public ActionResult UpdateAdjustmentRequestWithItemValue(InvLeatherStockAdjustModel model) { var msg = objBLLStockAdjust.UpdateAdjustmentRequestWithItemValue(model); var requestDetails = objDalAdjustItem.GetRequestDetails(model.RequestID); return(Json(new { Msg = msg, requestDetails = requestDetails }, JsonRequestBehavior.AllowGet)); }
public ValidationMsg Save(InvLeatherStockAdjustModel model) { using (var tx = new TransactionScope()) { using (_context) { } tx.Complete(); } return(_vmMsg); }
public int SaveAdjustItemRequest(InvLeatherStockAdjustModel model, int userID) { var leatherTypeID = DalCommon.GetLeatherTypeCode("Raw Hide"); var leatherStatusID = DalCommon.GetLeatherStatusCode("Raw Hide"); using (TransactionScope transaction = new TransactionScope()) { #region Insert Inv_LeatherStockAdjustRequest objAdjustmentRequest = new Inv_LeatherStockAdjustRequest(); objAdjustmentRequest.PurchaseYear = model.PurchaseYear; objAdjustmentRequest.RequestDate = DalCommon.SetDate(model.RequestDate); objAdjustmentRequest.LeatherType = model.LeatherType; objAdjustmentRequest.StoreID = model.StoreID; objAdjustmentRequest.RecordStatus = "NCF"; objAdjustmentRequest.SetBy = userID; objAdjustmentRequest.SetOn = DateTime.Now; _context.Inv_LeatherStockAdjustRequest.Add(objAdjustmentRequest); _context.SaveChanges(); var currentRequestID = objAdjustmentRequest.RequestID; foreach (var item in model.StockAdjustItemList) { Inv_LeatherStockAdjustItem objAdjustmentItems = new Inv_LeatherStockAdjustItem(); objAdjustmentItems.RequestID = currentRequestID; objAdjustmentItems.SupplierID = item.SupplierID; objAdjustmentItems.PurchaseID = item.ChallanID; objAdjustmentItems.ItemTypeID = item.ItemTypeID; objAdjustmentItems.LeatherType = model.LeatherType; objAdjustmentItems.LeatherStatus = leatherStatusID; objAdjustmentItems.ItemQty = item.ItemQty; objAdjustmentItems.Unit = item.Unit; objAdjustmentItems.Remarks = item.Remarks; objAdjustmentItems.AdjustmentCause = item.AdjustmentCause; _context.Inv_LeatherStockAdjustItem.Add(objAdjustmentItems); _context.SaveChanges(); } transaction.Complete(); return(currentRequestID); #endregion } }
public ActionResult StockAdjust(InvLeatherStockAdjustModel model) { if (model.RequestID == null) { var msg = objBLLStockAdjust.SaveAdjustItemRequest(model, Convert.ToInt32(Session["UserID"])); var requestID = objBLLStockAdjust.GetRequestID(); var requestDetails = objDalAdjustItem.GetRequestDetails((requestID).ToString()); return(Json(new { Msg = msg, requestID = requestID, requestDetails = requestDetails }, JsonRequestBehavior.AllowGet)); } else { var msg = objBLLStockAdjust.UpdateAdjustItemRequest(model, Convert.ToInt32(Session["UserID"])); var requestDetails = objDalAdjustItem.GetRequestDetails(model.RequestID); return(Json(new { Msg = msg, requestDetails = requestDetails }, JsonRequestBehavior.AllowGet)); } }
public int UpdateAdjustmentRequestWithItemValue(InvLeatherStockAdjustModel model) { using (TransactionScope transaction = new TransactionScope()) { foreach (var item in model.StockAdjustItemList) { var CurrentItem = (from i in _context.Inv_LeatherStockAdjustItem.AsEnumerable() where i.AdjustID == item.AdjustID select i).FirstOrDefault(); CurrentItem.ItemValue = item.ItemValue; _context.SaveChanges(); } transaction.Complete(); } return(1); }
public ValidationMsg UpdateAdjustItemRequest(InvLeatherStockAdjustModel model, int userID) { var transactionOption = new TransactionOptions { Timeout = new TimeSpan(0, 0, 9999) }; var vMsg = new ValidationMsg(); using (var transactionScope = new TransactionScope(TransactionScopeOption.RequiresNew, transactionOption)) { try { var _dalStockAdjustItem = new DalInvLeatherStockAdjustItem(); currentRequestID = _dalStockAdjustItem.UpdateAdjustItemRequest(model, userID); if (currentRequestID > 0) { transactionScope.Complete(); vMsg.Type = Enums.MessageType.Update; vMsg.Msg = "Updated successfully."; } else { vMsg.Type = Enums.MessageType.Error; vMsg.Msg = "Failed to Update."; } } catch (Exception e) { vMsg.Type = Enums.MessageType.Error; vMsg.Msg = "Failed to Update."; } } return(vMsg); }
public int UpdateAdjustItemRequest(InvLeatherStockAdjustModel model, int userID) { var leatherTypeID = DalCommon.GetLeatherTypeCode("Raw Hide"); var leatherStatusID = DalCommon.GetLeatherStatusCode("Raw Hide"); //var requestdate = (model.RequestDate).ToString("dd'/'MM'/'yyyy"); using (TransactionScope transaction = new TransactionScope()) { var currentRequestID = Convert.ToInt32(model.RequestID); var currentRequest = (from r in _context.Inv_LeatherStockAdjustRequest.AsEnumerable() where r.RequestID == Convert.ToInt32(model.RequestID) select r).FirstOrDefault(); currentRequest.RequestDate = DalCommon.SetDate(model.RequestDate); currentRequest.PurchaseYear = model.PurchaseYear; currentRequest.LeatherType = model.LeatherType; currentRequest.StoreID = model.StoreID; currentRequest.SetBy = userID; currentRequest.SetOn = DateTime.Now; _context.SaveChanges(); if (model.StockAdjustItemList != null) { foreach (var item in model.StockAdjustItemList) { if (item.AdjustID == 0) { Inv_LeatherStockAdjustItem objAdjustmentItems = new Inv_LeatherStockAdjustItem(); objAdjustmentItems.RequestID = Convert.ToInt32(model.RequestID); objAdjustmentItems.SupplierID = item.SupplierID; objAdjustmentItems.PurchaseID = item.ChallanID; objAdjustmentItems.ItemTypeID = item.ItemTypeID; objAdjustmentItems.LeatherType = model.LeatherType; objAdjustmentItems.LeatherStatus = leatherStatusID; objAdjustmentItems.ItemQty = item.ItemQty; objAdjustmentItems.Unit = item.Unit; objAdjustmentItems.Remarks = item.Remarks; objAdjustmentItems.AdjustmentCause = item.AdjustmentCause; _context.Inv_LeatherStockAdjustItem.Add(objAdjustmentItems); _context.SaveChanges(); } else { var CurrentItem = (from i in _context.Inv_LeatherStockAdjustItem.AsEnumerable() where i.AdjustID == item.AdjustID select i).FirstOrDefault(); CurrentItem.SupplierID = item.SupplierID; CurrentItem.PurchaseID = item.ChallanID; CurrentItem.ItemTypeID = item.ItemTypeID; CurrentItem.LeatherType = model.LeatherType; CurrentItem.LeatherStatus = leatherStatusID; CurrentItem.ItemQty = item.ItemQty; CurrentItem.Unit = item.Unit; CurrentItem.Remarks = item.Remarks; CurrentItem.AdjustmentCause = item.AdjustmentCause; _context.SaveChanges(); } } } transaction.Complete(); return(currentRequestID); } }