public static void Update(string oldSinger, string newSinger, string newSong, string songLength, int rating, string songText)
{
using (var context = new MusColectionContext())
{
SongList songList = context.SongLists.FirstOrDefault(treck => treck.Singer == oldSinger);
if (songList != null)
{
songList.Singer = newSinger;
songList.Song = newSong;
context.Entry(songList).State = EntityState.Modified;
context.SaveChanges();
}
SongDescription songDescription = context.SongDescriptions.FirstOrDefault(description => description.SongList.Singer == oldSinger);
if (songDescription != null)
{
songDescription.SongLehgth = songLength;
songDescription.Rating = rating;
songDescription.SongText = songText;
context.SaveChanges();
}
Console.Clear();
ShowCollection();
}
}
public static void Add()
{
using (var context = new MusColectionContext())
{
SongList songList = new SongList();
SongDescription songDescription = new SongDescription();
Console.Write("Ввдите исполнителя песни: ");
songList.Singer = Console.ReadLine();
Console.Write("Введите композицию: ");
songList.Song = Console.ReadLine();
Console.WriteLine("Описание");
Console.Write("\tдлительность трека: ");
songDescription.SongLehgth = Console.ReadLine();
Console.Write("\tвведите рейтинг трека: ");
int rating = 0;
int.TryParse(Console.ReadLine(), out rating);
if (rating == 0)
{
Console.WriteLine("Вы не отметили рейтинг песни?");
}
Console.WriteLine("Слова песни по умолчанию. Cлова наиболее любимых треков можно будет занести позже");
songDescription.SongText = "";
context.SongLists.Add(songList);
context.SongDescriptions.Add(songDescription);
context.SaveChanges();
}
}
public static void Delete(string singer)
{
using (var context = new MusColectionContext())
{
SongList songList = context.SongLists.Include("Description").FirstOrDefault();
if (songList != null)
{
context.SongDescriptions.Remove(songList.Description);
context.SongLists.Remove(songList);
context.SaveChanges();
}
SongDescription songDescription = context.SongDescriptions.FirstOrDefault(description => description.SongList.Singer == singer);
if (songDescription != null)
{
context.SongDescriptions.Remove(songDescription);
context.SaveChanges();
}
}
}