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