public async Task <IHttpActionResult> PutCategories(int id, Categories categories)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != categories.CategoryID)
{
return(BadRequest());
}
db.Entry(categories).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CategoriesExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
// PUT api/Product/5
public async Task <IHttpActionResult> PutProduct(int id, Product product)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != product.ProductID)
{
return(BadRequest());
}
db.Entry(product).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ProductExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
/// <summary>
/// Adds a new product
/// </summary>
/// <param name="product">Product to be added</param>
/// <returns>Number of records added</returns>
public async Task <int> AddProduct(Product product)
{
using (var dbContext = new NORTHWNDEntities())
{
dbContext.Products.Add(product);
return(await dbContext.SaveChangesAsync());
}
}
/// <summary>
/// Removes specified product
/// </summary>
/// <param name="product"></param>
/// <returns>Number of affacted rows</returns>
public async Task <int> RemoveProduct(int?productID)
{
using (var dbContext = new NORTHWNDEntities())
{
Product prodToRemove = dbContext.Products.Find(productID);
dbContext.Products.Remove(prodToRemove);
return(await dbContext.SaveChangesAsync());
}
}
/// <summary>
/// Updates existing product (only unit price and product name is modified)
/// </summary>
/// <param name="product">Product to be updated</param>
/// <returns>Number of records updated</returns>
public async Task <int> UpdateProduct(Product product)
{
using (var dbContext = new NORTHWNDEntities())
{
Product productEntity = await dbContext.Products.FindAsync(product.ProductID);
productEntity.UnitPrice = product.UnitPrice;
dbContext.Entry(productEntity).State = EntityState.Modified;
return(await dbContext.SaveChangesAsync());
}
}
public static void CleanTableByTags()
{
var tags = ScenarioContext.Current.ScenarioInfo.Tags
.Where(x => x.StartsWith("Clean"))
.Select(x => x.Replace("Clean", ""));
if (!tags.Any())
{
return;
}
using (var dbcontext = new NORTHWNDEntities())
{
foreach (var tag in tags)
{
dbcontext.Database.ExecuteSqlCommand("TRUNCATE TABLE [" + tag + "]");
}
dbcontext.SaveChangesAsync();
}
}
