@(Html.Kendo().Grid()
.Name("grid")
.NoRecords("No user assignment found")
.ToolBar(tools => tools.Excel())
.Excel(excel => excel .AllPages(true)
.FileName("UserAssignments.xlsx"))
.Columns(columns =>
{
columns.Template(@).ClientTemplate("")
.HeaderTemplate("").Width(8);
columns.Bound(c => c.ID).Width(0).Title("ID").Visible(false);
columns.Bound(c => c.EmployeeName).Width(20).Title("Employee Name").Visible(false);
columns.Bound(c => c.StartDate).Width(14).Title("Start Date");
columns.Bound(c => c.CompletionDate).Width(16).Title("Completion Date");
columns.Bound(c => c.Status).Width(10).Title("Status").Visible(false);
})
.HtmlAttributes(new { style = "height: 1500px; width:1080px;" })
.Scrollable()
.Sortable()
.Events(e => e.ExcelExport("exportToExcelSheetColumnWidthChange"))
.Filterable(filterable => filterable
.Extra(false)
.Operators(operators => operators
.ForString(str => str
.Clear()
.Contains("Contains")
.IsEqualTo("Is equal to")
)
)
)
.Pageable(pageable => pageable
.Refresh(true)
.PageSizes(true)
.ButtonCount(5))
.DataSource(dataSource => dataSource
.Ajax()
.Read(read => read.Action("GetEmployeeDataListing", "Employee"))
.PageSize(20)
)
.Scrollable()
.Events(events => events.DataBound("onGridDataFound").DataBound("onDataBound"))
)