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