public void DeleteProduct(int prod_id, int sup_id) { using (var db = new SupplierProductDAL()) { var entity = db.tblSupplierProducts.Where(p => p.productID == prod_id).FirstOrDefault(p => p.supplierID == sup_id); db.tblSupplierProducts.Remove(entity); db.SaveChanges(); } }
public void AddSupplierProduct(SupplierDTO s, ProductDTO prod) { using (var db = new SupplierProductDAL()) { var x = db.tblSupplierProducts.Where(p => p.supplierID == s.supplierId); var entity = x.FirstOrDefault(p => p.productID == prod.productId); if (entity == null) { AddRelationship(s, prod); } } }
public int AddRelationship(SupplierDTO s, ProductDTO p) { using (var db = new SupplierProductDAL()) { var newRelationship = new tblSupplierProduct() { productID = p.productId, supplierID = s.supplierId }; db.tblSupplierProducts.Add(newRelationship); db.SaveChanges(); return(newRelationship.SupProdId); } }