Telerik Forums
UI for ASP.NET MVC Forum
2 answers
229 views

Entity Model for Country (All models are in a separate project)

 

[ScaffoldColumn(false)]
public int CountryId { get; set; }
public string ShortName { get; set; }
public string LongName { get; set; }
public string IsoCode2 { get; set; }
public string IsoCode3 { get; set; }
public string IsoCodeHash { get; set; }
public string CallingCodeOne { get; set; }
public string CallingCodeTwo { get; set; }
public string CurrencyName { get; set; }
public string CurrencySymbol { get; set; }
public List<State> States { get; set; }
 

Entity Model for State 

 

[ScaffoldColumn(false)]
public int StateId { get; set; }
public string Name { get; set; }
public bool IsCapital { get; set; }
 
[ScaffoldColumn(false)]
public int CountryId { get; set; }
public Country Country { get; set; }

 

States Controller deriving from ODataController (It's a separate project)

 

private DataAccess.Helper.DatabaseContext _dbContext;
 
public StatesController()
{
    DataAccess.MyApp.StartUp.Initialize();
 
    const string dataSource = "My-PC\\SQLEXPRESS";
    const string initialCatalog = "BS";
 
    var connString = SqlConnection.CreateConnectionString("", dataSource, initialCatalog);
 
    _dbContext = new DatabaseContext(connString);
}
 
// GET odata/Countries
[EnableQuery]
public System.Linq.IQueryable<State> GetStates()
{
    return _dbContext.States;
}
 
public IHttpActionResult Put([FromODataUri] int key, State entity)
{
    if (!ModelState.IsValid)
        return BadRequest(ModelState);
     
 
    if (key != entity.StateId)
        return BadRequest();
 
    _dbContext.States.Attach(entity);
    _dbContext.Entry(entity).State = EntityState.Modified;
 
    try
    {
        _dbContext.SaveChanges();
    }
    catch (Exception)
    {
        if (!EntityExists(key))
        {
            return NotFound();
        }
        else
        {
            throw;
        }
    }
 
    return Updated(entity);
}
 
private bool EntityExists(int key)
{
    return _dbContext.States.Count(e => e.StateId == key) > 0;
}
 
public IHttpActionResult Post(State entity)
{
    if (!ModelState.IsValid)
        return BadRequest(ModelState);
 
    _dbContext.States.Add(entity);
    _dbContext.SaveChanges();
    return Created(entity);
}

 

View (It's in a separate project)

@(Html.Kendo().Grid<SC.BS.EntityModel.State>()
      .Name("EntityStates")
      .Columns(col =>
      {
          col.Bound(e => e.StateId);
          col.Bound(e => e.Name).Title("State").Width("200");
          col.Bound(e => e.IsCapital).Title("Capital").Filterable(false).Width(100).ClientTemplate("#= IsCapital ? 'Yes':'No' #").HtmlAttributes(new {style="align=center"});
          col.Bound(e => e.CountryId);
          col.Bound(e => e.Country).Title("Country").ClientTemplate("#: Country.ShortName #").EditorTemplateName("CountriesLookUp").Filterable(false);
          col.Command(cmd =>
          {
              cmd.Edit();
              cmd.Destroy();
          }).Width(170);
      })
      .Scrollable()
      .ToolBar(tb => tb.Create().Text("New State"))
      .DataSource(ds => ds
          .Custom()
          .Schema(sch =>
          {
              sch.Model(m =>
              {
                  m.Id("StateId");
                  m.Field(e => e.StateId).Editable(false);
                  m.Field(e => e.CountryId).DefaultValue(1);
                  //m.Field(e => e.Country).DefaultValue(new SC.BS.EntityModel.Country());
                  //m.Field("CreatedOn", typeof(DateTime));
              });
          })
          .Type("odata-v4")
          .Transport(tr =>
          {
              tr.Read(r => r.Url("http://localhost:28016/oData/States").Data("function() {return {'$expand' : 'Country'} }"));
              tr.Create(c => c.Url("http://localhost:28016/oData/States"));
              tr.Update(new
              {
                  url = new Kendo.Mvc.ClientHandlerDescriptor
                  {
                      HandlerName = @"function(data) {
                                            return 'http://localhost:28016/oData/States(' + data.StateId + ')';
                                       }"
                  }
              });
              tr.Destroy(new
              {
                  url = new Kendo.Mvc.ClientHandlerDescriptor
                  {
                      HandlerName = @"function(data) {
                                            return 'http://localhost:28016/oData/States(' + data.StateId + ')';
                                       }"
                  }
              });
          })
          .PageSize(20)
          .ServerPaging(true)
          .ServerSorting(true)
          .ServerFiltering(true)
      )
      .Pageable()
      .Sortable()
      .Filterable(ftb => ftb.Mode(GridFilterMode.Row))
      .Editable(e => e.Mode(GridEditMode.InLine)))

 

