public void GetBookingView()
{
Model.dao.BookingDao BD = new Model.dao.BookingDao();
var q = BD.GetBooking();
dataBooking.ItemsSource = q;
}
private void Button_Click(object sender, RoutedEventArgs e)
{
Model.dao.BookingDao BD = new Model.dao.BookingDao();
Time = dpTime.Text;
if (BD.ChangeBookingTime(Time, CusID, RoomID))
{
MessageBox.Show("Change Date Successfully !");
this.Close();
}
else
{
MessageBox.Show("Failed to Save");
}
}
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_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!");
}
}
}
}
