public async Task <IActionResult> Guardar(AeronaveViewModel entidad)
{
entidad.AeronaveTipo = await servicioaeronavetipo.Buscar(entidad.AeronaveTipo.Codigo);
if (string.IsNullOrEmpty(entidad.Id))
{
await servicio.Crear(entidad);
}
else
{
await servicio.Actualizar(entidad);
}
return(RedirectToAction("Lista"));
}
public async Task <IActionResult> Editar(string codigo)
{
ViewBag.ListaAeronaveTipo = (await servicioaeronavetipo.Listar()).Select(p => new SelectListItem()
{
Text = p.Descripcion,
Value = p.Codigo.ToString()
}).ToList();
AeronaveViewModel view = null;
if (string.IsNullOrEmpty(codigo))
{
view = new AeronaveViewModel();
}
else
{
view = await servicio.Buscar(codigo);
}
return(View(view));
}
public async Task <IEnumerable <AeronaveViewModel> > ObterAeronaves()
{
List <AeronaveViewModel> listaAeronaves = new List <AeronaveViewModel>();
using (var _command = _contexto.ObterCommand())
{
_command.CommandType = System.Data.CommandType.Text;
_command.CommandText = $@"
SELECT [Id]
,[Matricula]
,[Ativo]
FROM [Saipher].[dbo].[Aeronave]
WHERE 1=1
AND [Ativo] = 1
";
await _contexto.ExecReaderAsync(_command, (datareader) => {
if (datareader.HasRows)
{
while (datareader.Read())
{
var voo = new AeronaveViewModel
{
Id = datareader["Id"].ToString(),
Matricula = datareader["Matricula"].ToString()
};
listaAeronaves.Add(voo);
}
}
});
}
return(listaAeronaves);
}
public async Task Actualizar(AeronaveViewModel aeronave)
{
await PutAsync <AeronaveViewModel>("aeronave", aeronave).ConfigureAwait(false);
}
public async Task Crear(AeronaveViewModel aeronave)
{
await PostAsync <AeronaveViewModel>("aeronave", aeronave).ConfigureAwait(false);
}
