Questions on UI for ASP.NET MVC Forum

10 answers

679 views

[Solved] Cascading problem after the 2nd list

I am trying to cascade 3 levels but is failing the 3rd drop down. Is this not possible? Everything works until I select the 500 scale then nothing else the 100 scale option does not do anything

<h4>Select Grid:</h4>

@(Html.Kendo().DropDownList()

.Name("MainGrid")

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

.OptionLabel("Select Grid Section...")

.DataTextField("Gridid")

.DataValueField("Gridid")

.DataSource(source =>

{

source.Read(read =>

{

read.Action("GetCascadeMainGrid", "GridPrint");

});

})

)

<h4 style="margin-top: 2em;">500 Scale:</h4>

@(Html.Kendo().DropDownList()

.Name("Grid500")

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

.OptionLabel("Select Map 500 Scale...")

.DataTextField("MapName")

.DataValueField("Pagenumber")

.DataSource(source =>

{

source.Read(read =>

{

read.Action("GetCascadeGrid500", "GridPrint")

.Data("filterGrid500");

})

.ServerFiltering(true);

})

.Enable(false)

.AutoBind(false)

.CascadeFrom("MainGrid")

)

<button class="k-button k-primary" id="get" style="margin-top: 0em; ">Add this Grid</button>

<script>

function filterGrid500() {

return {

MainGrid: $("#MainGrid").val()

};

}

</script>

<h4 style="margin-top: 2em;">100 Scale:</h4>

@(Html.Kendo().DropDownList()

.Name("Grid100")

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

.OptionLabel("Select Map 100 Scale...")

.DataTextField("MapName")

.DataValueField("Pagenumber")

.DataSource(source =>

{

source.Read(read =>

{

read.Action("GetCascadeGrid100", "GridPrint")

.Data("filterGrid100");

})

.ServerFiltering(true);

})

.Enable(false)

.AutoBind(false)

.CascadeFrom("Grid500")

)

<button class="k-button k-primary" id="get2" style="margin-top: 0em;">Add this Grid</button>

<script>

function filterGrid100() {

return {

Grid500: $("#Grid500").val()

};

}

</script>

</div>

<script>

DropDownList

answered on 17 Jan 2019

1 answer

906 views

[Solved] How do you change a string's edit box to textarea?

The default Kendo Grid's behavior is to display a text box for string editing. How do you change this to a textarea?

I am trying to use a EditorTemplate but cannot retrieve or pass the model's string values if I use Html.TextArea

Grid

answered on 17 Jan 2019

7 answers

1.9K+ views

[Solved] Reset grid to initial state

Hi, I am using the grid's persist state feature to retain a user's current page, sorts, filter, etc. I've been asked to add a "Reset Grid State" button to the grid to basically set the grid back to how it looked on initial load prior to any paging, sorting, filtering, etc. What's the best way to do this?

Grid

answered on 16 Jan 2019

3 answers

1.3K+ views

MultiSelect find value in Jquery

My question is How can I find value and select it with jquery?

I have a textarea and the user put a list to it.

I have to check one by one the item is exist in the multiselect and select it.

Thanks, Károly

MultiSelect

answered on 16 Jan 2019

2 answers

436 views

[Solved] Conditional .Editable based upon Role

Hello,

What is the best way to handle a grid that can be edited by one role and read only by another?

Thanks

John

Grid

answered on 15 Jan 2019

3 answers

293 views

Date filter not working

Hi, I´m using a date filter, but it shows all the data. I´ve done it like this:

On properties > Report parameters > Add > Type: DateTime Visible: True

On properties > Filters > on Expression I have =Trim(Fields.Date) on Operator = on Value = Fields.Date

On preview I choose a date, but all records appear.

Chart

answered on 14 Jan 2019

3 answers

227 views

Loading a PartialPage inside a TabStrip after Postback from ComboBox doesn't render parent

Hi, I'm using a Grid inside a TabStrip and a Combobox for filtering. First time it loads correctly, but after I do a postback from the ComboBox it loads only the PartialPage instead of reloading the Partial inside the TabStrip.

div class="btn-group">

@using (Ajax.BeginForm("Rules", new AjaxOptions { HttpMethod = "POST", UpdateTargetId = "Rules", InsertionMode = InsertionMode.Replace }))

{

@Html.AntiForgeryToken()

<label>Account No</label>

@(Html.Kendo().DropDownList()

.Name("selectedAccountNo")

.DataTextField("Value")

.DataValueField("Text")

.BindTo(Model.selectedAccNo)

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

)

<br />

<label> Application </label>

@(Html.Kendo().DropDownList()

.Name("selectedAppNo")

.DataTextField("Value")

.DataValueField("Text")

.BindTo(Model.selectedAppNo)

.HtmlAttributes(new { style = "width: 100%", @onchange = "this.form.submit();" })

)

}

