// GET: Musicas
public ActionResult Index()
{
AlbumDao albumDao = new AlbumDao();
ViewBag.Album = new SelectList(albumDao.BuscarTodos(), "AlbumId", "Titulo");
return(View());
}
public int SetAlbum(Album album)
{
if (album == null)
{
return(-1);
}
if (album.PublishDate != null)
{
if (album.PublishYear <= 1900)
{
album.PublishYear = album.PublishDate.Year;
}
if (album.PublishMonth <= 0 || album.PublishMonth > 12)
{
album.PublishMonth = album.PublishDate.Month;
}
}
if (album.PublishMonth <= 0)
{
album.PublishMonth = 1;
}
return(AlbumDao.SetAlbum(album));
}
public ActionResult Adicionar(int id)
{
//Pega o genero
GeneroDao gDao = new GeneroDao();
//pega o tipo da midia
TipoMidiaDao mDao = new TipoMidiaDao();
//pega o album
AlbumDao albumDao = new AlbumDao();
//Busca o album selecionado na listagem
var album = albumDao.BuscarPorId(id);
ViewBag.IdAlbum = album.AlbumId;
ViewBag.TituloAlbum = album.Titulo;
var faixa = new Faixa();
//Atribui o id do album a uma FK da Faixa
faixa.AlbumId = album.AlbumId;
ViewBag.GeneroID = new SelectList(gDao.BuscarTodos(), "GeneroID", "Nome");
ViewBag.TipoMidiaId = new SelectList(mDao.BuscarTodos(), "TipoMidiaId", "Nome");
return(View(faixa));
}
public void DeleteAlbumIdEqualZeroTest()
{
AlbumDao dal = new AlbumDao();
Response <int> expected = new Response <int>(false, "Id must be grater than 0", -1);
Response <int> actual = dal.Delete(0);
Assert.AreEqual(expected.Status, actual.Status);
Assert.AreEqual(expected.Message, actual.Message);
Assert.AreEqual(expected.Data, actual.Data);
}
public void UpdateNullAlbumTest()
{
AlbumDao dal = new AlbumDao();
AlbumDto album = null;
Response <int> expected = new Response <int>(false, "Album to update cannot be null", -1);
Response <int> actual = dal.Update(album);
Assert.AreEqual(expected.Status, actual.Status);
Assert.AreEqual(expected.Message, actual.Message);
Assert.AreEqual(expected.Data, actual.Data);
}
public void InsertNullAlbumTest()
{
AlbumDto albumToInsert = null;
AlbumDao dal = new AlbumDao();
Response <int> expected = new Response <int>(false, "Album cannot be null", -1);
Response <int> actual = dal.Insert(albumToInsert);
Assert.AreEqual(expected.Status, actual.Status);
Assert.AreEqual(expected.Message, actual.Message);
Assert.AreEqual(expected.Data, actual.Data);
}
public void DeleteTest()
{
AlbumDao dal = new AlbumDao();
AlbumDto album = dal.SelectAll().Data.First(e => e.Name == "xyz album de prueba");
Response <int> expected = new Response <int>(true, "Album was delete from DB", album.Id);
Response <int> actual = dal.Delete(album.Id);
Assert.AreEqual(expected.Status, actual.Status);
Assert.AreEqual(expected.Message, actual.Message);
Assert.AreEqual(expected.Data, actual.Data);
}
public void DeleteAlbumIdIsNotInTheDatabaseTest()
{
AlbumDao dal = new AlbumDao();
Response <int> expected = new Response <int>(false, "Somethig was wrong. Exception: ", -1);
Response <int> actual = dal.Delete(300000);
bool IsRightMessage = actual.Message.StartsWith(expected.Message);
Assert.AreEqual(expected.Status, actual.Status);
Assert.AreEqual(expected.Data, actual.Data);
Assert.AreEqual(true, IsRightMessage);
}
public int SetImage(Image image)
{
if (image.PublishDate == null)
{
if (image.AddDate != null)
{
image.PublishDate = image.AddDate;
}
else
{
image.PublishDate = DateTime.Now;
}
}
return(AlbumDao.SetImage(image));
}
public void UpdateAlbumThatIsNotInTheDatabaseTest()
{
AlbumDao dal = new AlbumDao();
AlbumDto album = new AlbumDto()
{
Id = 8000,
Name = "No existe",
Released = 1900
};
Response <int> expected = new Response <int>(false, "Album to update isn't in the database", -1);
Response <int> actual = dal.Update(album);
Assert.AreEqual(expected.Status, actual.Status);
Assert.AreEqual(expected.Message, actual.Message);
Assert.AreEqual(expected.Data, actual.Data);
}
public void InsertAlbumWithNullNameTest()
{
AlbumDto albumToInsert = new AlbumDto()
{
Name = null,
Released = 2019
};
AlbumDao dal = new AlbumDao();
Response <int> expected = new Response <int>(false, "Somethig was wrong. Exception: ", -1);
Response <int> actual = dal.Insert(albumToInsert);
bool IsRightMessage = actual.Message.StartsWith(actual.Message);
Assert.AreEqual(expected.Status, actual.Status);
Assert.AreEqual(expected.Data, actual.Data);
Assert.AreEqual(true, IsRightMessage);
}
public void InsertTest()
{
AlbumDto albumToInsert = new AlbumDto()
{
Name = "xyz album de prueba",
Released = 2019
};
AlbumDao dal = new AlbumDao();
Response <int> expected = new Response <int>(true, "Album was inserted in DB", 0);
Response <int> actual = dal.Insert(albumToInsert);
Console.WriteLine(actual.Data);
Assert.AreEqual(expected.Status, actual.Status);
Assert.AreEqual(expected.Message, actual.Message);
Assert.AreNotEqual(-1, actual.Data);
}
public void CreateTest()
{
SongManager songMng = new SongManager();
AlbumDao albumDao = new AlbumDao();
ArtistDao artistDao = new ArtistDao();
Album album = albumDao.SelectAll().First();
Artist artist = artistDao.SelectAll().First();
Song song = new Song()
{
title = "Canción de prueba",
genre = "genero de prueba",
fk_album_id = album.album_id,
fk_artist_id = artist.artist_id
};
var actual = songMng.Create(song);
var expected = true;
Console.WriteLine(actual.Message);
Assert.AreEqual(expected, actual.Status);
}
public Album GetAlbum(int albumId)
{
return(AlbumDao.GetAlbum(albumId));
}
public List <Album> GetPagedAlbums(PagingContext pager, PublishStatus publishStatus)
{
return(AlbumDao.GetPagedAlbums(pager, (int)publishStatus));
}
public Album GetAlbum(Album Album)
{
return(AlbumDao.GetAlbum(Album));
}
public void DeleteAlbum(int albumId)
{
AlbumDao.DeleteAlbum(albumId);
}
public List <Image> GetPagedImagesByPublishYearMonth(PagingContext pager, PublishStatus publishStatus
, DateTime sTime, DateTime eTime)
{
return(AlbumDao.GetPagedImagesByPublishYearMonth(pager, (int)publishStatus,
sTime, eTime));
}
public List <Image> GetPagedImagesByTag(PagingContext pager, PublishStatus publishStatus, int tagId)
{
return(AlbumDao.GetPagedImagesByTag(pager, (int)publishStatus,
tagId));
}
public List <Image> GetPagedImagesByAlbumId(PagingContext pager, int albumId, PublishStatus publishStatus)
{
return(AlbumDao.GetPagedImagesByAlbumId(pager, albumId, (int)publishStatus));
}
public List <Image> GetPagedImagesByBandId(PagingContext pager, PublishStatus publishStatus, int bandId)
{
return(AlbumDao.GetPagedImagesByBandId(pager, (int)publishStatus,
bandId));
}
public List <Image> GetImagesByAlbumId(int albumId, PublishStatus publishStatus)
{
return(AlbumDao.GetImagesByAlbumId(albumId, (int)publishStatus));
}
public Image GetImage(int imageId)
{
return(AlbumDao.GetImage(imageId));
}
public void DeleteImage(int imageId)
{
AlbumDao.DeleteImage(imageId);
}
public List <Album> GetAlbumsByArtist(Artist artist)
{
return(AlbumDao.GetAlbumsByArtist(artist));
}
public List <Album> GetPagedAlbumsByPublishYearMonth(PagingContext pager, PublishStatus publishStatus
, int pulishYear, int publishMonth)
{
return(AlbumDao.GetPagedAlbumsByPublishYearMonth(pager, (int)publishStatus,
pulishYear, publishMonth));
}
public List <Album> GetPagedAlbumsByTagAndBand(PagingContext pager, PublishStatus publishStatus, int tagId, int bandId)
{
return(AlbumDao.GetPagedAlbumsByTagAndBand(pager, (int)publishStatus,
tagId, bandId));
}
public void DeleteImagesByAlbumId(int albumId)
{
AlbumDao.DeleteImagesByAlbumId(albumId);
}