public bool Add(ClassDetailBill.DetailBill detailBill)
{
string query = "INSERT INTO CTHoaDon VALUES ( @MaHD , @MaSP , @SoLuong )";
object[] para = new object[] { detailBill.MaHD, detailBill.MaSP, detailBill.SoLuong };
if (DataProvider.Instance.ExecuteNonQuery(query, para) > 0)
{
return(true);
}
return(false);
}
public bool Edit(ClassDetailBill.DetailBill detailBill)
{
string MaHD = detailBill.MaHD;
string MaSP = detailBill.MaSP;
string query = "UPDATE CTHoaDon SET SoLuong = @SoLuong WHERE MaHD = @MaHD AND MaSP = @MaSP ";
object[] para = new object[] { detailBill.SoLuong, detailBill.MaHD, detailBill.MaSP };
if (DataProvider.Instance.ExecuteNonQuery(query, para) > 0)
{
return(true);
}
return(false);
}