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