public IPagedList <Agent> SearchAgent(AgentSearchCriteria searchCriteria, PagingFilter pagingFilter)
{
var query = this.SearchAgent(searchCriteria);
var result = new PagedList <Agent>(query, pagingFilter.PageIndex, pagingFilter.PageSize);
return(result);
}
public static async Task <List <AgentListItemModel> > SearchAgent(AgentSearchCriteria searchCriteria)
{
var agents =
await WebServiceUtils.Get <List <AgentListItemModel> >("/api/agent/search/with-filter", prams : searchCriteria);
return(agents);
}
public List <AgentListItemModel> SearchWithFilter([FromUri] AgentSearchCriteria searchCriteria)
{
var queryResult = _agentLogic.SearchAgent(searchCriteria);
var mappedResult = Mapper.Map <List <AgentListItemModel> >(queryResult);
return(mappedResult);
}
public IList <AgentListItemModel> SearchWithFilter([FromUri] AgentSearchCriteria searchCriteria,
[FromUri] PagingFilter pagingFilter)
{
if (searchCriteria == null || pagingFilter == null)
{
return(new PagedList <AgentListItemModel>(new List <AgentListItemModel>(), 0, 0));
}
var queryResult = _agentLogic.SearchAgent(searchCriteria, pagingFilter);
var mappedResult = queryResult.ToModelList <Agent, AgentListItemModel>();
return(mappedResult);
}
private async void btnSearch_Click(object sender, EventArgs e)
{
var searchCriteria = new AgentSearchCriteria()
{
Id = txtId.Text,
Name = txtName.Text,
Province = txtProvince.Text,
District = txtDistrict.Text,
IsActive = checkBox1.Checked
};
var agent = await AgentLogic.SearchAgent(searchCriteria);
var tableSource = agent.ToDataTable();
gridAgent.DataSource = tableSource;
}
public IList <Agent> SearchAgent(AgentSearchCriteria searchCriteria)
{
var query = _agentRepository.TableNoTracking.IncludeTable(c => c.District).IncludeTable(c => c.Province);
if (!string.IsNullOrEmpty(searchCriteria.Id))
{
query = query.Where(c => c.AgentId.ToString() == searchCriteria.Id);
}
if (!string.IsNullOrEmpty(searchCriteria.Name))
{
query = query.Where(c => c.AgentName == searchCriteria.Name);
}
if (!string.IsNullOrEmpty(searchCriteria.District))
{
query =
query.Where(
c =>
c.District.DistrictName.Contains(searchCriteria.District) ||
c.District.DistrictId.ToString() == searchCriteria.District);
}
if (!string.IsNullOrEmpty(searchCriteria.Province))
{
query =
query.Where(
c =>
c.Province.ProvinceName.Contains(searchCriteria.Province) ||
c.Province.ProvinceId.ToString() == searchCriteria.Province);
}
if (searchCriteria.IsActive.HasValue)
{
query = query.Where(c => c.IsActive == searchCriteria.IsActive.Value);
}
return(query.ToList());
}
