[CLOSED] Syntax to get grid panel row index to filter comboBox data inside grid panel

[alscg]

Hi,

Please refer the highlighted area in the image attached with this thread.
This code is working with hard coded row index.
I need the syntax to get grid panel row index while filtering of records for combo box inside grid panel.

Thanks

[Vladimir]

Component bind is performed on the client side therefore you cannot do it on the server side
I can suggest to use associations

Controller

public class OverviewController : Controller
    {
        public ActionResult Index()
        {
            return View(new List<object> { 
                new { Index= 1, ComboItems = new List<object>{ 
                    new {value = 1, text = "Item1 for index=1"},
                    new {value = 2, text = "Item2 for index=1"},
                    new {value = 3, text = "Item3 for index=1"}
                }},


                new { Index= 2, ComboItems = new List<object>{ 
                    new {value = 1, text = "Item1 for index=2"},
                    new {value = 2, text = "Item2 for index=2"},
                    new {value = 3, text = "Item3 for index=2"}
                }},


                new { Index= 3, ComboItems = new List<object>{ 
                    new {value = 1, text = "Item1 for index=3"},
                    new {value = 2, text = "Item2 for index=3"},
                    new {value = 3, text = "Item3 for index=3"}
                }}
            });
        }       
    }

View

@model System.Collections.IEnumerable
           
@using System.Collections.Generic


@{
    ViewBag.Title = "ComponentColumn Overview - Ext.NET MVC Examples";
    Layout = "~/Views/Shared/_BaseLayout.cshtml";
}


@section example
{        
    @(Html.X().Model()
        .Name("ComboItem")
        .Fields(
            new ModelField("text"),
            new ModelField("value", ModelFieldType.Int)
        )
     )


    @(Html.X().GridPanel()
        .Title("ComponentColumn Overview")
        .Width(320)
        .Height(180)
        .Store(Html.X().Store()
            .Model(Html.X().Model()
                .Fields(
                    new ModelField("Index", ModelFieldType.Int)                    
                )
                .Associations(a=>{
                    a.Add(new HasManyAssociation { Model = "ComboItem", Name = "comboItems", AssociationKey = "ComboItems" });
                })
            )
            .Data(Model)
        )
        .ColumnModel(
            Html.X().RowNumbererColumn(),
            
            Html.X().ComponentColumn()
                .Flex(1)
                .DataIndex("Index")
                .Editor(true)
                .Component(Html.X().ComboBox()
                    .Flex(1)
                    .DisplayField("text")
                    .ValueField("value")
                    .QueryMode(DataLoadMode.Local)
                    .TriggerAction(TriggerAction.All)
                    .Store(Html.X().Store()                        
                        .AutoLoad(false)
                        .ModelName("ComboItem")
                    )
                )
                .Listeners(l=>l.Bind.Handler = "cmp.store.add(record.comboItems().getRange());")
        )


    )
}

[alscg]

Hi,

I tried with the way you suggested.
There seems some problem with the below line of code: -

.Listeners(l=>l.Bind.Handler = "cmp.store.add(record.MasteryNames().getRange());" )

Also, I am not very clear what exactly is written or should be written inside the string which is assigned to the handler above.

- what is 'cmp.store.add'? do i need to write the same or something else in my context?
- 'record.MasteryNames().getRange()' give error as 'MasteryNames' is not an identified method. If I remove the brackets, it gives error as 'MasteryNames' is undefined.

Below is my code sample for reference: -
Let me know what correction is required here.

Model: -

CompetencyMasteryDTO

[DataContract]
    public class CompetencyMasteryDTO
    {
        [DataMember]
        public int Position_Grade_Id { get; set; } 

        [DataMember]
        public int Competency_Mastery_Id { get; set; } 

        [DataMember]
        public int Competency_Id { get; set; } 

        [DataMember]
        public int Mastery_Id { get; set; } 

        [DataMember]
        public string Competency_Name { get; set; } 

        [DataMember]
        public string Mastery_Name { get; set; } 

        [DataMember]
        public int Is_Active { get; set; } 

        [DataMember]
        public int Competency_Mastery_Assignment_Id { get; set; }                           

        [DataMember]
        public List<MasteryDTO> List_Mastery { get; set; }
        [DataMember]
        public Int32 List_CompetencyId { get; set; }
    }

MasteryDTO

[DataContract]
    public class MasteryDTO
    {
        [DataMember]
        public int Mastery_Id;

        [DataMember]
        public int Competency_Mastery_Id { get; set; }

        [DataMember]
        public int Competency_Id { get; set; }

        [DataMember]
        public string Mastery_Name;

        [DataMember]
        public string Mastery_Desc;

        [DataMember]
        public int Badge_Id;

        [DataMember]
        public int Is_Active;
    }

View: -

