public List <RequestType> GetRequestTypeChildren(long requestTypeId) { var requestTypeManager = new RequestTypeManager(); if (requestTypeId == 0) { return(GetQuery().ToList()); } var request1 = GetQuery(p => p.RequestTypeID == requestTypeId).ToList(); var child = requestTypeManager.GetQuery(p => p.ParentRequestType == requestTypeId); foreach (var item in child) { var x1 = GetQuery(p => p.RequestTypeID == item.RequestTypeID).ToList(); request1.AddRange(x1); var nave = requestTypeManager.GetQuery(p => p.ParentRequestType == item.RequestTypeID); foreach (var item1 in nave) { var x2 = base.GetQuery(p => p.RequestTypeID == item1.RequestTypeID).ToList(); request1.AddRange(x2); } } var x3 = request1.ToList(); return(x3); }
public List <Request> GetRequestWithChildRequestType(DateTime?toDate, DateTime?fromDate, long requestTypeId) { var requestTypeManager = new RequestTypeManager(); if (requestTypeId == 0) { return(GetQuery(r => r.InsertDate <= toDate && r.InsertDate >= fromDate).ToList()); } var request1 = GetQuery(p => p.RequestTypeID == requestTypeId).ToList(); var child = requestTypeManager.GetQuery(p => p.ParentRequestType == requestTypeId); foreach (var item in child) { var x1 = GetQuery(p => p.RequestTypeID == item.RequestTypeID).ToList(); request1.AddRange(x1); var nave = requestTypeManager.GetQuery(p => p.ParentRequestType == item.RequestTypeID); foreach (var item1 in nave) { var x2 = base.GetQuery(p => p.RequestTypeID == item1.RequestTypeID).ToList(); request1.AddRange(x2); } } var x3 = request1.ToList().Where(r => r.InsertDate <= toDate && r.InsertDate >= fromDate).ToList(); return(x3); }