public IActionResult Get(QueryArgsBase args) { var res = db.EducationForms .Sort(args) .AsNoTracking() .ToList(); return(Ok(res)); }
public IActionResult Get(QueryArgsBase args) { var res = db.Groups .Filter(Request.Query.ToList()) .Sort(args) .AsNoTracking() .ToList(); return(Ok(res)); }
public IActionResult Get(int id, QueryArgsBase args) { var res = db.PgTypes .Where(x => x.PgKindId == id && x.InArchive == false) .Sort(args) .AsNoTracking() .ToList(); return(Ok(res)); }
public IActionResult Get(int specialityId, QueryArgsBase args) { var res = db.Groups .Where(x => x.SpecialityId == specialityId) .Filter(Request.Query.ToList()) .Sort(args) .AsNoTracking() .ToList(); return(Ok(res)); }
public IActionResult Get(QueryArgsBase args) { IQueryable <School> query = db.Schools.AsQueryable(); if (args.q != null) { query = query.Where(x => x.Name.Contains(args.q)); } var res = query .Sort(args) .AsNoTracking() .PaginateResult(args); return(Json(res)); }
public IActionResult Get(QueryArgsBase args) { IQueryable <Organization> query = db.Organizations.AsQueryable(); if (args.q != null) { query = query.Where(x => x.Name.Contains(args.q)); } var res = query.Filter(Request.Query.ToList()) .Sort(args) .AsNoTracking() .PaginateResult(args); return(Json(res)); }
public IActionResult Get(QueryArgsBase args) { IQueryable <Speciality> query = db.Specialities .FromSql <Speciality>("select speciality_id, speciality from dbo.pg_access_to_specialities({0})", employmentId); if (args.q != null) { query = query.Where(x => x.Name.Contains(args.q)); } var res = query .Filter(Request.Query.ToList()) .Sort(args) .AsNoTracking() .PaginateResult(args); return(Ok(res)); }
public JsonResult Get(QueryArgsBase args) { IQueryable <Placement> query = db.Placements.AsQueryable(); if (args.q != null) { query = query.FromSql <Placement>("select * from dbo.pg_search_placements({0}, {1})", employmentId, args.q); } else { query = query.FromSql <Placement>("select * from dbo.pg_placements({0})", employmentId); } var res = query.Filter(Request.Query.ToList()) .Sort(args) .AsNoTracking() .PaginateResult(args); return(Json(res)); }