public async Task <ViewResult> Search(MemberSreachViewModel model)
{
var members = repository.Search(model);
var paginatedList = await PaginatedList <Member> .CreateAsync(members, 1, 5);
return(View("List", paginatedList));
}
public IQueryable <Member> Search(MemberSreachViewModel model)
{
var query = "SELECT * FROM dbo.Members WHERE ";
if (model.Name != null)
{
query += "Name LIKE '%'+ @p0 +'%' AND ";
}
if (model.Position != null)
{
query += "Position = @p1 AND ";
}
query += "1 = 1";
return(applicationContext.Members.FromSql(query, model.Name, model.Position));
}
