//Hiennv 26/11/2014 public frmTsk_CheckInForRoomBooking(frmTsk_ListBookingRs afrmTsk_ListBookingRs, int IDBookingR, DateTime CheckoutPlan) { InitializeComponent(); this.afrmTsk_ListBookingRs = afrmTsk_ListBookingRs; this.IDBookingR = IDBookingR; this.CheckoutPlan = CheckoutPlan; this.aCheckInEN = this.InitData(this.IDBookingR); }
public frmTsk_CheckIn_Goverment_Step3(frmTsk_CheckIn_Goverment_Step2 afrmTsk_CheckIn_Goverment_Step2, CheckInEN aCheckInEN) { InitializeComponent(); this.afrmTsk_CheckIn_Goverment_Step2 = afrmTsk_CheckIn_Goverment_Step2; this.aCheckInEN = aCheckInEN; CustomersBO aCustomersBO = new CustomersBO(); this.aListCustomers = aCustomersBO.SelectListCustomer_ByIDCustomerGroups(aCheckInEN.IDCustomerGroup); }
public frmTsk_CheckIn_Customer_Step2(frmTsk_CheckIn_Customer_Step1 afrm_Tsk_CheckIn_Customer_Step1, CheckInEN aCheckInEN) { InitializeComponent(); afrm_Tsk_CheckIn_Customer_Step1_Old = afrm_Tsk_CheckIn_Customer_Step1; aCheckInEN_Old = aCheckInEN; }
public frmTsk_CheckIn_Goverment_Step2(frmTsk_CheckIn_Goverment_Step1 afrmTsk_CheckIn_Goverment_Step1, CheckInEN aCheckInEn) { InitializeComponent(); this.afrmTsk_CheckIn_Goverment_Step1 = afrmTsk_CheckIn_Goverment_Step1; this.aCheckInEN = aCheckInEn; }
public frmTsk_CheckIn_Group_Step2(frmTsk_CheckIn_Group_Step1 afrmTsk_CheckIn_Group_Step1, CheckInEN aCheckInEN) { InitializeComponent(); this.afrmTsk_CheckIn_Group_Step1 = afrmTsk_CheckIn_Group_Step1; this.aCheckInEN = aCheckInEN; }
//Hiennv 26/11/2014 ham dung de load toan bo du lieu theo IDBookingR public CheckInEN InitData(int IDBookingR) { try { CheckInEN aCheckInEN = new CheckInEN(); BookingRsBO aBookingRsBO = new BookingRsBO(); BookingRs aBookingRs = new BookingRs(); aBookingRs = aBookingRsBO.Select_ByID(IDBookingR); if(aBookingRs != null) { aCheckInEN.IDBookingR = aBookingRs.ID; aCheckInEN.CustomerType = aBookingRs.CustomerType.GetValueOrDefault(); aCheckInEN.BookingType = aBookingRs.BookingType.GetValueOrDefault(); aCheckInEN.Note = aBookingRs.Note; aCheckInEN.IDCustomerGroup = aBookingRs.IDCustomerGroup; aCheckInEN.IDCustomer = aBookingRs.IDCustomer; aCheckInEN.IDSystemUser = aBookingRs.IDSystemUser; aCheckInEN.PayMenthod = aBookingRs.PayMenthod.GetValueOrDefault(); aCheckInEN.StatusPay = aBookingRs.StatusPay.GetValueOrDefault(); aCheckInEN.BookingMoney = aBookingRs.BookingMoney.GetValueOrDefault(); aCheckInEN.ExchangeRate = aBookingRs.ExchangeRate.GetValueOrDefault(); aCheckInEN.Status = aBookingRs.Status.GetValueOrDefault(); aCheckInEN.Type = aBookingRs.Type.GetValueOrDefault(); aCheckInEN.Disable = aBookingRs.Disable.GetValueOrDefault(); aCheckInEN.Level = aBookingRs.Level; aCheckInEN.Subject = aBookingRs.Subject; aCheckInEN.Description = aBookingRs.Description; aCheckInEN.DatePay = aBookingRs.DatePay; aCheckInEN.DateEdit = aBookingRs.DateEdit; CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO(); CustomerGroups aCustomerGroups = new CustomerGroups(); aCustomerGroups = aCustomerGroupsBO.Select_ByID(aBookingRs.IDCustomerGroup); if(aCustomerGroups !=null) { aCheckInEN.IDCompany = aCustomerGroups.IDCompany; } } RoomsBO aRoomsBO = new RoomsBO(); List<Rooms> aListRooms = new List<Rooms>(); aListRooms = aRoomsBO.Select_All(); BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO(); List<BookingRooms> aListBookingRooms = new List<BookingRooms>(); aListBookingRooms = aBookingRoomsBO.Select_ByIDBookingRs(IDBookingR); for (int i = 0; i < aListBookingRooms.Count; i++ ) { RoomMemberEN aRoomMemberEN = new RoomMemberEN(); aRoomMemberEN.IDBookingRooms = aListBookingRooms[i].ID; aRoomMemberEN.RoomCode = aListBookingRooms[i].CodeRoom; aRoomMemberEN.RoomSku = aCheckInEN.GetInfoRooms(aListRooms, aListBookingRooms[i].CodeRoom).Sku; aRoomMemberEN.RoomType = aCheckInEN.GetInfoRooms(aListRooms, aListBookingRooms[i].CodeRoom).Type.GetValueOrDefault(); aRoomMemberEN.RoomTypeDisplay = CORE.CONSTANTS.SelectedRoomsType(aCheckInEN.GetInfoRooms(aListRooms, aListBookingRooms[i].CodeRoom).Type.GetValueOrDefault()).Name; aRoomMemberEN.RoomBed1 = aCheckInEN.GetInfoRooms(aListRooms, aListBookingRooms[i].CodeRoom).Bed1.GetValueOrDefault(); aRoomMemberEN.RoomBed2 = aCheckInEN.GetInfoRooms(aListRooms, aListBookingRooms[i].CodeRoom).Bed2.GetValueOrDefault(); aRoomMemberEN.RoomCostRef = aCheckInEN.GetInfoRooms(aListRooms, aListBookingRooms[i].CodeRoom).CostRef.GetValueOrDefault(); aRoomMemberEN.RoomCost = aListBookingRooms[i].Cost.GetValueOrDefault(); aCheckInEN.InsertRoom(aRoomMemberEN); } return aCheckInEN; } catch (Exception ex) { MessageBox.Show("frmTsk_CheckInForRoomBooking.InitData()\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); return null; } }
public bool CheckIn(CheckInEN aCheckInEN) { try { //======================================================== BookingRs aBookingRs = new BookingRs(); aBookingRs.CreatedDate = DateTime.Now; aBookingRs.CustomerType = aCheckInEN.CustomerType; aBookingRs.BookingType = aCheckInEN.BookingType; aBookingRs.Note = aCheckInEN.Note; aBookingRs.IDCustomerGroup = aCheckInEN.IDCustomerGroup; aBookingRs.IDCustomer = aCheckInEN.IDCustomer; aBookingRs.IDSystemUser = aCheckInEN.IDSystemUser; aBookingRs.PayMenthod = aCheckInEN.PayMenthod; aBookingRs.StatusPay = aCheckInEN.StatusPay; aBookingRs.BookingMoney = aCheckInEN.BookingMoney; aBookingRs.ExchangeRate = aCheckInEN.ExchangeRate; aBookingRs.Status = aCheckInEN.Status; aBookingRs.Type = aCheckInEN.Type; aBookingRs.Disable = aCheckInEN.Disable; aBookingRs.Level = aCheckInEN.Level; aBookingRs.Subject = aCheckInEN.Subject; aBookingRs.Description = aCheckInEN.Description; aBookingRs.DatePay = aCheckInEN.DatePay; aBookingRs.DateEdit = aCheckInEN.DateEdit; //add new bookingRs BookingRsBO aBookingRsBO = new BookingRsBO(); aBookingRsBO.Insert(aBookingRs); int IDBookingR = aBookingRs.ID; //========================================================== BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO(); BookingRooms aBookingRooms; BookingRoomsMembers aBookingRoomsMembers; for (int i = 0; i < aCheckInEN.aListRoomMembers.Count; i++) { aBookingRooms = new BookingRooms(); aBookingRooms.IDBookingR = IDBookingR; aBookingRooms.CodeRoom = aCheckInEN.aListRoomMembers[i].RoomCode; aBookingRooms.PercentTax = 10; aBookingRooms.CostRef_Rooms = aCheckInEN.aListRoomMembers[i].RoomCostRef; aBookingRooms.Cost = aCheckInEN.aListRoomMembers[i].RoomCostRef; aBookingRooms.CheckInPlan = aCheckInEN.CheckInActual; aBookingRooms.CheckInActual = aCheckInEN.CheckInActual; aBookingRooms.CheckOutPlan = aCheckInEN.CheckOutPlan; aBookingRooms.CheckOutActual = aCheckInEN.CheckOutActual; aBookingRooms.StartTime = aCheckInEN.CheckInActual; aBookingRooms.EndTime = aCheckInEN.CheckOutPlan; aBookingRooms.BookingStatus = 1; aBookingRooms.Type = 3; //Tính CheckIn sớm và CheckOut muộn aBookingRooms.Status = aCheckInEN.Status; aBookingRooms.PriceType = "G1"; //add new bookingRoom aBookingRoomsBO.Insert(aBookingRooms); int IDBookingRooms = aBookingRooms.ID; aCheckInEN.aListRoomMembers[i].IDBookingRooms = IDBookingRooms; //----------------------------------------------------------- aBookingRoomsMembers = new BookingRoomsMembers(); aBookingRoomsMembers.IDBookingRoom = aCheckInEN.aListRoomMembers[i].IDBookingRooms; BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO(); for (int ii = 0; ii < aCheckInEN.aListRoomMembers[i].ListCustomer.Count; ii++) { aBookingRoomsMembers.IDCustomer = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].ID; aBookingRoomsMembers.PurposeComeVietnam = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].PurposeComeVietnam; aBookingRoomsMembers.DateEnterCountry = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].DateEnterCountry; aBookingRoomsMembers.EnterGate = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].EnterGate; aBookingRoomsMembers.TemporaryResidenceDate = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].TemporaryResidenceDate; aBookingRoomsMembers.LimitDateEnterCountry = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].LimitDateEnterCountry; aBookingRoomsMembers.Organization = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Organization; aBookingRoomsMembers.LeaveDate = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].LeaveDate; //add new bookingRoomMember aBookingRoomsMembersBO.Insert(aBookingRoomsMembers); } } return true; } catch (Exception ex) { throw new Exception("ReceptionTaskBO.CheckInGoverment\n" + ex.ToString()); } }
//Hiennv 26/11/2014 Viet lai phuong thuc checkInForRoomBooking public bool NewCheckInForRoomBooking(CheckInEN aCheckInEN) { try { CustomersBO aCustomersBO = new CustomersBO(); List<Customers> aListCustomersTemp = aCustomersBO.Select_All(); BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO(); List<BookingRooms> aListBookingRoomTemp = aBookingRoomsBO.Select_All(); int IDBookingRooms = 0; int IDCompany = 0; int IDCustomerGroup = 0; int IDCustomer = 0; int Result = 0; string customerType = string.Empty; if (aCheckInEN.CustomerType == 0) { customerType = "Tất cả loại khác"; } else if (aCheckInEN.CustomerType == 1) { customerType = "Khách nhà nước"; } else if (aCheckInEN.CustomerType == 2) { customerType = "Khách đoàn"; } else if (aCheckInEN.CustomerType == 3) { customerType = "Khách lẻ"; } else if (aCheckInEN.CustomerType == 4) { customerType = "Khách vãng lai"; } else if (aCheckInEN.CustomerType == 5) { customerType = "Khách bộ ngoại giao"; } else { customerType = string.Empty; } #region Them moi cong ty khi cong ty chua co if (aCheckInEN.IDCompany > 0) { IDCompany = aCheckInEN.IDCompany; } else { CompaniesBO aCompaniesBO = new CompaniesBO(); Companies aCompanies = new Companies(); if (aCheckInEN.NameCompany.Length > 250) { aCompanies.Name = aCheckInEN.NameCompany.Substring(0, 250); } else { aCompanies.Name = aCheckInEN.NameCompany; } aCompanies.TaxNumberCode = string.Empty; aCompanies.Address = string.Empty; aCompanies.Type = aCheckInEN.CustomerType; aCompanies.Status = 1; aCompanies.Disable = false; IDCompany = aCompaniesBO.Insert(aCompanies); } #endregion #region Them moi nhom vao trong cong ty CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO(); CustomerGroups aCustomerGroups; aCustomerGroups = aCustomerGroupsBO.Select_ByIDCompanyAndIDCustomerGroup(IDCompany, aCheckInEN.IDCustomerGroup); if (aCustomerGroups == null) { aCustomerGroups = new CustomerGroups(); string nameGroup = "[" + customerType + "][" + aCheckInEN.NameCompany + "][" + DateTime.Now.ToString() + "]"; aCustomerGroups.IDCompany = IDCompany; if (nameGroup.Length > 250) { aCustomerGroups.Name = nameGroup.Substring(0, 250); } else { aCustomerGroups.Name = nameGroup; } aCustomerGroups.Type = 1; aCustomerGroups.Status = 1; aCustomerGroups.Disable = false; IDCustomerGroup = aCustomerGroupsBO.Insert(aCustomerGroups); } else { IDCustomerGroup = aCheckInEN.IDCustomerGroup; } #endregion string subject = "[" + customerType + "][" + aCheckInEN.NameCompany + "][" + DateTime.Now.ToString() + "]"; BookingRsBO aBookingRsBO = new BookingRsBO(); BookingRs aBookingRs = aBookingRsBO.Select_ByID(aCheckInEN.IDBookingR); if (aBookingRs != null) { aBookingRs.CreatedDate = DateTime.Now; aBookingRs.CustomerType = aCheckInEN.CustomerType; aBookingRs.BookingType = aCheckInEN.BookingType; if (subject.Length > 250) { aBookingRs.Subject = subject.Substring(0, 250); } else { aBookingRs.Subject = subject; } aBookingRs.IDCustomerGroup = IDCustomerGroup; aBookingRs.IDCustomer = aCheckInEN.IDCustomer; aBookingRs.IDSystemUser = aCheckInEN.IDSystemUser; aBookingRs.PayMenthod = aCheckInEN.PayMenthod; aBookingRs.StatusPay = aCheckInEN.StatusPay; aBookingRs.BookingMoney = aCheckInEN.BookingMoney; aBookingRs.ExchangeRate = aCheckInEN.ExchangeRate; aBookingRs.Level = 0;// de mac dinh hien tai chua dung den aBookingRs.Note = string.Empty; aBookingRs.Description = string.Empty; aBookingRs.DatePay = aCheckInEN.CheckOutPlan; aBookingRs.DateEdit = aCheckInEN.CheckInActual; aBookingRs.Status = aCheckInEN.Status; aBookingRs.Type = aCheckInEN.Type; aBookingRs.Disable = aCheckInEN.Disable; aBookingRsBO.Update(aBookingRs); } //========================================================== BookingRooms aBookingRooms; BookingRoomsMembers aBookingRoomsMembers; for (int i = 0; i < aCheckInEN.aListRoomMembers.Count; i++) { List<BookingRooms> aListBookingRoom = aListBookingRoomTemp.Where(r => r.ID == aCheckInEN.aListRoomMembers[i].IDBookingRooms).ToList(); if (aListBookingRoom.Count > 0) { aBookingRooms = new BookingRooms(); aBookingRooms = aListBookingRoom[0]; aBookingRooms.IDBookingR = aCheckInEN.IDBookingR; aBookingRooms.CodeRoom = aCheckInEN.aListRoomMembers[i].RoomCode; aBookingRooms.PercentTax = 10; aBookingRooms.CostRef_Rooms = aCheckInEN.aListRoomMembers[i].RoomCostRef; aBookingRooms.Cost = aCheckInEN.aListRoomMembers[i].RoomCostRef; aBookingRooms.CheckInPlan = aCheckInEN.CheckInActual; aBookingRooms.CheckInActual = aCheckInEN.CheckInActual; aBookingRooms.CheckOutPlan = aCheckInEN.CheckOutPlan; aBookingRooms.CheckOutActual = aCheckInEN.CheckOutActual; aBookingRooms.StartTime = aCheckInEN.CheckInActual; aBookingRooms.EndTime = aCheckInEN.CheckOutPlan; aBookingRooms.BookingStatus = 1; aBookingRooms.Type = 3; //Tính CheckIn sớm và CheckOut muộn aBookingRooms.Status = aCheckInEN.Status; aBookingRooms.PriceType = "G1"; aBookingRoomsBO.Update(aBookingRooms); IDBookingRooms = aCheckInEN.aListRoomMembers[i].IDBookingRooms; } else { aBookingRooms = new BookingRooms(); aBookingRooms.IDBookingR = aCheckInEN.IDBookingR; aBookingRooms.CodeRoom = aCheckInEN.aListRoomMembers[i].RoomCode; aBookingRooms.PercentTax = 10; aBookingRooms.CostRef_Rooms = aCheckInEN.aListRoomMembers[i].RoomCostRef; aBookingRooms.Cost = aCheckInEN.aListRoomMembers[i].RoomCostRef; aBookingRooms.CheckInPlan = aCheckInEN.CheckInActual; aBookingRooms.CheckInActual = aCheckInEN.CheckInActual; aBookingRooms.CheckOutPlan = aCheckInEN.CheckOutPlan; aBookingRooms.CheckOutActual = aCheckInEN.CheckOutActual; aBookingRooms.StartTime = aCheckInEN.CheckInActual; aBookingRooms.EndTime = aCheckInEN.CheckOutPlan; aBookingRooms.BookingStatus = 1; aBookingRooms.Type = 3; //Tính CheckIn sớm và CheckOut muộn aBookingRooms.Status = aCheckInEN.Status; aBookingRooms.PriceType = "G1"; //add new bookingRoom IDBookingRooms = aBookingRoomsBO.Insert(aBookingRooms); } //----------------------------------------------------------- aBookingRoomsMembers = new BookingRoomsMembers(); aBookingRoomsMembers.IDBookingRoom = IDBookingRooms; BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO(); for (int ii = 0; ii < aCheckInEN.aListRoomMembers[i].ListCustomer.Count; ii++) { Customers aCustomers; List<Customers> aListCustomers = aListCustomersTemp.Where(c => c.ID == aCheckInEN.aListRoomMembers[i].ListCustomer[ii].ID).ToList(); if (aListCustomers.Count > 0) { IDCustomer = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].ID; aCustomers = aListCustomers[0]; aCustomers.Name = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Name; aCustomers.Identifier1 = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Identifier1; aCustomers.Birthday = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Birthday; aCustomers.Gender = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Gender; aCustomers.Tel = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Tel; aCustomers.Nationality = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Nationality; aCustomersBO.Update(aCustomers); } else { aCustomers = new Customers(); aCustomers.Name = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Name; aCustomers.Identifier1 = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Identifier1; aCustomers.Birthday = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Birthday; aCustomers.Gender = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Gender; aCustomers.Tel = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Tel; aCustomers.Nationality = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Nationality; //Them moi khach hang IDCustomer = aCustomersBO.Insert(aCustomers); } aBookingRoomsMembers.IDCustomer = IDCustomer; aBookingRoomsMembers.PurposeComeVietnam = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].PurposeComeVietnam; aBookingRoomsMembers.DateEnterCountry = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].DateEnterCountry; aBookingRoomsMembers.EnterGate = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].EnterGate; aBookingRoomsMembers.TemporaryResidenceDate = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].TemporaryResidenceDate; aBookingRoomsMembers.LimitDateEnterCountry = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].LimitDateEnterCountry; aBookingRoomsMembers.Organization = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Organization; aBookingRoomsMembers.LeaveDate = aCheckInEN.aListRoomMembers[i].ListCustomer[ii].LeaveDate; //add new bookingRoomMember aBookingRoomsMembersBO.Insert(aBookingRoomsMembers); #region them nguoi vao trong customergroup_customer string nameCustomerGroup_customer = "[" + customerType + "][" + aCheckInEN.aListRoomMembers[i].ListCustomer[ii].Name + "]"; CustomerGroups_CustomersBO aCustomerGroups_CustomersBO = new CustomerGroups_CustomersBO(); CustomerGroups_Customers aCustomerGroups_Customers = new CustomerGroups_Customers(); if (nameCustomerGroup_customer.Length > 150) { aCustomerGroups_Customers.Name = nameCustomerGroup_customer.Substring(0, 150); } else { aCustomerGroups_Customers.Name = nameCustomerGroup_customer; } aCustomerGroups_Customers.Type = 1; aCustomerGroups_Customers.Status = 1; aCustomerGroups_Customers.Disable = false; aCustomerGroups_Customers.FromDate = DateTime.Now; aCustomerGroups_Customers.ToDate = DateTime.Now; aCustomerGroups_Customers.IDCustomer = IDCustomer; aCustomerGroups_Customers.IDCustomerGroup = IDCustomerGroup; aCustomerGroups_CustomersBO.Insert(aCustomerGroups_Customers); #endregion // dung de cap nhap lai nguoi dai dien khi dat phong if (aCheckInEN.aListRoomMembers[i].ListCustomer[ii].PepoleRepresentative == true) { aBookingRsBO = new BookingRsBO(); aBookingRs = new BookingRs(); aBookingRs = aBookingRsBO.Select_ByID(aCheckInEN.IDBookingR); if (aBookingRs != null) { aBookingRs.IDCustomer = IDCustomer; Result = aBookingRsBO.Update(aBookingRs); } } else { if (ii == (aCheckInEN.aListRoomMembers[i].ListCustomer.Count - 1)) { if (Result == 0) { aBookingRsBO = new BookingRsBO(); aBookingRs = new BookingRs(); aBookingRs = aBookingRsBO.Select_ByID(aCheckInEN.IDBookingR); if (aBookingRs != null) { aBookingRs.IDCustomer = IDCustomer; aBookingRsBO.Update(aBookingRs); } } } } } } return true; } catch (Exception ex) { return false; } }