private IList<SearchResult> GetSearchResults(ClassScheduleDb db, string searchterm, string quarter)
{
SqlParameter[] parms = {
new SqlParameter("SearchWord", searchterm),
new SqlParameter("YearQuarterID", YearQuarter.ToYearQuarterID(quarter))
};
using (_profiler.Step("Executing search stored procedure"))
{
return db.ExecuteStoreQuery<SearchResult>("usp_ClassSearch @SearchWord, @YearQuarterID", parms).ToList();
}
}