public int InsertChiTietHoaDonBanSi(eChiTietHoaDonBanSi Ct) { var SanPham = from i in db.SanPhams where i.MaSP == Ct.MaSP select i; if (SanPham.Any()) { var ChiTiet = from i in db.ChiTietHoaDonBanSis where i.MaHoaDonBanSi == Ct.MaHoaDonoBanSi && i.MaSP == Ct.MaSP select i; if (ChiTiet.Any()) { return(0); } else { ChiTietHoaDonBanSi ChitietHDBS = new ChiTietHoaDonBanSi(); ChitietHDBS.MaHoaDonBanSi = Ct.MaHoaDonoBanSi; ChitietHDBS.MaSP = Ct.MaSP; ChitietHDBS.SoLuong = Ct.soluong; ChitietHDBS.GhiChu = Ct.GhiChu; ChitietHDBS.GiaBanSi = Ct.GiaBanSi; decimal Money = Ct.soluong * Ct.GiaBanSi; UpdateTongTienHoaDonBanSiI(Ct.MaHoaDonoBanSi, Money); db.ChiTietHoaDonBanSis.InsertOnSubmit(ChitietHDBS); db.SubmitChanges(); return(1); } } else { return(2); } }
public void DeleteChiTietHoaDonBanSi(string MaHoaDonBanSi, string MaSp, string MaChiTietHoaDonBanSi) { ChiTietHoaDonBanSi Chitiet = db.ChiTietHoaDonBanSis.Where(x => x.MaHoaDonBanSi == MaHoaDonBanSi && x.MaSP == MaSp).FirstOrDefault(); decimal Money = Convert.ToDecimal(Chitiet.GiaBanSi * Chitiet.SoLuong); db.ChiTietHoaDonBanSis.DeleteOnSubmit(Chitiet); db.SubmitChanges(); UpdateTongTienHoaDonBanSiD(MaHoaDonBanSi, Money); }