public ActionResult PostSearchBlabs(string searchText) { if (IsUserLoggedIn() == false) { return(RedirectToLogin(HttpContext.Request.RawUrl)); } if (searchText == "error") { throw new Exception(); } var searchBlabslist = new List <BlabSearchResultViewModel>(); using (var dbContext = new BlabberDB()) { dbContext.Database.Connection.Open(); var searchBlabs = dbContext.Database.Connection.CreateCommand(); searchBlabs.CommandText = sqlSearchBlabs; var parm = searchBlabs.CreateParameter(); parm.ParameterName = "search"; parm.Value = searchText; searchBlabs.Parameters.Add(parm); var searchBlabsResults = searchBlabs.ExecuteReader(); while (searchBlabsResults.Read()) { var post = new BlabSearchResultViewModel { Blabber = searchBlabsResults.GetString(0), Content = searchBlabsResults.GetString(1), BlabDate = searchBlabsResults.GetDateTime(2), }; searchBlabslist.Add(post); } } var model = new SearchBlabsViewModel { Blabs = searchBlabslist, SearchText = searchText }; return(View("SearchBlabs", model)); }
public ActionResult PostSearchBlabs(string searchText) { if (IsUserLoggedIn() == false) { return(RedirectToLogin(HttpContext.Request.RawUrl)); } var searchBlabslist = new List <BlabSearchResultViewModel>(); using (var dbContext = new BlabberDB()) { dbContext.Database.Connection.Open(); var searchBlabs = (SqlCommand)dbContext.Database.Connection.CreateCommand(); searchBlabs.CommandText = sqlSearchBlabs; searchBlabs.Parameters.AddWithValue("@keywords", $"%{searchText}%"); var searchBlabsResults = searchBlabs.ExecuteReader(); while (searchBlabsResults.Read()) { var post = new BlabSearchResultViewModel { Blabber = searchBlabsResults.GetString(0), Content = searchBlabsResults.GetString(1), BlabDate = searchBlabsResults.GetDateTime(2), }; searchBlabslist.Add(post); } } var model = new SearchBlabsViewModel { Blabs = searchBlabslist, SearchText = searchText }; return(View("SearchBlabs", model)); }
public ActionResult PostSearchBlabs(string searchText) { if (IsUserLoggedIn() == false) { return(RedirectToLogin(Request.QueryString.Value)); } var searchBlabslist = new List <BlabSearchResultViewModel>(); using (var dbContext = new ApplicationDbContext()) { dbContext.Database.Connection.Open(); var searchBlabs = dbContext.Database.Connection.CreateCommand(); searchBlabs.CommandText = string.Format(sqlSearchBlabs, searchText); var searchBlabsResults = searchBlabs.ExecuteReader(); while (searchBlabsResults.Read()) { var post = new BlabSearchResultViewModel { Blabber = searchBlabsResults.GetString(0), Content = searchBlabsResults.GetString(1), BlabDate = searchBlabsResults.GetDateTime(2), }; searchBlabslist.Add(post); } } var model = new SearchBlabsViewModel { Blabs = searchBlabslist, SearchText = searchText }; return(View("SearchBlabs", model)); }