public void GenarateHierarchy() { var root = new RootItem(); DataTable dt = Connstring.SqlDataTable(@"SELECT [id], RTRIM(LTRIM([name])) AS name, RTRIM(LTRIM([parentID])) AS parentID, weight FROM [PPLDEV].[dbo].[hierarchy];"); var parents = GetTopLevelRows(dt); root.nodeStructure = CreateItem(dt, parents); var serializer = new JavaScriptSerializer(); serializer.RegisterConverters(new JavaScriptConverter[] { new NullPropertiesConverter() }); var json = serializer.Serialize(root); }
public void CustomJson() { var obj = new RootItem(); obj.chart = new Chart(); obj.chart.container = "#example"; obj.chart.nodeAlign = "BOTTOM"; obj.chart.connectors = new ConnectorsType(); obj.chart.connectors.type = "step"; obj.chart.node = new Node(); obj.chart.node.HTMLclass = "nodeExample1"; obj.scrollbar = "fancy"; obj.animateOnInit = true; obj.node = new Node(); obj.node.collapsable = true; obj.animation = new Animation(); obj.animation.nodeAnimation = "easeOutBounce"; obj.animation.nodeSpeed = "nodeSpeed"; obj.animation.connectorsAnimation = "bounce"; obj.animation.connectorsSpeed = 700; obj.nodeStructure = new ChildNodeStructure(); obj.nodeStructure.text = new Text(); obj.nodeStructure.text.name = "MKT (CMO)"; obj.nodeStructure.HTMLclass = "blue"; obj.nodeStructure.image = "images/no_member.png"; var child1 = new ChildNodeStructure() { connectors = new Connector() { style = new Style() { stroke = "#000000" } }, text = new Text() { name = "Sales", }, HTMLclass = "blue", image = "images/no_member.png" }; var subchild1 = new ChildNodeStructure() { connectors = new Connector() { style = new Style() { stroke = "#000000" } }, text = new Text() { name = "SLM (HOD)", }, HTMLclass = "blue", image = "images/no_member.png" }; var subchild2 = new ChildNodeStructure() { connectors = new Connector() { style = new Style() { stroke = "#000000" } }, text = new Text() { name = "PPL & AKP (HOD)" }, HTMLclass = "blue", image = "images/no_member.png" }; var subchild3 = new ChildNodeStructure() { connectors = new Connector() { style = new Style() { stroke = "#000000" } }, text = new Text() { name = "DP (HOD)" }, HTMLclass = "blue", image = "images/no_member.png" }; var subchild4 = new ChildNodeStructure() { connectors = new Connector() { style = new Style() { stroke = "#000000" } }, text = new Text() { name = "CRE & Others (HOD)" }, HTMLclass = "blue", image = "images/no_member.png" }; var sublist = new List <ChildNodeStructure>(); sublist.Add(subchild1); sublist.Add(subchild2); sublist.Add(subchild3); sublist.Add(subchild4); child1.children = sublist; var child2 = new ChildNodeStructure() { connectors = new Connector() { style = new Style() { stroke = "#000000" } }, pseudo = true, children = new List <ChildNodeStructure>() { new ChildNodeStructure { text = new Text { name = "Distribution (HOD)" }, HTMLclass = "blue", image = "images/no_member.png" } } }; var child3 = new ChildNodeStructure() { connectors = new Connector() { style = new Style() { stroke = "#000000" } }, text = new Text() { name = "Marketing" }, HTMLclass = "blue", image = "images/no_member.png", link = new Link() { href = "www.google.com", target = "_blank" }, children = new List <ChildNodeStructure>() { new ChildNodeStructure() { children = new List <ChildNodeStructure>() { new ChildNodeStructure() { pseudo = true, connectors = new Connector(), children = new List <ChildNodeStructure>() { new ChildNodeStructure() { pseudo = true, connectors = new Connector(), children = new List <ChildNodeStructure>() { new ChildNodeStructure() { pseudo = true, connectors = new Connector(), children = new List <ChildNodeStructure>() { new ChildNodeStructure() { text = new Text() { name = "Final Test :D" }, HTMLclass = "blue", image = "images/no_member.png" } } } } } } } } }, new ChildNodeStructure() { connectors = new Connector() { style = new Style() { stroke = "#000000" } }, text = new Text() { name = "Com (HOD)" }, HTMLclass = "blue", image = "images/no_member.png" }, new ChildNodeStructure() { connectors = new Connector() { style = new Style() { stroke = "#000000" } }, text = new Text() { name = "BRD (HOD)" }, HTMLclass = "blue", image = "images/no_member.png" } } }; var childlist = new List <ChildNodeStructure>(); childlist.Add(child1); childlist.Add(child2); childlist.Add(child3); obj.nodeStructure.children = childlist; //var serializer = new JavaScriptSerializer(); //var serializedResult = serializer.Serialize(obj); var serializer = new JavaScriptSerializer(); serializer.RegisterConverters(new JavaScriptConverter[] { new NullPropertiesConverter() }); var json = serializer.Serialize(obj); }