public static async Task Seed(IServiceProvider provider, GoDbContext context) { var comments = System.IO.File.ReadAllLines(CommentsFilePath); if (!context.Comments.Any()) { var allDests = context.Destinations.ToList(); foreach (var dest in allDests) { var countComments = new Random().Next(1, 11); for (int k = 0; k < countComments; k++) { //var socialization = new Random().Next(1, 3); var randomUser = context.Users.OrderBy(x => Guid.NewGuid()).First(); var comment = new Comment { Comentator = randomUser, ComentatorId = randomUser.Id, Date = DateTime.Now.AddSeconds(-k), Destination = dest, DestinationId = dest.Id, Content = comments.OrderBy(x => Guid.NewGuid()).First() }; await context.Comments.AddAsync(comment); await context.SaveChangesAsync(); } ; } } }
public static async Task Seed(IServiceProvider provider, GoDbContext context) { var rolAdminid = context.Roles.FirstOrDefault(r => r.Name == "Admin").Id; var adminId = context.UserRoles.FirstOrDefault(u => u.RoleId == rolAdminid).UserId; if (!context.LevelsParticipants.Any()) { var allGamess = context.Games.ToList(); var gamesLevelUsers = new List <GameLevelParticipant>(); foreach (var game in allGamess) { var countParticipans = new Random().Next(1, 10); var levelsGame = context.Levels.Where(x => x.GameId == game.Id).ToList(); for (int k = 0; k < countParticipans; k++) { var randomUser = context.Users.Where(x => x.Id != adminId).OrderBy(x => Guid.NewGuid()).First(); foreach (var level in levelsGame.OrderBy(x => x.NumberInGame)) { var imageNumber = new Random().Next(1, 3); if (gamesLevelUsers.FirstOrDefault(x => x.ParticipantId == randomUser.Id && x.LevelId == level.Id && x.GameId == game.Id) == null) { var gameLevelparticipant = new GameLevelParticipant { GameId = game.Id, Game = game, LevelId = level.Id, Level = level, ParticipantId = randomUser.Id, Participant = randomUser, StatusLevel = (StatusLevel)2, CorrespondingImage = File.ReadAllBytes(GamesImagesPath + imageNumber.ToString() + ".jpg") }; gamesLevelUsers.Add(gameLevelparticipant); } } } } await context.AddRangeAsync(gamesLevelUsers); await context.SaveChangesAsync(); } }
public static async Task Seed(IServiceProvider provider, GoDbContext context) { var stories = System.IO.File.ReadAllLines(StoriesFilePath); if (!context.Stories.Any()) { var allDests = context.Destinations.ToList(); foreach (var dest in allDests) { var countStories = new Random().Next(1, 20); for (int k = 0; k < countStories; k++) { //var socialization = new Random().Next(1, 3); var randomUser = context.Users.OrderBy(x => Guid.NewGuid()).First(); var stor = stories.OrderBy(x => Guid.NewGuid()).First(); var title = String.Join(" ", stor.Split(" ", StringSplitOptions.RemoveEmptyEntries).Take(3)); if (!context.Stories.Any(x => x.Content == stor && x.DestinationId == dest.Id)) { var story = new Story { Author = randomUser, AuthorId = randomUser.Id, Destination = dest, DestinationId = dest.Id, Content = stor, Title = title }; await context.Stories.AddAsync(story); await context.SaveChangesAsync(); } } ; } } }
public static async Task Seed(IServiceProvider provider, GoDbContext context) { if (!context.DestinationsUsers.Any()) { var allDests = context.Destinations.ToList(); foreach (var dest in allDests) { var countParticipans = new Random().Next(1, 20); for (int k = 0; k < countParticipans; k++) { var socialization = new Random().Next(1, 3); var randomUser = context.Users.OrderBy(x => Guid.NewGuid()).First(); var destUser = new DestinationsUsers { ParticipantId = randomUser.Id, Participant = randomUser, DestinationId = dest.Id, Destination = dest, Socialization = (Socialization)socialization }; var userExist = context.DestinationsUsers .FirstOrDefault(x => x.DestinationId == dest.Id && x.ParticipantId == randomUser.Id); if (userExist == null) { await context.DestinationsUsers.AddAsync(destUser); await context.SaveChangesAsync(); } } } } }
public static async Task Seed(IServiceProvider provider, GoDbContext context) { if (!context.CoursesUsers.Any()) { var allCourses = context.Courses.ToList(); foreach (var course in allCourses) { var countParticipans = new Random().Next(1, course.MaxCountParticipants); for (int k = 0; k < countParticipans; k++) { var statusUser = new Random().Next(1, 3); var randomUser = context.Users.OrderBy(x => Guid.NewGuid()).First(); var courseUser = new CoursesUsers { ParticipantId = randomUser.Id, Participant = randomUser, CourseId = course.Id, Course = course, StatusUser = StatusParticitant.Unsuccessfully }; var userExist = context.CoursesUsers .FirstOrDefault(x => x.CourseId == course.Id && x.ParticipantId == randomUser.Id); if (userExist == null) { await context.CoursesUsers.AddAsync(courseUser); await context.SaveChangesAsync(); } } } } }
//private readonly IServiceProvider provider; public static async Task Seed(IServiceProvider provider, GoDbContext context) { var sb = new StringBuilder(); var dataDestinations = new List <string>(); if (!context.Destinations.Any()) { var owners = System.IO.File.ReadAllLines(DestinationsFilePath); for (int i = 0; i < owners.Length; i++) { if (owners[i] == "") { var dest = sb.ToString(); dataDestinations.Add(dest); sb.Remove(0, sb.Length); } else { sb.AppendLine(owners[i]); } } var destinations = new List <Destination>(); for (int i = 0; i < dataDestinations.Count; i++) { var titleAndContent = dataDestinations[i].Split(Environment.NewLine).ToArray(); var title = titleAndContent[0]; var titleImg = new StringBuilder(); titleImg.Append(title); if (title.Contains("\"")) { titleImg.Clear(); for (int k = 0; k <= title.Length - 1; k++) { if (title[k] != '"') { titleImg.Append(title[k]); } } } var description = string.Join(Environment.NewLine, titleAndContent.Skip(1)); var imgPath = DestinationsImagesPath + titleImg.ToString() + ".jpg"; var creator = context.Users.OrderBy(x => Guid.NewGuid()).First(); var random = new Random().Next(1, 10); var random1 = new Random().Next(1, 7); var random2 = new Random().Next(1, 6); var endDateToJoin = DateTime.Now.AddDays(random - random1); var startDate = DateTime.Now.AddDays(random); var endDate = DateTime.Now.AddDays(random + random2); var randomLevel = new Random().Next(1, 3); var destination = new Destination { Naame = title, Description = description, Image = File.ReadAllBytes(imgPath), Creator = creator, CreatorId = creator.Id, StartDate = startDate, EndDateToJoin = endDateToJoin, EndDate = endDate, Level = (LevelOfDifficulty)randomLevel }; await context.Destinations.AddAsync(destination); } await context.SaveChangesAsync(); } }
public static async Task Seed(IServiceProvider provider, GoDbContext context) { var sb = new StringBuilder(); var dataGames = new List <string>(); if (!context.Games.Any()) { var owners = System.IO.File.ReadAllLines(GamesFilePath); for (int i = 0; i < owners.Length; i++) { if (owners[i] == "") { var game = sb.ToString(); dataGames.Add(game); sb.Remove(0, sb.Length); } else { sb.AppendLine(owners[i]); } } var games = new List <Game>(); for (int i = 0; i < dataGames.Count; i++) { var titleAndContent = dataGames[i].Split(Environment.NewLine).ToArray(); var title = titleAndContent[0]; var titleImg = new StringBuilder(); titleImg.Append(title); if (title.Contains("\"")) { titleImg.Clear(); for (int k = 0; k <= title.Length - 1; k++) { if (title[k] != '"') { titleImg.Append(title[k]); } } } var gameDescription = string.Join(Environment.NewLine, titleAndContent.Skip(1).Take(1)); var level1Text = string.Join(Environment.NewLine, titleAndContent.Skip(2).Take(1)); var level2Text = string.Join(Environment.NewLine, titleAndContent.Skip(3).Take(1)); var level3Text = string.Join(Environment.NewLine, titleAndContent.Skip(4).Take(1)); var creator = context.Users.OrderBy(x => Guid.NewGuid()).First(); var randomLevel1 = new Random().Next(1, 10); var randomLevel2 = new Random().Next(3, 10); var randomLevel3 = new Random().Next(5, 10); var creatorId = context.UserRoles.FirstOrDefault(x => x.RoleId == context.Roles.FirstOrDefault(r => r.Name == "Admin").Id).UserId; var game = new Game { Name = title, CreatorId = creatorId, Creator = context.Users.FirstOrDefault(x => x.Id == creatorId), Description = gameDescription, Image = File.ReadAllBytes(GamesImagesPath + "3" + ".jpg"), }; await context.Games.AddAsync(game); await context.SaveChangesAsync(); var level1 = new Level { Image = File.ReadAllBytes(GamesImagesPath + "1" + ".jpg"), Description = level1Text, Points = randomLevel1, NumberInGame = 1, Game = game, GameId = game.Id }; var level2 = new Level { Image = File.ReadAllBytes(GamesImagesPath + "2" + ".jpg"), Description = level2Text, Points = randomLevel2, NumberInGame = 2, Game = game, GameId = game.Id }; var level3 = new Level { Image = File.ReadAllBytes(GamesImagesPath + "3" + ".jpg"), Description = level3Text, Points = randomLevel3, NumberInGame = 3, Game = game, GameId = game.Id }; context.Levels.Add(level1); context.Levels.Add(level2); context.Levels.Add(level3); } await context.SaveChangesAsync(); } }
//private readonly IServiceProvider provider; public static async Task Seed(IServiceProvider provider, GoDbContext context) { var sb = new StringBuilder(); var dataCourses = new List <string>(); if (!context.Courses.Any()) { var owners = System.IO.File.ReadAllLines(CoursesFilePath); for (int i = 0; i < owners.Length; i++) { if (owners[i] == "") { var course = sb.ToString(); dataCourses.Add(course); sb.Remove(0, sb.Length); } else { sb.AppendLine(owners[i]); } } var courses = new List <Course>(); for (int i = 0; i < dataCourses.Count; i++) { var titleAndContent = dataCourses[i].Split(Environment.NewLine).ToArray(); var title = titleAndContent[0]; var titleImg = new StringBuilder(); titleImg.Append(title); if (title.Contains("\"")) { titleImg.Clear(); for (int k = 0; k <= title.Length - 1; k++) { if (title[k] != '"') { titleImg.Append(title[k]); } } } int image; var description = string.Join(Environment.NewLine, titleAndContent.Skip(1)); if (title == CourseName1) { image = 3; } else if (title == CourseName2) { image = 2; } else { image = 1; } var imgPath = CoursesImagesPath + image.ToString() + ".jpg"; var creator = context.Users.OrderBy(x => Guid.NewGuid()).First(); var random = new Random().Next(1, 10); var random1 = new Random().Next(random, random + 30); var startDate = DateTime.Now.AddDays(random); var randomStatus = new Random().Next(1, 3); var randomCategory = new Random().Next(1, 5); var randomMaxCountParticipants = new Random().Next(3, 20); var course = new Course { Title = title, Description = description, Image = File.ReadAllBytes(imgPath), Creator = creator, CreatorId = creator.Id, StartDate = DateTime.Now,//startDate, DurationOfDays = random, CountOfHours = random1, MaxCountParticipants = randomMaxCountParticipants, Status = (Status)randomStatus, Category = (Category)randomCategory }; if (i == 0) { course.StartDate = DateTime.Now.AddDays(-3); course.DurationOfDays = 2; } else if (i == 1) { course.StartDate = DateTime.Now.AddDays(1); course.DurationOfDays = 2; } await context.Courses.AddAsync(course); } await context.SaveChangesAsync(); } }