private void wbntThemloaikhachhang_ButtonClick(object sender, DevExpress.XtraBars.Docking2010.ButtonEventArgs e) { switch (e.Button.Properties.Tag.ToString()) { case "Thêm": //Lưu thông tin if (LoaiKhachHangBUS.CapNhatThongTinLoaiKhachHang(new DTO.LoaiKhachHangDTO(loaiKhachHangDTO.MaLoaiKH, txtTenLoaiKhachHang.Text, Convert.ToInt32(txtSoDiemDeDatDuoc.EditValue), Convert.ToDouble(txtPhanTramGiamGia.EditValue), Convert.ToDouble(txtSoTienGiamGia_Min.EditValue), Convert.ToDouble(txtSoTienGiamGia_Max.EditValue), Convert.ToDouble(txtPhanTramGiamGiaSinhNhat.EditValue), Convert.ToDouble(txtSoTienGiamGiaSinhNhat_Min.EditValue), Convert.ToDouble(txtSoTienGiamGiaSinhNhat_Max.EditValue)))) { //Thông báo thành công XtraMessageBox.Show("Sửa loại khách hàng thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); actionBack(); } else { //Thông báo thất bại XtraMessageBox.Show("Sửa loại khách hàng thất bại!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } break; case "Hủy": if (ThongBaoHuyKoLuuLoaiKH()) { actionBack(); } break; default: break; } }
private void frmThemKhachHang_Load(object sender, EventArgs e) { LoaiKhachHangBUS bus = new LoaiKhachHangBUS(); cbLoaiKH.DataSource = bus.GetDataID_Ten(); cbLoaiKH.DisplayMember = "tenLKH"; cbLoaiKH.ValueMember = "maLKH"; }
public void RefreshDataBinding() { txtMaLoaiKhachHang.EditValue = LoaiKhachHangBUS.PhatSinhLoaiKhachHang(); txtTenLoaiKhachHang.Text = ""; ValidateChildren(); }
public void TaoLoaiKhachHang_1() { DAL.DataProvider.InitalizeConnection(); LoaiKhachHangDTO loaiHangDTO = new LoaiKhachHangDTO(LoaiKhachHangBUS.PhatSinhLoaiKhachHang(), "abc", 0, 0, 0, 0, 0, 0, 0); LoaiKhachHangBUS.LuuThongTinLoaiKhachHang(loaiHangDTO); DataTable khachhangDT = LoaiKhachHangBUS.LayTatCaLoaiKhachHang_DataTable(); Assert.IsTrue(loaiHangDTO.MaLoaiKH == (int)khachhangDT.Rows[khachhangDT.Rows.Count - 1]["MaLoaiKH"]); }
public void SuaLoaiKhachHang_1() { DAL.DataProvider.InitalizeConnection(); DataTable khachhangDT = LoaiKhachHangBUS.LayTatCaLoaiKhachHang_DataTable(); LoaiKhachHangDTO loaiHangDTO = new LoaiKhachHangDTO((int)khachhangDT.Rows[khachhangDT.Rows.Count - 1]["MaLoaiKH"], "xyz", 0, 0, 0, 0, 0, 0, 0); LoaiKhachHangBUS.CapNhatThongTinLoaiKhachHang(loaiHangDTO); DataTable newKhachHangDT = LoaiKhachHangBUS.LayTatCaLoaiKhachHang_DataTable(); Assert.IsTrue(newKhachHangDT.Rows[newKhachHangDT.Rows.Count - 1]["TenLoaiKH"].ToString() == khachhangDT.Rows[khachhangDT.Rows.Count - 1]["TenLoaiKH"].ToString()); }
public void XoaLoaiKhachHang_1() { DAL.DataProvider.InitalizeConnection(); DataTable khachhangDT = LoaiKhachHangBUS.LayTatCaLoaiKhachHang_DataTable(); //LoaiKhachHangDTO loaiHangDTO = new LoaiKhachHangDTO((int)khachhangDT.Rows[khachhangDT.Rows.Count - 1]["MaLoaiKH"], "xyz", 0, 0, 0, 0, 0, 0, 0); LoaiKhachHangBUS.XoaLoaiKhachHang((int)khachhangDT.Rows[khachhangDT.Rows.Count - 1]["MaLoaiKH"]); DataTable newKhachHangDT = LoaiKhachHangBUS.LayTatCaLoaiKhachHang_DataTable(); Assert.IsTrue((int)newKhachHangDT.Rows[newKhachHangDT.Rows.Count - 1]["MaLoaiKH"] != (int)khachhangDT.Rows[khachhangDT.Rows.Count - 1]["MaLoaiKH"]); }
public void RefreshDataBinding(int maLoaiKH) { this.loaiKhachHangDTO = LoaiKhachHangBUS.LayLoaiKhachHang(maLoaiKH); txtMaLoaiKhachHang.EditValue = loaiKhachHangDTO.MaLoaiKH; txtTenLoaiKhachHang.Text = loaiKhachHangDTO.TenLoaiKH; txtSoDiemDeDatDuoc.EditValue = loaiKhachHangDTO.SoDiemDeDatDuoc; txtPhanTramGiamGia.EditValue = loaiKhachHangDTO.PhanTramGiamGia; txtSoTienGiamGia_Min.EditValue = loaiKhachHangDTO.SoTienGiamGia_Min; txtSoTienGiamGia_Max.EditValue = loaiKhachHangDTO.SoTienGiamGia_Max; txtPhanTramGiamGiaSinhNhat.EditValue = loaiKhachHangDTO.PhanTramGiamGiaSinhNhat; txtSoTienGiamGiaSinhNhat_Min.EditValue = loaiKhachHangDTO.SoTienGiamGiaSinhNhat_Min; txtSoTienGiamGiaSinhNhat_Max.EditValue = loaiKhachHangDTO.SoTienGiamGiaSinhNhat_Max; ValidateChildren(); }
private void btn_luu_Click(object sender, EventArgs e) { LoaiKhachHangBUS a = new LoaiKhachHangBUS(); if (trThai == 2) { LoaiKhachHangDTO loai; try { loai = new LoaiKhachHangDTO() { MALOAI = int.Parse(txt_MaLoai.Text), TENLOAIKH = txt_TenLoai.Text, TINHTRANG = ckb_TinhTrang.Checked ? true : false }; } catch { MessageBox.Show("Thieu thong tin"); return; } bool kt = a.CapNhatLoaiKH(loai); if (!kt) { MessageBox.Show("Cập nhật thất bại"); } else { MessageBox.Show("Cập nhật thành công!"); FrmChinh frmmain = (FrmChinh)this.MdiParent; frmmain.lsNDDTO = new LichSuNguoiDungDTO() { MAND = frmmain.nvDangNhap.MAND, MANV = frmmain.nvDangNhap.MANV, THOIGIAN = DateTime.Parse(DateTime.Now.ToString("dd/MM/yyy HH:mm")), SUKIEN = "Loại khách hàng cập nhật" + loaiKH.TENLOAIKH + " => :" + loai.TENLOAIKH }; bool ktls = frmmain.lsNDBUS.ThemLichSuNguoiDung(frmmain.lsNDDTO); trThai = 1; loaiKH = null; } } TrangThai(); Bind(); LoadData(); }
public void RefreshDataBinding(int maKH) { try { khachHangDTO = KhachHangBUS.LayKhachHang(maKH); //Lấy tất cả loại phòng vào cmb listLoaiKH = LoaiKhachHangBUS.LayTatCaLoaiKhachHang_List(); //Nếu không có loại phòng, thông báo cần tạo loại phòng trước if (listLoaiKH.Count == 0) { XtraMessageBox.Show("Cần thêm loại khách hàng trước!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } cmbLoaiKH.Properties.Items.Clear(); foreach (LoaiKhachHangDTO loaiKH in listLoaiKH) { cmbLoaiKH.Properties.Items.Add(new MyComboBoxItem(loaiKH.TenLoaiKH, loaiKH.MaLoaiKH)); if (loaiKH.MaLoaiKH == khachHangDTO.MaLoaiKH) { cmbLoaiKH.SelectedIndex = cmbLoaiKH.Properties.Items.Count - 1; } } txtNgaySinh.DateTime = khachHangDTO.NgaySinh; txtMaKH.EditValue = khachHangDTO.MaKH.ToString(); txtTenKH.EditValue = khachHangDTO.TenKH; txtEmail.EditValue = khachHangDTO.Email; txtDiaChi.EditValue = khachHangDTO.DiaChi; txtSDT.EditValue = khachHangDTO.SDT.ToString(); txtDiemtichluy.EditValue = khachHangDTO.DiemTichLuy; // pictureEdit1.Image = khachHangDTO.HinhAnh; ValidateChildren(); } catch (Exception x) { } }
private void frmSuaKhachHang_Load(object sender, EventArgs e) { if (IsInsert == false) { DataTable dt = new DataTable(); dt = khBus.GetDataByID(ID); txtTenKH.Text = dt.Rows[0]["tenKH"].ToString(); txtSDT.Text = dt.Rows[0]["sdtKH"].ToString(); txtEmail.Text = dt.Rows[0]["emailKH"].ToString(); //cbLoaiSP.DisplayMember = dt.Rows[0]["maLSP"].ToString(); //cbLoaiSP.ValueMember = dt.Rows[0]["tenLSP"].ToString(); //cbLoaiSP.DataSource = dt; txtDiaChi.Text = dt.Rows[0]["diachiKH"].ToString(); txtGhiChu.Text = dt.Rows[0]["ghichuKH"].ToString(); LoaiKhachHangBUS LoaiBus = new LoaiKhachHangBUS(); cbLoaiKH.DataSource = LoaiBus.GetDataID_Ten(); cbLoaiKH.DisplayMember = "tenLKH"; cbLoaiKH.ValueMember = "maLKH"; } }
public void LoadData() { KhachHangBUS a = new KhachHangBUS(); maKHMoi = a.MaKHMoi(); txt_MaKH.Text = maKHMoi; //trThai = 1; //TrangThai(); LoaiKhachHangBUS lp = new LoaiKhachHangBUS(); cbo_LoaiKH.DataSource = lp.DanhSachLoaiKH().FindAll(o => o.TINHTRANG == true); cbo_LoaiKH.ValueMember = "MALOAI"; cbo_LoaiKH.DisplayMember = "TENLOAIKH"; TinhTrangKHBUS tt = new TinhTrangKHBUS(); cbo_TinhTrang.DataSource = tt.DSTINHTRANGKH(); cbo_TinhTrang.ValueMember = "MATTR"; cbo_TinhTrang.DisplayMember = "TENTTR"; //load datagridviewcomboboxcolum truoc khi load ds . DataGridViewComboBoxColumn dgvcb_loaiphong = (DataGridViewComboBoxColumn)dgv_KhachHang.Columns["colLOAI"]; dgvcb_loaiphong.DataSource = lp.DanhSachLoaiKH().FindAll(o => o.TINHTRANG == true); dgvcb_loaiphong.ValueMember = "MALOAI"; dgvcb_loaiphong.DisplayMember = "TENLOAIKH"; DataGridViewComboBoxColumn dgvcb_tinhtrang = (DataGridViewComboBoxColumn)dgv_KhachHang.Columns["colTT"]; dgvcb_tinhtrang.DataSource = tt.DSTINHTRANGKH(); dgvcb_tinhtrang.ValueMember = "MATTR"; dgvcb_tinhtrang.DisplayMember = "TENTTR"; //DataGridViewCheckBoxColumn dgvckb = (DataGridViewCheckBoxColumn)dgv_sanpham.Columns["TinhTrang"]; KhachHangBUS b = new KhachHangBUS(); dgv_KhachHang.DataSource = b.DanhSachKhachHang(); }
private void btnThayDoiKhachHang_Click(object sender, EventArgs e) { folderKhachHang.ChonKhachHang chonKhachHang = new folderKhachHang.ChonKhachHang(false); XtraDialogArgs args = new XtraDialogArgs(caption: "Caption", content: chonKhachHang, buttons: new DialogResult[] { DialogResult.OK, DialogResult.Cancel }); args.Showing += Args_Showing_ChonKH; args.Caption = "Default Text"; args.Buttons = new DialogResult[] { DialogResult.OK, DialogResult.Cancel }; switch (XtraDialog.Show(args)) { case DialogResult.OK: khachHang = chonKhachHang.LayKhachHangDaChon(); txtMaKH.EditValue = khachHang.MaKH; txtLoaiKH.EditValue = LoaiKhachHangBUS.LayLoaiKhachHang(khachHang.MaLoaiKH).TenLoaiKH; txtEmail.EditValue = khachHang.Email; txtSDT.EditValue = khachHang.SDT; txtTenKH.EditValue = khachHang.TenKH; txtDiaChi.EditValue = khachHang.DiaChi; txtNgaySinh.EditValue = khachHang.NgaySinh; DatPhongBUS.UpdateKhachHang(datPhong.MaDatPhong, khachHang.MaKH); break; case DialogResult.Cancel: break; default: break; } }
private void wbntKhachhang_ButtonClick(object sender, DevExpress.XtraBars.Docking2010.ButtonEventArgs e) { switch (e.Button.Properties.Tag.ToString()) { case "Thêm khách hàng": //Nếu không có loại KH, thông báo cần tạo loại phòng trước if (LoaiKhachHangBUS.LayTatCaLoaiKhachHang_List().Count == 0) { XtraMessageBox.Show("Cần phải thêm loại khách hàng trước!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } themKhachHang3.Initialize(); this.KhachhangPagecontrol.SelectedPage = PageThemkhachhang; break; case "Sửa khách hàng": suaKhachHang3.RefreshDataBinding((int)khachHang.Rows[gridView1.GetFocusedDataSourceRowIndex()]["MaKH"]); this.KhachhangPagecontrol.SelectedPage = PageSuakhachang; break; case "Bộ lọc": DevExpress.XtraBars.Docking2010.Views.WindowsUI.FlyoutAction action = new DevExpress.XtraBars.Docking2010.Views.WindowsUI.FlyoutAction() { Caption = "BỘ LỌC", Description = "Close the application?" }; DevExpress.XtraBars.Docking2010.Views.WindowsUI.FlyoutCommand command1 = new DevExpress.XtraBars.Docking2010.Views.WindowsUI.FlyoutCommand() { Text = "Lọc", Result = System.Windows.Forms.DialogResult.Yes }; DevExpress.XtraBars.Docking2010.Views.WindowsUI.FlyoutCommand command2 = new DevExpress.XtraBars.Docking2010.Views.WindowsUI.FlyoutCommand() { Text = "Hủy", Result = System.Windows.Forms.DialogResult.No }; action.Commands.Add(command1); action.Commands.Add(command2); FlyoutProperties properties = new FlyoutProperties(); properties.ButtonSize = new Size(160, 50); properties.Style = FlyoutStyle.MessageBox; filterDialog = new FilterControlDialog(gridControl1, gridView1.ActiveFilterString.ToString()); if (DevExpress.XtraBars.Docking2010.Customization.FlyoutDialog.Show(this.FindForm(), filterDialog, action, properties) == DialogResult.Yes) { if (filterDialog.GetFilterString() == "") { return; } gridView1.ActiveFilterString = strFilterDialog = filterDialog.GetFilterString(); tileControl2.SelectedItem = tileFilter; tileFilter.Visible = true; } break; case "Quản lý loại khách hàng": goToLoaiKhachHang(); break; //case "Xóa": // //Thông báo xác nhận // if (XtraMessageBox.Show("Bạn có chắc xóa khách hàng '" + gridView1.GetFocusedRowCellValue(colTenKH).ToString() + "' ?", "Xác nhận", MessageBoxButtons.OKCancel) == DialogResult.OK) // { // if (BUS.KhachHangBUS.XoaKhachHang((int)gridView1.GetFocusedRowCellValue(colMaKH))) // { // //Thông báo thành công/thất bại // XtraMessageBox.Show("Xóa khách hàng thành công!", "Thông báo", MessageBoxButtons.OK); // RefreshDataBinding(); // } // else // //Thông báo thành công/thất bại // XtraMessageBox.Show("Xóa khách hàng thất bại!", "Thông báo", MessageBoxButtons.OK); // } // break; } }
public void RefreshDataBinding(int maDatPhong) { //Lấy tất cả tinh trang phong vào cmb listTinhTrangDatPhong = DatPhongBUS.LayTatCaTinhTrangDatPhong_List(); //combobox tinh trang phong txtTinhTrangDat.Properties.Items.Clear(); foreach (TinhTrangDatPhongDTO tinhtrang in listTinhTrangDatPhong) { txtTinhTrangDat.Properties.Items.Add(new MyComboBoxItem(tinhtrang.TinhTrangDatPhong, tinhtrang.MaTinhDatTrangPhong)); } this.datPhong = DatPhongBUS.LayThongTinDatPhong(maDatPhong); txtMaDatPhong.EditValue = maDatPhong; txtTienTraTruoc.EditValue = datPhong.SoTienDatTruoc; txtThoiGian.EditValue = datPhong.ThoiGianDatPhong; txtGhiChu.EditValue = datPhong.GhiChu; dateNgayLapPhieu.DateTime = datPhong.NgayLapPhieuDat; txtTinhTrangDat.EditValue = DatPhongBUS.LayTinhTrangPhong(datPhong.MaTinhTrangDatPhong).TinhTrangDatPhong; khachHang = KhachHangBUS.LayKhachHang(datPhong.MaKH); txtMaKH.EditValue = khachHang.MaKH; txtLoaiKH.EditValue = LoaiKhachHangBUS.LayLoaiKhachHang(khachHang.MaLoaiKH).TenLoaiKH; txtEmail.EditValue = khachHang.Email; txtSDT.EditValue = khachHang.SDT; txtTenKH.EditValue = khachHang.TenKH; txtDiaChi.EditValue = khachHang.DiaChi; txtNgaySinh.EditValue = khachHang.NgaySinh; txtTenNhanVien.EditValue = NhanVienBUS.LayNhanVien(datPhong.MaNhanVien).TenNhanVien; this.TabControl.TabPages.Clear(); foreach (ChiTietDatPhongDTO chiTiet in DatPhongBUS.LayTatCaCacChiTietDatPhong(datPhong.MaDatPhong)) { ThongTinChiTietDatPhong thongTinChiTietDatPhong = new ThongTinChiTietDatPhong(datPhong); thongTinChiTietDatPhong.RefreshDataBinding(chiTiet); DevExpress.XtraTab.XtraTabPage xtraTab = new DevExpress.XtraTab.XtraTabPage(); // // thongTinChiTietPhong1 // thongTinChiTietDatPhong.Appearance.BackColor = System.Drawing.Color.White; thongTinChiTietDatPhong.Appearance.Options.UseBackColor = true; thongTinChiTietDatPhong.Dock = System.Windows.Forms.DockStyle.Fill; thongTinChiTietDatPhong.Location = new System.Drawing.Point(0, 0); thongTinChiTietDatPhong.Name = "thongTinChiTietPhong1"; thongTinChiTietDatPhong.Size = new System.Drawing.Size(989, 591); thongTinChiTietDatPhong.TabIndex = 0; // // tab1 // xtraTab.Controls.Add(thongTinChiTietDatPhong); xtraTab.Name = thongTinChiTietDatPhong.phong.MaPhong.ToString(); xtraTab.Size = new System.Drawing.Size(989, 591); xtraTab.Text = thongTinChiTietDatPhong.phong.TenPhong; xtraTab.Tag = thongTinChiTietDatPhong; // this.TabControl.TabPages.AddRange(new DevExpress.XtraTab.XtraTabPage[] { xtraTab }); } if (datPhong.MaTinhTrangDatPhong == 3) { txtTienTraTruoc.ReadOnly = true; txtGhiChu.ReadOnly = true; } }
public void RefreshDataBinding(ThuePhongDTO thuePhongDTO, KhachHangDTO khachHangDTO) { txtTienGio.ReadOnly = false; gridView1.OptionsBehavior.ReadOnly = false; this.thuePhong = thuePhongDTO; txtGioVao.Time = thuePhong.GioThuePhong; txtGioRa.Time = (thuePhong.GioTraPhong == DateTime.MinValue) ?DateTime.Now : thuePhong.GioTraPhong; thuePhong.GioTraPhong = txtGioRa.Time; listKhuyenMai = new Dictionary <int, DichVuPhongDTO>(); RefreshDataBindingTienGio(); loaiKhachHang = LoaiKhachHangBUS.LayLoaiKhachHang(khachHangDTO); DichVuPhongDTO dichVuPhongDTO; //Kiểm tra các ngày đặt biệt foreach (DTO.ThongTinThanhToanTheoNgay ngay in ThanhToanBUS.TinhTienThuePhong(thuePhong, DateTime.Now).listThongTin) { //Sinh nhật if (ngay.ngay.date.Day == khachHangDTO.NgaySinh.Day && ngay.ngay.date.Month == khachHangDTO.NgaySinh.Month && khachHangDTO.MaKH != 0) { if (TongTienGio * loaiKhachHang.PhanTramGiamGiaSinhNhat > loaiKhachHang.SoTienGiamGiaSinhNhat_Max) { dichVuPhongDTO = new DichVuPhongDTO(-1, thuePhong.MaThuePhong, 1, DateTime.Now, 1.0, -loaiKhachHang.SoTienGiamGiaSinhNhat_Max); } else if ((TongTienGio * loaiKhachHang.PhanTramGiamGiaSinhNhat < loaiKhachHang.SoTienGiamGiaSinhNhat_Min)) { dichVuPhongDTO = new DichVuPhongDTO(-1, thuePhong.MaThuePhong, 1, DateTime.Now, 1.0, -loaiKhachHang.SoTienGiamGiaSinhNhat_Min); } else { dichVuPhongDTO = new DichVuPhongDTO(-1, thuePhong.MaThuePhong, 1, DateTime.Now, 1.0, -(TongTienGio * loaiKhachHang.PhanTramGiamGiaSinhNhat)); } if (dichVuPhongDTO.DonGia != 0) { listKhuyenMai.Add(dichVuPhongDTO.MaDVP, dichVuPhongDTO); } } } //KM Loại KH if (TongTienGio * loaiKhachHang.PhanTramGiamGia > loaiKhachHang.SoTienGiamGia_Max) { dichVuPhongDTO = new DichVuPhongDTO(-(listKhuyenMai.Count + 1), thuePhong.MaThuePhong, 2, DateTime.Now, 1.0, -loaiKhachHang.SoTienGiamGia_Max); } else if ((TongTienGio * loaiKhachHang.PhanTramGiamGia < loaiKhachHang.SoTienGiamGia_Min)) { dichVuPhongDTO = new DichVuPhongDTO(-(listKhuyenMai.Count + 1), thuePhong.MaThuePhong, 2, DateTime.Now, 1.0, -loaiKhachHang.SoTienGiamGia_Min); } else { dichVuPhongDTO = new DichVuPhongDTO(-(listKhuyenMai.Count + 1), thuePhong.MaThuePhong, 2, DateTime.Now, 1.0, -(TongTienGio * loaiKhachHang.PhanTramGiamGia)); } if (dichVuPhongDTO.DonGia != 0 && khachHangDTO.MaKH != 0) { listKhuyenMai.Add(dichVuPhongDTO.MaDVP, dichVuPhongDTO); } RefreshDataBindingDichVuPhong(); }
private void LoadData() { LoaiKhachHangBUS b = new LoaiKhachHangBUS(); dgv_LoaiKH.DataSource = b.DanhSachLoaiKH(); }