//For detailed information Requisition Detailed Page public List <Requisition_ItemBO> getRequisitionDetail(int reqID) { var qry = (from i in context.Items join si in context.Requisition_Item on i.ItemID equals si.ItemID where si.RequisitionID == reqID select new { si.ItemID, i.ItemNumber, i.Description, si.RequestedQty, si.ReceivedQty, i.UnitOfMeasure, si.Status }).ToList(); List <Requisition_ItemBO> lst = new List <Requisition_ItemBO>(); foreach (var q in qry) { Requisition_ItemBO b = new Requisition_ItemBO(); b.ItemID = q.ItemID; b.Description = q.Description; b.RequestedQty = q.RequestedQty; b.ReceivedQty = q.ReceivedQty; b.Uom = q.UnitOfMeasure; b.ItemNumber = q.ItemNumber; b.Status = q.Status; lst.Add(b); } return(lst); }
//Employee -- Approve Requisition Detail Page -- //1.. Get Requistion Item List by Requisition ID for detail page public List <Requisition_ItemBO> getRequisitionItem(int requisitionID) { List <Requisition_ItemBO> lst = new List <Requisition_ItemBO>(); var qry = (from r in context.Requisitions join ri in context.Requisition_Item on r.RequisitionID equals ri.RequisitionID join i in context.Items on ri.ItemID equals i.ItemID where r.RequisitionID == requisitionID select new { r.RequisitionID, ri.Requisition_ItemID, ri.ItemID, ri.RequestedQty, i.Description, i.UnitOfMeasure }) .ToList(); foreach (var q in qry) { Requisition_ItemBO reqItemBO = new Requisition_ItemBO(); reqItemBO.RequisitionID = q.RequisitionID; reqItemBO.Requisition_ItemID = q.Requisition_ItemID; reqItemBO.ItemID = q.ItemID; reqItemBO.RequestedQty = q.RequestedQty; reqItemBO.Description = q.Description; reqItemBO.Uom = q.UnitOfMeasure; lst.Add(reqItemBO); } return(lst); }