public OperationStatus InsertCustomer(Customer customer) { var opStatus = new OperationStatus { Status = true }; try { _Context.Customers.Add(customer); _Context.SaveChanges(); } catch (Exception exp) { opStatus.Status = false; opStatus.ExceptionMessage = exp.Message; } return opStatus; }
public static OperationStatus CreateFromException(string message, Exception ex) { OperationStatus opStatus = new OperationStatus { Status = false, Message = message, OperationId = null }; if (ex != null) { opStatus.ExceptionMessage = ex.Message; opStatus.ExceptionStackTrace = ex.StackTrace; opStatus.ExceptionInnerMessage = (ex.InnerException == null) ? null : ex.InnerException.Message; opStatus.ExceptionInnerStackTrace = (ex.InnerException == null) ? null : ex.InnerException.StackTrace; } return opStatus; }
public OperationStatus DeleteCustomer(int id) { var opStatus = new OperationStatus(); try { var cust = _Context.Customers.SingleOrDefault(c => c.Id == id); if (cust != null) { _Context.Customers.Remove(cust); _Context.SaveChanges(); opStatus.Status = true; } else { opStatus.Message = "Customer not found!"; } } catch (Exception exp) { return OperationStatus.CreateFromException("Error deleting customer", exp); } return opStatus; }
public OperationStatus DeleteCustomer(int id) { var opStatus = new OperationStatus { Status = true }; try { var cust = _Context.Customers.SingleOrDefault(c => c.Id == id); if (cust != null) { _Context.Customers.Remove(cust); _Context.SaveChanges(); } else { opStatus.Status = false; opStatus.ExceptionMessage = "Customer not found"; } } catch (Exception exp) { opStatus.Status = false; opStatus.ExceptionMessage = exp.Message; } return opStatus; }
public OperationStatus UpdateCustomer(Customer customer) { var opStatus = new OperationStatus { Status = true }; try { customer.State.Id = customer.StateId; _Context.Customers.Attach(customer); _Context.Entry<Customer>(customer).State = System.Data.Entity.EntityState.Modified; _Context.SaveChanges(); } catch (Exception exp) { opStatus.Status = false; opStatus.ExceptionMessage = exp.Message; } return opStatus; }
public OperationStatus UpdateCustomer(int id, [FromBody]Customer customer) { var opStatus = new OperationStatus(); try { customer.State.ID = customer.StateID; _Context.Customers.Attach(customer); _Context.Entry<Customer>(customer).State = System.Data.EntityState.Modified; _Context.SaveChanges(); opStatus.Status = true; } catch (Exception exp) { return OperationStatus.CreateFromException("Error updating customer", exp); } return opStatus; }
public OperationStatus InsertCustomer([FromBody]Customer customer) { var opStatus = new OperationStatus(); try { _Context.Customers.Add(customer); _Context.SaveChanges(); opStatus.Status = true; opStatus.OperationID = customer.Id; } catch (Exception exp) { return OperationStatus.CreateFromException("Error updating customer", exp); } return opStatus; }
// DELETE api/<controller>/5 public HttpResponseMessage DeleteCustomer(int id) { var opStatus = new OperationStatus(); try { var cust = _Context.Customers.SingleOrDefault(c => c.Id == id); if (cust != null) { _Context.Customers.Remove(cust); _Context.SaveChanges(); return Request.CreateResponse(HttpStatusCode.OK); } else { return Request.CreateResponse(HttpStatusCode.NotFound); } } catch (Exception exp) { return Request.CreateErrorResponse(HttpStatusCode.NotFound, exp.Message); } }
// PUT api/<controller>/5 public HttpResponseMessage PutCustomer(int id, [FromBody]Customer customer) { var opStatus = new OperationStatus(); try { //customer.State.Id = customer.StateId; _Context.Customers.Attach(customer); _Context.Entry<Customer>(customer).State = System.Data.EntityState.Modified; _Context.SaveChanges(); return Request.CreateResponse<Customer>(HttpStatusCode.Accepted, customer); } catch (Exception exp) { return Request.CreateResponse(HttpStatusCode.NotModified, exp.Message); } }
// POST api/<controller> public HttpResponseMessage PostCustomer([FromBody]Customer customer) { var opStatus = new OperationStatus(); try { _Context.Customers.Add(customer); _Context.SaveChanges(); var response = Request.CreateResponse<Customer>(HttpStatusCode.Created, customer); string uri = Url.Link("DefaultApi", new { id = customer.Id }); response.Headers.Location = new Uri(uri); return response; } catch (Exception exp) { return Request.CreateErrorResponse(HttpStatusCode.NotFound, exp.Message); } }