public async Task <IActionResult> Statistika()
{
var user = await _userManager.GetUserAsync(HttpContext.User);
var transakcije = _transakcijaService.GetTransakcije(user);
List <DataPoint> dataPoints = new List <DataPoint>();
for (int i = 0; i < transakcije.Count; i++)
{
dataPoints.Add(new DataPoint(transakcije[i].DatumIniciranjaTransakcije.ToString(), transakcije[i].IznosTotal));
}
ViewBag.DataPoints = JsonConvert.SerializeObject(dataPoints);
var tNamirnice = _transakcijaService.GetNamirniceUTransakcijiama(user);
//var jsonSerialiser = new JavaScriptSerializer();
var json = JsonConvert.SerializeObject(tNamirnice);
ViewBag.ChartDataPie = json;
var v = new StatistikaViewModel
{
TotalVrijednost = _transakcijaService.GetTotalProtok(user),
NajvecaTransakcija = _transakcijaService.GetNajvecaTransakcija(user),
NajNamirnica = _transakcijaService.GetNajNamirnica(user),
NajPartner = _transakcijaService.GetNajPartner(user)
};
return(View(v));
}
public StatistikaView()
{
try
{
vm = new StatistikaViewModel();
this.InitializeComponent();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
//pocetna
public IActionResult PocetnaReferent()
{
StatistikaViewModel statistika = new StatistikaViewModel
{
Godina = DateTime.Now.Year - 1993,
BrojKandidata = reposKandidat.Count(),
BrojUposlenika = reposUposlenik.Count(),
BrojVozila = reposVozila.Count(),
BrojZahtjeva = reposZahtjev.Count()
};
return(View(statistika));
}
public StatistikaPopupPage(ClanNaProjektu clan)
{
this.model = new StatistikaViewModel(clan.IdKorisnik, clan.IdProjekt);
this.BindingContext = model;
InitializeComponent();
}
/// <summary>
/// generiranje podataka za stranicenje
/// </summary>
/// <param name="page"></param>
/// <param name="sort"></param>
/// <param name="ascending"></param>
/// <param name="cityCode"></param>
/// <returns></returns>
public IActionResult Index(int page = 1, int sort = 1, bool ascending = true, int?cityCode = null)
{
int pagesize = _appSettings.PageSize;
//var query = _context.Putovanje.AsNoTracking();
var query = _context.Statistika.Include(p => p.SifraOrganizacijeNavigation).Include(s => s.SifraGradaNavigation).AsNoTracking();
if (cityCode.HasValue)
{
query = query.Where(s => s.SifraGrada == cityCode.Value);
}
int count = query.Count();
var pagingInfo = new PagingInfo
{
CurrentPage = page,
Sort = sort,
Ascending = ascending,
ItemsPerPage = pagesize,
TotalItems = count
};
if (page > pagingInfo.TotalPages)
{
return(RedirectToAction(nameof(Index), new { page = pagingInfo.TotalPages, sort, ascending }));
}
System.Linq.Expressions.Expression <Func <Statistika, object> > orderSelection = null;
switch (sort)
{
case 1:
orderSelection = p => p.SifraObjave;
break;
case 2:
orderSelection = p => p.SifraGrada;
break;
case 3:
orderSelection = p => p.SifraOrganizacije;
break;
case 4:
orderSelection = p => p.BrojSlucajeva;
break;
case 5:
orderSelection = p => p.BrojAktivnih;
break;
case 6:
orderSelection = p => p.BrojUmrlih;
break;
case 7:
orderSelection = p => p.BrojIzlijecenih;
break;
}
if (orderSelection != null)
{
query = ascending ? query.OrderBy(orderSelection) : query.OrderByDescending(orderSelection);
}
var statistika = query.Skip((page - 1) * pagesize)
.Take(_appSettings.PageSize)
.ToList();
var model = new StatistikaViewModel
{
Statistika = statistika,
PagingInfo = pagingInfo
};
return(View(model));
}
public AccountPage()
{
InitializeComponent();
BindingContext = model = new StatistikaViewModel();
}
