public static PurchasingResult Save(PurchasingOrderHeaderViewModel models) { PurchasingResult result = new PurchasingResult(); try { using (var db = new BuahSayurContext()) { string newRef = GetNewReference(); result.Reference = newRef; PurchasingOrder purchasingOrder = new PurchasingOrder { Id = 1, Supplier_Code = models.Supplier_Code, Reference = newRef, PurchasingDate = models.PurchasingDate }; db.PurchasingOrders.Add(purchasingOrder); foreach (var item in models.PurchasingDetails) { PurchasingOrderDetail purchasingDetail = new PurchasingOrderDetail { PurchasingOrder_Id = purchasingOrder.Id, Item_Code = item.Item_Code, Quantity = item.Quantity, Price = item.Price, Total = item.Quantity * item.Price }; result.Total += (item.Quantity * item.Price); db.PurchasingOrderDetails.Add(purchasingDetail); // Update Stock Item Stock = db.Items.Where(x => x.Code == item.Item_Code).FirstOrDefault(); if (Stock != null) { Stock.Stock = Stock.Stock + item.Quantity; } } db.SaveChanges(); } } catch (Exception ex) { result.Success = false; Message = ex.Message; } return(result); }
public ActionResult SavePurchasing(PurchasingOrderHeaderViewModel models) { if (ModelState.IsValid) { PurchasingResult result = PurchasingDataAccess.Save(models); if (result.Success) { return(Json(new { success = true, message = "Success", data = result }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false, message = PurchasingDataAccess.Message }, JsonRequestBehavior.AllowGet)); } } return(Json(new { success = false, message = "Invalid Model State!" }, JsonRequestBehavior.AllowGet)); }