public Album()
{
this.Title = "";
this.DateReleased = DateTime.Now;
this.Artist = null;
//ArtistsInAlbum = new List<Artist>();
// CompositionsInAlbum = new List<Composition>();
}
public Album(string title, Artist artist)
{
this.Artist = artist;
this.Title = title;
//ArtistsInAlbum = new List<Artist>();
// CompositionsInAlbum = new List<Composition>();
this.SaveToDB();
}
public Album(Artist artist, string title, DateTime daterelease)
{
this.Artist = artist;
this.Title = title;
this.DateReleased = daterelease;
//ArtistsInAlbum = new List<Artist>();
// CompositionsInAlbum = new List<Composition>();
this.SaveToDB();
}
public void CreateArtist(string LastName, string FirstName)
{
Artist Artist = new Artist(LastName, FirstName);
}
public void CreateArtist()
{
Artist Artist = new Artist();
}
public void DeleteArtist(Artist SelectedArtist)
{
ICollection<Album> Albs = new List<Album>();
foreach (Album alb in Album.Load())
{
if (alb.Artist.Id == SelectedArtist.Id)
Albs.Add(alb);
}
if (Albs.Count == 0)
SelectedArtist.Delete();
}
public void CreateArtist(string lastname, string firstname)
{
Artist Artist = new Artist(lastname, firstname);
}
public void EditArtist(Artist SelectedArtist, string NewFirstName, string NewLastName)
{
SelectedArtist.Update(new Artist() { FirstName = NewFirstName, LastName = NewLastName });
}
public Album(Artist artist, string title, DateTime daterelease)
{
this.Artist = artist;
this.Title = title;
// this.DateReleased = daterelease;
this.Save();
}
public Album()
{
this.Title = "";
//this.DateReleased = DateTime.Now;
this.Artist = null;
}
/* public static Album FindThisInstanceInDB(DateTime date_released)
{
using (SqlCommand sqlcmd = new SqlCommand())
{
Album Album = null;
sqlcmd.Connection = new System.Data.SqlClient.SqlConnection(ConnectionString);
sqlcmd.CommandText = "SELECT * FROM Albums WHERE DateReleased=@date_released";
sqlcmd.Parameters.AddWithValue("@date_released", date_released);
sqlcmd.Connection.Open();
using (var sqlreader = sqlcmd.ExecuteReader())
{
if (sqlreader.HasRows)
{
sqlreader.Read();
Album = new Album();
Album.Id = (Guid)sqlreader[0];
Album.Title = (string)sqlreader[1];
Album.DateReleased = (DateTime)sqlreader[2];
}
sqlcmd.Connection.Close();
return Album;
}
}*/
// }
/// <summary>
/// Loading of all instances from database
/// </summary>
/// <returns></returns>
public static List<Album> Load()
{
using (SqlCommand sqlcmd = new SqlCommand())
{
List<Album> ListAlbums = new List<Album>();
sqlcmd.Connection = new System.Data.SqlClient.SqlConnection(ConnectionString);
sqlcmd.CommandText = "SELECT * FROM Albums";
sqlcmd.Connection.Open();
using (var sqlreader = sqlcmd.ExecuteReader())
{
if (sqlreader.HasRows)
{
while (sqlreader.Read())
{
var Album = new Album();
Album.Id = (Guid)sqlreader[0];
Album.Title = (string)sqlreader[1];
Album.Artist = (Artist)Artist.FindThisInstanceInDB((Guid)sqlreader[2]);
//album.DateReleased = Convert.ToDateTime((string)sqlreader[2]);
ListAlbums.Add(Album);
}
}
sqlcmd.Connection.Close();
return ListAlbums;
}
}
}
public Album(string title, Artist artist)
{
this.Id = Guid.NewGuid();
this.Artist = artist;
this.Title = title;
this.Save();
}
public Composition(string title, string subtitle, string words, string music, string tabs, string copyright, string notice, Album album, Artist artist)//, DateTime datecreated)
{
this.Title = title;
this.Subtitle = subtitle;
this.Words = words;
this.Music = music;
this.Tabs = tabs;
this.Copyright = copyright;
this.Notice = notice;
//this.DateCreated = datecreated;
this.Album = album;
this.Artist = artist;
ArtistsOfComposition = new List<Artist>();
//CompositionInAlbums = new List<Album>();
this.SaveToDB();
}
/// <summary>
/// Loading of all instances from database
/// </summary>
/// <returns></returns>
public static List<Artist> LoadAllFromDB()
{
using (SqlCommand sqlcmd = new SqlCommand())
{
List<Artist> ListArtists = new List<Artist>();
sqlcmd.Connection = new System.Data.SqlClient.SqlConnection(ConnectionString);
sqlcmd.CommandText = "SELECT * FROM Artists";
sqlcmd.Connection.Open();
using (var sqlreader = sqlcmd.ExecuteReader())
{
if (sqlreader.HasRows)
{
while (sqlreader.Read())
{
var artist = new Artist();
artist.Id = (Guid)sqlreader[0];
artist.LastName = (string)sqlreader[1];
artist.FirstName = (string)sqlreader[2];
ListArtists.Add(artist);
}
}
sqlcmd.Connection.Close();
return ListArtists;
}
}
}
/// <summary>
/// Search by Id
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static Artist FindThisInstanceInDB(Guid id)
{
using (SqlCommand sqlcmd = new SqlCommand())
{
Artist Artist = null;
sqlcmd.Connection = new System.Data.SqlClient.SqlConnection(ConnectionString);
sqlcmd.CommandText = "SELECT * FROM Artists WHERE Id=@id";
sqlcmd.Parameters.AddWithValue("@id", id);
sqlcmd.Connection.Open();
using (var sqlreader = sqlcmd.ExecuteReader())
{
if (sqlreader.HasRows)
{
sqlreader.Read();
Artist = new Artist();
Artist.Id = (Guid)sqlreader[0];
Artist.LastName = (string)sqlreader[1];
Artist.FirstName = (string)sqlreader[2];
}
sqlcmd.Connection.Close();
return Artist;
}
}
}
public void CreateAlbum(string Name, Artist SelectedArtist)
{
Album alb = new Album(Name, SelectedArtist);
}
public void CreateComposition(string Title, string Subtitle, string Words, string Music, string Tabs, string Copyright, string Notice, Album SelectedAlbum, Artist SelectedArtist, User SelectedAuthor)
{
Composition Composition = new Composition(Title, Subtitle, Words, Music, Tabs, Copyright, Notice, SelectedAlbum, SelectedArtist, SelectedAuthor);
// UserComposition UserComposition = new UserComposition(SelectedAuthor, Composition);
}
/// <summary>
/// Search by Id
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static Album FindThisInstanceInDB(Guid id)
{
using (SqlCommand sqlcmd = new SqlCommand())
{
Album Album = null;
sqlcmd.Connection = new System.Data.SqlClient.SqlConnection(ConnectionString);
sqlcmd.CommandText = "SELECT * FROM Albums WHERE Id=@id";
sqlcmd.Parameters.AddWithValue("@id", id);
sqlcmd.Connection.Open();
using (var sqlreader = sqlcmd.ExecuteReader())
{
if (sqlreader.HasRows)
{
sqlreader.Read();
Album = new Album();
Album.Id = (Guid)sqlreader[0];
Album.Artist = (Artist)Artist.FindThisInstanceInDB((Guid)sqlreader[1]);
Album.Title = (string)sqlreader[2];
//Album.DateReleased = (DateTime)sqlreader[2];
}
sqlcmd.Connection.Close();
return Album;
}
}
}
public void EditComposition(Composition SelectedComposition, string NewTitle, string NewSubtitle, string NewWords, string NewMusic, string NewTabs, string NewCopyright, string NewNotice, Album NewSelectedAlbum, Artist NewSelectedArtist, User NewAuthor)
{
SelectedComposition.Update(
new Composition()
{
Title = NewTitle,
Subtitle = NewSubtitle,
Words = NewWords,
Music = NewMusic,
Tabs = NewTabs,
Copyright = NewCopyright,
Notice = NewNotice,
Album = NewSelectedAlbum,
Artist = NewSelectedArtist,
Author = NewAuthor
});
}
public Composition(string title, string subtitle, string words, string music, string tabs, string copyright, string notice, Album album, Artist artist, User author)//, DateTime datecreated)
{
this.Id = Guid.NewGuid();
this.Title = title;
this.Subtitle = subtitle;
this.Words = words;
this.Music = music;
this.Tabs = tabs;
this.Copyright = copyright;
this.Notice = notice;
//this.DateCreated = datecreated;
this.Album = album;
this.Artist = artist;
this.Author = author;
this.Save();
}