public async Task <ActionResult> SearchAsync(string searchText)
{
var query = new FindUsersBySearchTextQuery {
SearchText = searchText, IncludeInactiveUsers = true
};
var users = await asyncHandler.Handle(query);
return(View(users));
}
public ActionResult Search(string searchText)
{
var query = new FindUsersBySearchTextQuery
{
SearchText = searchText,
IncludeInactiveUsers = true
};
return(View(handler.Handle(query)));
}
public View SearchUsers(string searchString)
{
var query = new FindUsersBySearchTextQuery
{
SearchText = searchString,
IncludeInactiveUsers = false
};
User[] users = this.handler.Handle(query);
return(this.View(users));
}
public async Task <IEnumerable <User> > Handle(FindUsersBySearchTextQuery query)
{
using (var con = factory.CreateConnection())
{
var sql = "SELECT * FROM Users WHERE Name LIKE '%' + @Name + '%'";
if (!query.IncludeInactiveUsers)
{
sql += " AND Active = 1";
}
return(await con.QueryAsync <User>(sql, new { Name = query.SearchText }));
}
}
public View SearchUsers(string searchString)
{
var query = new FindUsersBySearchTextQuery
{
SearchText = searchString
};
// Note how we omit the generic type argument,
// but still have type safety.
User[] users = this.queryProcessor.Execute(query);
return(this.View(users));
}
public async Task <User[]> Handle(FindUsersBySearchTextQuery query)
{
// ...
}
