// 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);
}
}