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