public int Save()
{
try
{
Console.Clear();
if (SourceManagerSave.AlbumExists(this))
{
throw new Exception("Album exist in Base");
}
int ID = SourceManagerSave.Add(this);
if (ID == -1)
{
throw new Exception("Error, Data didn't save to Base");
}
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine($"zapisano {Title} do Bazy Danych pod ID: {ID}");
Console.ResetColor();
return(ID);
}
catch (Exception e)
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine(e.Message);
Console.ResetColor();
return(-1);
}
}
public static List <QueryModel> CreateQueryList(List <AlbumModel> albumList)
{
List <QueryModel> queryList = new List <QueryModel>();
foreach (AlbumModel album in albumList)
{
QueryModel query = new QueryModel();
query.ExistInDB = SourceManagerSave.AlbumExists(album);
if (query.ExistInDB)
{
SqlHelper.GetIDByNameAndTitle(album.Artists, album.Title);
}
if (!(album.Title is null))
{
query.Title = album.Title;
}
if (!(album.Artists is null))
{
query.Artist = album.Artists;
}
if (album.ExtraArtists.Count > 0)
{
query.Extraartists = album.ExtraArtists.Count;
}
if (album.Genres.Count > 0)
{
query.Genres = String.Join(", ", album.Genres.ToArray());
}
if (album.Styles.Count > 0)
{
query.Styles = String.Join(", ", album.Styles.ToArray());
}
if (album.TrackList.Count > 0)
{
query.Tracks = album.TrackList.Count;
}
if (album.Videos.Count > 0)
{
query.Videos = album.Videos.Count;
}
if (album.Images.Count > 0)
{
query.Images = album.Images.Count;
}
queryList.Add(query);
}
return(queryList);
}
public int Save()
{
try
{
if (SourceManagerSave.AlbumExists(this))
{
throw new Exception("Album exist in Base");
}
int ID = SourceManagerSave.Add(this);
if (ID == -1)
{
throw new Exception("Error, Data didn't save to Base");
}
return(ID);
}
catch (Exception e)
{
return(-1);
}
}