//Hiennv
private void chkDisable_Click(object sender, EventArgs e)
{
try
{
int ID = Convert.ToInt32(viewRooms.GetFocusedRowCellValue("ID"));
bool disableOld = Convert.ToBoolean(viewRooms.GetFocusedRowCellValue("Disable"));
bool disalbeNew = false;
string disable = string.Empty;
if (disableOld == false)
{
disalbeNew = true;
disable = "Khóa";
}
else
{
disalbeNew = false;
disable = "Mở";
}
DialogResult result = MessageBox.Show("Bạn có chắc chắn muốn " + disable + " phòng này không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
RoomsBO aRoomsBO = new RoomsBO();
Rooms aRooms = aRoomsBO.Select_ByID(ID);
if (aRooms != null)
{
aRooms.Disable = disalbeNew;
int count = aRoomsBO.Update(aRooms);
if (count > 0)
{
this.ReloadData();
if (this.afrmMain != null)
{
this.afrmMain.ReloadData();
}
MessageBox.Show("Thực hiện thành công.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("frmLst_Rooms.chkDisable_Click\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public RoomExtStatusEN GetStatusRoom(int IDRoom, DateTime now)
{
List<sp_RoomExt_GetCurrentStatusRooms_ByIDRoom_ByTime_Result> aList = this.aDatabaseDA.sp_RoomExt_GetCurrentStatusRooms_ByIDRoom_ByTime(IDRoom, now).ToList();
RoomExtStatusEN aRoomExtStatusEN = new RoomExtStatusEN();
if (aList.Count > 0)
{
for (int i = 0; i < aList.Count; i++)
{
aRoomExtStatusEN = new RoomExtStatusEN();
aRoomExtStatusEN.ID = aList[i].ID;
aRoomExtStatusEN.Bed1 = aList[i].Bed1;
aRoomExtStatusEN.Bed2 = aList[i].Bed2;
aRoomExtStatusEN.CostRef = aList[i].CostRef;
aRoomExtStatusEN.Code = aList[i].Code;
aRoomExtStatusEN.Sku = aList[i].Sku;
aRoomExtStatusEN.Note = aList[i].Note;
aRoomExtStatusEN.Type = aList[i].Type;
aRoomExtStatusEN.BookingRooms_ID = aList[i].BookingRooms_ID;
aRoomExtStatusEN.BookingRs_BookingMoney = aList[i].BookingRs_BookingMoney;
aRoomExtStatusEN.BookingRs_CustomerType = aList[i].BookingRs_CustomerType;
aRoomExtStatusEN.BookingRs_ID = aList[i].BookingRs_ID;
aRoomExtStatusEN.BookingRs_Subject = aList[i].BookingRs_Subject;
aRoomExtStatusEN.CheckInActual = aList[i].CheckInActual;
aRoomExtStatusEN.CheckInPlan = aList[i].CheckInPlan;
aRoomExtStatusEN.CheckOutActual = aList[i].CheckOutActual;
aRoomExtStatusEN.CheckOutPlan = aList[i].CheckOutPlan;
aRoomExtStatusEN.Color = aList[i].Color;
aRoomExtStatusEN.Companies_Name = aList[i].Companies_Name;
aRoomExtStatusEN.CostRef = aList[i].CostRef;
aRoomExtStatusEN.CustomerGroups_Name = aList[i].CustomerGroups_Name;
aRoomExtStatusEN.Customers_Address = aList[i].Customers_Address;
aRoomExtStatusEN.Customers_Name = aList[i].Customers_Name;
aRoomExtStatusEN.Customers_Nationality = aList[i].Customers_Nationality;
aRoomExtStatusEN.Customers_Tel = aList[i].Customers_Tel;
aRoomExtStatusEN.Companies_ID = aList[i].Companies_ID;
aRoomExtStatusEN.CustomerGroups_ID = aList[i].CustomerGroups_ID;
aRoomExtStatusEN.Customers_ID = aList[i].Customers_ID;
if (aList[i].BookingRooms_Status == 1)
{
aRoomExtStatusEN.RoomStatus = 1;
}
else if (aList[i].BookingRooms_Status == 2)
{
aRoomExtStatusEN.RoomStatus = 2;
}
else if (aList[i].BookingRooms_Status == 3)
{
aRoomExtStatusEN.RoomStatus = 3;
}
else if (aList[i].BookingRooms_Status == 5)
{
aRoomExtStatusEN.RoomStatus = 5;
}
else if ((aList[i].BookingRooms_Status == 6) || (aList[i].BookingRooms_Status == 7) || (aList[i].BookingRooms_Status == 8))
{
aRoomExtStatusEN.RoomStatus = 0;
}
}
return aRoomExtStatusEN;
}
else
{
RoomsBO aRoomsBO = new RoomsBO();
Rooms aRooms = aRoomsBO.Select_ByID(IDRoom);
if (aRooms != null)
{
aRoomExtStatusEN = new RoomExtStatusEN();
aRoomExtStatusEN.RoomStatus = 0;
aRoomExtStatusEN.Code = aRooms.Code;
aRoomExtStatusEN.Sku = aRooms.Sku;
aRoomExtStatusEN.Bed1 = aRooms.Bed1;
aRoomExtStatusEN.Bed2 = aRooms.Bed2;
aRoomExtStatusEN.Type = aRooms.Type;
}
else
{
throw new Exception("Phòng cần check trạng thái không tồn tại");
}
return aRoomExtStatusEN;
}
}
