private void btnUnSelect_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
try
{
HallExtStatusEN aHallExtStatusEN = new HallExtStatusEN();
aHallExtStatusEN.Code = grvSelectedHalls.GetFocusedRowCellValue("Code").ToString();
aHallExtStatusEN.Sku = grvSelectedHalls.GetFocusedRowCellValue("Sku").ToString();
aHallExtStatusEN.CostRef = Convert.ToDecimal(grvSelectedHalls.GetFocusedRowCellValue("CostRef"));
aHallExtStatusEN.Type = Convert.ToInt16(grvSelectedHalls.GetFocusedRowCellValue("Type"));
aListAvailableHall.Insert(0, aHallExtStatusEN);
dgvAvailableHalls.DataSource = aListAvailableHall;
dgvAvailableHalls.RefreshDataSource();
HallsEN aTemp = aListSelected.Where(a => a.Code == grvSelectedHalls.GetFocusedRowCellValue("Code").ToString()).ToList()[0];
aListSelected.Remove(aTemp);
dgvSelectedHalls.DataSource = aListSelected;
dgvSelectedHalls.RefreshDataSource();
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_UpdBooking.btnUnSelect_ButtonClick\n" + ex.ToString(), "Error ", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public HallExtStatusEN GetStatusHall(int IDHall, DateTime CheckPoint, bool IsLunarDate)
{
List<sp_HallExt_GetCurrentStatusHalls_ByIDHall_ByTime_Result> aList = this.aDatabaseDA.sp_HallExt_GetCurrentStatusHalls_ByIDHall_ByTime(IDHall, CheckPoint, IsLunarDate).ToList();
HallExtStatusEN aHallExtStatusEN = new HallExtStatusEN();
if (aList.Count > 0)
{
for (int i = 0; i < aList.Count; i++)
{
aHallExtStatusEN = new HallExtStatusEN();
aHallExtStatusEN.ID = aList[i].ID;
aHallExtStatusEN.CostRef = aList[i].CostRef;
aHallExtStatusEN.Code = aList[i].Code;
aHallExtStatusEN.Sku = aList[i].Sku;
aHallExtStatusEN.Note = aList[i].Note;
aHallExtStatusEN.Type = aList[i].Type;
aHallExtStatusEN.BookingHalls_ID = aList[i].BookingHalls_ID;
aHallExtStatusEN.BookingHs_BookingMoney = aList[i].BookingHs_BookingMoney;
aHallExtStatusEN.BookingHs_CustomerType = aList[i].BookingHs_CustomerType;
aHallExtStatusEN.BookingHs_ID = aList[i].BookingHs_ID;
aHallExtStatusEN.BookingHs_Subject = aList[i].BookingHs_Subject;
aHallExtStatusEN.Date = aList[i].Date;
aHallExtStatusEN.LunarDate = aList[i].LunarDate;
aHallExtStatusEN.StartTime = aList[i].StartTime;
aHallExtStatusEN.EndTime = aList[i].EndTime;
aHallExtStatusEN.Color = aList[i].Color;
aHallExtStatusEN.Companies_Name = aList[i].Companies_Name;
aHallExtStatusEN.CostRef = aList[i].CostRef;
aHallExtStatusEN.CustomerGroups_Name = aList[i].CustomerGroups_Name;
aHallExtStatusEN.Customers_Address = aList[i].Customers_Address;
aHallExtStatusEN.Customers_Name = aList[i].Customers_Name;
aHallExtStatusEN.Customers_Nationality = aList[i].Customers_Nationality;
aHallExtStatusEN.Customers_Tel = aList[i].Customers_Tel;
//aHallExtStatusEN.Code = aList[i].Code;
aHallExtStatusEN.Location = aList[i].Location;
aHallExtStatusEN.NumTableMax = aList[i].NumTableMax;
aHallExtStatusEN.NumTableStandard = aList[i].NumTableStandard;
aHallExtStatusEN.Unit = aList[i].Unit;
aHallExtStatusEN.TableOrPerson = aList[i].TableOrPerson;
if (aList[i].BookingHalls_Status == 1)
{
aHallExtStatusEN.HallStatus = 1;
}
else if (aList[i].BookingHalls_Status == 2)
{
aHallExtStatusEN.HallStatus = 2;
}
else if (aList[i].BookingHalls_Status == 3)
{
aHallExtStatusEN.HallStatus = 3;
}
else if (aList[i].BookingHalls_Status == 4)
{
aHallExtStatusEN.HallStatus = 4;
}
else if (aList[i].BookingHalls_Status == 5)
{
aHallExtStatusEN.HallStatus = 5;
}
else if (aList[i].BookingHalls_Status == 6)
{
aHallExtStatusEN.HallStatus = 6;
}
else if ( (aList[i].BookingHalls_Status == 7) || (aList[i].BookingHalls_Status == 8))
{
aHallExtStatusEN.HallStatus = 0;
}
}
return aHallExtStatusEN;
}
else
{
HallsBO aHallsBO = new HallsBO();
Halls aHalls = aHallsBO.Select_ByID(IDHall);
if (aHalls != null)
{
aHallExtStatusEN = new HallExtStatusEN();
aHallExtStatusEN.HallStatus = 0;
aHallExtStatusEN.Code = aHalls.Code;
aHallExtStatusEN.Sku = aHalls.Sku;
aHallExtStatusEN.Type = aHalls.Type;
aHallExtStatusEN.CostRef = aHalls.CostRef;
aHallExtStatusEN.Code = aHalls.Code;
aHallExtStatusEN.Sku = aHalls.Sku;
aHallExtStatusEN.Type = aHalls.Type;
aHallExtStatusEN.CostRef = aHalls.CostRef;
aHallExtStatusEN.NumTableMax = aHalls.NumTableMax;
aHallExtStatusEN.NumTableStandard = aHalls.NumTableStandard;
}
else
{
throw new Exception("Hội trường cần check trạng thái không tồn tại");
}
return aHallExtStatusEN;
}
}
public List<HallExtStatusEN> GetStatusBookingHalls(DateTime From, DateTime To, bool IsLunarDate)
{
List<sp_HallExt_GetStatusBookingHalls_ByRankTime_Result> aList = this.aDatabaseDA.sp_HallExt_GetStatusBookingHalls_ByRankTime(From, To, IsLunarDate).ToList();
List<HallExtStatusEN> aList_HallExtStatusEN = new List<HallExtStatusEN>();
HallExtStatusEN aHallExtStatusEN = new HallExtStatusEN();
if (aList.Count > 0)
{
for (int i = 0; i < aList.Count; i++)
{
aHallExtStatusEN = new HallExtStatusEN();
aHallExtStatusEN.ID = aList[i].ID;
aHallExtStatusEN.CostRef = aList[i].CostRef;
aHallExtStatusEN.Code = aList[i].Code;
aHallExtStatusEN.Sku = aList[i].Sku;
aHallExtStatusEN.Note = aList[i].Note;
aHallExtStatusEN.Type = aList[i].Type;
aHallExtStatusEN.BookingHalls_ID = aList[i].BookingHalls_ID;
aHallExtStatusEN.BookingHs_BookingMoney = aList[i].BookingHs_BookingMoney;
aHallExtStatusEN.BookingHs_CustomerType = aList[i].BookingHs_CustomerType;
aHallExtStatusEN.BookingHs_ID = aList[i].BookingHs_ID;
aHallExtStatusEN.BookingHs_Subject = aList[i].BookingHs_Subject;
aHallExtStatusEN.Date = aList[i].Date;
aHallExtStatusEN.LunarDate = aList[i].LunarDate;
aHallExtStatusEN.StartTime = aList[i].StartTime;
aHallExtStatusEN.EndTime = aList[i].EndTime;
aHallExtStatusEN.Color = aList[i].Color;
aHallExtStatusEN.Companies_Name = aList[i].Companies_Name;
aHallExtStatusEN.CostRef = aList[i].CostRef;
aHallExtStatusEN.CustomerGroups_Name = aList[i].CustomerGroups_Name;
aHallExtStatusEN.Customers_Address = aList[i].Customers_Address;
aHallExtStatusEN.Customers_Name = aList[i].Customers_Name;
aHallExtStatusEN.Customers_Nationality = aList[i].Customers_Nationality;
aHallExtStatusEN.Customers_Tel = aList[i].Customers_Tel;
//aHallExtStatusEN.Code = aList[i].Code;
aHallExtStatusEN.Location = aList[i].Location;
aHallExtStatusEN.NumTableMax = aList[i].NumTableMax;
aHallExtStatusEN.NumTableStandard = aList[i].NumTableStandard;
aHallExtStatusEN.Unit = aList[i].Unit;
aHallExtStatusEN.TableOrPerson = aList[i].TableOrPerson;
if (aList[i].BookingHalls_Status == 1)
{
aHallExtStatusEN.HallStatus = 1;
}
else if (aList[i].BookingHalls_Status == 2)
{
aHallExtStatusEN.HallStatus = 2;
}
else if (aList[i].BookingHalls_Status == 3)
{
aHallExtStatusEN.HallStatus = 3;
}
else if (aList[i].BookingHalls_Status == 4)
{
aHallExtStatusEN.HallStatus = 4;
}
else if (aList[i].BookingHalls_Status == 5)
{
aHallExtStatusEN.HallStatus = 5;
}
else if (aList[i].BookingHalls_Status == 6)
{
aHallExtStatusEN.HallStatus = 6;
}
else if ( (aList[i].BookingHalls_Status == 7) || (aList[i].BookingHalls_Status == 8))
{
aHallExtStatusEN.HallStatus = 0;
}
aList_HallExtStatusEN.Add(aHallExtStatusEN);
}
}
return aList_HallExtStatusEN.Where(p => p.HallStatus > 0).ToList(); //Loai cac hoi truong Avail
}
public HallExtStatusEN GetStatusHall(string CodeHall, DateTime CheckPoint, bool IsLunarDate)
{
HallsBO aHallsBO = new HallsBO();
HallExtStatusEN aHallExtStatusEN = new HallExtStatusEN();
Halls aHalls = aHallsBO.Select_ByCodeHall(CodeHall, 1);
if (aHalls != null)
{
aHallExtStatusEN = this.GetStatusHall(aHalls.ID, CheckPoint, IsLunarDate);
return aHallExtStatusEN;
}
else
{
return null;
}
}
private void btnUnSelect_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
try
{
HallExtStatusEN aHallExtStatusEN = new HallExtStatusEN();
aHallExtStatusEN.Code = grvSelectedHalls.GetFocusedRowCellValue("CodeHall").ToString();
aHallExtStatusEN.Sku = grvSelectedHalls.GetFocusedRowCellValue("HallSku").ToString();
aHallExtStatusEN.CostRef = Convert.ToDecimal(grvSelectedHalls.GetFocusedRowCellValue("CostRef_Halls"));
aHallExtStatusEN.Type = Convert.ToInt32(grvSelectedHalls.GetFocusedRowCellValue("HallType"));
aListAvailableHall.Insert(0, aHallExtStatusEN);
dgvAvailableHalls.DataSource = aListAvailableHall;
dgvAvailableHalls.RefreshDataSource();
NewBookingHallEN aTemp = this.aNewBookingHEN.aListBookingHallUsed.Where(a => a.CodeHall == grvSelectedHalls.GetFocusedRowCellValue("CodeHall").ToString()).ToList()[0];
this.aNewBookingHEN.aListBookingHallUsed.Remove(aTemp);
dgvSelectedHalls.DataSource = this.aNewBookingHEN.aListBookingHallUsed;
lueHalls.Reset();
lueHalls.Properties.DataSource = this.aNewBookingHEN.aListBookingHallUsed;
lueHalls.Properties.DisplayMember = "HallSku";
lueHalls.Properties.ValueMember = "CodeHall";
dgvSelectedHalls.RefreshDataSource();
}
catch (Exception ex)
{
MessageBox.Show("frmTsk_BookingHall_Customer_New.btnUnSelect_ButtonClick\n" + ex.ToString(), "Error ", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
