private void tbSearch_KeyUp(object sender, KeyEventArgs e)
{
HOTELMANAGEMENTEntities hm = new HOTELMANAGEMENTEntities();
var filter = hm.ROOMs.Where(r => r.NAME.Contains(tbSearch.Text)).ToList();
dataRoom.ItemsSource = filter;
}
private void tbSearch_KeyUp(object sender, KeyEventArgs e)
{
HOTELMANAGEMENTEntities hm = new HOTELMANAGEMENTEntities();
var filter = hm.CUSTOMERs.Where(r => r.NAME.Contains(tbSearch.Text) || r.IDCARD.Contains(tbSearch.Text) || r.ADDRESS.Contains(tbSearch.Text)).ToList();
dataCustomer.ItemsSource = filter;
}
public List <view.ServiceView> GetService()
{
HOTELMANAGEMENTEntities hm = new HOTELMANAGEMENTEntities();
var q = hm.SERVICEs.Select(d => new view.ServiceView {
NAME = d.NAME, TYPE = d.TYPE, PRICE = (d.PRICE ?? 0), STATUS = d.STATUS
}).ToList();
return(q);
}
public List <Model.view.BookingView> GetBooking()
{
HOTELMANAGEMENTEntities hm = new HOTELMANAGEMENTEntities();
var q = hm.BOOKINGs.Where(b => b.STATUS == true).Join(hm.ROOMs, b => b.ROOMID, r => r.ID, (b, r) => new { Room = r, Booking = b }).Join(hm.CUSTOMERs, b => b.Booking.CUSID, c => c.ID, (b, c) => new { b.Booking, b.Room, Customer = c }).Select(s => new Model.view.BookingView {
RoomName = s.Room.NAME, CusName = s.Customer.NAME, CusPhoneNumber = s.Customer.PHONENUMBER, CheckInTime = s.Booking.CHECKINTIME, CusID = s.Customer.ID, RoomID = s.Room.ID
}).ToList();
return(q);
}
public List <view.BillView> GetBill(int roomid)
{
HOTELMANAGEMENTEntities hm = new HOTELMANAGEMENTEntities();
var q = hm.ORDERDETAILs.Join(hm.SRVORDERs.Where(srvorder => srvorder.PAYMENTSTATUS == false && srvorder.ROOMID == roomid), odetail => odetail.ORDERID, srvorder => srvorder.ID, (odetail, srvorder) => new { OrderDetail = odetail, SrvOrder = srvorder }).Join(hm.SERVICEs, x => x.SrvOrder.SRVID, y => y.ID, (x, y) => new { x.SrvOrder, x.OrderDetail, Service = y }).Select(s => new Model.view.BillView {
NAME = s.Service.NAME, QUANTITY = s.SrvOrder.QUANTITY ?? 0, PRICE = s.OrderDetail.PRICE ?? 0, TOTAL = s.SrvOrder.QUANTITY * s.OrderDetail.PRICE ?? 0, DATE = s.OrderDetail.date, NOTE = s.SrvOrder.NOTE
}).ToList();
return(q);
}
public List <view.RoomView> GetRoom()
{
HOTELMANAGEMENTEntities hm = new HOTELMANAGEMENTEntities();
var q = hm.ROOMs.Select(d => new view.RoomView {
NAME = d.NAME, TYPE = d.TYPE, CATEGORY = d.CATEGORY, PRICE = (d.PRICE ?? 0), NOTE = d.NOTE, STATUS = d.STATUS
}).ToList();
return(q);
}
public List <Model.view.EmployeeView> GetEmployee()
{
HOTELMANAGEMENTEntities hm = new HOTELMANAGEMENTEntities();
var q = hm.EMPLOYEEs.Select(s => new Model.view.EmployeeView {
ID = s.ID, IDCARD = s.IDCARD, NAME = s.NAME, AGE = s.AGE ?? 0, EMAIL = s.EMAIL, PHONENUMBER = s.PHONENUMBER, ADDRESS = s.ADDRESS, ACCOUNTTYPE = s.ACCOUNTTYPE
}).ToList();
return(q);
}
private void tbSearch_KeyUp(object sender, KeyEventArgs e)
{
HOTELMANAGEMENTEntities hm = new HOTELMANAGEMENTEntities();
var filter = hm.BOOKINGs.Where(b => b.STATUS == true).Join(hm.ROOMs.Where(r => r.NAME.Contains(tbSearch.Text)), b => b.ROOMID, r => r.ID, (b, r) => new { Room = r, Booking = b }).Join(hm.CUSTOMERs, b => b.Booking.CUSID, c => c.ID, (b, c) => new { b.Booking, b.Room, Customer = c }).Select(s => new Model.view.BookingView {
RoomName = s.Room.NAME, CusName = s.Customer.NAME, CusPhoneNumber = s.Customer.PHONENUMBER, CheckInTime = s.Booking.CHECKINTIME
}).ToList();
dataBooking.ItemsSource = filter;
}
public List <Model.view.CustomerView> GetCustomer()
{
HOTELMANAGEMENTEntities hm = new HOTELMANAGEMENTEntities();
var q = hm.CUSTOMERs.Select(s => new Model.view.CustomerView {
ID = s.ID, IDCARD = s.IDCARD, NAME = s.NAME, ADDRESS = s.ADDRESS, AGE = (s.AGE ?? 0), PHONENUMBER = s.PHONENUMBER
}).ToList();
return(q);
}
public bool Add(entity.ROOM r)
{
try
{
HOTELMANAGEMENTEntities hm = new HOTELMANAGEMENTEntities();
hm.ROOMs.Add(r);
hm.SaveChanges();
return(true);
}
catch (Exception ex)
{
ex.ToString();
return(false);
}
}
public bool Add(Model.entity.SERVICE s)
{
HOTELMANAGEMENTEntities hm = new HOTELMANAGEMENTEntities();
try
{
hm.SERVICEs.Add(s);
hm.SaveChanges();
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex.InnerException.Message);
return(false);
}
}
public bool Add(Model.entity.EMPLOYEE e)
{
HOTELMANAGEMENTEntities hm = new HOTELMANAGEMENTEntities();
try
{
hm.EMPLOYEEs.Add(e);
hm.SaveChanges();
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(false);
}
}
