public bool XoaCTPhieuNHap(string MAPHIEUNHAP, string MATHIETBI) { try { CHITIETNHAPTHIETBI ct = db.CHITIETNHAPTHIETBIs.FirstOrDefault(t => t.MATHIETBI == MATHIETBI && t.MAPHIEUNHAP == MAPHIEUNHAP); db.CHITIETNHAPTHIETBIs.DeleteOnSubmit(ct); db.SubmitChanges(); return(true); } catch { return(false); } }
public bool CapNhatSoLuong(string MAPHIEUNHAP, string MATHIETBI, int SLNHAP, float DGIANHAP) { try { CHITIETNHAPTHIETBI ct = db.CHITIETNHAPTHIETBIs.FirstOrDefault(t => t.MATHIETBI == MATHIETBI && t.MAPHIEUNHAP == MAPHIEUNHAP); ct.SLNHAP += SLNHAP; ct.DGIANHAP = DGIANHAP; ct.THANHTIEN = ct.SLNHAP * DGIANHAP; db.SubmitChanges(); return(true); } catch { return(false); } }
public bool Them(string MAPHIEUNHAP, string MATHIETBI, int SLNHAP, float DGIANHAP) { try { CHITIETNHAPTHIETBI ct = new CHITIETNHAPTHIETBI(); ct.MAPHIEUNHAP = MAPHIEUNHAP; ct.MATHIETBI = MATHIETBI; ct.SLNHAP = SLNHAP; ct.DGIANHAP = DGIANHAP; ct.THANHTIEN = SLNHAP * DGIANHAP; db.CHITIETNHAPTHIETBIs.InsertOnSubmit(ct); try { db.SubmitChanges(); } catch { } return(true); } catch { return(false); } }