public object AddArtist(string name) { Artist artist = new Artist(); artist.Name = name.Trim(); artist.DateAdded = DateTime.Today; DB.Artists.Add(artist); DB.SaveChanges(); return name + " added."; }
public object SaveSong(int id, string artistName, string name, string lyrics, string notes) { /// 1. Find song by id, or create new song /// 2. Set song properties /// 3. Find the artist, by name /// 4. If the artist does not exist, create it /// 5. Set artist /// 6. Save changes and return the updated song /// 1 Song song = DB.Songs.Find(id); if (song == null) { song = new Song(); // create a new one DB.Songs.Add(song); // add to set song.DateAdded = DateTime.Today; } /// 2 song.Name = name.Trim(); song.Lyrics = lyrics.Trim(); song.Notes = notes.Trim(); /// 3 Artist artist = DB.Artists.FirstOrDefault(x => x.Name == artistName); /// 4 if (artist == null) { artist = new Artist() { Name = artistName, DateAdded = DateTime.Now }; DB.Artists.Add(artist); } /// 5 song.Artist = artist; /// 6 DB.SaveChanges(); return GetSong(song.Id); }