</div>

01.[HttpPost]

02.[ValidateAntiForgeryToken]

03.public ActionResult Rules(string selectedAccountNo = "", string selectedAppNo = "")

04.{

05. var rules = from rule in _db.Rules

06. select rule;

07.

08. var ruletypes = from rTypes in _db.RuleTypes

09. select rTypes.RuleType1;

10.

11. var vm = new RuleListAndSearchVM(_db);

12. var rulesVm = new List<RuleVM>();

13.

14. ViewBag.Title = "Rules";

15.

16.

17. var ruleTypes = _db.RuleTypes.AsNoTracking().Select(n => new SelectListItem { Value = n.RuleTypeId.ToString(), Text = n.RuleType1 }).ToList();

18. ViewBag.RuleType = ruleTypes;

19. TempData.ContainsKey("RuleType");

20. vm.RuleType = ruleTypes;

21.

22. List<SelectListItem> appNumbers = _db.Rules.AsNoTracking().Select(n => new SelectListItem { Value = n.AppNo, Text = n.AppNo }).ToList();

23. List<SelectListItem> accNumbers = _db.Rules.AsNoTracking().Select(n => new SelectListItem { Value = n.AccNo, Text = n.AccNo }).ToList();

24. vm.selectedAppNo = appNumbers;

25. vm.selectedAccNo = accNumbers;

26.

27. if (!String.IsNullOrEmpty(selectedAccountNo))

28. {

29. rules = rules.Where(acc => acc.AccNo == selectedAccountNo);

30. }

31. if (!String.IsNullOrEmpty(selectedAppNo))

32. {

33. rules = rules.Where(acc => acc.AppNo == selectedAppNo);

34. }

35.

36.

37. foreach (var r in rules)

38. {

39. var newRule = new RuleVM() { AccNo = r.AccNo, AppNo = r.AppNo, RuleId = r.RuleId, RuleType = new RuleTypeVM() { RuleTypeId = r.RuleTypeId }, RuleValue = r.RuleValue, CreatedBy = new UserVM() { UserId = r.CreatedBy }, DateCreated = r.DateCreated };

40.

41. if (r.Status == true)

42. newRule.Status = "Active";

43. else

44. newRule.Status = "Deleted";

45.

46. newRule.RuleType.RuleType = _db.RuleTypes.Find(newRule.RuleType.RuleTypeId).RuleType1;

47. newRule.CreatedBy.Username = _db.Users.Find(newRule.CreatedBy.UserId).Username;

48. rulesVm.Add(newRule);

49.

50. }

51.

52. vm.Data = rulesVm;

53.

54. vm.SelectedAccNo = selectedAccountNo;

55. vm.SelectedAppNo = selectedAppNo;

56.

57. if (!string.IsNullOrEmpty(selectedAccountNo) || !string.IsNullOrEmpty(selectedAppNo))

58. {

59. View("RulesPartial", vm).ExecuteResult(this.ControllerContext);

60. return View("RulesPartial", vm);

61. }

62.

63. return new HttpStatusCodeResult(HttpStatusCode.BadRequest);

64.

65.}

TabStrip

answered on 14 Jan 2019

5 answers

574 views

Grid Filter Multi-Select Checkbox Sorting - Brute Force Solution

I've achieved sorting in Filter Multi-Select Checkboxes but I'm thinking I may be making it harder than it has to be.

The simpler code shown here provides multi-select checkboxes, but they're not sorted into order.

.Filterable(ftb => ftb.Multi(true).Search(true));

Adding a data source enables us to sort each checkbox list into proper order.

.Filterable(ftb => ftb.Multi(true).Search(true).DataSource(ds => ds.Read(r => r.Action("filterPOD", "Home").Data("{ field: 'PODNumber' }"))))

But this requires me to have a corresponding block of code in my controller for EACH column that I intend to filter with Multi-select CBs.

public ActionResult filterPOD(string field)

{

var w = new SQL_DB_Entities();

var result = w.Shipping_Table.Select(x => new filterModel

{

PODNumber = x.PODNumber

}).Distinct().OrderBy(p => p.PODNumber);

return Json(result, JsonRequestBehavior.AllowGet);

}

