public ActionResult Search(HomeIndexModel model) { if (!ModelState.IsValid) { model.SelectedLogDatabase = GetSelectedConnectionStringName(); model.OutputRowCount = GetTopValue(); model.LogDatabases.AddRange(LogDatabaseConnectionStrings.Select(css => new SelectListItem { Text = css.Name.Replace(LogDatabase.ConnectionStringPrefix, string.Empty), Value = css.Name, })); return(View("Index", model)); } var profiler = MiniProfiler.Current; using (profiler.Step("Getting logs from database")) using (var sqlConn = CreateProfiledDbConnection()) { var searchTerm = "%" + model.SearchTerm.Replace("%", "[%]").Replace("[", "[[]").Replace("]", "[]]") + "%"; model.Logs.AddRange(sqlConn.Query <Log>(GetSearchSql(GetTopValue()), new { searchTerm })); } model.SelectedLogDatabase = GetSelectedConnectionStringName(); model.OutputRowCount = GetTopValue(); model.LogDatabases.AddRange(LogDatabaseConnectionStrings.Select(css => new SelectListItem { Text = css.Name.Replace(LogDatabase.ConnectionStringPrefix, string.Empty), Value = css.Name, })); return(View("Index", model)); }
public ActionResult Index() { var model = new HomeIndexModel(); var profiler = MiniProfiler.Current; using (profiler.Step("Getting logs from database")) using (var sqlConn = CreateProfiledDbConnection()) { model.Logs.AddRange(sqlConn.Query <Log>("SELECT TOP 100 * FROM Log ORDER BY Id DESC")); } model.SelectedLogDatabase = GetSelectedConnectionStringName(); model.LogDatabases.AddRange(LogDatabaseConnectionStrings.Select(css => new SelectListItem { Text = css.Name.Replace(LogDatabase.ConnectionStringPrefix, string.Empty), Value = css.Name })); return(View(model)); }
public async Task <ActionResult> Index() { var model = new HomeIndexModel(); using (MiniProfiler.Current.Step("Getting logs from database")) using (var conn = CreateProfiledDbConnection()) { model.Logs.AddRange( await conn .QueryAsync <Log>(DapperQueries.GetTop100Logs) ); } model.SelectedLogDatabase = GetSelectedConnectionStringName(); var dbConnStrings = LogDatabaseConnectionStrings .Select(css => new SelectListItem { Text = css.Name.ToFriendlyLogDatabaseName(), Value = css.Name }); model.LogDatabases.AddRange(dbConnStrings); return(View(model)); }