public void GetRoomView()
{
Model.dao.RoomDao r = new Model.dao.RoomDao();
var q = r.GetRoom();
dataRoom.ItemsSource = q;
}
private void CheckBill(object sender, RoutedEventArgs e)
{
if (dataRoom.SelectedItems.Count > 0)
{
Model.view.RoomView row = (Model.view.RoomView)dataRoom.SelectedItem;
Model.dao.RoomDao RD = new Model.dao.RoomDao();
Frm.CheckBill CB = new Frm.CheckBill(RD.GetID(row.NAME));
CB.ShowDialog();
GetRoomView();
}
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
String note = tbNote.Text;
Model.dao.RoomDao rd = new Model.dao.RoomDao();
if (rd.EditNote(note, RoomName))
{
MessageBox.Show("Successfully Saved");
this.Close();
}
else
{
MessageBox.Show("Not Saved");
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (tbQuantity.Text != "")
{
Model.dao.RoomDao RD = new Model.dao.RoomDao();
Model.dao.CustomerDao CD = new Model.dao.CustomerDao();
Model.dao.ServiceDao SD = new Model.dao.ServiceDao();
Model.dao.SrvOrderDao SOD = new Model.dao.SrvOrderDao();
Model.dao.OrderDetailDao ODD = new Model.dao.OrderDetailDao();
Model.entity.SRVORDER order = new Model.entity.SRVORDER();
Model.entity.ORDERDETAIL orderdetail = new Model.entity.ORDERDETAIL();
order.CUSID = CD.GetID(RD.GetIDCard(RoomName));
order.SRVID = SD.GetID(boxService.Text);
order.ROOMID = RD.GetID(RoomName);
order.QUANTITY = int.Parse(tbQuantity.Text);
order.NOTE = tbNote.Text;
order.PAYMENTSTATUS = false;
if (SOD.Add(order))
{
DateTime now = DateTime.Now;
orderdetail.ORDERID = SOD.GetInsertedSrvOrderId();
orderdetail.DISCOUNT = 0; //// warning
orderdetail.EMPID = empid;
orderdetail.date = now.ToString("dd/MM/yyyy HH:mm:ss");
orderdetail.PRICE = SD.GetPrice(boxService.Text);
if (ODD.Add(orderdetail))
{
MessageBox.Show("Order Successfully !");
this.Close();
}
}
else
{
MessageBox.Show("Failed To Order !");
}
}
else
{
MessageBox.Show("Please Enter Quantity!");
}
}
private void DisableRoom(object sender, RoutedEventArgs e)
{
if (dataRoom.SelectedItems.Count > 0)
{
Model.view.RoomView row = (Model.view.RoomView)dataRoom.SelectedItem;
Model.dao.RoomDao RD = new Model.dao.RoomDao();
if (DisRoom.Header.ToString() == "Disable Room")
{
RD.DisableRoom(1, row.NAME);
}
else
{
RD.DisableRoom(2, row.NAME);
}
GetRoomView();
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (tbPrice.Text != "")
{
Model.entity.ROOM r = new Model.entity.ROOM();
r.NAME = tbName.Text;
r.PRICE = Double.Parse(tbPrice.Text);
r.TYPE = boxType.Text;
r.CATEGORY = boxCate.Text;
Model.dao.RoomDao rd = new Model.dao.RoomDao();
rd.Edit(r);
this.Close();
}
else
{
MessageBox.Show("Please enter price!");
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
Model.dao.RoomDao RD = new Model.dao.RoomDao();
String RoomName = RD.GetRoomName(RoomID);
RD.DisableRoom(2, RoomName);
RD.EditNote("", RoomName);
Model.dao.SrvOrderDao SOD = new Model.dao.SrvOrderDao();
if (SOD.ChangePaymentStatus(RoomID))
{
MessageBox.Show("Check Out Sucessfully !");
this.Close();
}
else
{
MessageBox.Show("Failed To Check Out !");
}
}
private void UnBooking(object sender, RoutedEventArgs e)
{
if (dataBooking.SelectedItems.Count > 0)
{
Model.dao.BookingDao BD = new Model.dao.BookingDao();
Model.dao.RoomDao RD = new Model.dao.RoomDao();
Model.view.BookingView row = (Model.view.BookingView)dataBooking.SelectedItem;
if (BD.ChangeBookingStatus(row.CusID, row.RoomID))
{
RD.DisableRoom(2, row.RoomName);
MessageBox.Show("Unbook Successfully !");
}
else
{
MessageBox.Show("Failed to Unbook !");
}
GetBookingView();
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
Model.dao.RoomDao rd = new Model.dao.RoomDao();
Model.entity.ROOM r = new Model.entity.ROOM();
r.NAME = tbName.Text;
if (tbName.Text != "")
{
if (!rd.CheckRoomName(r.NAME))
{
if (tbPrice.Text != "")
{
r.PRICE = Double.Parse(tbPrice.Text);
r.TYPE = boxType.Text;
r.NOTE = "";
r.CATEGORY = boxCate.Text;
r.STATUS = "Empty";
if (rd.Add(r))
{
MessageBox.Show("Successfully Saved");
}
else
{
MessageBox.Show("Not Saved");
}
this.Close();
}
else
{
MessageBox.Show("Please Enter Price!");
}
}
else
{
MessageBox.Show("Room's Name Is Already Exists");
}
}
else
{
MessageBox.Show("Please Enter Room Name!");
}
}
public CheckIn(String Name, String status, int id)
{
empid = id;
InitializeComponent();
RoomName = Name;
Status = status;
if (Status == "Booked")
{
Model.dao.RoomDao RD = new Model.dao.RoomDao();
Model.dao.CustomerDao CD = new Model.dao.CustomerDao();
String [] info = RD.GetIDCardWithCheckOut(RoomName);
tbIDCard.Text = info[0];
Model.entity.CUSTOMER c = CD.GetCustomerInfo(tbIDCard.Text);
tbCusName.Text = c.NAME;
tbCusAge.Text = c.AGE.ToString();
tbCusPhone.Text = c.PHONENUMBER;
tbCusAddress.Text = c.ADDRESS;
dpCheckOut.Text = info[1];
tbIDCard.IsReadOnly = true;
tbIDCard.IsEnabled = false;
}
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
Model.dao.RoomDao RD = new Model.dao.RoomDao();
Model.dao.CustomerDao CD = new Model.dao.CustomerDao();
Model.dao.BookingDao BD = new Model.dao.BookingDao();
if (CD.CheckCus(tbIDCard.Text))
{
if (CheckEmpty())
{
Model.entity.BOOKING b = new Model.entity.BOOKING();
b.CUSID = CD.GetID(tbIDCard.Text);
b.EMPID = empid;
b.ROOMID = RD.GetID(RoomName);
b.CHECKINTIME = dpCheckIn.Text;
b.CHECKOUTTIME = dpCheckOut.Text;
DateTime now = DateTime.Now;
b.BOOKINGDATE = now.ToString("dd/MM/yyyy HH:mm:ss");
b.STATUS = true;
if (BD.Add(b))
{
MessageBox.Show("Booking Succesfully !");
RD.DisableRoom(3, RoomName);
this.Close();
}
else
{
MessageBox.Show("Failed To Book");
}
}
}
else
{
if (CheckEmpty())
{
Model.entity.CUSTOMER c = new Model.entity.CUSTOMER();
c.IDCARD = tbIDCard.Text;
c.NAME = tbCusName.Text;
c.AGE = int.Parse(tbCusAge.Text);
c.PHONENUMBER = tbCusPhone.Text;
c.ADDRESS = tbCusAddress.Text;
if (CD.Add(c))
{
Model.entity.BOOKING b = new Model.entity.BOOKING();
b.CUSID = CD.GetID(tbIDCard.Text);
b.EMPID = empid;
b.ROOMID = RD.GetID(RoomName);
b.CHECKINTIME = dpCheckIn.Text;
b.CHECKOUTTIME = dpCheckOut.Text;
DateTime now = DateTime.Now;
b.BOOKINGDATE = now.ToString("dd/MM/yyyy HH:mm:ss");
b.STATUS = false;
if (BD.Add(b))
{
MessageBox.Show("Booking Succesfully !");
RD.DisableRoom(3, RoomName);
this.Close();
}
else
{
MessageBox.Show("Failed To Book");
}
}
else
{
MessageBox.Show("Not Saved!");
}
}
}
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
Model.dao.ServiceDao sd = new Model.dao.ServiceDao();
Model.dao.RoomDao RD = new Model.dao.RoomDao();
Model.dao.CustomerDao CD = new Model.dao.CustomerDao();
Model.dao.OrderDetailDao odd = new Model.dao.OrderDetailDao();
Model.dao.SrvOrderDao sod = new Model.dao.SrvOrderDao();
if (CD.CheckCus(tbIDCard.Text))
{
if (CheckEmpty())
{
Model.entity.SRVORDER order = new Model.entity.SRVORDER();
order.CUSID = CD.GetID(tbIDCard.Text);
order.ROOMID = RD.GetID(RoomName);
if (sd.CheckServiceName(2, RoomName))
{
order.SRVID = sd.GetServiceId(RoomName);
}
else
{
Model.entity.SERVICE s = new Model.entity.SERVICE();
s.NAME = RD.GetSrvName(RoomName);
s.TYPE = "Room";
s.PRICE = RD.GetPrice(RoomName);
s.STATUS = "Active";
if (sd.Add(s))
{
order.SRVID = sd.GetServiceId(RoomName);
}
}
order.QUANTITY = 1;
order.PAYMENTSTATUS = false;
if (sod.Add(order))
{
DateTime now = DateTime.Now;
Model.entity.ORDERDETAIL orderdetail = new Model.entity.ORDERDETAIL();
orderdetail.date = now.ToString("dd/MM/yyyy HH:mm:ss");
orderdetail.DISCOUNT = 0;
orderdetail.EMPID = empid;
orderdetail.PRICE = RD.GetPrice(RoomName);
orderdetail.ORDERID = sod.GetInsertedSrvOrderId();
if (odd.Add(orderdetail))
{
if (Status == "Booked")
{
Model.dao.BookingDao BD = new Model.dao.BookingDao();
BD.ChangeBookingStatus(CD.GetID(tbIDCard.Text), RD.GetID(RoomName));
}
RD.DisableRoom(4, RoomName);
MessageBox.Show("Check In Successfully!");
this.Close();
}
else
{
MessageBox.Show("Failed To Check In!");
}
}
else
{
MessageBox.Show("Failed To Check In!");
}
}
}
else
{
if (CheckEmpty())
{
Model.entity.CUSTOMER c = new Model.entity.CUSTOMER();
c.IDCARD = tbIDCard.Text;
c.NAME = tbCusName.Text;
c.AGE = int.Parse(tbCusAge.Text);
c.PHONENUMBER = tbCusPhone.Text;
c.ADDRESS = tbCusAddress.Text;
if (CD.Add(c))
{
Model.entity.SRVORDER order = new Model.entity.SRVORDER();
order.CUSID = CD.GetID(tbIDCard.Text);
order.ROOMID = RD.GetID(RoomName);
if (sd.CheckServiceName(2, RoomName))
{
order.SRVID = sd.GetServiceId(RoomName);
}
else
{
Model.entity.SERVICE s = new Model.entity.SERVICE();
s.NAME = RD.GetSrvName(RoomName);
s.TYPE = "Room";
s.PRICE = RD.GetPrice(RoomName);
s.STATUS = "Active";
if (sd.Add(s))
{
order.SRVID = sd.GetServiceId(RoomName);
}
}
order.QUANTITY = 1;
order.PAYMENTSTATUS = false;
if (sod.Add(order))
{
DateTime now = DateTime.Now;
Model.entity.ORDERDETAIL orderdetail = new Model.entity.ORDERDETAIL();
orderdetail.date = now.ToString("dd/MM/yyyy HH:mm:ss");
orderdetail.DISCOUNT = 0;
orderdetail.EMPID = empid;
orderdetail.PRICE = RD.GetPrice(RoomName);
orderdetail.ORDERID = sod.GetInsertedSrvOrderId();
if (odd.Add(orderdetail))
{
RD.DisableRoom(4, RoomName);
MessageBox.Show("Check In Successfully!");
this.Close();
}
else
{
MessageBox.Show("Failed To Check In!");
}
}
else
{
MessageBox.Show("Failed To Check In!");
}
}
else
{
MessageBox.Show("Failed To Add Customer!");
}
}
}
}
