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