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