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);
}
}
