public List<Album> AlbumsOfArtist()
{
using (SqlCommand sqlcmd = new SqlCommand())
{
List<Album> ArtistsInAlbum = new List<Album>();
sqlcmd.Connection = new System.Data.SqlClient.SqlConnection(ConnectionString);
sqlcmd.CommandText = @"SELECT * FROM Albums WHERE ArtistId = @artistid";
sqlcmd.Parameters.AddWithValue("@artistid", this.Id);
sqlcmd.Connection.Open();
using (var sqlreader = sqlcmd.ExecuteReader())
{
if (sqlreader.HasRows)
{
while (sqlreader.Read())
{
Album album = new Album();
album.Id = (Guid)sqlreader[0];
album.Artist = (Artist)Artist.FindThisInstanceInDB((Guid)sqlreader[1]);
album.Title = (string)sqlreader[2];
ArtistsInAlbum.Add(album);
}
}
sqlcmd.Connection.Close();
return ArtistsInAlbum;
}
}
}
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 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);
}
public void CreateAlbum(string Name, Artist SelectedArtist)
{
Album alb = new Album(Name, SelectedArtist);
}
public void CreateAlbum()
{
Album Album = new Album();
}
public void DeleteAlbum(Album SelectedAlbum)
{
ICollection<Composition> compositions = new List<Composition>();
foreach (Composition comp in Composition.Load())
{
if (comp.Artist.Id == SelectedAlbum.Id)
compositions.Add(comp);
}
if (compositions.Count == 0)
SelectedAlbum.Delete();
}
/// <summary>
/// Loading of all instances from database
/// </summary>
/// <returns></returns>
public static List<Album> LoadAllFromDB()
{
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.Artist = (Artist)Artist.FindThisInstanceInDB((Guid)sqlreader[1]);
album.Title = (string)sqlreader[2];
//album.DateReleased = Convert.ToDateTime((string)sqlreader[2]);
ListAlbums.Add(album);
}
}
sqlcmd.Connection.Close();
return ListAlbums;
}
}
}
/// <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 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();
}
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();
}
