public static DTResponse GetRelationTypes(DTRequest request)
{
var context = new AdminDbContext();
var response = new DTResponse()
{
draw = request.draw
};
var relationTypes = context.RelationTypes;
var data = relationTypes.AsEnumerable();
if (request.order != null && request.order.Any())
{
var asc = request.order[0].dir == "asc";
switch (request.order[0].column)
{
case 0:
{
data = asc ? data.OrderBy(u => u.Id) : data.OrderByDescending(u => u.Id);
break;
}
case 1:
{
data = asc ? data.OrderBy(u => u.Code) : data.OrderByDescending(u => u.Code);
break;
}
case 2:
{
data = asc ? data.OrderBy(u => u.Name) : data.OrderByDescending(u => u.Name);
break;
}
default:
{
data = data.OrderBy(u => u.Id);
break;
}
}
}
response.recordsFiltered = data.Count();
data = data.Skip(request.start).Take(request.length);
var responseData = data.Select(u => new RelationTypeDisplayModel { Id = u.Id, Code = u.Code, Name = u.Name, Relations = u.Relations.Count() });
response.data = responseData;
response.recordsTotal = context.RelationTypes.Count();
return response;
}
public JsonResult GetEntities(DTRequest dtRequest)
{
var response = EntityManager.GetEntities(dtRequest);
return Json(response);
}
public JsonResult GetRelations(DTRequest dtRequest)
{
var response = RelationManager.GetRelations(dtRequest);
return Json(response);
}
public JsonResult GetUsers(DTRequest dtRequest)
{
var response = UserManager.GetUsers(dtRequest);
return Json(response);
}
public static DTResponse GetUsers(DTRequest request)
{
var context = new AdminDbContext();
var response = new DTResponse()
{
draw = request.draw
};
var users = context.Users;
var data = users.AsEnumerable();
if (request.order != null && request.order.Any())
{
var asc = request.order[0].dir == "asc";
switch (request.order[0].column)
{
case 0:
{
data = asc ? data.OrderBy(u => u.Id) : data.OrderByDescending(u => u.Id);
break;
}
case 1:
{
data = asc ? data.OrderBy(u => u.Email) : data.OrderByDescending(u => u.Email);
break;
}
case 2:
{
data = asc ? data.OrderBy(u => u.RegisterDate) : data.OrderByDescending(u => u.RegisterDate);
break;
}
case 3:
{
data = asc ? data.OrderBy(u => u.Active) : data.OrderByDescending(u => u.Active);
break;
}
default:
{
data = data.OrderBy(u => u.Id);
break;
}
}
}
response.recordsFiltered = data.Count();
data = data.Skip(request.start).Take(request.length);
var responseData = data.Select(u => new UserModel { Id = u.Id, Email = u.Email, Active = u.Active, RegisterDate = u.RegisterDate });
response.data = responseData;
response.recordsFiltered = users.Count();
response.recordsTotal = context.Users.Count();
return response;
}
