public IHttpActionResult UpdateMusica(int id, DTOMusica musica)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != musica.idMusica)
{
return(BadRequest());
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
DTOBaseResponse response = new DTOBaseResponse();
try
{
BusinessLogic.Controllers.MusicaController controller = new BusinessLogic.Controllers.MusicaController();
controller.UpdateMusica(id, musica);
response.Success = true;
}
catch (Exception ex)
{
response.Success = false;
response.Error = ex.ToString();
}
return(Ok(response));
}
public DTOMusica GetMusica(int id)
{
using (UnitOfWork uow = new UnitOfWork())
{
var entity = uow.MusicaRepository.Get(id);
if (entity == null)
{
return(null);
}
DTOMusica musica = _mapper.MapToDTO(entity);
return(musica);
}
}
public Musica MapFromDTO(DTOMusica dto)
{
if (dto == null)
{
return(null);
}
Musica musica = new Musica()
{
urlMusica = dto.urlMusica,
tituloMusica = dto.tituloMusica
};
return(musica);
}
public void CreateMusica(DTOMusica musica)
{
try
{
using (UnitOfWork uow = new UnitOfWork())
{
uow.MusicaRepository.Create(_mapper.MapFromDTO(musica));
uow.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public DTOMusica MapToDTO(Musica musica)
{
if (musica == null)
{
return(null);
}
DTOMusica pMusica = new DTOMusica()
{
idMusica = musica.idMusica,
urlMusica = musica.urlMusica,
tituloMusica = musica.tituloMusica
};
return(pMusica);
}
public void UpdateMusica(int id, DTOMusica musica)
{
try
{
using (UnitOfWork uow = new UnitOfWork())
{
Musica entity = uow.MusicaRepository.Get(id);
entity.idMusica = musica.idMusica;
entity.urlMusica = musica.urlMusica;
entity.tituloMusica = musica.tituloMusica;
uow.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateSong(DTOMusica DTOMus)
{
string cmd = string.Format($@"UPDATE TBL_Musica SET nome = '{DTOMus.Nome}', nomeAutor = '{DTOMus.NomeAutor}', idGravadora = {DTOMus.IdGravadora}, idCD = {DTOMus.IdCD} WHERE idMusica = {DTOMus.IdMusica};");
DALBanco.ExecuteQuery(cmd);
}
public void DeleteSong(DTOMusica DTOMus)
{
string cmd = string.Format($@"DELETE from TBL_Musica where idMusica = {DTOMus.IdMusica};");
DALBanco.ExecuteQuery(cmd);
}
public void InsertSong(DTOMusica DTOMus)
{
string cmd = string.Format($@"INSERT INTO TBL_Musica VALUES(NULL,'{DTOMus.Nome}','{DTOMus.NomeAutor}','{DTOMus.IdGravadora}','{DTOMus.IdCD}');");
DALBanco.ExecuteQuery(cmd);
}
