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