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