public async void Tragaj(int kursId, DateTime DatumOd, DateTime DatumDo)
{
lista.Clear();
lista = new List <KoPohadja>();
TragajRequest request = new TragajRequest
{
DO = DatumDo,
KursId = kursId,
OD = DatumOd
};
List <KoPohadja> listaPohadjanja = await _service_Tragaj.Get <List <KoPohadja> >(request);
foreach (var x in listaPohadjanja)
{
lista.Add(new KoPohadja
{
Ime = x.Ime,
Ocjena = x.Ocjena,
Prezime = x.Prezime
});
}
Application.Current.MainPage = new PrikazKoPolazePage(UserID, Role, lista);
}
public List <KoPohadja> Get([FromQuery] TragajRequest request)
{
var query = db.Pohadja.AsQueryable();
if (request.DO != null)
{
query = query.Where(x => x.DatumPohadjanja.Value.Year >= request.OD.Year && x.DatumPohadjanja.Value.Month >= request.OD.Month && x.DatumPohadjanja.Value.Day >= request.OD.Day);
}
if (request.OD != null)
{
query = query.Where(x => x.DatumPohadjanja.Value.Year <= request.DO.Year && x.DatumPohadjanja.Value.Month <= request.DO.Month && x.DatumPohadjanja.Value.Day <= request.DO.Day);
}
if (request.KursId > 0)
{
query = query.Where(x => x.KursId == request.KursId);
}
var lista = query.ToList();
List <KoPohadja> result = new List <KoPohadja>();
foreach (var x in lista)
{
if (x.Polozio == "Da" && x.Ocjena > 5)
{
result.Add(new Models.KoPohadja
{
Ime = db.Student.Where(a => a.StudentId == x.StudentId).Select(o => o.Ime).FirstOrDefault(),
Prezime = db.Student.Where(a => a.StudentId == x.StudentId).Select(o => o.Prezime).FirstOrDefault(),
Ocjena = x.Ocjena
});
}
}
return(result);
}
public List <KoPohadja> Get([FromQuery] TragajRequest request)
{
return(_service.Get(request));
}
