/// <summary>
/// Tablicni prikaz sastanaka
/// </summary>
/// <param name="page">Stranica koju zelimo prikazati</param>
/// <param name="sort">Index stupca po kojem sortiramo</param>
/// <param name="ascending">Smjer sortiranja (true za uzlazno)</param>
/// <returns>novi pogled</returns>
public IActionResult Index(int page = 1, int sort = 1, bool ascending = true)
{
int pagesize = appSettings.PageSize;
var query = ctx.Sastanak.Include(z => z.SifraStozeraNavigation).AsNoTracking();
int count = query.Count();
var pagingInfo = new PagingInfo
{
CurrentPage = page,
Sort = sort,
Ascending = ascending,
ItemsPerPage = pagesize,
TotalItems = count
};
if (page > pagingInfo.TotalItems)
{
return(RedirectToAction(nameof(Index), new { page = pagingInfo.TotalPages, sort, ascending }));
}
System.Linq.Expressions.Expression <Func <Sastanak, object> > orderSelector = null;
switch (sort)
{
case 1:
orderSelector = d => d.SifraStozeraNavigation.Naziv;
break;
case 3:
orderSelector = d => d.Datum;
break;
}
if (orderSelector != null)
{
query = ascending ? query.OrderBy(orderSelector) : query.OrderByDescending(orderSelector);
}
var sastanci = query
.Select(m => new SastanakViewModel
{
NazivStozera = m.SifraStozeraNavigation.Naziv,
Datum = m.Datum,
SifraSastanka = m.SifraSastanka
})
.Skip((page - 1) * pagesize)
.Take(pagesize)
.ToList();
var model = new SastanciViewModel
{
Sastanci = sastanci,
PagingInfo = pagingInfo
};
return(View(model));
}
public SastanciPage(int Klijent)
{
InitializeComponent();
KlijentId = Klijent;
BindingContext = model = new SastanciViewModel(KlijentId);
}
