public async Task <ActionResult> Get([FromServices] MusicRepository repository) { try { return(Ok(await repository.GetMusicsAsync())); } catch (Exception ex) { return(StatusCode(StatusCodes.Status500InternalServerError, new { message = ex.Message })); } }
public async Task <ActionResult> Import( [FromServices] DataContext context, [FromServices] MusicRepository repository ) { try { using (var con = new MySqlConnection("Server= mysql.saidata.net.br; Database= saidata01; Uid= saidata01; Pwd= Pttsq6adj;")) { con.Open(); var cmd = new MySqlCommand(); cmd.Connection = con; cmd.CommandText = @"SELECT `Musicas`.`Id`, `Musicas`.`Titulo`, `Musicas`.`Lembrete`, `Musicas`.`Interprete`, `Musicas`.`Letra`, `Musicas`.`Cifra`, `Musicas`.`Video`, `Musicas`.`Tocamos` FROM `saidata01`.`Musicas`"; var rdr = cmd.ExecuteReader(); while (rdr.Read()) { var music = new Music(rdr.GetString(1), rdr.GetString(2), rdr.GetString(3), rdr.GetString(4), rdr.GetString(5), rdr.GetString(6), rdr.GetBoolean(7)); music.Id = rdr.GetInt32(0); repository.Add(music); await context.SaveChangesAsync(); } cmd.Dispose(); } return(Ok(await repository.GetMusicsAsync())); } catch (Exception ex) { return(StatusCode(StatusCodes.Status500InternalServerError, new { message = ex.Message })); } }