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