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