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