public void TestGenreDelete()
{
using (var ctx = new CDCatalogEntities())
{
//Test init
Genre g = new Genre();
g.GenreID = 0; // auto incremented and set by add
g.GenreName = "Test Genre W6YderKT";
//add it to the context and save to database
ctx.Genres.Add(g);
ctx.SaveChanges();
//Find the list of "Test Genre"
//in case duplicates were added in the previous tests, delete them all
var list = ctx.Genres
.Where(n => n.GenreName.ToLower().Equals("test genre w6yderkt"))
.Where(n => n.GenreID > 1000);
ctx.Genres.RemoveRange(list);
int count = ctx.SaveChanges();
Assert.IsTrue(count > 0, "No Record Deleted");
//Test clean-up (none)
}
}
public void TestAlbumDelete()
{
using (var ctx = new CDCatalogEntities())
{
//Test init
Artist A = ctx.Artists.Where(n => n.ArtistName.ToLower().Equals("kaskade")).FirstOrDefault();
//Get a genre we know exists -- Electronic
Genre G = ctx.Genres.Where(n => n.GenreName.ToLower().Equals("electronic")).FirstOrDefault();
//create a test album
Album i = new Album();
i.AlbumID = 0; // autogenerated on add
i.AlbumYear = 2014;
i.ArtistID = A.ArtistID;
i.AlbumTitle = "The KqxKAW Test Album";
i.AlbumRating = 5;
i.GenreID = G.GenreID;
//add it to the context, then database
ctx.Albums.Add(i);
ctx.SaveChanges();
//find the list of "Testing Artists"
//in case duplicates were added in the previous tests, delete them all
var list = ctx.Albums
.Where(n => n.AlbumTitle.ToLower().Equals("the kqxkaw test album"));
ctx.Albums.RemoveRange(list);
int count = ctx.SaveChanges();
Assert.IsTrue(count > 0, "No Record Deleted");
//Test clean-up (none)
}
}
public void TestGenreAdd()
{
//create a new context
using (var ctx = new CDCatalogEntities())
{
//Test init
//Create a test genre
Genre g = new Genre();
g.GenreID = 0; // auto incremented and set by add
g.GenreName = "Test Genre W6YderKT";
//add it to the context
ctx.Genres.Add(g);
//verify that records were changed
int count = ctx.SaveChanges();
Assert.IsTrue(count > 0 && g.GenreID > 0, "No Records Changed");
//Test clean-up
if (count > 0)
{
var list = ctx.Genres
.Where(n => n.GenreName.ToLower().Equals("test genre w6yderkt"))
.Where(n => n.GenreID > 0);
ctx.Genres.RemoveRange(list);
ctx.SaveChanges();
}
}
}
public void TestArtistFetch()
{
using (var ctx = new CDCatalogEntities())
{
//Test init
Artist i = new Artist();
i.ArtistID = 0; // autogenerated on add
i.ArtistName = "Testing Artist 7yJLirjI";
//add it to the context and make changes in the database
ctx.Artists.Add(i);
ctx.SaveChanges();
//Find the test artist in the database
Artist a = ctx.Artists
.Where(n => n.ArtistName.ToLower().Equals("testing artist 7yjlirji"))
.FirstOrDefault();
Assert.IsTrue(a != null, "No Record Found");
//Test clean-up
if (a != null)
{
var list = ctx.Artists
.Where(n => n.ArtistName.ToLower().Equals("testing artist 7yjlirji"));
ctx.Artists.RemoveRange(list);
ctx.SaveChanges();
}
}
}
public void TestGenreAdd()
{
//create a new context
using (var ctx = new CDCatalogEntities())
{
//Test init
//Create a test genre
Genre g = new Genre();
g.GenreID = 0; // auto incremented and set by add
g.GenreName = "Test Genre W6YderKT";
//add it to the context
ctx.Genres.Add(g);
//verify that records were changed
int count = ctx.SaveChanges();
Assert.IsTrue(count > 0 && g.GenreID > 0, "No Records Changed");
//Test clean-up
if (count > 0)
{
var list = ctx.Genres
.Where(n => n.GenreName.ToLower().Equals("test genre w6yderkt"))
.Where(n => n.GenreID > 0);
ctx.Genres.RemoveRange(list);
ctx.SaveChanges();
}
}
}
public void TestGenreDelete()
{
using (var ctx = new CDCatalogEntities())
{
//Test init
Genre g = new Genre();
g.GenreID = 0; // auto incremented and set by add
g.GenreName = "Test Genre W6YderKT";
//add it to the context and save to database
ctx.Genres.Add(g);
ctx.SaveChanges();
//Find the list of "Test Genre"
//in case duplicates were added in the previous tests, delete them all
var list = ctx.Genres
.Where(n => n.GenreName.ToLower().Equals("test genre w6yderkt"))
.Where(n => n.GenreID > 1000);
ctx.Genres.RemoveRange(list);
int count = ctx.SaveChanges();
Assert.IsTrue(count > 0, "No Record Deleted");
//Test clean-up (none)
}
}
public void TestAlbumDelete()
{
using (var ctx = new CDCatalogEntities())
{
//Test init
Artist A = ctx.Artists.Where(n => n.ArtistName.ToLower().Equals("kaskade")).FirstOrDefault();
//Get a genre we know exists -- Electronic
Genre G = ctx.Genres.Where(n => n.GenreName.ToLower().Equals("electronic")).FirstOrDefault();
//create a test album
Album i = new Album();
i.AlbumID = 0; // autogenerated on add
i.AlbumYear = 2014;
i.ArtistID = A.ArtistID;
i.AlbumTitle = "The KqxKAW Test Album";
i.AlbumRating = 5;
i.GenreID = G.GenreID;
//add it to the context, then database
ctx.Albums.Add(i);
ctx.SaveChanges();
//find the list of "Testing Artists"
//in case duplicates were added in the previous tests, delete them all
var list = ctx.Albums
.Where(n => n.AlbumTitle.ToLower().Equals("the kqxkaw test album"));
ctx.Albums.RemoveRange(list);
int count = ctx.SaveChanges();
Assert.IsTrue(count > 0, "No Record Deleted");
//Test clean-up (none)
}
}
public void TestAlbumAdd()
{
using (var ctx = new CDCatalogEntities())
{
//Test init (none)
//Get an artist we know exists -- Kaskade
Artist A = ctx.Artists.Where(n => n.ArtistName.ToLower().Equals("kaskade")).FirstOrDefault();
//Get a genre we know exists -- Electronic
Genre G = ctx.Genres.Where(n => n.GenreName.ToLower().Equals("electronic")).FirstOrDefault();
//create a test album
Album m = new Album();
m.AlbumID = 0; // autogenerated on add
m.AlbumYear = 2014;
m.ArtistID = A.ArtistID;
m.AlbumTitle = "The KqxKAW Test Album";
m.AlbumRating = 5;
m.GenreID = G.GenreID;
//add it to the database
ctx.Albums.Add(m);
int count = ctx.SaveChanges();
Assert.IsTrue(count > 0 && m.AlbumID > 0, "No Record Added");
//Test clean-up
if (count > 0)
{
var list = ctx.Albums
.Where(n => n.AlbumTitle.ToLower().Equals("the kqxkaw test album"));
ctx.Albums.RemoveRange(list);
ctx.SaveChanges();
}
}
}
public void TestAlbumAdd()
{
using (var ctx = new CDCatalogEntities())
{
//Test init (none)
//Get an artist we know exists -- Kaskade
Artist A = ctx.Artists.Where(n => n.ArtistName.ToLower().Equals("kaskade")).FirstOrDefault();
//Get a genre we know exists -- Electronic
Genre G = ctx.Genres.Where(n => n.GenreName.ToLower().Equals("electronic")).FirstOrDefault();
//create a test album
Album m = new Album();
m.AlbumID = 0; // autogenerated on add
m.AlbumYear = 2014;
m.ArtistID = A.ArtistID;
m.AlbumTitle = "The KqxKAW Test Album";
m.AlbumRating = 5;
m.GenreID = G.GenreID;
//add it to the database
ctx.Albums.Add(m);
int count = ctx.SaveChanges();
Assert.IsTrue(count > 0 && m.AlbumID > 0, "No Record Added");
//Test clean-up
if (count > 0)
{
var list = ctx.Albums
.Where(n => n.AlbumTitle.ToLower().Equals("the kqxkaw test album"));
ctx.Albums.RemoveRange(list);
ctx.SaveChanges();
}
}
}
public void TestGenreFetch()
{
using (var ctx = new CDCatalogEntities())
{
//Test init
Genre i = new Genre();
i.GenreID = 0; // auto incremented and set by add
i.GenreName = "Test Genre W6YderKT";
//add it to the context and save to database
ctx.Genres.Add(i);
ctx.SaveChanges();
//Find the test genre in the database
Genre g = ctx.Genres.Where(n => n.GenreName.ToLower().Equals("test genre w6yderkt")).FirstOrDefault();
Assert.IsTrue(g != null, "No Record Found");
//Test clean-up
if (g != null)
{
var list = ctx.Genres
.Where(n => n.GenreName.ToLower().Equals("test genre w6yderkt"))
.Where(n => n.GenreID > 0);
ctx.Genres.RemoveRange(list);
ctx.SaveChanges();
}
}
}
public void TestArtistAdd()
{
using (var ctx = new CDCatalogEntities())
{
//Test init (none)
//Create a test artist
Artist a = new Artist();
a.ArtistID = 0; // autogenerated on add
a.ArtistName = "Testing Artist 7yJLirjI";
//add it to the context
ctx.Artists.Add(a);
//verify that .. records were changed
int count = ctx.SaveChanges();
Assert.IsTrue(count > 0 && a.ArtistID > 0, "No Records Changed");
//Test clean-up
if (count > 0)
{
var list = ctx.Artists
.Where(n => n.ArtistName.ToLower().Equals("testing artist 7yjlirji"));
ctx.Artists.RemoveRange(list);
ctx.SaveChanges();
}
}
}
/// <summary>
///
/// </summary>
/// <param name="title"></param>
/// <param name="artistId"></param>
/// <param name="albumId"></param>
/// <param name="trackNumber"></param>
/// <param name="songRating"></param>
/// <param name="trackLength"></param>
/// <param name="genreId"></param>
/// <returns></returns>
public static bool UpdateSong(int songId, string title, int artistId, int albumId, int trackNumber, int songRating, int trackLength, int genreId)
{
var song = new CDCatalogEF.Song();
try
{
song.SongTitle = title;
song.ArtistID = artistId;
song.AlbumID = albumId;
song.SongTrackNumber = trackNumber;
song.SongRating = songRating;
song.SongTrackLength = trackLength;
song.GenreID = genreId;
using (var db = new CDCatalogEntities())
{
db.Songs.First(i => i.SongID == songId);
int resultCount = db.SaveChanges();
return(true); // Executes only if no exception
}
}
catch (Exception ex)
{
// Define a new top-level error message.
string str = "Adding the Song failed. " + ex.Message;
// Pop-up a messagebox with the message
MessageBox.Show(str);
}
return(false);
}
public static int AddArtist(string artistName)
{
var artist = new CDCatalogEF.Artist();
try
{
artist.ArtistName = artistName;
using (var db = new CDCatalogEntities())
{
db.Artists.Add(artist); //faults here
var resultCount = db.SaveChanges();
}
}
catch (Exception ex)
{
// Define a new top-level error message.
string str = "Adding the Artist by Name failed. " + ex.Message;
// Pop-up a messagebox with the message
MessageBox.Show(str);
}
var artistId = artist.ArtistID;
return(artistId);
}
/// <summary>
///
/// </summary>
/// <param name="albumId"></param>
/// <param name="albumYear"></param>
/// <param name="artistId"></param>
/// <param name="albumTitle"></param>
/// <param name="albumRating"></param>
/// <param name="genreId"></param>
/// <returns></returns>
public static bool ChangeAlbum(int albumId, int albumYear, int artistId, string albumTitle, int albumRating, int genreId)
{
var album = new CDCatalogEF.Album();
try
{
album.AlbumID = albumId;
album.AlbumYear = albumYear;
album.ArtistID = artistId;
album.AlbumTitle = albumTitle;
album.AlbumRating = albumRating;
album.GenreID = genreId;
using (var db = new CDCatalogEntities())
{
db.Albums.First(i => i.AlbumID == albumId);
int resultCount = db.SaveChanges();
return true; // if there is an exception, this won't run
}
}
catch (Exception ex)
{
// Define a new top-level error message.
string str = "Changing the Album failed. " + ex.Message;
// Pop-up a messagebox with the message
MessageBox.Show(str);
}
var songId = album.ArtistID; // The song.ArtistID gets updated in the context as its saved
return true;
}
/// <summary>
///
/// </summary>
/// <param name="albumYear"></param>
/// <param name="artistId"></param>
/// <param name="albumTitle"></param>
/// <param name="albumRating"></param>
/// <param name="genreId"></param>
/// <returns></returns>
public static int AddAlbum(int albumYear, int artistId, string albumTitle, int albumRating, int genreId)
{
var album = new CDCatalogEF.Album();
try
{
album.AlbumYear = albumYear;
album.ArtistID = artistId;
album.AlbumTitle = albumTitle;
album.AlbumRating = albumRating;
album.GenreID = genreId;
using (var db = new CDCatalogEntities())
{
db.Albums.Add(album);
var resultCount = db.SaveChanges();
}
}
catch (Exception ex)
{
// Define a new top-level error message.
string str = "Adding the Album failed. " + ex.Message;
// Pop-up a messagebox with the message
MessageBox.Show(str);
}
var songId = album.ArtistID; // The song.ArtistID gets updated in the context as its saved
return artistId;
}
public void TestSongDelete()
{
using (var ctx = new CDCatalogEntities())
{
//Test init
//Get an artist we know exists -- Avicii
Artist A = ctx.Artists.Where(n => n.ArtistName.ToLower().Equals("avicii")).FirstOrDefault();
//Get an album we know exists --
Album M = ctx.Albums.Where(n => n.AlbumTitle.ToLower().Equals("true")).FirstOrDefault();
//Get a genre we know exists -- Dance
Genre G = ctx.Genres.Where(n => n.GenreName.ToLower().Equals("dance")).FirstOrDefault();
Song s = new Song();
s.SongID = 0; // autogenerated on add
s.SongTitle = "Test Song GMwRYZ";
s.ArtistID = A.ArtistID;
s.AlbumID = M.AlbumID;
s.GenreID = G.GenreID;
s.SongTrackNumber = 15;
s.SongTrackLength = 350;
s.SongRating = 3;
//add it to the database
ctx.Songs.Add(s);
//find the list of "Test Song GMwRYZ"
//in case duplicates were added in the previous tests
var list = ctx.Songs
.Where(n => n.SongTitle.ToLower().Equals("test song gmwryz"));
ctx.Songs.RemoveRange(list);
int count = ctx.SaveChanges();
Assert.IsTrue(count > 0, "No Record Deleted");
//Test clean-up (none)
}
}
public static CDCatalogEF.Genre AddGenre(string genreName)
{
if (genreName == null)
{
// Define a new top-level error message.
string str = "You did not enter a Genre Name. Cancel this operation?";
// Pop-up a messagebox with the message
MessageBox.Show(str);
return(null);
}
var genre = new CDCatalogEF.Genre();
try
{
genre.GenreName = genreName;
using (var db = new CDCatalogEntities())
{
db.Genres.Add(genre);
var resultCount = db.SaveChanges();
}
}
catch (Exception ex)
{
// Define a new top-level error message.
string str = "Adding the Genre by Name failed. " + ex.Message;
// Pop-up a messagebox with the message
MessageBox.Show(str);
}
return(genre);
}
/// <summary>
///
/// </summary>
/// <param name="title"></param>
/// <param name="artistId"></param>
/// <param name="albumId"></param>
/// <param name="trackNumber"></param>
/// <param name="songRating"></param>
/// <param name="trackLength"></param>
/// <param name="genreId"></param>
/// <returns></returns>
public static int AddSong(string title, int artistId, int albumId, int trackNumber, int songRating, int trackLength, int genreId)
{
var song = new CDCatalogEF.Song();
try
{
song.SongTitle = title;
song.ArtistID = artistId;
song.AlbumID = albumId;
song.SongTrackNumber = trackNumber;
song.SongRating = songRating;
song.SongTrackLength = trackLength;
song.GenreID = genreId;
using (var db = new CDCatalogEntities())
{
db.Songs.Add(song);
var resultCount = db.SaveChanges();
}
}
catch (Exception ex)
{
// Define a new top-level error message.
string str = "Adding the Song failed. " + ex.Message;
// Pop-up a messagebox with the message
MessageBox.Show(str);
}
var songId = song.ArtistID; //The song.ArtistID gets updated in the context as its saved
return(songId);
}
/// <summary>
///
/// </summary>
/// <param name="albumId"></param>
/// <param name="albumYear"></param>
/// <param name="artistId"></param>
/// <param name="albumTitle"></param>
/// <param name="albumRating"></param>
/// <param name="genreId"></param>
/// <returns></returns>
public static bool ChangeAlbum(int albumId, int albumYear, int artistId, string albumTitle, int albumRating, int genreId)
{
var album = new CDCatalogEF.Album();
try
{
album.AlbumID = albumId;
album.AlbumYear = albumYear;
album.ArtistID = artistId;
album.AlbumTitle = albumTitle;
album.AlbumRating = albumRating;
album.GenreID = genreId;
using (var db = new CDCatalogEntities())
{
db.Albums.First(i => i.AlbumID == albumId);
int resultCount = db.SaveChanges();
return(true); // if there is an exception, this won't run
}
}
catch (Exception ex)
{
// Define a new top-level error message.
string str = "Changing the Album failed. " + ex.Message;
// Pop-up a messagebox with the message
MessageBox.Show(str);
}
var songId = album.ArtistID; // The song.ArtistID gets updated in the context as its saved
return(true);
}
/// <summary>
///
/// </summary>
/// <param name="albumYear"></param>
/// <param name="artistId"></param>
/// <param name="albumTitle"></param>
/// <param name="albumRating"></param>
/// <param name="genreId"></param>
/// <returns></returns>
public static int AddAlbum(int albumYear, int artistId, string albumTitle, int albumRating, int genreId)
{
var album = new CDCatalogEF.Album();
try
{
album.AlbumYear = albumYear;
album.ArtistID = artistId;
album.AlbumTitle = albumTitle;
album.AlbumRating = albumRating;
album.GenreID = genreId;
using (var db = new CDCatalogEntities())
{
db.Albums.Add(album);
var resultCount = db.SaveChanges();
}
}
catch (Exception ex)
{
// Define a new top-level error message.
string str = "Adding the Album failed. " + ex.Message;
// Pop-up a messagebox with the message
MessageBox.Show(str);
}
var songId = album.ArtistID; // The song.ArtistID gets updated in the context as its saved
return(artistId);
}
public static int AddArtist(string artistName)
{
var artist = new CDCatalogEF.Artist();
try
{
artist.ArtistName = artistName;
using (var db = new CDCatalogEntities())
{
db.Artists.Add(artist); //faults here
var resultCount = db.SaveChanges();
}
}
catch (Exception ex)
{
// Define a new top-level error message.
string str = "Adding the Artist by Name failed. " + ex.Message;
// Pop-up a messagebox with the message
MessageBox.Show(str);
}
var artistId = artist.ArtistID;
return artistId;
}
public void TestSongAdd()
{
//Test init (none)
//Add a song to the database
using (var ctx = new CDCatalogEntities())
{
//Get an artist we know exists -- Avicii
Artist A = ctx.Artists.Where(n => n.ArtistName.ToLower().Equals("avicii")).FirstOrDefault();
//Get an album we know exists --
Album M = ctx.Albums.Where(n => n.AlbumTitle.ToLower().Equals("true")).FirstOrDefault();
//Get a genre we know exists -- Dance
Genre G = ctx.Genres.Where(n => n.GenreName.ToLower().Equals("dance")).FirstOrDefault();
//Creat a new song and add it to the context
Song s = new Song();
s.SongID = 0; // autogenerated on add
s.SongTitle = "Test Song GMwRYZ";
s.ArtistID = A.ArtistID;
s.AlbumID = M.AlbumID;
s.GenreID = G.GenreID;
s.SongTrackNumber = 15;
s.SongTrackLength = 350;
s.SongRating = 3;
//add it to the database
ctx.Songs.Add(s);
//verify that only one record was changed
int count = ctx.SaveChanges();
Assert.IsTrue(count > 0 && s.SongID > 0, "No Records Added");
//Test clean-up
if (count > 0)
{
//find all the test songs
var list = ctx.Songs
.Where(n => n.SongTitle.ToLower().Equals("test song gmwryz"));
//Remove the songs from the context and database
ctx.Songs.RemoveRange(list);
ctx.SaveChanges();
}
}
}
public void TestSongAdd()
{
//Test init (none)
//Add a song to the database
using (var ctx = new CDCatalogEntities())
{
//Get an artist we know exists -- Avicii
Artist A = ctx.Artists.Where(n => n.ArtistName.ToLower().Equals("avicii")).FirstOrDefault();
//Get an album we know exists --
Album M = ctx.Albums.Where(n => n.AlbumTitle.ToLower().Equals("true")).FirstOrDefault();
//Get a genre we know exists -- Dance
Genre G = ctx.Genres.Where(n => n.GenreName.ToLower().Equals("dance")).FirstOrDefault();
//Creat a new song and add it to the context
Song s = new Song();
s.SongID = 0; // autogenerated on add
s.SongTitle = "Test Song GMwRYZ";
s.ArtistID = A.ArtistID;
s.AlbumID = M.AlbumID;
s.GenreID = G.GenreID;
s.SongTrackNumber = 15;
s.SongTrackLength = 350;
s.SongRating = 3;
//add it to the database
ctx.Songs.Add(s);
//verify that only one record was changed
int count = ctx.SaveChanges();
Assert.IsTrue(count > 0 && s.SongID > 0, "No Records Added");
//Test clean-up
if (count > 0)
{
//find all the test songs
var list = ctx.Songs
.Where(n => n.SongTitle.ToLower().Equals("test song gmwryz"));
//Remove the songs from the context and database
ctx.Songs.RemoveRange(list);
ctx.SaveChanges();
}
}
}
public Genre CreateGenre(string name)
{
using (CDCatalogEntities context = new CDCatalogEntities())
{
var genre = new Genre();
genre.GenreName = name;
context.Genres.Add(genre);
context.SaveChanges();
return genre;
}
}
public Artist CreateArtist(string artistName)
{
using (CDCatalogEntities context = new CDCatalogEntities())
{
var artist = new Artist();
artist.ArtistName = artistName;
context.Artists.Add(artist);
context.SaveChanges();
return artist;
}
}
private void button3_Click(object sender, EventArgs e)
{
using (CDCatalogEntities db = new CDCatalogEntities())
{
List <Song> songList = db.Songs.OrderBy(s => s.SongTitle).ToList();
foreach (Song s in songList)
{
s.TrackLength -= 300;
db.SaveChanges();
}
}
}
public void TestAlbumFetch()
{
using (var ctx = new CDCatalogEntities())
{
//Test init
//Get an artist we know exists -- Kaskade
Artist A = ctx.Artists.Where(n => n.ArtistName.ToLower().Equals("kaskade")).FirstOrDefault();
//Get a genre we know exists -- Electronic
Genre G = ctx.Genres.Where(n => n.GenreName.ToLower().Equals("electronic")).FirstOrDefault();
//create a test album
Album i = new Album();
i.AlbumID = 0; // autogenerated on add
i.AlbumYear = 2014;
i.ArtistID = A.ArtistID;
i.AlbumTitle = "The KqxKAW Test Album";
i.AlbumRating = 5;
i.GenreID = G.GenreID;
//add it to the context, then database
ctx.Albums.Add(i);
ctx.SaveChanges();
//Find the test album in the database
Album m = ctx.Albums
.Where(n => n.AlbumTitle.ToLower().Equals("the kqxkaw test album"))
.FirstOrDefault();
Assert.IsTrue(m != null, "No Record Found");
//Test clean-up
if (m != null)
{
var list = ctx.Albums
.Where(n => n.AlbumTitle.ToLower().Equals("the kqxkaw test album"));
ctx.Albums.RemoveRange(list);
int count = ctx.SaveChanges();
}
}
}
public Album CreateAlbum(string albumTitle, Artist albumArtist, int albumYear, int albumRating)
{
using (CDCatalogEntities context = new CDCatalogEntities())
{
var album = new Album();
album.Title = albumTitle;
album.Year = albumYear;
album.Rating = albumRating;
album.ArtistId = albumArtist.ArtistId;
context.Albums.Add(album);
context.SaveChanges();
return album;
}
}
public void TestArtistDelete()
{
using (var ctx = new CDCatalogEntities())
{
//Test init
Artist i = new Artist();
i.ArtistID = 0; // autogenerated on add
i.ArtistName = "Testing Artist 7yJLirjI";
//add it to the context and make changes in the database
ctx.Artists.Add(i);
ctx.SaveChanges();
//find the list of "Testing Artists"
//in case duplicates were added in the previous tests
var list = ctx.Artists
.Where(n => n.ArtistName.ToLower().Equals("testing artist 7yjlirji"));
ctx.Artists.RemoveRange(list);
int count = ctx.SaveChanges();
Assert.IsTrue(count > 0, "No Record Deleted");
//Test clean-up (none)
}
}
public Song CreateSong(string songTitle, Artist artist, Genre genre, int songLengthSeconds, int songRating, Album album = null, int albumTrackNumber = 0)
{
using (CDCatalogEntities context = new CDCatalogEntities())
{
var song = new Song();
song.Title = songTitle;
song.ArtistId = artist.ArtistId;
song.GenreId = genre.GenreId;
song.TrackLengthSeconds = songLengthSeconds;
song.Rating = songRating;
song.AlbumId = album?.AlbumId;
song.TrackNumber = albumTrackNumber;
context.Songs.Add(song);
context.SaveChanges();
return song;
}
}
public void TestSongFetch()
{
using (var ctx = new CDCatalogEntities())
{
//Test init
//Get an artist we know exists -- Avicii
Artist A = ctx.Artists.Where(n => n.ArtistName.ToLower().Equals("avicii")).FirstOrDefault();
//Get an album we know exists --
Album M = ctx.Albums.Where(n => n.AlbumTitle.ToLower().Equals("true")).FirstOrDefault();
//Get a genre we know exists -- Dance
Genre G = ctx.Genres.Where(n => n.GenreName.ToLower().Equals("dance")).FirstOrDefault();
//Build a context
Song i = new Song();
i.SongID = 0; // autogenerated on add
i.SongTitle = "Test Song GMwRYZ";
i.ArtistID = A.ArtistID;
i.AlbumID = M.AlbumID;
i.GenreID = G.GenreID;
i.SongTrackNumber = 15;
i.SongTrackLength = 300;
i.SongRating = 3;
//add it to the database
ctx.Songs.Add(i);
//find a the test song in the database
Song s = ctx.Songs.Where(n => n.SongTitle.ToLower().Equals("test song gmwryz")).FirstOrDefault();
Assert.IsTrue(s != null, "No Record Deleted");
//Test clean-up
if (s != null)
{
//find all the test songs in the context
var list = ctx.Songs
.Where(n => n.SongTitle.ToLower().Equals("test song gmwryz"));
//delete them from the context and database
ctx.Songs.RemoveRange(list);
ctx.SaveChanges();
}
}
}
public static int AddArtist(string artistName)
{
CDCatalogEF.Artist artist = new Artist();
try
{
artist.ArtistName = artistName;
using (var db = new CDCatalogEntities())
{
db.Artists.Add(artist);
int resultCount = db.SaveChanges();
}
}
catch (Exception ex)
{
string s = ex.Message;
}
int artistId = artist.ArtistID;
return(artistId);
}
private List <PlaylistSong> RandomPlaylist(List <Song> sourceList, int targetSeconds, Playlist playList)
{
///Algorithm needs to:
///1) Check playlist length against target--while totalLength less than or equal to targetSeconds + 60?
///
///2) Reduce available songs to those that will fit in the time.
///3) Add a song, add song length to totalLength
///
Random rand = new Random();
List <PlaylistSong> playlistSongList = new List <PlaylistSong>();
PlaylistSong newPLS = new PlaylistSong();
bool keepGoing = true;
bool isFull = false;
bool notEnoughSongs = false;
int iterator = 0;
int index = 0;
int songOrder = 1;
int totalLength = 0;
List <Song> songList = sourceList.OrderBy(s => s.SongID).ToList();
List <Song> filteredList = songList.Where(s => s.TrackLength <= ((targetSeconds + 60) - totalLength)).ToList();
List <Song> workingList = new List <Song>();
//checking the iterator keeps this from becoming an infinite loop,
//but all testing, even with fairly small datasets, has so far found
//a solution before the iterator iterates out.
while (iterator < 1000000000 && keepGoing == true)
{
while (totalLength <= (targetSeconds + 60) && isFull == false && notEnoughSongs == false)
{
//reduce the available songs to only those which will not exceed the specifid playlist length plus one minute.
filteredList = songList.Where(s => s.TrackLength <= ((targetSeconds + 60) - totalLength)).ToList();
if (filteredList.Count > 0) //If we're out of songs, we can't add any more to the playlist
{
index = rand.Next(0, filteredList.Count);
workingList.Add(songList[index]);
totalLength += songList[index].TrackLength;
songList.RemoveAt(index);
}
else
{
notEnoughSongs = true;
keepGoing = false;
}
if (totalLength >= (targetSeconds - 60))
{
isFull = true;
}
}
if (totalLength >= (targetSeconds - 60) && totalLength <= (targetSeconds + 60))
{
using (CDCatalogEntities db = new CDCatalogEntities())
{
songOrder = 1;
foreach (Song s in workingList)
{
newPLS = new PlaylistSong();
newPLS.PlaylistID = playList.PlaylistID;
newPLS.SongID = s.SongID;
newPLS.SongOrder = songOrder;
db.PlaylistSongs.Add(newPLS);
db.SaveChanges();
playlistSongList.Add(newPLS);
songOrder++;
}
}
keepGoing = false;
}
else
{
workingList.Clear();
totalLength = 0;
isFull = false;
songList = sourceList.OrderBy(s => s.SongID).ToList();
filteredList = songList.Where(s => s.TrackLength <= ((targetSeconds + 60) - totalLength)).ToList();
iterator++;
}
}
return(playlistSongList);
}
private void button1_Click(object sender, EventArgs e)
{
using (CDCatalogEntities db = new CDCatalogEntities())
{
Genre genre = db.Genres.Where(g => g.GenreName.Equals("Alternative")).First();
//Album album = db.Albums.Where(a => a.AlbumTitle.Equals("Ramones [Expanded]")).First();
Album album = new Album();
album.AlbumTitle = "Apollo 18";
album.ArtistID = db.Artists.Where(a => a.ArtistName.Equals("They Might Be Giants")).First().ArtistID;
album.Year = 2015;
db.Albums.Add(album);
db.SaveChanges();
Song song = new Song();
song.SongTitle = "Dig My Grave";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 1;
song.TrackLength = 68;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "I Palindrome I";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 2;
song.TrackLength = 142;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "She's Actual Size";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 3;
song.TrackLength = 125;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "My Evil Twin";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 4;
song.TrackLength = 157;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "Mammal";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 5;
song.TrackLength = 134;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "The Statue Got Me High";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 6;
song.TrackLength = 186;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "Spider";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 7;
song.TrackLength = 50;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "The Guitar";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 8;
song.TrackLength = 228;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "Dinner Bell";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 9;
song.TrackLength = 131;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "Narrow Your Eyes";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 10;
song.TrackLength = 166;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "Hall of Heads";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 11;
song.TrackLength = 173;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "Which Describes How You're Feeling";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 12;
song.TrackLength = 73;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "See the Constellation";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 13;
song.TrackLength = 207;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "If I Wasn't Shy";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 14;
song.TrackLength = 103;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "Turn Around";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 15;
song.TrackLength = 173;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "Hypnotist of Ladies";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 16;
song.TrackLength = 101;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "Catching on Fire";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 17;
song.TrackLength = 12;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "Fingertips I";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 18;
song.TrackLength = 6;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "I Hear the Wind Blow";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 19;
song.TrackLength = 10;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "Hey Now, Everybody";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 20;
song.TrackLength = 5;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "Standin'";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 21;
song.TrackLength = 6;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "A New Friend";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 22;
song.TrackLength = 7;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "Wreck My Car";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 23;
song.TrackLength = 11;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "Aren't You the Guy";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 24;
song.TrackLength = 6;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "Pass the Milk";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 25;
song.TrackLength = 8;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "Leave Me Alone";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 26;
song.TrackLength = 5;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "Knockin' on the Wall";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 27;
song.TrackLength = 4;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "All Alone";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 28;
song.TrackLength = 5;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "Blue Thing";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 29;
song.TrackLength = 8;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "Something Grabbed Ahold of My Hand";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 30;
song.TrackLength = 11;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "I Don't Understand You";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 31;
song.TrackLength = 27;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "I Heard a Sound";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 32;
song.TrackLength = 4;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "Mysterious Whisper";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 33;
song.TrackLength = 28;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "The Day That Love Came to Play";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 34;
song.TrackLength = 8;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "Heart Attack";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 35;
song.TrackLength = 22;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "Fingertips II";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 36;
song.TrackLength = 10;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "Darkened Corridors";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 37;
song.TrackLength = 61;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
song = new Song();
song.SongTitle = "Space Suit";
song.AlbumID = album.AlbumID;
song.ArtistID = album.ArtistID;
song.GenreID = genre.GenreID;
song.TrackNumber = 38;
song.TrackLength = 96;
song.Rating = 3;
db.Songs.Add(song);
db.SaveChanges();
albumList = db.Albums.OrderBy(a => a.AlbumTitle).ToList();
dataGridView1.DataSource = albumList;
}
}
public void TestAlbumFetch()
{
using (var ctx = new CDCatalogEntities())
{
//Test init
//Get an artist we know exists -- Kaskade
Artist A = ctx.Artists.Where(n => n.ArtistName.ToLower().Equals("kaskade")).FirstOrDefault();
//Get a genre we know exists -- Electronic
Genre G = ctx.Genres.Where(n => n.GenreName.ToLower().Equals("electronic")).FirstOrDefault();
//create a test album
Album i = new Album();
i.AlbumID = 0; // autogenerated on add
i.AlbumYear = 2014;
i.ArtistID = A.ArtistID;
i.AlbumTitle = "The KqxKAW Test Album";
i.AlbumRating = 5;
i.GenreID = G.GenreID;
//add it to the context, then database
ctx.Albums.Add(i);
ctx.SaveChanges();
//Find the test album in the database
Album m = ctx.Albums
.Where(n => n.AlbumTitle.ToLower().Equals("the kqxkaw test album"))
.FirstOrDefault();
Assert.IsTrue(m != null, "No Record Found");
//Test clean-up
if (m != null)
{
var list = ctx.Albums
.Where(n => n.AlbumTitle.ToLower().Equals("the kqxkaw test album"));
ctx.Albums.RemoveRange(list);
int count = ctx.SaveChanges();
}
}
}
public void TestSongDelete()
{
using (var ctx = new CDCatalogEntities())
{
//Test init
//Get an artist we know exists -- Avicii
Artist A = ctx.Artists.Where(n => n.ArtistName.ToLower().Equals("avicii")).FirstOrDefault();
//Get an album we know exists --
Album M = ctx.Albums.Where(n => n.AlbumTitle.ToLower().Equals("true")).FirstOrDefault();
//Get a genre we know exists -- Dance
Genre G = ctx.Genres.Where(n => n.GenreName.ToLower().Equals("dance")).FirstOrDefault();
Song s = new Song();
s.SongID = 0; // autogenerated on add
s.SongTitle = "Test Song GMwRYZ";
s.ArtistID = A.ArtistID;
s.AlbumID = M.AlbumID;
s.GenreID = G.GenreID;
s.SongTrackNumber = 15;
s.SongTrackLength =350;
s.SongRating = 3;
//add it to the database
ctx.Songs.Add(s);
//find the list of "Test Song GMwRYZ"
//in case duplicates were added in the previous tests
var list = ctx.Songs
.Where(n => n.SongTitle.ToLower().Equals("test song gmwryz"));
ctx.Songs.RemoveRange(list);
int count = ctx.SaveChanges();
Assert.IsTrue(count > 0, "No Record Deleted");
//Test clean-up (none)
}
}
public void TestGenreFetch()
{
using (var ctx = new CDCatalogEntities())
{
//Test init
Genre i = new Genre();
i.GenreID = 0; // auto incremented and set by add
i.GenreName = "Test Genre W6YderKT";
//add it to the context and save to database
ctx.Genres.Add(i);
ctx.SaveChanges();
//Find the test genre in the database
Genre g = ctx.Genres.Where(n => n.GenreName.ToLower().Equals("test genre w6yderkt")).FirstOrDefault();
Assert.IsTrue(g != null, "No Record Found");
//Test clean-up
if (g != null)
{
var list = ctx.Genres
.Where(n => n.GenreName.ToLower().Equals("test genre w6yderkt"))
.Where(n => n.GenreID > 0);
ctx.Genres.RemoveRange(list);
ctx.SaveChanges();
}
}
}
public void TestSongFetch()
{
using (var ctx = new CDCatalogEntities())
{
//Test init
//Get an artist we know exists -- Avicii
Artist A = ctx.Artists.Where(n => n.ArtistName.ToLower().Equals("avicii")).FirstOrDefault();
//Get an album we know exists --
Album M = ctx.Albums.Where(n => n.AlbumTitle.ToLower().Equals("true")).FirstOrDefault();
//Get a genre we know exists -- Dance
Genre G = ctx.Genres.Where(n => n.GenreName.ToLower().Equals("dance")).FirstOrDefault();
//Build a context
Song i = new Song();
i.SongID = 0; // autogenerated on add
i.SongTitle = "Test Song GMwRYZ";
i.ArtistID = A.ArtistID;
i.AlbumID = M.AlbumID;
i.GenreID = G.GenreID;
i.SongTrackNumber = 15;
i.SongTrackLength = 300;
i.SongRating = 3;
//add it to the database
ctx.Songs.Add(i);
//find a the test song in the database
Song s = ctx.Songs.Where(n => n.SongTitle.ToLower().Equals("test song gmwryz")).FirstOrDefault();
Assert.IsTrue(s != null, "No Record Deleted");
//Test clean-up
if (s != null)
{
//find all the test songs in the context
var list = ctx.Songs
.Where(n => n.SongTitle.ToLower().Equals("test song gmwryz"));
//delete them from the context and database
ctx.Songs.RemoveRange(list);
ctx.SaveChanges();
}
}
}
public void UpdateAlbumRating(string albumTitle, int albumRating, string artistName = null)
{
using (CDCatalogEntities context = new CDCatalogEntities())
{
Album album;
if (artistName == null)
{
album = GetAlbumByID(SearchAlbumsByAlbumTitle(albumTitle).First().AlbumId);
}
else
{
var albums = SearchAlbumsByAlbumTitle(albumTitle).ToList();
album = GetAlbumByID(albums.Where(a => a.Artist_Name == artistName).FirstOrDefault().AlbumId);
}
album.Rating = albumRating;
context.Albums.Attach(album);
var entry = context.Entry(album);
entry.Property(e => e.Rating).IsModified = true;
context.SaveChanges();
}
}
public void UpdateSongRating(string songTitle, int songRating, Album album = null)
{
using (CDCatalogEntities context = new CDCatalogEntities())
{
Song song;
if (album == null)
song = GetSongByID(SearchSongsBySongTitle(songTitle).First().SongID);
else
{
var songs = SearchSongsBySongTitle(songTitle);
song = GetSongByID((songs.Where(s => s.Album == album.Title).FirstOrDefault()).SongID);
}
song.Rating = songRating;
context.Songs.Attach(song);
var entry = context.Entry(song);
entry.Property(e => e.Rating).IsModified = true;
context.SaveChanges();
}
}
