private void SeedRecruitments(FootballizeDbContext dbContext, User user, List <Pitch> fields) { var games = new List <Recruitment>(); for (int i = 2; i <= 10; i++) { var index = i % 2 == 0 ? 1 : 0; var game = new Recruitment { Title = $"Need {i} players", Pitch = fields[index], Creator = user, StartingAt = DateTime.Now.AddDays(2), MaximumPlayers = i, }; games.Add(game); } foreach (var game in games) { if (!dbContext.Recruitments.Any(x => x.Title == game.Title)) { dbContext.Recruitments.Add(game); } } }
public void Seed(FootballizeDbContext dbContext, IServiceProvider serviceProvider) { var roles = new List <Role> { new Role(GlobalConstants.CanCreateGathersRoleName), new Role(GlobalConstants.CanEditGathersRoleName), new Role(GlobalConstants.CanDeleteGathersRoleName), new Role(GlobalConstants.CanCreateRecruitmentRoleName), new Role(GlobalConstants.CanEditRecruitmentRoleName), new Role(GlobalConstants.CanDeleteRecruitmentRoleName), new Role(GlobalConstants.CanSeeAdminAreaRoleName), new Role(GlobalConstants.CanBanPlayers), }; var roleManager = serviceProvider.GetService <RoleManager <Role> >(); foreach (Role role in roles) { if (!roleManager.RoleExistsAsync(role.Name).Result) { IdentityResult roleResult = roleManager. CreateAsync(role).Result; } } }
public static void Seed(FootballizeDbContext dbContext, IServiceProvider serviceProvider) { if (dbContext == null) { throw new ArgumentNullException(nameof(dbContext)); } if (serviceProvider == null) { throw new ArgumentNullException(nameof(serviceProvider)); } var logger = serviceProvider.GetService <ILoggerFactory>().CreateLogger(typeof(ApplicationDbContextSeeder)); var seeders = new List <ISeeder> { new RolesSeeder(), new UsersSeeder(), new CountriesAndCitiesSeeder(), new FieldsSeeder(), new GamesSeeder() }; foreach (var seeder in seeders) { seeder.Seed(dbContext, serviceProvider); logger.LogInformation($"Seeder {seeder.GetType().Name} done."); dbContext.SaveChanges(); } }
public void Seed(FootballizeDbContext dbContext, IServiceProvider serviceProvider) { var user = dbContext.Users.FirstOrDefault(); var fields = dbContext.Pitches.Take(2).ToList(); this.SeedGathers(dbContext, user, fields); this.SeedRecruitments(dbContext, user, fields); }
private void SeedGathers(FootballizeDbContext dbContext, User user, List <Pitch> fields) { var gathers = new List <Gather>(); for (int i = 0; i < 10; i++) { var index = i % 2 == 0 ? 1 : 0; var gather = new Gather { Pitch = fields[index], Creator = user, StartingAt = DateTime.Now.AddDays(1), Description = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse lectus nisi, dictum vitae euismod vel, elementum eu nunc. Maecenas feugiat orci enim, a euismod mauris sollicitudin et.", TeamFormat = TeamFormat.FivePlusOne, Title = $"Game {(i + 1)}", MaximumPlayers = 12 }; var player = new GatherUser { Gather = gather, User = user }; gather.Players.Add(player); gathers.Add(gather); } foreach (Gather gather in gathers) { if (!dbContext.Gathers.Any(x => x.Title == gather.Title)) { dbContext.Gathers.Add(gather); } } }
public void Seed(FootballizeDbContext dbContext, IServiceProvider serviceProvider) { var sources = new List <Country> { new Country { Name = "Bulgaria", IsoCode = "BG", Provinces = new List <Province> { new Province { Name = "Blagoevgrad", Towns = new List <Town> { new Town { Name = "Blagoevgrad", } } }, new Province { Name = "Burgas", Towns = new List <Town> { new Town { Name = "Burgas", } } }, new Province { Name = "Dobrich", Towns = new List <Town> { new Town { Name = "Dobrich", } } }, new Province { Name = "Gabrovo", Towns = new List <Town> { new Town { Name = "Gabrovo", } } }, new Province { Name = "Kardzhali", Towns = new List <Town> { new Town { Name = "Kardzhali", } } }, new Province { Name = "Khaskovo", Towns = new List <Town> { new Town { Name = "Khaskovo", } } }, new Province { Name = "Kyustendil", Towns = new List <Town> { new Town { Name = "Kyustendil", } } }, new Province { Name = "Lovec", Towns = new List <Town> { new Town { Name = "Lovec", } } }, new Province { Name = "Montana", Towns = new List <Town> { new Town { Name = "Montana", } } }, new Province { Name = "Pazardzhik", Towns = new List <Town> { new Town { Name = "Pazardzhik", } } }, new Province { Name = "Pernik", Towns = new List <Town> { new Town { Name = "Pernik", } } }, new Province { Name = "Pleven", Towns = new List <Town> { new Town { Name = "Pleven", } } }, new Province { Name = "Plovdiv", Towns = new List <Town> { new Town { Name = "Plovdiv", } } }, new Province { Name = "Razgrad", Towns = new List <Town> { new Town { Name = "Razgrad", } } }, new Province { Name = "Ruse", Towns = new List <Town> { new Town { Name = "Ruse", } } }, new Province { Name = "Shumen", Towns = new List <Town> { new Town { Name = "Shumen", } } }, new Province { Name = "Silistra", Towns = new List <Town> { new Town { Name = "Silistra", } } }, new Province { Name = "Sliven", Towns = new List <Town> { new Town { Name = "Sliven", } } }, new Province { Name = "Smolyan", Towns = new List <Town> { new Town { Name = "Smolyan", } } }, new Province { Name = "Sofia", Towns = new List <Town> { new Town { Name = "Sofia", } } }, new Province { Name = "Stara Zagora", Towns = new List <Town> { new Town { Name = "Stara Zagora", } } }, new Province { Name = "Targovishte", Towns = new List <Town> { new Town { Name = "Targovishte", } } }, new Province { Name = "Veliko Turnovo", Towns = new List <Town> { new Town { Name = "Veliko Turnovo", } } }, new Province { Name = "Varna", Towns = new List <Town> { new Town { Name = "Varna", } } }, new Province { Name = "Vidin", Towns = new List <Town> { new Town { Name = "Vidin", } } }, new Province { Name = "Vratsa", Towns = new List <Town> { new Town { Name = "Vratsa", } } }, new Province { Name = "Yambol", Towns = new List <Town> { new Town { Name = "Yambol", } } } } } }; foreach (Country country in sources) { if (!dbContext.Countries.Any(x => x.Name == country.Name)) { dbContext.Countries.Add(country); } } }
public void Seed(FootballizeDbContext dbContext, IServiceProvider serviceProvider) { var userManager = serviceProvider.GetService <UserManager <User> >(); var users = new List <User> { new User { Email = "*****@*****.**", UserName = "******", FirstName = "Tester", LastName = "Testerov" }, new User { Email = "*****@*****.**", UserName = "******", FirstName = "Gather", LastName = "Admin" }, new User { Email = "*****@*****.**", UserName = "******", FirstName = "Recruit", LastName = "Admin" }, new User { Email = "*****@*****.**", UserName = "******", FirstName = "Super", LastName = "Admin" } }; foreach (var user in users) { if (userManager.FindByEmailAsync(user.Email).Result == null) { IdentityResult result = userManager.CreateAsync(user, "gather123").Result; if (result.Succeeded) { if (user.UserName.Contains("Gather")) { userManager.AddToRoleAsync(user, GlobalConstants.CanCreateGathersRoleName).Wait();; userManager.AddToRoleAsync(user, GlobalConstants.CanEditGathersRoleName).Wait();; userManager.AddToRoleAsync(user, GlobalConstants.CanDeleteGathersRoleName).Wait();; } if (user.UserName.Contains("Recruit")) { userManager.AddToRoleAsync(user, GlobalConstants.CanCreateRecruitmentRoleName).Wait();; userManager.AddToRoleAsync(user, GlobalConstants.CanEditRecruitmentRoleName).Wait();; userManager.AddToRoleAsync(user, GlobalConstants.CanDeleteRecruitmentRoleName).Wait();; } if (user.UserName.Contains("Super")) { userManager.AddToRoleAsync(user, GlobalConstants.CanCreateGathersRoleName).Wait(); userManager.AddToRoleAsync(user, GlobalConstants.CanEditGathersRoleName).Wait(); userManager.AddToRoleAsync(user, GlobalConstants.CanDeleteGathersRoleName).Wait(); userManager.AddToRoleAsync(user, GlobalConstants.CanCreateRecruitmentRoleName).Wait(); userManager.AddToRoleAsync(user, GlobalConstants.CanEditRecruitmentRoleName).Wait(); userManager.AddToRoleAsync(user, GlobalConstants.CanDeleteRecruitmentRoleName).Wait(); userManager.AddToRoleAsync(user, GlobalConstants.CanSeeAdminAreaRoleName).Wait(); userManager.AddToRoleAsync(user, GlobalConstants.CanBanPlayers).Wait(); } } } } }
public EfDeletableEntityRepository(FootballizeDbContext context) : base(context) { }
public EfRepository(FootballizeDbContext context) { this.Context = context ?? throw new ArgumentNullException(nameof(context)); this.DbSet = this.Context.Set <TEntity>(); }
public void Seed(FootballizeDbContext dbContext, IServiceProvider serviceProvider) { var plovdivId = dbContext.Towns.SingleOrDefault(x => x.Name.Equals("Plovdiv")).Id; var sofiaId = dbContext.Towns.SingleOrDefault(x => x.Name.Equals("Sofia")).Id; var fields = new List <Pitch> { new Pitch { Name = "Atrim Arena", Address = new Address { TownId = plovdivId, Street = "Carigradko Shose blvd.", Number = 54, Location = new Location { Latitude = 42.150069, Longitude = 24.799438 } } }, new Pitch { Name = "SC Optimum", Address = new Address { TownId = plovdivId, Street = "Asenovgradsko Shose blvd.", Number = 116, Location = new Location { Latitude = 42.125237, Longitude = 24.772354 } } }, new Pitch { Name = "Korona", Address = new Address { TownId = plovdivId, Street = "Car Simeon", Number = 158, Location = new Location { Latitude = 42.127130, Longitude = 24.781652 } } }, new Pitch { Name = "Select", Address = new Address { TownId = plovdivId, Street = "Peroshtica", Number = 6, Location = new Location { Latitude = 42.1402311, Longitude = 24.7184506 } } }, new Pitch { Name = "RD Sport", Address = new Address { TownId = sofiaId, Street = "Studentski Kompleks", Number = 1756, Location = new Location { Latitude = 42.659793, Longitude = 23.354340 } } }, new Pitch { Name = "Sofia Sport", Address = new Address { TownId = sofiaId, Street = "Fransoa Miteran", Number = 1700, Location = new Location { Latitude = 42.649877, Longitude = 23.339989 } } }, new Pitch { Name = "Arena Royal", Address = new Address { TownId = sofiaId, Street = "Dimitar Pashev", Number = 158, Location = new Location { Latitude = 42.645417, Longitude = 23.412855 } } }, new Pitch { Name = "Green Sport", Address = new Address { TownId = sofiaId, Street = "Dimitar Pashev", Number = 158, Location = new Location { Latitude = 42.676759, Longitude = 23.380542 } } } }; foreach (Pitch field in fields) { if (!dbContext.Pitches.Any(x => x.Name == field.Name)) { dbContext.Pitches.Add(field); } } }