public void CapNhatCTHD(CTHD ct)
{
DAO_CTHD dao = new DAO_CTHD();
dao.Open();
dao.CapNhatCTHD(ct);
dao.Close();
}
public void XoaCTHD(int MaHD)
{
DAO_CTHD dao = new DAO_CTHD();
dao.Open();
string qry = "delete from ChiTiet_HoaDon where MaHD = " + MaHD;
SqlCommand cmd = new SqlCommand(qry, dao.cnn);
cmd.ExecuteNonQuery();
cmd.Dispose();
dao.Close();
}
public DataTable LoadCTHD(int MaHD)
{
DataTable dt = new DataTable();
DAO_CTHD dao = new DAO_CTHD();
dao.Open();
string qry = "select MaHD,s.MaSP as MaSP,TenSP,Size,SoLuong,DonGia from ChiTiet_HoaDon c , SanPham s,Size si where c.MaSP = s.MaSP and c.MaSize = si.MaSize and c.MaHD = " + MaHD;
SqlCommand cmd = new SqlCommand(qry, dao.cnn);
SqlDataReader reader = cmd.ExecuteReader();
dt.Load(reader);
cmd.Dispose();
reader.Dispose();
dao.Close();
return(dt);
}
public void CapNhatCTHD(CTHD cthd)
{
DAO_CTHD dao = new DAO_CTHD();
dao.Open();
string qry = "CapNhatSoLuong";
SqlCommand cmd = new SqlCommand(qry, dao.cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@MaHD", SqlDbType.Int).Value = cthd.MAHD;
cmd.Parameters.Add("@MaSP", SqlDbType.Int).Value = cthd.MASP;
cmd.Parameters.Add("@MaSize", SqlDbType.Int).Value = cthd.MASIZE;
cmd.Parameters.Add("@SoLuong", SqlDbType.Int).Value = cthd.SOLUONG;
cmd.Parameters.Add("@DonGia", SqlDbType.Int).Value = cthd.DONGIA;
cmd.Parameters.Add("@flag", SqlDbType.Int).Value = 1;
cmd.ExecuteNonQuery();
dao.Close();
cmd.Dispose();
}