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