<%: Html.X().GridPanel()
            .Width(400)
            .Height(500)
            .ID("competenciesGridPanel")
            .Store(Html.X().Store()
            .ID("storeId")
                .Model(Html.X().Model()
                    .Fields(
                            new ModelField("Competency_Mastery_Id", ModelFieldType.Int),
                            new ModelField("Competency_Name", ModelFieldType.String),
                            new ModelField("Mastery_Id", ModelFieldType.Int),
                            new ModelField("Competency_Id", ModelFieldType.Int))
                    .Associations(a =>{a.Add(new HasManyAssociation { Model = "MasteryDTO", Name = "MasteryNames", AssociationKey = "List_Mastery" });
                    })
                )                    
                 .DataSource(Model))                 
            .ColumnModel(
                Html.X().Column().ID("cmptncyMasteryId").DataIndex("Competency_Mastery_Id").Hidden(true),
                Html.X().Column().DataIndex("Competency_Id"),
                Html.X().Column().DataIndex("Competency_Name"),                
                Html.X().ComponentColumn()
                .Flex(1)
                .DataIndex("Index")
                .Editor(true)
                .Component(Html.X().ComboBox()
                    .Flex(1)
                    .DisplayField("Mastery_Name")
                    .ValueField("Mastery_Id")
                    .QueryMode(DataLoadMode.Local)
                    .TriggerAction(TriggerAction.All)
                    .Store(Html.X().Store()
                    .AutoLoad(false)
                    .ModelName("MasteryDTO"))                    
                )
                .Listeners(l=>l.Bind.Handler = "cmp.store.add(record.MasteryNames.getRange());")                 
                        )
         
        %>

[geoffrey.mcgill]

Please edit your last post and wrap all code in [CODE] tags.

[Vladimir]

Hi,

what is 'cmp.store.add'? do i need to write the same or something else in my context?

'cmp' is Combobox, it is argument is passed to Bind event handler, you don't need to change it

'record.MasteryNames().getRange()' give error as 'MasteryNames' is not an identified method. If I remove the brackets, it gives error as 'MasteryNames' is undefined.

You don't need to remove brackets. The problem that you have to use 'Data' in the store instead DataSource (like in my example) because DataSource doesn't serialize extra info (only defined fields)

[alscg]

I still get the same error after doing change as per your input.
TypeError: record.MasteryNames is not a function

With reference to the image attached, [Name="MasteryName"] given in 'Associations' is the one which should be given inside string value for listener right

[alscg]

I was wondering if there is a way to get gridpanel row index as I asked for in my first post in this thread.

Because that is working for me. I hard coded different row indexes and it is filtering the records as per the index.

[Vladimir]

Please provide controller and view which we can test without any changes

[Vladimir]

I tested with your business object and all works fine for me

Controller

public ActionResult Index()
        {
            return View(new List<CompetencyMasteryDTO>() { 
                new CompetencyMasteryDTO{ Competency_Mastery_Id = 1, Competency_Name = "Name 1",
                    List_Mastery = new List<MasteryDTO>{
                        new MasteryDTO{Mastery_Id = 1, Mastery_Name = "Item 1"}
                    }
                }
            });
        }

View

@model System.Collections.IEnumerable
           
@using System.Collections.Generic


@{
    ViewBag.Title = "ComponentColumn Overview - Ext.NET MVC Examples";
    Layout = "~/Views/Shared/_BaseLayout.cshtml";
}


@section headtag
{
    
}


@section example
{    
    @(Html.X().Model()
        .Name("MasteryDTO")
        .Fields(
            new ModelField("Mastery_Name"),
            new ModelField("Mastery_Id", ModelFieldType.Int)
        )
     )


    @(Html.X().GridPanel()
            .Width(400)
            .Height(500)
            .ID("competenciesGridPanel")
            .Store(Html.X().Store()
            .ID("storeId")
                .Model(Html.X().Model()
                    .Fields(
                            new ModelField("Competency_Mastery_Id", ModelFieldType.Int),
                            new ModelField("Competency_Name", ModelFieldType.String),
                            new ModelField("Mastery_Id", ModelFieldType.Int),
                            new ModelField("Competency_Id", ModelFieldType.Int))
                    .Associations(a =>{a.Add(new HasManyAssociation { Model = "MasteryDTO", Name = "MasteryNames", AssociationKey = "List_Mastery" });
                    })
                )                    
                 .Data(Model))                 
            .ColumnModel(
                Html.X().Column().ID("cmptncyMasteryId").DataIndex("Competency_Mastery_Id").Hidden(true),
                Html.X().Column().DataIndex("Competency_Id"),
                Html.X().Column().DataIndex("Competency_Name"),   
                             
                Html.X().ComponentColumn()
                .Flex(1)
                .DataIndex("Index")
                .Editor(true)
                .Component(Html.X().ComboBox()
                    .Flex(1)
                    .DisplayField("Mastery_Name")
                    .ValueField("Mastery_Id")
                    .QueryMode(DataLoadMode.Local)
                    .TriggerAction(TriggerAction.All)
                    .Store(Html.X().Store()
                    .AutoLoad(false)
                    .ModelName("MasteryDTO"))
                )
                .Listeners(l=>l.Bind.Handler = "cmp.store.add(record.MasteryNames().getRange());")                 
                        )
    )
}

[Vladimir]

Also please clarify, do you use Razor View or WebForm view? Just I confused with '<%:' syntax