public JsonResult AddCustomer(PersonViewModel stu)
{
try
{
using (CobraOnboardEntities dbContext = new CobraOnboardEntities())
{
var newPerson = new Person
{
Name = stu.Name,
Address1 = stu.Address1,
Address2 = stu.Address2,
City = stu.City,
};
dbContext.People.Add(newPerson);
dbContext.SaveChanges();
dbContext.Entry(newPerson).GetDatabaseValues();
var newPersonId = newPerson.Id;
return(Json(newPersonId, JsonRequestBehavior.AllowGet));
//return Json(e.Message, JsonRequestBehavior.AllowGet);
}
}
catch (Exception)
{
return(Json(-1));
}
}
public JsonResult UpdateCustomer(PersonViewModel person)
{
try
{
using (CobraOnboardEntities dbContext = new CobraOnboardEntities())
{
var lstPerson = dbContext.People.Find(person.Id);
if (lstPerson != null)
{
//lstPerson.Name = person.Name;
//lstPerson.Address1 = person.Address1;
//lstPerson.Address2 = person.Address2;
//lstPerson.City = person.City;
dbContext.Entry(lstPerson).CurrentValues.SetValues(person);
dbContext.SaveChanges();
return(Json(person.Id, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(-1));
}
}
}
catch (Exception)
{
return(Json(-1));
}
}
public JsonResult AddOrder(OrderViewModel order)
{
try
{
using (CobraOnboardEntities dbContext = new CobraOnboardEntities())
{
var orderheader = new OrderHeader
{
OrderDate = order.OrderDate, //DateTime.Now,
PersonId = order.CustomerId,
};
dbContext.OrderHeaders.Add(orderheader);
dbContext.SaveChanges();
dbContext.Entry(orderheader).GetDatabaseValues();
// var lastRecord = dbContext.OrderHeaders.Where(x => x.PersonId == order.CustomerId).LastOrDefault();
var lastRecordOrderId = orderheader.OrderId;
var orderdetail = new OrderDetail
{
OrderId = lastRecordOrderId,
ProductId = order.ProductId,
};
//orderdetail.OrderId = lastRecordId;
dbContext.OrderDetails.Add(orderdetail);
dbContext.SaveChanges();
return(Json(lastRecordOrderId, JsonRequestBehavior.AllowGet));
}
}
catch (Exception)
{
return(Json(-1));
}
}
