public LastPurchaseReceivedModel getLastReceiptInfoByShortItemNo(int shortItemNo) { Mapper.CreateMap<F43071, LastPurchaseReceivedModel>(); objF43071 = new F43071Repository(); F43071 objEntity = (from r in objF43071.GetAll() where r.ShortItemNo.Equals(shortItemNo) select r).OrderByDescending(x=>x.LastDocDate).FirstOrDefault(); LastPurchaseReceivedModel resultModel = new LastPurchaseReceivedModel(); resultModel = Mapper.Map(objEntity, resultModel); return resultModel; }
public IList<ContractPricingModel> getContractPricingData(IList<string> ItemList) { IList<ContractPricingModel> objResult = new List<ContractPricingModel>(); int? priVal = 1; var abPriorityVal = objABPriority.GetSingle(ab => ab.Priority == priVal); foreach (string item in ItemList) { var existingQuery = from r in objResult where r.ItemNo2nd.Contains(item) select r; if (existingQuery.Count() > 0) { objResult.Add(existingQuery.FirstOrDefault()); } else { ContractPricingModel cpm = new ContractPricingModel(); F41010Model itemModel = _F41010Manager.GetDataByItemNo2nd(item); F58ZX003 ABInfo = objABPrice.GetSingle(x => x.APLITM.Trim().Equals(item) && x.APAN8.Equals(abPriorityVal.AddressNo)); var DuplicateItem = from d in ItemList.ToList() where d.Equals(item) select d; if (DuplicateItem.Count() > 1) cpm.dupicateStatus = "Duplicate " + item; if (ABInfo != null) { cpm.HQABCur = ABInfo.APCRCD; cpm.ABPrice = (decimal)ABInfo.APUPRC; } if (itemModel != null) { cpm.ItemNo2nd = itemModel.ItemNo2nd; cpm.Desc1 = itemModel.Desc1; cpm.PricingList = generatePricing(itemModel.ItemNo2nd).ToList(); cpm.WHQtyList = generateWHQty(itemModel.ItemNo2nd).ToList(); cpm.SRQty = _F41021Manager.getSRQty_SumByItemShortItemNo(itemModel.ShortItemNo); cpm.OpenPOQty = _purchaseManager.getOpenPOQty_SumByShortItemNo(itemModel.ShortItemNo); cpm.OpenPOATP = cpm.OpenPOQty - ( _purchaseManager.getPurIndentQty_SumByItemShortItemNo(itemModel.ShortItemNo) + _F41021Manager.getInspQty_SumByItemShortItemNo(itemModel.ShortItemNo) + _F41021Manager.getInspATPQty_SumByItemShortItemNo(itemModel.ShortItemNo) + _F41021Manager.getGitQty_SumByItemShortItemNo(itemModel.ShortItemNo) ); cpm.CustomerCount = _salesManager.getCustomerCountByShortItemNo(itemModel.ShortItemNo); cpm.CurYearQty = _salesManager.getQty_sumByYearAndShortItemNo(DateTime.Today.Year, itemModel.ShortItemNo); cpm.Year1Qty = _salesManager.getQty_sumByYearAndShortItemNo(DateTime.Today.Year - 1, itemModel.ShortItemNo); cpm.Year2Qty = _salesManager.getQty_sumByYearAndShortItemNo(DateTime.Today.Year - 2, itemModel.ShortItemNo); cpm.Year3Qty = _salesManager.getQty_sumByYearAndShortItemNo(DateTime.Today.Year - 3, itemModel.ShortItemNo); LastPurchaseReceivedModel LR = new LastPurchaseReceivedModel(); LR =_purchaseManager.getLastReceiptInfoByShortItemNo(itemModel.ShortItemNo); if (LR != null) { cpm.LastReceiptCurr = LR.LastReceiptCurr; cpm.LastReceiptDate = LR.LastDocDate.Date; cpm.LastReceiptPrice = LR.LastReceiptPrice; } else { cpm.LastReceiptCurr = ""; cpm.LastReceiptPrice = 0; cpm.LastReceiptDate = null; } } else { cpm.ItemNo2nd = item; cpm.dupicateStatus = "Item not exist, Please verify"; cpm.Desc1 = "N/A in Item Master"; cpm.PricingList = null; cpm.WHQtyList = null; cpm.SRQty = 0; cpm.OpenPOQty = 0; cpm.OpenPOATP = 0; cpm.CustomerCount = 0; cpm.CurYearQty = 0; cpm.Year1Qty = 0; cpm.Year2Qty = 0; cpm.Year3Qty = 0; cpm.LocalPlanCode = ""; cpm.UnitPerCarton = 0; cpm.LastReceiptCurr = ""; cpm.LastReceiptPrice = 0; cpm.LastReceiptDate = null; } objResult.Add(cpm); } //if condition }//foreach return objResult; }