public async Task <List <StatSheetItemViewModel> > GetAll() { List <StatSheetItemViewModel> result = new List <StatSheetItemViewModel>(); for (int year = 2019; year < 2021; year++) { for (int month = 1; month < 13; month++) { var point = new DbConnector.DbContext(_connStr).GetStats(year, month); result.Add(Convert(point)); } } return(result); }
public async Task <List <StatPolarItemViewModel> > GetAll() { List <StatPolarItemViewModel> result = new List <StatPolarItemViewModel>(); for (int year = 2019; year < 2021; year++) { for (int month = 1; month < 13; month++) { var point = new DbConnector.DbContext(_connStr).GetStatPolar(year, month); result.Add(Convert(point)); } } result = result.OrderByDescending(r => r.year).ThenByDescending(r => r.month).ToList(); for (int i = 0; i < result.Count - 1; i++) { result[i].percentage = (((float)result[i].shopware / (float)result[i + 1].shopware) * 100) - 100; } return(result); }
public async Task <List <DataSheetItemViewModel> > GetAll() { var result = new DbConnector.DbContext(_connStr).Get().Select(r => Convert(r)).ToList(); return(result); }