/// <summary>
/// Converts an XML document to an IJavaScriptObject (JSON).
/// <see cref="http://www.xml.com/pub/a/2006/05/31/converting-between-xml-and-json.html?page=1">Stefan Goessner</see>
/// <see cref="http://developer.yahoo.com/common/json.html#xml">Yahoo XML JSON</see>
/// </summary>
/// <param name="n">The XmlNode to serialize to JSON.</param>
/// <returns>A IJavaScriptObject.</returns>
public static IJavaScriptObject GetIJavaScriptObjectFromXmlNode(XmlNode n)
{
if (n == null)
{
return(null);
}
//if (xpath == "" || xpath == "/")
// xpath = n.Name;
System.Text.RegularExpressions.Regex r = new System.Text.RegularExpressions.Regex(@"\w+|\W+", System.Text.RegularExpressions.RegexOptions.Compiled);
JavaScriptObject o = new JavaScriptObject();
if (n.NodeType == XmlNodeType.Element)
{
for (int i = 0; i < n.Attributes.Count; i++)
{
o.Add("@" + n.Attributes[i].Name, n.Attributes[i].Value);
}
if (n.FirstChild != null) // element has child nodes
{
int textChild = 0;
bool hasElementChild = false;
for (XmlNode e = n.FirstChild; e != null; e = e.NextSibling)
{
if (e.NodeType == XmlNodeType.Element)
{
hasElementChild = true;
}
if (e.NodeType == XmlNodeType.Text && r.IsMatch(e.InnerText))
{
textChild++; // non-whitespace text
}
}
if (hasElementChild)
{
if (textChild < 2) // structured element with evtl. a single text node
{
for (XmlNode e = n.FirstChild; e != null; e = e.NextSibling)
{
if (e.NodeType == XmlNodeType.Text)
{
o.Add("#text", e.InnerText);
}
else if (o.ContainsKey(e.Name))
{
if (o[e.Name] is JavaScriptArray)
{
((JavaScriptArray)o[e.Name]).Add(GetIJavaScriptObjectFromXmlNode(e));
}
else
{
IJavaScriptObject _o = o[e.Name];
JavaScriptArray a = new JavaScriptArray();
a.Add(_o);
a.Add(GetIJavaScriptObjectFromXmlNode(e));
o[e.Name] = a;
}
}
else
{
o.AddInternal(e.Name, GetIJavaScriptObjectFromXmlNode(e));
}
}
}
}
else if (textChild > 0)
{
if (n.Attributes.Count == 0)
{
return(new JavaScriptString(n.InnerText));
}
else
{
o.Add("#text", n.InnerText);
}
}
}
if (n.Attributes.Count == 0 && n.FirstChild == null)
{
return(new JavaScriptString(n.InnerText));
}
}
else if (n.NodeType == XmlNodeType.Document)
{
return(GetIJavaScriptObjectFromXmlNode(((XmlDocument)n).DocumentElement));
}
else
{
throw new NotSupportedException("Unhandled node type '" + n.NodeType + "'.");
}
return(o);
}
/// <summary>
/// Converts an IJavaScriptObject into an NET object.
/// </summary>
/// <param name="o">The IJavaScriptObject object to convert.</param>
/// <param name="t"></param>
/// <returns>Returns a .NET object.</returns>
public override object Deserialize(IJavaScriptObject o, Type t)
{
JavaScriptObject ht = o as JavaScriptObject;
if (ht == null)
{
throw new NotSupportedException();
}
if (!ht.ContainsKey("columns") || !(ht["columns"] is JavaScriptArray) ||
!ht.ContainsKey("columnTypes") || !(ht["columnTypes"] is JavaScriptArray) ||
!ht.ContainsKey("rows") || !(ht["rows"] is JavaScriptArray))
{
throw new NotSupportedException();
}
JavaScriptArray columns = (JavaScriptArray)ht["columns"];
JavaScriptArray columnTypes = (JavaScriptArray)ht["columnTypes"];
JavaScriptArray rows = (JavaScriptArray)ht["rows"];
if (columns.Count != columnTypes.Count)
{
throw new NotSupportedException();
}
DataTable dt = new DataTable();
DataRow row = null;
Type colType;
JavaScriptString columnName;
JavaScriptString columnType;
if (ht.ContainsKey("name") && ht["name"] is JavaScriptString)
{
dt.TableName = ht["name"].ToString();
}
for (int i = 0; i < columns.Count; i++)
{
columnName = (JavaScriptString)columns[i];
columnType = (JavaScriptString)columnTypes[i];
colType = Type.GetType(columnType, true);
dt.Columns.Add(columnName, colType);
}
JavaScriptArray cols = null;
object obj;
for (int y = 0; y < rows.Count; y++)
{
// if(!(r is JavaScriptArray))
// continue;
cols = (JavaScriptArray)rows[y];
row = dt.NewRow();
for (int i = 0; i < cols.Count; i++)
{
//row[i] = JavaScriptDeserializer.Deserialize((IJavaScriptObject)cols[i], dt.Columns[i].DataType);
obj = JavaScriptDeserializer.Deserialize((IJavaScriptObject)cols[i], dt.Columns[i].DataType);
row[i] = (obj == null) ? DBNull.Value : obj;
}
dt.Rows.Add(row);
}
return(dt);
}
