public void Create(UArtist artist) { artist.ArtistID = Guid.NewGuid(); Db.Artists.Add(artist); Db.SaveChanges(); }
public void Update(UArtist artist) { Db.Entry<UArtist>(artist).State = System.Data.Entity.EntityState.Modified; Db.SaveChanges(); }
public SeedArtists(string versionID, ContentModel db, UmbracoProvider provider) : base(versionID, db, provider) { SeedName = "Artists"; SeedStart(); if (SeedCanRun) { List<UArtist> artists = UProvider.GetList<UArtist>("Artist").ToList(); if (artists.Count > 0) { foreach (UArtist a in artists) { try { UArtist tmp = new UArtist(a); tmp.IsPublished = true; if (!Db.Artists.Where(w => w.UmbracoID == tmp.UmbracoID).Any()) { tmp.ArtistID = Guid.NewGuid(); if (a.Country != null) { UCountry country = Db.Countries.Where(w => w.UmbracoID == a.Country.UmbracoID).FirstOrDefault(); tmp.CountryID = country.CountryID; tmp.Country = null; List<UGenre> tmpList = new List<UGenre>(); foreach (UGenre genre in a.Genres) { UGenre tmpGenre = db.Genres.Where(w => w.UmbracoID == genre.UmbracoID).First(); if (!Db.G2A.Where(w => Db.Artists.Select(s => s).Where(w2 => w2.UmbracoID == tmp.UmbracoID).Select(s2 => s2.ArtistID).ToList().Contains(w.ArtistID) && w.GenreID == tmpGenre.GenreID).Any()) { Db.G2A.Add(new UGenre2UArtist { G2AID = Guid.NewGuid(), ArtistID = tmp.ArtistID, GenreID = tmpGenre.GenreID }); } } tmp.Genres = null; Db.Artists.Add(tmp); } else { throw new Exception("Country for artist " + a.Name + " was null"); } } } catch(Exception ex) { throw ex; } } } try { Db.SaveChanges(); SeedFinished(true); } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { HandleDbEntityValidationException(ex); throw ex; } catch(Exception ex) { throw ex; } } else { SeedFinished(true); } }