private static void RegisterGrid(GridDefaults gridDefaults, ColumnDefaults colDefauls, string gridName)
{
MVCGridDefinitionTable.Add(GRID_NAME, new MVCGridBuilder <ProductItemModel>(gridDefaults, colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
BuildColumns(cols);
})
.WithSorting(true, "Name", SortDirection.Asc)
.WithFiltering(true)
.WithAdditionalQueryOptionNames(FILTER_NAME, FILTER_DESC)
.WithRetrieveDataMethod((context) =>
{
var service = DependencyResolver.Current.GetService <IProductsService>();
var result = service.GetProducts();
var options = context.QueryOptions;
var query = result.Items.AsQueryable();
var name = options.GetAdditionalQueryOptionString(FILTER_NAME);
var desc = options.GetAdditionalQueryOptionString(FILTER_DESC);
query = FilterData(options, query, name, desc);
return(new QueryResult <ProductItemModel>()
{
Items = query.ToList(),
TotalRecords = result.Items.Count()
});
})
);
}
internal static void Register()
{
GridDefaults employeeGridDefauls = new GridDefaults()
{
Paging = true,
ItemsPerPage = 10,
Sorting = true,
NoResultsMessage = "No hay mas usuarios para mostrar",
NextButtonCaption = string.Empty,
PreviousButtonCaption = string.Empty,
SummaryMessage = "Viendo {0} a {1} de {2} registros"
};
MVCGridDefinitionTable.Add("PadresGrid", new MVCGridBuilder <Padre>(employeeGridDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
// Add your columns here
cols.Add().WithColumnName("Nombre").WithHeaderText("Nombre").WithValueExpression(i => i.Nombre).WithSorting(false);
cols.Add().WithColumnName("Apellido").WithHeaderText("Apellido").WithValueExpression(i => i.Apellido).WithSorting(false);
cols.Add().WithColumnName("Email").WithHeaderText("Email").WithValueExpression(i => i.Email).WithSorting(false);
cols.Add().WithColumnName("Hijos").WithHeaderText("Hijos").WithValueExpression(i => i.Hijos != null ? string.Join(", ", i.Hijos.Select(x => x.Nombre)) : string.Empty).WithSorting(false);
cols.Add().WithColumnName("Details").WithHeaderText("").WithCellCssClassExpression((i, c) => "action").WithHtmlEncoding(false)
.WithValueExpression((i, c) =>
string.Format("{0}{1}{2}",
string.Format("<a data-modal='' class='text-info' href='{0}' id='{1}' title='Asignar hijos'><span class='fa fa-server'></span></a>", c.UrlHelper.Action("Assign", "Padres", new { id = i.Id }), i.Id),
string.Format("<a data-modal='' class='text-info' href='{0}' id='{1}' title='Editar'><span class='fa fa-pencil'></span></a>", c.UrlHelper.Action("Form", "Padres", new { id = i.Id }), i.Id),
string.Format("<a data-modal='' class='text-info' href='{0}' id='{1}' title='Eliminar'><span class='fa fa-trash'></span></a>", c.UrlHelper.Action("Form", "Padres", new { id = i.Id, readOnly = true, delete = true }), i.Id)
));
})
.WithPaging(true, 10, true, 100)
.WithSorting(true, "Id")
.WithAdditionalQueryOptionNames("search")
.WithPageParameterNames("user")
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
var result = new QueryResult <Padre>();
string globalSearch = options.GetAdditionalQueryOptionString("search");
UsuarioLogueado usuarioLogueado = JsonConvert.DeserializeObject <UsuarioLogueado>(options.GetPageParameterString("user"));
IServicioWeb servicio = new ImplementacionService.ImplementacionService(); //BaseController.CreateService();
var data = servicio.ObtenerPadres(usuarioLogueado, options.PageIndex.Value, options.ItemsPerPage.Value, globalSearch);
return(new QueryResult <Padre>()
{
Items = data.Lista.ToArray(),
TotalRecords = data.CantidadRegistros,
});
})
);
}
private static GridDefaults GetGridDefaults()
{
GridDefaults gridDefaults = new GridDefaults()
{
Paging = true,
ItemsPerPage = 10,
Sorting = true,
};
return(gridDefaults);
}
public static void RegisterGrids()
{
ColumnDefaults colDefauls = new ColumnDefaults()
{
EnableSorting = true
};
MVCGridDefinitionTable.Add("TestGrid", new MVCGridBuilder<Person>(colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.WithSorting(sorting: true, defaultSortColumn: "Id", defaultSortDirection: SortDirection.Dsc)
.WithPaging(paging: true, itemsPerPage: 10, allowChangePageSize: true, maxItemsPerPage: 100)
.WithAdditionalQueryOptionNames("search")
.AddColumns(cols =>
{
cols.Add("Id").WithValueExpression((p, c) => c.UrlHelper.Action("detail", "demo", new { id = p.Id }))
.WithValueTemplate("<a href='{Value}'>{Model.Id}</a>", false)
.WithPlainTextValueExpression(p => p.Id.ToString());
cols.Add("FirstName").WithHeaderText("First Name")
.WithVisibility(true, true)
.WithValueExpression(p => p.FirstName);
cols.Add("LastName").WithHeaderText("Last Name")
.WithVisibility(true, true)
.WithValueExpression(p => p.LastName);
cols.Add("FullName").WithHeaderText("Full Name")
.WithValueTemplate("{Model.FirstName} {Model.LastName}")
.WithVisibility(visible: false, allowChangeVisibility: true)
.WithSorting(false);
cols.Add("StartDate").WithHeaderText("Start Date")
.WithVisibility(visible: true, allowChangeVisibility: true)
.WithValueExpression(p => p.StartDate.HasValue ? p.StartDate.Value.ToShortDateString() : "");
cols.Add("Status")
.WithSortColumnData("Active")
.WithVisibility(visible: true, allowChangeVisibility: true)
.WithHeaderText("Status")
.WithValueExpression(p => p.Active ? "Active" : "Inactive")
.WithCellCssClassExpression(p => p.Active ? "success" : "danger");
cols.Add("Gender").WithValueExpression((p, c) => p.Gender)
.WithAllowChangeVisibility(true);
cols.Add("Email")
.WithVisibility(visible: false, allowChangeVisibility: true)
.WithValueExpression(p => p.Email);
cols.Add("Url").WithVisibility(false)
.WithValueExpression((p, c) => c.UrlHelper.Action("detail", "demo", new { id = p.Id }));
})
//.WithAdditionalSetting(MVCGrid.Rendering.BootstrapRenderingEngine.SettingNameTableClass, "notreal") // Example of changing table css class
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
int totalRecords;
var repo = DependencyResolver.Current.GetService<IPersonRepository>();
string globalSearch = options.GetAdditionalQueryOptionString("search");
string sortColumn = options.GetSortColumnData<string>();
var items = repo.GetData(out totalRecords, globalSearch, options.GetLimitOffset(), options.GetLimitRowcount(),
sortColumn, options.SortDirection == SortDirection.Dsc);
return new QueryResult<Person>()
{
Items = items,
TotalRecords = totalRecords
};
})
);
MVCGridDefinitionTable.Add("EmployeeGrid", new MVCGridBuilder<Person>()
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
cols.Add("Id").WithValueExpression(p => p.Id.ToString());
cols.Add("FirstName").WithHeaderText("First Name")
.WithValueExpression(p => p.FirstName);
cols.Add("LastName").WithHeaderText("Last Name")
.WithValueExpression(p => p.LastName);
})
.WithRetrieveDataMethod((options) =>
{
var result = new QueryResult<Person>();
using (var db = new SampleDatabaseEntities())
{
result.Items = db.People.Where(p => p.Employee).ToList();
}
return result;
})
);
MVCGridDefinitionTable.Add("SortableGrid", new MVCGridBuilder<Person>(colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
cols.Add("Id").WithSorting(false)
.WithValueExpression(p => p.Id.ToString());
cols.Add("FirstName").WithHeaderText("First Name")
.WithValueExpression(p => p.FirstName);
cols.Add("LastName").WithHeaderText("Last Name")
.WithValueExpression(p => p.LastName);
})
.WithSorting(true, "LastName")
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
var result = new QueryResult<Person>();
using (var db = new SampleDatabaseEntities())
{
var query = db.People.Where(p => p.Employee);
if (!String.IsNullOrWhiteSpace(options.SortColumnName))
{
switch (options.SortColumnName.ToLower())
{
case "firstname":
query = query.OrderBy(p => p.FirstName, options.SortDirection);
break;
case "lastname":
query = query.OrderBy(p => p.LastName, options.SortDirection);
break;
}
}
result.Items = query.ToList();
}
return result;
})
);
MVCGridDefinitionTable.Add("PagingGrid", new MVCGridBuilder<Person>(colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
cols.Add("Id").WithSorting(false)
.WithValueExpression(p => p.Id.ToString());
cols.Add("FirstName").WithHeaderText("First Name")
.WithValueExpression(p => p.FirstName);
cols.Add("LastName").WithHeaderText("Last Name")
.WithValueExpression(p => p.LastName);
})
.WithSorting(true, "LastName")
.WithPaging(true, 10)
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
var result = new QueryResult<Person>();
using (var db = new SampleDatabaseEntities())
{
var query = db.People.AsQueryable();
result.TotalRecords = query.Count();
if (!String.IsNullOrWhiteSpace(options.SortColumnName))
{
switch (options.SortColumnName.ToLower())
{
case "firstname":
query = query.OrderBy(p => p.FirstName, options.SortDirection);
break;
case "lastname":
query = query.OrderBy(p => p.LastName, options.SortDirection);
break;
}
}
if (options.GetLimitOffset().HasValue)
{
query = query.Skip(options.GetLimitOffset().Value).Take(options.GetLimitRowcount().Value);
}
result.Items = query.ToList();
}
return result;
})
);
MVCGridDefinitionTable.Add("DIGrid", new MVCGridBuilder<Person>(colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
cols.Add("Id").WithSorting(false)
.WithValueExpression(p => p.Id.ToString());
cols.Add("FirstName").WithHeaderText("First Name")
.WithValueExpression(p => p.FirstName);
cols.Add("LastName").WithHeaderText("Last Name")
.WithValueExpression(p => p.LastName);
})
.WithSorting(true, "LastName")
.WithPaging(true, 10)
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
int totalRecords;
var repo = DependencyResolver.Current.GetService<IPersonRepository>();
var items = repo.GetData(out totalRecords, options.GetLimitOffset(), options.GetLimitRowcount(),
options.SortColumnName, options.SortDirection == SortDirection.Dsc);
return new QueryResult<Person>()
{
Items = items,
TotalRecords = totalRecords
};
})
);
MVCGridDefinitionTable.Add("FormattingGrid", new MVCGridBuilder<Person>(colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
cols.Add("Id").WithSorting(false)
.WithValueExpression(p => p.Id.ToString());
cols.Add("FirstName").WithHeaderText("First Name")
.WithValueExpression(p => p.FirstName);
cols.Add("LastName").WithHeaderText("Last Name")
.WithValueExpression(p => p.LastName);
cols.Add("StartDate").WithHeaderText("Start Date")
.WithValueExpression(p => p.StartDate.HasValue ? p.StartDate.Value.ToShortDateString() : "");
cols.Add("ViewLink").WithSorting(false)
.WithHeaderText("")
.WithHtmlEncoding(false)
.WithValueExpression((p, c) => c.UrlHelper.Action("detail", "demo", new { id = p.Id }))
.WithValueTemplate("<a href='{Value}'>View</a>");
})
.WithSorting(true, "LastName")
.WithPaging(true, 10)
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
int totalRecords;
var repo = DependencyResolver.Current.GetService<IPersonRepository>();
var items = repo.GetData(out totalRecords, options.GetLimitOffset(), options.GetLimitRowcount(),
options.SortColumnName, options.SortDirection == SortDirection.Dsc);
return new QueryResult<Person>()
{
Items = items,
TotalRecords = totalRecords
};
})
);
MVCGridDefinitionTable.Add("StyledGrid", new MVCGridBuilder<Person>(colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
cols.Add("Id").WithSorting(false)
.WithValueExpression(p => p.Id.ToString());
cols.Add("FirstName").WithHeaderText("First Name")
.WithValueExpression(p => p.FirstName);
cols.Add("LastName").WithHeaderText("Last Name")
.WithValueExpression(p => p.LastName);
cols.Add("StartDate").WithHeaderText("Start Date")
.WithValueExpression(p => p.StartDate.HasValue ? p.StartDate.Value.ToShortDateString() : "");
cols.Add("Status").WithSortColumnData("Active")
.WithHeaderText("Status")
.WithValueExpression(p => p.Active ? "Active" : "Inactive");
cols.Add("Gender").WithValueExpression(p => p.Gender)
.WithCellCssClassExpression(p => p.Gender == "Female" ? "danger" : "warning");
cols.Add().WithColumnName("ViewLink")
.WithSorting(false)
.WithHeaderText("")
.WithHtmlEncoding(false)
.WithValueExpression((p, c) => c.UrlHelper.Action("detail", new { id = p.Id }))
.WithValueTemplate("<a href='{Value}'>View</a>");
})
.WithRowCssClassExpression(p => p.Active ? "success" : "")
.WithSorting(true, "LastName")
.WithPaging(true, 10)
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
int totalRecords;
var repo = DependencyResolver.Current.GetService<IPersonRepository>();
string sortColumn = options.GetSortColumnData<string>();
var items = repo.GetData(out totalRecords, options.GetLimitOffset(), options.GetLimitRowcount(),
sortColumn, options.SortDirection == SortDirection.Dsc);
return new QueryResult<Person>()
{
Items = items,
TotalRecords = totalRecords
};
})
);
MVCGridDefinitionTable.Add("Preloading", new MVCGridBuilder<Person>(colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
cols.Add("Id").WithSorting(false)
.WithValueExpression(p => p.Id.ToString());
cols.Add("FirstName").WithHeaderText("First Name")
.WithValueExpression(p => p.FirstName);
cols.Add("LastName").WithHeaderText("Last Name")
.WithValueExpression(p => p.LastName);
})
.WithPreloadData(false)
.WithSorting(true, "LastName")
.WithPaging(true, 10)
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
int totalRecords;
var repo = DependencyResolver.Current.GetService<IPersonRepository>();
var items = repo.GetData(out totalRecords, options.GetLimitOffset(), options.GetLimitRowcount(),
options.GetSortColumnData<string>(), options.SortDirection == SortDirection.Dsc);
return new QueryResult<Person>()
{
Items = items,
TotalRecords = totalRecords
};
})
);
MVCGridDefinitionTable.Add("CustomLoading", new MVCGridBuilder<Person>(colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
cols.Add("Id").WithSorting(false)
.WithValueExpression(p => p.Id.ToString());
cols.Add("FirstName")
.WithHeaderText("First Name")
.WithValueExpression(p => p.FirstName);
cols.Add("LastName").WithHeaderText("Last Name")
.WithValueExpression(p => p.LastName);
})
.WithSorting(true, "LastName")
.WithPaging(true, 10)
.WithClientSideLoadingMessageFunctionName("showLoading")
.WithClientSideLoadingCompleteFunctionName("hideLoading")
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
int totalRecords;
var repo = DependencyResolver.Current.GetService<IPersonRepository>();
var items = repo.GetData(out totalRecords, options.GetLimitOffset(), options.GetLimitRowcount(),
options.GetSortColumnData<string>(), options.SortDirection == SortDirection.Dsc);
// pause to test loading message
System.Threading.Thread.Sleep(1000);
return new QueryResult<Person>()
{
Items = items,
TotalRecords = totalRecords
};
})
);
MVCGridDefinitionTable.Add("Filtering", new MVCGridBuilder<Person>(colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
cols.Add("Id").WithSorting(false)
.WithValueExpression(p => p.Id.ToString());
cols.Add("LastName").WithHeaderText("Last Name")
.WithValueExpression(p => p.LastName)
.WithFiltering(true);
cols.Add("FirstName").WithHeaderText("First Name")
.WithValueExpression(p => p.FirstName)
.WithFiltering(true);
cols.Add("Status").WithSortColumnData("Active")
.WithHeaderText("Status")
.WithValueExpression(p => p.Active ? "Active" : "Inactive")
.WithFiltering(true);
})
.WithSorting(true, "LastName")
.WithPaging(true, 10, true, 100)
.WithFiltering(true)
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
int totalRecords;
var repo = DependencyResolver.Current.GetService<IPersonRepository>();
bool? active = null;
string fa = options.GetFilterString("Status");
if (!String.IsNullOrWhiteSpace(fa))
{
active = (String.Compare(fa, "active", true) == 0);
}
string sortColumn = options.GetSortColumnData<string>();
var items = repo.GetData(out totalRecords,
options.GetFilterString("FirstName"),
options.GetFilterString("LastName"),
active,
options.GetLimitOffset(), options.GetLimitRowcount(),
sortColumn, options.SortDirection == SortDirection.Dsc);
return new QueryResult<Person>()
{
Items = items,
TotalRecords = totalRecords
};
})
);
MVCGridDefinitionTable.Add("ExportGrid", new MVCGridBuilder<Person>(colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
cols.Add().WithColumnName("Id")
.WithSorting(false)
.WithHtmlEncoding(false)
.WithValueExpression((p, c) =>
{
return String.Format("<a href='{0}'>{1}</a>",
c.UrlHelper.Action("detail", "demo", new { id = p.Id }), p.Id);
})
.WithPlainTextValueExpression(p => p.Id.ToString());
cols.Add("FirstName").WithHeaderText("First Name")
.WithValueExpression(p => p.FirstName);
cols.Add("LastName").WithHeaderText("Last Name")
.WithValueExpression(p => p.LastName);
cols.Add("Status").WithSortColumnData("Active")
.WithHeaderText("Status")
.WithValueExpression(p => p.Active ? "Active" : "Inactive");
})
.WithSorting(true, "LastName")
.WithPaging(true, 10)
.WithClientSideLoadingMessageFunctionName("showLoading")
.WithClientSideLoadingCompleteFunctionName("hideLoading")
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
int totalRecords;
var repo = DependencyResolver.Current.GetService<IPersonRepository>();
string sortColumn = options.GetSortColumnData<string>();
var items = repo.GetData(out totalRecords,
options.GetLimitOffset(), options.GetLimitRowcount(),
sortColumn, options.SortDirection == SortDirection.Dsc);
return new QueryResult<Person>()
{
Items = items,
TotalRecords = totalRecords
};
})
);
MVCGridDefinitionTable.Add("Multiple1", new MVCGridBuilder<Person>(colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
cols.Add("Id").WithSorting(false)
.WithHtmlEncoding(false)
.WithValueExpression((p, c) => c.UrlHelper.Action("detail", "demo", new { id = p.Id }))
.WithValueTemplate("<a href='{Value}'>{Model.Id}</a>")
.WithPlainTextValueExpression((p, c) => p.Id.ToString());
cols.Add("FirstName").WithHeaderText("First Name")
.WithValueExpression(p => p.FirstName);
cols.Add("LastName").WithHeaderText("Last Name")
.WithValueExpression(p => p.LastName);
cols.Add("Status").WithSortColumnData("Active")
.WithHeaderText("Status")
.WithValueExpression(p => p.Active ? "Active" : "Inactive");
})
.WithSorting(true, "LastName")
.WithPaging(true, 10)
.WithQueryStringPrefix("grid1")
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
int totalRecords;
var repo = DependencyResolver.Current.GetService<IPersonRepository>();
string sortColumn = options.GetSortColumnData<string>();
var items = repo.GetData(out totalRecords,
options.GetLimitOffset(), options.GetLimitRowcount(),
sortColumn, options.SortDirection == SortDirection.Dsc);
return new QueryResult<Person>()
{
Items = items,
TotalRecords = totalRecords
};
})
);
MVCGridDefinitionTable.Add("Multiple2", new MVCGridBuilder<TestItem>(colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
cols.Add("Col1").WithValueExpression(p => p.Col1);
cols.Add("Col2").WithValueExpression(p => p.Col2);
cols.Add("Col3").WithValueExpression(p => p.Col3);
})
.WithSorting(true, "Col1")
.WithPaging(true, 10)
.WithQueryStringPrefix("grid2")
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
TestItemRepository repo = new TestItemRepository();
int totalRecords;
var items = repo.GetData(out totalRecords, options.GetLimitOffset(), options.GetLimitRowcount(), options.GetSortColumnData<string>(), options.SortDirection == SortDirection.Dsc);
return new QueryResult<TestItem>()
{
Items = items,
TotalRecords = totalRecords
};
})
);
MVCGridDefinitionTable.Add("CustomStyle", new MVCGridBuilder<Person>(colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
cols.Add("Id").WithSorting(false)
.WithHtmlEncoding(false)
.WithValueExpression((p, c) => c.UrlHelper.Action("detail", "demo", new { id = p.Id }))
.WithValueTemplate("<a href='{Value}'>{Model.Id}</a>")
.WithPlainTextValueExpression(p => p.Id.ToString());
cols.Add("FirstName").WithHeaderText("First Name")
.WithValueExpression(p => p.FirstName);
cols.Add("LastName").WithHeaderText("Last Name")
.WithValueExpression(p => p.LastName);
cols.Add("Status").WithSortColumnData("Active")
.WithHeaderText("Status")
.WithValueExpression(p => p.Active ? "Active" : "Inactive");
})
.WithRenderingEngine(typeof(CustomHtmlRenderingEngine))
.WithSorting(true, "LastName")
.WithPaging(true, 20)
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
int totalRecords;
var repo = DependencyResolver.Current.GetService<IPersonRepository>();
string sortColumn = options.GetSortColumnData<string>();
var items = repo.GetData(out totalRecords,
options.GetLimitOffset(), options.GetLimitRowcount(),
sortColumn, options.SortDirection == SortDirection.Dsc);
return new QueryResult<Person>()
{
Items = items,
TotalRecords = totalRecords
};
})
);
MVCGridDefinitionTable.Add("CustomRazorView", new MVCGridBuilder<Person>(colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.WithRenderingMode(RenderingMode.Controller)
.WithViewPath("~/Views/MVCGrid/_Custom.cshtml")
.AddColumns(cols =>
{
cols.Add("Id").WithSorting(false)
.WithHtmlEncoding(false)
.WithValueExpression((p, c) => c.UrlHelper.Action("detail", "demo", new { id = p.Id }))
.WithValueTemplate("<a href='{Value}'>{Model.Id}</a>")
.WithPlainTextValueExpression(p => p.Id.ToString());
cols.Add("FirstName").WithHeaderText("First Name")
.WithValueExpression(p => p.FirstName);
cols.Add("LastName").WithHeaderText("Last Name")
.WithValueExpression(p => p.LastName);
cols.Add("Status").WithSortColumnData("Active")
.WithHeaderText("Status")
.WithValueExpression(p => p.Active ? "Active" : "Inactive");
})
.WithSorting(true, "LastName")
.WithPaging(true, 20)
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
int totalRecords;
var repo = DependencyResolver.Current.GetService<IPersonRepository>();
string sortColumn = options.GetSortColumnData<string>();
var items = repo.GetData(out totalRecords,
options.GetLimitOffset(), options.GetLimitRowcount(),
sortColumn, options.SortDirection == SortDirection.Dsc);
return new QueryResult<Person>()
{
Items = items,
TotalRecords = totalRecords
};
})
);
MVCGridDefinitionTable.Add("ValueTemplate", new MVCGridBuilder<Person>(colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
cols.Add("Id").WithSorting(false)
.WithValueExpression((p, c) => c.UrlHelper.Action("detail", "demo", new { id = p.Id }))
.WithValueTemplate("<a href='{Value}'>{Model.Id}</a>", false)
.WithPlainTextValueExpression(p => p.Id.ToString());
cols.Add("FirstName").WithHeaderText("First Name")
.WithValueExpression(p => p.FirstName);
cols.Add("LastName").WithHeaderText("Last Name")
.WithValueExpression(p => p.LastName);
cols.Add("Edit").WithHtmlEncoding(false)
.WithSorting(false)
.WithHeaderText(" ")
.WithValueExpression((p, c) => c.UrlHelper.Action("detail", "demo", new { id = p.Id }))
.WithValueTemplate("<a href='{Value}' class='btn btn-primary' role='button'>Edit</a>");
cols.Add("Delete").WithHtmlEncoding(false)
.WithSorting(false)
.WithHeaderText(" ")
.WithValueExpression((p, c) => c.UrlHelper.Action("detail", "demo", new { id = p.Id }))
.WithValueTemplate("<a href='{Value}' class='btn btn-danger' role='button'>Delete</a>");
cols.Add("Example").WithHtmlEncoding(false)
.WithSorting(false)
.WithHeaderText("Example")
.WithValueExpression((p, c) => p.Active ? "label-success" : "label-danger")
.WithValueTemplate("You can access any of the item's properties: <strong>{Model.FirstName}</strong> <br />or the current column value: <span class='label {Value}'>{Model.Active}</span>");
})
.WithSorting(true, "LastName")
.WithPaging(true, 20)
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
int totalRecords;
var repo = DependencyResolver.Current.GetService<IPersonRepository>();
string sortColumn = options.GetSortColumnData<string>();
var items = repo.GetData(out totalRecords,
options.GetLimitOffset(), options.GetLimitRowcount(),
sortColumn, options.SortDirection == SortDirection.Dsc);
return new QueryResult<Person>()
{
Items = items,
TotalRecords = totalRecords
};
})
);
MVCGridDefinitionTable.Add("CustomErrorMessage", new MVCGridBuilder<Person>(colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
cols.Add("Id").WithSorting(false)
.WithValueExpression(p => p.Id.ToString());
cols.Add("FirstName").WithHeaderText("First Name")
.WithValueExpression(p => p.FirstName);
cols.Add("LastName").WithHeaderText("Last Name")
.WithValueExpression(p => p.LastName);
})
.WithErrorMessageHtml(@"<div class=""alert alert-danger"" role=""alert"">OH NO!!!</div>")
.WithSorting(true, "LastName")
.WithPaging(true)
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
var result = new QueryResult<Person>();
using (var db = new SampleDatabaseEntities())
{
var query = db.People.AsQueryable();
result.TotalRecords = query.Count();
if (!String.IsNullOrWhiteSpace(options.SortColumnName))
{
switch (options.SortColumnName.ToLower())
{
case "firstname":
throw new Exception("Test exception");
case "lastname":
query = query.OrderBy(p => p.LastName, options.SortDirection);
break;
}
}
if (options.GetLimitOffset().HasValue)
{
query = query.Skip(options.GetLimitOffset().Value).Take(options.GetLimitRowcount().Value);
}
result.Items = query.ToList();
}
return result;
})
);
MVCGridDefinitionTable.Add("UsageExample", new MVCGridBuilder<YourModelItem>()
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
// Add your columns here
cols.Add("UniqueColumnName").WithHeaderText("Any Header")
.WithValueExpression(i => i.YourProperty); // use the Value Expression to return the cell text for this column
cols.Add().WithColumnName("UrlExample")
.WithHeaderText("Edit")
.WithValueExpression((i, c) => c.UrlHelper.Action("detail", "demo", new { id = i.YourProperty }));
})
.WithRetrieveDataMethod((context) =>
{
// Query your data here. Obey Ordering, paging and filtering paramters given in the context.QueryOptions.
// Use Entity Framwork, a module from your IoC Container, or any other method.
// Return QueryResult object containing IEnumerable<YouModelItem>
return new QueryResult<YourModelItem>()
{
Items = new List<YourModelItem>(),
TotalRecords = 0 // if paging is enabled, return the total number of records of all pages
};
})
);
MVCGridDefinitionTable.Add("GlobalSearchGrid", new MVCGridBuilder<Person>(colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
cols.Add("Id").WithSorting(false)
.WithValueExpression(p => p.Id.ToString());
cols.Add("FirstName").WithHeaderText("First Name")
.WithValueExpression(p => p.FirstName);
cols.Add("LastName").WithHeaderText("Last Name")
.WithValueExpression(p => p.LastName);
})
.WithAdditionalQueryOptionNames("Search")
.WithAdditionalSetting("RenderLoadingDiv", false)
.WithSorting(true, "LastName")
.WithPaging(true, 10, true, 100)
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
int totalRecords;
var repo = DependencyResolver.Current.GetService<IPersonRepository>();
string globalSearch = options.GetAdditionalQueryOptionString("Search");
var items = repo.GetData(out totalRecords, globalSearch, options.GetLimitOffset(), options.GetLimitRowcount(),
options.SortColumnName, options.SortDirection == SortDirection.Dsc);
return new QueryResult<Person>()
{
Items = items,
TotalRecords = totalRecords
};
})
);
MVCGridDefinitionTable.Add("PageSizeGrid", new MVCGridBuilder<Person>(colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
cols.Add("Id").WithSorting(false)
.WithValueExpression(p => p.Id.ToString());
cols.Add("FirstName").WithHeaderText("First Name")
.WithValueExpression(p => p.FirstName);
cols.Add("LastName").WithHeaderText("Last Name")
.WithValueExpression(p => p.LastName);
})
.WithSorting(true, "LastName")
.WithPaging(true, 10, true, 100)
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
int totalRecords;
var repo = DependencyResolver.Current.GetService<IPersonRepository>();
var items = repo.GetData(out totalRecords, options.GetLimitOffset(), options.GetLimitRowcount(),
options.SortColumnName, options.SortDirection == SortDirection.Dsc);
return new QueryResult<Person>()
{
Items = items,
TotalRecords = totalRecords
};
})
);
MVCGridDefinitionTable.Add("ColumnVisibilityGrid", new MVCGridBuilder<Person>(colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
cols.Add("Id").WithSorting(false)
.WithValueExpression(p => p.Id.ToString());
cols.Add("FirstName").WithHeaderText("First Name")
.WithValueExpression(p => p.FirstName);
cols.Add("LastName").WithHeaderText("Last Name")
.WithValueExpression(p => p.LastName);
cols.Add("StartDate").WithHeaderText("Start Date")
.WithVisibility(false, true)
.WithValueExpression(p => p.StartDate.HasValue ? p.StartDate.Value.ToShortDateString() : "");
cols.Add("Status").WithSortColumnData("Active")
.WithHeaderText("Status")
.WithVisibility(false, true)
.WithValueExpression(p => p.Active ? "Active" : "Inactive")
.WithCellCssClassExpression((p, c) => p.Active ? "success" : "danger");
cols.Add("Gender")
.WithVisibility(false, true)
.WithValueExpression(p => p.Gender);
})
.WithSorting(true, "LastName")
.WithPaging(true, 10)
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
int totalRecords;
var repo = DependencyResolver.Current.GetService<IPersonRepository>();
var items = repo.GetData(out totalRecords, options.GetLimitOffset(), options.GetLimitRowcount(),
options.SortColumnName, options.SortDirection == SortDirection.Dsc);
return new QueryResult<Person>()
{
Items = items,
TotalRecords = totalRecords
};
})
);
MVCGridDefinitionTable.Add("NestedObjectTest", new MVCGridBuilder<Job>()
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.WithPaging(true)
.AddColumns(cols =>
{
cols.Add("Id", "Id", row => row.JobId.ToString());
cols.Add("Name", "Name", row => row.Name);
cols.Add("Contact")
.WithHeaderText("Contact")
.WithHtmlEncoding(false)
.WithSorting(true)
.WithValueExpression((p, c) => p.Contact != null ? c.UrlHelper.Action("Edit", "Contact", new { id = p.Contact.Id }) : "")
.WithValueTemplate("<a href='{Value}'>{Model.Contact.FullName}</a>").WithPlainTextValueExpression((p, c) => p.Contact != null ? p.Contact.FullName : "");
})
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
JobRepo repo = new JobRepo();
int totalRecords;
var data = repo.GetData(out totalRecords, null, options.GetLimitOffset(), options.GetLimitRowcount(), null, false);
return new QueryResult<Job>()
{
Items = data,
TotalRecords = totalRecords
};
})
);
MVCGridDefinitionTable.Add("PPGrid", new MVCGridBuilder<Person>(colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.WithPageParameterNames("Active")
.AddColumns(cols =>
{
cols.Add("Id").WithSorting(false)
.WithValueExpression(p => p.Id.ToString());
cols.Add("FirstName").WithHeaderText("First Name")
.WithValueExpression(p => p.FirstName);
cols.Add("LastName").WithHeaderText("Last Name")
.WithValueExpression(p => p.LastName);
})
.WithPreloadData(true)
.WithSorting(true, "LastName")
.WithPaging(true, 10)
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
int totalRecords;
var repo = DependencyResolver.Current.GetService<IPersonRepository>();
string ppactive = options.GetPageParameterString("active");
bool filterActive = bool.Parse(ppactive);
var items = repo.GetData(out totalRecords, null,null, filterActive, options.GetLimitOffset(), options.GetLimitRowcount(),
options.GetSortColumnData<string>(), options.SortDirection == SortDirection.Dsc);
return new QueryResult<Person>()
{
Items = items,
TotalRecords = totalRecords
};
})
);
MVCGridDefinitionTable.Add("QPLGrid", new MVCGridBuilder<Person>(colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.WithQueryOnPageLoad(false)
.WithPreloadData(false)
.AddColumns(cols =>
{
cols.Add("Id").WithSorting(false)
.WithValueExpression(p => p.Id.ToString());
cols.Add("FirstName").WithHeaderText("First Name")
.WithValueExpression(p => p.FirstName);
cols.Add("LastName").WithHeaderText("Last Name")
.WithValueExpression(p => p.LastName);
})
.WithSorting(true, "LastName")
.WithPaging(true, 10)
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
int totalRecords;
var repo = DependencyResolver.Current.GetService<IPersonRepository>();
var items = repo.GetData(out totalRecords, options.GetLimitOffset(), options.GetLimitRowcount(),
options.GetSortColumnData<string>(), options.SortDirection == SortDirection.Dsc);
return new QueryResult<Person>()
{
Items = items,
TotalRecords = totalRecords
};
})
);
//MVCGridDefinitionTable.Add DO NOT DELETE - Needed for demo code parsing
GridDefinition<YourModelItem> def = new GridDefinition<YourModelItem>();
GridColumn<YourModelItem> column = new GridColumn<YourModelItem>();
column.ColumnName = "UniqueColumnName";
column.HeaderText = "Any Header";
column.ValueExpression = (i, c) => i.YourProperty;
def.AddColumn(column);
def.RetrieveData = (options) =>
{
return new QueryResult<YourModelItem>()
{
Items = new List<YourModelItem>(),
TotalRecords = 0
};
};
MVCGridDefinitionTable.Add("NonFluentUsageExample", def);
GridDefaults defaultSet1 = new GridDefaults()
{
Paging = true,
ItemsPerPage = 20,
Sorting = true,
NoResultsMessage = "Sorry, no results were found"
};
MVCGridDefinitionTable.Add("DefaultsExample",
new MVCGridBuilder<YourModelItem>(defaultSet1) // pass in defauls object to ctor
.AddColumns(cols =>
{
// add columns
})
.WithDefaultSortColumn("Test")
.WithRetrieveDataMethod((context) =>
{
//get data
return new QueryResult<YourModelItem>();
})
);
var docsReturnTypeColumn = new GridColumn<MethodDocItem>()
{
ColumnName = "ReturnType",
HeaderText = "Return Type",
HtmlEncode = false,
ValueExpression = (p, c) => String.Format("<code>{0}</code>", HttpUtility.HtmlEncode(p.Return))
};
var docsNameColumn = new GridColumn<MethodDocItem>()
{
ColumnName = "Name",
HtmlEncode = false,
ValueExpression = (p, c) => String.Format("<code>{0}</code>", HttpUtility.HtmlEncode(p.Name))
};
var docsDescriptionColumn = new GridColumn<MethodDocItem>()
{
ColumnName = "Description",
ValueExpression = (p, c) => p.Description
};
Func<GridContext, QueryResult<MethodDocItem>> docsLoadData = (context) =>
{
var result = new QueryResult<MethodDocItem>();
DocumentationRepository repo = new DocumentationRepository();
result.Items = repo.GetData(context.GridName);
return result;
};
MVCGridDefinitionTable.Add("GridDefinition", new MVCGridBuilder<MethodDocItem>()
.AddColumn(docsNameColumn)
.AddColumn(docsReturnTypeColumn)
.AddColumn(docsDescriptionColumn)
.WithRetrieveDataMethod(docsLoadData)
);
MVCGridDefinitionTable.Add("GridColumn", new MVCGridBuilder<MethodDocItem>()
.AddColumn(docsNameColumn)
.AddColumn(docsReturnTypeColumn)
.AddColumn(docsDescriptionColumn)
.WithRetrieveDataMethod(docsLoadData)
);
MVCGridDefinitionTable.Add("QueryOptions", new MVCGridBuilder<MethodDocItem>()
.AddColumn(docsNameColumn)
.AddColumn(docsReturnTypeColumn)
.AddColumn(docsDescriptionColumn)
.WithRetrieveDataMethod(docsLoadData)
);
MVCGridDefinitionTable.Add("ClientSide", new MVCGridBuilder<MethodDocItem>()
.AddColumn(docsNameColumn)
.AddColumn(docsDescriptionColumn)
.WithRetrieveDataMethod(docsLoadData)
);
}
public SignalRMVCGridBuilder(string gridName, SignalRGridType signalRGridType, GridDefaults gridDefaults) : base(gridDefaults, null)
{
InitializeSignalR(gridName, signalRGridType);
}
public static void RegisterGrids()
{
GridDefaults gridDefaults = new GridDefaults()
{
Paging = true,
ItemsPerPage = 20,
Sorting = true,
NoResultsMessage = "Sorry, no results were found"
};
ColumnDefaults colDefaults = new ColumnDefaults()
{
EnableSorting = true
};
MVCGridDefinitionTable.Add("StudentGrid", new MVCGridBuilder <tblStudent>(colDefaults)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
// Add your columns here
cols.Add("StudID").WithValueExpression(p => p.StudID.ToString());
cols.Add("StudCode").WithValueExpression(p => p.StudCode.ToString());
cols.Add("FullName").WithHeaderText("FullName")
.WithValueExpression(p => p.FullName);
})
.WithSorting(true, "StudCode")
.WithPaging(true, 10)
.WithRetrieveDataMethod((context) =>
{
var result = new QueryResult <tblStudent>();
using (var db = new SchoolTimeContext())
{
result.Items = db.tblStudents.ToList();
}
return(result);
})
);
MVCGridDefinitionTable.Add("SujectsGrid", new MVCGridBuilder <tblSuject>()
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
// Add your columns here
cols.Add("SujectID").WithValueExpression(p => p.SujectID.ToString());
cols.Add("SujectCode").WithValueExpression(p => p.SujectCode.ToString());
cols.Add("SujectName").WithValueExpression(p => p.SujectName.ToString());
})
.WithRetrieveDataMethod((context) =>
{
var result = new QueryResult <tblSuject>();
using (var db = new SchoolTimeContext())
{
result.Items = db.tblSujects.ToList();
}
return(result);
})
);
MVCGridDefinitionTable.Add("TeacherGrid", new MVCGridBuilder <tblTeacher>()
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
// Add your columns here
cols.Add("teachID").WithValueExpression(p => p.teachID.ToString());
cols.Add("teachCode").WithValueExpression(p => p.teachCode.ToString());
cols.Add("FullName").WithValueExpression(p => p.FullName.ToString());
})
.WithRetrieveDataMethod((context) =>
{
var result = new QueryResult <tblTeacher>();
using (var db = new SchoolTimeContext())
{
result.Items = db.tblTeachers.ToList();
}
return(result);
})
);
}
public static void RegisterGrid(GridDefaults gridDefaults, ColumnDefaults colDefauls)
{
RegisterGrid(gridDefaults, colDefauls, GRID_NAME);
}
