private void CreateOrUpdateMaping(RadTreeView RTV, string commanType) { advisorPreferenceBo = new AdviserPreferenceBo(); DataTable dtTreeNodes = new DataTable(); DataTable dtSubTreeNodes = new DataTable(); DataTable dtSubSubTreeNodes = new DataTable(); // Adding treenode Columns dtTreeNodes.Columns.Add("AR_RoleId"); dtTreeNodes.Columns.Add("WTN_TreeNodeId"); //Adding treeSubNode Columns dtSubTreeNodes.Columns.Add("AR_RoleId"); dtSubTreeNodes.Columns.Add("WTSN_SubTreeNodeId"); dtSubTreeNodes.Columns.Add("WTN_TreeNodeId"); //Adding treeSubNode Columns dtSubSubTreeNodes.Columns.Add("AR_RoleId"); dtSubSubTreeNodes.Columns.Add("WTSSN_SubSubTreeNodeId"); dtSubSubTreeNodes.Columns.Add("WTSN_SubTreeNodeId"); dtSubSubTreeNodes.Columns.Add("WTN_TreeNodeId"); // ---------------- Collecting Treenodes ----- foreach (RadTreeNode RTVTreeNodes in RTV.CheckedNodes) { if (RTVTreeNodes.Checked == true && RTVTreeNodes.Level == 0) { dtTreeNodes.Rows.Add(); dtTreeNodes.Rows[dtTreeNodes.Rows.Count - 1]["AR_RoleId"] = Convert.ToInt32(ddlRole.SelectedValue); dtTreeNodes.Rows[dtTreeNodes.Rows.Count - 1]["WTN_TreeNodeId"] = RTVTreeNodes.Value; } } if (dtTreeNodes.Rows.Count > 0) { int i = advisorPreferenceBo.CreateOrUpdateTreeNodeMapping(dtTreeNodes, commanType, userVo.UserId, Convert.ToInt32(ddlLevel.SelectedValue)); } //--------------Collecting SubTreeNodes----- foreach (RadTreeNode RTVSubTreeNodes in RTV.CheckedNodes) { if (RTVSubTreeNodes.Checked == true & RTVSubTreeNodes.Level == 1) { dtSubTreeNodes.Rows.Add(); dtSubTreeNodes.Rows[dtSubTreeNodes.Rows.Count - 1]["AR_RoleId"] = Convert.ToInt32(ddlRole.SelectedValue); dtSubTreeNodes.Rows[dtSubTreeNodes.Rows.Count - 1]["WTN_TreeNodeId"] = RTVSubTreeNodes.ParentNode.Value; dtSubTreeNodes.Rows[dtSubTreeNodes.Rows.Count - 1]["WTSN_SubTreeNodeId"] = RTVSubTreeNodes.Value; } } if (dtSubTreeNodes.Rows.Count > 0) { int i = advisorPreferenceBo.CreateOrUpdateTreeSubNodeMapping(dtSubTreeNodes, commanType, userVo.UserId, Convert.ToInt32(ddlLevel.SelectedValue)); } //------- Collecting SubSubTreeNodes-------------- foreach (RadTreeNode RTVSubSubTreeNodes in RTV.CheckedNodes) { if (RTVSubSubTreeNodes.Checked == true & RTVSubSubTreeNodes.Level == 2) { dtSubSubTreeNodes.Rows.Add(); dtSubSubTreeNodes.Rows[dtSubSubTreeNodes.Rows.Count - 1]["AR_RoleId"] = Convert.ToInt32(ddlRole.SelectedValue); dtSubSubTreeNodes.Rows[dtSubSubTreeNodes.Rows.Count - 1]["WTN_TreeNodeId"] = (RTVSubSubTreeNodes.ParentNode).ParentNode.Value; dtSubSubTreeNodes.Rows[dtSubSubTreeNodes.Rows.Count - 1]["WTSN_SubTreeNodeId"] = RTVSubSubTreeNodes.ParentNode.Value; dtSubSubTreeNodes.Rows[dtSubSubTreeNodes.Rows.Count - 1]["WTSSN_SubSubTreeNodeId"] = RTVSubSubTreeNodes.Value; } } if (dtSubSubTreeNodes.Rows.Count > 0) { int i = advisorPreferenceBo.CreateOrUpdateTreeSubSubNodeMapping(dtSubSubTreeNodes, commanType, userVo.UserId, Convert.ToInt32(ddlLevel.SelectedValue)); } }