public static async Task SeedDataAsync(DataContext context, UserManager <User> userManager)
{
if (!context.Books.Any())
{
var bookData = System.IO.File.ReadAllText("./Data/bookData.json");
var bookList = JsonConvert.DeserializeObject <List <Book> >(bookData);
context.AddRange(bookList);
context.SaveChanges();
}
if (!context.Users.Any())
{
var users = new User[]
{
new User
{
DisplayName = "Ashik",
Email = "*****@*****.**",
UserName = "******",
Image = "https://images.unsplash.com/photo-1597792694946-85c191c617dc?crop=entropy&cs=tinysrgb&fit=crop&fm=jpg&h=400&ixlib=rb-1.2.1&q=80&w=400",
},
new User
{
DisplayName = "Pranto",
Email = "*****@*****.**",
UserName = "******",
Image = "https://images.unsplash.com/photo-1595465100655-7a340977fcb7?crop=entropy&cs=tinysrgb&fit=crop&fm=jpg&h=400&ixlib=rb-1.2.1&q=80&w=800",
}
};
foreach (var user in users)
{
await userManager.CreateAsync(user, "Passw0rd");
}
}
}
public static async Task SeedStations(IExternalClientContext clientContext, DataContext context, IMapper mapper)
{
if (await context.Stations.AnyAsync() && await context.Norms.AnyAsync())
{
return;
}
if (await context.Stations.AnyAsync() == false)
{
var stationsDTO = await clientContext.GetStationsAsync();
var communes = stationsDTO.Select(x => x.City.Commune)
.GroupBy(x => new { x.CommuneName, x.DistrictName, x.ProvinceName })
.Select(x => x.First()).ToList();
var provinces = communes.Select(x => x)
.GroupBy(x => x.ProvinceName)
.Select(x => x.First()).OrderBy(x => x.ProvinceName).Select(x => x.ProvinceName.ToUpper()).ToList();
var districts = communes.Select(x => x)
.GroupBy(x => new { x.DistrictName, x.ProvinceName })
.Select(x => x.First()).OrderBy(x => x.DistrictName).Select(x => new { x.DistrictName, x.ProvinceName }).ToList();
var cities = stationsDTO.Select(x => x.City)
.GroupBy(x => new { x.Id, x.Commune.CommuneName })
.Select(x => x.First()).OrderBy(x => x.Name).Select(x => x).ToList();
var provincesList = new List <Province>();
foreach (var provinceDTO in provinces)
{
var province = new Province()
{
Id = provinces.IndexOf(provinceDTO) + 1,
ProvinceName = provinceDTO,
Districts = new List <District>()
};
foreach (var districtDTO in districts.Where(x => x.ProvinceName.ToUpper() == province.ProvinceName))
{
var district = new District()
{
Id = districts.IndexOf(districtDTO) + 1,
DistrictName = districtDTO.DistrictName.ToUpper(),
ProvienceId = province.Id,
Communes = new List <Commune>()
};
foreach (var communeDTO in communes.Where(x => x.DistrictName.ToUpper() == district.DistrictName &&
x.ProvinceName.ToUpper() == province.ProvinceName))
{
var commune = new Commune()
{
Id = communes.IndexOf(communeDTO) + 1,
CommuneName = communeDTO.CommuneName.ToUpper(),
DistrictId = district.Id,
Cities = new List <City>()
};
foreach (var cityDTO in cities.Where(x => x.Commune.CommuneName.ToUpper() == commune.CommuneName))
{
var city = mapper.Map <City>(cityDTO);
city.Stations = stationsDTO.Where(x => x.City.Id == city.Id)
.Select(x => mapper.Map <Station>(x))
.ToList();
commune.Cities.Add(city);
}
district.Communes.Add(commune);
}
province.Districts.Add(district);
}
provincesList.Add(province);
}
context.AddRange(provincesList);
}
if (await context.Stations.AnyAsync() == false)
{
var normsData = await System.IO.File.ReadAllTextAsync("Data/NormsSeed.json");
var norms = JsonSerializer.Deserialize <List <Norm> >(normsData);
context.Norms.AddRange(norms);
}
await context.SaveChangesAsync();
}
