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