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