public static List<string> GetKeywords(string pre) { List<string> allKeywordsUnique = new List<string>(); List<string> allKeywords = new List<string>(); List<string> keywordsOne = new List<string>(); List<string> keywordsTwo = new List<string>(); List<string> keywordsThree = new List<string>(); using (ReggieRepoEntities dc = new ReggieRepoEntities()) { keywordsOne = (from f in dc.FILES where f.Keyword1.Contains(pre) select f.Keyword1).ToList(); } using (ReggieRepoEntities dc = new ReggieRepoEntities()) { keywordsTwo = (from f in dc.FILES where f.Keyword2.Contains(pre) select f.Keyword2).ToList(); } using (ReggieRepoEntities dc = new ReggieRepoEntities()) { keywordsThree = (from f in dc.FILES where f.Keyword3.Contains(pre) select f.Keyword3).ToList(); } allKeywords.AddRange(keywordsOne); allKeywords.AddRange(keywordsTwo); allKeywords.AddRange(keywordsThree); allKeywordsUnique = allKeywords.Distinct().ToList(); return allKeywordsUnique; }
public static List<string> GetResearchName(string pre) { List<string> researchNameUnique = new List<string>(); List<string> allResearchName = new List<string>(); using (ReggieRepoEntities dc = new ReggieRepoEntities()) { allResearchName = (from f in dc.FILES where f.Project_Name.Contains(pre) select f.Project_Name).ToList(); } researchNameUnique = allResearchName.Distinct().ToList(); return researchNameUnique; }
public static List<string> GetCommitteeName(string pre) { List<string> committeeNameUnique = new List<string>(); List<string> allCommittees = new List<string>(); List<string> allCommitteeOneName = new List<string>(); List<string> allCommitteeTwoName = new List<string>(); using (ReggieRepoEntities dc = new ReggieRepoEntities()) { allCommitteeOneName = (from f in dc.FILES where f.Chair_Name.Contains(pre) select f.Chair_Name).ToList(); allCommitteeTwoName = (from f in dc.FILES where f.Comm_Name.Contains(pre) select f.Comm_Name).ToList(); } allCommittees.AddRange(allCommitteeOneName); allCommittees.AddRange(allCommitteeTwoName); committeeNameUnique = allCommittees.Distinct().ToList(); return committeeNameUnique; }