public ActionResult Grid(GridPaging paging)
{
JQGridData jq = HomeRepo.ProductRepo.GetAll().Select(s => new
{
id = s.Id,
Name = s.Name,
Category = s.ProductCategory.Name
}).AsQueryable().ToJQGridData(paging, new[] { "id", "Name", "Category" });
return Json(jq, JsonRequestBehavior.AllowGet);
}
public ActionResult Index2()
{
GridModel model = new GridModel();
model.AutoGenerateColumns = false;
GridColumn idColumn = new GridColumn();
idColumn.Key = "id";
idColumn.HeaderText = "ID";
idColumn.DataType = "number";
GridColumn NombreColumn = new GridColumn();
NombreColumn.Key = "Nombre";
NombreColumn.HeaderText = "Nombre";
NombreColumn.DataType = "string";
GridColumn ApellidoColumn = new GridColumn();
ApellidoColumn.Key = "Apellido";
ApellidoColumn.HeaderText = "Apellido";
ApellidoColumn.DataType = "string";
GridColumn SexoColumn = new GridColumn();
SexoColumn.Key = "Sexo";
SexoColumn.HeaderText = "Sexo";
SexoColumn.DataType = "string";
GridColumn FechaNacimientoColumn = new GridColumn();
FechaNacimientoColumn.Key = "FechaNacimiento";
FechaNacimientoColumn.HeaderText = "Fecha Nacimiento";
FechaNacimientoColumn.DataType = "datetime";
model.Columns.Add(idColumn);
model.Columns.Add(NombreColumn);
model.Columns.Add(ApellidoColumn);
model.Columns.Add(SexoColumn);
model.Columns.Add(FechaNacimientoColumn);
//Activando Ordenamiento
GridSorting sorting = new GridSorting();
sorting.Mode = SortingMode.Single;
ColumnSortingSetting colSetting = new ColumnSortingSetting();
colSetting.ColumnIndex = 1;
colSetting.ColumnKey = "Nombre";
colSetting.AllowSorting = true;
//Activando Filtrado
GridFiltering filtering = new GridFiltering();
ColumnFilteringSetting colFilter = new ColumnFilteringSetting();
colFilter.AllowFiltering = true;
sorting.ColumnSettings.Add(colSetting);
filtering.ColumnSettings.Add(colFilter);
model.Features.Add(sorting);
model.Features.Add(filtering);
//Activando Paginacion
GridPaging gridpaging = new GridPaging();
gridpaging.PageSize = 2;
model.Features.Add(gridpaging);
model.DataSource = ctx.Alumno.GetAllAlumnos3();
return(View(model));
}
private GridModel GridLoadOnDemandModel()
{
// Define the Categories layout
GridModel grid = new GridModel();
grid.AutoGenerateLayouts = false;
grid.AutoGenerateColumns = false;
grid.PrimaryKey = "ID";
grid.Width = "100%";
grid.Columns.Add(new GridColumn()
{
HeaderText = "Category ID", Key = "ID", DataType = "number", Width = "0%", Hidden = true
});
grid.Columns.Add(new GridColumn()
{
HeaderText = "Category Name", Key = "CategoryName", DataType = "string", Width = "30%"
});
grid.Columns.Add(new GridColumn()
{
HeaderText = "Description", Key = "Description", DataType = "string", Width = "50%"
});
grid.Columns.Add(new GridColumn()
{
HeaderText = "Products Count", Key = "ProductCount", DataType = "number", Width = "20%"
});
// Define the Products layout
GridColumnLayoutModel layout = new GridColumnLayoutModel();
layout.Key = "Products";
layout.ForeignKey = "CategoryID";
layout.PrimaryKey = "ID";
layout.AutoGenerateColumns = false;
layout.Columns.Add(new GridColumn()
{
HeaderText = "Product ID", Key = "ID", DataType = "number", Width = "0%", Hidden = true
});
layout.Columns.Add(new GridColumn()
{
HeaderText = "Category ID", Key = "CategoryID", DataType = "number", Width = "0%", Hidden = true
});
layout.Columns.Add(new GridColumn()
{
HeaderText = "Product Name", Key = "ProductName", DataType = "string", Width = "40%"
});
layout.Columns.Add(new GridColumn()
{
HeaderText = "Unit Price", Key = "UnitPrice", DataType = "number", Width = "30%"
});
layout.Columns.Add(new GridColumn()
{
HeaderText = "Units In Stock", Key = "UnitsInStock", DataType = "number", Width = "30%"
});
layout.Width = "100%";
grid.ColumnLayouts.Add(layout);
GridPaging paging = new GridPaging();
paging.Type = OpType.Remote;
paging.Inherit = true;
paging.PageSize = 5;
grid.Features.Add(paging);
return(grid);
}
private GridModel GridLoadOnDemandModel()
{
// Define the Categories layout
GridModel grid = new GridModel();
grid.AutoGenerateLayouts = false;
grid.AutoGenerateColumns = false;
grid.PrimaryKey = "ID";
grid.Width = "100%";
grid.Columns.Add(new GridColumn() { HeaderText = "Category ID", Key = "ID", DataType = "number", Width = "0%", Hidden = true});
grid.Columns.Add(new GridColumn() { HeaderText = "Category Name", Key = "CategoryName", DataType = "string", Width = "30%" });
grid.Columns.Add(new GridColumn() { HeaderText = "Description", Key = "Description", DataType = "string", Width = "50%" });
grid.Columns.Add(new GridColumn() { HeaderText = "Products Count", Key = "ProductCount", DataType = "number", Width = "20%" });
// Define the Products layout
GridColumnLayoutModel layout = new GridColumnLayoutModel();
layout.Key = "Products";
layout.ForeignKey = "CategoryID";
layout.PrimaryKey = "ID";
layout.AutoGenerateColumns = false;
layout.Columns.Add(new GridColumn() { HeaderText = "Product ID", Key = "ID", DataType = "number", Width = "0%", Hidden = true });
layout.Columns.Add(new GridColumn() { HeaderText = "Category ID", Key = "CategoryID", DataType = "number",Width = "0%", Hidden = true});
layout.Columns.Add(new GridColumn() { HeaderText = "Product Name", Key = "ProductName", DataType = "string",Width = "40%"});
layout.Columns.Add(new GridColumn() { HeaderText = "Unit Price", Key = "UnitPrice", DataType = "number", Width = "30%" });
layout.Columns.Add(new GridColumn() { HeaderText = "Units In Stock", Key = "UnitsInStock", DataType = "number", Width = "30%" });
layout.Width = "100%";
grid.ColumnLayouts.Add(layout);
GridPaging paging = new GridPaging();
paging.Type = OpType.Remote;
paging.Inherit = true;
paging.PageSize = 5;
grid.Features.Add(paging);
return grid;
}
public ActionResult GetGrid(GridPaging paging)
{
try
{
var result = req.GetAllRequest().Select(m => new
{
id = m.requestId,
wbsno = m.wbsno,
summary = m.summary
}).ToJQGridData(paging, new string[] { "id","wbsno","summary"});
return Json(result, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
return null;
}
}
