need help with where and contains 616 razor - Razor

Go to solution

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

Phillip Turner 98 posts 412 karma points

Apr 18, 2014 @ 20:03

Need help with Where and Contains 6.1.6 Razor

Razor

Good afternoon Umbracians.

I am trying to get a list of items from my tree where a dropdown field = a certain value.

I have tried so many different ways and failed. Any advice will be grateful.

Here is my code:

@inherits Umbraco.Web.Mvc.UmbracoTemplatePage
@using System.Xml.XPath
@using umbraco.MacroEngines
@{
    int i = 0;
    XPathNodeIterator iterator = umbraco.library.GetPreValues(2309);
    iterator.MoveNext();
    XPathNodeIterator preValues = iterator.Current.SelectChildren("preValue", "");
    var centers = CurrentPage.AncestorOrSelf(2).Children;
    List<string> groups = new List<string>();

    while (preValues.MoveNext())
    {
        groups.Add(preValues.Current.Value);
    }
}
<div id="tab-box-partner" style="background-color: White;">
    @foreach (string group in groups)
    {
        <div class="service-center-block @(i > 0 ? " hidden" : "")">
        <h2>@group</h2>
        <p>
        @foreach (var center in centers.Where(string.Format("serviceCenterType == {0}", group)))
        {
        @(center.serviceCenterName == "" ? center.Name : center.serviceCenterName)
        @center.addressBlock
        }  
        </p>      
    </div>
    i++;
}
</div>

Copy Link

Jeavon Leopold 3072 posts 13628 karma points MVP 10x admin c-trib

Apr 18, 2014 @ 20:54

0

Hi Philip,

It looks like this is a MVC Partial View, could you confirm?

Jeavon

Edit: I see you are using Umbraco v6.1.6

Copy Link
Jeavon Leopold 3072 posts 13628 karma points MVP 10x admin c-trib

Apr 18, 2014 @ 21:05

0

Also is your dropdown with property alias "serviceCenterType" a "Dropdown list" or a "Dropdown list, publishing keys"?

Copy Link
Phillip Turner 98 posts 412 karma points

Apr 18, 2014 @ 21:12

0

Yes, this is a MVC partial and the DataType is DropDownList.

Copy Link
Jeavon Leopold 3072 posts 13628 karma points MVP 10x admin c-trib

Apr 18, 2014 @ 21:16

0

Ok cool, and you want to find all nodes that are the children of the first level 2 node up the tree from the current node that have a certain value selected from that dropdown, e.g. "mything" and loop through them, right?

Copy Link
Phillip Turner 98 posts 412 karma points

Apr 18, 2014 @ 22:03

0

Home > Centers > Service Center Address

Above is the how the tree is.

I want to get all the nodes under Centers that have a serviceCenterType of XYZ.

Copy Link

Jeavon Leopold 3072 posts 13628 karma points MVP 10x admin c-trib

Apr 18, 2014 @ 22:12

Ok, unless I'm missing something, I think this should do it?

@inherits UmbracoTemplatePage
@{
    var centers = CurrentPage.AncestorOrSelf(2).Children;
    var valueToFind = "XYZ";

    var xzy = centers.Where("serviceCenterType == @0", valueToFind);

    foreach (var node in xzy)
    {
        <p>@node.Name</p>
    }    
}

Copy Link

Jeavon Leopold 3072 posts 13628 karma points MVP 10x admin c-trib

Apr 18, 2014 @ 22:14
100
To ignore case, you can change it to:
```
var xzy = centers.Where("serviceCenterType.ToLower() == @0", valueToFind.ToLower());
```
Copy Link

Phillip Turner 98 posts 412 karma points

Apr 18, 2014 @ 23:12

Jeavon to the rescue.

Worked great.

@foreach (string group in groups)
{
    <div class="service-center-block @(i > 0 ? " hidden" : "")">
        <h2>@group</h2>
        @foreach (var center in centers.Where("serviceCenterType == @0", group))
        {
            <p>
            <CenterName>@(center.serviceCenterName == "" ? center.Name : center.serviceCenterName)</CenterName><br />
            <CenterPhone>@center.addressBlock</CenterPhone>
            </p>
        }       
    </div>
    i++;
}

Copy Link

Jeavon Leopold 3072 posts 13628 karma points MVP 10x admin c-trib

Apr 18, 2014 @ 23:18

0

Great! One additional bit of advice, when using MVC, you should never have @using umbraco.MacroEngines that is from the legacy "Razor Macros" and has no use within MVC templating.

Copy Link
is working on a reply...

Please Sign in or register to post replies