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