private async void InitData()
{
StatesList = Enum.GetValues(typeof(State)).Cast <State>().ToList();
_immutableStylesList = (await _stylesManager.GetStyles()).ToList();
StylesList = _immutableStylesList.ToList();
_immutableArchitectsList = (await _architectsManager.GetArchitects()).ToList();
ArchitectsList = (await _architectsManager.GetArchitects()).ToList();
}
private static async Task FillStyles()
{
IList <Style> styles = (await _stylesManager.GetStyles()).ToList();
if (styles != null && styles.Any())
{
return;
}
await _stylesManager.AddStyle(new Style("Style1", "Russia", "Kakaya-to1"));
await _stylesManager.AddStyle(new Style("Style2", "Ukraine", "Kakaya-to2"));
await _stylesManager.AddStyle(new Style("Style3", "Russia", "Kakaya-to3"));
await _stylesManager.AddStyle(new Style("Style4", "Russia", "Kakaya-to4"));
await _stylesManager.AddStyle(new Style("Style5", "Ukraine", "Kakaya-to5"));
await _stylesManager.AddStyle(new Style("Style6", "Russia", "Kakaya-to6"));
}
private async void LoadData()
{
_architectures = (await _architecturesManager.GetArchitectures()).ToList();
_repairs = (await _repairsManager.GetRepairs()).ToList();
_styles = (await _stylesManager.GetStyles()).ToList();
var groupedByCountryList = _architectures.OrderBy(e => e.Country).GroupBy(ar => ar.Country);
foreach (var element in groupedByCountryList)
{
var groupedByStateList = element.GroupBy(e => e.State)
.Select(f1 => (object)new
{
Страна = element.Key,
Состояние = f1.Key.ToString(),
Количество_сооружений = f1.Count()
});
foreach (var arch in groupedByStateList)
{
_architectureCountryStateList.Add(arch);
}
}
var groupedByArchList = _architectures.OrderBy(e => e.Architect.Surname)
.GroupBy(ar => ar.Architect.Surname);
foreach (var element in groupedByArchList)
{
var architectureArchStyleList = element.GroupBy(e => e.Style)
.Select(f1 => (object)new
{
Архитектор = element.Key,
Стиль = f1.Key.Title,
Количество_сооружений = f1.Count()
});
foreach (var arch in architectureArchStyleList)
{
_architectureArchStyleList.Add(arch);
}
}
var groupedByDateList = _repairs.OrderByDescending(e => e.RestorationDate.Year)
.GroupBy(ar => ar.RestorationDate.Year);
foreach (var element in groupedByDateList)
{
var dateRestorList = element.GroupBy(e => e.RestorationKind)
.Select(f1 => (object)new
{
Год_реставрации = element.Key.ToString(),
Вид_реставрации = f1.Key.ToString(),
Количество_сооружений = f1.Count()
});
foreach (var arch in dateRestorList)
{
_restorationKindList.Add(arch);
}
}
foreach (var element in groupedByDateList)
{
var dateSumRepairList = element.GroupBy(e => e.RestorationDate.Year)
.Select(f1 => (object)new
{
Год_реставрации = element.Key.ToString(),
Количество_ремонтов = element.Count(),
Количество_сооружений = element.Select(ar => ar.ArchitectureId).Distinct().Count(),
Потраченная_сумма = element.Sum(r => r.RestorationCost)
});
foreach (var arch in dateSumRepairList)
{
_dateSumRepairList.Add(arch);
}
}
}
private async void LoadData()
{
StyleList = new ObservableCollection <StyleModel>(await _stylesManager.GetStyles());
}
