public async Task <HttpResponseMessage> ObterVoos([FromBody] VooConsultaViewModel vooConsultaViewModel) { try { var ret = await _vooApp.ObterVoos(vooConsultaViewModel); return(CustomResponse(ret)); } catch (Exception ex) { return(CustomResponse(ex)); } }
public async Task <IEnumerable <VooListaViewModel> > ObterVoos(VooConsultaViewModel vooConsultaViewModel) { List <VooListaViewModel> listaVoos = new List <VooListaViewModel>(); using (var _command = _contexto.ObterCommand()) { _command.CommandType = System.Data.CommandType.Text; _command.CommandText = $@" SELECT AERO.NOME AS AERONOME, AER.MATRICULA AS AERMATRICULA, AERD.NOME AS AERDNOME, V.ID AS VID, V.DataAgendamentoVoo as VDataAgendamentoVoo , V.TempoVooPrevisto AS VTempoVooPrevisto, V.TempoVooEfetivado AS VTempoVooEfetivado FROM VOO AS V JOIN AEROPORTO AERD ON AERD.ID = V.AeroportoDestinoId JOIN AEROPORTO AERO ON AERO.ID = V.AeroportoOrigemId JOIN AERONAVE AER ON AER.ID = V.AeronaveId WHERE 1=1 AND V.ATIVO = @VATIVO "; var parAtivo = _command.CreateParameter(); parAtivo.ParameterName = "@VATIVO"; parAtivo.Value = vooConsultaViewModel.Ativo.ToDataBaseBoolean(false); _command.Parameters.Add(parAtivo); if (!string.IsNullOrEmpty(vooConsultaViewModel.AeronaveNome)) { _command.CommandText += @" AND AER.MATRICULA LIKE @MATRICULA "; _command.Parameters.Add(_contexto.ObterParametro(_command, "@MATRICULA", "%" + vooConsultaViewModel.AeronaveNome + "%")); } await _contexto.ExecReaderAsync(_command, (datareader) => { if (datareader.HasRows) { while (datareader.Read()) { var voo = new VooListaViewModel { VooId = datareader["VID"].ToString(), DescricaoVoo = $" AERONAVE - {datareader["AERMATRICULA"]} SAIU - {datareader["AERONOME"]} DEST - {datareader["AERDNOME"]} AS {datareader["VDataAgendamentoVoo"]} ", Aeronave = datareader["AERMATRICULA"].ToString(), AeroportoDestino = datareader["AERDNOME"].ToString(), AeroportoOrigem = datareader["AERONOME"].ToString(), TempoPrevisto = (datareader["VTempoVooPrevisto"] == null || datareader["VTempoVooPrevisto"] == DBNull.Value) ? "" : Convert.ToDateTime(datareader["VTempoVooPrevisto"]).ToString(), TempoEfetivado = (datareader["VTempoVooEfetivado"] == null || datareader["VTempoVooEfetivado"] == DBNull.Value) ? "" : Convert.ToDateTime(datareader["VTempoVooEfetivado"]).ToString(), DataVoo = (datareader["VDataAgendamentoVoo"] == null || datareader["VDataAgendamentoVoo"] == DBNull.Value) ? "" : Convert.ToDateTime(datareader["VDataAgendamentoVoo"]).ToString() }; listaVoos.Add(voo); } } }); } return(listaVoos); }
public Task <IEnumerable <VooListaViewModel> > ObterVoos(VooConsultaViewModel vooConsultaViewModel) { return(_vooRepository.ObterVoos(vooConsultaViewModel)); }