CountriesLookUp EditorTemplate

@model SC.BS.EntityModel.Country
 
@(Html.Kendo().DropDownList().Name("Countries").DataSource(ds => ds
    .Custom()
    .Schema(sch =>
    {
        sch.Model(m =>
        {
            m.Id("CountryId");
        });
    })
    .Type("odata-v4")
    .Transport(tr =>
    {
        tr.Read(r => r.Url("http://localhost:28016/oData/Countries"));
    })
 
)
.DataValueField("Country")
.DataTextField("ShortName"))

 

 

Displaying data works fine, but I'am having trouble updating the State.

  1. When I click edit, DropDown preselect top/first country instead of selecting the country that state belongs to.
  2. After changing values, update doesn't work, my ​Web​AP complaints in Put method that the ModelState is invalid and errors out:
  3. message=entity : The property 'Countries' does not exist on type 'SC.BS.EntityModel.State'. Make sure to only use property names that are defined by the type.
  4. This is the JSON that is sent on update command.
    {"StateId":"1","Name":"Delhi","IsCapital":true,"CountryId":"2","Country":{"CountryId":2,"ShortName":"United States","LongName":"United States of America","IsoCode2":"US","IsoCode3":"USA","IsoCodeHash":"840","CallingCodeOne":"1","CallingCodeTwo":"","CurrencyName":"USD","CurrencySymbol":"$"},"Countries":"United States"}
Boyan Dimitrov
Telerik team
 answered on 18 Aug 2015
4 answers
617 views

I want to persist what child detail grid is open on return to the page. I tried using the localstorage example

var options = kendo.stringify(grid.getOptions())
     localStorage.setItem("kendo-grid-options", options);

but this does not seem to keep the open expanded row details.

Is there an event that fires when oi expand a row, then maybe I could use that to record the row number and expand using js when page is loaded, thanks

Dimiter Madjarov
Telerik team
 answered on 17 Aug 2015
2 answers
107 views

I have very large data sets I want to display in a grid, and I'd like to use the auto filtering on the column header.  But with my large data sets, users will typically want to specify a few filters before getting their data, otherwise the retrieval of the records from the database takes a very long time.

It seems that by default, each filter in the grid is applied immediately.  I'd like to allow the user to select multiple filters, and then push a button to trigger the refresh.

Is there a good way to skip the automatic refresh that comes with setting a filter in the grid header?

 

Brian
Top achievements
Rank 1
 answered on 14 Aug 2015
2 answers
105 views

Hi

I have installed a trial version to have a play around with the Scheduler control.

I have put together a basic ​page, but have a problem when attempting to edit an event.  After double clicking on the event, the event dialog opens. Then, whenever I hit Cancel or the close (X) button, I get the following error:

 Unhandled exception at line 10, column 30735 in kendo.all.min.js

Javascript runtime error: unable to get property 'uid' of undefined or null reference.

The Save button works fine. 

 I am using Kendo.Mvc.dll 2015.2.805.545, and Visual Studio 2013.

 Any ideas on why this is failing?

Cheers, Jarrod

Jarrod
Top achievements
Rank 1
 answered on 14 Aug 2015
8 answers
189 views
Hello,

like the title reveals, I need to display data, that is updated irregularly, but at least once every few seconds.

