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); } }