public static string GetData() { System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer(); string nomCampus = HttpContext.Current.Request.QueryString.Get("nomCampus"); string calle = HttpContext.Current.Request.QueryString.Get("calle"); string colonia = HttpContext.Current.Request.QueryString.Get("colonia"); string telefono = HttpContext.Current.Request.QueryString.Get("telefono"); //string Pais = HttpContext.Current.Request.QueryString.Get("claPais"); //string Estado = HttpContext.Current.Request.QueryString.Get("claEstado"); //string Ciudad = HttpContext.Current.Request.QueryString.Get("claCiudad"); JQXGridSettings settings = JsonGridData.GetGridSettings(); Business.Campus bo = new Business.Campus(); List <Entities.Campus> list = bo.ListarCampus(settings, nomCampus, calle, colonia, telefono, 0, 0, 0); int registros = 0; if (list.Count > 0) { registros = list[0].TotalRecords; } JsonGridData data = new JsonGridData(list, registros); string json = js.Serialize(data); return(json); }
public static JQXGridSettings GetGridSettings() { JQXGridSettings settings = new JQXGridSettings(); string sort = HttpContext.Current.Request.QueryString.Get("sortdatafield"); string sortOrder = HttpContext.Current.Request.QueryString.Get("sortorder"); string pageNum = HttpContext.Current.Request.QueryString.Get("pagenum"); string pageSize = HttpContext.Current.Request.QueryString.Get("pagesize"); settings.PageNumber = Utils.IsNull(pageNum, 0); settings.PageSize = Utils.IsNull(pageSize, 0); if (sort != null && sortOrder != null && sort.Trim() != "" && sortOrder.Trim() != "") { settings.OrderBy = string.Format("{0} {1}", sort, sortOrder); } return(settings); }
public static string GetData() { System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer(); string NomLeccion = HttpContext.Current.Request.QueryString.Get("NomLeccion"); JQXGridSettings settings = JsonGridData.GetGridSettings(); Business.Lecciones bo = new Business.Lecciones(); List <Entities.Lecciones> list = bo.ListarLecciones(settings, "", 0, 0, 0); int registros = 0; if (list.Count > 0) { registros = list[0].TotalRecords; } JsonGridData data = new JsonGridData(list, registros); string json = js.Serialize(data); return(json); }
public static string GetData() { System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer(); JQXGridSettings settings = JsonGridData.GetGridSettings(); Business.Paises bo = new Business.Paises(); List <Entities.Pais> list = bo.ListarPaises(settings, ""); int registros = 0; if (list.Count > 0) { registros = list[0].TotalRecords; } JsonGridData data = new JsonGridData(list, registros); string json = js.Serialize(data); return(json); }
public void ConfigurePagedStoredProcedure(PagedStoredProcedure sp, JQXGridSettings settings) { sp.NumPagina = settings.PageNumber; sp.OrdenarPor = settings.OrderBy; sp.TamanioPagina = settings.PageSize; }