// After Save & Update to get fresh data into page grid public List <PRDChemProdReqItem> GetRequisitionItemList(int _RequisitionID, byte _StoreID) { using (var context = new BLC_DEVEntities()) { var FinalStock = DalChemicalStock.ItemWiseStockInSpecificChemicalStore(_StoreID); var Data = (from r in context.PRD_ChemProdReqItem.AsEnumerable() where r.RequisitionID == _RequisitionID from i in context.Sys_ChemicalItem.Where(x => x.ItemID == r.ItemID).DefaultIfEmpty() from u in context.Sys_Unit.Where(x => x.UnitID == r.RequiredUnit).DefaultIfEmpty() from su in context.Sys_Unit.Where(x => x.UnitID == r.SizeUnit).DefaultIfEmpty() from rq in context.Sys_Unit.Where(x => x.UnitID == r.RequisitionUnit).DefaultIfEmpty() from ap in context.Sys_Unit.Where(x => x.UnitID == r.ApproveUnit).DefaultIfEmpty() from size in context.Sys_Size.Where(x => x.SizeID == r.PackSize).DefaultIfEmpty() join s in FinalStock on i.ItemID equals s.ItemID into StockInfo from item in StockInfo.DefaultIfEmpty() join sup in context.Sys_Supplier on(item == null ? 0 : item.SupplierID) equals sup.SupplierID into badhon2 from finalitem in badhon2.DefaultIfEmpty() select new PRDChemProdReqItem { RequisitionItemID = r.RequisitionItemID, ItemID = r.ItemID, ItemName = (i == null ? null : i.ItemName), RequiredQty = Convert.ToDecimal(r.RequiredQty), RequiredUnit = Convert.ToByte(r.RequiredUnit), RequiredUnitName = (u == null ? null : u.UnitName), PackSize = Convert.ToByte(r.PackSize), PackSizeName = (size == null ? null : size.SizeName), SizeUnit = Convert.ToByte(r.SizeUnit), SizeUnitName = (su == null ? null : su.UnitName), PackQty = Convert.ToInt32(r.PackQty), RequsitionQty = r.RequsitionQty, RequisitionUnit = r.RequisitionUnit, RequisitionUnitName = (rq == null ? null : rq.UnitName), ApproveQty = Convert.ToDecimal(r.ApproveQty), ApproveUnit = Convert.ToByte(r.ApproveUnit), ApproveUnitName = (ap == null ? null : ap.UnitName), StockQty = (item == null ? 0 : (item.ClosingQty)), //StockUnitName = (su == null ? null : su.UnitName), SupplierID = (finalitem == null ? 0 : finalitem.SupplierID), SupplierName = (finalitem == null ? null : finalitem.SupplierName) }).ToList(); return(Data); } }
public List <PRDChemProdReqItem> GetTransactionItemListForStockAdjust(long _TransactionID, string _IssueFrom) { using (var context = new BLC_DEVEntities()) { var StockResult = DalChemicalStock.CombinationWiseStockInSpecificProductionFloor(Convert.ToByte(_IssueFrom)); var Data = (from i in context.INV_StoreTransItem.AsEnumerable() where i.TransactionID == _TransactionID join s in StockResult on new { ItemID = (i.ItemID == null? 0: i.ItemID), SupplierID = (i.SupplierID == null? 0 : i.SupplierID), UnitID = (i.TransactionUnit == null?0:i.TransactionUnit) } equals new { ItemID = s.ItemID, SupplierID = s.SupplierID, UnitID = s.UnitID } into StockInfo from item in StockInfo.DefaultIfEmpty() join su in context.Sys_Unit on(item == null ? 0 : item.UnitID) equals su.UnitID into StockUnits from su in StockUnits.DefaultIfEmpty() join sup in context.Sys_Supplier on(item == null ? 0 : item.SupplierID) equals sup.SupplierID into Suppliers from sup in Suppliers.DefaultIfEmpty() from it in context.Sys_ChemicalItem.Where(x => x.ItemID == i.ItemID).DefaultIfEmpty() from iu in context.Sys_Unit.Where(x => x.UnitID == i.TransactionUnit).DefaultIfEmpty() select new PRDChemProdReqItem { TransItemID = i.TransItemID, ItemID = i.ItemID, ItemName = (it == null ? null : it.ItemName), StockQty = (item == null ? 0 : item.ClosingQty), StockUnitName = (su == null ? null : su.UnitName), SupplierID = (sup == null ? 0 : sup.SupplierID), SupplierName = (sup == null ? null : sup.SupplierName), IssueQty = i.TransactionQty, IssueUnit = i.TransactionUnit, IssueUnitName = (iu == null ? "" : iu.UnitName) }).ToList(); return(Data); } }