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