public int?criteriaAmount()
{
LUSSISEntities e = new LUSSISEntities();
List <RequisitionDetail> reqdetaillist = new List <RequisitionDetail>();
List <RequisitionDetail> temp = new List <RequisitionDetail>();
List <string> cata = new List <string>();
List <Catalogue> cataBy = new List <Catalogue>();
cata = e.Catalogues.Where(x => x.CategoryID == CategoryID).Select(x => x.ItemCode).ToList();
int?amount = 0;
foreach (Requisition req in dlist)
{
temp = e.RequisitionDetails.Where(x => x.RequisitionID == req.RequisitionID).ToList();
reqdetaillist.AddRange(temp);
}
foreach (string code in cata)
{
foreach (RequisitionDetail reqd in reqdetaillist)
{
if (reqd.ItemCode == code)
{
amount += reqd.ItemQty;
}
}
}
return(amount);
}
public List <Requisition> getReqByDepid()
{
LUSSISEntities e = new LUSSISEntities();
List <int> empid = new List <int>();
List <Requisition> temp = new List <Requisition>();
empid = e.Employees.Where(x => x.DepartmentID == DepartmentID).Select(x => x.EmployeeID).ToList();
foreach (var item in empid)
{
temp = e.Requisitions.Where(x => x.EmployeeID == item).ToList();
reql.AddRange(temp);
}
return(reql);
}