// implementing delete method /* * public void Delete(int suppId) * { * using ( OrdersDBEntities entities = new OrdersDBEntities()){ * entities.Suppliers.Remove(entities.Suppliers.FirstOrDefault((supp)=> supp.SupplierID==suppId)); * entities.SaveChanges(); * } * } */ //put method public HttpResponseMessage Put(int id, [FromBody] Supplier supp) { try { //get the supplier using (OrdersDBEntities entities = new OrdersDBEntities()) { var supplier = entities.Suppliers.FirstOrDefault((sup) => sup.SupplierID == id); //check if provided supplier is not null if (supplier == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "no supplier ith this id is found")); } else { supplier.CompanyName = supp.CompanyName; supplier.PhoneNumber = supp.PhoneNumber; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
/* without any response * public void Post([FromBody] Supplier supp) * { * using (OrdersDBEntities entity = new OrdersDBEntities()) * { * entity.Suppliers.Add(supp); * entity.SaveChanges(); * } * } * */ //[HttpDelete] public HttpResponseMessage Delete(int suppId) { try { using (OrdersDBEntities entities = new OrdersDBEntities()) { var entity = entities.Suppliers.FirstOrDefault((supp) => supp.SupplierID == suppId); if (entity == null) { //the error message return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "the id is not present")); } else { entities.Suppliers.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public ActionResult UpdateOrder(OrderViewModel updated) { var order = dbContext.Orders.FirstOrDefault(o => o.OrderID == updated.OrderID); order.DateOfOrder = updated.DateOfOrder; order.OrderID = updated.OrderID; dbContext.SaveChanges(); var orders = dbContext.Orders.Select( o => new OrderViewModel { OrderID = o.OrderID, DateOfOrder = o.DateOfOrder }); return(View(new GridModel(orders))); }
public HttpResponseMessage Post([FromBody] Supplier supp) { try { using (OrdersDBEntities entity = new OrdersDBEntities()) { entity.Suppliers.Add(supp); entity.SaveChanges(); //create the message var message = Request.CreateResponse(HttpStatusCode.Created, supp); message.Headers.Location = new Uri(Request.RequestUri + supp.SupplierID.ToString()); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }