public Task Update(ProductCompositionsModel model)
{
string sql =
@"UPDATE product_compositions SET ProductId=@ProductId, ProductComposition=@ProductComposition WHERE CompositionId=@CompositionId";
return(_db.ExecuteSQLQuery(sql, model));
}
public Task Remove(ProductCompositionsModel model)
{
string sql =
@"DELETE FROM product_compositions WHERE CompositionId=@CompositionId";
return(_db.ExecuteSQLQuery(sql, model));
}
public Task <int> Add(ProductCompositionsModel model)
{
string sql = @"insert into product_compositions (ProductId, ProductComposition)
values (@ProductId, @ProductComposition); select scope_identity()";
return(_db.InsertDataIntoDatabase(sql, model));
}