TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
mohammed shamsheer
NA
394
143.9k
tabcycling is not working after datagridinsertin
Dec 24 2014 4:03 AM
question:
tabcycling is not working after datagridinsertin()
the processflow is following:
select guestdetails-->Employee details-->Details to grid-->Advance-->Discount.
tab cycling is moving nicely by default. but if we cycle the tab after gridinsertion it stay on hours textbox(data for datagridinsert)
code :
private void txtnoofPer_KeyUp(object sender, KeyEventArgs e)
{
try
{
if (e.KeyCode == Keys.Enter)
{
ConfCheckinDetailsToGrid();
}
}
catch (Exception ex) { }
}
--------------------------
public void ConfCheckinDetailsToGrid()
{
if (txtTotalHours.Text != "0")
{
string roomID = Convert.ToString(cmbroomno.SelectedValue);
object[,] ParamArray = new object[,] { { "@RoomID", roomID } };
DataSet ds = new DataSet();
ds = DB.ExecuteQuery_SP("SelectRoomDetailsForGridByID", ParamArray);
if (ds.Tables.Count > 0)
{
int row = 0;
row = dgvcheckin1.FirstFreeRow;
//dgvcheckin1.DataSource = null;
dgvcheckin1.Rows.Add();
row = dgvcheckin1.Rows.Count - 1;
dgvcheckin1.Rows[row].Cells["RoomNo"].Value = ds.Tables[0].Rows[0]["RoomNo"].ToString();
dgvcheckin1["RoomNo", row].Value = ds.Tables[0].Rows[0]["RoomNo"].ToString();
dgvcheckin1["RoomCategoryName", row].Value = ds.Tables[0].Rows[0]["RoomCategoryName"].ToString();
dgvcheckin1["RoomCapacity", row].Value = ds.Tables[0].Rows[0]["RoomCapacity"].ToString();
dgvcheckin1["NoofPerson", row].Value = txtTotalHours.Text;
dgvcheckin1["Hours", row].Value = txtTotalHours.Text;
dgvcheckin1["InTime", row].Value = dtpchkintime.Text;
dgvcheckin1["CheckInDate", row].Value = dtpcheckin.Text;
dgvcheckin1["Rents", row].Value = ds.Tables[0].Rows[0]["PerdayRent"].ToString();
dgvcheckin1["TaxAmount", row].Value = ds.Tables[0].Rows[0]["TaxAmount"].ToString();
dgvcheckin1["CheckOutday", row].Value = dtpcheckOutdate.Text;
dgvcheckin1["CheckOutTime", row].Value = dtpouttime.Text;
dgvcheckin1["Roomid", row].Value = cmbroomno.SelectedValue;
if (Convert.ToInt32(txtTotalHours.Text) > 1)
{
double NetTotal = ((Convert.ToDouble(ds.Tables[0].Rows[0]["PerdayRent"]) + Convert.ToDouble(ds.Tables[0].Rows[0]["TaxAmount"])) + ((PolosysHMS.General.Classes.Settings.InventorySettings.ExtraHoursCost) * (Convert.ToDouble(txtTotalHours.Text) - 1)));
dgvcheckin1.Rows[row].Cells["NetTotal"].Value = NetTotal.ToString();
}
//dgvcheckin["RoomId",row].Value = ds.Tables[0].Rows[0]["RoomID"].ToString();
RoomCap = Convert.ToInt32(dgvcheckin1.Rows[row].Cells["RoomCapacity"].Value);
rent = Convert.ToDouble(dgvcheckin1.Rows[row].Cells["Rents"].Value.ToString());
tax = Convert.ToDouble(dgvcheckin1.Rows[row].Cells["TaxAmount"].Value.ToString());
No_Of_Hours = Convert.ToInt32(dgvcheckin1.Rows[row].Cells["Hours"].Value);
//if (txtnoofPer.Text == "")
//{
// txtnoofPer.Text = "0";
//}
No_of_Person = Convert.ToInt32(dgvcheckin1.Rows[row].Cells["NoofPerson"].Value);
//if (No_of_Person > RoomCap)
//{
// Ext_Person = No_of_Person - RoomCap;
// add_amt_forRoom = Ext_Person * 50;
// txttotal.Text = Convert.ToString((rent + tax + add_amt_forRoom) * No_Of_days);
// total += Convert.ToDouble(txttotal.Text);
// txttotal.Text = Convert.ToString(total);
// txtbalance.Text = Convert.ToString(total);
//}
//else
//{
double NetTotalCal = Convert.ToDouble(dgvcheckin1.Rows[row].Cells["NetTotal"].Value);
double totatl = +NetTotalCal;
txttotal.Text = totatl.ToString();
//txttotal.Text = Convert.ToString((rent + tax) * No_Of_Hours);
// total += Convert.ToDouble(txttotal.Text);
// txttotal.Text = Convert.ToString(total);
txtbalance.Text = Convert.ToString(totatl);
txtBillingAmount.Text = Convert.ToString(totatl);
Bal(txtbalance, txttotal, txtadvance, txtDiscount);
}
}
//int Roomno_Bookingprocess = Convert.ToInt32(cmbroomno);
//objGeneralclass.UpdateOnBookingProcess(Convert.ToInt32(cmbroomno.SelectedValue), true);
ClearInputGridField();
}
-------------------------------------------
tested solution :
1. I checked any focus on hourstextbox.
2. test with out updateBookingprocess()function
3. test with out ClearInputGridfield()
Reply
Answers (
0
)
Duplicate datagridview columns creating
filtering records from 1st combobox to 2nd combobox and 2nd