private void txttransferroom_LostFocus(object sender, RoutedEventArgs e) { try { Checksin c = new Checksin(); DataTable dt = c.roomchange(); if (dt.Rows.Count == 0) { if (txtmainroom.Text == txttransferroom.Text) { txttransferroom.Text = ""; //MessageBox.Show("please enter the vacant room ?"); pop2.IsOpen = true; } else { } } else { txttransferroom.Text = ""; //MessageBox.Show("please enter the vacant room"); pop2.IsOpen = true; } } catch (Exception) { } }
private void txtmainroom_LostFocus(object sender, RoutedEventArgs e) { try { Checksin c = new Checksin(); c.ROOM_NO = txtmainroom.Text; DataTable dt = c.roomchange(); if (dt.Rows.Count == 0) { txtmainroom.Text = ""; pop3.IsOpen = true; //MessageBox.Show("Please Enter the Occupied Room"); } else { txtguestname.Text = dt.Rows[0]["FIRSTNAME"].ToString(); txtgueststatus.Text = dt.Rows[0]["STATUS"].ToString(); txtarrivaldate.Text = dt.Rows[0]["ARRIVAL_DATE"].ToString(); txtdeparturedate.Text = dt.Rows[0]["DEPARTURE_DATE"].ToString(); txtguestname1.Text = dt.Rows[0]["FIRSTNAME"].ToString(); txtgueststatus1.Text = dt.Rows[0]["STATUS"].ToString(); txtarrivaldate1.Text = dt.Rows[0]["ARRIVAL_DATE"].ToString(); txtdeparturedate1.Text = dt.Rows[0]["DEPARTURE_DATE"].ToString(); } } catch (Exception) { } }
private void txtswap_LostFocus(object sender, RoutedEventArgs e) { try { Checksin c = new Checksin(); c.ROOM_NO = txtswap.Text; c.roomchange(); txtguestname2.Text = c.FIRSTNAME; txtgueststatus2.Text = c.status; txtarrivaldate2.Text = Convert.ToDateTime(c.ARRIVAL_DATE).ToString(); txtdeparturedate2.Text = Convert.ToDateTime(c.DEPARTURE_DATE).ToString(); } catch (Exception) { } }
private void Save_Click(object sender, RoutedEventArgs e) { try { if (error != 0 || txtroomno.Text == "" || txtcontactno.Text == "") { //pop1.IsOpen = true; if (txtroomno.Text == "") { txtroomno.Text = ""; } if (txtcontactno.Text == "") { txtcontactno.Text = ""; } } else { INGUESTHOUSEINFOS IN = new INGUESTHOUSEINFOS(); Checksin ch = new Checksin(); IN.ROOM_NO = txtroomno.Text; IN.GUEST_NAME = txtname.Text; IN.COMPANY_NAME = txtcompanyname.Text; IN.Company_Gst = txtcompanygst.Text; IN.ARRIVAL_DATE = dt.Text; IN.ARRIVAL_TIME = txtarrivaltime.Text; IN.DEPARTURE_DATE = dt1.Text; IN.DEPARTURE_TIME = txtdeparturetime.Text; IN.CONTACT_NO = txtcontactno.Text; IN.EMAIL = txtemail.Text; IN.ID_TYPE = idproof.Text; IN.ID_DATA = txtproof.Text; //11/15/2017 dddd //IN.USER_NAME = login.u; IN.INSERT_BY = login.u; IN.INSERT_DATE = DateTime.Today; IN.CHARGED_TARRIF = Math.Round(Convert.ToDecimal(txttariff.Text), 2, MidpointRounding.AwayFromZero); ch.FETCH_TAX(txttariff.Text); IN.TAX = Math.Round(Convert.ToDecimal(ch.TAX), 2, MidpointRounding.AwayFromZero); string a1 = "Save", b1 = Convert.ToString(Save.Content); if (b1 == a1) { IN.INSERT(); IN.guestupdate(); IN.NightAuditUpdate(); //MessageBox.Show("Saved sucessfully"); // Save.Content = "Save"; insert.Text = "Data Inserted.!"; pop2.IsOpen = true; } string a = "Update", b = Convert.ToString(Save.Content); if (b == a) { IN.INSERT(); insert.Text = "Data Updated.!"; pop2.IsOpen = true; //MessageBox.Show("Updated sucessfully"); } IN.UPDTE(); CLEAR(); } } catch (Exception) { } }
private void Swap_Click(object sender, RoutedEventArgs e) { //try //{ if (error != 0 || (ENABLE.IsChecked == true && txtmainroom.Text == "") || (ENABLE.IsChecked == true && txttransferroom.Text == "") || (DISEBLE.IsChecked == true && txtmainroom.Text == "") || (DISEBLE.IsChecked == true && txtswap.Text == "")) { if (ENABLE.IsChecked == true) { if (txtmainroom.Text == "") { txtmainroom.Text = ""; } if (txttransferroom.Text == "") { txttransferroom.Text = ""; } } if (DISEBLE.IsChecked == true) { if (txtmainroom.Text == "") { txtmainroom.Text = ""; } if (txtswap.Text == "") { txtswap.Text = ""; } } } else { if (swap.Content.ToString() == "transfer") { //new code for Room Transfer ROOMCHANGE1 RM_T = new ROOMCHANGE1(); RM_T.MAINROOM = txtmainroom.Text; DataTable dt = RM_T.GetRoomDetails(); if (dt.Rows.Count > 0) { RM_T.ROOM_CHANGE = "Transfer"; RM_T.TRANSFERROOM = txttransferroom.Text; RM_T.FROM_GUESTNAME = txtguestname.Text; RM_T.FROM_GUESTSTATUS = txtgueststatus.Text; RM_T.RM_CHECKINID = dt.Rows[0]["CHECKIN_ID"].ToString(); RM_T.FROM_ARRIVALDATE = Convert.ToDateTime(txtarrivaldate.Text); RM_T.FROM_DEPARTUREDATE = Convert.ToDateTime(txtdeparturedate.Text); RM_T.TransferInsert(); RM_T.Rm_ChargedTariff = RM_T.GetTariff(); ch.FETCH_TAX(RM_T.Rm_ChargedTariff.ToString()); RM_T.Rm_GST = ch.TAX; RM_T.UpdateNightAudit(); RM_T.UpdateAdvance(); RM_T.UpdatePostCharges(); RM_T.UpdateDiscount(); RM_T.UpdatecheckinDetails(); RM_T.UpdateMRColor(); RM_T.UpdateTRColor(); } else { MessageBox.Show("This room is vacant"); } //old code for Room Transfer. //ROOMCHANGE1 RM = new ROOMCHANGE1(); //RM.MAINROOM = txtmainroom.Text; //RM.ROOM_CHANGE = "transfer"; //RM.TRANSFERROOM = txttransferroom.Text; //RM.FROM_GUESTNAME = txtguestname.Text; //RM.FROM_GUESTSTATUS = txtgueststatus.Text; //RM.FROM_ARRIVALDATE = Convert.ToDateTime(txtarrivaldate.Text); //RM.FROM_DEPARTUREDATE = Convert.ToDateTime(txtdeparturedate.Text); //RM.INSERT_BY = login.u; //RM.INSERT_DATE = DateTime.Today.Date; //RM.INSERT(); //Checksin c = new Checksin(); //c.ROOM_NO = txttransferroom.Text; //c.FIRSTNAME = txtguestname.Text; //c.ARRIVAL_DATE = Convert.ToDateTime(txtarrivaldate.Text.ToString()); //c.DEPARTURE_DATE = Convert.ToDateTime(txtdeparturedate.Text.ToString()); /////c.INSERT(); //RM.insertcheckin(); //RM.updatemainroom(); //RM.INSERTDATENIGHT(); //DataTable d = RM.count(); //if (DateTime.Today.Date > ROOMCHANGE1.c) //{ // if (d.Rows.Count == 0) // { // cunt1 = decimal.Parse("0.00"); // } // else // { // cunt1 = Convert.ToDecimal(d.Rows[0]["ROOM_TARRIF"]); // } //} //else //{ // cunt1 = decimal.Parse("0.00"); //} //RM.night(); //RM.night1(); //RM.UPDATECOLOR(); CLEARS(); } if (swap.Content.ToString() == "swap") { s1 = txtguestname1.Text; s2 = txtgueststatus1.Text; s3 = txtarrivaldate1.Text; s4 = txtdeparturedate1.Text; t1 = txtguestname2.Text; t2 = txtgueststatus2.Text; t3 = txtarrivaldate2.Text; t4 = txtdeparturedate2.Text; txtguestname1.Text = t1; txtgueststatus1.Text = t2; txtarrivaldate1.Text = t3; txtdeparturedate1.Text = t4; txtguestname2.Text = s1; txtgueststatus2.Text = s2; txtdeparturedate2.Text = s3; txtarrivaldate2.Text = s4; ROOMCHANGE1 RM = new ROOMCHANGE1(); RM.MAINROOM = txtmainroom.Text; RM.ROOM_CHANGE = "swap"; RM.TRANSFERROOM = txtswap.Text; RM.FROM_GUESTNAME = txtguestname.Text; RM.FROM_GUESTSTATUS = txtgueststatus.Text; RM.FROM_ARRIVALDATE = Convert.ToDateTime(txtarrivaldate.Text); RM.FROM_DEPARTUREDATE = Convert.ToDateTime(txtdeparturedate.Text); RM.TO_GUESTNAME = txtguestname1.Text; RM.TO_GUESTSTATUS = txtgueststatus1.Text; RM.TO_ARRIVALDATE = Convert.ToDateTime(txtarrivaldate1.Text); RM.TO_DEPARTUREDATE = Convert.ToDateTime(txtdeparturedate1.Text); RM.INSERT_BY = login.u; RM.INSERT_DATE = DateTime.Today; RM.swapinsert(); Checksin c = new Checksin(); c.ROOM_NO = txtmainroom.Text; RM.Swapupdate(); txtguestname2.Text = c.FIRSTNAME; txtarrivaldate2.Text = c.ARRIVAL_DATE.ToString(); txtdeparturedate2.Text = c.DEPARTURE_DATE.ToString(); txtgueststatus2.Text = c.status; c.ROOM_NO = txtswap.Text; RM.Swapupdate1(); txtguestname1.Text = c.FIRSTNAME; txtarrivaldate1.Text = c.ARRIVAL_DATE.ToString(); txtdeparturedate1.Text = c.DEPARTURE_DATE.ToString(); txtgueststatus1.Text = c.status; CLEARS(); } } //} //catch (Exception) { } }