public ActionResult Index() { ViewBag.Message = "Графики на Highcharts."; var gridModel = new LogJqGridModel(); var grid = gridModel.LogGrid; // NOTE: you need to call this method in the action that fetches the data as well, // so that the models match LogSetupGrid(grid); IndicatorsModel model = new IndicatorsModel() { LogGrid = gridModel }; SkladDataContext context = new SkladDataContext(); // Check permissions int currentUserId = WebSecurity.CurrentUserId; string[] roles = Roles.GetRolesForUser(WebSecurity.CurrentUserName); if (roles.Contains("limitedemployee")) { IQueryable<UserProfile> userProfiles = context.UserProfiles.Where(x => x.UserId == currentUserId); model.Employees = userProfiles; model.Managers = userProfiles; } else { model.Employees = context.UserProfiles.Where(x => x.ContactTypeId == (int)EntityEnum.ContactTypeEnum.Employee); model.Managers = context.UserProfiles .Where(x => x.ContactTypeId == (int)EntityEnum.ContactTypeEnum.Manager || x.ContactTypeId == (int)EntityEnum.ContactTypeEnum.Employee); } /*employee var result = (from u in datacontextModel.UserProfiles where u.DisplayName.ToLower().Contains(term.ToLower()) && (u.ContactTypeId == (int)EntityEnum.ContactTypeEnum.Manager || u.ContactTypeId == (int)EntityEnum.ContactTypeEnum.Employee) select new { u.DisplayName, u.UserId }).ToList(); */ return View(model); }
public JsonResult LogSearchGridDataRequested() { // Get both the grid Model and the data Model // The data model in our case is an autogenerated linq2sql database based on Northwind. var gridModel = new LogJqGridModel(); var datacontextModel = new LoggingDataContext(); // customize the default grid model with our custom settings LogSetupGrid(gridModel.LogGrid); // return the result of the DataBind method, passing the datasource as a parameter // jqGrid for ASP.NET MVC automatically takes care of paging, sorting, filtering/searching, etc return gridModel.LogGrid.DataBind(datacontextModel.Logs.OrderByDescending(x => x.Date)); }