public JsonResult DeleteCustomer(int Id)
{
try
{
using (CobraOnboardEntities dataContext = new CobraOnboardEntities())
{
var orderRcord = dataContext.OrderHeaders.Where(x => x.PersonId == Id).FirstOrDefault();
if (orderRcord == null)
{
var lstStud = dataContext.People.Where(x => x.Id == Id).FirstOrDefault();
dataContext.People.Remove(lstStud);
dataContext.SaveChanges();
return(Json(Id, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { orderFound = true }));
}
}
}
catch (Exception)
{
return(Json(-1));
}
}
public JsonResult DeleteOrder(int Id)
{
try
{
using (CobraOnboardEntities dbContext = new CobraOnboardEntities())
{
var orderDet = dbContext.OrderDetails.Where(x => x.OrderId == Id).FirstOrDefault();
dbContext.OrderDetails.Remove(orderDet);
var orderHead = dbContext.OrderHeaders.Where(x => x.OrderId == Id).FirstOrDefault();
dbContext.OrderHeaders.Remove(orderHead);
dbContext.SaveChanges();
return(Json(Id, JsonRequestBehavior.AllowGet));
}
}
catch (Exception)
{
return(Json(-1));
}
}
public JsonResult EditOrder(OrderViewModel editOrder)
{
try
{
using (CobraOnboardEntities dbContext = new CobraOnboardEntities())
{
var recordHeader = dbContext.OrderHeaders.Find(editOrder.OrderId);
recordHeader.OrderDate = editOrder.OrderDate;
recordHeader.PersonId = editOrder.CustomerId;
var recordDetails = dbContext.OrderDetails.Where(x => x.OrderId == editOrder.OrderId).FirstOrDefault();
recordDetails.ProductId = editOrder.ProductId;
dbContext.SaveChanges();
return(Json(editOrder.OrderId, JsonRequestBehavior.AllowGet));
}
}
catch (Exception)
{
return(Json(-1));
}
}