private SearchResultNoSectionModel GetNoSectionSearchResults(ClassScheduleDb db, string searchterm, YearQuarter yrq)
{
SqlParameter[] parms = {
new SqlParameter("SearchWord", searchterm),
new SqlParameter("YearQuarterID", yrq.ID)
};
SearchResultNoSectionModel model = new SearchResultNoSectionModel {SearchedYearQuarter = yrq};
using (_profiler.Step("Executing 'other classes' stored procedure"))
{
model.NoSectionSearchResults = db.ExecuteStoreQuery<SearchResultNoSection>("usp_CourseSearch @SearchWord, @YearQuarterID", parms).ToList();
}
return model;
}