public void xoaCTDDH(int manl, int maddh)
{
CT_DDH dh = ql.CT_DDHs.Where(ct => ct.MaNL == manl && ct.MaDDH == maddh).FirstOrDefault();
if (dh != null)
{
ql.CT_DDHs.DeleteOnSubmit(dh);
ql.SubmitChanges();
}
}
public void suaCTDDH(int maddh, int manl, int soluong)
{
CT_DDH dh = ql.CT_DDHs.Where(ct => ct.MaNL == manl && ct.MaDDH == maddh).FirstOrDefault();
if (dh != null)
{
dh.SoLuong = soluong;
ql.SubmitChanges();
}
}
//thêm chi tiết đơn hàng
public void luu_chitiet(int manl, int soluong, int thanhtien)
{
CT_DDH ct = new CT_DDH();
ct.MaNL = manl;
ct.SoLuong = soluong;
ct.ThanhTien = thanhtien;
ql.CT_DDHs.InsertOnSubmit(ct);
ql.SubmitChanges();
}
public void themCTDDH(int maNL, int soluong, int thanhtien, int maddh)
{
CT_DDH ctddh = new CT_DDH();
ctddh.MaNL = maNL;
ctddh.SoLuong = soluong;
ctddh.MaDDH = maddh;
ctddh.ThanhTien = thanhtien;
ql.CT_DDHs.InsertOnSubmit(ctddh);
ql.SubmitChanges();
}
public bool khoaNgoai(int ma)
{
CT_DDH ddh = ql.CT_DDHs.Where(t => t.MaNL == ma).FirstOrDefault();
CT_PhieuXuat px = ql.CT_PhieuXuats.Where(t => t.MaNL == ma).FirstOrDefault();
if (ddh == null && px == null)
{
return(true);
}
else
{
return(false);
}
}
