public async Task SeedAsync(ISOOUDbContext 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(ISOOUContextSeeder));
var seeders = new List <ISeeder>
{
new RolesSeeder(),
//new UsersSeeder(),
new DistrictsSeeder(),
new SchoolsSeeder(),
new CriteriasSeeder(),
new AddressesSeeder(),
new ParentsSeeder(),
};
foreach (var seeder in seeders)
{
await seeder.SeedAsync(dbContext, serviceProvider);
await dbContext.SaveChangesAsync();
logger.LogInformation($"Seeder {seeder.GetType().Name} done.");
}
}
public async Task SeedAsync(ISOOUDbContext dbContext, IServiceProvider serviceProvider)
{
if (!dbContext.Parents.Any())
{
var address = dbContext.Addresses.FirstOrDefault();
await dbContext.Parents.AddAsync(new Parent
{
FirstName = "Друг",
MiddleName = "NA",
LastName = " ",
PhoneNumber = "08888888888",
Role = ParentRole.Друг,
AddressId = address.Id,
UCN = "0000000001",
WorkDistrict = dbContext.Districts.FirstOrDefault(n => n.Name == "Неизвестен"),
});
await dbContext.Parents.AddAsync(new Parent
{
FirstName = "Няма",
MiddleName = "NA",
LastName = " ",
PhoneNumber = "08888888888",
Role = ParentRole.Няма,
AddressId = address.Id,
UCN = "0000000002",
WorkDistrict = dbContext.Districts.FirstOrDefault(n => n.Name == "Неизвестен"),
});
}
}
public async Task SeedAsync(ISOOUDbContext dbContext, IServiceProvider serviceProvider)
{
var roleManager = serviceProvider.GetRequiredService <RoleManager <SystemRole> >();
await SeedRoleAsync(roleManager, GlobalConstants.AdministratorRoleName);
await SeedRoleAsync(roleManager, GlobalConstants.DirectorRoleName);
await SeedRoleAsync(roleManager, GlobalConstants.UserRoleName);
}
public async Task SeedAsync(ISOOUDbContext dbContext, IServiceProvider serviceProvider)
{
if (!dbContext.Addresses.Any())
{
await dbContext.Addresses.AddAsync(new AddressDetails
{
Permanent = "NA",
Current = "NA",
PermanentCity = CityName.София,
CurrentCity = CityName.София,
PermanentDistrictId = dbContext.Districts.Where(d => d.Name == "Неизвестен").FirstOrDefault().Id,
CurrentDistrictId = dbContext.Districts.Where(d => d.Name == "Неизвестен").FirstOrDefault().Id,
});
}
}
public async Task SeedAsync(ISOOUDbContext dbContext, IServiceProvider serviceProvider)
{
if (!dbContext.Districts.Any())
{
await dbContext.Districts.AddAsync(new District { Name = "Връбница" });
await dbContext.Districts.AddAsync(new District { Name = "Възраждане" });
await dbContext.Districts.AddAsync(new District { Name = "Изгрев" });
await dbContext.Districts.AddAsync(new District { Name = "Илинден" });
await dbContext.Districts.AddAsync(new District { Name = "Красна Поляна" });
await dbContext.Districts.AddAsync(new District { Name = "Красно Село" });
await dbContext.Districts.AddAsync(new District { Name = "Лозенец" });
await dbContext.Districts.AddAsync(new District { Name = "Люлин" });
await dbContext.Districts.AddAsync(new District { Name = "Младост" });
await dbContext.Districts.AddAsync(new District { Name = "Надежда" });
await dbContext.Districts.AddAsync(new District { Name = "Оборище" });
await dbContext.Districts.AddAsync(new District { Name = "Овча Купел" });
await dbContext.Districts.AddAsync(new District { Name = "Подуяне" });
await dbContext.Districts.AddAsync(new District { Name = "Сердика" });
await dbContext.Districts.AddAsync(new District { Name = "Средец" });
await dbContext.Districts.AddAsync(new District { Name = "Триадица" });
await dbContext.Districts.AddAsync(new District { Name = "Искър" });
await dbContext.Districts.AddAsync(new District { Name = "Неизвестен" });
}
}
private void SeedTestData(ISOOUDbContext context)
{
context.Schools.AddRange(this.GetTestData());
context.SaveChanges();
}
public async Task SeedAsync(ISOOUDbContext dbContext, IServiceProvider serviceProvider)
{
var userManager = serviceProvider.GetRequiredService <UserManager <SystemUser> >();
var roleManager = serviceProvider.GetRequiredService <RoleManager <SystemRole> >();
var userToSeed = await userManager.FindByNameAsync(GlobalConstants.AdministratorUsername);
var roleToSeed = (await roleManager.FindByNameAsync(GlobalConstants.AdministratorRoleName)).ToString();
if (userToSeed == null)
{
var userAdmin = new SystemUser()
{
UserName = GlobalConstants.AdministratorUsername,
Email = GlobalConstants.AdministratorEmail,
FullName = GlobalConstants.AdministratorFullName,
};
var result = await userManager.CreateAsync(userAdmin, roleToSeed);
if (!result.Succeeded)
{
throw new Exception(string.Join(Environment.NewLine, result.Errors.Select(e => e.Description)));
}
await userManager.AddToRoleAsync(userAdmin, GlobalConstants.AdministratorRoleName);
}
userToSeed = await userManager.FindByEmailAsync("*****@*****.**");
roleToSeed = (await roleManager.FindByNameAsync(GlobalConstants.UserRoleName)).ToString();
if (userToSeed == null)
{
var userIrrrka = new SystemUser()
{
UserName = "******",
Email = "*****@*****.**",
FullName = "Irina Marina",
};
var result = await userManager.CreateAsync(userIrrrka, "123123");
if (!result.Succeeded)
{
throw new Exception(string.Join(Environment.NewLine, result.Errors.Select(e => e.Description)));
}
await userManager.AddToRoleAsync(userIrrrka, roleToSeed);
}
userToSeed = await userManager.FindByEmailAsync("*****@*****.**");
roleToSeed = (await roleManager.FindByNameAsync(GlobalConstants.DirectorRoleName)).ToString();
if (userToSeed == null)
{
var userIrrrkaDir = new SystemUser
{
UserName = "******",
Email = "*****@*****.**",
FullName = "Irina Dirina",
};
var result = await userManager.CreateAsync(userIrrrkaDir, "123123");
if (!result.Succeeded)
{
throw new Exception(string.Join(Environment.NewLine, result.Errors.Select(e => e.Description)));
}
await userManager.AddToRoleAsync(userIrrrkaDir, roleToSeed);
}
userToSeed = await userManager.FindByEmailAsync("*****@*****.**");
roleToSeed = (await roleManager.FindByNameAsync(GlobalConstants.UserRoleName)).ToString();
if (userToSeed == null)
{
var userJovo = new SystemUser
{
UserName = "******",
Email = "*****@*****.**",
FullName = "Jovo Jovo",
};
var result = await userManager.CreateAsync(userJovo, "123123");
if (!result.Succeeded)
{
throw new Exception(string.Join(Environment.NewLine, result.Errors.Select(e => e.Description)));
}
await userManager.AddToRoleAsync(userJovo, roleToSeed);
}
}
public async Task SeedAsync(ISOOUDbContext dbContext, IServiceProvider serviceProvider)
{
if (!dbContext.Criterias.Any())
{
dbContext.Criterias.AddRange(
new Criteria
{
Name = nameof(GlobalConstants.ParentPermanentCitySofiaCriteria),
DisplayName = "Постоянен адрес на територията на Столична община на поне единия от родителите",
Scores = GlobalConstants.ParentPermanentCitySofiaCriteria,
},
new Criteria
{
Name = nameof(GlobalConstants.ParentCurrentCitySofiaCriteria),
DisplayName = "Настоящ адрес на територията на Столична община на поне единия от родителите",
Scores = GlobalConstants.ParentCurrentCitySofiaCriteria,
},
new Criteria
{
Name = nameof(GlobalConstants.ParentPermanentDistrictSchoolCriteria),
DisplayName = "Постоянен адрес на територията на административния район на училището на поне единия от родителите",
Scores = GlobalConstants.ParentPermanentDistrictSchoolCriteria,
},
new Criteria
{
Name = nameof(GlobalConstants.ParentCurrentDistrictSchoolCriteria),
DisplayName = "Настоящ адрес на територията на административния район на училището на поне единия от родителите",
Scores = GlobalConstants.ParentCurrentDistrictSchoolCriteria,
},
new Criteria
{
Name = nameof(GlobalConstants.MotherHasWorkCriteria),
DisplayName = "Работещ родител",
Scores = GlobalConstants.MotherHasWorkCriteria,
},
new Criteria
{
Name = nameof(GlobalConstants.FatherHasWorkCriteria),
DisplayName = "Работещ родител",
Scores = GlobalConstants.FatherHasWorkCriteria,
},
new Criteria
{
Name = nameof(GlobalConstants.ParentHasWorkInDistrictSchoolCriteria),
DisplayName = "Работещ родител в района на училището",
Scores = GlobalConstants.ParentHasWorkInDistrictSchoolCriteria,
},
new Criteria
{
Name = nameof(GlobalConstants.HasVisitKGCriteria),
DisplayName = "Дете, което е посещавало общинска детска градина, регистрирана на Столична община",
Scores = GlobalConstants.HasVisitKGCriteria,
},
new Criteria
{
Name = nameof(GlobalConstants.HasNoParentCriteria),
DisplayName = "Дете без родители",
Scores = GlobalConstants.HasNoParentCriteria,
},
new Criteria
{
Name = nameof(GlobalConstants.HasOneParentCriteria),
DisplayName = "Дете с един родител",
Scores = GlobalConstants.HasOneParentCriteria,
},
new Criteria
{
Name = nameof(GlobalConstants.HasManyBrothersOrSistersCriteria),
DisplayName = "Дете, което живее в семейство с повече деца",
Scores = GlobalConstants.HasManyBrothersOrSistersCriteria,
},
new Criteria
{
Name = nameof(GlobalConstants.HasSENCriteria),
DisplayName = "Дете със специални образователни потребности",
Scores = GlobalConstants.HasSENCriteria,
},
new Criteria
{
Name = nameof(GlobalConstants.HasDeseasCriteria),
DisplayName = "Дете с хронични заболявания",
Scores = GlobalConstants.HasDeseasCriteria,
},
new Criteria
{
Name = nameof(GlobalConstants.HasAllTheImmunizations),
DisplayName = "Дете с всички задължителни имунизации",
Scores = GlobalConstants.HasAllTheImmunizations,
});
}
}
public async Task SeedAsync(ISOOUDbContext dbContext, IServiceProvider serviceProvider)
{
if (!dbContext.Schools.Any())
{
Random random = new Random();
District currDistrict;
//"Връбница"
currDistrict = dbContext.Districts.FirstOrDefault(n => n.Name == "Връбница");
dbContext.Schools.AddRange(
new School
{
Name = "61 ОУ \"Св.св.Kирил и Методий\"",
DirectorName = "Елизабета Колева",
Email = "*****@*****.**",
PhoneNumber = "02/934-54-89",
URLOfMap = "https://www.google.com/maps/d/viewer?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.737856000000015%2C23.290851799999928&z=19",
URLOfSchool = "http://ou-61.org/",
District = currDistrict,
Address = "ул. \"Ломско шосе\" № 186",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "62 ОУ \"Христо Ботев\"",
DirectorName = "вр.и.д. Димитър Караиванов",
Email = "*****@*****.**",
PhoneNumber = "02/834-16-17",
URLOfMap = "https://www.google.com/maps/d/viewer?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.739813100000006%2C23.264302399999906&z=19",
URLOfSchool = "http://www.62ou.com/",
District = currDistrict,
Address = "кв. \"Обеля\", ул. \"Ефрем Чучков\" № 26",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "70 ОУ \"Св.Kлимент Охридски\"",
DirectorName = "Величка Таседжикова",
Email = "*****@*****.**",
PhoneNumber = "02/827-74-92",
URLOfMap = "https://www.google.com/maps/d/viewer?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.726794500000004%2C23.28269309999996&z=19",
URLOfSchool = "http://www.70ou.com/",
District = currDistrict,
Address = "ул. \"Адам Мицкевич\" № 10",
FreeSpots = random.Next(0, 101),
});
//"Възраждане"
currDistrict = dbContext.Districts.FirstOrDefault(n => n.Name == "Възраждане");
dbContext.Schools.AddRange(
new School
{
Name = "46 ОУ \"Kонстантин Фотинов\"",
DirectorName = "Маргарита Грънчарова",
Email = "*****@*****.**",
PhoneNumber = "02/831-00-49",
URLOfMap = "https://www.google.com/maps/d/viewer?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.70317129999998%2C23.316551600000025&z=19",
URLOfSchool = "http://46ou.net/",
District = currDistrict,
Address = "бул. \"Христо Ботев\" № 109",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "67 ОУ \"Васил Друмев\"",
DirectorName = "Красимир Вълков",
Email = "*****@*****.**",
PhoneNumber = "02/822-36-21",
URLOfMap = "https://www.google.com/maps/d/viewer?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.69301228461862%2C23.29787870192183&z=19",
URLOfSchool = string.Empty,
District = currDistrict,
Address = "ул. \"Гюешево\" № 63",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "76 ОУ \"Уилям Сароян\"",
DirectorName = "Емилия Стефанова",
Email = "*****@*****.**",
PhoneNumber = "02/987-43-44",
URLOfMap = "https://www.google.com/maps/d/viewer?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.698193300000014%2C23.3166966&z=19",
URLOfSchool = "http://www.76ou.eu/",
District = currDistrict,
Address = "ул. \"Братя Миладинови\" № 9",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "136 ОУ \"Любен Kаравелов\"",
DirectorName = "Галина Сахиева",
Email = "*****@*****.**",
PhoneNumber = "02/821-70-88",
URLOfMap = "https://www.google.com/maps/d/viewer?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.699712300000016%2C23.299815299999977&z=19",
URLOfSchool = string.Empty,
District = currDistrict,
Address = "ул. \"Димитър Петков\" № 116",
FreeSpots = random.Next(0, 101),
});
//"Изгрев"
currDistrict = dbContext.Districts.FirstOrDefault(n => n.Name == "Изгрев");
dbContext.Schools.AddRange(
new School
{
Name = "11 ОУ \"Св.Пимен Зографски\"",
DirectorName = "Августина Петрова",
Email = "*****@*****.**",
PhoneNumber = "02/862-41-87",
URLOfMap = "https://www.google.com/maps/d/viewer?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.66289210000002%2C23.343448500000022&z=19",
URLOfSchool = "http://11oy.com",
District = currDistrict,
Address = "ул. \"Никола Габровски\" № 22",
FreeSpots = random.Next(0, 101),
});
//"Илинден"
currDistrict = dbContext.Districts.FirstOrDefault(n => n.Name == "Илинден");
dbContext.Schools.AddRange(
new School
{
Name = "43 ОУ \"Христо Смирненски\"",
DirectorName = "Сергей Богачев",
Email = "*****@*****.**",
PhoneNumber = "02/822-92-7",
URLOfMap = "https://www.google.com/maps/d/viewer?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.707044399999994%2C23.30130699999995&z=19",
URLOfSchool = "http://43ou.net/",
District = currDistrict,
Address = "бул. \"Сливница\" № 45",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "45 ОУ \"Kонстантин Величков\"",
DirectorName = "Светла Стефанова",
Email = "*****@*****.**",
PhoneNumber = "02/822-14-10",
URLOfMap = "https://www.google.com/maps/d/viewer?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.711020299999994%2C23.296346800000038&z=19",
URLOfSchool = "http://www.45ou.bg/",
District = currDistrict,
Address = "ул.\"Пловдив\" № 20",
FreeSpots = random.Next(0, 101),
});
//"Искър"
currDistrict = dbContext.Districts.FirstOrDefault(n => n.Name == "Искър");
dbContext.Schools.AddRange(
new School
{
Name = "4 ОУ \"Проф.Джон Атанасов\"",
DirectorName = "Галина Шипкалиева",
Email = "*****@*****.**",
PhoneNumber = "02/979-09-63",
URLOfMap = "https://www.google.com/maps/d/u/0/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.6603857095304%2C23.398583349061255&z=19",
URLOfSchool = "http://4ou.clients.info-top.com/",
District = currDistrict,
Address = "ул. \"Тирана\" № 12",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "89 ОУ \"Д - р Христо Стамболски\"",
DirectorName = "Тотка Цветанова",
Email = "*****@*****.**",
PhoneNumber = "02/979-08-38",
URLOfMap = "https://www.google.com/maps/d/u/0/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.66520490176343%2C23.394650667105452&z=19",
URLOfSchool = "http://www.89ousofia.com/",
District = currDistrict,
Address = "ж.к. \"Дружба - 1\", ул. \"Чудомир Топлодолски\" № 4",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "150 ОУ \"Цар Симеон I\"",
DirectorName = "Радослав Богданов",
Email = "*****@*****.**",
PhoneNumber = "02/879-67-63",
URLOfMap = "https://www.google.com/maps/d/u/0/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.64591895912879%2C23.409892094368388&z=19",
URLOfSchool = "http://www.150ou.org/",
District = currDistrict,
Address = "ж.к. \"Дружба - 2\", ул. \"Делийска воденица\" № 11",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "163 ОУ \"Черноризец Храбър\"",
DirectorName = "Катя Дойнова",
Email = "*****@*****.**",
PhoneNumber = "02/978-07-2",
URLOfMap = "https://www.google.com/maps/d/u/0/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.64451777594269%2C23.40535987554597&z=19",
URLOfSchool = "http://163ou.org/",
District = currDistrict,
Address = "ж.к. \"Дружба - 2\", ул. \"Обиколна\" № 36",
FreeSpots = random.Next(0, 101),
});
//"Лозенец"
currDistrict = dbContext.Districts.FirstOrDefault(n => n.Name == "Лозенец");
dbContext.Schools.AddRange(
new School
{
Name = "122 ОУ \"Николай Лилиев\"",
DirectorName = "Ивета Германова",
Email = "*****@*****.**",
PhoneNumber = "02/865-03-74",
URLOfMap = "https://www.google.com/maps/place/ul.+%22Prezviter+Kozma%22+2,+1421+g.k.+Lozenets,+Sofia/data=!4m2!3m1!1s0x40aa85aa7c2887f3:0x51107996835ba355?sa=X&ved=2ahUKEwiEhZvthK3jAhWKIZoKHTNACGgQ8gEwAHoECAoQAQ",
URLOfSchool = "https://122ou.com/",
District = currDistrict,
Address = "ул. \"Презвитер Козма\" 2",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "107 ОУ \"Хан Крум\"",
DirectorName = "Иванка Маринова",
Email = "*****@*****.**",
PhoneNumber = "02/866-20-29",
URLOfMap = "https://www.google.com/maps/d/viewer?ll=42.676406987939345%2C23.329929603647884&z=19&mid=1xYlSUjydIF6BL8ONgmjDwTpoymw",
URLOfSchool = "http://www.107ou.com/",
District = currDistrict,
Address = "ул. \"Димитър Димов\" № 13",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "120 ОУ \"Георги С. Раковски\"",
DirectorName = "Цветанка Тонева",
Email = "*****@*****.**",
PhoneNumber = "02/866-56-80",
URLOfMap = "https://www.google.com/maps/d/viewer?ll=42.683467139210094%2C23.324429079739616&z=19&mid=1xYlSUjydIF6BL8ONgmjDwTpoymw",
URLOfSchool = "http://www.daskalo.com/ou120/",
District = currDistrict,
Address = "ул. \"Папа Йоан Павел II\" № 7\"",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "139 ОУ \"Захарий Kруша\"",
DirectorName = "Румяна Дончева",
Email = "*****@*****.**",
PhoneNumber = "02/866-77-41",
URLOfMap = "https://www.google.com/maps/d/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.67561873535963%2C23.316023605169903&z=19",
URLOfSchool = "http://139ou.com/",
District = currDistrict,
Address = "ул. \"Димитър Хаджикоцев\" № 44",
FreeSpots = random.Next(0, 101),
});
//"Люлин"
currDistrict = dbContext.Districts.FirstOrDefault(n => n.Name == "Люлин");
dbContext.Schools.AddRange(
new School
{
Name = "33 ОУ \"Санкт Петербург\"",
DirectorName = "Юлия Георгиева",
Email = "*****@*****.**",
PhoneNumber = "02/824-88-23",
URLOfMap = "https://www.google.com/maps/d/viewer?ll=42.71960002000201%2C23.247150345941122&z=19&mid=1xYlSUjydIF6BL8ONgmjDwTpoymw",
URLOfSchool = "http://33ou-lulin.org/",
District = currDistrict,
Address = "ж.к. \"Люлин - 3\" ул. \"309\" № 8",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "77 ОУ \"Kирил и Методий\"",
DirectorName = "Огнян Халембаков",
Email = "*****@*****.**",
PhoneNumber = "02/826-41-63",
URLOfMap = "https://www.google.com/maps/d/viewer?ll=42.719186198461195%2C23.22077131558069&z=19&mid=1xYlSUjydIF6BL8ONgmjDwTpoymw",
URLOfSchool = "https://www.77ousofia.com/",
District = currDistrict,
Address = "ул. \"3 март\" № 45",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "103 ОУ \"Васил Левски\"",
DirectorName = "Милена Бенкова",
Email = "*****@*****.**",
PhoneNumber = "02/824-48-85",
URLOfMap = "https://www.google.com/maps/d/viewer?ll=42.71950062210194%2C23.232491870336844&z=19&mid=1xYlSUjydIF6BL8ONgmjDwTpoymw",
URLOfSchool = "http://103ouvasillevski.bg/",
District = currDistrict,
Address = "ж.к. \"Филиповци\"",
FreeSpots = random.Next(0, 101),
});
//"Младост"
currDistrict = dbContext.Districts.FirstOrDefault(n => n.Name == "Младост");
dbContext.Schools.AddRange(
new School
{
Name = "145 ОУ \"Симеон Радев\"",
DirectorName = "Антоанета Михайлова",
Email = "*****@*****.**",
PhoneNumber = "02/877-41-36",
URLOfMap = "https://www.google.com/maps/d/viewer?ll=42.6483661337137%2C23.38520513106971&z=19&mid=1xYlSUjydIF6BL8ONgmjDwTpoymw",
URLOfSchool = "http://145ou.com/",
District = currDistrict,
Address = "ж.к. \"Младост - 1А\", ул. \"Ресен\" № 1",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "82 ОУ \"Васил Априлов\"",
DirectorName = "Мартин Ганчев",
Email = "*****@*****.**",
PhoneNumber = "02/973-60-40",
URLOfMap = "https://www.google.com/maps/d/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.63069408126569%2C23.4095511607984&z=19",
URLOfSchool = "",
District = currDistrict,
Address = "кв. Горубляне, ул. \"Самоковско шосе\" № 41",
FreeSpots = random.Next(0, 101),
});
//"Надежда"
currDistrict = dbContext.Districts.FirstOrDefault(n => n.Name == "Надежда");
dbContext.Schools.AddRange(
new School
{
Name = "98 НУ \"Св.св.Kирил и Методий\"",
DirectorName = "Антоанета Михайлова",
Email = "*****@*****.**",
PhoneNumber = "02/938-31-49",
URLOfMap = "https://www.google.com/maps/d/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.751002174446086%2C23.316778199507553&z=19",
URLOfSchool = "http://nu98.org/",
District = currDistrict,
Address = "кв. \"Илиянци\", ул. \"Махония\" № 2",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "102 ОУ \"Панайот Волов\"",
DirectorName = "Румяна-Колева",
Email = "*****@*****.**",
PhoneNumber = "02/938-26-54",
URLOfMap = "https://www.google.com/maps/d/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.735155932950846%2C23.305273285457247&z=19",
URLOfSchool = "http://102ou.com/",
District = currDistrict,
Address = "ж.к. \"Надежда - 4\", ул. \"Звезда\" № 3",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "141 OУ \"Народни будители\"",
DirectorName = "Таня Иванова",
Email = "*****@*****.**",
PhoneNumber = "02/896-01-00",
URLOfMap = "https://www.google.com/maps/d/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.73851124007748%2C23.30841111339157&z=19",
URLOfSchool = "http://141ou.com/",
District = currDistrict,
Address = "ж.к. \"Свобода\", ул. \"Народни будители\"",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "63 ОУ \"Христо Ботев\"",
DirectorName = "Карамфилка Новачкова",
Email = "*****@*****.**",
PhoneNumber = "02/938-29-26",
URLOfMap = "https://www.google.com/maps/d/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.774428881099816%2C23.31212821630595&z=19",
URLOfSchool = "http://www.63ou-hbotev.org/",
District = currDistrict,
Address = "кв. \"Требич\", ул. \"Леденика\" № 12",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "16 ОУ \"Райко Жинзифов\"",
DirectorName = "Елизабет Иванова",
Email = "*****@*****.**",
PhoneNumber = "02/938-28-90",
URLOfMap = "https://www.google.com/maps/d/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.72596450029161%2C23.300098708440032&z=19",
URLOfSchool = string.Empty,
District = currDistrict,
Address = "ул. \"Дравски бой\" № 7",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "ЦПЛР - Център за изкуства, култура и образование \"София\"",
DirectorName = "Марияна Тафрова",
Email = "*****@*****.**",
PhoneNumber = "02/936-07-67",
URLOfMap = "https://www.google.com/maps/d/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.73274500400355%2C23.30812911725434&z=19",
URLOfSchool = "http://www.stcrd.com/",
District = currDistrict,
Address = "ж.к. \"Надежда-2\", ул. \"Св. Никола Нови\" № 22",
FreeSpots = random.Next(0, 101),
});
//"Оборище"
currDistrict = dbContext.Districts.FirstOrDefault(n => n.Name == "Оборище");
dbContext.Schools.AddRange(
new School
{
Name = "112 ОУ \"Стоян Заимов\"",
DirectorName = "Жанета Бранкова",
Email = string.Empty,
PhoneNumber = "02/846-73-25",
URLOfMap = "https://www.google.com/maps/d/viewer?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.69816480820887%2C23.33719763505701&z=19",
URLOfSchool = "http://112ou.org/index.php",
District = currDistrict,
Address = "бул. \"Княз Ал.Дондуков\" № 60",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "129 ОУ \"Антим - I\"",
DirectorName = "Богдана Николова",
Email = "*****@*****.**",
PhoneNumber = "02/944-43-51",
URLOfMap = "https://www.google.com/maps/d/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.693452852602846%2C23.34729604338804&z=19",
URLOfSchool = "http://129ou-sofia.eu/",
District = currDistrict,
Address = "ул. \"Султан тепе\" № 1",
FreeSpots = random.Next(0, 101),
});
//"Подуяне"
currDistrict = dbContext.Districts.FirstOrDefault(n => n.Name == "Подуяне");
dbContext.Schools.AddRange(
new School
{
Name = "199 ОУ \"Св.ап.Йоан Богослов\"",
DirectorName = "Мони Иванов",
Email = "*****@*****.**",
PhoneNumber = "02/946 6956",
URLOfMap = "https://www.google.com/maps/d/u/0/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.713865451563215%2C23.37781863246937&z=19",
URLOfSchool = "http://ou-199.webnode.com/",
District = currDistrict,
Address = "ж.к. \"Левски - Г\", ул. \"Поручик Г.Кюмюрджиев\" № 30",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "143 ОУ \"Георги Бенковски\"",
DirectorName = "Ирена Дойчинова",
Email = "*****@*****.**",
PhoneNumber = "02/846-51-67",
URLOfMap = "https://www.google.com/maps/d/u/0/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.702579461397676%2C23.355941619998248&z=19",
URLOfSchool = "http://www.143ou.com/",
District = currDistrict,
Address = "ул. \"Тодорини кукли\" № 9",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "106 ОУ \"Григорий Цамблак\"",
DirectorName = "Ирена Цукева",
Email = "*****@*****.**",
PhoneNumber = "02/945-28-79",
URLOfMap = "https://www.google.com/maps/d/u/0/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.69955171681993%2C23.38172047016087&z=19",
URLOfSchool = "http://www.106ou.info/",
District = currDistrict,
Address = "ул. \"Григорий Цамблак\" № 18",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "49 ОУ \"Бенито Хуарес\"",
DirectorName = "Яница Милева",
Email = "*****@*****.**",
PhoneNumber = "02/847-22-40",
URLOfMap = "https://www.google.com/maps/d/u/0/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.700953185764774%2C23.36254368075197&z=19",
URLOfSchool = "http://www.49ousofia.com/",
District = currDistrict,
Address = "ул. \"Константин Фотинов\" № 4",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "42 ОУ \"Хаджи Димитър\"",
DirectorName = "Жулиета Александрова",
Email = "*****@*****.**",
PhoneNumber = "02/840-34-58",
URLOfMap = "https://www.google.com/maps/d/u/0/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.7063196653868%2C23.345321196114583&z=19",
URLOfSchool = "http://www.42ou.com/",
District = currDistrict,
Address = "ул. \"Ген.Липранди\" № 5",
FreeSpots = random.Next(0, 101),
});
//"Триадица"
currDistrict = dbContext.Districts.FirstOrDefault(n => n.Name == "Триадица");
dbContext.Schools.AddRange(
new School
{
Name = "20 ОУ \"Тодор Минков\"",
DirectorName = "Анелия Андреева",
Email = "*****@*****.**",
PhoneNumber = "02/954-91-64",
URLOfMap = "https://www.google.com/maps/d/viewer?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.688706471214175%2C23.3153743882217&z=19",
URLOfSchool = "http://20ou.com/",
District = currDistrict,
Address = "ул. \"Kняз Борис I\" № 27",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "41 ОУ \"Св.Патриарх Евтимий\"",
DirectorName = "Александра Топалова",
Email = "*****@*****.**",
PhoneNumber = "02/987-88-47",
URLOfMap = "https://www.google.com/maps/d/viewer?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.69248831417614%2C23.31688174914325&z=19",
URLOfSchool = "http://www.41ou.com/",
District = currDistrict,
Address = "ул. \"Цар Самуил\" № 24",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "104 ОУ \"Захари Стоянов\"",
DirectorName = "Капка Велинова",
Email = "*****@*****.**",
PhoneNumber = "02/859-51-92",
URLOfMap = "https://www.google.com/maps/d/viewer?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.66540256404757%2C23.29758707546307&z=19",
URLOfSchool = "http://104ou.com/",
District = currDistrict,
Address = "ул. \"Костенски водопад\" № 60",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "126 ОУ \"Петко Ю.Тодоров\"",
DirectorName = "Росен Димитров",
Email = "*****@*****.**",
PhoneNumber = "02/859-61-29",
URLOfMap = "https://www.google.com/maps/d/viewer?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.67361418239139%2C23.2964169355821&z=19",
URLOfSchool = "http://www.126ou.net/",
District = currDistrict,
Address = "бул. \"България\" № 43",
FreeSpots = random.Next(0, 101),
});
//"Средец"
currDistrict = dbContext.Districts.FirstOrDefault(n => n.Name == "Средец");
dbContext.Schools.AddRange(
new School
{
Name = "6 ОУ \"Граф Игнатиев\"",
DirectorName = "Ивелина Спасова",
Email = "*****@*****.**",
PhoneNumber = "02/988-17-13",
URLOfMap = "https://www.google.com/maps/d/viewer?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.69071236506488%2C23.326956062040722&z=19",
URLOfSchool = "http://www.6ou.org/",
District = currDistrict,
Address = "ул. \"6 - ти септември\" № 16",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "38 ОУ \"Васил Априлов\"",
DirectorName = "Виолета Игова",
Email = "*****@*****.**",
PhoneNumber = "02/846-53-58",
URLOfMap = "https://www.google.com/maps/d/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.693452852602846%2C23.34729604338804&z=19",
URLOfSchool = "http://129ou-sofia.eu/",
District = currDistrict,
Address = "ул. \"Шипка\" № 40",
FreeSpots = random.Next(0, 101),
});
//"Сердика"
currDistrict = dbContext.Districts.FirstOrDefault(n => n.Name == "Сердика");
dbContext.Schools.AddRange(
new School
{
Name = "48 ОУ \"Йосиф Kовачев\"",
DirectorName = "Даниела Костова",
Email = "*****@*****.**",
PhoneNumber = "02/831-30-87",
URLOfMap = "https://www.google.com/maps/d/u/0/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.707549538831614%2C23.31991750638224&z=19",
URLOfSchool = "http://48ou.net/ekip.html",
District = currDistrict,
Address = "ул. \"Kлокотница\" № 21",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "58 ОУ \"Сергей Румянцев\"",
DirectorName = "Костадин Мустайков",
Email = "*****@*****.**",
PhoneNumber = "02/936-67-55",
URLOfMap = "https://www.google.com/maps/d/u/0/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.725045292515134%2C23.338714672431365&z=19",
URLOfSchool = "http://58ou.net/",
District = currDistrict,
Address = "ул. \"Железопътна\" № 65",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "59 ОУ \"Васил Левски\"",
DirectorName = "Марияна Божкова",
Email = "*****@*****.**",
PhoneNumber = "02/936-67-16",
URLOfMap = "https://www.google.com/maps/d/u/0/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.71625383537773%2C23.346681445945933&z=19",
URLOfSchool = "http://59-ou-vasil-levski.webnode.com/",
District = currDistrict,
Address = "ул. \"Кестен\" № 1",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "60 ОУ \"Св.св.Kирил и Методий\"",
DirectorName = "Таня Борисова",
Email = "*****@*****.**",
PhoneNumber = "02/936-68-75",
URLOfMap = "https://www.google.com/maps/d/u/0/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.74206103961984%2C23.344054861202494&z=19",
URLOfSchool = "http://www.60ou.org/",
District = currDistrict,
Address = "ул. \"Hаука\" № 2",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "100 ОУ \"Hайден Геров\"",
DirectorName = "Румяна Темелкова",
Email = "*****@*****.**",
PhoneNumber = "02/931-60-53",
URLOfMap = "https://www.google.com/maps/d/u/0/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.7145323305044%2C23.301612847306274&z=19",
URLOfSchool = "http://www.100oung.com/",
District = currDistrict,
Address = "ул. \"Иван Йосифов\" № 68",
FreeSpots = random.Next(0, 101),
});
//"Красна поляна"
currDistrict = dbContext.Districts.FirstOrDefault(n => n.Name == "Красна Поляна");
dbContext.Schools.AddRange(
new School
{
Name = "75 ОУ \"Тодор Kаблешков\"",
DirectorName = "Антон Сивков",
Email = "*****@*****.**",
PhoneNumber = "02/822-15-67",
URLOfMap = "https://www.google.com/maps/d/u/0/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.69262072002462%2C23.26639706369815&z=19",
URLOfSchool = "http://www.75ou.com/",
District = currDistrict,
Address = "кв. \"Факултета\", ул. \"Възкресение\" № 151",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "92 ОУ \"Димитър Талев\"",
DirectorName = "Красимира Орсова",
Email = "*****@*****.**",
PhoneNumber = "02/828-47-33",
URLOfMap = "https://www.google.com/maps/d/u/0/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.693349743694945%2C23.279738853631216&z=19",
URLOfSchool = "http://www.92dimitartalev.com/",
District = currDistrict,
Address = "ж.к. \"Красна поляна\", ул. \"Добротич\" № 21",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "147 ОУ \"Йордан Радичков\"",
DirectorName = "Людмил Лачев",
Email = "*****@*****.**",
PhoneNumber = "02/920-80-89",
URLOfMap = "https://www.google.com/maps/d/u/0/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.698796019217816%2C23.292626518133147&z=19",
URLOfSchool = "http://www.147ou.info/",
District = currDistrict,
Address = "ж.к. \"Разсадника\",ул. \"Д - р Калинков\" № 40",
FreeSpots = random.Next(0, 101),
});
//"Красо село"
currDistrict = dbContext.Districts.FirstOrDefault(n => n.Name == "Красно Село");
dbContext.Schools.AddRange(
new School
{
Name = "25 ОУ \"Д - р Петър Берон\"",
DirectorName = "Надка Христова",
Email = "*****@*****.**",
PhoneNumber = "02/952-11-70",
URLOfMap = "https://www.google.com/maps/d/u/0/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.68138061779841%2C23.286544575223047&z=19",
URLOfSchool = "http://www.25ou.com/",
District = currDistrict,
Address = "ул. \"Балканджи Йово\" № 22",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "34 ОУ \"Стою Шишков\"",
DirectorName = "Цеца Тонева",
Email = "*****@*****.**",
PhoneNumber = "02/859-41-31",
URLOfMap = "https://www.google.com/maps/d/u/0/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.67070518505562%2C23.28634877396496&z=19",
URLOfSchool = "http://www.34ou.org/",
District = currDistrict,
Address = "ул. \"Родопски извор\" № 43",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "142 ОУ с РЧО \"Веселин Ханчев\"",
DirectorName = "Юлияна Петрова",
Email = "*****@*****.**",
PhoneNumber = "02/955-58-34",
URLOfMap = "https://www.google.com/maps/d/u/0/edit?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.672844367665505%2C23.28047521592964&z=19",
URLOfSchool = "http://142ou.org/",
District = currDistrict,
Address = "ул. \"Пчела\" № 21",
FreeSpots = random.Next(0, 101),
});
//"Овча купел"
currDistrict = dbContext.Districts.FirstOrDefault(n => n.Name == "Овча Купел");
dbContext.Schools.AddRange(
new School
{
Name = "53 ОУ \"Hиколай Хрелков\"",
DirectorName = "Малинка Дилова Левакова",
Email = "*****@*****.**",
PhoneNumber = "02/957-69-59",
URLOfMap = "https://www.google.com/maps/d/viewer?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.67705771188079%2C23.23386114729078&z=19",
URLOfSchool = "http://53ou.com/",
District = currDistrict,
Address = "кв. \"Горна баня\",ул. \"Обзор\" № 6",
FreeSpots = random.Next(0, 101),
},
new School
{
Name = "72 ОУ \"Христо Ботев\"",
DirectorName = "вр.и.д. Евелина Иванова",
Email = "*****@*****.**",
PhoneNumber = "02/929-53-50",
URLOfMap = "https://www.google.com/maps/d/viewer?mid=1xYlSUjydIF6BL8ONgmjDwTpoymw&ll=42.69490282713998%2C23.225142981020326&z=19",
URLOfSchool = "http://ou72.org/",
District = currDistrict,
Address = "кв. \"Суходол\",ул. \"Овче поле\" № 14",
FreeSpots = random.Next(0, 101),
});
}
}
public EfRepository(ISOOUDbContext context)
{
this.Context = context ?? throw new ArgumentNullException(nameof(context));
this.DbSet = this.Context.Set <TEntity>();
}
public EfDeletableEntityRepository(ISOOUDbContext context)
: base(context)
{
}
