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 = "..."; } }