public async Task <bool> SaveAll()
{
return(await _context.SaveChangesAsync() > 0);
}
public async Task <bool> Complete()
{
return(await context.SaveChangesAsync() > 0);
}
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();
}
public async Task <bool> SaveAllAsync()
{
return(await _context.SaveChangesAsync() > 0); //if changes saved return integer > 0
}
public async Task <bool> SaveAllAsync()
{
// return true if 1 or more changes is been saved, else false
return(await _contaxt.SaveChangesAsync() > 0);
}
public async void AddClass(Class clas)
{
_context.Classes.Add(clas);
await _context.SaveChangesAsync();
}
public async Task <bool> SaveAllAsync()
{
//because of this function returns int - number of changes rows in DB,
//if it returns number greater than zero its saved something
return(await _context.SaveChangesAsync() > 0);
}
public async Task <bool> SaveAllAsync()
{
// The number of changes that has been saved to the database
return(await _context.SaveChangesAsync() > 0);
}