public void DeletePDNXKChiTiet(string SoPhieu, string MaSP) { ChiTietPhieuDNXK chitiet = db.ChiTietPhieuDNXKs.Where(x => x.MaPhieuDNXK == SoPhieu && x.MaSP == MaSP).FirstOrDefault(); if (chitiet != null) { db.ChiTietPhieuDNXKs.DeleteOnSubmit(chitiet); db.SubmitChanges(); } else { throw new Exception("Invald Details"); } }
public int InsertPDNXKChiTiet(eChiTietPhieuDeNghiXuatKho Chitiet) { var sp = from i in db.SanPhams where i.MaSP == Chitiet.MaSP select i; if (sp.Any()) { var c = from i in db.ChiTietPhieuDNXKs where i.MaSP == Chitiet.MaSP && i.MaPhieuDNXK == Chitiet.SoPhieu select i; if (c.Any()) { return(0); throw new Exception("There have already"); } else { ChiTietPhieuDNXK newct = new ChiTietPhieuDNXK(); newct.MaPhieuDNXK = Chitiet.SoPhieu; newct.MaSP = Chitiet.MaSP; newct.GhiChu = Chitiet.GhiChu; newct.SoLuong = Chitiet.SoLuong; db.ChiTietPhieuDNXKs.InsertOnSubmit(newct); db.SubmitChanges(); return(1); } } else { return(2); throw new Exception("Invaild SanPham"); } }