public bool DeleteCTPhieuQLK(eCTQLKho delid)
{
try
{
Tbl_CTPhieuQLKho deletema = DB.Tbl_CTPhieuQLKhos.Single(x => x.maPhieuql == delid._maPhieuQL && x.maSP == delid._masp);
DB.Tbl_CTPhieuQLKhos.DeleteOnSubmit(deletema);
DB.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool UpdateCTPQLKho(eCTPhieuQlyKho updatectpqlk)
{
try
{
Tbl_CTPhieuQLKho ctpqlk = DB.Tbl_CTPhieuQLKhos.Single(x => x.maPhieuql == updatectpqlk._maPhieuQly && x.maSP == updatectpqlk._maSP);
ctpqlk.tenSP = updatectpqlk._tenSP;
ctpqlk.sTT = updatectpqlk._sTT;
ctpqlk.sLuongql = updatectpqlk._soLuongQly;
ctpqlk.donVi = updatectpqlk._donVi;
DB.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool UpdateCTPQLKho(eCTQLKho updatectpqlk)
{
try
{
Tbl_CTPhieuQLKho ctpqlk = DB.Tbl_CTPhieuQLKhos.Single(x => x.maPhieuql == updatectpqlk._maPhieuQL && x.maSP == updatectpqlk._masp);
ctpqlk.maSP = updatectpqlk._masp;
ctpqlk.maPhieuql = updatectpqlk._maPhieuQL;
ctpqlk.tenSP = updatectpqlk._tensp;
ctpqlk.sTT = updatectpqlk._sott;
ctpqlk.sLuongql = updatectpqlk._soluongql;
ctpqlk.donVi = updatectpqlk._donvi;
DB.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool AddAllCTPQLKho(eCTQLKho newctpqlk)
{
try
{
Tbl_CTPhieuQLKho ctpqlk = DB.Tbl_CTPhieuQLKhos.Single(x => x.maPhieuql == newctpqlk._maPhieuQL && x.maSP == newctpqlk._masp);
ctpqlk.maPhieuql = newctpqlk._maPhieuQL;
ctpqlk.maSP = newctpqlk._masp;
ctpqlk.sTT = newctpqlk._sott;
ctpqlk.tenSP = newctpqlk._tensp;
ctpqlk.sLuongql = newctpqlk._soluongql;
ctpqlk.donVi = newctpqlk._donvi;
DB.Tbl_CTPhieuQLKhos.InsertOnSubmit(ctpqlk);
DB.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
