/// <summary> /// AJAX request, retrieves data for basic grid /// </summary> /// <param name="gridSettings">Settings received from jqGrid request</param> /// <returns>JSON view containing data for basic grid</returns> public ActionResult GridDataBasic(GridSettings gridSettings) { var customers = _repo.GetCustomers(gridSettings); var totalCustomers = _repo.CountCustomers(gridSettings); var jsonData = new { total = totalCustomers / gridSettings.PageSize + 1, page = gridSettings.PageIndex, records = totalCustomers, rows = ( from c in customers select new { id = c.CustomerId, // Remove ravendb prefix from identifier cell = new[] { c.CustomerId, c.Fullname, c.Company, c.EmailAddress, c.LastModified.ToShortDateString(), c.Telephone } }).ToArray() }; return Json(jsonData, JsonRequestBehavior.AllowGet); }
/// <summary> /// Add a new grid /// </summary> /// <param name="gridSettings">Grid settings</param> public void Add(GridSettings gridSettings) { int gridId = 0; db.Grid.Add(gridSettings.GridName, gridSettings.GameTypeId, gridSettings.TreatmentTypeId, gridSettings.RoundCount, gridSettings.X, gridSettings.Y, gridSettings.PlayerCount, gridSettings.BotCount, gridSettings.FillFactor, gridSettings.LowerThreshold, gridSettings.UpperThreshold, gridSettings.HighPayoff, gridSettings.LowPayoff, gridSettings.NoiseLevel, gridSettings.RandomSeed, gridSettings.ExchangeRate, gridSettings.IntroTimer, gridSettings.RoundTimer, gridSettings.SummaryTimer, gridSettings.EntryGrid, gridSettings.ExitGrid, gridSettings.PlayedMGames, gridSettings.PlayedTGames, gridSettings.Chained, out gridId); }
/// <summary> /// AJAX request, retrieves data for basic grid /// </summary> /// <param name="gridSettings">Settings received from jqGrid request</param> /// <returns>JSON view containing data for basic grid</returns> public ActionResult GridDataBasic(GridSettings gridSettings) { var customers = _repo.GetCustomers(gridSettings); var totalCustomers = _repo.CountCustomers(gridSettings); var jsonData = new { total = totalCustomers / gridSettings.PageSize + 1, page = gridSettings.PageIndex, records = totalCustomers, rows = ( from c in customers select new { id = c.CustomerID, cell = new[] { c.CustomerID.ToString(), string.Format("{0} {1}", c.FirstName, c.LastName), c.CompanyName, c.EmailAddress, c.ModifiedDate.ToShortDateString(), c.Phone } }).ToArray() }; return Json(jsonData, JsonRequestBehavior.AllowGet); }
public void Grid_GridSettingsNotNull_GridMarkup() { var html = new HtmlHelper(new ViewContext(), new ViewDataContainer()); var gs = new GridSettings(); MvcHtmlString grid = html.Grid(gs); Assert.AreEqual(gs.ToString(), grid.ToString()); }
protected void ObtenerFiltros(GridSettings settings, ControllerContext controllerContext) { if (settings.Where == null) { settings.Where = new GridFilter(); List<GridRule> rules = new List<GridRule>(); settings.Where.rules = rules.ToArray(); } }
public int CountCustomers(GridSettings gridSettings) { var customers = _dataContext.Customers.AsQueryable(); if (gridSettings.IsSearch) { customers = gridSettings.Where.rules.Aggregate(customers, FilterCustomers); } return customers.Count(); }
public IList <Customer> GetCustomers(GridSettings gridSettings) { var orderedCustomers = OrderCustomers(Customers, gridSettings.SortColumn, gridSettings.SortOrder); if (gridSettings.IsSearch) { orderedCustomers = gridSettings.Where.rules.Aggregate(orderedCustomers, FilterCustomers); } return(orderedCustomers.Skip((gridSettings.PageIndex - 1) * gridSettings.PageSize).Take(gridSettings.PageSize).ToList()); }
public JsonResult ConsultarGrid(GridSettings gridSettings) { int qtdRegistros; var situacaoVPD = new Rule() { field = "Situacao", data = "A" }; var unidadeGestoraEmitente = new Rule() { field = "UnidadeGestoraCodigoEmitente", data = ExercicioAnoSessao.Sessao.UnidadeGestoraAtual.Value.ToString() }; if (gridSettings.Where == null) { gridSettings.Where = new MVC.Util.Filter() { rules = new Rule[] { situacaoVPD, unidadeGestoraEmitente } } } ; else { var regras = gridSettings.Where.rules.ToList(); if (!ExercicioAnoSessao.Sessao.EhUsuarioSemac && !regras.Any(el => el.field == "UnidadeGestoraCodigoEmitente")) { regras.Add(unidadeGestoraEmitente); } regras.Add(situacaoVPD); gridSettings.Where.rules = regras.ToArray(); } var lista = documentoDA.GridObterVPDPrevia(gridSettings, out qtdRegistros); var list = lista.AsEnumerable() .Select(d => new GridRow { id = d.DocumentoID, cell = new object[] { d.DocumentoID, d.Numero, d.DataEmissao.ToString("dd/MM/yyyy"), d.UnidadeGestora.UnidadeGestoraCodigo + " - " + d.UnidadeGestora.Nome, d.Credor != null ? d.Credor.CredorIdentificacao + " - " + d.Credor.Nome : string.Empty, d.ValorDocumento.ToString("N2"), d.ItemVariacaoPatrimonialDiminutiva.Select(x => new { TipoVPD = x.TipoVPD.Equals("A") ? "Prévia" : "Posterior" }).Select(x => x.TipoVPD).FirstOrDefault(), d.Documento2 != null ? d.Documento2.Numero : string.Empty, } }); return(list.Retornar(gridSettings, qtdRegistros)); }
public List <AppointmentCategoryDTO> GetAll(GridSettings gridSettings) { try { return(appointmentCategoryRepository.GetAll(gridSettings).ToList()); } catch (Exception e) { throw e; } }
public string GetEmbroideryFirmPricingGridData(GridSettings grid, Guid EmbroideryFirmId) { try { return(new EmbroideryFirmPriceSettingsBL().GetGridData(grid, EmbroideryFirmId)); } catch (Exception ex) { return(""); } }
public string GetGridData(GridSettings grid) { try { return(new EmbroideryFirmBL().GetGridData(grid)); } catch (Exception ex) { return(""); } }
public IList<Customer> GetCustomers(GridSettings gridSettings) { var orderedCustomers = OrderCustomers(Customers, gridSettings.SortColumn, gridSettings.SortOrder); if (gridSettings.IsSearch) { orderedCustomers = gridSettings.Where.rules.Aggregate(orderedCustomers, FilterCustomers); } return orderedCustomers.Skip((gridSettings.PageIndex - 1)*gridSettings.PageSize).Take(gridSettings.PageSize).ToList(); }
public ActionResult DynamicGridData(GridSettings gridData) { //get data from user and map with value injecter to view model IQueryable <UserViewModel> userViewModel = _userService.GetAll().AsQueryable().Select(c => new UserViewModel().InjectFrom(c)).Cast <UserViewModel>(); if (gridData.IsSearch) { if (gridData.Where.groupOp == "AND") { foreach (var rule in gridData.Where.rules) { userViewModel = userViewModel.Where <UserViewModel>( rule.field, rule.data, (WhereOperation)StringEnum.Parse(typeof(WhereOperation), rule.op)); } } else { var temp = new List <UserViewModel>().AsQueryable(); foreach (var rule in gridData.Where.rules) { var t = userViewModel.Where <UserViewModel>( rule.field, rule.data, (WhereOperation)StringEnum.Parse(typeof(WhereOperation), rule.op)); temp = temp.Concat <UserViewModel>(t); } userViewModel = temp.Distinct <UserViewModel>(); } userViewModel = userViewModel.OrderBy <UserViewModel>(gridData.SortColumn, gridData.SortOrder); } int pageIndex = Convert.ToInt32(gridData.PageIndex) - 1; int pageSize = gridData.PageSize; int totalRecords = userViewModel.Count(); int totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize); var jsonData = new { total = totalPages, page = pageIndex, records = totalRecords, rows = (from model in userViewModel select new { i = model.UserId, cell = new string[] { model.UserId.ToString(), model.UserName, model.Email } }).ToArray() }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }
public List <UserDTO> GetAll(GridSettings gridSettings) { try { return(userRepository.GetAll(gridSettings).ToList()); } catch (Exception e) { throw e; } }
private IEnumerable <Customer> GetData(GridSettings grid, out int totalRecords, bool allData = false) { IEnumerable <Customer> data; var query = _customerRepository.GetAll(); //filtring if (grid.Where != null) { if (grid.Where.groupOp == "AND") { foreach (var rule in grid.Where.rules) { query = query.Where(rule.field, rule.data, (WhereOperation)StringEnum.Parse(typeof(WhereOperation), rule.op)); } } else { //Or var temp = (new List <Customer>()).AsQueryable(); foreach (var rule in grid.Where.rules) { var t = query.Where( rule.field, rule.data, (WhereOperation)StringEnum.Parse(typeof(WhereOperation), rule.op)); temp = temp.Concat(t); } //remove repeating records query = temp.Distinct(); } } query = query.Where(c => c.UserType == UserType.Customer); //sorting if (!string.IsNullOrEmpty(grid.SortColumn)) { query = query.OrderBy(grid.SortColumn, grid.SortOrder); } totalRecords = query.Count(); if (!allData) { data = query.Skip((grid.PageIndex - 1) * grid.PageSize).Take(grid.PageSize); } else { data = query.AsEnumerable().ToList(); } return(data); }
/// <summary> /// 分页的数据 /// </summary> /// <returns></returns> public JsonResult GetData(GridSettings setting) { string requestStringPar = Request["customPar"]; string page = Request["page"]; //当前页 string rows = Request["rows"]; //每页显示 int pageIndex = Convert.ToInt32(page); //当前页 int rowsint = Convert.ToInt32(rows); //过滤参数 List <CommonSearchModel> parasD = null; if (!string.IsNullOrEmpty(requestStringPar)) { parasD = JsonConvert.DeserializeObject <List <CommonSearchModel> >(requestStringPar);; } int records = SysDataHelper <T_Sys_Users> .ResultDataCount_New(parasD); int total = (int)Math.Ceiling((float)records / (float)rowsint); List <T_Sys_Users> usersList = null; try { usersList = SysDataHelper <T_Sys_Users> .FindDataByPageFilter(parasD, string.IsNullOrEmpty(setting.sortColumn)? "UserId" : setting.sortColumn + " " + setting.sortOrder, pageIndex, rowsint).ToList(); } catch (Exception ex) { throw; } var jsonData = new { total = total, page = pageIndex, records = records, rows = ( from sta in usersList select new { i = sta.UserId, cell = new object[] { sta.UserId, sta.UserName, sta.RealName, sta.Email, sta.Sex == 0?"男":"女", sta.Tel, DateTime.Parse(sta.CreateDate.ToString()).ToString("yyyy-MM-dd") } } ).ToArray() }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }
public string GetGridData(GridSettings grid) { try { return(new UserBL().GetGridData(grid)); } catch (Exception ex) { return(""); } }
public string GetGridData(GridSettings grid) { try { return(new StudentBL().GetGridData(grid)); } catch (Exception ex) { return(ex.Message); } }
public List <MedicalHistoryDTO> GetAll(GridSettings gridSettings) { try { return(medicalHistoryRepository.GetAll(gridSettings).ToList()); } catch (Exception e) { throw e; } }
public List <PatientDTO> GetAll(GridSettings gridSettings) { try { return(patientRepository.GetAll(gridSettings).ToList()); } catch (Exception e) { throw e; } }
public IList <Thuoc> GetThuocs(string maNhaThuoc, GridSettings gridSettings) { var orderedThuocs = OrderThuocs(GetMany(e => e.NhaThuoc.MaNhaThuoc == maNhaThuoc), gridSettings.SortColumn, gridSettings.SortOrder); if (gridSettings.IsSearch) { orderedThuocs = gridSettings.Where.rules.Aggregate(orderedThuocs, FilterThuocs); } return(orderedThuocs.Skip((gridSettings.PageIndex - 1) * gridSettings.PageSize).Take(gridSettings.PageSize).ToList()); }
public GridController(GridView view, GridSettings settings) { _model = new GridModel(settings); _view = view; _view.InitializeGrid(_model.gridSettings); _view.onCellPressed += OnCellPressed; SpawnRoundBalls(); }
public IQueryable <Customer> GetCustomers(GridSettings gridSettings) { var customers = orderCustomers(_dataContext.Customers.AsQueryable(), gridSettings.SortColumn, gridSettings.SortOrder); if (gridSettings.IsSearch) { customers = gridSettings.Where.rules.Aggregate(customers, FilterCustomers); } return(customers.Skip((gridSettings.PageIndex - 1) * gridSettings.PageSize).Take(gridSettings.PageSize)); }
public IQueryable<Customer> GetCustomers(GridSettings gridSettings) { var customers = orderCustomers(_dataContext.Customers.AsQueryable(), gridSettings.SortColumn, gridSettings.SortOrder); if (gridSettings.IsSearch) { customers = gridSettings.Where.rules.Aggregate(customers, FilterCustomers); } return customers.Skip((gridSettings.PageIndex - 1) * gridSettings.PageSize).Take(gridSettings.PageSize); }
private void buttonOK_Click(object sender, EventArgs e) { if (!this.ValidateChildren()) { MessageBox.Show("Validation failed!\nPlease check all fields with red border!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } ResultSettings = CRV_TS_Converter.Save(this); Close(); }
private static SortConfiguration PrepareSortSettings( GridSettings gridSettings, SortConfiguration defaultSortSettings) { if (string.IsNullOrEmpty(gridSettings.SortColumn)) { return(defaultSortSettings); } var sortMode = gridSettings.SortOrder == "asc" ? SortMode.Ascending : SortMode.Descending; return(new SortConfiguration(gridSettings.SortColumn, sortMode)); }
private string[] getCondition(GridSettings objGrdSettings) { string WhereCondition = ""; string sOrderBy = "", sSearchString = ""; //for sorting string orderBy = ""; string pagination = ""; if (!string.IsNullOrEmpty(objGrdSettings.SortColumn)) { if (objGrdSettings.SortColumn.Contains("date") || objGrdSettings.SortColumn.ToLower().Contains("time")) { sOrderBy += string.Format(" CONVERT(VARCHAR, ISNULL({0},0), 101) ", objGrdSettings.SortColumn, objGrdSettings.SortOrder); } else { sOrderBy += string.Format(" CONVERT(VARCHAR, ISNULL({0},0)) {1} ", objGrdSettings.SortColumn, objGrdSettings.SortOrder); } orderBy = string.Format(" order by {0}", sOrderBy); } //for search sSearchString = ""; WhereCondition += "where 1=1"; if (objGrdSettings.Where != null) { foreach (var item in objGrdSettings.Where.rules) { if (item.field.Contains("date") || item.field.ToLower().Contains("time")) { sSearchString += string.Format(" and convert(varchar, {0}, 101) like '{1}%' ", item.field, item.data); } else { sSearchString += string.Format(" and CONVERT(VARCHAR, ISNULL({0},0)) like '{1}%' ", item.field, item.data); } } WhereCondition += string.Format("{0}", sSearchString); } // for paging if (objGrdSettings.PageSize > 0) { pagination = string.Format(" where rowid BETWEEN {0} AND {1}", ((objGrdSettings.PageIndex - 1) * objGrdSettings.PageSize) + 1, (objGrdSettings.PageIndex * objGrdSettings.PageSize)); } string[] filter = new string[3]; filter[0] = orderBy; filter[1] = WhereCondition; filter[2] = pagination; return(filter); }
/// ------------------------------------------------------------------------------------ protected override void OnColumnWidthChanged(DataGridViewColumnEventArgs e) { base.OnColumnWidthChanged(e); AutoResizeColumnHeadersHeight(); ColumnHeadersHeight += 8; if (!DesignMode) { GridSettings = GridSettings.Create(this); } }
public ActionResult SearchByPreProduct(MasterListSearchViewModel model, GridSettings gridSettings) { try { var results = _preProductDomain.SearchMaterialList(model.MasterCode, gridSettings); return(Json(results.Data)); } catch (Exception ex) { return(Json(new { Success = false, ex.Message })); } }
public GridModel(GridSettings settings) { gridSettings = settings; grid = new int[gridSettings.size, gridSettings.size]; freeCells = new List <int>(); for (int i = 0; i < gridSettings.size * gridSettings.size; i++) { freeCells.Add(i); } }
public IActionResult PostGridSettings([FromBody] GridSettings gridSettings) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _uow.GridRepo.SetGridSettings(gridSettings); _uow.SaveChanges(); return(Ok(gridSettings)); }
public ActionResult GetDataWindow2(SearchCriteriaModel model, GridSettings gridSettings) { var inputDate = !string.IsNullOrEmpty(model.StartDate) ? ConvertHelper.ConvertToDateTimeFull(model.StartDate) : DateTime.Now; var dataDate = !string.IsNullOrEmpty(model.EndDate) ? ConvertHelper.ConvertToDateTimeFull(model.EndDate) : DateTime.Now; var result = _cleanlinessDataInputDomain.SearchDataWindow1(inputDate, dataDate, model.Location, gridSettings); if (!result.IsSuccess) { return(Json(null, JsonRequestBehavior.AllowGet)); } return(Json(result.Data, JsonRequestBehavior.AllowGet)); }
public IEnumerable <ClinicDTO> GetAll(GridSettings gridSettings) { IEnumerable <Clinic> clinicList = dbset.Where(x => string.IsNullOrEmpty(gridSettings.SearchText) ? true : (x.Name.Contains(gridSettings.SearchText) || x.Address.Contains(gridSettings.SearchText) )); gridSettings.RowsCount = clinicList.Count(); return(_mapper.Map <List <ClinicDTO> >(clinicList.OrderByDescending(m => m.CreationDate) .Skip(gridSettings.PageSize * gridSettings.PageIndex) .Take(gridSettings.PageSize))); }
public List <M.Category> Get(GridSettings settings) { var list = _categoryRepo.GetAll().FullTextSearch(settings.Keyword); var retVal = list.OrderBy(settings.OrderBy).Paginate(settings).Select(x => new M.Category() { ID = x.ID, Name = x.Name }); return(retVal.ToList()); }
//public string GetGridData(GridSettings grid, int JariCompanyId = 0) //{ // try // { // using (var ctx = new DBAJEntities()) // { // var query = ctx.vw_Users.AsQueryable(); // if (JariCompanyId != 0) // { // query = query.Where(k => k.JariCompanyId == JariCompanyId); // } // else // { // string RoleGroupName = Convert.ToString(En_Role_Group.AJ); // List<int> lstRole = ctx.Roles.Where(r => r.RoleGroup == RoleGroupName).Select(r => r.RoleId).ToList(); // query = query.Where(u => lstRole.Contains(u.RoleId)); // } // int count; // var data = query.GridCommonSettings(grid, out count); // var result = new // { // total = (int)Math.Ceiling((double)count / grid.PageSize), // page = grid.PageIndex, // records = count, // rows = (from u in data // select new // { // u.UserId, // u.RoleId, // u.JariCompanyId, // u.FirstName, // u.LastName, // u.Email, // u.Mobile, // u.Phone, // u.Password, // u.Status, // u.ModifiedBy, // u.ModifiedOn, // u.JariCompanyName, // u.CreateDate, // u.ActivationEndDate, // u.RoleGroup, // u.RoleName, // Action = u.UserId // }).ToArray() // }; // return JsonConvert.SerializeObject(result, new IsoDateTimeConverter()); // } // } // catch (Exception ex) // { // throw ex; // } //} public string GetGridData(GridSettings grid) { try { using (var ctx = new DBAJEntities()) { var query = ctx.vw_Users.AsQueryable(); string RoleGroupName = Convert.ToString(En_Role_Group.Company); List <int> lstRole = ctx.Roles.Where(r => r.RoleGroup == RoleGroupName).Select(r => r.RoleId).ToList(); query = query.Where(u => lstRole.Contains(u.RoleId)); int count; var data = query.GridCommonSettings(grid, out count); var result = new { total = (int)Math.Ceiling((double)count / grid.PageSize), page = grid.PageIndex, records = count, rows = (from u in data select new { u.UserId, u.RoleId, u.JariCompanyId, u.FirstName, u.LastName, u.Email, u.Mobile, u.Phone, u.Password, u.Status, u.ModifiedBy, u.ModifiedOn, u.JariCompanyName, u.CreateDate, u.ActivationEndDate, u.RoleGroup, u.RoleName, Action = u.UserId }).ToArray() }; return(JsonConvert.SerializeObject(result, new IsoDateTimeConverter())); } } catch (Exception ex) { throw ex; } }
public async Task <ActionResult> Search(SearchCriteriaRequest model, GridSettings gridSettings) { var result = await ExecuteSearch(model, gridSettings); if (!result.IsSuccess) { return(Json(null, JsonRequestBehavior.AllowGet)); } var response = Mapper.Map <GridResponse <CategoryListingWebModel> >(result.Data); return(Json(response, JsonRequestBehavior.AllowGet)); }
public IEnumerable <AppointmentAdditionDTO> GetAll(GridSettings gridSettings) { double.TryParse(gridSettings.SearchText, out double price); IEnumerable <AppointmentAddition> appointmentAdditionList = dbset.Where(x => string.IsNullOrEmpty(gridSettings.SearchText) ? true : (x.Name.Contains(gridSettings.SearchText) || x.Price == price )); gridSettings.RowsCount = appointmentAdditionList.Count(); return(_mapper.Map <List <AppointmentAdditionDTO> >(appointmentAdditionList.OrderByDescending(m => m.CreationDate) .Skip(gridSettings.PageSize * gridSettings.PageIndex) .Take(gridSettings.PageSize))); }
public List <ClinicDTO> Delete(ClinicDTO clinic, GridSettings gridSettings) { try { clinicRepository.Delete(clinic); UoW.SaveChanges(); } catch (Exception e) { throw e; } return(GetAll(gridSettings)); }
public GridResult<Ensayo> ReadEnsayo(GridSettings grid) { return EnsayoRepository.ReadEnsayo(grid); }
public GridResult<Lote> ReadLote(GridSettings grid) { return LoteRepository.ReadLote(grid); }
public GridResult<Perfil> ReadPerfil(GridSettings grid) { return PerfilRepository.ReadPerfil(grid); }
public GridResult<Equipo> ReadEquipo(GridSettings grid) { return EquipoRepository.ReadEquipo(grid); }
public GridResult<Usuario> ReadUsuario(GridSettings grid) { return UsuarioRepository.ReadUsuario(grid); }
public GridResult<Producto> ReadProducto(GridSettings grid) { return ProductoRepository.ReadProducto(grid); }
/// <summary> /// Called when deserializing /// </summary> /// <param name="info"></param> /// <param name="context"></param> protected EditorSceneSettings(SerializationInfo info, StreamingContext context) { _vLuxSettingsFile = info.GetString("_vLuxSettingsFile"); _bUseDefaultvLuxSettingsFile = info.GetBoolean("_bUseDefaultvLuxSettingsFile"); if (SerializationHelper.HasElement(info,"_shapeOrigin")) _shapeOrigin = (Vector3F)info.GetValue("_shapeOrigin", typeof(Vector3F)); if (SerializationHelper.HasElement(info,"_cameraPosition")) _cameraPosition = (Vector3F)info.GetValue("_cameraPosition", typeof(Vector3F)); if (SerializationHelper.HasElement(info,"_cameraAngles")) _cameraAngles = (Vector3F)info.GetValue("_cameraAngles", typeof(Vector3F)); if (SerializationHelper.HasElement(info,"_description")) _OLDdescription = info.GetString("_description"); if (SerializationHelper.HasElement(info,"_showDescAtStartup")) _showDescAtStartup = info.GetBoolean("_showDescAtStartup"); if (SerializationHelper.HasElement(info,"_gridSettings")) _gridSettings = (GridSettings)info.GetValue("_gridSettings", typeof(GridSettings)); if (SerializationHelper.HasElement(info, "_exportProfileName")) _exportProfileName = info.GetString("_exportProfileName"); if (SerializationHelper.HasElement(info, "_autoSaveExportProfile")) _autoSaveExportProfile = info.GetBoolean("_autoSaveExportProfile"); if (SerializationHelper.HasElement(info, "_screenshotSettings")) { _screenshotSettings = info.GetValue("_screenshotSettings", typeof(ScreenshotSettings)) as ScreenshotSettings; } else { _screenshotSettings = new ScreenshotSettings(); } // the following settings are now in export profiles. Load them here for backwards compatibility if (PATCH_PROFILE != null) ///...but only if no dedicated profile name has been loaded { if (SerializationHelper.HasElement(info, "_exportPath")) CurrentProfile.ExportPath = info.GetString("_exportPath"); if (SerializationHelper.HasElement(info, "_bRunAfterExport")) CurrentProfile.RunAfterExport = info.GetBoolean("_bRunAfterExport"); if (SerializationHelper.HasElement(info, "_exportedLayerNames")) CurrentProfile.ExportedLayerNames = (StringCollection)info.GetValue("_exportedLayerNames", typeof(StringCollection)); if (SerializationHelper.HasElement(info, "_bIncludeVisibilityInfo")) CurrentProfile.IncludeVisibilityInfo = info.GetBoolean("_bIncludeVisibilityInfo"); if (SerializationHelper.HasElement(info, "_bEmbedCustomLitFile")) CurrentProfile.EmbedCustomLitFile = info.GetBoolean("_bEmbedCustomLitFile"); } }
public JsonResult GetData(GridSettings grid) { //GridSettings grid = new GridSettings(); // Get the ObjectContext related to this DbContext //var objectContext = (this as IObjectContextAdapter).ObjectContext; //objectContext.CommandTimeout = 120; // var query = _repository.PlanFactLists(); using (var context = new CMER_DWEnt()) { var query = context.vwPlanFactLists.AsQueryable(); //filtring if (grid.IsSearch) { if (grid.Where != null) { //And if (grid.Where.groupOp == "AND") foreach (var rule in grid.Where.rules) query = query.Where<vwPlanFactLists>( rule.field, rule.data, (WhereOperation)StringEnum.Parse(typeof(WhereOperation), rule.op)); else { //Or var temp = (new List<vwPlanFactLists>()).AsQueryable(); foreach (var rule in grid.Where.rules) { var t = query.Where<vwPlanFactLists>( rule.field, rule.data, (WhereOperation)StringEnum.Parse(typeof(WhereOperation), rule.op)); temp = temp.Concat<vwPlanFactLists>(t); } //remove repeating records query = temp.Distinct<vwPlanFactLists>(); } } } //sorting query = query.OrderBy<vwPlanFactLists>(grid.SortColumn, grid.SortOrder); //count var count = 17862269; //query.Count(); //paging var data = query.Skip((grid.PageIndex - 1) * grid.PageSize).Take(grid.PageSize).ToArray(); //converting in grid format var result = new { total = (int)Math.Ceiling((double)count / grid.PageSize), page = grid.PageIndex, records = count, rows = (data).ToArray() }; //convert to JSON and return to client return Json(result, JsonRequestBehavior.AllowGet); } }
public ActionResult Manage(GridSettings settings) { var model = _repository.FindAll().ToList(); return View(model); }
public int CountCustomers(GridSettings gridSettings) { return gridSettings.IsSearch ? gridSettings.Where.rules.Aggregate(Customers, FilterCustomers).Count() : Customers.Count(); }
public GridResult<Planta> ReadPlanta(GridSettings grid) { return PlantaRepository.ReadPlanta(grid); }
public GridResult<Proveedor> ReadProveedor(GridSettings grid) { return ProveedorRepository.ReadProveedor(grid); }
public GridResult<ResultadoDetalle> ReadResultadoDetalle(GridSettings grid) { return ResultadoDetalleRepository.ReadResultadoDetalle(grid); }
public GridResult<Especificacion> ReadEspecificacion(GridSettings grid) { return EspecificacionRepository.ReadEspecificacion(grid); }
public GridResult<Calibracion> ReadCalibracion(GridSettings grid) { return CalibracionRepository.ReadCalibracion(grid); }
public GridResult<Silo> ReadSilo(GridSettings grid) { return SiloRepository.ReadSilo(grid); }
public GridResult<Color> ReadColor(GridSettings grid) { return ColorRepository.ReadColor(grid); }
public GridResult<SystemLog> ReadLog(GridSettings grid) { return SystemLogRepository.ReadLog(grid); }
public GridResult<Resultado> ReadResultado(GridSettings grid) { return ResultadoRepository.ReadResultado(grid); }
public GridResult<Menu> ReadMenu(GridSettings grid) { return MenuRepository.ReadMenu(grid); }
public GridResult<NormaEnsayoValorIn> ReadNormaIn(GridSettings grid) { return NormaEnsayoValorInRepository.ReadNormaIn(grid); }
public GridResult<NormaProducto> ReadNormaProducto(GridSettings grid) { return NormaProductoRepository.ReadNormaProducto(grid); }