public static List <Product> getAllProductsToCollect()
{
UniversityStoreEntities context = new UniversityStoreEntities();
List <string> pNumberList = new List <string>();
var q = from x in context.ConsolidatedRequisitionListDetails
join y in context.ConsolidatedRequisitionLists on x.ConsolidatedListID equals y.ConsolidatedListID
where y.Status == STATUS_OPEN
orderby x.DateRequest descending
group x by x.ItemNumber into g
select new
{
itemNumber = g.Key,
totalQty = g.Sum(x => x.QuantityRequested)
};
List <Object> olist = q.ToList <Object>();
if (olist.Count() != 0)
{
for (int i = 0; i < olist.Count(); i++)
{
pNumberList.Add(olist[i].ToString().Substring(15, 4));
//Console.WriteLine(o.ToString().Substring(15, 4));
// Console.WriteLine(o.ToString().Substring(32, 3).Trim());
}
}
return(ProductDAO.getProductFromListOfID2(pNumberList));
}