It's probably something simple I'm overlooking, but I'd like to create a block of "Generic" code in my controller to return the sorted lists needed for multi select checkboxes, rather than having to repeat this block of code for each fieldname / column that I filter. I'm already passing the field name as a string (named "field"). How can I replace the 3 instances of "PODNumber" in this block of code to use the value of the field variable instead so that I can have a single generic block of code? That would be a more elegant solution than the "brute force" one of repeating this code over and over. I'm new to MVC and jquery, so please be gentle with me. -Darron

Grid

answered on 11 Jan 2019

10 answers

5.3K+ views

[Solved] mvc grid custom command to call actionLink with parameter from grid

Hi,

I have an NVC4 kendo grid in which I want to place a button which, when pressed, will call an ActionLink with an ID taken from a column in the current row. In my case this will jump to a new page to display a map of the location by calling the MVC action method via the URL ~/Controller/ShowMap?Id=123 (if the Id was 123)

I have found columns.Command method and have written the following code

@(Html.Kendo().Grid(Model)

.Name("SchemeResults")

.Columns(columns =>

{

columns.Bound(p => p.Id).Hidden();

columns.Bound(p => p.SchemeName);

columns.Command(command => command.Custom( "Map") .Click("GotoMap"));

})

.Pageable()

)

This successfully calls the JavaScript function "GotoMap", but I can't find a method of getting the ID from the event.

Please could you advise me on the best way to implement this feature.

Grid

answered on 11 Jan 2019

3 answers

251 views

MVC SharedDataSource Between Pie Chart & Grid

I have a pie chart that is populated via a remote datasource that returns JSON. I now want to add a grid that will use the same data. When I implement the shared data source for the pie chart it calls the action to get the data but the pie chart no longer shows.

This Works:

@(Html.Kendo().Chart<PortalApp.Areas.TaskManagement.Features.Reporting.Index.Vendor> ()
.Name("chart1")
.Title(title => title
//.Text("Vendor - Total Assigned: 27564")
.Text("Vendor")
.Position(ChartTitlePosition.Top))
.Legend(legend => legend
.Visible(false)
)
.ChartArea(chart => chart
.Background("transparent")
.Height(300)
)
.SeriesColors(new string[] { "#9de219", "#90cc38", "#068c35", "#006634", "#004d38", "#033939" })
.DataSource(ds => ds.Read(read => read.Action("GetVendorGraph", "Reporting")))
//.DataSource("graphOneDS")
.Series(series =>
{
series.Pie(m => m.value, m => m.category)
.Padding(0)
.Labels(labels => labels
.Template("#= dataItem.category #: #= dataItem.value2 #")
.Background("transparent")
.Visible(true)
)
.StartAngle(210);
})
.Tooltip(tooltip => tooltip
.Visible(true)
.Template("#= dataItem.category #: #= dataItem.value #% (#= dataItem.value2 # Review Tasks Assigned)</br>Outstanding Requests: #= dataItem.value3 #</br>Outstanding Questions: #= dataItem.value4 #")
)
.Deferred(true)
)

This Doesn't

@(Html.Kendo().DataSource<PortalApp.Areas.TaskManagement.Features.Reporting.Index.Vendor>()
.Name("graphOneDS")
.Ajax(dataSource => dataSource
.Read(read => read.Action("GetVendorGraph", "Reporting"))
)
.Deferred(true)
)
@(Html.Kendo().Chart<PortalApp.Areas.TaskManagement.Features.Reporting.Index.Vendor> ()
.Name("chart1")
.Title(title => title
//.Text("Vendor - Total Assigned: 27564")
.Text("Vendor")
.Position(ChartTitlePosition.Top))
.Legend(legend => legend
.Visible(false)
)
.ChartArea(chart => chart
.Background("transparent")
.Height(300)
)
.SeriesColors(new string[] { "#9de219", "#90cc38", "#068c35", "#006634", "#004d38", "#033939" })
//.DataSource(ds => ds.Read(read => read.Action("GetVendorGraph", "Reporting")))
.DataSource("graphOneDS")
.Series(series =>
{
series.Pie(m => m.value, m => m.category)
.Padding(0)
.Labels(labels => labels
.Template("#= dataItem.category #: #= dataItem.value2 #")
.Background("transparent")
.Visible(true)
)
.StartAngle(210);
})
.Tooltip(tooltip => tooltip
.Visible(true)
.Template("#= dataItem.category #: #= dataItem.value #% (#= dataItem.value2 # Review Tasks Assigned)</br>Outstanding Requests: #= dataItem.value3 #</br>Outstanding Questions: #= dataItem.value4 #")
)
.Deferred(true)
)

Chart

answered on 11 Jan 2019