public uc_RoomStatusItem(RoomExtStatusEN Datasource)
{
InitializeComponent();
this.Datasource = Datasource;
string a =Datasource.Sku;
string b = Datasource.Code;
if (Datasource.RoomStatus == 0)
{
this.rectangleShape_BackColor = System.Drawing.Color.Gainsboro;
this.rectangleShape_BorderColor = System.Drawing.Color.WhiteSmoke;
this.lblSku_BackColor = System.Drawing.Color.Gainsboro;
this.lblSku_ForeColor = System.Drawing.Color.WhiteSmoke;
}
if (Datasource.RoomStatus == 1) // Verifi
{
this.rectangleShape_BackColor = System.Drawing.Color.DarkRed;
this.rectangleShape_BorderColor = System.Drawing.Color.Maroon;
this.lblSku_BackColor = System.Drawing.Color.DarkRed;
this.lblSku_ForeColor = System.Drawing.Color.Maroon;
}
if (Datasource.RoomStatus == 2)
{
this.rectangleShape_BackColor = System.Drawing.Color.Tomato;
this.rectangleShape_BorderColor = System.Drawing.Color.Salmon;
this.lblSku_BackColor = System.Drawing.Color.Tomato;
this.lblSku_ForeColor = System.Drawing.Color.Salmon;
}
if (Datasource.RoomStatus == 3) //
{
this.rectangleShape_BackColor = System.Drawing.Color.Gold;
this.rectangleShape_BorderColor = System.Drawing.Color.Goldenrod;
this.lblSku_BackColor = System.Drawing.Color.Gold;
this.lblSku_ForeColor = System.Drawing.Color.Goldenrod;
}
if (Datasource.RoomStatus == 5)
{
this.rectangleShape_BackColor = System.Drawing.Color.SlateGray;
this.rectangleShape_BorderColor = System.Drawing.Color.LightSlateGray;
this.rectangleShape1.BackgroundImage = RoomManager.Properties.Resources.ice2; // Gán ảnh băng giá cho background
this.lblSku_BackColor = System.Drawing.Color.SlateGray;
this.lblSku_ForeColor = System.Drawing.Color.LightSlateGray;
}
lblSku.ForeColor = lblSku_ForeColor;
lblSku.BackColor = lblSku_BackColor;
rectangleShape1.BorderColor = rectangleShape_BorderColor;
rectangleShape1.BackColor = rectangleShape_BackColor;
this.LoadWarning();
}
public uc_Tooltip_StatusRoom_0()
{
InitializeComponent();
this.Datasource = new RoomExtStatusEN();;
}
public uc_Tooltip_StatusRoom_0(RoomExtStatusEN Datasource)
{
InitializeComponent();
this.Datasource = Datasource;
}
public uc_RoomStatusItem(RoomExtStatusEN Datasource)
{
InitializeComponent();
this.Datasource = Datasource;
//string a =Datasource.Sku;
//string b = Datasource.Code;
this.From = Datasource;
if (Datasource.Disable == true)
{
this.rectangleShape_BackColor = System.Drawing.Color.DarkRed;
this.rectangleShape_BorderColor = System.Drawing.Color.Maroon;
this.lblSku_BackColor = System.Drawing.Color.DarkRed;
this.lblSku_ForeColor = System.Drawing.Color.Maroon;
}
else if (Datasource.Disable == false)
{
if (Datasource.RoomStatus == 0)
{
this.rectangleShape_BackColor = System.Drawing.Color.Gainsboro;
this.rectangleShape_BorderColor = System.Drawing.Color.WhiteSmoke;
this.lblSku_BackColor = System.Drawing.Color.Gainsboro;
this.lblSku_ForeColor = System.Drawing.Color.WhiteSmoke;
}
if (Datasource.RoomStatus == 1) // Verifi
{
this.rectangleShape_BackColor = System.Drawing.Color.DarkRed;
this.rectangleShape_BorderColor = System.Drawing.Color.Maroon;
this.lblSku_BackColor = System.Drawing.Color.DarkRed;
this.lblSku_ForeColor = System.Drawing.Color.Maroon;
}
if (Datasource.RoomStatus == 2)
{
this.rectangleShape_BackColor = System.Drawing.Color.Gold;
this.rectangleShape_BorderColor = System.Drawing.Color.Goldenrod;
this.lblSku_BackColor = System.Drawing.Color.Gold;
this.lblSku_ForeColor = System.Drawing.Color.Goldenrod;
}
if (Datasource.RoomStatus == 3) // Dang o
{
this.rectangleShape_BackColor = System.Drawing.Color.SkyBlue;
this.rectangleShape_BorderColor = System.Drawing.Color.Teal;
this.lblSku_BackColor = System.Drawing.Color.SkyBlue;
this.lblSku_ForeColor = System.Drawing.Color.WhiteSmoke;
}
if (Datasource.RoomStatus == 5)
{
this.rectangleShape_BackColor = System.Drawing.Color.Gold;
this.rectangleShape_BorderColor = System.Drawing.Color.Goldenrod;
this.lblSku_BackColor = System.Drawing.Color.Gold;
this.lblSku_ForeColor = System.Drawing.Color.Goldenrod;
}
}
lblSku.ForeColor = lblSku_ForeColor;
lblSku.BackColor = lblSku_BackColor;
rectangleShape1.BorderColor = rectangleShape_BorderColor;
rectangleShape1.BackColor = rectangleShape_BackColor;
this.LoadWarning();
}
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;
}
}
public RoomExtStatusEN GetStatusRoom(string CodeRoom, DateTime now)
{
RoomExtStatusEN aRoomExtStatusEN = new RoomExtStatusEN();
Rooms aRooms = this.Select_ByCodeRoom(CodeRoom,1);
if (aRooms != null)
{
aRoomExtStatusEN = this.GetStatusRoom(aRooms.ID, now);
return aRoomExtStatusEN;
}
else
{
return null;
}
}
public List<RoomExtStatusEN> GetStatusRoom_ByListStatus( List<int> ListStatus)
{
List<RoomExtStatusEN> ret = new List<RoomExtStatusEN>();
List<sp_RoomExt_GetBookingRoom_ByListStatus_Result> aList = this.aDatabaseDA.sp_RoomExt_GetBookingRoom_ByListStatus( string.Join(",", ListStatus), 1).ToList();
RoomExtStatusEN aRoomExtStatusEN = new RoomExtStatusEN();
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.LevelSku = aList[i].LevelSku;
aRoomExtStatusEN.OrderSku = aList[i].OrderSku;
aRoomExtStatusEN.BookingRooms_ID = aList[i].BookingRooms_ID;
aRoomExtStatusEN.Disable = aList[i].Disable;
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.CustomerGroups_ID = aList[i].CustomerGroups_ID;
aRoomExtStatusEN.Companies_ID = aList[i].Companies_ID;
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.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;
}
ret.Add(aRoomExtStatusEN);
}
return ret.Distinct().ToList();
}
public List<RoomExtStatusEN> GetStatusRoom(List<string> ListCodeRoom, DateTime now)
{
List<RoomExtStatusEN> ret = new List<RoomExtStatusEN>();
List<sp_RoomExt_GetCurrentStatusRooms_ByListCodeRoom_ByTime_Result> aList = this.aDatabaseDA.sp_RoomExt_GetCurrentStatusRooms_ByListCodeRoom_ByTime(string.Join(",", ListCodeRoom), now,1).ToList();
RoomExtStatusEN aRoomExtStatusEN = new RoomExtStatusEN();
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.LevelSku = aList[i].LevelSku;
aRoomExtStatusEN.OrderSku = aList[i].OrderSku;
aRoomExtStatusEN.BookingRooms_ID = aList[i].BookingRooms_ID;
aRoomExtStatusEN.Disable = aList[i].Disable;
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.CustomerGroups_ID = aList[i].CustomerGroups_ID;
aRoomExtStatusEN.Companies_ID = aList[i].Companies_ID;
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.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;
}
ret.Add(aRoomExtStatusEN);
}
ret = ret.Distinct().ToList();
List<string> aListCodeTempt = aList.Select(p=>p.Code).ToList();
//-----------------------------------
// Xoa nhung phong da dang su dung vao thoi diem do, con lai nhung phong trong
for (int iii = 0 ; iii<aListCodeTempt.Count ; iii++)
{
ListCodeRoom.Remove(aListCodeTempt[iii]);
}
//-----------------------------------
// Lay thong tin phong trong
for (int iii = 0; iii < ListCodeRoom.Count; iii++)
{
RoomsBO aRoomsBO = new RoomsBO();
Rooms aRooms = aRoomsBO.Select_ByCodeRoom(ListCodeRoom[iii],1);
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;
aRoomExtStatusEN.LevelSku = aRooms.LevelSku;
aRoomExtStatusEN.OrderSku = aRooms.OrderSku;
aRoomExtStatusEN.Disable = aRooms.Disable;
ret.Add(aRoomExtStatusEN);
}
else
{
throw new Exception("Phòng cần check trạng thái không tồn tại");
}
}
return ret.Distinct().ToList();
}
