public IEnumerable <Company> GetAll() { IQuery query = new GetAllCompanyQuery(); List <Company> res = new List <Company>(); try { using (var connection = new SqlConnection(connectionString)) { //reducing into one object connection.Query <Company, AdressOfDepartment, Company>( query.Sql, (company, adress) => { int index = 0; if (!res.Contains(company)) { res.Add(company); index = res.Count - 1; } else { index = res.IndexOf(company); } res[index].AddAdress(adress); return(company); }, splitOn: "ID"); } } catch (Exception e) { return(null); } return(res); }
public async Task <IActionResult> GetAll([FromQuery] GetAllCompanyQuery query) { return(Ok(await _mediator.Send(query))); }