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) { }
}
