or
I want to sum my orders as GrandTotal, But my grid cannot do it.
Grand Total row is always 0
Please help Urgent
Big Thanks
my grid
@(Html.Kendo().Grid((IEnumerable<Apex.Models.bmfsummary>)ViewData[
"BMFsummary"
])
.Name(
"Grid"
)
.Columns(cols =>
{
cols.Bound(ss => ss.eventdate).Title(
"Date"
).ClientFooterTemplate(
"Grand Total"
);
cols.Bound(ss => ss.totalPrice).Title(
"Total"
).Format(
"{0:n2}"
).ClientFooterTemplate(
"#=sum#"
);
})
.DataSource(dataSource =>
dataSource.Ajax()
.Aggregates(aggregates => { aggregates.Add(ss => ss.totalPrice).Sum(); } )
.Read(read => read.Action(
"Summary"
,
"BMF"
))
)
<
div
data-role
=
"view"
data-title
=
"Views"
id
=
"overview-list"
data-init
=
"ProjectList"
data-layout
=
"overview-layout"
>
<
ul
data-role
=
"listview"
data-style
=
"inset"
data-type
=
"group"
>
<
li
>
<
ul
id
=
"endless-scrolling"
>
</
ul
>
</
li
>
</
ul
>
<
script
id
=
"endless-scrolling-template"
type
=
"text/x-kendo-template"
>
<
a
href
=
"/_layouts/projectDetail.aspx?id=#=ID #"
data-transition
=
"slide"
">
<
div
class
=
"Lists"
>
<
img
class
=
"pullImage"
src
=
"#=Picture1 #"
/>#= Title #
<
div
class
=
"metadata"
>
#= Description #
</
div
>
</
div
>
</
a
>
</
script
>
</
div
>
and my Javascript:
$(function () {
window.kendoMobileApplication = new kendo.mobile.Application(document.body);
});
var Skip = 0; //Number of skipped row
var Take = 1; //
function ProjectList() {
var dataSource = new kendo.data.DataSource({
transport: {
read: function (options) {
// make AJAX request to the remote service
$.ajax({
type: "POST",
url: "mobile.aspx/AllProject",
data: "{ Skip:" + Skip + ", Take:" + Take + " }",
contentType: "application/json; charset=utf-8",
dataType: "json",
headers: { "cache-control": "no-cache" },
success: function (data) {
Skip = Skip + Take;
options.success(data.d);
}
});
},
cache: false
},
schema: {
total: function () { return 0; }
}
});
var listMore =$("#endless-scrolling").kendoMobileListView({
dataSource: dataSource,
template: $("#endless-scrolling-template").text(),
loadMore: true
});
}
<
script
type
=
"text/x-kendo-template"
id
=
"tmpl_jailcard_comment"
>
begin list
<
ul
data-role
=
"listview"
data-style
=
"inset"
data-type
=
"group"
>
<
li
id
=
"Item-A"
>AAA</
li
>
<
li
id
=
"Item-B"
>BBB</
li
>
<
li
id
=
"Item-C"
>CCC</
li
>
</
ul
>
end list
</
script
>
<
span
data-bind
=
"source:this"
data-template
=
"tmpl_jailcard_comment"
></
span
>
kendo.bind("#scr_jailcard_comment", viewModel);
public
class
Member {
public
Member() {
this
.Relatives =
new
List<Relative>();
}
public
string
Id {
get
;
set
; }
public
string
Name {
get
;
set
; }
public
ICollection<Relative> Relatives {
get
;
set
; }
}
public
class
Relative {
public
string
Name {
get
;
set
; }
public
int
Age {
get
;
set
; }
}
Member.Id
Member.Name
Member.Relatives[0][Name]
Member.Relatives[0][Age]
Member.Relatives[1][Name]
Member.Relatives[1][Age]
Member[Id]
Member[Name]
Member[Relatives][0][Name]
Member[Relatives][0][Age]
Member[Relatives][1][Name]
Member[Relatives][1][Age]
filterable: {
ui: "datetimepicker"
}
<
P
>The <
ins
>black</
ins
> spotted fox <
del
>leaped</
del
>
over the rolling<
br
>new</
P
>
var
rows = chooseGrid.select(),
dataItems = [];
for
(
var
i = rows.length; i--;) {
dataItems.unshift(chooseGrid.dataItem(rows[i]));
chooseGrid.dataSource.remove(dataItems[0]);
koqGrid.dataSource.insert(AdminToProfileKoQ(dataItems[0]));
addedQuestions.unshift(dataItems[0]);
for
(
var
j = chooseGrid.dataSource.options.data.length; j--; )
{
if
(chooseGrid.dataSource.options.data[j].Id == dataItems[0].Id) {
chooseGrid.dataSource.options.data.splice(j, 1);
break
;
}
}
};
$(
"#ChooseKnockOutQuestionGrid"
).kendoGrid({
dataSource: {
schema : {
model: {
fields: {
Id: { type:
"number"
},
AdminLeadType: { type:
"number"
},
Answer1Text: { type:
"string"
},
Answer2Text: { type:
"string"
},
Enabled: { type:
"boolean"
},
QuestionText: { type:
"string"
},
QuestionTypeId : {type:
"number"
},
Price: { type:
"number"
}
}
}
},
data : @Html.Raw(ViewBag.Data),
pageSize: 5,
serverFiltering:
false
,
serverGrouping:
false
,
serverSorting:
false
,
serverPaging:
false
},
filterable:
true
,
sortable:
true
,
selectable:
"multiple, row"
,
columns: [{
field:
"QuestionText"
,
title:
"Question Text"
},
"Price"
],
dataBound: OnChooseDataBound,
change: OnChooseChange
});