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);
}
}
}
