public async Task <ActionResult <Music> > Post(
[FromServices] MusicRepository repository,
[FromServices] DataContext context,
[FromBody] AddMusicCommand command)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var music = new Music(
command.Title.Trim(),
command.Reminder.Trim(),
command.Singer.Trim(),
command.Lirycs,
command.Notation,
command.Video,
command.Play);
repository.Add(music);
await context.SaveChangesAsync();
return(Ok(new { music }));
}
catch (Exception)
{
return(StatusCode(StatusCodes.Status500InternalServerError,
new { message = ErrorMessage.Internal }));
}
}
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 }));
}
}
private async Task <RequestEngineResult> AddAlbumRequest(AlbumRequest model)
{
await MusicRepository.Add(model);
var result = await RunSpecificRule(model, SpecificRules.CanSendNotification);
if (result.Success)
{
NotificationHelper.NewRequest(model);
}
await _requestLog.Add(new RequestLog
{
UserId = (await GetUser()).Id,
RequestDate = DateTime.UtcNow,
RequestId = model.Id,
RequestType = RequestType.Album,
});
return(new RequestEngineResult {
Result = true, Message = $"{model.Title} has been successfully added!", RequestId = model.Id
});
}