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