public JsonResult AddCustomerPurchase(CustomerAndPurchaseViewModel customerAndPurchaseViewModel) { bool status = false; var isValidModel = TryUpdateModel(customerAndPurchaseViewModel); if (isValidModel) { using (POS_WebEntities db = new POS_WebEntities()) { Customer customer = new Customer() { CustomerName = customerAndPurchaseViewModel.CustomerName, OrderNumber = customerAndPurchaseViewModel.OrderNumber, Date = customerAndPurchaseViewModel.Date, Description = customerAndPurchaseViewModel.Description }; db.Customers.Add(customer); if (db.SaveChanges() > 0) { int customerID = db.Customers.Max(c => c.ID); foreach (var item in customerAndPurchaseViewModel.Items) { Purchase purchase = new Purchase() { CustomerID = customerID, ProductID = item.ProductID, Price = item.Price, Quantity = item.Quantity, TotalPrice = item.TotalPrice }; db.Purchases.Add(purchase); } if (db.SaveChanges() > 0) { return(new JsonResult { Data = new { status = status, message = "Purchase added successfully" } }); } } } } status = false; return(new JsonResult { Data = new { status = status, message = "Error !!" } }); }