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)); }