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