I created this dummy class that will get
populated using User Control Wrapper.
public class DDValues
{
public string Name { get; set; }
public int ID { get; set; }
public DDValues() { }
public DDValues(string
name, int id)
{
Name = name;
ID = id;
}
//Other properties, methods, events...
}
Here is an example on how to set it up.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using umbraco.cms.businesslogic.datatype;
using System.Data;
using umbraco.editorControls.userControlGrapper;
namespace MobileSite_Controls.usercontrols
{
public partial class DropdownByTypeReturnClass
: System.Web.UI.UserControl,
umbraco.editorControls.userControlGrapper.IUsercontrolDataEditor
{
[DataEditorSetting("Type
ID")]
public string typeid
{ get; set; }
protected void
Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string
connection = System.Configuration.ConfigurationManager.AppSettings["umbracoDbDSN"].ToString();
ddcontrol.DataSource = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(connection, CommandType.Text, "SELECT
id, Name FROM tblcustomDropdownValues where TypeID=" + (string.IsNullOrEmpty(typeid) ? "0" : typeid));
ddcontrol.DataTextField = "Name";
ddcontrol.DataValueField = "Name";
ddcontrol.DataBind();
ddcontrol.Items.Insert(0, new ListItem(string.Empty,
string.Empty));
ddcontrol.SelectedIndex = 0;
if (_umbval!=null)
{ ddcontrol.SelectedValue = _umbval.Name; }
}
}
private DDValues
_umbval;
public object value
{
get {
return SerializationHelper.ValueToXmlString(new DDValues("Boston", 1));
}
set {
if (value
!= null && string.IsNullOrEmpty(value.ToString()))
{
_umbval = new DDValues("", 0);
}
else
{
try
{
_umbval = (DDValues)SerializationHelper.ValueFromXmlString(value, typeof(DDValues));
}
catch
{
_umbval = new DDValues("", 0);
}
}
}
}
}
public class DDValues
{
public string Name { get; set; }
public int ID { get; set; }
public DDValues() { }
public DDValues(string
name, int id)
{
Name = name;
ID = id;
}
//Other properties, methods, events...
}
}
Now, above Data Type can be assigned to the new Document
Type with an alias. Example alias can be StateDD
To output on the front-end using Razor script
<umbraco:Macro runat="server" language="cshtml">
@Model.StateDD.ID
@Model.StateDD.Name
</umbraco:Macro>