Is it possible to bind the Chart to a SignalR hub, like it is for the grid? (http://demos.telerik.com/aspnet-mvc/grid/signalr)
Which other approaches promise good and efficient results? Polling of WebAPI? A separat SignalR function and adding data to chart on client side?

Thank you in advance.
Robert
Top achievements
Rank 1
 answered on 14 Aug 2015
1 answer
91 views

Hi

 Please may we have a similar "Navigator" feature as in the Stock chart, for the Scatter chart.

 At least where the X axis is time.

 This would be of great benefit.

 Alternatively how may we customise using two sliders a similar feature.

 Kind Regards

David

Iliana Dyankova
Telerik team
 answered on 14 Aug 2015
1 answer
464 views

Hello,

 I have been trying to figure out how to set value of my multiSelect after server filtering and adding some conditions so that some elements cannot be deleted.  The multiselect works fine *as long* as the user uses the mouse to select elements to add. Once the user decides to filter by using the keyboard the multiselect does not render the added item correctly even though the values i set to them are correct.Here is my code:

Edit.cshtml:

   @Html.Kendo().MultiSelect().Name("msGroupMembers").DataTextField("FullName").DataValueField("Id").Value(new[] { new { FullName = Model.SelectedTO.Select(x => x.Text), Id = Model.SelectedTO.Select(x => x.Value) } }).Filter(FilterType.Contains).Events(e => e.Change("onChangeEdit").Close("onCloseEdit").Select("onSelect")).DataSource(source => source
                        .Custom()
                        .Transport(transport => transport
                        .Read(read =>
                        {
                            read.Action("GetGroupMembers", "ScheduleRequest")
                            .Data("testOfficerFiltering");
                        }))
                        .ServerFiltering(true)).HtmlAttributes(new { required = "required" })

 Controller:

  public ActionResult SetGroupMembers(List<int> items, string teamLead)
        {
            Business.Entities.RTSSUser user = userService.GetRTSSUser(User.Identity.Name);

            // check to see if we have a lead.
            int lead;
            bool result = int.TryParse(teamLead, out lead);
            if (!result)
            {
                lead = -1;
            }

            try
            {
                int findLead = items.FindIndex(s => s == lead);
                int findOwner = items.FindIndex(s => s == user.Person.Id);

                //if our owner is also the lead, place in first spot
                if (findLead == findOwner && findOwner == -1)
                {
                    items.Insert(0, user.Person.Id);
                }

                else if (findLead == -1)
                {
                    items.Insert(1, lead);
                }

                else if (findOwner == -1)
                {
                    items.Insert(0, user.Person.Id);
                }

            }
            catch (Exception e)
            {
                // handle an empty list passed.
                List<int> msUsers = new List<int>();
                msUsers.Insert(0, user.Person.Id);
                return Json(msUsers, JsonRequestBehavior.AllowGet);
            }
           
            
            return Json(items, JsonRequestBehavior.AllowGet);
        }​

Javascript:
function onChangeEdit(e) {
   
    var lead = $("#cbTeamLeadName").data("kendoComboBox").value();

    var msValue = this.value();
    var arrayLength = msValue.length;
    var newArrayValue = new Array();

    //store values into array
    for (var i = 0; i < arrayLength; i++) {
        newArrayValue.push(msValue[i]);
        console.log(msValue[i]);
    }    

    //get owner
    $.ajax({
        type: 'GET',
        url: SetGroupMembersUrl,
        data: {
            "items": newArrayValue,
            "teamLead": lead
        },
        contentType: 'application/json',
        async: true,
        cache: false,
        dataType: 'json',
        traditional: true,
        success: function (data) {          
            populateMs(data);
         
        },        
        error: function () {
            console.log("Could not get AgencyName");
        }
    });
    
}

 
function populateMs(e) {
    var multiSelect = $("#msGroupMembers").data("kendoMultiSelect");
    multiSelect.dataSource.filter({});
    multiSelect.value([])
    multiSelect.refresh();
    multiSelect.value(e);
    alert("Dat: " + e);
}

I have found this similar thread: http://stackoverflow.com/questions/22010796/kendo-multiselect-value-setting-bug and was wondering if it is a bug or if i am doing something wrong. Thanks in advance!

Daniel
Telerik team
 answered on 13 Aug 2015
3 answers
1.2K+ views
Hi,

I'm trying to bind a Kendo.Dropdownlist to an enum in MVC but cant seem to get it working. It binds OK to get the values but when I change the value its not reflected in the ViewModel. I have attached two screenshots of my editor template (one working and one not). The one that works use the built in EnumDropdownListFor but this doesn't have the styling like the Kendo UI. Any ideas how i can get the Kendo dropdown to work?

@model CapType

@{
    var enumItems = EnumHelper.GetSelectList(typeof(CapType));

    var options = new SelectList(enumItems, "Value", "Text", Model);
}

@(Html.Kendo().DropDownListFor(m => Model)
              .Name("eCapType")
      .BindTo(options))
Jason
Top achievements
Rank 1
 answered on 13 Aug 2015
1 answer
212 views
Hi,
i've created a sample Application for the Grid with ASP.NET SignalR having real-time updates 

http://webapps-in-action.com/post/Telerik-Kendo-UI-Grid-Updating-Stock-Data-with-SignalR-in-ASPNET-MVC4

Greetings Otto
Nathan
Top achievements
Rank 1
 answered on 13 Aug 2015
2 answers
281 views

I have been looking at the datepicker mask example at

http://docs.telerik.com/kendo-ui/aspnet-mvc/helpers/datepicker/how-to/masked-date-picker-grid

Is this solution valid for MVC wrappers also?

I have included the code but still no mask.

Thanks

 

 

 
Alan Mosley
Top achievements
Rank 1
 answered on 13 Aug 2015
Narrow your results
Selected tags
Tags
Grid
General Discussions
Scheduler
DropDownList
Chart
Editor
TreeView
DatePicker
Upload
ComboBox
MultiSelect
ListView
Window
TabStrip
Menu
Installer and VS Extensions
Spreadsheet
AutoComplete
TreeList
Gantt
PanelBar
NumericTextBox
Filter
ToolTip
Map
Diagram
Button
PivotGrid
Form
ListBox
Splitter
Application
FileManager
Sortable
Calendar
View
MaskedTextBox
PDFViewer
TextBox
Toolbar
MultiColumnComboBox
Dialog
DropDownTree
Checkbox
Slider
Switch
Notification
ListView (Mobile)
Pager
Accessibility
ColorPicker
DateRangePicker
Wizard
Security
Styling
Chat
MediaPlayer
TileLayout
DateInput
Drawer
SplitView
Barcode
ButtonGroup (Mobile)
Drawer (Mobile)
ImageEditor
RadioGroup
Sparkline
Stepper
TabStrip (Mobile)
GridLayout
Template
Badge
LinearGauge
ModalView
ResponsivePanel
TextArea
Breadcrumb
ExpansionPanel
Licensing
Rating
ScrollView
ButtonGroup
CheckBoxGroup
NavBar
ProgressBar
QRCode
RadioButton
Scroller
Timeline
TreeMap
TaskBoard
OrgChart
Captcha
ActionSheet
Signature
DateTimePicker
AppBar
BottomNavigation
Card
FloatingActionButton
Localization
MultiViewCalendar
PopOver (Mobile)
Ripple
ScrollView (Mobile)
Switch (Mobile)
PivotGridV2
FlatColorPicker
ColorPalette
DropDownButton
AIPrompt
PropertyGrid
ActionSheet (Mobile)
BulletGraph
Button (Mobile)
Collapsible
Loader
CircularGauge
SkeletonContainer
Popover
HeatMap
Avatar
ColorGradient
CircularProgressBar
SplitButton
StackLayout
TimeDurationPicker
Chip
ChipList
DockManager
ToggleButton
Sankey
OTPInput
ChartWizard
SpeechToTextButton
InlineAIPrompt
TimePicker
StockChart
RadialGauge
ContextMenu
ArcGauge
AICodingAssistant
+? more
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?