public async Task <IActionResult> Constituents([FromBody] ConstituentSearchRequest searchFilter)
{
var result = new ConstituentSearchResponse();
result.Data = new List <ConstituentSearchRecord>();
result.Data = await _constituentRepository.Search(searchFilter);
/*foreach(Constituent c in list)
* {
* var record = new ConstituentSearchRecord()
* {
* Address = c.Address1,
* Name = c.FirstName + ' ' + c.LastName,
* Id = c.ConstituentId,
* City = "",
* Phone = "",
* PostalCode = c.PostalCode,
* State = c.StateCd
* };
* result.Records.Add(record);
* }*/
return(Ok(result));
}
public async Task <List <ConstituentSearchRecord> > Search(ConstituentSearchRequest request)
{
var query = from u in _context.ConstituentSearchRecords
select u;
if (!String.IsNullOrEmpty(request.Address))
{
query = query.Where(u => u.Address.StartsWith(request.Address));
}
if (!String.IsNullOrEmpty(request.LastName))
{
query = query.Where(u => u.LastName.StartsWith(request.LastName));
}
if (!String.IsNullOrEmpty(request.FirstName))
{
query = query.Where(u => u.FirstName.StartsWith(request.FirstName));
}
return(await query.ToListAsync());
}
