protected override Role UpdateEntity(MovieDbContext entityContext, Role entity) { return((from e in entityContext.RoleSet where e.Id == entity.Id select e).FirstOrDefault()); }
protected override State AddEntity(MovieDbContext entityContext, State entity) { return(entityContext.StateSet.Add(entity)); }
protected override State GetEntity(MovieDbContext entityContext, int id) { return((from s in entityContext.StateSet where s.Id == id select s).FirstOrDefault()); }
protected override Country AddEntity(MovieDbContext entityContext, Country entity) { return(entityContext.CountrySet.Add(entity)); }
protected override Country GetEntity(MovieDbContext entityContext, int id) { return((from c in entityContext.CountrySet where c.Id == id select c).FirstOrDefault()); }
protected override IEnumerable <User> GetEntities(MovieDbContext entityContext) { return(entityContext.UserSet.ToList()); }
protected override Comment UpdateEntity(MovieDbContext entityContext, Comment entity) { return((from e in entityContext.CommentSet where e.Id == entity.Id select e).FirstOrDefault()); }
protected override PollVotingRecord UpdateEntity(MovieDbContext entityContext, PollVotingRecord entity) { return((from en in entityContext.PollVotingRecordSet where en.Id == entity.Id select en).FirstOrDefault()); }
protected override PollVotingRecord GetEntity(MovieDbContext entityContext, int id) { return((from en in entityContext.PollVotingRecordSet where en.Id == id select en).FirstOrDefault()); }
protected override IEnumerable <Review> GetEntities(MovieDbContext entityContext) { return(entityContext.ReviewSet.ToList()); }
protected override PollVotingRecord AddEntity(MovieDbContext entityContext, PollVotingRecord entity) { return(entityContext.PollVotingRecordSet.Add(entity)); }
protected override Review GetEntity(MovieDbContext entityContext, int id) { return((from en in entityContext.ReviewSet where en.Id == id select en).FirstOrDefault()); }
protected override Review UpdateEntity(MovieDbContext entityContext, Review entity) { return((from en in entityContext.ReviewSet where en.Id == entity.Id select en).FirstOrDefault()); }
protected override Review AddEntity(MovieDbContext entityContext, Review entity) { return(entityContext.ReviewSet.Add(entity)); }
public static void SeedActorsTop1000() { var actors = XDocument.Load(@"C:\seed\New_\active.xml"); var actorsName = actors.Elements("Top1000").Elements("Actor").Elements("Name").Select(t => t.Value).ToList(); var actorsConst = actors.Elements("Top1000").Elements("Actor").Elements("Const").Select(t => t.Value).ToList(); var actorsKnownFor = actors.Elements("Top1000").Elements("Actor").Elements("KnownFor").Select(t => t.Value).ToList(); var actorsIsMale = actors.Elements("Top1000").Elements("Actor").Elements("IsMale").Select(t => t.Value).ToList(); var actorsBirthDate = actors.Elements("Top1000").Elements("Actor").Elements("Birth").Select(t => t.Value).ToList(); var forCount = actorsName.Count; var list = new List <string>(); var firstLastNameSeperated = new List <Seeder.FirstLastName>(); foreach (var actorFullName in actorsName) { var splitted = actorFullName.Split(' '); switch (splitted.Count()) { case 1: list.Add(actorFullName); break; case 2: firstLastNameSeperated.Add(new Seeder.FirstLastName() { First = splitted[0], Last = splitted[1] }); break; case 3: firstLastNameSeperated.Add(new Seeder.FirstLastName() { First = splitted[0], Last = splitted[1] + " " + splitted[2] }); break; case 4: firstLastNameSeperated.Add(new Seeder.FirstLastName() { First = splitted[0], Last = splitted[1] + " " + splitted[2] + " " + splitted[3] }); break; } } var birthdateFinal = new List <DateTime>(); foreach (var year in actorsBirthDate) { DateTime dateOut; DateTime.TryParse(year, out dateOut); var dateFinal = dateOut.ToShortDateString(); birthdateFinal.Add(dateOut); } using (var context = new MovieDbContext()) { for (int i = 0; i < forCount; i++) { var actorKnownForMovieId = actorsKnownFor[i]; Movie isThereAmovie = context.MovieSet.FirstOrDefault(t => t.ImdbLink == actorKnownForMovieId); if (isThereAmovie != null) // Film var mı? : Film var. { // Peki aktör var mı? string actorName = actorsName[i]; Actor isThereAnActor = context.ActorSet.FirstOrDefault(t => t.FullName == actorName); if (isThereAnActor == null) // böyle bir aktör yok (map da olamaz). ama bu aktörün (known for) movie'si var. { var actorToDb = new Actor() { Biography = "", BirthDate = birthdateFinal[i], CreatedAt = isThereAmovie.CreatedAt, DeathDate = null, FirstName = firstLastNameSeperated[i].First, LastName = firstLastNameSeperated[i].Last, FullName = actorsName[i], Gender = Convert.ToBoolean(actorsIsMale[i]), CountryId = 1, CountyId = 1, StateId = 1, ImdbLink = actorsConst[i], Photo = "null" }; context.ActorSet.Add(actorToDb); context.SaveChanges(); context.MovieActorMappingSet.Add(new MovieActorMapping() { MovieId = isThereAmovie.Id, ActorId = actorToDb.Id }); context.SaveChanges(); } else { // böyle bir aktör var. Film de vardı. O zaman map yapma zamanı. // Tabii hali hazırda map yoksa... // önce gender ayarı MovieActorMapping mp = context.MovieActorMappingSet .FirstOrDefault(t => t.MovieId == isThereAmovie.Id && t.ActorId == isThereAnActor.Id); if (mp == null) // map yok { context.MovieActorMappingSet.Add(new MovieActorMapping() { MovieId = isThereAmovie.Id, ActorId = isThereAnActor.Id }); context.SaveChanges(); } } } else { // Actor için KnownFor FİLM YOK. Peki böyle bir Actor var mı? string actorName = actorsName[i]; Actor isThereAnActor = context.ActorSet.FirstOrDefault(t => t.FullName == actorName); if (isThereAnActor == null) // böyle bir aktör de YOK: ekle o zaman. { var actorToDb = new Actor() { Biography = "", BirthDate = birthdateFinal[i], CreatedAt = DateTime.Now, DeathDate = null, FirstName = firstLastNameSeperated[i].First, LastName = firstLastNameSeperated[i].Last, FullName = actorsName[i], Gender = Convert.ToBoolean(actorsIsMale[i]), CountryId = 1, CountyId = 1, StateId = 1, ImdbLink = actorsConst[i], Photo = "null" }; context.ActorSet.Add(actorToDb); context.SaveChanges(); } } } } }
protected override IEnumerable <PollVotingRecord> GetEntities(MovieDbContext entityContext) { return(entityContext.PollVotingRecordSet.ToList()); }
protected override User AddEntity(MovieDbContext entityContext, User entity) { return(entityContext.UserSet.Add(entity)); }
protected override BlogPostComment AddEntity(MovieDbContext entityContext, BlogPostComment entity) { return(entityContext.BlogPostCommentSet.Add(entity)); }
protected override Comment AddEntity(MovieDbContext entityContext, Comment entity) { return(entityContext.CommentSet.Add(entity)); }
protected override BlogPostComment GetEntity(MovieDbContext entityContext, int id) { return((from en in entityContext.BlogPostCommentSet where en.Id == id select en).FirstOrDefault()); }
protected override Comment GetEntity(MovieDbContext entityContext, int id) { return((from e in entityContext.CommentSet where e.Id == id select e).FirstOrDefault()); }
protected override IEnumerable <BlogPostComment> GetEntities(MovieDbContext entityContext) { return(entityContext.BlogPostCommentSet.ToList()); }
protected override Country UpdateEntity(MovieDbContext entityContext, Country entity) { return((from c in entityContext.CountrySet where c.Id == entity.Id select c).FirstOrDefault()); }
protected override News AddEntity(MovieDbContext entityContext, News entity) { return(entityContext.NewsSet.Add(entity)); }
protected override IEnumerable <Country> GetEntities(MovieDbContext entityContext) { return(entityContext.CountrySet.ToList()); }
protected override News UpdateEntity(MovieDbContext entityContext, News entity) { return((from e in entityContext.NewsSet where e.Id == entity.Id select e).FirstOrDefault()); }
protected override State UpdateEntity(MovieDbContext entityContext, State entity) { return((from s in entityContext.StateSet where s.Id == entity.Id select s).FirstOrDefault()); }
protected override Director AddEntity(MovieDbContext entityContext, Director entity) { entity.CreatedAt = DateTime.Now; return(entityContext.DirectorSet.Add(entity)); }
protected override IEnumerable <State> GetEntities(MovieDbContext entityContext) { return(entityContext.StateSet.ToList()); }
protected override Role AddEntity(MovieDbContext entityContext, Role entity) { return(entityContext.RoleSet.Add(entity)); }