public void CreateHostTest() { DataLayerBase target = DataLayerFactory.Instance.GetDataLayer(DataLayerType.SqlServer); string hostName = "LG"; target.CreateHost(hostName); string filePath = @"c:\LG\chamame.mp3"; string album = "Chamame"; string artist = "Tarrago Ross"; string title = "Curuzu Cuatia"; int year = 1966; string genre = "Folklore"; target.CreateOrUpdateMusicTrack(hostName, filePath, album, artist, title, year, genre); int totalHostCount = 0; if (target.GetAllHosts() != null) { totalHostCount = target.GetAllHosts().Rows.Count; } Assert.AreEqual(2, totalHostCount, "It should be 2 Host on the database."); }
public void CreateOrUpdateMusicTrackTest() { DataLayerBase target = DataLayerFactory.Instance.GetDataLayer(DataLayerType.SqlServer); string hostName = "Frostmourne"; target.CreateHost(hostName); string filePath = @"c:\Music\chamame.mp3"; string album = "Chamame"; string artist = "Tarrago Ross"; string title = "Curuzu Cuatia"; int year = 1966; string genre = "Folklore"; target.CreateOrUpdateMusicTrack(hostName, filePath, album, artist, title, year, genre); filePath = @"c:\Music\coco.mp3"; album = "Greatest Hits"; artist = "Roxette"; title = "Dangerous"; year = 2004; genre = "Rock"; target.CreateOrUpdateMusicTrack(hostName, filePath, album, artist, title, year, genre); filePath = @"c:\Music\Arjona\pinguinos en la cama.mp3"; album = "Arjona"; artist = "Ricardo Arjona"; title = "Pinguinos en la cama"; year = 2005; genre = "Melódico"; target.CreateOrUpdateMusicTrack(hostName, filePath, album, artist, title, year, genre); DataTable dt = target.Search(album, artist, title, year, genre); Assert.AreEqual(1, dt.Rows.Count, "Music Track creation fail."); if (dt.Rows.Count > 0) { Guid musicTrackId = new Guid(dt.Rows[0][DBConstants.MusicTrackId].ToString()); DataRow dr = target.GetMusicTrack(musicTrackId); if (dr != null) { Assert.AreEqual(artist, dr[DBConstants.Artist].ToString(), "GetMusicTrack fail."); } } }