public ActionResult AjaxAddOrder(int customerId)
{
if (ModelState.IsValid)
{
var context = new SampleEntities();
var customer = context.Customers.Single(c => c.ID == customerId);
var order = new Order();
try
{
UpdateModel(order);
customer.Orders.Add(order);
context.SaveChanges();
}
catch (Exception e)
{
Response.StatusCode = 500;
Response.AppendHeader("message",
"There was an issue adding order to customer \"" + customer.FirstName + " " + customer.LastName +
"\". Please contact tech support with this message: " + Utility.GetInnermostException(e).Message);
}
}
return View(new GridModel(GetOrders(customerId)));
}
public ActionResult AjaxAddCustomer(string lastName, string firstName)
{
if (ModelState.IsValid)
{
try
{
var context = new SampleEntities();
var customer = new Customer();
UpdateModel(customer);
context.Customers.AddObject(customer);
context.SaveChanges();
}
catch (Exception e)
{
Response.StatusCode = 500;
Response.AppendHeader("message",
"There was an issue adding customer \"" + firstName + " " + lastName +
"\". Please contact tech support with this message: " + Utility.GetInnermostException(e).Message);
}
}
return View(new GridModel(GetCustomers()));
}
public ActionResult AjaxDeleteCustomer(int customerId)
{
try
{
var context = new SampleEntities();
var customer = context.Customers.Single(c => c.ID == customerId);
bool orders = customer.Orders.Any();
if (orders)
{
Response.StatusCode = 500;
Response.AppendHeader("message", "This customer has order history, and cannot be deleted until all orders are deleted.");
}
else
{
context.Customers.DeleteObject(customer);
context.SaveChanges();
}
}
catch (System.Exception e)
{
Response.StatusCode = 500;
Response.AppendHeader("message", "There was an issue deleting this customer. Please contact tech support with this message: " + Utility.GetInnermostException(e).Message);
}
return View(new GridModel(GetCustomers()));
}
public ActionResult AjaxSaveOrder(int customerId, int orderId)
{
if (ModelState.IsValid)
{
var context = new SampleEntities();
var order = context.Customers.Single(c => c.ID == customerId).Orders.Single(o => o.ID == orderId);
try
{
UpdateModel(order);
context.SaveChanges();
}
catch (Exception e)
{
Response.StatusCode = 500;
Response.AppendHeader("message",
"There was an issue editing data for this order. Please contact tech support with this message: " + e.Message);
}
}
return View(new GridModel(GetOrders(customerId)));
}
public ActionResult AjaxSaveCustomer(int customerId, string lastName, string firstName)
{
if (ModelState.IsValid)
{
try
{
var context = new SampleEntities();
var customer = context.Customers.Single(c => c.ID == customerId);
UpdateModel(customer);
context.SaveChanges();
}
catch (Exception e)
{
Response.StatusCode = 500;
Response.AppendHeader("message",
"There was an issue editing data for customer \"" + firstName + " " + lastName +
"\". Please contact tech support with this message: " + e.Message);
}
}
return View(new GridModel(GetCustomers()));
}
public ActionResult AjaxDeleteOrder(int customerId, int orderId)
{
try
{
var context = new SampleEntities();
var customer = context.Customers.Single(c => c.ID == customerId);
var order = customer.Orders.Single(o => o.ID == orderId);
context.DeleteObject(order);
context.SaveChanges();
}
catch (System.Exception e)
{
Response.StatusCode = 500;
Response.AppendHeader("message", "There was an issue deleting order " + orderId + ". Please contact tech support with this message: " + Utility.GetInnermostException(e).Message);
}
return View(new GridModel(GetOrders(customerId)));
}