public DataTable putPilotos(PilotosDto dto, int id)
{
using (con = new SqlConnection(dbContext.ObtenerCadenaDbConexSQL(_config["config:urlConex"])))
{
try
{
tblResult = new DataTable();
con.Open();
if (con.State == ConnectionState.Open)
{
SqlDataAdapter cmd = new SqlDataAdapter(STORE_PROCEDURES.PUT_PILOTOS, con);
cmd.SelectCommand.CommandType = CommandType.StoredProcedure;
cmd.SelectCommand.Parameters.Add("@id", SqlDbType.Int).Value = id;
cmd.SelectCommand.Parameters.Add("@nombres", SqlDbType.VarChar).Value = dto.nombres;
cmd.SelectCommand.Parameters.Add("@apellidos", SqlDbType.VarChar).Value = dto.apellidos;
cmd.SelectCommand.Parameters.Add("@idAeronave", SqlDbType.Int).Value = dto.idAeronave;
cmd.SelectCommand.Parameters.Add("@estado", SqlDbType.Bit).Value = dto.estado;
cmd.Fill(tblResult);
cmd.Dispose();
}
}
catch (SqlException ex)
{
con.Close();
throw new InvalidOperationException("TAG: " + ex.Message + ex.ErrorCode + ex.Data, ex.InnerException);
}
catch (Exception)
{
throw new Exception();
}
con.Close();
return(tblResult);
}
}
public ResultDto putPilotos(PilotosDto dto, int id) => _repository.putPilotos(dto, id).AsResult();
public ResultDto putPilotos([FromBody] PilotosDto dto, int id)
{
return(_service.putPilotos(dto, id));
}
public ResultDto setPilotos(PilotosDto dto) => _repository.setPilotos(dto).AsResult();
public ResultDto setPilotos([FromBody] PilotosDto dto)
{
return(_service.setPilotos(dto));
}