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