/// <summary> /// Update row of grid. /// </summary> public ActionResult UpdateGridForItemsLog([ModelBinder(typeof(DevExpressEditorsBinder))] ItemsLogModel model) { try { if (ModelState.IsValid) { ItemsLogRepository.UpdateItemLog(model); } else { TempData["ErrorMessage"] = Common.ErrorMsgForGrid; } } catch (Exception exc) { TempData["ErrorMessage"] = exc.Message; Logger.LogError(exc, "Error while updating items log from Supervisor zone"); } return(PartialView("Grid/_GridForItemsLog", ItemsLogRepository.ItemsLog)); }
/// <summary> /// Update Item log. /// </summary> public static void UpdateItemLog(ItemsLogModel itemLog) { var editItemLog = GetEditableItemLog(itemLog.Id); if (editItemLog == null) { return; } var oldItemQtyFromLog = editItemLog.ItemQuantity; editItemLog.ItemId = itemLog.ItemId; editItemLog.ItemQuantity = itemLog.ItemQuantity; editItemLog.VendorName = itemLog.VendorName; editItemLog.EntryDate = itemLog.EntryDate; OimsDataContext.SaveChanges(); #region Update item's stock var itemsModel = GetItemsModel(itemLog.ItemId); if (itemsModel == null) { return; } // Calculate item quantity to set var itemCurrentStock = itemsModel.ItemQuantity; var newItemQtyFromLog = itemLog.ItemQuantity; var itemQtyToSet = (itemCurrentStock - oldItemQtyFromLog) + newItemQtyFromLog; itemsModel.ItemQuantity = itemQtyToSet; itemsModel.Vendor = editItemLog.VendorName; itemsModel.UpdatedOn = DateTime.Now; ItemRepository.UpdateItem(itemsModel); #endregion }