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