public ActionResult Lista(int nalogid) { //this.repo.find("Dokument?entitet=" + entitet + "&entitetopis=" + entitetoipis + "&entitetid" + entitet) try { Zapis zapis = null; RadniNalog nalog = null; Korisnik odobrio = null; var docs = _session.QueryOver(() => zapis) .JoinAlias(x => x.RadniNalog, () => nalog) .Left.JoinAlias(x => x.Odobrio, () => odobrio) .Where(x => !x.Obrisan) .And(x => x.RadniNalog.Id == nalogid); ZapisDto result = null; var obj = docs.SelectList(list => list .Select(p => p.Id).WithAlias(() => result.Id) .Select(p => p.Rbr).WithAlias(() => result.Rbr) .Select(p => p.Opis).WithAlias(() => result.Opis) .Select(p => p.FileName).WithAlias(() => result.FileName) .Select(p => p.DateLastModified).WithAlias(() => result.DateLastModified) .Select(p => p.DateCreated).WithAlias(() => result.DateUploaded) .Select(p => p.Size).WithAlias(() => result.Size) .Select(p => p.Broj).WithAlias(() => result.Broj) .Select(p => p.Vrsta).WithAlias(() => result.Vrsta) .Select(p => p.Oznaka).WithAlias(() => result.Oznaka) .Select(p => p.Odobreno).WithAlias(() => result.Odobreno) .Select(p => p.Datum).WithAlias(() => result.Datum) .Select(p => p.DatumOdobrenja).WithAlias(() => result.DatumOdobrenja) .Select(p => p.Odobrio).WithAlias(() => result.Odobrio) ) .TransformUsing(Transformers.AliasToBean <ZapisDto>()) .List <ZapisDto>(); return(Json(new { Success = true, Message = "", obj = obj })); } catch (Exception ex) { _logger.LogError(ex.Message); return(Json(new { Success = false, Message = ex.Message })); } }
public KendoResult <ZapisDto> ListaSvi([FromBody] KendoRequest kr) { //this.repo.find("Dokument?entitet=" + entitet + "&entitetopis=" + entitetoipis + "&entitetid" + entitet) Zapis zapis = null; RadniNalog radniNalog = null; Korisnik odobrio = null; Ponuda Ponuda = null; Klijent Klijent = null; var upit = _session.QueryOver <Zapis>(() => zapis) .JoinAlias(x => x.RadniNalog, () => radniNalog) .JoinAlias(() => radniNalog.Ponuda, () => Ponuda) .JoinAlias(() => Ponuda.Klijent, () => Klijent) //.Left.JoinAlias(x => x.Odobrio, () => odobrio) .Where(x => !x.Obrisan); if (kr.Sort.Any()) { foreach (Sort sort in kr.Sort) { string prop = sort.Field.FirstCharToUpper(); //textInfo.ToTitleCase(sort.Field); upit.UnderlyingCriteria.AddOrder(new Order(prop, sort.Dir.ToLower() == "asc")); } } if (kr.PageSize != 0) { upit.Skip(kr.Skip); upit.Take(kr.Take); } ZapisDto result = null; var obj = upit.SelectList(list => list .Select(p => p.Id).WithAlias(() => result.Id) .Select(p => p.Rbr).WithAlias(() => result.Rbr) .Select(p => p.Opis).WithAlias(() => result.Opis) .Select(p => p.FileName).WithAlias(() => result.FileName) .Select(p => p.DateLastModified).WithAlias(() => result.DateLastModified) .Select(p => p.DateCreated).WithAlias(() => result.DateUploaded) .Select(p => p.Size).WithAlias(() => result.Size) .Select(p => p.Broj).WithAlias(() => result.Broj) .Select(p => p.Vrsta).WithAlias(() => result.Vrsta) .Select(p => p.Oznaka).WithAlias(() => result.Oznaka) .Select(p => p.Odobreno).WithAlias(() => result.Odobreno) .Select(p => p.Datum).WithAlias(() => result.Datum) .Select(p => p.DatumOdobrenja).WithAlias(() => result.DatumOdobrenja) .Select(p => p.Odobrio).WithAlias(() => result.Odobrio) .Select(p => p.RadniNalog).WithAlias(() => result.RadniNalog) //.Select(() => ponuda).WithAlias(() => result.Ponuda) ); upit.Future <ZapisDto>(); upit.TransformUsing(new AliasToBeanResultTransformer(typeof(ZapisDto))); var rowcount = upit.ToRowCountQuery(); rowcount.Select(Projections.Count(Projections.Id())); var redova = rowcount.FutureValue <int>().Value; var lista = upit.List <ZapisDto>(); var res = new KendoResult <ZapisDto> { Data = lista, Total = redova }; return(res); }