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