public BindingList<KhachHangDTO> LayDanhSach()
{
BindingList<KhachHangDTO> danhSach = new BindingList<KhachHangDTO>();
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "Select * From DanhMucKhachHang";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
OleDbDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
KhachHangDTO itemDTO = new KhachHangDTO();
itemDTO.Id = (int)dr["Id"];
itemDTO.MaKhachHang = (string)dr["MaKhachHang"];
itemDTO.HoKhachHang = (string)dr["HoKhachHang"];
itemDTO.TenKhachHang = (string)dr["TenKhachHang"];
itemDTO.IdNhomKhachHang = (int)dr["IdNhomKhachHang"];
itemDTO.DiaChi = (string)dr["DiaChi"];
itemDTO.DienThoai = (string)dr["DienThoai"];
itemDTO.NgaySinh = (DateTime)dr["NgaySinh"];
itemDTO.Email = (string)dr["Email"];
itemDTO.GhiChu = (string)dr["GhiChu"];
danhSach.Add(itemDTO);
}
return danhSach;
}
public ActionResult DangKy(KhachHangDTO kh)
{
if (db.insertKhachHang(kh) == 1)
{
ViewBag.ThongBao = "Chúc mừng bạn đăng ký thành công !";
return View();
}
//db.insertKhachHang(kh);
ViewBag.ThongBao = "Bạn đăng ký không thành công !";
return View();
}
public DataTable ConvertKhachHangDTOArrayToDataTable(KhachHangDTO[] DTOArr)
{
DataTable dt = new DataTable();
int row = DTOArr.Length;
dt.Columns.Add("MaKhachHang", typeof(string));
dt.Columns.Add("TenKhachHang", typeof(string));
dt.Columns.Add("MaLoaiKH", typeof(string));
dt.Columns.Add("CMND", typeof(string));
dt.Columns.Add("DiaChi", typeof(string));
dt.Columns.Add("KhachHangDaiDien", typeof(string));
for (int i = 0; i < row; i++)
{
dt.Rows.Add(DTOArr[i].MaKhachHang, DTOArr[i].TenKhachHang, DTOArr[i].MaLoaiKH, DTOArr[i].CMND, DTOArr[i].DiaChi, DTOArr[i].KhachHangDaiDien);
}
return dt;
}
public DataTable ConvertCTPhieuTHueDTOArrayToDataTable(CTPhieuThueDTO[] ctptDTOArr)
{
DataTable dt = new DataTable();
int row = ctptDTOArr.Length;
dt.Columns.Add("MaCTPT", typeof(string));
dt.Columns.Add("MaPhieuThue", typeof(string));
dt.Columns.Add("MaKhachHang", typeof(string));
dt.Columns.Add("TenKhachHang", typeof(string));
dt.Columns.Add("MaLoaiKH", typeof(string));
dt.Columns.Add("DiaChi", typeof(string));
dt.Columns.Add("CMND", typeof(string));
for (int i = 0; i < row; i++)
{
KhachHangDTO[] kDTO = new KhachHangDTO[1];
kDTO = ws.getKhachHangById(ctptDTOArr[i].MaKhachHang);
dt.Rows.Add(ctptDTOArr[i].MaCTPT, ctptDTOArr[i].MaPhieuThue, ctptDTOArr[i].MaKhachHang, kDTO[0].TenKhachHang, kDTO[0].MaLoaiKH, kDTO[0].DiaChi, kDTO[0].CMND);
}
return dt;
}
public void Sua(KhachHangDTO itemDTO)
{
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "Update DanhMucKhachHang Set MaKhachHang = ?, HoKhachHang = ?, TenKhachHang = ?, IdNhomKhachHang = ?, DiaChi = ?, DienThoai = ?, NgaySinh = ?, Email = ?, GhiChu = ? Where Id = ?";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@MaKhachHang", OleDbType.WChar).Value = itemDTO.MaKhachHang;
cmd.Parameters.Add("@HoKhachHang", OleDbType.WChar).Value = itemDTO.HoKhachHang;
cmd.Parameters.Add("@TenKhachHang", OleDbType.WChar).Value = itemDTO.TenKhachHang;
cmd.Parameters.Add("@IdNhomKhachHang", OleDbType.Numeric).Value = itemDTO.IdNhomKhachHang;
cmd.Parameters.Add("@DiaChi", OleDbType.WChar).Value = itemDTO.DiaChi;
cmd.Parameters.Add("@DienThoai", OleDbType.WChar).Value = itemDTO.DienThoai;
cmd.Parameters.Add("@NgaySinh", OleDbType.DBDate).Value = itemDTO.NgaySinh;
cmd.Parameters.Add("@Email", OleDbType.WChar).Value = itemDTO.Email;
cmd.Parameters.Add("@GhiChu", OleDbType.WChar).Value = itemDTO.GhiChu;
cmd.Parameters.Add("@Id", OleDbType.Numeric).Value = itemDTO.Id;
cmd.ExecuteNonQuery();
cn.Close();
}
public void Them(KhachHangDTO itemDTO)
{
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "Insert into DanhMucKhachHang (MaKhachHang, HoKhachHang, TenKhachHang, IdNhomKhachHang, DiaChi, DienThoai, NgaySinh, Email, GhiChu) values (?, ?, ?, ?, ?, ?, ?, ?, ?)";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@MaKhachHang", OleDbType.WChar).Value = itemDTO.MaKhachHang;
cmd.Parameters.Add("@HoKhachHang", OleDbType.WChar).Value = itemDTO.HoKhachHang;
cmd.Parameters.Add("@TenKhachHang", OleDbType.WChar).Value = itemDTO.TenKhachHang;
cmd.Parameters.Add("@IdNhomKhachHang", OleDbType.Numeric).Value = itemDTO.IdNhomKhachHang;
cmd.Parameters.Add("@DiaChi", OleDbType.WChar).Value = itemDTO.DiaChi;
cmd.Parameters.Add("@DienThoai", OleDbType.WChar).Value = itemDTO.DienThoai;
cmd.Parameters.Add("@NgaySinh", OleDbType.DBDate).Value = itemDTO.NgaySinh;
cmd.Parameters.Add("@Email", OleDbType.WChar).Value = itemDTO.Email;
cmd.Parameters.Add("@GhiChu", OleDbType.WChar).Value = itemDTO.GhiChu;
cmd.ExecuteNonQuery();
cn.Close();
}
public KhachHang_Sua(string maKH)
{
InitializeComponent();
khachhang = KhachHangDAO.Instance.GetKhach(maKH);
fillInput();
}
public static List <KhachHangDTO> DSKHTheoTenCMND(KhachHangDTO thongtin)
{
return(CustomerDAO.DSKHTheoTenCMND(thongtin));
}
public static bool ThemKhachHang(KhachHangDTO kh)
{
return(CustomerDAO.ThemKhachHang(kh));
}
private void frmChiTietDonHang_Load(object sender, EventArgs e)
{
int maDH = frmQuanLyDonHang.gMaDH;
KhachHangBUS khBus = new KhachHangBUS();
KhachHangDTO khDto = new KhachHangDTO();
DonHangBUS dhBus = new DonHangBUS();
DonHangDTO dhDto = new DonHangDTO();
ChiTietDonHangBUS ctdhBus = new ChiTietDonHangBUS();
khDto = khBus.LayThongTinKhachHangTuMaDonHang(maDH);
dhDto = dhBus.LayBangMaDonHang(maDH);
cbmTrangThai.DataSource = TrangThaiDonHangBUS.GetList();
cbmTrangThai.DisplayMember = "TrangThai";
cbmTrangThai.ValueMember = "MaTrangThai";
cbmTrangThai.SelectedValue = dhDto.TrangThai;
txtMaKH.Text = khDto.MaKhachHang.ToString();
txtTenKH.Text = khDto.HoTen;
txtDiaChi.Text = khDto.DiaChi;
txtDienThoai.Text = khDto.DienThoai;
txtEmail.Text = khDto.Email;
txtFacebook.Text = khDto.Facebook;
txtTKNganHang.Text = khDto.TKNganHang;
lbSoLuong.Text = dhDto.SoLuongSanPham.ToString();
lbTongTien.Text = dhDto.TongTien.ToString("n0");
txtPhiVanChuyen.Text = dhDto.PhiVanChuyen.ToString("n0");
if (dhDto.HinhThucMua == 0)
{
rdGiaSi.Checked = true;
rdGiaLe.Checked = false;
}
else
{
rdGiaLe.Checked = true;
rdGiaSi.Checked = false;
}
dt = ctdhBus.LayDanhSachSanPham(maDH);
dtgvDanhSachSanPham.DataSource = dt;
DataGridViewImageColumn imageCol = new DataGridViewImageColumn();
imageCol.Name = "img";
imageCol.HeaderText = "Hinh Anh";
imageCol.Width = _colWidth;
dtgvDanhSachSanPham.Columns.Insert(2, imageCol);
DataGridViewButtonColumn btnColumn = new DataGridViewButtonColumn();
btnColumn.HeaderText = "";
btnColumn.Text = "Xóa";
btnColumn.UseColumnTextForButtonValue = true;
dtgvDanhSachSanPham.Columns.Add(btnColumn);
formatData();
_firstLoad = false;
}
private void btnSua_Click(object sender, EventArgs e)
{
if (lsvKhachhang.SelectedItems.Count <= 0) return;
string fe = lsvKhachhang.SelectedItems[0].SubItems[0].Text;
if (tenkh() && cmnd())
{
khDTO = new KhachHangDTO();
khDTO.Makhachhang = fe;
khDTO.Tenkhachhang = txtTenKH.Text;
khDTO.Gioitinh = rdNam.Checked;
khDTO.CMND_PASSPORT = txtCMND.Text;
khDTO.Diachi = txtDiachi.Text;
khDTO.Pass = txtPass.Text;
khDTO.Sodienthoai = txtSoDT.Text;
khDTO.Email = txtEmail.Text;
khg.updateKhachHang(khDTO);
tim(fe);
}
}
public string insert(KhachHangDTO obj)
{
return(dal.insert(obj));
}
public void Sua(KhachHangDTO itemDTO)
{
KhachHangDAO itemDAO = new KhachHangDAO();
itemDAO.Sua(itemDTO);
}
public Result Insert(KhachHangDTO khachHangDTO)
{
return(khachHangDAO.Insert(khachHangDTO));
}
public static DataTable Serch_TenKH(KhachHangDTO kh)
{
return(KhachHangDAO.Search_TenKH(kh));
}
public static void Delete_KH(KhachHangDTO kh)
{
KhachHangDAO.Delete_KH(kh);
}
public static void Update_KH(KhachHangDTO kh)
{
KhachHangDAO.Update_KH(kh);
}
private void btnThem_Click(object sender, EventArgs e)
{
if (kiemtra())
{
khDTO = new KhachHangDTO();
khDTO.Makhachhang = txtMKH.Text;
khDTO.Tenkhachhang = txtTenKH.Text;
khDTO.Gioitinh = rdNam.Checked;
khDTO.CMND_PASSPORT = txtCMND.Text;
khDTO.Diachi = txtDiachi.Text;
khDTO.Pass = txtPass.Text;
khDTO.Sodienthoai = txtSoDT.Text;
khDTO.Email = txtEmail.Text;
if (khg.insertKhachHang(khDTO) == 1)
{
tim(khDTO.Makhachhang);
}
else
{
MessageBox.Show("Mã khách hàng đã có!");
txtMKH.Clear();
txtMKH.Focus();
return;
}
}
}
private void btnTraCuu_Click(object sender, EventArgs e)
{
if (dgvMatHang.Rows.Count > 0)
{
dgvMatHang.Rows.Clear();
}
DateTime dtNgayBD = dtTuNgay.Value;
DateTime dtNgayKT = dtDenNgay.Value;
string strKhachHang = "0";
if (cbxNhaCC.Checked == true)
{
strKhachHang = cmbKhachHang.SelectedValue.ToString();
}
DataTable dtXuatKho = new DataTable();
dtXuatKho = bllXuatKho.TimKiem(dtNgayBD, dtNgayKT, strKhachHang);
for (int i = 0; i < dtXuatKho.Rows.Count; i++)
{
dgvMatHang.Rows.Add();
string strIDKhachHang = dtXuatKho.Rows[i]["MAKHACHHANG"].ToString();
KhachHangDTO dtoKhachHang = new KhachHangDTO();
dtoKhachHang = bllKhachHang.GetKhachHangByID(strIDKhachHang);
dgvMatHang.Rows[i].Cells[0].Value = dtoKhachHang.TenKH;
dgvMatHang.Rows[i].Cells[0].Tag = strIDKhachHang;
// Nếu dư nợ - thì cần phải thanh toán
// Nếu dư nợ + thì đã thanh toán
if (dtoKhachHang.DuNo < 0)
{
dgvMatHang.Rows[i].Cells[1].Value = Math.Abs(dtoKhachHang.DuNo);
}
else if (dtoKhachHang.DuNo > 0)
{
dgvMatHang.Rows[i].Cells[2].Value = dtoKhachHang.DuNo;
}
else
{
dgvMatHang.Rows[i].Cells[1].Value = 0;
dgvMatHang.Rows[i].Cells[2].Value = 0;
}
// Phải thanh toán
double dbPhaiThanhToan = double.Parse(dtXuatKho.Rows[i]["THANHTIEN"].ToString());
dgvMatHang.Rows[i].Cells[3].Value = dbPhaiThanhToan;
// Đã thanh toán
double dbDaThanhToan = 0;
DataTable dtPhieuThu = new DataTable();
dtPhieuThu = bllPhieuThu.TimKiem(strIDKhachHang, dtNgayBD, dtNgayKT);
if (dtPhieuThu.Rows.Count > 0)
{
dbDaThanhToan = double.Parse(dtPhieuThu.Rows[0]["THANHTIEN"].ToString());
dgvMatHang.Rows[i].Cells[4].Value = dbDaThanhToan;
}
// Tính dư nợ cuối kỳ và đầu kỳ
double dbDuNo = dtoKhachHang.DuNo - (dbPhaiThanhToan - dbDaThanhToan);
if (dbDuNo < 0)
{
dgvMatHang.Rows[i].Cells[5].Value = Math.Abs(dbDuNo);
}
else
{
dgvMatHang.Rows[i].Cells[6].Value = dbDuNo;
}
btnChiTiet.Enabled = true;
}
}
public Result Update(KhachHangDTO khachHangDTO)
{
return(khachHangDAO.Update(khachHangDTO));
}
public static bool LuuThongTinKH(KhachHangDTO khachHangDTO)
{
return(DAL.KhachHangDAL.LuuThongTinKhachHang(khachHangDTO));
}
public static void saveKH(KhachHangDTO kh, string method)
{
D_KhachHang.saveKH(kh, method);
}
public int InsertKhachHang(KhachHangDTO kDTO)
{
return ws.InsertKhachHang(kDTO);
}
public List <HoaDonDTO> LayDanhSachHoaDon(KhachHangDTO NhanVien, int MaKH, DateTime NgayLap, decimal ThanhTien)
{
return(dao.LayDanhSachHoaDon(NhanVien, MaKH, NgayLap, ThanhTien));
}
public void RefreshDataBinding(PhongDTO phongDTO, ThuePhongDTO thuePhongDTO = null)
{
phong = phongDTO;
txtMaPhong.EditValue = phongDTO.MaPhong;
txtTenPhong.EditValue = phongDTO.TenPhong;
txtLoaiPhong.EditValue = BUS.LoaiPhongBUS.LayLoaiPhong(phongDTO).TenLoaiPhong;
txtTang.EditValue = phongDTO.Tang;
RefreshDataBindingDatPhong();
//Phòng trống
if (thuePhongDTO == null)
{
DisplayControlForRented(false);
for (int i = 0; i < wbntQuanlyphong.Buttons.Count; i++)
{
wbntQuanlyphong.Buttons[i].Properties.Visible = false;
}
}
else
{
DisplayControlForRented(true);
if (HoaDonBUS.LayThongTinHoaDon(thuePhongDTO.MaHoaDon).MaDatPhong == -1)
{
wbntQuanlyphong.Buttons[7].Properties.Visible = false;
wbntQuanlyphong.Buttons["Thông tin đặt phòng"].Properties.Visible = false;
}
else
{
wbntQuanlyphong.Buttons["Thông tin đặt phòng"].Properties.Visible = true;
}
thuePhong = thuePhongDTO;
hoaDon = BUS.HoaDonBUS.LayThongTinHoaDonDangThue(thuePhong.MaHoaDon);
khachHang = BUS.KhachHangBUS.LayKhachHang(hoaDon.MaKH);
txtMaKH.EditValue = khachHang.MaKH;
txtTenKH.EditValue = khachHang.TenKH;
txtLoaiKH.EditValue = BUS.LoaiKhachHangBUS.LayLoaiKhachHang(khachHang).TenLoaiKH;
txtSDT.EditValue = khachHang.SDT;
txtDiemTichLuy.EditValue = khachHang.DiemTichLuy;
txtNgayGioVao.EditValue = thuePhong.GioThuePhong.ToString("dd-MM-yyyy hh:mm:ss");
txtGioTraPhong.EditValue = (thuePhong.GioTraPhong == DateTime.MinValue) ? "Chưa có" : thuePhong.GioTraPhong.ToString("dd-MM-yyyy hh:mm:ss");
txtTienTraTruoc.EditValue = hoaDon.TienTraTruoc;
txtMaHoaDon.EditValue = hoaDon.MaHoaDon;
txtGhiChu.EditValue = hoaDon.GhiChu;
//Phòng đang được thuê
if (thuePhongDTO.GioTraPhong == DateTime.MinValue)
{
txtSoGio.EditValue = ToCustomString((DateTime.Now - thuePhong.GioThuePhong));
}
else //Phòng đã được trả
{
txtSoGio.EditValue = ToCustomString((thuePhong.GioTraPhong - thuePhong.GioThuePhong));
wbntQuanlyphong.Buttons["Chuyển Phòng"].Properties.Visible = false;
wbntQuanlyphong.Buttons["Trả Phòng"].Properties.Visible = false;
}
RefreshDataBindingDichVuPhong();
}
}
public int UpdateKhachHang(KhachHangDTO kDTO)
{
return ws.UpdateKhachHang(kDTO);
}
private void TimKiemTheoYeuCau(int s)
{
KhachHangDTO thongtin = LayThongTinTimKiem();
if (s == 1)
{
gcDanhSachKhachHang.DataSource = CustomerBUS.DSKHTheoTen(thongtin);
}
else if (s == 2)
{
gcDanhSachKhachHang.DataSource = CustomerBUS.DSKHTheoTenDiaChi(thongtin);
}
else if (s == 3)
{
gcDanhSachKhachHang.DataSource = CustomerBUS.DSKHTheoTenLoaiKhach(thongtin);
}
else if (s == 4)
{
gcDanhSachKhachHang.DataSource = CustomerBUS.DSKHTheoTenDiaChiLoaiKhach(thongtin);
}
else if (s == 5)
{
gcDanhSachKhachHang.DataSource = CustomerBUS.DSKHTheoLoaiKhach(thongtin);
}
else if (s == 6)
{
gcDanhSachKhachHang.DataSource = CustomerBUS.DSKHTheoLoaiKhachDiaChi(thongtin);
}
else if (s == 7)
{
gcDanhSachKhachHang.DataSource = CustomerBUS.DSKHTheoDiaChi(thongtin);
}
else if (s == 8)
{
gcDanhSachKhachHang.DataSource = CustomerBUS.DanhSachKhachHang();
}
else if (s == 9)
{
gcDanhSachKhachHang.DataSource = CustomerBUS.DSKHTheoCMND(thongtin);
}
else if (s == 10)
{
gcDanhSachKhachHang.DataSource = CustomerBUS.DSKHTheoTenDiaChiLoaiKhachCMND(thongtin);
}
else if (s == 11)
{
gcDanhSachKhachHang.DataSource = CustomerBUS.DSKHTheoTenDiaChiCMND(thongtin);
}
else if (s == 12)
{
gcDanhSachKhachHang.DataSource = CustomerBUS.DSKHTheoTenLoaiKhachCMND(thongtin);
}
else if (s == 13)
{
gcDanhSachKhachHang.DataSource = CustomerBUS.DSKHLoaiKhachCMND(thongtin);
}
else if (s == 14)
{
gcDanhSachKhachHang.DataSource = CustomerBUS.DSKHDiaChiLoaiKhachCMND(thongtin);
}
else if (s == 15)
{
gcDanhSachKhachHang.DataSource = CustomerBUS.DSKHDiaChiCMND(thongtin);
}
else if (s == 16)
{
gcDanhSachKhachHang.DataSource = CustomerBUS.DSKHTheoTenCMND(thongtin);
}
}
public bool ThemKH(KhachHangDTO DTO)
{
KhachHangDAO dao = new KhachHangDAO();
return(dao.ThemKH(DTO));
}
public int LapHoaDon(KhachHangDTO NhanVien, int MaDP)
{
return(dao.LapHoaDon(NhanVien, MaDP));
}
public bool XoaTTKH(KhachHangDTO DTO)
{
KhachHangDAO dao = new KhachHangDAO();
return(dao.XoaKH(DTO));
}
public static bool XoaKhachHang(KhachHangDTO id)
{
return(CustomerDAO.XoaKhachHang(id));
}
public int ThemKhachHang(KhachHangDTO khachhang, TheThanhToanDTO the)
{
KhachHangBUS khachhangBUS = new KhachHangBUS();
return(khachhangBUS.ThemKhachHang(khachhang, the));
}
public static List <KhachHangDTO> DSKHTheoDiaChi(KhachHangDTO thongtin)
{
return(CustomerDAO.DSKHTheoDiaChi(thongtin));
}
private void gvDanhMucKhachHang_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e)
{
if (gvDanhMucKhachHang.FocusedRowHandle > -1)
{
try
{
KhachHangDTO itemDTO = new KhachHangDTO();
KhachHangBUS itemBUS = new KhachHangBUS();
MD5 maHoa = new MD5();
itemDTO.MaKhachHang = gvDanhMucKhachHang.GetFocusedRowCellValue("MaKhachHang").ToString();
itemDTO.HoKhachHang = gvDanhMucKhachHang.GetFocusedRowCellValue("HoKhachHang").ToString();
itemDTO.TenKhachHang = gvDanhMucKhachHang.GetFocusedRowCellValue("TenKhachHang").ToString();
itemDTO.IdNhomKhachHang = int.Parse(gvDanhMucKhachHang.GetFocusedRowCellValue("IdNhomKhachHang").ToString());
itemDTO.DiaChi = gvDanhMucKhachHang.GetFocusedRowCellValue("DiaChi").ToString();
itemDTO.DienThoai = gvDanhMucKhachHang.GetFocusedRowCellValue("DienThoai").ToString();
itemDTO.NgaySinh = DateTime.Parse(gvDanhMucKhachHang.GetFocusedRowCellValue("NgaySinh").ToString());
itemDTO.Email = gvDanhMucKhachHang.GetFocusedRowCellValue("Email").ToString();
itemDTO.GhiChu = gvDanhMucKhachHang.GetFocusedRowCellValue("GhiChu").ToString();
itemDTO.Id = int.Parse(gvDanhMucKhachHang.GetFocusedRowCellValue("Id").ToString());
if (this.flagThem && gvDanhMucKhachHang.FocusedRowHandle == gvDanhMucKhachHang.RowCount - 2)
{
if (itemDTO.MaKhachHang.Length > 0)
{
DialogResult hopThoai = MessageBox.Show("Bạn chắc chắn muốn thêm mới?", "Thêm mới", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (hopThoai == DialogResult.Yes)
{
itemBUS.Them(itemDTO);
this.flagThem = false;
}
}
else
{
MessageBox.Show("Bạn chưa nhập mã!", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
DialogResult hopThoai = MessageBox.Show("Bạn chắc chắn muốn cập nhật?", "Cập nhật", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (hopThoai == DialogResult.Yes)
{
itemBUS.Sua(itemDTO);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
this.LayDanhSachKhachHang();
}
}
public static List <KhachHangDTO> DSKHDiaChiLoaiKhachCMND(KhachHangDTO thongtin)
{
return(CustomerDAO.DSKHDiaChiLoaiKhachCMND(thongtin));
}
private void btnbosung_Click(object sender, EventArgs e)
{
DataTable dt = ThamSoDAO.GetThamSoAll();
int nomax = int.Parse(dt.Rows[0].ItemArray[3].ToString());
int luongtonaftersell = int.Parse(dt.Rows[0].ItemArray[4].ToString());
DataTable dt2 = ThamSoDAO.SlectTienNoKH(int.Parse(txtmakhct.Text));
int tienno = int.Parse(dt2.Rows[0].ItemArray[5].ToString());
HoaDonDTO hd = new HoaDonDTO();
try
{
hd.MaHoaDon = int.Parse(txtmahdct.Text);
}
catch (FormatException)
{
MessageBox.Show("Không được để trống");
return;
}
try
{
hd.MaSach = int.Parse(txtmasach.Text);
}
catch (FormatException)
{
MessageBox.Show("Mã sách phải được chọn từ danh sách");
btnmasach_Click(sender, e);
return;
}
try
{
hd.SoLuongMua = uint.Parse(txtsoluongmua.Text);
}
catch (FormatException)
{
MessageBox.Show("Số lượng mua phải là số và không được để trống");
}
catch (OverflowException)
{
MessageBox.Show("Số lượng không được âm");
}
if (tienno <= nomax)
{
DataTable dt3 = ThamSoDAO.SlectSoLuongTon(hd.MaSach);
int luongton = int.Parse(dt3.Rows[0].ItemArray[3].ToString());
int luongmua = int.Parse(txtsoluongmua.Text);
int tongtien = tienno + (luongmua * int.Parse(txtdongia.Text));
if ((luongton - luongmua) < luongtonaftersell)
{
MessageBox.Show("Số lượng tồn của sách này sau khi bán đã nhỏ hơn quy định");
return;
}
if (HoaDonBUS.ThemHoaDonChiTiet(hd) == false)
{
MessageBox.Show("Sách này đã có rồi");
}
else
{
int soluongtonnew = luongton - luongmua;
SachDTO s = new SachDTO();
s.MaSach = int.Parse(txtmasach.Text);
s.SoLuongTon = soluongtonnew;
SachDAO.UpdateSoLuongTon(s);
KhachHangDTO kh = new KhachHangDTO();
kh.MaKhachHang = int.Parse(txtmakhct.Text);
kh.TienNo = tongtien;
KhachHangDAO.UpdateTienNo(kh);
BaoCaoTonDTO bc = new BaoCaoTonDTO();
bc.MaSach = s.MaSach;
bc.NgayPhatSinh = dtngaylaphoadon.Value;
bc.PhatSinh = "Bán sách";
bc.TonDau = luongton;
bc.TonCuoi = soluongtonnew;
BaoCaoTonDAO.Insert(bc);
BaoCaoCongNoDTO cn = new BaoCaoCongNoDTO();
cn.MaKhachHang = kh.MaKhachHang;
cn.NgayPhatSinh = bc.NgayPhatSinh;
cn.NoDau = tienno;
cn.NoCuoi = tongtien;
cn.PhatSinh = "Hóa đơn bán sách";
BaoCaoCongNoDAO.Insert(cn);
MessageBox.Show("Thành công");
hienthidscthoadon();
}
}
else
{
MessageBox.Show("Tiền nợ quý khách đã quá quy định để mua sách");
}
}
public bool AddData(KhachHangDTO kh)
{
return(khachHangDAL.AddData(kh));
}
public static void InsertKhachHang(KhachHangDTO kh)
{
DAO.KhachHangDAO.InsertKhachHang(kh);
}
public void BindingData(DataSet dsHoaDon, KhachHangDTO khachHang, HoaDonDTO hoaDon, double TongTienGio, double TongTienKhuyenMai, double TongTienDichVu, double TienTraTruoc, string ghiChu, bool isHoaDonTamTinh = false)
{
if (isHoaDonTamTinh)
{
xrLabel1.Text = "HÓA ĐƠN TẠM TÍNH";
}
DataSource = dsHoaDon;
DataMember = "thuephong";
lbNgayThanhToan.Text = hoaDon.NgayThanhToan.ToString("dd/MM/yyyy HH:mm:ss");
GroupHeader1.GroupFields.Clear();
GroupHeader1.GroupUnion = GroupUnion.WithFirstDetail;
GroupHeader1.GroupFields.Add(new GroupField("MaThuePhong"));
//GroupHeader1.GroupFields.Add(new GroupField("thuephong.MaThuePhong"));
//GroupHeader1.GroupFields.Add(new GroupField("thuephong.GioThuePhong"));
//Group Header 1
xrLabel3.DataBindings.Add("Text", null, "thuephong.MaThuePhong");
lbTenPhong.DataBindings.Add("Text", null, "thuephong.TenPhong");
lbMaPhong.DataBindings.Add("Text", null, "thuephong.MaPhong");
lbLoaiPhong.DataBindings.Add("Text", null, "thuephong.TenLoaiPhong");
lbGioVao.DataBindings.Add("Text", null, "thuephong.GioThuePhong");
lbGioRa.DataBindings.Add("Text", null, "thuephong.GioTraPhong");
lbTienphong.DataBindings.Add("Text", null, "thuephong.TienPhong");
//Group Header 2
lbLoaiDichVu.DataBindings.Add("Text", null, "colType");
//Detail
string detailDataMember = string.Format("{0}.{1}", dsHoaDon.Tables[1].TableName, dsHoaDon.Relations[1].RelationName);
DetailReport.DataSource = dsHoaDon;
DetailReport.DataMember = detailDataMember;
GroupHeader3.GroupFields.Clear();
GroupHeader3.GroupFields.Add(new GroupField("colType"));
lbLoaiDichVu.DataBindings.Add("Text", null, detailDataMember + ".colType");
xrTableCell4.DataBindings.Add("Text", null, detailDataMember + ".TenDV");
xrTableCell6.DataBindings.Add("Text", null, detailDataMember + ".DonVi");
xrTableCell8.DataBindings.Add("Text", null, detailDataMember + ".SoLuong");
xrTableCell12.DataBindings.Add("Text", null, detailDataMember + ".Gia");
//lbTenDV.DataBindings.Add("Text", null, detailDataMember+".TenDV");
//lbDonViTinh.DataBindings.Add("Text", null, "dichvuphong.DonVi");
//lbSoLuong.DataBindings.Add("Text", null, "dichvuphong.SoLuong");
//lbDonGia.DataBindings.Add("Text", null, "dichvuphong.Gia");
xrTableCell13.ExpressionBindings.Add(new ExpressionBinding("BeforePrint", "Text", detailDataMember + ".SoLuong * " + detailDataMember + ".Gia"));
//Group Footer 2
lbTongTienDV_Type.ExpressionBindings.Add(new ExpressionBinding("BeforePrint", "Text", "sumSum( " + detailDataMember + ".SoLuong * " + detailDataMember + ".Gia)"));
//Group Footer 1
lbTongTienDV.ExpressionBindings.Add(new ExpressionBinding("BeforePrint", "Text", "sumSum( " + detailDataMember + ".SoLuong * " + detailDataMember + ".Gia)"));
//lbTongTienDV.DataBindings.Add("Text", null, "Sum(SoLuong)");
// lbTienDV.DataBindings.Add("Text", null, (Convert.ToInt32(lbDonGia.Text)* Convert.ToInt32(lbSoLuong.Text)).ToString() );
lbMaHoaDon.Text = "#" + hoaDon.MaHoaDon.ToString();
//lbNgayThanhToan.Text = dsHoaDon.Rows[0]["ThoiGian"].ToString();
lbTenKH.Text = khachHang.TenKH;
lbLoaiKH.Text = BUS.LoaiKhachHangBUS.LayLoaiKhachHang(khachHang).TenLoaiKH;
lbDiemTichLuy.Text = khachHang.DiemTichLuy.ToString("###,###,##0");
xrTableCell15.Text = (TongTienGio).ToString("###,###,##0 VNĐ");
lbTienHoaDon.Text = (TongTienDichVu).ToString("###,###,##0 VNĐ");
lbTienKhuyenMai.Text = TongTienKhuyenMai.ToString("###,###,##0 VNĐ");
lbThanhTien.Text = TienTraTruoc.ToString("###,###,##0 VNĐ");
lbTongThanhTien.Text = (TongTienDichVu + TongTienGio + TongTienKhuyenMai - TienTraTruoc).ToString("###,###,##0 VNĐ");
xrTableCell18.Text = ghiChu;
}
public static void UpdateKhachHang(KhachHangDTO kh)
{
DAO.KhachHangDAO.UpdateKhachHang(kh);
}
public static bool CapNhatThongTinKhachHang(KhachHangDTO khachHangDTO)
{
return(DAL.KhachHangDAL.CapNhatThongTinKhachHang(khachHangDTO));
}
public static NpgsqlDataAdapter TimKiemKhachHang(KhachHangDTO kh)
{
return(DAO.KhachHangLapPhieuThueDAO.TimKiemKhachHang(kh));
}
public void Them(KhachHangDTO itemDTO)
{
KhachHangDAO itemDAO = new KhachHangDAO();
itemDAO.Them(itemDTO);
}
private void txt_MaKH_TextChanged(object sender, EventArgs e)
{
KhachHangDTO[] khDTO = new KhachHangDTO[1];
khDTO = ws.getKhachHangById(txt_MaKH.Text);
if (khDTO.Length > 0)
{
txt_MaKhachHangDD.Text = khDTO[0].KhachHangDaiDien.ToString();
txt_TenKH.Text = khDTO[0].TenKhachHang.ToString();
}
else
{
txt_MaKhachHangDD.Text = "...";
txt_TenKH.Text = "...";
}
}
