//Hiennv private void txtTaxNumberCode_Leave(object sender, EventArgs e) { try { CompaniesBO aCompaniesBO = new CompaniesBO(); Companies aCompanies = aCompaniesBO.Select_ByID(this.aPaymentHallsEN.IDCompany); if (aCompanies != null) { aCompanies.TaxNumberCode = txtTaxNumberCode.Text; aCompaniesBO.Update(aCompanies); } } catch (Exception ex) { MessageBox.Show("frmTsk_PaymentHall.txtTaxNumberCode_Leave\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
// Author : Linhting public void InitData( int IDBookingH) { try { CompaniesBO aCompaniesBO = new CompaniesBO(); CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO(); SystemUsersBO aSystemUsersBO = new SystemUsersBO(); BookingHsBO aBookingHsBO = new BookingHsBO(); CustomersBO aCustomersBO = new CustomersBO(); ReceptionTaskBO aReceptionTaskBO = new ReceptionTaskBO(); HallsBO aHallsBO = new HallsBO(); BookingHallsBO aBookingHallsBO = new BookingHallsBO(); FoodsBO aFoodsBO = new FoodsBO(); BookingHs aBookingHs = aBookingHsBO.Select_ByID(IDBookingH); // Truyen du lieu cho List BookingRoom cua NewPayment if (aBookingHs != null) { aNewPaymentEN.IDCustomer = aBookingHs.IDCustomer; Customers aCustomers = aCustomersBO.Select_ByID(aBookingHs.IDCustomer); if (aCustomers != null) { aNewPaymentEN.NameCustomer = aCustomers.Name; } aNewPaymentEN.IDSystemUser = aBookingHs.IDSystemUser; SystemUsers aSystemUsers = aSystemUsersBO.Select_ByID(aBookingHs.IDSystemUser); if (aSystemUsers != null) { aNewPaymentEN.NameSystemUser = aSystemUsers.Name; } aNewPaymentEN.IDCustomerGroup = aBookingHs.IDCustomerGroup; CustomerGroups aCustomerGroups = aCustomerGroupsBO.Select_ByID(aBookingHs.IDCustomerGroup); if (aCustomerGroups != null) { aNewPaymentEN.NameCustomerGroup = aCustomerGroups.Name; aNewPaymentEN.IDCompany = aCustomerGroups.IDCompany; Companies aCompanies = aCompaniesBO.Select_ByID(aCustomerGroups.IDCompany); if (aCompanies != null) { aNewPaymentEN.NameCompany = aCompanies.Name; aNewPaymentEN.TaxNumberCodeCompany = aCompanies.TaxNumberCode; aNewPaymentEN.AddressCompany = aCompanies.Address; } } aNewPaymentEN.IDBookingH = aBookingHs.ID; aNewPaymentEN.CreatedDate_BookingH = aBookingHs.CreatedDate; aNewPaymentEN.CustomerType = aBookingHs.CustomerType; aNewPaymentEN.Status_BookingH = aBookingHs.Status; aNewPaymentEN.BookingHMoney = aBookingHs.BookingMoney; // Truyen du lieu cho List BookingHall cua NewPayment List<BookingHalls> aListBookingHalls = aBookingHallsBO.Select_ByIDBookigH(this.IDBookingH); if (aListBookingHalls != null) { BookingHallUsedEN aBookingHallUsedEN; foreach (BookingHalls item in aListBookingHalls) { aBookingHallUsedEN = new BookingHallUsedEN(); aBookingHallUsedEN.SetValue(item); Halls aHalls = aHallsBO.Select_ByCodeHall(item.CodeHall, 1); if (aHalls != null) { aBookingHallUsedEN.HallSku = aHalls.Sku; } else { aBookingHallUsedEN.HallSku = string.Empty; } aBookingHallUsedEN.CustomerType = aBookingHs.CustomerType; aBookingHallUsedEN.BookingTypeBookingH = aBookingHs.BookingType; aBookingHallUsedEN.StatusPayBookingH = aBookingHs.StatusPay; aBookingHallUsedEN.LevelBookingH = aBookingHs.Level; aBookingHallUsedEN.aListMenuEN = aReceptionTaskBO.GetListMenus_ByIDBookingHall(item.ID); List<ServiceUsedEN> aListServiceTemp = aReceptionTaskBO.GetListServiceUsedInHall_ByIDBookingHall(item.ID); foreach (ServiceUsedEN aTemp in aListServiceTemp) { aBookingHallUsedEN.aListServiceUsed.Add(aTemp); } aNewPaymentEN.aListBookingHallUsed.Add(aBookingHallUsedEN); } } } } catch (Exception ex) { MessageBox.Show("frmTsk_PaymentHall.InitData\n" + ex.ToString()); } }
public void InitData(int IDBookingH) { CompaniesBO aCompaniesBO = new CompaniesBO(); CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO(); SystemUsersBO aSystemUsersBO = new SystemUsersBO(); BookingHsBO aBookingHsBO = new BookingHsBO(); ReceptionTaskBO aReceptionTaskBO = new ReceptionTaskBO(); HallsBO aHallsBO = new HallsBO(); BookingHallsBO aBookingHallsBO = new BookingHallsBO(); FoodsBO aFoodsBO = new FoodsBO(); List<int> aListIndexTemp = new List<int>(); BookingHs aBookingHs = aBookingHsBO.Select_ByID(IDBookingH); if (aBookingHs != null) { aNewPaymentHEN.IDCustomer = aBookingHs.IDCustomer; Customers aCustomers = aCustomersBO.Select_ByID(aBookingHs.IDCustomer); if (aCustomers != null) { aNewPaymentHEN.NameCustomer = aCustomers.Name; } aNewPaymentHEN.IDSystemUser = aBookingHs.IDSystemUser; SystemUsers aSystemUsers = aSystemUsersBO.Select_ByID(aBookingHs.IDSystemUser); if (aSystemUsers != null) { aNewPaymentHEN.NameSystemUser = aSystemUsers.Name; } aNewPaymentHEN.IDCustomerGroup = aBookingHs.IDCustomerGroup; CustomerGroups aCustomerGroups = aCustomerGroupsBO.Select_ByID(aBookingHs.IDCustomerGroup); if (aCustomerGroups != null) { aNewPaymentHEN.NameCustomerGroup = aCustomerGroups.Name; aNewPaymentHEN.IDCompany = aCustomerGroups.IDCompany; Companies aCompanies = aCompaniesBO.Select_ByID(aCustomerGroups.IDCompany); if (aCompanies != null) { aNewPaymentHEN.NameCompany = aCompanies.Name; aNewPaymentHEN.TaxNumberCodeCompany = aCompanies.TaxNumberCode; aNewPaymentHEN.AddressCompany = aCompanies.Address; } } aNewPaymentHEN.Subject = aBookingHs.Subject; aNewPaymentHEN.PayMenthodH = aBookingHs.PayMenthod; aNewPaymentHEN.CreatedDate_BookingH = aBookingHs.CreatedDate; aNewPaymentHEN.CustomerType = aBookingHs.CustomerType; aNewPaymentHEN.Status_BookingH = aBookingHs.Status; aNewPaymentHEN.StatusPay = aBookingHs.StatusPay; aNewPaymentHEN.BookingHMoney = aBookingHs.BookingMoney; aNewPaymentHEN.AcceptDate = aBookingHs.AcceptDate; aNewPaymentHEN.InvoiceDate = aBookingHs.InvoiceDate; aNewPaymentHEN.InvoiceNumber = aBookingHs.InvoiceNumber; this.aNewPaymentHEN.IDBookingH = aBookingHs.ID; this.aNewPaymentHEN.PayMenthodH = aBookingHs.PayMenthod; this.aNewPaymentHEN.CreatedDate_BookingH = aBookingHs.CreatedDate; this.aNewPaymentHEN.CustomerType = aBookingHs.CustomerType; this.aNewPaymentHEN.Status_BookingH = aBookingHs.Status; this.aNewPaymentHEN.BookingHMoney = aBookingHs.BookingMoney; // Truyen du lieu cho List BookingHall cua NewPayment List<BookingHalls> aListBookingHalls = aBookingHallsBO.Select_ByIDBookigH(this.IDBookingH); if (aListBookingHalls != null) { BookingHallUsedEN aBookingHallUsedEN; foreach (BookingHalls item in aListBookingHalls) { aBookingHallUsedEN = new BookingHallUsedEN(); aBookingHallUsedEN.SetValue(item); Halls aHalls = aHallsBO.Select_ByCodeHall(item.CodeHall, 1); if (aHalls != null) { aBookingHallUsedEN.HallSku = aHalls.Sku; } else { aBookingHallUsedEN.HallSku = string.Empty; } aBookingHallUsedEN.CustomerType = aBookingHs.CustomerType; aBookingHallUsedEN.BookingTypeBookingH = aBookingHs.BookingType; aBookingHallUsedEN.StatusPayBookingH = aBookingHs.StatusPay; aBookingHallUsedEN.LevelBookingH = aBookingHs.Level; aBookingHallUsedEN.aListMenuEN = aReceptionTaskBO.GetListMenus_ByIDBookingHall(item.ID); aListIndexTemp.Add(Convert.ToInt32(aBookingHallUsedEN.IndexSubPayment)); List<ServiceUsedEN> aListServiceTemp = aReceptionTaskBO.GetListServiceUsedInHall_ByIDBookingHall(item.ID); foreach (ServiceUsedEN aTemp in aListServiceTemp) { aBookingHallUsedEN.aListServiceUsed.Add(aTemp); aListIndexTemp.Add(Convert.ToInt32(aTemp.IndexSubPayment)); } aNewPaymentHEN.aListBookingHallUsed.Add(aBookingHallUsedEN); } } } aNewPaymentHEN.ListIndex = aListIndexTemp.Distinct().ToList(); }
//hiennv public void InitData(PaymentHallsEN aPaymentHallsEN, int IDBookingH) { try { HallsBO aHallsBO = new HallsBO(); BookingHallsBO aBookingHallsBO = new BookingHallsBO(); FoodsBO aFoodsBO = new FoodsBO(); ReceptionTaskBO aReceptionTaskBO = new ReceptionTaskBO(); CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO(); CustomersBO aCustomersBO = new CustomersBO(); BookingHsBO aBookingHsBO = new BookingHsBO(); CompaniesBO aCompaniesBO = new CompaniesBO(); SystemUsersBO aSystemUsersBO = new SystemUsersBO(); BookingHs aBookingHs = aBookingHsBO.Select_ByID(IDBookingH); if (aBookingHs != null) { aPaymentHallsEN.IDBookingH = aBookingHs.ID; aPaymentHallsEN.IDCustomerGroup = aBookingHs.IDCustomerGroup; CustomerGroups aCustomerGroups = aCustomerGroupsBO.Select_ByID(aBookingHs.IDCustomerGroup); if (aCustomerGroups != null) { aPaymentHallsEN.NameCustomerGroup = aCustomerGroups.Name; aPaymentHallsEN.IDCompany = aCustomerGroups.IDCompany; Companies aCompanies = aCompaniesBO.Select_ByID(aCustomerGroups.IDCompany); if (aCompanies != null) { aPaymentHallsEN.NameCompany = aCompanies.Name; aPaymentHallsEN.TaxNumberCodeCompany = aCompanies.TaxNumberCode; } } aPaymentHallsEN.IDCustomer = aBookingHs.IDCustomer; Customers aCustomers = aCustomersBO.Select_ByID(aBookingHs.IDCustomer); if (aCustomers != null) { aPaymentHallsEN.NameCustomer = aCustomers.Name; } aPaymentHallsEN.IDSystemUser = aBookingHs.IDSystemUser; SystemUsers aSystemUsers = aSystemUsersBO.Select_ByID(aBookingHs.IDSystemUser); if (aSystemUsers != null) { aPaymentHallsEN.NameSystemUser = aSystemUsers.Name; } aPaymentHallsEN.CreatedDate_BookingH = aBookingHs.CreatedDate; aPaymentHallsEN.CustomerType = aBookingHs.CustomerType; aPaymentHallsEN.BookingType = aBookingHs.BookingType; aPaymentHallsEN.PayMenthod = aBookingHs.PayMenthod; aPaymentHallsEN.StatusPay = aBookingHs.StatusPay; aPaymentHallsEN.Status_BookingH = aBookingHs.Status; aPaymentHallsEN.ExchangeRate = aBookingHs.ExchangeRate; aPaymentHallsEN.Level = aBookingHs.Level; aPaymentHallsEN.BookingMoney = aBookingHs.BookingMoney; } List<BookingHalls> aListBookingHalls = new List<BookingHalls>(); aListBookingHalls = aBookingHallsBO.Select_ByIDBookigH(IDBookingH); InfoDetailPaymentHallsEN aInfoDetailPaymentHallsEN; for (int i = 0; i < aListBookingHalls.Count; i++) { aInfoDetailPaymentHallsEN = new InfoDetailPaymentHallsEN(); Halls aHalls = aHallsBO.Select_ByCodeHall(aListBookingHalls[i].CodeHall, 1); if (aHalls != null) { aInfoDetailPaymentHallsEN.Sku = aHalls.Sku; } else { aInfoDetailPaymentHallsEN.Sku = string.Empty; } aInfoDetailPaymentHallsEN.aBookingHalls = aListBookingHalls[i]; aInfoDetailPaymentHallsEN.aMenusEN = aReceptionTaskBO.GetDetailMenu_ByIDBookingHall(aListBookingHalls[i].ID); aInfoDetailPaymentHallsEN.aListServicesHallsEN = aReceptionTaskBO.GetListServicesHallsEN_ByIDBookingHall(aListBookingHalls[i].ID); aPaymentHallsEN.aListInfoDetailPaymentHallsEN.Insert(i, aInfoDetailPaymentHallsEN); } } catch (Exception ex) { MessageBox.Show("frmTsk_PaymentHall.InitData\n" + ex.ToString()); } }
// =============================================================================== // Khoi tao doi tuong Payment private void InitData(int IDBookingR, int IDBookingH) { CompaniesBO aCompaniesBO = new CompaniesBO(); CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO(); SystemUsersBO aSystemUsersBO = new SystemUsersBO(); BookingHsBO aBookingHsBO = new BookingHsBO(); BookingRsBO aBookingRsBO = new BookingRsBO(); BookingRoomsBO aBookingRoomBO = new BookingRoomsBO(); CustomersBO aCustomersBO = new CustomersBO(); ReceptionTaskBO aReceptionTaskBO = new ReceptionTaskBO(); RoomsBO aRoomsBO = new RoomsBO(); HallsBO aHallsBO = new HallsBO(); BookingHallsBO aBookingHallsBO = new BookingHallsBO(); FoodsBO aFoodsBO = new FoodsBO(); ExtraCostBO aExtraCostBO = new ExtraCostBO(); List<int> aListIndexTemp = new List<int>(); BookingHs aBookingHs = new BookingHs(); BookingRs aBookingRs = aBookingRsBO.Select_ByID(IDBookingR); if (this.IDBookingH > 0) { aBookingHs = aBookingHsBO.Select_ByID(this.IDBookingH); } else { BookingRs_BookingHs aItem = (new BookingRs_BookingHsBO()).Select_ByIDBookingR(this.IDBookingR); if (aItem != null) { this.IDBookingH = aItem.IDBookingH.GetValueOrDefault(0); aBookingHs = aBookingHsBO.Select_ByID(this.IDBookingH); } } // Truyen du lieu chung cua NewPayment if (aBookingRs != null) { aNewPaymentEN.IDBookingR = aBookingRs.ID; aNewPaymentEN.IDCustomer = aBookingRs.IDCustomer; Customers aCustomers = aCustomersBO.Select_ByID(aBookingRs.IDCustomer); if (aCustomers != null) { aNewPaymentEN.NameCustomer = aCustomers.Name; } aNewPaymentEN.IDSystemUser = aBookingRs.IDSystemUser; SystemUsers aSystemUsers = aSystemUsersBO.Select_ByID(aBookingRs.IDSystemUser); if (aSystemUsers != null) { aNewPaymentEN.NameSystemUser = aSystemUsers.Name; } aNewPaymentEN.IDCustomerGroup = aBookingRs.IDCustomerGroup; CustomerGroups aCustomerGroups = aCustomerGroupsBO.Select_ByID(aBookingRs.IDCustomerGroup); if (aCustomerGroups != null) { aNewPaymentEN.NameCustomerGroup = aCustomerGroups.Name; aNewPaymentEN.IDCompany = aCustomerGroups.IDCompany; Companies aCompanies = aCompaniesBO.Select_ByID(aCustomerGroups.IDCompany); if (aCompanies != null) { aNewPaymentEN.NameCompany = aCompanies.Name; aNewPaymentEN.TaxNumberCodeCompany = aCompanies.TaxNumberCode; aNewPaymentEN.AddressCompany = aCompanies.Address; } } aNewPaymentEN.PayMenthodR = aBookingRs.PayMenthod; aNewPaymentEN.CreatedDate_BookingR = aBookingRs.CreatedDate; aNewPaymentEN.CustomerType = aBookingRs.CustomerType; aNewPaymentEN.Status_BookingR = aBookingRs.Status; aNewPaymentEN.StatusPay = aBookingRs.StatusPay; aNewPaymentEN.BookingRMoney = aBookingRs.BookingMoney; aNewPaymentEN.Status_BookingR = aBookingRs.Status; aNewPaymentEN.AcceptDate = aBookingRs.AcceptDate; aNewPaymentEN.InvoiceDate = aBookingRs.InvoiceDate; aNewPaymentEN.InvoiceNumber = aBookingRs.InvoiceNumber; // Truyen du lieu cho List BookingRoom cua NewPayment List<BookingRooms> aListBookingRooms = aBookingRoomBO.Select_ByIDBookingRs(this.IDBookingR); if (aListBookingRooms.Count > 0) { BookingRoomUsedEN aBookingRoomUsedEN; foreach (BookingRooms item in aListBookingRooms) { aBookingRoomUsedEN = new BookingRoomUsedEN(); aBookingRoomUsedEN.SetValue(item); aBookingRoomUsedEN.ListCustomer = aCustomersBO.SelectListCustomer_ByIDBookingRoom(item.ID); Rooms aRooms = aRoomsBO.Select_ByCodeRoom(item.CodeRoom, 1); if (aRooms != null) { aBookingRoomUsedEN.RoomSku = aRooms.Sku; } else { aBookingRoomUsedEN.RoomSku = string.Empty; } if (item.Status == 8 || item.Status == 7) { aBookingRoomUsedEN.AddTimeStart = Convert.ToDouble(aReceptionTaskBO.GetAddTimeStart(Convert.ToInt32(item.Type), item.CheckInActual)); aBookingRoomUsedEN.AddTimeEnd = Convert.ToDouble(aReceptionTaskBO.GetAddTimeEnd(Convert.ToInt32(item.Type), item.CheckOutActual)); aBookingRoomUsedEN.TimeInUse = Convert.ToDecimal(aReceptionTaskBO.GetTimeInUsed(item.CheckInActual, item.CheckOutActual) * 24 * 60); } else { aBookingRoomUsedEN.AddTimeStart = Convert.ToDouble(aReceptionTaskBO.GetAddTimeStart(Convert.ToInt32(item.Type), item.CheckInActual)); aBookingRoomUsedEN.AddTimeEnd = Convert.ToDouble(aReceptionTaskBO.GetAddTimeEnd(Convert.ToInt32(item.Type), item.CheckOutPlan)); aBookingRoomUsedEN.TimeInUse = Convert.ToDecimal(aReceptionTaskBO.GetTimeInUsed(item.CheckInActual, item.CheckOutPlan) * 24 * 60); } decimal? cost = 0; if (item.Cost == null) { cost = item.CostRef_Rooms; aBookingRoomUsedEN.Cost = cost + Convert.ToDecimal(aExtraCostBO.Select_BySku_ByPriceType_ByNumberPeople(aRooms.Sku, aBookingRoomUsedEN.PriceType, aBookingRoomUsedEN.ListCustomer.Count).ExtraValue); } else { cost = item.Cost; aBookingRoomUsedEN.Cost = cost; } List<ServiceUsedEN> aListServiceRTemp = aReceptionTaskBO.GetListServiceUsedInRoom_ByIDBookingRoom(item.ID); foreach (ServiceUsedEN aTemp in aListServiceRTemp) { aBookingRoomUsedEN.ListServiceUsed.Add(aTemp); aListIndexTemp.Add(Convert.ToInt32(aTemp.IndexSubPayment)); } aListIndexTemp.Add(Convert.ToInt32(aBookingRoomUsedEN.IndexSubPayment)); aNewPaymentEN.aListBookingRoomUsed.Add(aBookingRoomUsedEN); } } //==================================================================================================== //==================================================================================================== //==================================================================================================== // Brucelee Thanh sửa ngày 04/06/2015 // //--------------- // Lỗi sai điều kiện câu lệnh if khiến aBookingHs truyền dữ liệu CustomerType sai cho NewPaymentEN //--------------- // Ban đầu : if (aBookingHs != null) //------------------------------------- if (aBookingHs.ID > 0) { aNewPaymentEN.IDBookingH = aBookingHs.ID; aNewPaymentEN.PayMenthodH = aBookingHs.PayMenthod; aNewPaymentEN.CreatedDate_BookingH = aBookingHs.CreatedDate; aNewPaymentEN.CustomerType = aBookingHs.CustomerType; aNewPaymentEN.Status_BookingH = aBookingHs.Status; aNewPaymentEN.BookingHMoney = aBookingHs.BookingMoney; // Truyen du lieu cho List BookingHall cua NewPayment List<BookingHalls> aListBookingHalls = aBookingHallsBO.Select_ByIDBookigH(this.IDBookingH); if (aListBookingHalls != null) { BookingHallUsedEN aBookingHallUsedEN; foreach (BookingHalls item in aListBookingHalls) { aBookingHallUsedEN = new BookingHallUsedEN(); aBookingHallUsedEN.SetValue(item); Halls aHalls = aHallsBO.Select_ByCodeHall(item.CodeHall, 1); if (aHalls != null) { aBookingHallUsedEN.HallSku = aHalls.Sku; } else { aBookingHallUsedEN.HallSku = string.Empty; } aBookingHallUsedEN.CustomerType = aBookingHs.CustomerType; aBookingHallUsedEN.BookingTypeBookingH = aBookingHs.BookingType; aBookingHallUsedEN.StatusPayBookingH = aBookingHs.StatusPay; aBookingHallUsedEN.LevelBookingH = aBookingHs.Level; aBookingHallUsedEN.aListMenuEN = aReceptionTaskBO.GetListMenus_ByIDBookingHall(item.ID); aListIndexTemp.Add(Convert.ToInt32(aBookingHallUsedEN.IndexSubPayment)); List<ServiceUsedEN> aListServiceTemp = aReceptionTaskBO.GetListServiceUsedInHall_ByIDBookingHall(item.ID); foreach (ServiceUsedEN aTemp in aListServiceTemp) { aBookingHallUsedEN.aListServiceUsed.Add(aTemp); aListIndexTemp.Add(Convert.ToInt32(aTemp.IndexSubPayment)); } aNewPaymentEN.aListBookingHallUsed.Add(aBookingHallUsedEN); } } } aNewPaymentEN.ListIndex = aListIndexTemp.Distinct().ToList(); } }
private void btnDelete_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { CompaniesBO aCompaniesBO = new CompaniesBO(); int ID = int.Parse(viewAvailableCompanies.GetFocusedRowCellValue("ID").ToString()); string Name = aCompaniesBO.Select_ByID(ID).Name; DialogResult result = MessageBox.Show("Bạn có muốn xóa công ty " + Name + " này không?", "Xóa công ty", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { aCompaniesBO.Delete(ID); MessageBox.Show("Xóa thành công"); this.ReloadData(); } }
private void frmTsk_PendingCheckIn_Step2_Load(object sender, EventArgs e) { try { BookingRsBO aBookingRsBO = new BookingRsBO(); BookingRs aBookingRs = aBookingRsBO.Select_ByID(IDBookingR); lblIDBookingR.Text = aBookingRs.ID.ToString(); CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO(); CustomerGroups aCustomerGroups = aCustomerGroupsBO.Select_ByID(aBookingRs.IDCustomerGroup); lblNameCustomerGroup.Text = aCustomerGroups.Name; CompaniesBO aCompaniesBO = new CompaniesBO(); Companies aCompanies = aCompaniesBO.Select_ByID(aCustomerGroups.IDCompany); lblNameCompany.Text = aCompanies.Name; CustomersBO aCustomersBO = new CustomersBO(); Customers aCustomers = aCustomersBO.Select_ByID(aBookingRs.IDCustomer); lblNameCustomer.Text = aCustomers.Name; RoomsBO aRoomsBO = new RoomsBO(); Rooms aRooms = aRoomsBO.Select_ByCodeRoom(CodeRoom, 1);//1=IDLang lblSku.Text = aRooms.Sku; dtpTo.DateTime = CheckOutPlan; dtpFrom.DateTime = DateTime.Now; dtpFrom.Enabled = false; dtpFrom.Properties.ReadOnly = true; } catch (Exception ex) { MessageBox.Show("frmTsk_PendingCheckIn_Step2.frmTsk_PendingCheckIn_Step2_Load\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void ResetFormWhenTimeChange() { if (aBookingRs.CustomerType == 1) { lblCustomerType.Text = "Khách nhà nước"; } else if (aBookingRs.CustomerType == 2) { lblCustomerType.Text = "Cty ngoài"; } else if (aBookingRs.CustomerType == 3) { lblCustomerType.Text = "Khách lẻ"; } else if (aBookingRs.CustomerType == 4) { lblCustomerType.Text = "Khách vãng lai"; } CustomersBO aCustomersBO = new CustomersBO(); CustomerInfoEN aCustomers = new CustomerInfoEN(); aCustomers = new CustomerInfoEN (aCustomersBO.Select_ByID(aBookingRs.IDCustomer)); lblCustomer.Text = aCustomers.Name; lblTel.Text = aCustomers.Tel; CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO(); CustomerGroups aCustomerGroups = aCustomerGroupsBO.Select_ByID(aBookingRs.IDCustomerGroup); lblGroup.Text = aCustomerGroups.Name; CompaniesBO aCompaniesBO = new CompaniesBO(); lblCompany.Text = aCompaniesBO.Select_ByID(aCustomerGroups.IDCompany).Name; // Fill All Customer dgvAvailableCustomers.DataSource = ConvertListCustomer ((new CustomersBO()).Select_All()); lueRooms.Properties.DataSource = this.GetAvaiableRoom(); lueRooms.Properties.ValueMember = "Code"; lueRooms.Properties.DisplayMember = "Sku"; RoomsBO aRoomsBO = new RoomsBO(); Rooms aRooms = new Rooms(); aRooms = aRoomsBO.Select_ByCodeRoom(this.aBookingRoom.CodeRoom, 1); lueRooms.Properties.NullText = aRooms.Sku; lueRooms.SelectedText = aRooms.Sku; lueRooms.EditValue = aRooms.Code; BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO(); List<BookingRoomsMembers> aListBookingRoomsMembers = aBookingRoomsMembersBO.Select_ByIDBookingRoom (this.aBookingRoom.ID); dgvSelectCustomers.DataSource = GetCustomers(aListBookingRoomsMembers); }
private void InitForm() { // Kiem tra xem phong dang o che do checkIn hay book phong if (this.aBookingRoom.Status < 3) { dtpCheckIn.Text = aBookingRoom.CheckInPlan.ToString(); dtpCheckOut.Text = aBookingRoom.CheckOutPlan.ToString(); } else if (this.aBookingRoom.Status == 3) // Phong da checkIn { dtpCheckIn.Text = DateTime.Now.ToString(); dtpCheckOut.Text = aBookingRoom.CheckOutPlan.ToString(); } if (aBookingRs.CustomerType == 1) { lblCustomerType.Text = "Khách nhà nước"; } else if (aBookingRs.CustomerType == 2) { lblCustomerType.Text = "Cty ngoài"; } else if (aBookingRs.CustomerType == 3) { lblCustomerType.Text = "Khách lẻ"; } else if (aBookingRs.CustomerType == 4) { lblCustomerType.Text = "Khách vãng lai"; } CustomersBO aCustomersBO = new CustomersBO(); CustomerInfoEN aCustomers = new CustomerInfoEN(); aCustomers = new CustomerInfoEN (aCustomersBO.Select_ByID(aBookingRs.IDCustomer)); lblCustomer.Text = aCustomers.Name; lblTel.Text = aCustomers.Tel; CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO(); CustomerGroups aCustomerGroups = aCustomerGroupsBO.Select_ByID(aBookingRs.IDCustomerGroup); lblGroup.Text = aCustomerGroups.Name; CompaniesBO aCompaniesBO = new CompaniesBO(); lblCompany.Text = aCompaniesBO.Select_ByID(aCustomerGroups.IDCompany).Name; // Fill All Customer dgvAvailableCustomers.DataSource = ConvertListCustomer ((new CustomersBO()).Select_All()); lueRooms.Properties.DataSource = this.GetAvaiableRoom(); lueRooms.Properties.ValueMember = "Code"; lueRooms.Properties.DisplayMember = "Sku"; RoomsBO aRoomsBO = new RoomsBO(); Rooms aRooms = new Rooms(); aRooms = aRoomsBO.Select_ByCodeRoom(this.aBookingRoom.CodeRoom, 1); lueRooms.Properties.NullText = aRooms.Sku; lueRooms.SelectedText = aRooms.Sku; lueRooms.EditValue = aRooms.Code; BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO(); List<BookingRoomsMembers> aListBookingRoomsMembers = aBookingRoomsMembersBO.Select_ByIDBookingRoom (this.aBookingRoom.ID); dgvSelectCustomers.DataSource = GetCustomers(aListBookingRoomsMembers); //this.aChangeRoomEn.InsertItemChangeRooms() }
//Hiennv public List<BookingRStatusPayViewEN> GetListUnPayBookingR_ByIDBookingR(int IDBookingR) { List<vw__PaymentInfo__BookingRs_BookingRooms_Customers> aListTemp = new List<vw__PaymentInfo__BookingRs_BookingRooms_Customers>(); int?[] BookingRoomStatus = new int?[] { 3, 5, 7 }; aListTemp = aDatabaseDA.vw__PaymentInfo__BookingRs_BookingRooms_Customers.Where(c => c.BookingRs_ID == IDBookingR).Where(e => BookingRoomStatus.Contains(e.BookingRooms_Status)).ToList(); List<BookingRStatusPayViewEN> aListReturn = new List<BookingRStatusPayViewEN>(); BookingRStatusPayViewEN aBookingRStatusPayViewEN; CompaniesBO aCompaniesBO = new CompaniesBO(); for (int i = 0; i < aListTemp.Count; i++) { aBookingRStatusPayViewEN = new BookingRStatusPayViewEN(); aBookingRStatusPayViewEN.IDBookingR = aListTemp[i].BookingRs_ID; aBookingRStatusPayViewEN.CreatedDate = aListTemp[i].BookingRs_CreatedDate; aBookingRStatusPayViewEN.Customer_Name = aListTemp[i].Customers_Name; aBookingRStatusPayViewEN.Subject = aListTemp[i].BookingRs_Subject; aBookingRStatusPayViewEN.IDCustomer = aListTemp[i].Customers_ID; aBookingRStatusPayViewEN.IDCustomerGroup = aListTemp[i].CustomerGroups_ID; aBookingRStatusPayViewEN.BookingRs_Status = aListTemp[i].BookingRs_Status; int IDCompany = !String.IsNullOrEmpty(aListTemp[i].CustomerGroups_IDCompany.ToString()) ? Convert.ToInt32(aListTemp[i].CustomerGroups_IDCompany) : 0; Companies aCompanies = aCompaniesBO.Select_ByID(IDCompany); aBookingRStatusPayViewEN.NameCompany = aCompanies.Name; aBookingRStatusPayViewEN.CustomerGroups_Name = aListTemp[i].CustomerGroups_Name; aBookingRStatusPayViewEN.StatusPay = aListTemp[i].BookingRs_StatusPay; aBookingRStatusPayViewEN.BookingMoney = aListTemp[i].BookingRs_BookingMonye; aBookingRStatusPayViewEN.IDBookingRoom = aListTemp[i].BookingRooms_ID; aBookingRStatusPayViewEN.Sku = aListTemp[i].Rooms_Sku; aBookingRStatusPayViewEN.BookingStatus = aListTemp[i].BookingRooms_Status; aBookingRStatusPayViewEN.BookingRooms_CodeRoom = aListTemp[i].BookingRooms_CodeRoom; switch (aBookingRStatusPayViewEN.StatusPay) { case 1: aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Chưa thanh toán"; break; case 2: aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Tạm ứng"; break; case 3: aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Đã thanh toán"; break; default: aBookingRStatusPayViewEN.BookingRStatusPayDisplay = "Chưa xác định"; break; } switch (aBookingRStatusPayViewEN.BookingStatus) { case 3: aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Đã check in"; break; case 5: aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Pending"; break; case 7: aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Đã check out nhưng chưa thanh toán"; break; case 8: aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Đã thanh toán"; break; default: aBookingRStatusPayViewEN.BookingRoomStatusPayDisplay = "Chưa xác định"; break; } aListReturn.Add(aBookingRStatusPayViewEN); } return aListReturn; }
//======================================================= //Author: LinhTing //Function : Tìm danh sách phòng + hóa đơn đã đặt //======================================================= public List<BookingRStatusPayViewEN> GetListBookedBookingR_BookingRoom(DateTime From, DateTime To, int CustomerType, int BookingStatus) { List<vw__PaymentInfo__BookingRs_BookingRooms_Customers> aListTemp = new List<vw__PaymentInfo__BookingRs_BookingRooms_Customers>(); aListTemp = aDatabaseDA.vw__PaymentInfo__BookingRs_BookingRooms_Customers.ToList().Where(a => a.BookingRs_CreatedDate > From).Where(b => b.BookingRs_CreatedDate < To).Where(c => c.BookingRooms_Status == BookingStatus).Where(d => d.BookingRs_CustomerType == CustomerType).ToList(); List<BookingRStatusPayViewEN> aListReturn = new List<BookingRStatusPayViewEN>(); BookingRStatusPayViewEN aBookingRStatusPayViewEN = new BookingRStatusPayViewEN(); CompaniesBO aCompaniesBO = new CompaniesBO(); for (int i = 0; i < aListTemp.Count; i++) { aBookingRStatusPayViewEN = new BookingRStatusPayViewEN(); aBookingRStatusPayViewEN.IDBookingR = aListTemp[i].BookingRs_ID; aBookingRStatusPayViewEN.CreatedDate = aListTemp[i].BookingRs_CreatedDate; aBookingRStatusPayViewEN.Customer_Name = aListTemp[i].Customers_Name; aBookingRStatusPayViewEN.Subject = aListTemp[i].BookingRs_Subject; aBookingRStatusPayViewEN.IDCustomer = aListTemp[i].Customers_ID; aBookingRStatusPayViewEN.IDCustomerGroup = aListTemp[i].CustomerGroups_ID; int IDCompany = !String.IsNullOrEmpty(aListTemp[i].CustomerGroups_IDCompany.ToString()) ? Convert.ToInt32(aListTemp[i].CustomerGroups_IDCompany) : 0; Companies aCompanies = aCompaniesBO.Select_ByID(IDCompany); aBookingRStatusPayViewEN.NameCompany = aCompanies.Name; aBookingRStatusPayViewEN.CustomerGroups_Name = aListTemp[i].CustomerGroups_Name; aBookingRStatusPayViewEN.StatusPay = aListTemp[i].BookingRs_StatusPay; aBookingRStatusPayViewEN.BookingMoney = aListTemp[i].BookingRs_BookingMonye; aBookingRStatusPayViewEN.IDBookingRoom = aListTemp[i].BookingRooms_ID; aBookingRStatusPayViewEN.Sku = aListTemp[i].Rooms_Sku; aBookingRStatusPayViewEN.BookingStatus = aListTemp[i].BookingRooms_Status; aListReturn.Add(aBookingRStatusPayViewEN); } return aListReturn; }