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