public void AddGenre(Guid id, string description) { var ent = new MediaCatalogueEntities(); var genre = new Music_Genre(); genre.id = id; genre.Description = description; ent.AddToMusic_Genre(genre); ent.SaveChanges(); }
public void AddArtist(Guid id, string description) { var ent = new MediaCatalogueEntities(); var artist = new Music_Artist(); artist.id = id; artist.Name = description; ent.AddToMusic_Artist(artist); ent.SaveChanges(); }
public void UpdateGenre(Guid id, string description) { var ent = new MediaCatalogueEntities(); var genre = (from g in ent.Music_Genre where g.id == id select g).FirstOrDefault(); if (genre != null) { genre.Description = description; ent.SaveChanges(); } }
public void UpdateArtist(Guid id, string description) { var ent = new MediaCatalogueEntities(); var artist = (from a in ent.Music_Artist where a.id == id select a).FirstOrDefault(); if (artist != null) { artist.Name = description; ent.SaveChanges(); } }
public void UpdateVideoClip(MusicVideoClip clip) { var ent = new MediaCatalogueEntities(); var vc = (from c in ent.Music_Track.Include("Media_Item") .Include("Music_Genre") .Include("Music_Artist") where c.id == clip.id select c).FirstOrDefault(); if (vc != null) { vc.Media_Item.Title = clip.SongName; vc.Duration = clip.Duration; // ToDo: Find the right Genre and Artist entities, and update the references ent.SaveChanges(); } }