public JsonResult CargarProducto(AnexGRID grid)
{
return(Json(producto.ListarGrilla(grid)));
}
//grilla
public JsonResult CargarGrilla(AnexGRID grid)
{
return(Json(hojavidadocentefc.ListarGrilla(grid), JsonRequestBehavior.AllowGet));
}
public JsonResult CargarCliente(AnexGRID grid)
{
return(Json(cliente.Listar(grid)));
}
public JsonResult CargarGrilla(AnexGRID grid)
{
return(Json(proyecto.Consulta01(grid)));
}
public JsonResult GetUsers(AnexGRID grid)
{
return(Json(
_userService.GetAll(grid)
));
}
public JsonResult GetCategories(AnexGRID grid)
{
return(Json(
_categoryService.GetAll(grid)
));
}
public AnexGRIDResponde GetAll(AnexGRID grid)
{
grid.Inicializar();
try
{
using (var ctx = _dbContextScopeFactory.CreateReadOnly())
{
var courses = ctx.GetEntity <Course>();
var categories = ctx.GetEntity <Category>();
var lessons = ctx.GetEntity <LessonsPerCourse>();
var students = ctx.GetEntity <UsersPerCourses>();
var users = ctx.GetEntity <ApplicationUser>();
var queryStudents = (
from c in courses
from s in students.Where(x => x.CourseId == c.Id)
select new
{
UserId = s.UserId,
CourseId = c.Id
}
).AsQueryable();
var query = (
from c in courses
from u in users.Where(x => x.Id == c.AuthorId)
select new CourseForGridView
{
Id = c.Id,
Instructor = (u.LastName + ", " + u.Name),
Name = c.Name,
Lessons = lessons.Where(x => x.CourseId == c.Id).Count(),
Students = queryStudents.Where(x => x.CourseId == c.Id).Count(),
Status = c.Status
}
).AsQueryable();
// Order by
if (grid.columna == "Name")
{
query = grid.columna_orden == "DESC" ? query.OrderByDescending(x => x.Name)
: query.OrderBy(x => x.Name);
}
var data = query.Skip(grid.pagina)
.Take(grid.limite)
.ToList();
var total = query.Count();
grid.SetData(data, total);
}
}
catch (Exception e)
{
logger.Error(e.Message);
}
return(grid.responde());
}
