public void CheckIn()
{
if (lstCheckInCheckOut.SelectedItems != null)
{
ListViewItem item = lstCheckInCheckOut.SelectedItems[0];
CheckInCheckOut info = new CheckInCheckOut();
info.floor = item.SubItems[0].Text;
info.roomnumber = item.SubItems[1].Text;
room_number = item.SubItems[1].Text;
addCheckDate();
info.type = item.SubItems[2].Text;
info.price = item.SubItems[3].Text;
info.checkin = checkin;
info.checkout = checkout;
info.available = "NO";
double Uprice = double.Parse(item.SubItems[3].Text);
info.total = Uprice * diff + "$";
info.connect();
info.update();
info.connect();
info.addToCustomer();
}
ReadAllData();
//MessageBox.Show("Done");
}
public void CheckOut()
{
try
{
if (lstCheckInCheckOut.SelectedItems != null)
{
ListViewItem item = lstCheckInCheckOut.SelectedItems[0];
CheckInCheckOut info = new CheckInCheckOut();
info.roomnumber = item.SubItems[1].Text;
info.available = "YES";
info.connect();
info.update();
}
}
catch (Exception) { }
ReadAllData();
}
public void ReadAllData()
{
lstCheckInCheckOut.Items.Clear();
SqlConnection con = new SqlConnection("Data Source=Rofat;Initial Catalog=hotel;Integrated Security=True");
con.Open();
SqlCommand cm = new SqlCommand();
cm.Connection = con;
cm.CommandText = "SELECT tblRoom.floor, tblCheckinout.roomnum, tblRoom.type, tblRoom.price, tblCheckinout.available FROM tblRoom INNER JOIN tblCheckinout ON tblRoom.roomnum=tblCheckinout.roomnum";
SqlDataReader dr = cm.ExecuteReader();
while (dr.Read())
{
CheckInCheckOut info = new CheckInCheckOut();
info.floor = dr[0].ToString();
info.roomnumber = dr[1].ToString();
info.type = dr[2].ToString();
info.price = dr[3].ToString();
info.available = dr[4].ToString();
info.AddToList(lstCheckInCheckOut);
}
}
