public ActionResult InsertOneOrder(OrderViewModel order)
{
using (var context = new CobraOnboardingDbEntities())
{
context.Configuration.LazyLoadingEnabled = false;
var personId = context.People.SingleOrDefault(x => x.CustomerName.Equals(order.CustomerName)).Id;
var orderHeader = new OrderHeader()
{
OrderDate = order.OrderDate,
PersonId = personId
};
context.OrderHeaders.Add(orderHeader);
context.SaveChanges();
var orderId = context.OrderHeaders.OrderByDescending(x => x.OrderId).FirstOrDefault().OrderId;
var productId = context.Products.SingleOrDefault(x => x.ProductName.Equals(order.ProductName)).Id;
var orderDetail = new OrderDetail()
{
ProductId = productId, OrderId = orderId
};
context.OrderDetails.Add(orderDetail);
context.SaveChanges();
return(Json(null));
}
}
public ActionResult UpdateOneOrder(OrderViewModel order)
{
using (var context = new CobraOnboardingDbEntities())
{
context.Configuration.LazyLoadingEnabled = false;
var orderHeader = context.OrderHeaders.SingleOrDefault(x => x.OrderId == order.OrderId);
var personId = context.People.SingleOrDefault(x => x.CustomerName.Equals(order.CustomerName)).Id;
if (orderHeader != null)
{
orderHeader.OrderId = order.OrderId;
orderHeader.OrderDate = order.OrderDate;
orderHeader.PersonId = personId;
}
var orderDetail = context.OrderDetails.SingleOrDefault(x => x.OrderId == order.OrderId);
var productId = context.Products.SingleOrDefault(x => x.ProductName.Equals(order.ProductName)).Id;
if (orderDetail != null)
{
orderDetail.ProductId = productId;
}
context.SaveChanges();
return(Json(null));
}
}
public ActionResult InsertCustomers(Person person)
{
using (var context = new CobraOnboardingDbEntities())
{
context.Configuration.LazyLoadingEnabled = false;
context.People.Add(person);
context.SaveChanges();
var customers = context.People.ToList();
return(Json(customers, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteOneCustomer(Person person)
{
using (var context = new CobraOnboardingDbEntities())
{
context.Configuration.LazyLoadingEnabled = false;
var personInDb = context.People.SingleOrDefault(x => x.Id == person.Id);
if (personInDb != null)
{
context.People.Remove(personInDb);
}
context.SaveChanges();
var customers = context.People.ToList();
return(Json(customers, JsonRequestBehavior.AllowGet));
}
}
public ActionResult UpdateOneCustomer(Person person)
{
using (var context = new CobraOnboardingDbEntities())
{
context.Configuration.LazyLoadingEnabled = false;
var personInDb = context.People.SingleOrDefault(x => x.Id == person.Id);
if (personInDb != null)
{
personInDb.CustomerName = person.CustomerName;
personInDb.Address1 = person.Address1;
personInDb.Address2 = person.Address2;
personInDb.Town_City = person.Town_City;
}
context.SaveChanges();
var customers = context.People.ToList();
return(Json(customers, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteOneOrder(OrderViewModel order)
{
using (var context = new CobraOnboardingDbEntities())
{
context.Configuration.LazyLoadingEnabled = false;
var orderDetail = context.OrderDetails.SingleOrDefault(x => x.OrderId == order.OrderId);
if (orderDetail != null)
{
context.OrderDetails.Remove(orderDetail);
}
var orderHeader = context.OrderHeaders.SingleOrDefault(x => x.OrderId == order.OrderId);
if (orderHeader != null)
{
context.OrderHeaders.Remove(orderHeader);
}
context.SaveChanges();
return(Json(null));
}
}
