public bool Update(ChiTietHoaDonBanLe cthdbl) { try { Tbl_CTHDBanLe update = DB.Tbl_CTHDBanLes.Single(tmp => tmp.soHoaDon == cthdbl.SoHoaDon); update.soHoaDon = cthdbl.SoHoaDon; update.maSP = cthdbl.MaSP; update.ghiChu = cthdbl.GhiChu; update.soLuong = cthdbl.SoLuong; update.donGia = cthdbl.DonGia; DB.SubmitChanges(); return(true); } catch { return(false); } }
public int XoaCTHDBanLe(ChiTietHoaDonBanLe cthdbl) { Tbl_CTHDBanLe tbhdbl = new Tbl_CTHDBanLe(); tbhdbl = DB.Tbl_CTHDBanLes.Where(x => x.soHoaDon == cthdbl.SoHoaDon).FirstOrDefault(); if (tbhdbl != null) { return(0); } tbhdbl.soHoaDon = cthdbl.SoHoaDon; tbhdbl.maSP = cthdbl.MaSP; tbhdbl.ghiChu = cthdbl.GhiChu; tbhdbl.soLuong = cthdbl.SoLuong; tbhdbl.donGia = cthdbl.DonGia; DB.Tbl_CTHDBanLes.DeleteOnSubmit(tbhdbl); DB.SubmitChanges(); return(1); }
public int ThemCTHDBanLe(ChiTietHoaDonBanLe cthdbl) { var cthdbanle = DB.Tbl_CTHDBanLes.Where(x => x.soHoaDon == cthdbl.SoHoaDon).FirstOrDefault(); if (cthdbanle != null) { return(0); } Tbl_CTHDBanLe hd = new Tbl_CTHDBanLe(); hd.soHoaDon = cthdbl.SoHoaDon; hd.maSP = cthdbl.MaSP; hd.ghiChu = cthdbl.GhiChu; hd.soLuong = cthdbl.SoLuong; hd.donGia = cthdbl.DonGia; DB.Tbl_CTHDBanLes.InsertOnSubmit(hd); DB.SubmitChanges(); return(1); }
public static ChiTietHoaDonBanLe CTHDBL(Tbl_CTHDBanLe tmp) { return(new ChiTietHoaDonBanLe(tmp.soHoaDon, tmp.soLuong, tmp.maSP, tmp.ghiChu, tmp.donGia)); }