public InvLeatherIssue SetToBussinessObject(Inv_LeatherIssue Entity) { InvLeatherIssue Model = new InvLeatherIssue(); Model.IssueID = Entity.IssueID; Model.IssueDate = Entity.IssueDate.Date.ToString("dd/MM/yyyy"); Model.IssueRef = Entity.IssueRef; Model.IssueFor = Entity.IssueFor; //switch (Entity.IssueFor) //{ // case "Leather": // Model.IssueForName = "Store Transfer"; // break; // case "Production": // Model.IssueForName = "Production"; // break; // case "Job Order": // Model.IssueForName = "Job Order"; // break; //} Model.IssueFrom = Entity.IssueFrom; Model.IssueFromName = Entity.IssueFrom == null ? "" : _context.SYS_Store.Where(m => m.StoreID == Entity.IssueFrom).FirstOrDefault().StoreName; Model.IssueTo = Entity.IssueTo; Model.IssueToName = Entity.IssueTo == null ? "" : _context.SYS_Store.Where(m => m.StoreID == Entity.IssueTo).FirstOrDefault().StoreName; Model.JobOrderNo = Entity.JobOrderNo; Model.JobOrderNo = Entity.JobOrderNo; Model.PurchaseYear = Entity.PurchaseYear; Model.RecordStatus = Entity.RecordStatus; switch (Entity.RecordStatus) { case "NCF": Model.RecordStatusName = "Not Confirmed"; break; case "CNF": Model.RecordStatusName = "Confirmed"; break; case "APV": Model.RecordStatusName = "Approved"; break; case "RCV": Model.RecordStatusName = "Received"; break; default: Model.RecordStatusName = ""; break; } return(Model); }
public ValidationMsg Save(InvLeatherIssue model, int userid) { _vmMsg = new ValidationMsg(); try { using (var tx = new TransactionScope()) { using (_context) { model.SetBy = userid; Inv_LeatherIssue tblLeatherIssue = SetToModelObject(model); _context.Inv_LeatherIssue.Add(tblLeatherIssue); _context.SaveChanges(); #region Save Detail Records if (model.LeatherIssueItemList != null) { foreach (InvLeatherIssueItem objInvLeatherIssueItem in model.LeatherIssueItemList) { objInvLeatherIssueItem.SetBy = userid; objInvLeatherIssueItem.IssueID = tblLeatherIssue.IssueID; Inv_LeatherIssueItem tblPurchaseYearPeriod = SetToModelObject(objInvLeatherIssueItem); _context.Inv_LeatherIssueItem.Add(tblPurchaseYearPeriod); } } _context.SaveChanges(); #endregion tx.Complete(); IssueID = tblLeatherIssue.IssueID; _vmMsg.Type = Enums.MessageType.Success; _vmMsg.Msg = "Saved Successfully."; } } } catch { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to save."; } return(_vmMsg); }
public Inv_LeatherIssue SetToModelObject(InvLeatherIssue model) { Inv_LeatherIssue Entity = new Inv_LeatherIssue(); Entity.IssueID = model.IssueID; Entity.IssueDate = DalCommon.SetDate(model.IssueDate);// Convert.ToDateTime(model.IssueDate).Date; Entity.IssueFor = model.IssueFor; Entity.IssueRef = model.IssueRef; Entity.IssueFrom = model.IssueFrom; Entity.IssueTo = model.IssueTo; Entity.JobOrderNo = model.JobOrderNo; Entity.PurchaseYear = model.PurchaseYear; Entity.RecordStatus = "NCF"; Entity.SetOn = DateTime.Now; Entity.SetBy = model.SetBy; Entity.IPAddress = string.Empty; return(Entity); }
public ActionResult LeatherIssueConfirmed(InvLeatherIssue model) { _vmMsg = DalObj.LeatherIssueConfirmed(model, Convert.ToInt32(Session["UserID"])); return(Json(new { msg = _vmMsg })); }
public ActionResult LeatherIssue(InvLeatherIssue model) { _vmMsg = model.IssueID == 0 ? DalObj.Save(model, Convert.ToInt32(Session["UserID"])) : DalObj.Update(model, Convert.ToInt32(Session["UserID"])); return(Json(new { IssueID = DalObj.GetIssueID(), msg = _vmMsg })); }
public ValidationMsg Update(InvLeatherIssue model, int userid) { _vmMsg = new ValidationMsg(); try { using (var tx = new TransactionScope()) { using (_context) { Inv_LeatherIssue CurrentEntity = SetToModelObject(model); var OriginalEntity = _context.Inv_LeatherIssue.First(m => m.IssueID == model.IssueID); OriginalEntity.IssueDate = CurrentEntity.IssueDate;// Convert.ToDateTime(CurrentEntity.IssueDate).Date; OriginalEntity.IssueFor = CurrentEntity.IssueFor; OriginalEntity.IssueRef = CurrentEntity.IssueRef; OriginalEntity.IssueFrom = CurrentEntity.IssueFrom; OriginalEntity.IssueTo = CurrentEntity.IssueTo; OriginalEntity.JobOrderNo = CurrentEntity.JobOrderNo; OriginalEntity.PurchaseYear = CurrentEntity.PurchaseYear; OriginalEntity.SetBy = userid; OriginalEntity.SetOn = DateTime.Now; #region Save Detail Records if (model.LeatherIssueItemList != null) { foreach (InvLeatherIssueItem objInvLeatherIssueItem in model.LeatherIssueItemList) { if (objInvLeatherIssueItem.ItemIssueID == 0) { objInvLeatherIssueItem.IssueID = model.IssueID; Inv_LeatherIssueItem tblPurchaseYearPeriod = SetToModelObject(objInvLeatherIssueItem); _context.Inv_LeatherIssueItem.Add(tblPurchaseYearPeriod); } else { Inv_LeatherIssueItem CurEntity = SetToModelObject(objInvLeatherIssueItem); var OrgEntity = _context.Inv_LeatherIssueItem.First(m => m.ItemIssueID == objInvLeatherIssueItem.ItemIssueID); OrgEntity.SupplierID = CurEntity.SupplierID; OrgEntity.ChallanID = CurEntity.ChallanID; OrgEntity.ItemType = CurEntity.ItemType; OrgEntity.LeatherType = CurEntity.LeatherType; OrgEntity.LeatherStatus = CurEntity.LeatherStatus; OrgEntity.IssueQty = CurEntity.IssueQty; OrgEntity.UnitID = CurEntity.UnitID; OrgEntity.IssueSide = CurEntity.IssueSide; OrgEntity.Remarks = CurEntity.Remarks; OrgEntity.SetBy = userid; OrgEntity.SetOn = DateTime.Now; } } } _context.SaveChanges(); #endregion tx.Complete(); IssueID = model.IssueID; _vmMsg.Type = Enums.MessageType.Update; _vmMsg.Msg = "Updated Successfully."; } } } catch { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to Update."; } return(_vmMsg); }
public ValidationMsg LeatherIssueConfirmed(InvLeatherIssue model, int userid) { _vmMsg = new ValidationMsg(); try { using (var tx = new TransactionScope()) { using (_context) { #region Update Record Status var OriginalEntity = _context.Inv_LeatherIssue.First(m => m.IssueID == model.IssueID); OriginalEntity.ApprovedBy = userid; OriginalEntity.ApproveComment = model.ApproveComment; OriginalEntity.RecordStatus = "CNF"; #endregion #region Update Store if (model.LeatherIssueItemList != null) { foreach (InvLeatherIssueItem objLeatherIssueItem in model.LeatherIssueItemList) { objLeatherIssueItem.StoreIdIssueFrom = model.IssueFrom; objLeatherIssueItem.StoreIdIssueTo = model.IssueTo; #region Store Issue #region Supplier_Stock_Update var CheckSupplierStock = (from i in _context.Inv_StockSupplier where i.SupplierID == objLeatherIssueItem.SupplierID && i.ItemTypeID == objLeatherIssueItem.ItemType && i.LeatherType == objLeatherIssueItem.LeatherType && i.LeatherStatusID == objLeatherIssueItem.LeatherStatus && i.StoreID == objLeatherIssueItem.StoreIdIssueFrom && i.PurchaseID == objLeatherIssueItem.PurchaseID select i).Any(); if (!CheckSupplierStock) { Inv_StockSupplier tblStockSupplier = SetToModelObjectStockSupplier(objLeatherIssueItem); _context.Inv_StockSupplier.Add(tblStockSupplier); _context.SaveChanges(); } else { var LastSupplierStock = (from i in _context.Inv_StockSupplier where i.SupplierID == objLeatherIssueItem.SupplierID && i.ItemTypeID == objLeatherIssueItem.ItemType && i.LeatherType == objLeatherIssueItem.LeatherType && i.LeatherStatusID == objLeatherIssueItem.LeatherStatus && i.StoreID == objLeatherIssueItem.StoreIdIssueFrom && i.PurchaseID == objLeatherIssueItem.PurchaseID orderby i.TransectionID descending select i).FirstOrDefault(); Inv_StockSupplier objStockSupplier = new Inv_StockSupplier(); objStockSupplier.SupplierID = objLeatherIssueItem.SupplierID; objStockSupplier.StoreID = Convert.ToByte(objLeatherIssueItem.StoreIdIssueFrom); objStockSupplier.RefChallanID = objLeatherIssueItem.ChallanID; objStockSupplier.PurchaseID = objLeatherIssueItem.PurchaseID; objStockSupplier.ItemTypeID = objLeatherIssueItem.ItemType; objStockSupplier.LeatherType = objLeatherIssueItem.LeatherType; objStockSupplier.LeatherStatusID = objLeatherIssueItem.LeatherStatus; objStockSupplier.UnitID = objLeatherIssueItem.UnitID; objStockSupplier.OpeningQty = LastSupplierStock.ClosingQty; objStockSupplier.ReceiveQty = 0; objStockSupplier.IssueQty = objLeatherIssueItem.IssueQty; objStockSupplier.ClosingQty = LastSupplierStock.ClosingQty - objLeatherIssueItem.IssueQty; objStockSupplier.UpdateReason = "issue"; _context.Inv_StockSupplier.Add(objStockSupplier); _context.SaveChanges(); } #endregion #region Item_Stock_Update var CheckItemStock = (from i in _context.Inv_StockItem where i.ItemTypeID == objLeatherIssueItem.ItemType && i.LeatherType == objLeatherIssueItem.LeatherType && i.LeatherStatus == objLeatherIssueItem.LeatherStatus && i.StoreID == objLeatherIssueItem.StoreIdIssueFrom select i).Any(); if (!CheckItemStock) { Inv_StockItem objStockItem = new Inv_StockItem(); objStockItem.ItemTypeID = objLeatherIssueItem.ItemType; objStockItem.LeatherType = objLeatherIssueItem.LeatherType; objStockItem.LeatherStatus = objLeatherIssueItem.LeatherStatus; objStockItem.StoreID = Convert.ToByte(objLeatherIssueItem.StoreIdIssueFrom); objStockItem.UnitID = objLeatherIssueItem.UnitID; objStockItem.OpeningQty = objLeatherIssueItem.StockQty; objStockItem.IssueQty = objLeatherIssueItem.IssueQty; objStockItem.ReceiveQty = 0; objStockItem.ClosingQty = objLeatherIssueItem.StockQty - objLeatherIssueItem.IssueQty; _context.Inv_StockItem.Add(objStockItem); _context.SaveChanges(); } else { var LastItemInfo = (from i in _context.Inv_StockItem where i.ItemTypeID == objLeatherIssueItem.ItemType && i.LeatherType == objLeatherIssueItem.LeatherType && i.LeatherStatus == objLeatherIssueItem.LeatherStatus && i.StoreID == objLeatherIssueItem.StoreIdIssueFrom orderby i.TransectionID descending select i).FirstOrDefault(); Inv_StockItem objStockItem = new Inv_StockItem(); objStockItem.ItemTypeID = LastItemInfo.ItemTypeID; objStockItem.LeatherType = LastItemInfo.LeatherType; objStockItem.LeatherStatus = LastItemInfo.LeatherStatus; objStockItem.StoreID = LastItemInfo.StoreID; objStockItem.UnitID = objLeatherIssueItem.UnitID; objStockItem.OpeningQty = LastItemInfo.ClosingQty; objStockItem.ReceiveQty = 0; objStockItem.IssueQty = objLeatherIssueItem.IssueQty; objStockItem.ClosingQty = LastItemInfo.ClosingQty - objLeatherIssueItem.IssueQty; _context.Inv_StockItem.Add(objStockItem); _context.SaveChanges(); } #endregion #region Daily_Stock_Update var currentDate = System.DateTime.Now.Date; var CheckDate = (from ds in _context.Inv_StockDaily where ds.ItemTypeID == objLeatherIssueItem.ItemType && ds.StoreID == objLeatherIssueItem.StoreIdIssueFrom && ds.LeatherStatus == objLeatherIssueItem.LeatherStatus && ds.LeatherType == objLeatherIssueItem.LeatherType && ds.StockDate == currentDate select ds).Any(); if (CheckDate) { var CurrentItem = (from ds in _context.Inv_StockDaily where ds.ItemTypeID == objLeatherIssueItem.ItemType && ds.StoreID == objLeatherIssueItem.StoreIdIssueFrom && ds.LeatherStatus == objLeatherIssueItem.LeatherStatus && ds.LeatherType == objLeatherIssueItem.LeatherType && ds.StockDate == currentDate select ds).FirstOrDefault(); CurrentItem.DailyIssueQty = CurrentItem.DailyIssueQty + objLeatherIssueItem.IssueQty; CurrentItem.ClosingQty = CurrentItem.ClosingQty - objLeatherIssueItem.IssueQty; _context.SaveChanges(); } else { var PreviousRecord = (from ds in _context.Inv_StockDaily where ds.ItemTypeID == objLeatherIssueItem.ItemType && ds.StoreID == objLeatherIssueItem.StoreIdIssueFrom && ds.LeatherStatus == objLeatherIssueItem.LeatherStatus && ds.LeatherType == objLeatherIssueItem.LeatherType orderby ds.TransectionID descending select ds).FirstOrDefault(); Inv_StockDaily objStockDaily = new Inv_StockDaily(); objStockDaily.ItemTypeID = objLeatherIssueItem.ItemType; objStockDaily.StoreID = Convert.ToByte(objLeatherIssueItem.StoreIdIssueFrom); objStockDaily.UnitID = objLeatherIssueItem.UnitID; objStockDaily.LeatherStatus = objLeatherIssueItem.LeatherStatus; objStockDaily.LeatherType = objLeatherIssueItem.LeatherType; objStockDaily.OpeningQty = (PreviousRecord == null ? 0 : PreviousRecord.ClosingQty); objStockDaily.DailyReceiveQty = 0; objStockDaily.DailyIssueQty = objLeatherIssueItem.IssueQty; objStockDaily.ClosingQty = objStockDaily.OpeningQty - objLeatherIssueItem.IssueQty; objStockDaily.StockDate = currentDate; _context.Inv_StockDaily.Add(objStockDaily); _context.SaveChanges(); } #endregion #endregion #region storeReceive //if (model.IssueFor == "Production" || model.IssueFor == "Job Order") if (model.IssueFor == "Job Order") { #region Supplier_Stock_Update var CheckSupplierStockForRec = (from i in _context.Inv_StockSupplier where i.SupplierID == objLeatherIssueItem.SupplierID && i.ItemTypeID == objLeatherIssueItem.ItemType && i.LeatherType == objLeatherIssueItem.LeatherType && i.LeatherStatusID == objLeatherIssueItem.LeatherStatus && i.StoreID == objLeatherIssueItem.StoreIdIssueTo && i.PurchaseID == objLeatherIssueItem.PurchaseID select i).Any(); if (!CheckSupplierStockForRec) { Inv_StockSupplier Entity = new Inv_StockSupplier(); Entity.SupplierID = objLeatherIssueItem.SupplierID; Entity.StoreID = Convert.ToByte(objLeatherIssueItem.StoreIdIssueTo); Entity.RefChallanID = objLeatherIssueItem.ChallanID; Entity.PurchaseID = objLeatherIssueItem.PurchaseID; Entity.ItemTypeID = objLeatherIssueItem.ItemType; Entity.LeatherType = objLeatherIssueItem.LeatherType; Entity.LeatherStatusID = objLeatherIssueItem.LeatherStatus; Entity.UnitID = objLeatherIssueItem.UnitID; Entity.OpeningQty = 0; Entity.ReceiveQty = objLeatherIssueItem.IssueQty; Entity.IssueQty = 0; Entity.ClosingQty = objLeatherIssueItem.IssueQty; Entity.UpdateReason = "Job Order Receive"; _context.Inv_StockSupplier.Add(Entity); _context.SaveChanges(); } else { var LastSupplierStock = (from i in _context.Inv_StockSupplier where i.SupplierID == objLeatherIssueItem.SupplierID && i.ItemTypeID == objLeatherIssueItem.ItemType && i.LeatherType == objLeatherIssueItem.LeatherType && i.LeatherStatusID == objLeatherIssueItem.LeatherStatus && i.StoreID == objLeatherIssueItem.StoreIdIssueTo && i.PurchaseID == objLeatherIssueItem.PurchaseID orderby i.TransectionID descending select i).FirstOrDefault(); Inv_StockSupplier objStockSupplier = new Inv_StockSupplier(); objStockSupplier.SupplierID = objLeatherIssueItem.SupplierID; objStockSupplier.StoreID = Convert.ToByte(objLeatherIssueItem.StoreIdIssueTo); objStockSupplier.RefChallanID = objLeatherIssueItem.ChallanID; objStockSupplier.PurchaseID = objLeatherIssueItem.PurchaseID; objStockSupplier.ItemTypeID = objLeatherIssueItem.ItemType; objStockSupplier.LeatherType = objLeatherIssueItem.LeatherType; objStockSupplier.LeatherStatusID = objLeatherIssueItem.LeatherStatus; objStockSupplier.UnitID = objLeatherIssueItem.UnitID; objStockSupplier.OpeningQty = LastSupplierStock.ClosingQty; objStockSupplier.ReceiveQty = objLeatherIssueItem.IssueQty; objStockSupplier.IssueQty = 0; objStockSupplier.ClosingQty = LastSupplierStock.ClosingQty + objLeatherIssueItem.IssueQty; objStockSupplier.UpdateReason = "Job Order Receive"; _context.Inv_StockSupplier.Add(objStockSupplier); _context.SaveChanges(); } #endregion #region Item_Stock_Update var CheckItemStockForRec = (from i in _context.Inv_StockItem where i.ItemTypeID == objLeatherIssueItem.ItemType && i.LeatherType == objLeatherIssueItem.LeatherType && i.LeatherStatus == objLeatherIssueItem.LeatherStatus && i.StoreID == objLeatherIssueItem.StoreIdIssueTo select i).Any(); if (!CheckItemStockForRec) { Inv_StockItem objStockItem = new Inv_StockItem(); objStockItem.ItemTypeID = objLeatherIssueItem.ItemType; objStockItem.LeatherType = objLeatherIssueItem.LeatherType; objStockItem.LeatherStatus = objLeatherIssueItem.LeatherStatus; objStockItem.StoreID = Convert.ToByte(objLeatherIssueItem.StoreIdIssueTo); objStockItem.UnitID = objLeatherIssueItem.UnitID; objStockItem.OpeningQty = 0; objStockItem.ReceiveQty = objLeatherIssueItem.IssueQty; objStockItem.IssueQty = 0; objStockItem.ClosingQty = objLeatherIssueItem.IssueQty; _context.Inv_StockItem.Add(objStockItem); _context.SaveChanges(); } else { var LastItemInfo = (from i in _context.Inv_StockItem where i.ItemTypeID == objLeatherIssueItem.ItemType && i.LeatherType == objLeatherIssueItem.LeatherType && i.LeatherStatus == objLeatherIssueItem.LeatherStatus && i.StoreID == objLeatherIssueItem.StoreIdIssueTo orderby i.TransectionID descending select i).FirstOrDefault(); Inv_StockItem objStockItem = new Inv_StockItem(); objStockItem.ItemTypeID = LastItemInfo.ItemTypeID; objStockItem.LeatherType = LastItemInfo.LeatherType; objStockItem.LeatherStatus = LastItemInfo.LeatherStatus; objStockItem.StoreID = LastItemInfo.StoreID; objStockItem.UnitID = objLeatherIssueItem.UnitID; objStockItem.OpeningQty = LastItemInfo.ClosingQty; objStockItem.ReceiveQty = objLeatherIssueItem.IssueQty; objStockItem.IssueQty = 0; objStockItem.ClosingQty = LastItemInfo.ClosingQty + objLeatherIssueItem.IssueQty; _context.Inv_StockItem.Add(objStockItem); _context.SaveChanges(); } #endregion #region Daily_Stock_Update //var currentDate = System.DateTime.Now.Date; var CheckDateForRec = (from ds in _context.Inv_StockDaily where ds.ItemTypeID == objLeatherIssueItem.ItemType && ds.StoreID == objLeatherIssueItem.StoreIdIssueTo && ds.LeatherStatus == objLeatherIssueItem.LeatherStatus && ds.LeatherType == objLeatherIssueItem.LeatherType && ds.StockDate == currentDate select ds).Any(); if (CheckDateForRec) { var CurrentItem = (from ds in _context.Inv_StockDaily where ds.ItemTypeID == objLeatherIssueItem.ItemType && ds.StoreID == objLeatherIssueItem.StoreIdIssueTo && ds.LeatherStatus == objLeatherIssueItem.LeatherStatus && ds.LeatherType == objLeatherIssueItem.LeatherType && ds.StockDate == currentDate select ds).FirstOrDefault(); CurrentItem.DailyReceiveQty = CurrentItem.DailyReceiveQty + objLeatherIssueItem.IssueQty; CurrentItem.ClosingQty = CurrentItem.ClosingQty + objLeatherIssueItem.IssueQty; _context.SaveChanges(); } else { var PreviousRecord = (from ds in _context.Inv_StockDaily where ds.ItemTypeID == objLeatherIssueItem.ItemType && ds.StoreID == objLeatherIssueItem.StoreIdIssueTo && ds.LeatherStatus == objLeatherIssueItem.LeatherStatus && ds.LeatherType == objLeatherIssueItem.LeatherType orderby ds.TransectionID descending select ds).FirstOrDefault(); Inv_StockDaily objStockDaily = new Inv_StockDaily(); objStockDaily.ItemTypeID = objLeatherIssueItem.ItemType; objStockDaily.StoreID = Convert.ToByte(objLeatherIssueItem.StoreIdIssueTo); objStockDaily.UnitID = objLeatherIssueItem.UnitID; objStockDaily.LeatherStatus = objLeatherIssueItem.LeatherStatus; objStockDaily.LeatherType = objLeatherIssueItem.LeatherType; objStockDaily.OpeningQty = (PreviousRecord == null ? 0 : PreviousRecord.ClosingQty); objStockDaily.DailyReceiveQty = objLeatherIssueItem.IssueQty; objStockDaily.DailyIssueQty = 0; objStockDaily.ClosingQty = objStockDaily.OpeningQty + objLeatherIssueItem.IssueQty; objStockDaily.StockDate = currentDate; _context.Inv_StockDaily.Add(objStockDaily); _context.SaveChanges(); } #endregion } #endregion #region Update Record Status var OriginalIssueItemEntity = _context.Inv_LeatherIssueItem.First(m => m.ItemIssueID == objLeatherIssueItem.ItemIssueID); OriginalIssueItemEntity.RecordStatus = "CNF"; #endregion } } #endregion _context.SaveChanges(); tx.Complete(); _vmMsg.Type = Enums.MessageType.Success; _vmMsg.Msg = "Confirmed Successfully."; } } } catch { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to Confirmed."; } return(_vmMsg); }