public static int CreateOrd(OrderService os) { HotelAPIManagementEntities hm = new HotelAPIManagementEntities(); os.Total = 0; hm.OrderServices.Add(os); hm.SaveChanges(); return(os.IDOrd); }
public static int CreateCus(Customer cus) { HotelAPIManagementEntities hm = new HotelAPIManagementEntities(); cus.DayCreateCus = DateTime.Now; hm.Customers.Add(cus); hm.SaveChanges(); return(cus.IDCus); }
public static bool CreateHisBook(HistoryBooking hb) { HotelAPIManagementEntities hm = new HotelAPIManagementEntities(); hm.HistoryBookings.Add(hb); if (hm.SaveChanges() > 0) { return(true); } return(false); }
public static bool CreateCateService(CategoryService cs) { HotelAPIManagementEntities hm = new HotelAPIManagementEntities(); hm.CategoryServices.Add(cs); if (hm.SaveChanges() > 0) { return(true); } return(false); }
public static bool CreateCateRoom(CategoryRoom cr) { HotelAPIManagementEntities hm = new HotelAPIManagementEntities(); hm.CategoryRooms.Add(cr); if (hm.SaveChanges() > 0) { return(true); } return(false); }
public static bool CreateRoom(Room r) { HotelAPIManagementEntities hm = new HotelAPIManagementEntities(); r.Empty = true; hm.Rooms.Add(r); if (hm.SaveChanges() > 0) { return(true); } return(false); }
public static bool ReadBookingNew(int id) { HotelAPIManagementEntities hm = new HotelAPIManagementEntities(); var item = hm.Bookings.SingleOrDefault(s => s.IDBooking == id); item.NewBooking = false; if (hm.SaveChanges() > 0) { return(true); } return(false); }
public static bool CreateRB(RoomBooking rb) { HotelAPIManagementEntities hm = new HotelAPIManagementEntities(); hm.RoomBookings.Add(rb); if (hm.SaveChanges() > 0) { RoomDAO.UpdateRoomEmpty(rb.IDRoom); return(true); } return(false); }
public static bool UpdateCateService(CategoryService cs) { HotelAPIManagementEntities hm = new HotelAPIManagementEntities(); var item = hm.CategoryServices.SingleOrDefault(s => s.IDCateSer == cs.IDCateSer); item.NameCateSer = cs.NameCateSer; if (hm.SaveChanges() > 0) { return(true); } return(false); }
public static bool UpdateTotal(int idBook) { HotelAPIManagementEntities hm = new HotelAPIManagementEntities(); var item = hm.OrderServices.SingleOrDefault(s => s.IDBooking == idBook); item.Total = hm.OrderDetails.Where(w => w.OrderService.IDBooking == idBook).Sum(s => s.Amount); if (hm.SaveChanges() > 0) { return(true); } return(false); }
public static bool UpdatePayment(int idBooking, bool payment) { HotelAPIManagementEntities hm = new HotelAPIManagementEntities(); var item = hm.OrderServices.SingleOrDefault(s => s.IDBooking == idBooking); item.Payment = payment; if (hm.SaveChanges() > 0) { return(true); } return(false); }
public static bool UpdateRoom(Room r) { HotelAPIManagementEntities hm = new HotelAPIManagementEntities(); var item = hm.Rooms.SingleOrDefault(s => s.IDRoom == r.IDRoom); item.NameRoom = r.NameRoom; item.IDCateRoom = r.IDCateRoom; if (hm.SaveChanges() > 0) { return(true); } return(false); }
public static bool UpdateCateRoom(CategoryRoom cr) { HotelAPIManagementEntities hm = new HotelAPIManagementEntities(); var item = hm.CategoryRooms.SingleOrDefault(s => s.IDCateRoom == cr.IDCateRoom); item.NameCateRoom = cr.NameCateRoom; item.PriceCateRoom = cr.PriceCateRoom; if (hm.SaveChanges() > 0) { return(true); } return(false); }
public static bool UpdateService(Service s) { HotelAPIManagementEntities hm = new HotelAPIManagementEntities(); var item = hm.Services.SingleOrDefault(s1 => s1.IDService == s.IDService); item.NameService = s.NameService; item.PriceService = s.PriceService; item.IDCateSer = s.IDCateSer; if (hm.SaveChanges() > 0) { return(true); } return(false); }
public static bool CreateBooking(Booking b) { HotelAPIManagementEntities hm = new HotelAPIManagementEntities(); b.NewBooking = true; b.DayCreateBooking = DateTime.Now; hm.Bookings.Add(b); if (hm.SaveChanges() > 0) { var his = new HistoryBooking { IDBook = b.IDBooking, NameHisBook = "Đặt phòng thành công(CBS)", DayCreateHisBook = b.DayCreateBooking }; HistoryBookingDAO.CreateHisBook(his); return(true); } return(false); }
public static bool DelCateService(int id) { HotelAPIManagementEntities hm = new HotelAPIManagementEntities(); try { hm.CategoryServices.Remove(hm.CategoryServices.Find(id)); if (hm.SaveChanges() > 0) { return(true); } } catch (Exception) { return(false); } return(false); }
public static bool UpdateRoomEmpty(int id) { HotelAPIManagementEntities hm = new HotelAPIManagementEntities(); var item = hm.Rooms.SingleOrDefault(s => s.IDRoom == id); if (item.Empty == true) { item.Empty = false; } else { item.Empty = true; } if (hm.SaveChanges() > 0) { return(true); } return(false); }
public static bool UpdateCus(Customer cus, int idBooking) { HotelAPIManagementEntities hm = new HotelAPIManagementEntities(); var item = hm.Customers.SingleOrDefault(s => s.IDCus == cus.IDCus); item.NameCus = cus.NameCus; item.PhoneCus = cus.PhoneCus; item.AddressCus = cus.AddressCus; item.EmailCus = cus.EmailCus; if (hm.SaveChanges() > 0) { var his = new HistoryBooking { IDBook = idBooking, NameHisBook = "Cập nhật thông tin cá nhân", DayCreateHisBook = DateTime.Now }; HistoryBookingDAO.CreateHisBook(his); return(true); } return(false); }
public static bool UpdateBooking(Booking b) { HotelAPIManagementEntities hm = new HotelAPIManagementEntities(); var item = hm.Bookings.SingleOrDefault(s => s.IDBooking == b.IDBooking); item.NumberRoom = b.NumberRoom; item.DateIn = b.DateIn; item.DateOut = b.DateOut; item.DurationStay = b.DurationStay; item.IDCateRoom = b.IDCateRoom; if (hm.SaveChanges() > 0) { var his = new HistoryBooking { IDBook = b.IDBooking, NameHisBook = "Cập nhật thông tin phòng", DayCreateHisBook = DateTime.Now }; HistoryBookingDAO.CreateHisBook(his); return(true); } return(false); }
public static bool UpdateRB(RoomBooking rb, string reason) { HotelAPIManagementEntities hm = new HotelAPIManagementEntities(); var item = hm.RoomBookings.SingleOrDefault(s => s.IDRoomBook == rb.IDRoomBook); var idRoomOld = item.IDRoom; var roomOld = item.Room.NameRoom; var roomNew = hm.Rooms.SingleOrDefault(w => w.IDRoom == rb.IDRoom).NameRoom; item.IDRoom = rb.IDRoom; if (hm.SaveChanges() > 0) { var his = new HistoryBooking { IDBook = rb.IDBook, NameHisBook = "Đổi phòng thành công (" + roomOld + " -> " + roomNew + ": " + reason + ")", DayCreateHisBook = DateTime.Now }; HistoryBookingDAO.CreateHisBook(his); RoomDAO.UpdateRoomEmpty(idRoomOld); RoomDAO.UpdateRoomEmpty(rb.IDRoom); return(true); } return(false); }
public static void CreateOrdDetail(OrderDetail od, int idBook) { HotelAPIManagementEntities hm = new HotelAPIManagementEntities(); var rs = hm.OrderServices.Any(a => a.IDBooking == idBook); od.DayCreateOrdD = DateTime.Now; if (rs == false) { int idOrd = OrderServiceDAO.CreateOrd(new OrderService { IDBooking = idBook }); od.IDOrd = idOrd; } else { var ord = OrderServiceDAO.GetOrdService(idBook); od.IDOrd = ord.IDOrd; } hm.OrderDetails.Add(od); hm.SaveChanges(); OrderServiceDAO.UpdateTotal(idBook); }