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 long Save(PRDYearMonthCrustReqItem model, int userId) { long CurrentRequisitionItemID = 0; try { using (TransactionScope transaction = new TransactionScope()) { using (_context) { var RequisitionDateInfo = (from r in _context.PRD_YearMonthFinishReqDate.AsEnumerable() where r.RequisitionDateID == model.RequisitionDateID select r).FirstOrDefault(); RequisitionDateInfo.Remark = model.ConfirmNote; _context.SaveChanges(); #region Update_Item_Information if (model.ItemList != null) { foreach (var Item in model.ItemList) { #region New_Item_Insertion if (Item.RequisitionItemID == 0) { PRD_YearMonthFinishReqItem objItem = new PRD_YearMonthFinishReqItem(); objItem.RequisitionDateID = Item.RequisitionDateID; objItem.ScheduleItemID = Item.ScheduleItemID; objItem.ScheduleProductionNo = Item.ScheduleProductionNo; //objItem.RequisitionNo = Convert.ToInt32(model.PurchaseID); objItem.BuyerID = Item.BuyerID; objItem.BuyerOrderID = Item.BuyerOrderID; objItem.ArticleID = Item.ArticleID; objItem.ArticleNo = Item.ArticleNo; if (Item.ArticleChallanID != 0) { objItem.ArticleChallanID = Item.ArticleChallanID; objItem.ArticleChallanNo = Item.ArticleChallanNo; } objItem.AvgSize = Item.AvgSize; objItem.AvgSizeUnit = DalCommon.GetUnitCode(Item.AvgSizeUnitName); objItem.SelectionRange = Item.SelectionRange; objItem.SideDescription = Item.SideDescription; objItem.Thickness = Item.Thickness; objItem.ThicknessUnit = DalCommon.GetUnitCode(Item.ThicknessUnitName); objItem.ThicknessAt = (Item.ThicknessAt == "After Shaving" ? "AFSV" : "AFFN"); objItem.ItemTypeID = DalCommon.GetItemTypeCode(Item.ItemTypeName); objItem.LeatherStatusID = DalCommon.GetLeatherStatusCode(Item.LeatherStatusName); objItem.LeatherTypeID = DalCommon.GetLeatherTypeCode("Crust"); objItem.Remark = Item.Remarks; objItem.SetOn = DateTime.Now; objItem.SetBy = 1;; _context.PRD_YearMonthFinishReqItem.Add(objItem); _context.SaveChanges(); CurrentRequisitionItemID = objItem.RequisitionItemID; } #endregion #region Existing_Challan_Update else if (Item.RequisitionItemID != 0) { var CurrentItem = (from c in _context.PRD_YearMonthFinishReqItem.AsEnumerable() where c.RequisitionItemID == Item.RequisitionItemID select c).FirstOrDefault(); CurrentItem.RequisitionDateID = Item.RequisitionDateID; CurrentItem.ScheduleProductionNo = Item.ScheduleProductionNo; //CurrentItem.RequisitionNo = Convert.ToInt32(model.PurchaseID); CurrentItem.BuyerID = Item.BuyerID; CurrentItem.BuyerOrderID = Item.BuyerOrderID; CurrentItem.ArticleID = Item.ArticleID; CurrentItem.ArticleNo = Item.ArticleNo; if (Item.ArticleChallanID != 0) { CurrentItem.ArticleChallanID = Item.ArticleChallanID; CurrentItem.ArticleChallanNo = Item.ArticleChallanNo; } CurrentItem.AvgSize = Item.AvgSize; CurrentItem.AvgSizeUnit = DalCommon.GetUnitCode(Item.AvgSizeUnitName); CurrentItem.SelectionRange = Item.SelectionRange; CurrentItem.SideDescription = Item.SideDescription; CurrentItem.Thickness = Item.Thickness.ToString(); CurrentItem.ThicknessUnit = DalCommon.GetUnitCode(Item.ThicknessUnitName); CurrentItem.ThicknessAt = Item.ThicknessAt; CurrentItem.ItemTypeID = DalCommon.GetItemTypeCode(Item.ItemTypeName); CurrentItem.LeatherStatusID = DalCommon.GetLeatherStatusCode(Item.LeatherStatusName); CurrentItem.LeatherTypeID = DalCommon.GetLeatherTypeCode("Crust"); CurrentItem.Remark = Item.Remarks; _context.SaveChanges(); } #endregion } } #endregion #region To_Find_ColorItemID_For_Items_If_Any if (model.ColorList != null) { foreach (var Color in model.ColorList) { if (Color.RequisitionItemID != null && Color.RequisitionItemID != 0) { CurrentRequisitionItemID = Convert.ToInt64(Color.RequisitionItemID); break; } else { if (model.SelectedRequisitionItemID != 0) { CurrentRequisitionItemID = model.SelectedRequisitionItemID; } break; } } } #endregion #region Update_Color_Item_Information if (model.ColorList != null) { foreach (var Color in model.ColorList) { #region New_Color_Item_Insertion if (Color.ReqItemColorID == 0) { PRD_YearMonthFinishReqItemColor objColor = new PRD_YearMonthFinishReqItemColor(); objColor.RequisitionItemID = CurrentRequisitionItemID; objColor.ColorID = Color.ColorID; objColor.ArticleColorNo = Color.ArticleColorNo; objColor.ColorPcs = (Color.ColorPCS); objColor.ColorSide = (Color.ColorSide); objColor.ColorArea = Color.ColorArea; objColor.AreaUnit = DalCommon.GetUnitCode(Color.AreaUnitName); objColor.Remarks = Color.Remarks; objColor.SetBy = 1;; objColor.SetOn = DateTime.Now; _context.PRD_YearMonthFinishReqItemColor.Add(objColor); _context.SaveChanges(); } #endregion #region Update_Existing_Color_Item else if (Color.ReqItemColorID != 0) { var currentColorItem = (from c in _context.PRD_YearMonthFinishReqItemColor.AsEnumerable() where c.ReqItemColorID == Color.ReqItemColorID select c).FirstOrDefault(); currentColorItem.RequisitionItemID = CurrentRequisitionItemID; currentColorItem.ColorID = Color.ColorID; currentColorItem.ArticleColorNo = Color.ArticleColorNo; currentColorItem.ColorPcs = (Color.ColorPCS); currentColorItem.ColorSide = (Color.ColorSide); currentColorItem.ColorArea = Color.ColorArea; currentColorItem.AreaUnit = DalCommon.GetUnitCode(Color.AreaUnitName); currentColorItem.Remarks = Color.Remarks; currentColorItem.SetBy = 1;; currentColorItem.SetOn = DateTime.Now; _context.SaveChanges(); } #endregion } } #endregion } transaction.Complete(); } return(CurrentRequisitionItemID); } catch (Exception e) { return(0); } }
public bool ConfirmPurchase(string purchaseNumber, string confirmComment) { try { using (TransactionScope Transaction = new TransactionScope()) { using (_context) { var purchaseInfo = (from p in _context.Prq_Purchase.AsEnumerable() where (p.PurchaseID).ToString() == purchaseNumber select p).FirstOrDefault(); var challanList = (from c in _context.Prq_PurchaseChallan.AsEnumerable() where (c.PurchaseID).ToString() == purchaseNumber select c).ToList(); foreach (var item in challanList) { var challanItem = (from i in _context.Prq_PurchaseChallanItem.AsEnumerable() where i.ChallanID == item.ChallanID select i).ToList(); foreach (var leatherItem in challanItem) { var leatherTypeID = DalCommon.GetLeatherTypeCode("Raw Hide"); leatherTypeID = leatherTypeID == 0 ? Convert.ToByte(1) : leatherTypeID; var leatherStatusID = DalCommon.GetLeatherStatusCode("Raw Hide"); leatherStatusID = leatherStatusID == 0 ? Convert.ToByte(1) : leatherStatusID; var currentDate = DateTime.Now.Date; if (leatherItem.RecordStatus != "CNF" && leatherItem.RecordStatus != "Confirmed") { #region Daily_Stock_Update var CheckDate = (from ds in _context.Inv_StockDaily.AsEnumerable() where ds.ItemTypeID == leatherItem.ItemTypeID && ds.StoreID == item.ReceiveStore && ds.LeatherStatus == leatherStatusID && ds.LeatherType == leatherTypeID && ds.StockDate == currentDate select ds).Any(); if (CheckDate) { var CurrentItem = (from ds in _context.Inv_StockDaily.AsEnumerable() where ds.ItemTypeID == leatherItem.ItemTypeID && ds.StoreID == item.ReceiveStore && ds.LeatherStatus == leatherStatusID && ds.LeatherType == leatherTypeID && ds.StockDate == currentDate select ds).FirstOrDefault(); CurrentItem.DailyReceiveQty = CurrentItem.DailyReceiveQty + leatherItem.ReceiveQty; CurrentItem.ClosingQty = CurrentItem.ClosingQty + leatherItem.ReceiveQty; _context.SaveChanges(); } else { var PreviousRecord = (from ds in _context.Inv_StockDaily.AsEnumerable() where ds.ItemTypeID == leatherItem.ItemTypeID && ds.StoreID == item.ReceiveStore && ds.LeatherStatus == leatherStatusID && ds.LeatherType == leatherTypeID orderby ds.TransectionID descending select ds).FirstOrDefault(); Inv_StockDaily objStockDaily = new Inv_StockDaily(); objStockDaily.ItemTypeID = leatherItem.ItemTypeID; objStockDaily.StoreID = item.ReceiveStore; objStockDaily.UnitID = leatherItem.UnitID; objStockDaily.LeatherStatus = leatherStatusID; objStockDaily.LeatherType = leatherTypeID; objStockDaily.OpeningQty = (PreviousRecord == null ? 0 : PreviousRecord.ClosingQty); objStockDaily.DailyReceiveQty = leatherItem.ReceiveQty; objStockDaily.DailyIssueQty = 0; objStockDaily.ClosingQty = objStockDaily.OpeningQty + leatherItem.ReceiveQty; objStockDaily.StockDate = currentDate; _context.Inv_StockDaily.Add(objStockDaily); _context.SaveChanges(); } #endregion #region Supplier_Stock_Update var CheckSupplierStock = (from i in _context.Inv_StockSupplier.AsEnumerable() where i.SupplierID == purchaseInfo.SupplierID && i.ItemTypeID == leatherItem.ItemTypeID && i.LeatherType == leatherTypeID && i.LeatherStatusID == leatherStatusID && i.StoreID == item.ReceiveStore && i.PurchaseID.ToString() == purchaseInfo.PurchaseID.ToString() select i).Any(); if (!CheckSupplierStock) { Inv_StockSupplier objStockSupplier = new Inv_StockSupplier(); objStockSupplier.SupplierID = purchaseInfo.SupplierID; objStockSupplier.StoreID = item.ReceiveStore; objStockSupplier.PurchaseID = purchaseInfo.PurchaseID; objStockSupplier.RefChallanID = item.ChallanID; objStockSupplier.ItemTypeID = leatherItem.ItemTypeID; objStockSupplier.LeatherType = leatherTypeID; objStockSupplier.LeatherStatusID = leatherStatusID; objStockSupplier.UnitID = leatherItem.UnitID; objStockSupplier.OpeningQty = 0; objStockSupplier.ReceiveQty = leatherItem.ReceiveQty; objStockSupplier.IssueQty = 0; objStockSupplier.ClosingQty = leatherItem.ReceiveQty; objStockSupplier.UpdateReason = "Receive"; _context.Inv_StockSupplier.Add(objStockSupplier); _context.SaveChanges(); } else { var LastSupplierStock = (from i in _context.Inv_StockSupplier.AsEnumerable() where i.SupplierID == purchaseInfo.SupplierID && i.ItemTypeID == leatherItem.ItemTypeID && i.LeatherType == leatherTypeID && i.LeatherStatusID == leatherStatusID && i.StoreID == item.ReceiveStore && i.PurchaseID.ToString() == purchaseInfo.PurchaseID.ToString() orderby i.TransectionID descending select i).FirstOrDefault(); Inv_StockSupplier objStockSupplier = new Inv_StockSupplier(); objStockSupplier.SupplierID = purchaseInfo.SupplierID; objStockSupplier.StoreID = item.ReceiveStore; objStockSupplier.PurchaseID = purchaseInfo.PurchaseID; objStockSupplier.RefChallanID = item.ChallanID; objStockSupplier.ItemTypeID = leatherItem.ItemTypeID; objStockSupplier.LeatherType = leatherTypeID; objStockSupplier.LeatherStatusID = leatherStatusID; objStockSupplier.UnitID = leatherItem.UnitID; objStockSupplier.OpeningQty = LastSupplierStock.ClosingQty; objStockSupplier.ReceiveQty = leatherItem.ReceiveQty; objStockSupplier.IssueQty = 0; objStockSupplier.ClosingQty = LastSupplierStock.ClosingQty + leatherItem.ReceiveQty; objStockSupplier.UpdateReason = "Receive"; _context.Inv_StockSupplier.Add(objStockSupplier); _context.SaveChanges(); } #endregion #region Item_Stock_Update var CheckItemStock = (from i in _context.Inv_StockItem.AsEnumerable() where i.ItemTypeID == leatherItem.ItemTypeID && i.LeatherType == leatherTypeID && i.LeatherStatus == leatherStatusID && i.StoreID == item.ReceiveStore select i).Any(); if (!CheckItemStock) { Inv_StockItem objStockItem = new Inv_StockItem(); objStockItem.ItemTypeID = leatherItem.ItemTypeID; objStockItem.LeatherType = leatherTypeID; objStockItem.LeatherStatus = leatherStatusID; objStockItem.StoreID = item.ReceiveStore; objStockItem.UnitID = leatherItem.UnitID; objStockItem.OpeningQty = 0; objStockItem.ReceiveQty = leatherItem.ReceiveQty; objStockItem.IssueQty = 0; objStockItem.ClosingQty = leatherItem.ReceiveQty; _context.Inv_StockItem.Add(objStockItem); _context.SaveChanges(); } else { var LastItemInfo = (from i in _context.Inv_StockItem where i.ItemTypeID == leatherItem.ItemTypeID && i.LeatherType == leatherTypeID && i.LeatherStatus == leatherStatusID && i.StoreID == item.ReceiveStore orderby i.TransectionID descending select i).FirstOrDefault(); //var LastItemInfo = (from i in context.Inv_StockItem // where i.TransectionID == LastItemTransactionID // select i).FirstOrDefault(); Inv_StockItem objStockItem = new Inv_StockItem(); objStockItem.OpeningQty = LastItemInfo.ClosingQty; objStockItem.IssueQty = 0; objStockItem.ReceiveQty = leatherItem.ReceiveQty; objStockItem.ClosingQty = LastItemInfo.ClosingQty + leatherItem.ReceiveQty; objStockItem.ItemTypeID = LastItemInfo.ItemTypeID; objStockItem.LeatherType = LastItemInfo.LeatherType; objStockItem.LeatherStatus = LastItemInfo.LeatherStatus; objStockItem.StoreID = LastItemInfo.StoreID; objStockItem.UnitID = leatherItem.UnitID; _context.Inv_StockItem.Add(objStockItem); _context.SaveChanges(); } #endregion leatherItem.RecordStatus = "CNF"; } } item.RecordStatus = "CNF"; } purchaseInfo.RecordStatus = "CNF"; _context.SaveChanges(); } Transaction.Complete(); } return(true); } catch (Exception e) { return(false); } }
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); } }