@Html.EJS().DropDownList("MEMBER").Placeholder("Select a memeber to REJECT").Width("200").PopupHeight("200px").DataSource(
(IEnumerable<STAFF_LIST>)ViewBag.staffList).Fields(new DropDownListFieldSettings
{
Text = "EMPLOYEE_NAME",
Value = "EMPLOYEE_ID"
}).SortOrder((string)ViewBag.sort).Query((string)ViewBag.query).Render()
@Html.EJS().Button("btnReject").Content("Reject").IsPrimary(true).IsToggle(true).Render()
</div>
<br />
@Html.EJS(
).Grid(
"gDailyTimeSheet"
).DataSource(
ds => ds.Url(@Url.Action("TeamDatasource", "Master", new { date = TempData["sheetDate"].ToString(), EMPLOYEE_ID = TempData["EMPLOYEE_ID"].ToString() }))
.Adaptor("UrlAdaptor")
).AllowGrouping(
).AllowSorting(
).Columns(
col =>
{
col.Field("WEEK_DATE").HeaderText("WEEK_DATE").Width("100").Visible(false).DefaultValue(TempData["sheetDate"].ToString()).Add();
col.Field("EMPLOYEE_ID").HeaderText("EMPLOYEE_ID").Width("100").Visible(false).DefaultValue(TempData["EMPLOYEE_ID"].ToString()).Add();
col.Field("EMPLOYEE_NAME").HeaderText("Team Member").Width("100").DefaultValue(TempData["EMPLOYEE_ID"].ToString()).Add();
col.Field("TASK_PROJECT").HeaderText("Project").Width("300").DefaultValue(" ")
.EditType("dropdownedit")
.Edit(
new
{
@params = new
{
fields = new
{
text = "TASK_PROJECT",
value = "TASK_PROJECT"
},
dataSource = @ViewBag.projectList
}
}
).Add();
col.Field("TASK_ID").HeaderText("TASK").Width("400").DefaultValue(" ")
.EditType("dropdownedit")
.Edit(
new
{
@params = new
{
fields = new
{
text = "TASK_ID",
value = "TASK_ID"
},
dataSource = @ViewBag.taskList
}
}
).Add();
col.Field("TASK_TYPE").HeaderText("Type").Width("200").DefaultValue(" ")
.EditType("dropdownedit")
.Edit(
new
{
@params = new
{
value = "NORMAL",
fields = new { text = "TASK_TYPE", value = "TASK_TYPE" },
dataSource = @ViewBag.taskType
}
}
).Add();
col.Field("SUNDAY").HeaderText(ViewBag.Sunday).Width("100").Format("0.0").DefaultValue("0.0").EditType("numericedit").TextAlign(Syncfusion.EJ2.Grids.TextAlign.Right).Add();
col.Field("MONDAY").HeaderText(ViewBag.Monday).Width("100").Format("0.0").DefaultValue("0.0").EditType("numericedit").TextAlign(Syncfusion.EJ2.Grids.TextAlign.Right).Add();
col.Field("TUESDAY").HeaderText(ViewBag.Tuesday).Width("100").Format("0.0").DefaultValue("0.0").EditType("numericedit").TextAlign(Syncfusion.EJ2.Grids.TextAlign.Right).Add();
col.Field("WEDNESDAY").HeaderText(ViewBag.Wednesday).Width("100").Format("0.0").DefaultValue("0.0").EditType("numericedit").TextAlign(Syncfusion.EJ2.Grids.TextAlign.Right).Add();
col.Field("THURSDAY").HeaderText(ViewBag.Thursday).Width("100").Format("0.0").DefaultValue("0.0").EditType("numericedit").TextAlign(Syncfusion.EJ2.Grids.TextAlign.Right).Add();
col.Field("FRIDAY").HeaderText(ViewBag.Friday).Width("100").Format("0.0").DefaultValue("0.0").EditType("numericedit").TextAlign(Syncfusion.EJ2.Grids.TextAlign.Right).Add();
col.Field("SATURDAY").HeaderText(ViewBag.Saturday).Width("100").Format("0.0").DefaultValue("0.0").EditType("numericedit").TextAlign(Syncfusion.EJ2.Grids.TextAlign.Right).Add();
}
).EditSettings(
edit =>
{
edit.AllowEditing(true).AllowDeleting(true).Mode(Syncfusion.EJ2.Grids.EditMode.Batch).ShowDeleteConfirmDialog(true);
}
).Load(
"load"
).GroupSettings(group => group.ShowDropArea(true).Columns(new string[] { "EMPLOYEE_NAME" })
).Aggregates(
agg =>
{
agg.Columns(new List<Syncfusion.EJ2.Grids.GridAggregateColumn>() {
new Syncfusion.EJ2.Grids.GridAggregateColumn() { Field = "SUNDAY", Format ="0.0" , Type = "Sum", FooterTemplate = "${Sum}" }
, new Syncfusion.EJ2.Grids.GridAggregateColumn() { Field = "MONDAY", Format ="0.0" , Type = "Sum", FooterTemplate = "${Sum}" }
, new Syncfusion.EJ2.Grids.GridAggregateColumn() { Field = "TUESDAY", Format ="0.0" , Type = "Sum", FooterTemplate = "${Sum}" }
, new Syncfusion.EJ2.Grids.GridAggregateColumn() { Field = "WEDNESDAY", Format ="0.0", Type = "Sum", FooterTemplate = "${Sum}" }
, new Syncfusion.EJ2.Grids.GridAggregateColumn() { Field = "THURSDAY", Format ="0.0", Type = "Sum", FooterTemplate = "${Sum}" }
, new Syncfusion.EJ2.Grids.GridAggregateColumn() { Field = "FRIDAY", Format ="0.0", Type = "Sum", FooterTemplate = "${Sum}" }
, new Syncfusion.EJ2.Grids.GridAggregateColumn() { Field = "SATURDAY", Format ="0.0", Type = "Sum", FooterTemplate = "${Sum}" }
}).Add();
}
).Toolbar(
toolbarItems
).AllowTextWrap(
true
).ToolbarClick("toolbarClick").Render()
Please help to advance how to display an aggregate subtotal on each of grouping instead of the grand total thx.