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 CheckHisBook(int idBook, string value)
{
HotelAPIManagementEntities hm = new HotelAPIManagementEntities();
var rs = hm.HistoryBookings.SingleOrDefault(a => a.IDBook == idBook && a.NameHisBook.Contains(value));
if (rs == null)
{
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 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 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 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 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 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 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 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 CheckRoomBook(int idBook)
{
HotelAPIManagementEntities hm = new HotelAPIManagementEntities();
var book = hm.Bookings.SingleOrDefault(w => w.IDBooking == idBook);
var numberBook = book.NumberRoom;
var numberRoomBook = RoomBookingDAO.GetRB(idBook).Count();
if (numberBook == numberRoomBook)
{
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);
}
public static IEnumerable <OrderDetail> GetAllOrdDetail(int idBook)
{
HotelAPIManagementEntities hm = new HotelAPIManagementEntities();
return(hm.OrderDetails.Where(w => w.OrderService.IDBooking == idBook).ToList());
}
public static IEnumerable <CategoryService> GetCateServiceCBB(int id)
{
HotelAPIManagementEntities hm = new HotelAPIManagementEntities();
return(hm.CategoryServices.Where(w => w.IDCateSer != id).ToList());
}
public static IEnumerable <RoomBooking> GetRB(int id)
{
HotelAPIManagementEntities hm = new HotelAPIManagementEntities();
return(hm.RoomBookings.Where(w => w.IDBook == id).ToList());
}
public static CategoryService GetCateServiceByID(int id)
{
HotelAPIManagementEntities hm = new HotelAPIManagementEntities();
return(hm.CategoryServices.Find(id));
}
public static IEnumerable <CategoryService> GetAllCateService()
{
HotelAPIManagementEntities hm = new HotelAPIManagementEntities();
return(hm.CategoryServices.ToList());
}
public static RoomBooking RoomChange(int id)
{
HotelAPIManagementEntities hm = new HotelAPIManagementEntities();
return(hm.RoomBookings.Find(id));
}
public static IEnumerable <HistoryBooking> GetHisBookByID(int id)
{
HotelAPIManagementEntities hm = new HotelAPIManagementEntities();
return(hm.HistoryBookings.Where(w => w.IDBook == id).ToList());
}
