//Author: Tqtrung
public List<BookingRoomsEN> GetListRoomsCheckOutPlanInDayAndH(DateTime Checktime, int Status)
{
try
{
DateTime Checktime2 = Checktime.AddDays(1);
RoomsBO aRoomsBO = new RoomsBO();
List<BookingRooms> aListTemp = aDatabaseDA.BookingRooms.Where(b => b.Status == Status).Where(b => b.CheckOutPlan > Checktime && b.CheckOutPlan < Checktime2).ToList();
List<BookingRooms> alistTemp2 = aDatabaseDA.BookingRooms.Where(c => c.Status == Status).Where(b => b.CheckOutPlan < Checktime).ToList();
List<BookingRoomsEN> aListBookingRoomEN = new List<BookingRoomsEN>();
BookingRoomsEN aBookingRoomEN, aBookingRoomEN2;
for (int i = 0; i < aListTemp.Count; i++)
{
aBookingRoomEN = new BookingRoomsEN();
aBookingRoomEN.SetValue(aListTemp[i]);
if (aRoomsBO.Select_ByCodeRoom(aListTemp[i].CodeRoom, 1) != null)
{
aBookingRoomEN.RoomSku = aRoomsBO.Select_ByCodeRoom(aListTemp[i].CodeRoom, 1).Sku;
}
aListBookingRoomEN.Add(aBookingRoomEN);
}
for (int y = 0; y < alistTemp2.Count; y++)
{
aBookingRoomEN2 = new BookingRoomsEN();
aBookingRoomEN2.SetValue(alistTemp2[y]);
if (aRoomsBO.Select_ByCodeRoom(alistTemp2[y].CodeRoom, 1) != null)
{
aBookingRoomEN2.RoomSku = aRoomsBO.Select_ByCodeRoom(alistTemp2[y].CodeRoom, 1).Sku;
}
aListBookingRoomEN.Add(aBookingRoomEN2);
}
return aListBookingRoomEN;
}
catch (Exception ex)
{
throw new Exception("BookingRoomsBO.GetListRoomsCheckOutPlanInDayAndH:" + ex.ToString());
}
}
public void Reload()
{
BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO();
RoomsBO aRoomsBO = new RoomsBO();
BookingRoomsEN aBookingRoomsEN = new BookingRoomsEN();
BookingRooms aBookingRooms = aBookingRoomsBO.Select_ByID(IDBookingRoom);
aBookingRoomsEN.SetValue(aBookingRooms);
aBookingRoomsEN.ID = aBookingRooms.ID;
aBookingRoomsEN.RoomSku = aRoomsBO.Select_ByCodeRoom(aBookingRooms.CodeRoom, 1).Sku;
this.lbCurrentRoom.Text = "Phòng số : " + aBookingRoomsEN.RoomSku;
aListBookingRoom.Add(aBookingRoomsEN);
dgvRooms.DataSource = aListBookingRoom;
dgvRooms.RefreshDataSource();
ServicesBO aServicesBO = new ServicesBO();
aListService = aServicesBO.Select_ByType(2);
dgvServices.DataSource = aListService;
dgvServices.RefreshDataSource();
}