public static List <DisbursementListForSend> showDisbursementSeBy(int CpId)
{
LastADEntities entities = new LastADEntities();
List <int> list = Business.GetRequidWaitingForDelivery();
List <Transaction> tr = new List <Transaction>();
foreach (int id in list)
{
List <Transaction> trans = entities.Requisitions.Where(x => x.RequId == id).First().Transactions.ToList();
foreach (Transaction tran in trans)
{
tr.Add(tran);
}
}
var tt = tr.Where(p => p.Requisition.Employee.Department.CollectionPoint.CollectionPointId.Equals(CpId)).
Join(entities.Departments, m => m.Requisition.Employee.DepartmentCode, f => f.DepartmentCode,
(m, f) => new DisbursementListForDepa {
CollectionPoint = f.CollectionPoint.CollectionPointName, Description = m.ItemList.Description, Quantity = m.Quantity
}).ToList();
var dd = tt.GroupBy(x => x.Description).Select(y => new DisbursementListForSend {
Description = y.Key, Quantity = y.Sum(x => x.Quantity)
}).ToList();
return(dd);
}
public List <int> GetRequisitionidWaitingForDelivery()
{
return(Business.GetRequidWaitingForDelivery());
}
