//Lingting - Tự động thêm khách hàng và đưa vào nhóm public int AutoInsertCustomer(string Name, int IDCustomerGroup, string Tel,DateTime FromDate) { try { Customers aCustomer = new Customers(); aCustomer.Name = Name; aCustomer.Tel = Tel; aCustomer.Disable = false; this.Insert(aCustomer); CustomerGroups_CustomersBO aCustomerGroups_CustomersBO = new CustomerGroups_CustomersBO(); aCustomerGroups_CustomersBO.AutoInsertCustomerToGroup(aCustomer.ID, IDCustomerGroup, FromDate); return aCustomer.ID; } catch (Exception ex) { return 0; throw new Exception("CustomersBO.AutoInsertCustomer:" + ex.ToString()); } }
private void btnBook_Click(object sender, EventArgs e) { try { ReceptionTaskBO aReceptionTaskBO = new ReceptionTaskBO(); if (this.ValidateData() == true) { //Truyền dữ liệu BookingH this.aNewBookingHEN.Subject = txtSubject.Text; this.aNewBookingHEN.CreatedDate = dtpFrom.DateTime; this.aNewBookingHEN.CustomerType = this.CustomerType; this.aNewBookingHEN.BookingType = 3;//3 : Đặt trực tiếp if (txtBookingMoney.Text == "") { this.aNewBookingHEN.BookingMoney = 0; this.aNewBookingHEN.StatusPay = 1;//1 : Trạng thái chưa thanh toán } else { this.aNewBookingHEN.BookingMoney = this.aNewBookingHEN.BookingMoney = Convert.ToDecimal(txtBookingMoney.Text); this.aNewBookingHEN.StatusPay = 2;//2 : Trạng thái tạm ứng } this.aNewBookingHEN.Status = 2;//2: Trạng thái đã xác thực this.aNewBookingHEN.PayMenthod = 1; if (cbbType.EditValue.ToString().ToUpper() == "NGOÀI NẤU") { this.aNewBookingHEN.Type = 1;//1: Tiệc KHÔNG thuộc phạm trù bếp } else if (cbbType.EditValue.ToString().ToUpper() == "BẾP NẤU") { this.aNewBookingHEN.Type = 2;//2: Tiệc thuộc phạm trù bếp } this.aNewBookingHEN.Disable = false; this.aNewBookingHEN.Description = ""; string CustomerGroupName; if (Convert.ToInt32(lueCompany.EditValue) == 0) { this.IDCompany = this.aCompaniesBO.AutoInsertCompany(txtCompanyName.Text, 3);// 3 : Loại khách lẻ if (lueCustomer.Text == "") { if (txtSubject.Text == "") { CustomerGroupName = "[" + txtCompanyName.Text + "][" + DateTime.Now.ToShortDateString() + "]" + "[" + txtCustomerName.Text + "]"; } else { CustomerGroupName = txtSubject.Text; } } else { if (txtSubject.Text == "") { CustomerGroupName = "[" + txtCompanyName.Text + "][" + DateTime.Now.ToShortDateString() + "]" + "[" + lueCustomer.Text + "]"; } else { CustomerGroupName = txtSubject.Text; } } this.IDCustomerGroup = this.aCustomerGroupsBO.AutoInsertCustomerGroup(CustomerGroupName, IDCompany); } else { this.IDCompany = Convert.ToInt32(lueCompany.EditValue); if (lueCustomer.Text == "") { if (txtSubject.Text == "") { CustomerGroupName = "[" + txtCompanyName.Text + "][" + DateTime.Now.ToShortDateString() + "]" + "[" + txtCustomerName.Text + "]"; } else { CustomerGroupName = txtSubject.Text; } } else { if (txtSubject.Text == "") { CustomerGroupName = "[" + txtCompanyName.Text + "][" + DateTime.Now.ToShortDateString() + "]" + "[" + lueCustomer.Text + "]"; } else { CustomerGroupName = txtSubject.Text; } } this.IDCustomerGroup = this.aCustomerGroupsBO.AutoInsertCustomerGroup(CustomerGroupName, Convert.ToInt32(lueCompany.EditValue)); } if (Convert.ToInt32(lueCustomer.EditValue) == 0) { this.IDCustomer = this.aCustomersBO.AutoInsertCustomer(txtCustomerName.Text, this.IDCustomerGroup, txtPhoneNumber.Text, DateTime.Now); } else { CustomerGroups_CustomersBO aCustomerGroups_CustomersBO = new CustomerGroups_CustomersBO(); this.IDCustomer = Convert.ToInt32(lueCustomer.EditValue); aCustomerGroups_CustomersBO.AutoInsertCustomerToGroup(IDCustomer, this.IDCustomerGroup, dtpFrom.DateTime); } this.aNewBookingHEN.Disable = false; this.aNewBookingHEN.IDCustomer = this.IDCustomer; this.aNewBookingHEN.IDSystemUser = CORE.CURRENTUSER.SystemUser.ID; this.aNewBookingHEN.IDCustomerGroup = this.IDCustomerGroup; //=============================================================================== // Ngoc edit. All BookingR and BookingH join together // Tao them 1 bookingR neu chua co //=============================================================================== if (this.IDBookingR == 0) { BookingRsBO aBookingRsBO = new BookingRsBO(); BookingRs aBookingRs = new BookingRs(); aBookingRs.CreatedDate = this.aNewBookingHEN.CreatedDate; aBookingRs.ID = 0; aBookingRs.CustomerType = this.aNewBookingHEN.CustomerType; aBookingRs.IDCustomer = this.aNewBookingHEN.IDCustomer; aBookingRs.IDCustomerGroup = this.aNewBookingHEN.IDCustomerGroup; aBookingRs.DatePay = Convert.ToDateTime("01/01/1900"); aBookingRs.DateEdit = Convert.ToDateTime("01/01/1900"); aBookingRs.IDSystemUser = this.aNewBookingHEN.IDSystemUser; aBookingRs.Type = 0; aBookingRs.Status = 0; aBookingRs.Disable = true; aBookingRs.Level = -1; this.IDBookingR = aBookingRsBO.Insert(aBookingRs); } //=============================================================================== this.IDBookingH = aReceptionTaskBO.NewBookHall(this.aNewBookingHEN); if (this.IDBookingR != 0) { BookingRs_BookingHsBO aBookingRs_BookingHsBO = new BookingRs_BookingHsBO(); BookingRs_BookingHs aBookingRs_BookingHs = new BookingRs_BookingHs(); aBookingRs_BookingHs.IDBookingR = this.IDBookingR; aBookingRs_BookingHs.IDBookingH = this.IDBookingH; aBookingRs_BookingHs.Type = String.Empty; aBookingRs_BookingHs.Status = String.Empty; aBookingRs_BookingHs.Disable = false; aBookingRs_BookingHs.Extension1 = String.Empty; aBookingRs_BookingHs.Extension2 = String.Empty; aBookingRs_BookingHs.Extension3 = String.Empty; aBookingRs_BookingHsBO.Insert(aBookingRs_BookingHs); } MessageBox.Show("Đặt hội trường thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); if (afrmMain_Halls != null) { this.afrmMain_Halls.Reload(); } if (afrmTsk_Payment_Step2 != null) { this.afrmTsk_Payment_Step2.Reload(); } this.Close(); } } catch (Exception ex) { MessageBox.Show("frmTsk_BookingHall_Customer_New.btnBook_Click\n" + ex.ToString(), "Error ", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
// Ngoc public int InsertCustomerIntoCustomerGroup_ByIDBookingRs(int IDCustomer, int IDBookingRs) { // Add customer vao group CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO(); CustomerGroups aCustomerGroups = new CustomerGroups(); aCustomerGroups = aCustomerGroupsBO.Select_ByIDBookingR(IDBookingRs); CustomerGroups_CustomersBO aCustomerGroups_CustomersBO = new CustomerGroups_CustomersBO(); //Kiem tra xe khach do da co trong custome group chua CustomerGroups_Customers aCustomerGroups_Customers = new CustomerGroups_Customers(); aCustomerGroups_Customers = aCustomerGroups_CustomersBO.Select_ByIDCustomer_ByIDCustomerGroup(IDCustomer, aCustomerGroups.ID); if (aCustomerGroups_Customers == null) { aCustomerGroups_Customers = new CustomerGroups_Customers(); Customers aCustomers = (new CustomersBO()).Select_ByID(IDCustomer); aCustomerGroups_Customers.IDCustomer = IDCustomer; aCustomerGroups_Customers.IDCustomerGroup = aCustomerGroups.ID; aCustomerGroups_Customers.Name = aCustomerGroups.Name + "_" + aCustomers.Name + "_" + aCustomers.Identifier1 + "_" + DateTime.Now.ToShortDateString(); return aCustomerGroups_CustomersBO.Insert(aCustomerGroups_Customers); } else { return 0; } }
public int DeleteCustomerFromCustomerGroup_ByIDBookingRs(int IDCustomer, int IDBookingRs) { CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO(); CustomerGroups aCustomerGroups = new CustomerGroups(); aCustomerGroups = aCustomerGroupsBO.Select_ByIDBookingR(IDBookingRs); CustomerGroups_CustomersBO aCustomerGroups_CustomersBO = new CustomerGroups_CustomersBO(); return aCustomerGroups_CustomersBO.Delete(IDCustomer, aCustomerGroups.ID); }
private void btnDeleteCus_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { if (this.IsLockForm == false) { if (this.aNewPaymentEN.aListBookingRoomUsed.Where(a => a.ID == this.CurrentIDBookingRoom).ToList()[0].ListCustomer.Count == 1) { MessageBox.Show("Không thể xóa", "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { DialogResult result = MessageBox.Show("Xóa khách khỏi phòng. Tiếp tục?", "Xóa khách", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO(); int IDCustomer = Convert.ToInt32(viewCustomers.GetFocusedRowCellValue("ID")); aBookingRoomsMembersBO.Delete(this.CurrentIDBookingRoom, IDCustomer); MessageBox.Show("Thực hiện thành công!", "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Reload(); txtBookingRoomsCost.Text = aAccountancyBO.CalculateCostRoom(this.CurrentIDBookingRoom, cbbPriceType.Text, this.aNewPaymentEN.CustomerType.GetValueOrDefault(0), aNewPaymentEN.GetNumberCustomerInRoom(this.CurrentIDBookingRoom)).GetValueOrDefault(0).ToString(); CustomerGroups_CustomersBO aCustomerGroups_CustomersBO = new CustomerGroups_CustomersBO(); aCustomerGroups_CustomersBO.DeleteCustomerFromCustomerGroup_ByIDBookingRs(IDCustomer, this.IDBookingR); } } } else { MessageBox.Show("Không thực hiện được chức năng này do form đang chế độ khóa"); } }
public int InsertCustomerIntoCustomerGroup(int IDCustomer, int IDCustomerGroup) { // Add customer vao group CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO(); CustomerGroups aCustomerGroups = new CustomerGroups(); aCustomerGroups = aCustomerGroupsBO.Select_ByID(IDCustomerGroup); CustomerGroups_CustomersBO aCustomerGroups_CustomersBO = new CustomerGroups_CustomersBO(); CustomerGroups_Customers aCustomerGroups_Customers = new CustomerGroups_Customers(); aCustomerGroups_Customers = aCustomerGroups_CustomersBO.Select_ByIDCustomer_ByIDCustomerGroup(IDCustomer, IDCustomerGroup); if (aCustomerGroups_Customers == null) { Customers aCustomers = (new CustomersBO()).Select_ByID(IDCustomer); aCustomerGroups_Customers.IDCustomer = IDCustomer; aCustomerGroups_Customers.IDCustomerGroup = aCustomerGroups.ID; aCustomerGroups_Customers.Name = aCustomerGroups.Name + "_" + aCustomers.Name + "_" + aCustomers.Identifier1 + "_" + DateTime.Now.ToShortDateString(); return aCustomerGroups_CustomersBO.Insert(aCustomerGroups_Customers); } else return 0; }
private void btnUpdate_Click(object sender, EventArgs e) { BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO(); BookingRoomsMembers aBookingRoomsMembers = new BookingRoomsMembers(); DateTime? dateTime = null; CustomersBO aCustomersBO = new CustomersBO(); Customers aCustomers = new Customers(); //Update if (this.IDCustomer > 0) { aCustomers = aCustomersBO.Select_ByID(IDCustomer); } else { aCustomers = new Customers(); } aCustomers.Address = txtAddress.Text; aCustomers.Birthday = String.IsNullOrEmpty(dtpBirthday.Text) ? dateTime : dtpBirthday.DateTime; aCustomers.Citizen = Convert.ToInt32(lueCitizen.EditValue); aCustomers.Email = txtEmail.Text; aCustomers.Gender = lueGender.EditValue.ToString(); aCustomers.Identifier1 = txtIdentifier1.Text; aCustomers.Identifier2 = txtIdentifier2.Text; aCustomers.Identifier3 = txtIdentifier3.Text; aCustomers.Name = txtNames.Text; aCustomers.Nationality = lueNationality.EditValue.ToString(); aCustomers.Tel = txtTel.Text; if (this.IDCustomer > 0) { aCustomersBO.Update(aCustomers); } else { this.IDCustomer = aCustomersBO.Insert(aCustomers); } /*Insert nguoi moi vao group*/ CustomerGroups_CustomersBO aCustomerGroups_CustomersBO = new CustomerGroups_CustomersBO(); aCustomerGroups_CustomersBO.InsertCustomerIntoCustomerGroup_ByIDBookingRs(this.IDCustomer, (new BookingRsBO()).Select_ByIDBookingRoom(this.IDBookingRoom).ID); /*--------------------------*/ aBookingRoomsMembers = aBookingRoomsMembersBO.Select_ByIDBookingRoom_ByIDCustomer(this.IDBookingRoom, this.IDCustomer); if (aBookingRoomsMembers == null) { aBookingRoomsMembers = new BookingRoomsMembers(); aBookingRoomsMembers.IDBookingRoom = this.IDBookingRoom; aBookingRoomsMembers.IDCustomer = this.IDCustomer; } aBookingRoomsMembers.DateEnterCountry = String.IsNullOrEmpty(dtpDateEnterCountry.Text) ? dateTime : dtpDateEnterCountry.DateTime; aBookingRoomsMembers.EnterGate = txtEnterGate.Text; aBookingRoomsMembers.LeaveDate = String.IsNullOrEmpty(dtpLeaveDate.Text) ? dateTime : dtpLeaveDate.DateTime; aBookingRoomsMembers.LimitDateEnterCountry = String.IsNullOrEmpty(dtpLimitDateEnterCountry.Text) ? dateTime : dtpLimitDateEnterCountry.DateTime; aBookingRoomsMembers.Organization = txtOrganization.Text; aBookingRoomsMembers.PurposeComeVietnam = txtPurposeComeVietnam.Text; aBookingRoomsMembers.TemporaryResidenceDate = String.IsNullOrEmpty(dtpTemporaryResidenceDate.Text) ? dateTime : dtpTemporaryResidenceDate.DateTime; if (aBookingRoomsMembers.ID > 0) { aBookingRoomsMembersBO.Update(aBookingRoomsMembers); } else { aBookingRoomsMembersBO.Insert(aBookingRoomsMembers); } MessageBox.Show("Thực hiện thành công!", "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Information); this.afrmTsk_Payment_Step2.Reload(); // this.afrmTsk_Payment_Step2.ReloadMoneyRoom(); this.Close(); }
private void btnDeleteBookingR_Click(object sender, EventArgs e) { BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO(); BookingRooms_ServicesBO aBookingRooms_ServicesBO = new BookingRooms_ServicesBO(); BookingRoomsBO aBookingRoomsBO = new BookingRoomsBO(); BookingRsBO aBookingRsBO = new BookingRsBO(); CustomerGroups_CustomersBO aCustomerGroups_CustomersBO = new CustomerGroups_CustomersBO(); CustomerGroupsBO aCustomerGroupsBO = new CustomerGroupsBO(); BookingHsBO aBookingHsBO = new BookingHsBO(); BookingHalls_ServicesBO aBookingHalls_ServicesBO = new BookingHalls_ServicesBO(); BookingHallsBO aBookingHallsBO = new BookingHallsBO(); MenusBO aMenusBO = new MenusBO(); Menus_FoodsBO aMenus_FoodsBO = new Menus_FoodsBO(); try { MessageBox.Show("Chức năng này sẽ xóa tất cả các phòng và hóa đơn đặt phòng đã đặt!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); if (this.IDBookingH == 0) { DialogResult result = MessageBox.Show("Xóa tất cả các phòng đã đặt. Tiếp tục?", "Xóa phòng", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { foreach (BookingRoomUsedEN item in this.aNewPaymentEN.aListBookingRoomUsed) { aBookingRooms_ServicesBO.DeleteListServiceUsed(item.ID); aBookingRoomsMembersBO.DeleteListBookingRoomsMembers(item.ID); aBookingRoomsBO.Delete(item.ID); } aCustomerGroups_CustomersBO.DeleteAllCustomersFromCustomerGroup_ByIDBookingRs(this.IDBookingR); aCustomerGroupsBO.Delete_ByID(Convert.ToInt32(this.aNewPaymentEN.IDCustomerGroup)); int ret = aBookingRsBO.Delete(this.IDBookingR); if (ret > 0) { MessageBox.Show("Thực hiện thành công!", "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } else { DialogResult result = MessageBox.Show("Xóa tất cả các phòng và hội trường đã đặt. Tiếp tục?", "Xóa hóa đơn", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { foreach (BookingRoomUsedEN item in this.aNewPaymentEN.aListBookingRoomUsed) { aBookingRooms_ServicesBO.DeleteListServiceUsed(item.ID); aBookingRoomsMembersBO.DeleteListBookingRoomsMembers(item.ID); aBookingRoomsBO.Delete(item.ID); } aCustomerGroups_CustomersBO.DeleteAllCustomersFromCustomerGroup_ByIDBookingRs(this.IDBookingR); aCustomerGroupsBO.Delete_ByID(Convert.ToInt32(this.aNewPaymentEN.IDCustomerGroup)); aBookingRsBO.Delete(this.IDBookingR); foreach (BookingHallUsedEN item1 in this.aNewPaymentEN.aListBookingHallUsed) { aBookingHalls_ServicesBO.DeleteListServiceUsed(item1.ID); aBookingHallsBO.Delete(item1.ID); foreach (MenusEN aMenu in item1.aListMenuEN) { aMenusBO.Delete(aMenu.ID); aMenus_FoodsBO.Delete_ByIDMenu(aMenu.ID); } } int ret = aBookingHsBO.Delete(this.IDBookingH); if (ret > 0) { MessageBox.Show("Thực hiện thành công!", "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } this.Close(); if (this.afrmMain != null) { this.afrmMain.ReloadData(); } else if (this.afrmMain_Halls != null) { this.afrmMain_Halls.ReloadData(); } } catch (Exception ex) { MessageBox.Show("frmTsk_UpdBookingHall.btnDeleteBookingRs\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
//hiennv private void btnApply_Click(object sender, EventArgs e) { try { if (this.CheckDataBeforeApply() == true) { CustomerGroups_CustomersBO aCustomerGroupsCustomersBO = new CustomerGroups_CustomersBO(); if (aListRemove.Count > 0) { foreach (Customers item in aListRemove) { CustomerGroups_Customers aCustomerGroups_Customers = aCustomerGroupsCustomersBO.Select_ByIDCustomer_ByIDCustomerGroup(item.ID, IDCustomerGroup); if (aCustomerGroups_Customers != null) { aCustomerGroupsCustomersBO.Delete(item.ID, IDCustomerGroup); } } if (this.afrmTsk_CheckIn_Goverment_Step2 != null) { this.afrmTsk_CheckIn_Goverment_Step2.LoadIDCustomers(); } else if (this.afrmTsk_CheckIn_Group_Step2 != null) { this.afrmTsk_CheckIn_Group_Step2.LoadIDCustomers(); } else if (this.afrm_Tsk_CheckIn_Customer_Step2 != null) { this.afrm_Tsk_CheckIn_Customer_Step2.LoadCustomers(); } else if (this.afrmTsk_Booking_Step2 != null) { this.afrmTsk_Booking_Step2.LoadIDCustomers(); } else if (this.afrmTsk_CheckInGoverment_ForRoomBooking_Step2 != null) { this.afrmTsk_CheckInGoverment_ForRoomBooking_Step2.LoadIDCustomers(); this.afrmTsk_CheckInGoverment_ForRoomBooking_Step2.CallBackIDCustomer(aListAdd[0].ID); } else if (this.afrmTsk_CheckInGroup_ForRoomBooking_Step2 != null) { this.afrmTsk_CheckInGroup_ForRoomBooking_Step2.LoadIDCustomers(); this.afrmTsk_CheckInGroup_ForRoomBooking_Step2.CallBackIDCustomer(aListAdd[0].ID); } else if (this.afrmTsk_CheckInCustomer_ForRoomBooking_Step2 != null) { this.afrmTsk_CheckInCustomer_ForRoomBooking_Step2.LoadCustomers(); this.afrmTsk_CheckInCustomer_ForRoomBooking_Step2.CallBackIDCustomer(aListAdd[0].ID); } } if (aListAdd.Count > 0) { CustomerGroups_Customers aCustomerGroups_Customers = new CustomerGroups_Customers(); foreach (Customers item in aListAdd) { aCustomerGroups_Customers = aCustomerGroupsCustomersBO.Select_ByIDCustomer_ByIDCustomerGroup(item.ID, IDCustomerGroup); if (aCustomerGroups_Customers != null) { string name = (NameCustomerGroup + "_" + item.Name).Length > 150 ? (NameCustomerGroup + "_" + item.Name).Substring(0, 150) : (NameCustomerGroup + "_" + item.Name); aCustomerGroups_Customers.Name = name; aCustomerGroups_Customers.IDCustomer = item.ID; aCustomerGroups_Customers.IDCustomerGroup = IDCustomerGroup; aCustomerGroupsCustomersBO.Insert(aCustomerGroups_Customers); } } if (this.afrmTsk_CheckIn_Goverment_Step2 != null) { this.afrmTsk_CheckIn_Goverment_Step2.LoadIDCustomers(); this.afrmTsk_CheckIn_Goverment_Step2.CallBackIDCustomer(aListAdd[0].ID); } else if (this.afrmTsk_CheckIn_Group_Step2 != null) { this.afrmTsk_CheckIn_Group_Step2.LoadIDCustomers(); this.afrmTsk_CheckIn_Group_Step2.CallBackIDCustomer(aListAdd[0].ID); } else if (this.afrm_Tsk_CheckIn_Customer_Step2 != null) { this.afrm_Tsk_CheckIn_Customer_Step2.LoadCustomers(); this.afrm_Tsk_CheckIn_Customer_Step2.CallBackIDCustomer(aListAdd[0].ID); } else if (this.afrmTsk_Booking_Step2 != null) { this.afrmTsk_Booking_Step2.LoadIDCustomers(); this.afrmTsk_Booking_Step2.CallBackIDCustomer(aListAdd[0].ID); } else if (this.afrmTsk_CheckInGoverment_ForRoomBooking_Step2 != null) { this.afrmTsk_CheckInGoverment_ForRoomBooking_Step2.LoadIDCustomers(); this.afrmTsk_CheckInGoverment_ForRoomBooking_Step2.CallBackIDCustomer(aListAdd[0].ID); } else if (this.afrmTsk_CheckInGroup_ForRoomBooking_Step2 != null) { this.afrmTsk_CheckInGroup_ForRoomBooking_Step2.LoadIDCustomers(); this.afrmTsk_CheckInGroup_ForRoomBooking_Step2.CallBackIDCustomer(aListAdd[0].ID); } else if (this.afrmTsk_CheckInCustomer_ForRoomBooking_Step2!= null) { this.afrmTsk_CheckInCustomer_ForRoomBooking_Step2.LoadCustomers(); this.afrmTsk_CheckInCustomer_ForRoomBooking_Step2.CallBackIDCustomer(aListAdd[0].ID); } else if (afrmTsk_BookingHall_Goverment != null) { afrmTsk_BookingHall_Goverment.CallBackIDCustomer(aListSelectCustomers); } else if (afrmTsk_BookingHall_Group != null) { afrmTsk_BookingHall_Group.CallBackIDCustomer(aListSelectCustomers); } else if (afrmTsk_BookingHall_Customer != null) { afrmTsk_BookingHall_Customer.CallBackIDCustomer(aListSelectCustomers); } else if (afrmTsk_UpdBooking != null) { afrmTsk_UpdBooking.CallBackIDCustomer(aListSelectCustomers); } } this.Close(); MessageBox.Show("Thực hiện thành công!", "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show("frmAddListCustomerToCustomerGroups.btnApply_Click\n" + ex.ToString(), "Error ", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
//public frmUpd_Customers_2(frmIns_CustomerGroups_Customers afrmIns_CustomerGroups_Customers, int IDCustomer) //{ // InitializeComponent(); // this.afrmIns_CustomerGroups_Customers = afrmIns_CustomerGroups_Customers; // this.IDCustomer = IDCustomer; //} //public frmUpd_Customers_2(frmLst_Customers afrmLst_Customers, int aIDCustomer) //{ // InitializeComponent(); // this.afrmLst_Customers = afrmLst_Customers; // this.IDCustomer = aIDCustomer; //} //public frmUpd_Customers_2(frmTsk_EditBooking afrmTsk_EditBooking, int aIDCustomer) //{ // InitializeComponent(); // this.afrmTsk_EditBooking = afrmTsk_EditBooking; // this.IDCustomer = aIDCustomer; //} //public frmUpd_Customers_2(frmTsk_Payment_Step2 afrmTsk_Payment_Step2, int aIDCustomer) //{ // InitializeComponent(); // this.afrmTsk_Payment_Step2 = afrmTsk_Payment_Step2; // this.IDCustomer = aIDCustomer; //} private void frmUpdateCustomers_Load(object sender, EventArgs e) { try { dgvAvailableCustomers.DataSource = (new CustomersBO()).Select_All(); btnAdd.Enabled = false; lueNationality.Properties.DataSource = CORE.CONSTANTS.ListCountries;//Load Country lueNationality.Properties.DisplayMember = "Name"; lueNationality.Properties.ValueMember = "Code"; lueCitizen.Properties.DataSource = CORE.CONSTANTS.ListCitizens;//Load Citizen lueCitizen.Properties.DisplayMember = "Name"; lueCitizen.Properties.ValueMember = "ID"; lueGender.Properties.DataSource = CORE.CONSTANTS.ListGenders;//Load Gioi tinh lueGender.Properties.DisplayMember = "Name"; lueGender.Properties.ValueMember = "ID"; CustomersBO aCustomersBO = new CustomersBO(); // lấy IDCustomer này từ FormCustomers if (this.IDCustomer > 0) { Customers aCustomer = aCustomersBO.Select_ByID(IDCustomer); if (aCustomer != null) { txtNames.EditValue = aCustomer.Name; txtIdentifier1.EditValue = aCustomer.Identifier1; txtIdentifier2.EditValue = aCustomer.Identifier2; txtIdentifier3.EditValue = aCustomer.Identifier3; if (aCustomer.Birthday != null) { dtpBirthday.EditValue = aCustomer.Birthday; } if (aCustomer.Gender != null) { lueGender.EditValue = int.Parse(aCustomer.Gender.ToString()); } else { lueGender.EditValue = CORE.CONSTANTS.SelectedGender(1).ID; } txtAddress.EditValue = aCustomer.Address; if (String.IsNullOrEmpty(aCustomer.Nationality) == false) { lueNationality.EditValue = aCustomer.Nationality; } if (lueNationality.EditValue == null) { lueNationality.EditValue = CORE.CONSTANTS.SelectedCountry(704).Code; } if (aCustomer.Citizen > 0) { lueCitizen.EditValue = aCustomer.Citizen; } else { lueCitizen.EditValue = CORE.CONSTANTS.SelectedCitizen(2).ID; } //---------------------------------------------------------------- txtTel.EditValue = aCustomer.Tel; txtEmail.EditValue = aCustomer.Email; //---------------------------------------------------------------- CustomerGroups_CustomersBO aCustomerGroups_CustomersBO = new CustomerGroups_CustomersBO(); aCustomerGroups_CustomersBO.InsertCustomerIntoCustomerGroup_ByIDBookingRs(this.IDCustomer, (new BookingRsBO()).Select_ByIDBookingRoom(this.IDBookingRoom).ID); /*--------------------------*/ BookingRoomsMembers aBookingRoomsMembers = new BookingRoomsMembers(); BookingRoomsMembersBO aBookingRoomsMembersBO = new BookingRoomsMembersBO(); aBookingRoomsMembers = aBookingRoomsMembersBO.Select_ByIDBookingRoom_ByIDCustomer(this.IDBookingRoom, this.IDCustomer); if (aBookingRoomsMembers != null) { dtpDateEnterCountry.DateTime = aBookingRoomsMembers.DateEnterCountry.GetValueOrDefault() ; txtEnterGate.Text = aBookingRoomsMembers.EnterGate; dtpLeaveDate.DateTime = aBookingRoomsMembers.LeaveDate.GetValueOrDefault(); dtpLimitDateEnterCountry.DateTime = aBookingRoomsMembers.LimitDateEnterCountry.GetValueOrDefault(); txtOrganization.Text = aBookingRoomsMembers.Organization ; txtPurposeComeVietnam.Text = aBookingRoomsMembers.PurposeComeVietnam ; aBookingRoomsMembers.TemporaryResidenceDate = dtpTemporaryResidenceDate.DateTime ; } } } } catch (Exception ex) { MessageBox.Show("frmUpdateCustomers.frmUpdateCustomers_Load\n" + ex.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
//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; } }
private void btnDelete_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { int ID = int.Parse(viewAvailableCustomers.GetFocusedRowCellValue("ID").ToString()); string Name = viewAvailableCustomers.GetFocusedRowCellValue("Name").ToString(); DialogResult result = MessageBox.Show("Bạn có muốn xóa khách hàng " + Name + " này không?", "Xóa khách hàng", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { CustomerGroups_CustomersBO aCustomerGroups_CustomersBO = new CustomerGroups_CustomersBO(); CustomersBO aCustomersBO = new CustomersBO(); ReceptionTaskBO aReceptionTaskBO = new ReceptionTaskBO(); List<CustomerGroups_Customers> aListTemp = aCustomerGroups_CustomersBO.Select_ByIDCustomer(ID); List<vw__BookingRInfo__BookingRooms_Rooms_SystemUsers_Customers_CustomerGroups> aList = aReceptionTaskBO.GetInfoBookingRoom_ByIDCustomer(aListTemp.Select(p => p.IDCustomer).ToList()); if (aList.Count > 0) { MessageBox.Show("Bạn không được xóa khách này vì sẽ làm mất thông tin khách này với đặt phòng mã : " + string.Join(",", aList.Select(p => p.BookingRooms_IDBookingR).ToArray())); } else { aCustomersBO.Delete(ID); MessageBox.Show("Xóa thành công"); this.ReloadData(); } } }
private void btnApply_Click(object sender, EventArgs e) { try { CustomerGroups_CustomersBO aCustomerGroupsCustomersBO = new CustomerGroups_CustomersBO(); if (aListRemove.Count > 0) { foreach (Customers item in aListRemove) { List<CustomerGroups_Customers> count = aCustomerGroupsCustomersBO.Select_ByIDCustomer_ByIDCustomerGroup(item.ID, IDCustomerGroup); if (count.Count > 0) { aCustomerGroupsCustomersBO.Delete(item.ID, IDCustomerGroup); } } } if (aListAdd.Count > 0) { foreach (Customers item in aListAdd) { List<CustomerGroups_Customers> list = aCustomerGroupsCustomersBO.Select_ByIDCustomer_ByIDCustomerGroup(item.ID, IDCustomerGroup); if (list.Count < 1) { CustomerGroups_Customers aCustomerGroups_Customers = new CustomerGroups_Customers(); string name = (NameCustomerGroup + "_" + item.Name).Length > 150 ? (NameCustomerGroup + "_" + item.Name).Substring(0, 250) : (NameCustomerGroup + "_" + item.Name); aCustomerGroups_Customers.Name = name; aCustomerGroups_Customers.IDCustomer = item.ID; aCustomerGroups_Customers.IDCustomerGroup = IDCustomerGroup; aCustomerGroupsCustomersBO.Insert(aCustomerGroups_Customers); } } } if (afrmTsk_BookingHall_Goverment != null) { afrmTsk_BookingHall_Goverment.CallBackIDCustomer(aListSelectCustomers); } if (afrmTsk_BookingHall_Group != null) { afrmTsk_BookingHall_Group.CallBackIDCustomer(aListSelectCustomers); } if (afrmTsk_BookingHall_Customer != null) { afrmTsk_BookingHall_Customer.CallBackIDCustomer(aListSelectCustomers); } if (afrmTsk_UpdBooking != null) { afrmTsk_UpdBooking.CallBackIDCustomer(aListSelectCustomers); } MessageBox.Show("Thực hiện thành công!", "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } catch (Exception ex) { MessageBox.Show("frmAddListCustomerToCustomerGroups.btnApply_Click\n" + ex.ToString(), "Error ", MessageBoxButtons.OK, MessageBoxIcon.Error); } }