private void btnHoanTat_Click(object sender, EventArgs e) { if(dataGVGioHang.Rows.Count > 0) { string tenKH = tbTen_KH.Text; string email = tbEmail_KH.Text; string sdt = tbSDT_KH.Text; string ngaySinh = dtPickerNgaySinh_KH.Value.Date.ToString("dd/MM/yyyy"); int maKH = GetMaKH(tenKH, email, sdt, ngaySinh); string ngayBan = DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss"); int maNV = nv.MaNV; HoaDonDAO.InsertHoaDon(maNV, maKH, ngayBan); string maHD = HoaDonDAO.GetMaHoaDonByCondition(maNV, maKH, ngayBan); foreach(DataGridViewRow record in dataGVGioHang.Rows) { string maSach = record.Cells["colMaSach"].Value.ToString(); int soLuong = Convert.ToInt32(record.Cells["colSoLuong"].Value); double gia = Convert.ToDouble(record.Cells["colGia"].Value); if (CTHD_DAO.InsertCTHD(maHD, maSach, soLuong, gia)) { SachDAO.UpdateSoLuong(maSach, getQuantityInStockByMaSach(maSach) - soLuong); } } MessageBox.Show("Hoàn tất đơn hàng"); Dispose(); FormBanSach newForm = new FormBanSach(this.nv, SachDAO.LoadSach()); newForm.Show(); } else { MessageBox.Show("Chưa có sản phẩm nào trong giỏ hàng"); } }
public static DataTable LoadCTHDTheoMHD(int mahoadon) { return(CTHD_DAO.LoadCTHDTheoMHD(mahoadon)); }
public static bool ThemCTHD(CTHD_DTO cthd) { return(CTHD_DAO.ThemCTHD(cthd)); }
public static void Them(CTVE_DTO ctve) { CTHD_DAO.Them(ctve); }
public static DataTable Load_CTHD(string sohd) { return(CTHD_DAO.Load_CTHD(sohd)); }
public static DataTable XuatCTHoaDon(int MaHoaDon) { return(CTHD_DAO.XuatCTHoaDon(MaHoaDon)); }
public static void TaoCTHoaDon(int MaBN) { CTHD_DAO.TaoCTHoaDon(MaBN); }