public bool KiemTraTonTai(int madt, int masp)
{
CTDonTraHang CT = CTDonTraHangDAC.Instance.DocThongTin(madt, masp);
if (CT == null)
{
return(true);//Chưa tồn tại
}
return(false);
}
public bool Sua(CTDonTraHang dth)
{
string query = "Update CTDONTRAHANG set SoLuong = @SoLuong Where MaDTH = @MaDTH and MaSP = @MaSP ";
object[] para = new object[] { dth.SoLuong, dth.MaDTH, dth.MaSP };
if (DataProvider.Instance.ExecuteNonQuery(query, para) > 0)
{
return(true);
}
return(false);
}
public bool Them(CTDonTraHang dth)
{
string query = "Insert INTO CTDonTraHang( MaDTH , MaSP, SoLuong) VALUES ( @MaDTH , @MaSP , @SoLuong ) ";
object[] para = new object[] { dth.MaDTH, dth.MaSP, dth.SoLuong };
if (DataProvider.Instance.ExecuteNonQuery(query, para) > 0)
{
return(true);
}
return(false);
}
public CTDonTraHang DocThongTin(int madth, int masp)
{
string query = "Select * From CTDonTraHang where MaDTH = @MaDTH and MaSP = @MaSP";
object[] para = new object[] { madth, masp };
DataTable data = DataProvider.Instance.ExecuteQuery(query, para);
foreach (DataRow item in data.Rows)
{
int MaDTH = (int)item["MaDTH"];
int MaSP = (int)item["MaSP"];
int SoLuong = (int)item["SoLuong"];
CTDonTraHang newct = new CTDonTraHang(MaDTH, MaSP, SoLuong);
return(newct);
}
return(null);
}
public bool Sua(CTDonTraHang dth)
{
return(CTDonTraHangDAC.Instance.Sua(dth));
}
public bool Them(CTDonTraHang ctdth)
{
return(CTDonTraHangDAC.Instance.Them(ctdth));
}
