public int Update(PRDChemProdReq model, int userId) { try { using (TransactionScope transaction = new TransactionScope()) { using (_context) { #region PI_Informaiton_Update var CurrentRequisition = (from p in _context.PRD_ChemProdReq.AsEnumerable() where p.RequisitionID == model.RequisitionID select p).FirstOrDefault(); CurrentRequisition.RequisitionCategory = model.RequisitionCategory; CurrentRequisition.RequisitionType = model.RequisitionType; CurrentRequisition.RequisitionFrom = model.RequisitionFrom; CurrentRequisition.RequisitionTo = model.RequisitionTo; CurrentRequisition.RequiredByTime = model.RequiredByTime; CurrentRequisition.ReqRaisedBy = 1; CurrentRequisition.ReqRaisedOn = DalCommon.SetDate((model.ReqRaisedOn).ToString()); if (model.RecipeFor == 0) { CurrentRequisition.RecipeFor = null; } else { CurrentRequisition.RecipeFor = model.RecipeFor; } if (model.RecipeID == 0) { CurrentRequisition.RecipeID = null; } else { CurrentRequisition.RecipeID = model.RecipeID; } //CurrentRequisition.RecipeFor = model.RecipeFor; //CurrentRequisition.RecipeID = model.RecipeID; CurrentRequisition.ArticleNo = model.ArticleNo; CurrentRequisition.Thickness = model.Thickness; if (model.ThicknessUnit != null) { CurrentRequisition.ThicknessUnit = model.ThicknessUnit; } CurrentRequisition.LeatherSize = model.LeatherSize; if (model.SizeUnit != null) { CurrentRequisition.SizeUnit = model.SizeUnit; } CurrentRequisition.Selection = model.Selection; CurrentRequisition.ProductionQty = model.ProductionQty; CurrentRequisition.ModifiedBy = userId; CurrentRequisition.ModifiedOn = DateTime.Now; _context.SaveChanges(); #endregion #region Update Requisition ItemList if (model.RequisitionItemList != null) { foreach (var item in model.RequisitionItemList) { var checkRequisitionItem = (from i in _context.PRD_ChemProdReqItem.AsEnumerable() where i.RequisitionItemID == item.RequisitionItemID select i).Any(); #region New_Requisition_Insertion if (!checkRequisitionItem) { PRD_ChemProdReqItem objItem = new PRD_ChemProdReqItem(); objItem.RequisitionID = model.RequisitionID; objItem.ItemID = Convert.ToInt32(item.ItemID); if (item.SupplierID == 0) { objItem.SupplierID = null; } else { objItem.SupplierID = item.SupplierID; } objItem.RequiredQty = item.RequiredQty; if (item.RequiredUnitName == null) { objItem.RequiredUnit = null; } else { objItem.RequiredUnit = DalCommon.GetUnitCode(item.RequiredUnitName); } objItem.RequsitionQty = Convert.ToDecimal(item.RequsitionQty); objItem.RequisitionUnit = DalCommon.GetUnitCode(item.RequisitionUnitName); if (item.PackSizeName == null) { objItem.PackSize = null; } else { objItem.PackSize = DalCommon.GetSizeCode(item.PackSizeName); } //objItem.PackSize = DalCommon.GetSizeCode(item.PackSizeName); if (item.SizeUnitName == null) { objItem.SizeUnit = null; } else { objItem.SizeUnit = DalCommon.GetUnitCode(item.SizeUnitName); } objItem.PackQty = item.PackQty; objItem.ApproveQty = item.ApproveQty; objItem.ApproveUnit = DalCommon.GetUnitCode(item.ApproveUnitName); //objItem.ManufacturerID = item.ManufacturerID; objItem.ItemSource = DalCommon.ReturnItemSource(item.ItemSource); objItem.SetOn = DateTime.Now; objItem.SetBy = userId; _context.PRD_ChemProdReqItem.Add(objItem); _context.SaveChanges(); } #endregion #region Existing_Requisition_Update else { var FoundRequisition = (from i in _context.PRD_ChemProdReqItem.AsEnumerable() where i.RequisitionItemID == item.RequisitionItemID select i).FirstOrDefault(); FoundRequisition.RequisitionID = model.RequisitionID; FoundRequisition.ItemID = Convert.ToInt32(item.ItemID); if (item.SupplierID == 0) { FoundRequisition.SupplierID = null; } else { FoundRequisition.SupplierID = item.SupplierID; } FoundRequisition.RequiredQty = item.RequiredQty; if (item.RequiredUnitName == null) { FoundRequisition.RequiredUnit = null; } else { FoundRequisition.RequiredUnit = DalCommon.GetUnitCode(item.RequiredUnitName); } FoundRequisition.RequsitionQty = Convert.ToDecimal(item.RequsitionQty); FoundRequisition.RequisitionUnit = DalCommon.GetUnitCode(item.RequisitionUnitName); if (item.PackSizeName == null) { FoundRequisition.PackSize = null; } else { FoundRequisition.PackSize = DalCommon.GetSizeCode(item.PackSizeName); } //objItem.PackSize = DalCommon.GetSizeCode(item.PackSizeName); if (item.SizeUnitName == null) { FoundRequisition.SizeUnit = null; } else { FoundRequisition.SizeUnit = DalCommon.GetUnitCode(item.SizeUnitName); } FoundRequisition.PackQty = item.PackQty; FoundRequisition.ApproveQty = item.ApproveQty; FoundRequisition.ApproveUnit = DalCommon.GetUnitCode(item.ApproveUnitName); FoundRequisition.ItemSource = DalCommon.ReturnItemSource(item.ItemSource); FoundRequisition.ModifiedOn = DateTime.Now; FoundRequisition.ModifiedBy = userId; _context.SaveChanges(); } #endregion } } #endregion } transaction.Complete(); } return(1); } catch (Exception e) { return(0); } }
public int Save(PRDChemProdReq model, int userId, string pageUrl) { int CurrentRequisitionID = 0; try { using (TransactionScope transaction = new TransactionScope()) { using (_context) { var GetRequisitionNo = DalCommon.GetPreDefineNextCodeByUrl(pageUrl); if (GetRequisitionNo != null) { #region New_Requisition_Insert PRD_ChemProdReq objRequisition = new PRD_ChemProdReq(); objRequisition.RequisitionNo = GetRequisitionNo; objRequisition.RequisitionCategory = model.RequisitionCategory; objRequisition.RequisitionType = model.RequisitionType; objRequisition.RequisitionFrom = model.RequisitionFrom; objRequisition.RequisitionTo = model.RequisitionTo; objRequisition.RequiredByTime = model.RequiredByTime; objRequisition.ReqRaisedBy = userId; objRequisition.ReqRaisedOn = DalCommon.SetDate((model.ReqRaisedOn).ToString()); if (model.RecipeFor == 0) { objRequisition.RecipeFor = null; } else { objRequisition.RecipeFor = model.RecipeFor; } if (model.RecipeID == 0) { objRequisition.RecipeID = null; } else { objRequisition.RecipeID = model.RecipeID; } objRequisition.ArticleNo = model.ArticleNo; objRequisition.Thickness = model.Thickness; if (model.ThicknessUnit != null) { objRequisition.ThicknessUnit = model.ThicknessUnit; } objRequisition.LeatherSize = model.LeatherSize; if (model.SizeUnit != null) { objRequisition.SizeUnit = model.SizeUnit; } objRequisition.Selection = model.Selection; objRequisition.ProductionQty = model.ProductionQty; objRequisition.RequisitionState = "RNG"; objRequisition.RequisitionStatus = "PND"; objRequisition.RecordStatus = "NCF"; objRequisition.SetBy = userId; objRequisition.SetOn = DateTime.Now; //if (model.BuyerAddressID == 0) // objPI.BeneficiaryAddressID = null; //else // objPI.BeneficiaryAddressID = model.BuyerAddressID; _context.PRD_ChemProdReq.Add(objRequisition); _context.SaveChanges(); CurrentRequisitionID = objRequisition.RequisitionID; #endregion #region Item Insert if (model.RequisitionItemList != null) { foreach (var item in model.RequisitionItemList) { PRD_ChemProdReqItem objItem = new PRD_ChemProdReqItem(); objItem.RequisitionID = CurrentRequisitionID; objItem.ItemID = Convert.ToInt32(item.ItemID); if (item.SupplierID == 0) { objItem.SupplierID = null; } else { objItem.SupplierID = item.SupplierID; } //objItem.SupplierID = item.SupplierID; objItem.RequiredQty = item.RequiredQty; if (item.RequiredUnitName == null) { objItem.RequiredUnit = null; } else { objItem.RequiredUnit = DalCommon.GetUnitCode(item.RequiredUnitName); } objItem.RequsitionQty = Convert.ToDecimal(item.RequsitionQty); objItem.RequisitionUnit = DalCommon.GetUnitCode(item.RequisitionUnitName); if (item.PackSizeName == null) { objItem.PackSize = null; } else { objItem.PackSize = DalCommon.GetSizeCode(item.PackSizeName); } //objItem.PackSize = DalCommon.GetSizeCode(item.PackSizeName); if (item.SizeUnitName == null) { objItem.SizeUnit = null; } else { objItem.SizeUnit = DalCommon.GetUnitCode(item.SizeUnitName); } //objItem.SizeUnit = DalCommon.GetUnitCode(item.SizeUnitName); objItem.PackQty = item.PackQty; objItem.ApproveQty = item.ApproveQty; objItem.ApproveUnit = DalCommon.GetUnitCode(item.ApproveUnitName); //objItem.ManufacturerID = item.ManufacturerID; objItem.ItemSource = DalCommon.ReturnItemSource(item.ItemSource); objItem.SetOn = DateTime.Now; objItem.SetBy = userId; _context.PRD_ChemProdReqItem.Add(objItem); _context.SaveChanges(); } } #endregion } } transaction.Complete(); } return(CurrentRequisitionID); } catch (Exception e) { return(0); } }