Questions on UI for ASP.NET MVC Forum

1 answer

2.8K+ views

Filter with multiple default values

Hi,

I have a grid that contains this column (simplified for clarity):

columns.Bound(c => c.Status)

.Filterable

(

f => f.Extra(false).Multi(true).CheckAll(true).BindTo

(new[]

{

new { Status = "New" },

new { Status = "Started" },

new { Status = "Completed" }

})

);

I want both "New" and "Started" to be checked by default when the page is first displayed.

In the DataSource, I have this code:

.DataSource

(

.Filter

(

f => f

.Add(x => x.Status).IsEqualTo("New")

)

However, I cannot figure out how to add a second value, "Started", so that both are checked by default. How can I do this?

Thanks.

Grid

answered on 14 Nov 2017

3 answers

402 views

Geolocation

Has anyone had any luck with finding documentation on geolocation when using the bing layer on the kendo map UI ? I can't seem to find any documentation. Basically I am wanting to take advantage of the built in location services now in html 5 using mvc as my framework.

Map

answered on 14 Nov 2017

1 answer

176 views

Localization with some changes

Hi,

I'm using

@{ var culture = System.Globalization.CultureInfo.CurrentCulture.ToString(); }

<script src="@Url.Content("~/Scripts/cultures/kendo.culture." + culture + ".min.js")"></script>

<script> kendo.culture("@culture") </script>

and the most of the clients are using nl-NL as their culture and this works like I would expect but:

The official locale tells us the decimal separator is "," and thousand separator "." but everybody wants to use decimal separator "." and thousand separator ",".

Is it possible to change the kendo.culture.nl-NL.min.js file (or do I need to change kendo.culture.nl.min.js) to make this change?

Thanks,

Maurice Lucas

General Discussions

answered on 13 Nov 2017

1 answer

143 views

Copy modified row to datatable

Hi,

I have a spreadsheet in which I am populating the values using a dataset and datatable.

Once the user modifies the values in the spreadsheet, i want to pick that row and pass it to a datatable so that I can perform my update operation.

transport: {

/* the other CRUD settings are ommitted for brevity */

update:

Can you let me know how to pass the modified row to dataset or datatable using the transport method?

Spreadsheet

answered on 13 Nov 2017

1 answer

151 views

DateTime displayed incorrectly when loaded in spreadsheet

Hi

I am loading a spreadsheet with the help of a dataset result. I have a stored procedure that output's the result to a dataset and this dataset is being loaded to a datatable and rendered on the speadsheet using datasource. Below is my code

public ActionResult Products_Load([DataSourceRequest]DataSourceRequest request)

{

DataTable dt = new DataTable();

dt.Clear();

DataSet dsGetData = HandlerUtilities.HandlerFunctions.GetDynamicSheetData(1, 4);

if (dsGetData != null)

{

dt = dsGetData.Tables[0];

}

dt.Columns.Remove("atUserid");

dt.Columns.Remove("atTimestamp");

dt.AcceptChanges();

DataSourceResult result = dt.ToDataSourceResult(request);

JsonResult oJsonResult = Json(result, JsonRequestBehavior.AllowGet);

return oJsonResult;

}

When the data is rendered on the spreadsheet, the datetime values are getting converted into /Date(xxxxxx)/ instead of original values. I have attached the screenshot of my output for reference. My dataset is dynamic and everytime it will get changed and due to this I am not using a view model to bind the data. Hence, I cant provide the fieldname and its format in the client side as I dont know what the fieldnames will be. Is there any workaround fr this?

Spreadsheet

answered on 13 Nov 2017

3 answers

520 views

Return metadata with Grid data

I'm building a Grid that lists a collection of data that comes from multiple sources. One of those sources is a web service so it's possible that the web service call might fail. If it does, I still want to display the data from the other sources, but I want to display a warning on the page that the web service data is not included in the results. I have a ViewModel containing this property:

public class MyVM

{

public bool ServiceUnavailable { get; set; }

public List<RowVM> GridData { get; set; }

}

So I could show the warning when the Grid first loads. However, I'm not actually going to populate GridData during the initial page load. I want the Grid to make an AJAX call to load the first page (and for any other paging.) So after each Read action completes, I need to check if ServiceUnavailable and display the warning if it is true. The problem is, the Read action only returns a List<RowVM>.ToDataSourceResult(). How can I return additional data that is separate from the Grid row data? Is there a way to override the client-side Read function to make my own AJAX call and then on success update the datasource with the returned data myself?

Grid

answered on 13 Nov 2017

3 answers

566 views

When events are added Kendo Autocomplete is not working

Below is my autocomplete code. If I uncomment the Events section above the span class 'k-widget k-autocomplete k-header k-state-default' is removed, and the Kendo autocomplete is stoped and it is like a simple text box. Autocomplete functionality will be no more and no events are fired. Please let me know how should I fix the issue, and what may be reason for the same.

<style>

.imgslt .k-autocomplete { width: 25% !important; } </style>

<div class="form-group imgslt">

<label>Select Image:</label>

<div class="demo-section k-content">

@(Html.Kendo().AutoComplete()

.Name("ImageNameList")

.DataTextField("imageName")

.Filter("contains")

.MinLength(2)

.HtmlAttributes(new { style = "width:100%" })

//.Events(e => e

// .Select("autocomplete_select")

// .Change("autocomplete_change")

// )

.DataSource(source =>

{

source.Read(read =>

{

read.Action("GetListImages", "Assessment");

//.Data("onAdditionalData");

})

.ServerFiltering(false);

})

)

</div>

<script>

function autocomplete_select() {

//Handle the select event.

alert('select');

}

function autocomplete_change() {

//Handle the change event.

alert('change');

}

</script>

AutoComplete

answered on 13 Nov 2017

7 answers

1.5K+ views

How do I perform Server Side grouping and Aggregating

We have a heavy traffic data in DB, we don't want to dump huge data on to the client side and do grouping and aggregating.

So I started doing it on server side pagination, grouping and stuck with one column grouping. Need help with support multiple column grouping and then also able to aggregate data on server side.

Here is my grid Read Method

[AcceptVerbs(HttpVerbs.Post)]

public ActionResult Read_Traffic([DataSourceRequest] DataSourceRequest request)

{

var results = _auditService.All(OperatingUser.CompanyId, request, out int totalRecords);

if (request.Groups != null && request.Groups.Any())

{

//HaBo: Currently supporting only single grouping.

//need to work on to support multiple groupings.

return Json(new DataSourceResult

{

Data = CustomGroupBy(results, request.Groups[0].Member),

Total = totalRecords

});

}

//List<object> returnData = results.Cast<object>().ToList();

//foreach (var groupDescriptor in request.Groups)

//{

// returnData = (List<object>) CustomGroupBy(results, groupDescriptor.Member);

//}

return Json(new DataSourceResult

{

Data = results,

Total = totalRecords // Total number of records

});

}

Here is my Grouping Method

private static IEnumerable<object> CustomGroupBy(List<Audit> results, string groupKey)

{

switch (groupKey)

{

case "SessionId":

return results.GroupBy(x => x.SessionId).Select(g =>

new { Aggregates = new { }, Key = g.Key, HasSubgroups = false, Member = "SessionId", Subgroups = new object[] { }, Items = g });

case "AuditId":

return results.GroupBy(x => x.AuditId).Select(g =>

new { Aggregates = new { }, Key = g.Key, HasSubgroups = false, Member = "AuditId", Subgroups = new object[] { }, Items = g });

case "UserName":

return results.GroupBy(x => x.UserName).Select(g =>

new { Aggregates = new { }, Key = g.Key, HasSubgroups = false, Member = "UserName", Subgroups = new object[] { }, Items = g });

case "IpAddress":

return results.GroupBy(x => x.IpAddress).Select(g =>

new { Aggregates = new { }, Key = g.Key, HasSubgroups = false, Member = "IpAddress", Subgroups = new object[] { }, Items = g });

case "UrlReferrer":

return results.GroupBy(x => x.UrlReferrer).Select(g =>

new { Aggregates = new { }, Key = g.Key, HasSubgroups = false, Member = "UrlReferrer", Subgroups = new object[] { }, Items = g });

case "TimeAccessed":

return results.GroupBy(x => x.TimeAccessed).Select(g =>

new { Aggregates = new { }, Key = g.Key, HasSubgroups = false, Member = "TimeAccessed", Subgroups = new object[] { }, Items = g });

case "CountryName":

return results.GroupBy(x => x.CountryName).Select(g =>

new { Aggregates = new { }, Key = g.Key, HasSubgroups = false, Member = "CountryName", Subgroups = new object[] { }, Items = g });

case "CountryCode":

return results.GroupBy(x => x.CountryCode).Select(g =>

new { Aggregates = new { }, Key = g.Key, HasSubgroups = false, Member = "CountryCode", Subgroups = new object[] { }, Items = g });

}

return null;

}

As you can notice currently I am only able to group with the first group member, how can I support multiple column grouping?

Grid

answered on 10 Nov 2017

1 answer

578 views

Adding a chart dynamically

I'm creating a dashboard. The backend database stores the type of telerik chart control should go into which box. Very simply is it even possible based on the data response to then add that telerik chart control to the corresponding div? Sample code below.

Anytime I attempt this there are javascript errors due to the HTML and javascript emitted from the toHtmlString() method.
However I see no other way to perform this based on the javascript setup.

At this point it's 100% static to determine if this is even feasible.

switch(controlType) {
case "grid":
break;
case "bar":
break;
case "pie":
$('#widgetcontrol' + widgetId).html('@(Html.Kendo().Chart()
.Name("pieChart")
.Legend(legend => legend
.Position(ChartLegendPosition.Top)
)
.ChartArea(chartArea => chartArea
.Background("transparent")
.Height(250)
)
.Series(series =>
{
series.Pie(new dynamic[]
{
new {category = "Test", value = 957, color = "#9de219"},
new {category = "Test 2", value = 124, color = "#90cc38"},
new {category = "Test 3", value = 567, color = "#068c35"},
new {category = "Test 4", value = 678, color = "#006634"},
})
.Labels(labels => labels
.Template("#= category #: \n #= value# (#= kendo.format('{0:P}', percentage)#)")
.Background("transparent")
.Visible(false)
)
.StartAngle(150);
})
.Tooltip(tooltip => tooltip
.Visible(true)
.Template("#= category #: \n #= value# (#= kendo.format('{0:P}', percentage)#)")
).ToHtmlString())');
break;
case "counter":
break;

Chart

answered on 10 Nov 2017

1 answer

654 views

Kendo grid convert automaticlly strings with decimals to int

I have this property :

public string Commax_dosismaximam2 = "0,03"

And when it renders on the grid it become to 3.

I know is something about the culture because if I change it to "0.03" works fine, but the thing is I made it string to avoid this, I don´t understand why kendo have to convert a string to a int.

Thank you

Grid

answered on 10 Nov 2017