Hi Jake,

In your code example, what type of object is value? As the error is suggesting that it is already a NuPickersSqlDropDownPicker?

Thanks,
- Lee

Hi Jake,

Is your saved value:

{[{"key":"Spain","label":"Spain (5)"}]}

or

[{"key":"Spain","label":"Spain (5)"}]

I think nuPickers when set to Json, will by default, save an array of objects. (the second one), in which case the following should work:

var model = JsonConvert.DeserializeObject<IEnumerable<NuPickersSqlDropDownPicker>(value.ToString()).FirstOrDefault()

HTH,

Hendy

hi,

thank you for the replies chaps ;)

sorry, probably should've posted the complete converter:

using System;
using System.ComponentModel;
using Newtonsoft.Json;

namespace Site.Services.Converters
{
    public class NuPickersSqlDropDownPickerConverter : TypeConverter
    {
        public override bool CanConvertFrom(ITypeDescriptorContext context, Type sourceType)
        {
            return sourceType == typeof(Newtonsoft.Json.Linq.JObject) || base.CanConvertFrom(context, sourceType);
        }

        public override object ConvertFrom(ITypeDescriptorContext context, System.Globalization.CultureInfo culture, object value)
        {
            if ((value == null) || ((String.IsNullOrEmpty(value.ToString())))) return null;

            var model = JsonConvert.DeserializeObject<NuPickersSqlDropDownPicker>(value.ToString());

            return model == null ? null : model.Key;
        }

        public class NuPickersSqlDropDownPicker
        {
            public String Key { get; set; }
            public String Label { get; set; }
        }
    }
}

the 'value' is coming from umbraco via the model e.g.

[TypeConverter(typeof(NuPickersSqlDropDownPickerConverter))]
[UmbracoProperty("speciaOffersCountry")]
public string Country { get; set; }

hendy, that seems to be the go i.e. the json being returned is an array of objects - which seems odd as the drop down would only have one selected value?

i've tried the code you've posted but it wasn't happy on 'DeserializeObject' to an 'IEnumerable' so i tried this:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Linq;
using Newtonsoft.Json;

namespace Site.Services.Converters
{
    public class NuPickersSqlDropDownPickerConverter : TypeConverter
    {
        public override bool CanConvertFrom(ITypeDescriptorContext context, Type sourceType)
        {
            return sourceType == typeof(Newtonsoft.Json.Linq.JObject) || base.CanConvertFrom(context, sourceType);
        }

        public override object ConvertFrom(ITypeDescriptorContext context, System.Globalization.CultureInfo culture, object value)
        {
            if ((value == null) || ((String.IsNullOrEmpty(value.ToString())))) return null;

            var model = JsonConvert.DeserializeObject<Objects>(value.ToString());

            return model == null ? null : model.Values.First().Key;
        }

        public class Objects
        {
            public IEnumerable<NuPickersSqlDropDownPicker> Values { get; set; }
        }

        public class NuPickersSqlDropDownPicker
        {
            public String Key { get; set; }
            public String Label { get; set; }
        }
    }
}

but no dice, i still get the deserialize error!

it's weird, we've written a bunch of ditto converters that handle json strings and this is the 1st that's thrown a curve ball!

it must either be the json itself or the class we're trying to deserialize it to?

cheers,

jake

Hi Jake,

I wonder if it's the Property Value Converter built into nuPickers ? can you confirm that the value parameter is a string of Json ? I think it could be a Picker object, in which case you can do a ToString() on it to get the raw saved value.

Hendy

Hi Jake, it stores a single item within an array, as all the property editors share the same save code. The dropdown, radiobutton and list pickers restricted to a max of one item could potentially be changed to store a single object.

hi hendy, thanks for clarifying that, makes sense ;)

one small update: if no value is selected in the drop down, the value returned isn't json... so i've added 'value.ToString() == "nuPickers.Picker"' to the opening if statement to skip over the conversion if no value exists.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Linq;
using Newtonsoft.Json;

namespace Site.Services.Converters
{
    public class NuPickersSqlDropDownPickerConverter : TypeConverter
    {
        public override bool CanConvertFrom(ITypeDescriptorContext context, Type sourceType)
        {
            return sourceType == typeof(Newtonsoft.Json.Linq.JObject) || base.CanConvertFrom(context, sourceType);
        }

        public override object ConvertFrom(ITypeDescriptorContext context, System.Globalization.CultureInfo culture, object value)
        {
            if ((value == null) || ((String.IsNullOrEmpty(value.ToString()))) || (value.ToString() == "nuPickers.Picker")) return null;

            var model = JsonConvert.DeserializeObject<IEnumerable<NuPickersSqlDropDownPicker>>(value.ToString());

            return model == null ? null : model.First().Key;
        }

        public class NuPickersSqlDropDownPicker
        {
            public String Key { get; set; }
            public String Label { get; set; }
        }
    }
}

cheers,

jake

is working on a reply...