public HttpResponseMessage Get(string q) { using (ElectronicsEntities ee = new ElectronicsEntities()) { var ee_subjects = ee.GetSubjects(null, null, q).ToList(); var ee_articlesT = ee.GetArticles(null, q, null, null, null, null, null); var ee_articlesD = ee.GetArticles(null, null, q, null, null, null, null); var ee_articlesM = ee.GetArticles(null, null, null, q, null, null, null); var joined = ee_subjects.Select(s => new { Title = s.Name, ID = s.ID, Type = "S" }).ToList(); joined.AddRange(ee_articlesT.Select(a => new { Title = a.Title, ID = a.ID, Type = "A" }).ToList()); joined.AddRange(ee_articlesD.Select(a => new { Title = a.Title, ID = a.ID, Type = "A" }).ToList()); joined.AddRange(ee_articlesM.Select(a => new { Title = a.Title, ID = a.ID, Type = "A" }).ToList()); return(Globals.FinishResponse(joined)); } }
public HttpResponseMessage Get() { using (ElectronicsEntities ee = new ElectronicsEntities()) { var ee_subjects = ee.GetSubjects(null, null, null); List <SubjectResponse> subjects = new List <SubjectResponse>(); foreach (var s in ee_subjects) { var ee_articles = ee.GetArticles(null, null, null, null, null, s.ID, null).ToList(); subjects.Add(new SubjectResponse { ID = s.ID, ParentID = s.ParentID, Name = s.Name, Articles = ee_articles.Select(a => new { ID = a.ID, Title = a.Title, URL = a.FilePath }) }); } return(Globals.FinishResponse(subjects)); } }