public async Task <IActionResult> GetById(int id)
{
try
{
var firma = await _dapperFirmaService.QueryFirstAsync($"SELECT * FROM Firma WHERE FirmaID = {id}");
var araba = (await _dapperArabaService.QueryAsync($"SELECT * FROM Araba WHERE FirmaID = {firma.FirmaID}")).ToList();
firma.Arabas = araba;
return(Ok(firma));
}
catch (Exception ex)
{
return(NotFound(ex.Message));
}
}
public async Task <IActionResult> GetById(int id)
{
try
{
var kiralama = await _dapperKiralamaService.QueryFirstAsync($"SELECT * FROM Kiralama WHERE KiralamaID = {id}");
var alici = (await _dapperAliciService.QueryAsync($"SELECT * FROM Alici WHERE AliciID = {kiralama.AliciID}")).ToList();
kiralama.Alicis = alici;
var araba = (await _dapperArabaService.QueryAsync($"SELECT * FROM Araba WHERE ArabaID = {kiralama.ArabaID}")).ToList();
kiralama.Arabas = araba;
return(Ok(kiralama));
}
catch (Exception ex)
{
return(NotFound(ex.Message));
}
}
