private void BindReptTransactionDashBoard()
{
DataSet dsTreeNodes = new DataSet();
dsTreeNodes = XMLBo.GetSuperAdminTreeNodes(path);
DataRow[] drXmlTreeSubSubNode;
DataRow drTransationTreeNode;
DataTable dtTransationTreeNode = new DataTable();
dtTransationTreeNode.Columns.Add("TreeNode1", typeof(Int32));
dtTransationTreeNode.Columns.Add("TreeNodeText1", typeof(String));
// dtTransationTreeNode.Columns.Add("Path1", typeof(String));
dtTransationTreeNode.Columns.Add("TreeNode2", typeof(Int32));
dtTransationTreeNode.Columns.Add("TreeNodeText2", typeof(String));
//For Transaction 2014 is Tree Node Id in Sub Table in XML...
int treeSubNodeId = 2014;
drXmlTreeSubSubNode = dsTreeNodes.Tables[2].Select("TreeSubNodeCode=" + treeSubNodeId.ToString());
int count = 0;
drTransationTreeNode = dtTransationTreeNode.NewRow();
foreach (DataRow drSubSubNode in drXmlTreeSubSubNode)
{
if (count == 0)
{
count++;
drTransationTreeNode["TreeNode1"] = drSubSubNode["TreeSubSubNodeCode"].ToString();
drTransationTreeNode["TreeNodeText1"] = drSubSubNode["TreeSubSubNodeText"].ToString();
//drTransationTreeNode["Path1"] = drSubSubNode["Path"].ToString();
dtTransationTreeNode.Rows.Add(drTransationTreeNode);
}
else if (count == 1)
{
count++;
drTransationTreeNode["TreeNode2"] = drSubSubNode["TreeSubSubNodeCode"].ToString();
drTransationTreeNode["TreeNodeText2"] = drSubSubNode["TreeSubSubNodeText"].ToString();
// drTransationTreeNode["Path2"] = drSubSubNode["Path"].ToString();
count = 0;
drTransationTreeNode = dtTransationTreeNode.NewRow();
}
}
rptTransationTree.DataSource = dtTransationTreeNode;
rptTransationTree.DataBind();
}
private void BindReptReportDashBoard()
{
// dtReportTreeNode = XMLBo.GetUploadTreeNode(path);
DataSet dsTreeNodes = new DataSet();
DataTable dtRoleAssociationTreeNode = new DataTable();
//string expression = "NodeType = 'Reports'";
//dtReportTreeNode.DefaultView.RowFilter = expression;
dsTreeNodes = XMLBo.GetSuperAdminTreeNodes(path);
dtRoleAssociationTreeNode = XMLBo.GetRoleAssociationTreeNode(path);
DataRow[] drXmlTreeSubSubNode;
DataRow[] drXmlRoleToTreeSubSubNode;
DataRow drReportTreeNode;
DataTable dtReportTreeNode = new DataTable();
dtReportTreeNode.Columns.Add("TreeNode1", typeof(Int32));
dtReportTreeNode.Columns.Add("TreeNodeText1", typeof(String));
dtReportTreeNode.Columns.Add("TreeNode2", typeof(Int32));
dtReportTreeNode.Columns.Add("TreeNodeText2", typeof(String));
if (advisorVo.advisorId == Convert.ToInt32(ConfigurationSettings.AppSettings["ONLINE_ADVISER"]))
{
}
//For upload 2009 is Tree Node Id in Sub Table in XML...
int treeSubNodeId = 2010;
drXmlTreeSubSubNode = dsTreeNodes.Tables[2].Select("TreeSubNodeCode=" + treeSubNodeId.ToString());
int count = 0;
drReportTreeNode = dtReportTreeNode.NewRow();
foreach (DataRow drSubSubNode in drXmlTreeSubSubNode)
{
int roleCount = 0;
drXmlRoleToTreeSubSubNode = dtRoleAssociationTreeNode.Select("TreeSubSubNodeCode=" + drSubSubNode["TreeSubSubNodeCode"].ToString());
if (drXmlRoleToTreeSubSubNode.Count() > 0)
{
foreach (DataRow drUserRole in drXmlRoleToTreeSubSubNode)
{
if (int.Parse(drUserRole["UserRoleId"].ToString()) == roleId)
{
roleCount++;
break;
}
}
}
if (roleCount > 0)
{
if (count == 0)
{
count++;
drReportTreeNode["TreeNode1"] = drSubSubNode["TreeSubSubNodeCode"].ToString();
drReportTreeNode["TreeNodeText1"] = drSubSubNode["TreeSubSubNodeText"].ToString();
dtReportTreeNode.Rows.Add(drReportTreeNode);
}
else if (count == 1)
{
count++;
drReportTreeNode["TreeNode2"] = drSubSubNode["TreeSubSubNodeCode"].ToString();
drReportTreeNode["TreeNodeText2"] = drSubSubNode["TreeSubSubNodeText"].ToString();
count = 0;
drReportTreeNode = dtReportTreeNode.NewRow();
}
}
else
{
// break;
}
}
rptReportTree.DataSource = dtReportTreeNode;
rptReportTree.DataBind();
}
private void BindReptHoldingsDashBoard()
{
DataSet dsTreeNodes = new DataSet();
dsTreeNodes = XMLBo.GetSuperAdminTreeNodes(path);
DataRow[] drXmlTreeSubSubNode;
DataRow drHoldingsTreeNode;
DataTable dtHoldingsTreeNode = new DataTable();
dtHoldingsTreeNode.Columns.Add("TreeNode1", typeof(Int32));
dtHoldingsTreeNode.Columns.Add("TreeNodeText1", typeof(String));
dtHoldingsTreeNode.Columns.Add("TreeNode2", typeof(Int32));
dtHoldingsTreeNode.Columns.Add("TreeNodeText2", typeof(String));
//For holding dashboard 2013 is Tree Node Id in Sub Table in XML...
int treeSubNodeId = 2013;
drXmlTreeSubSubNode = dsTreeNodes.Tables[2].Select("TreeSubNodeCode=" + treeSubNodeId.ToString());
int count = 0;
drHoldingsTreeNode = dtHoldingsTreeNode.NewRow();
foreach (DataRow drSubSubNode in drXmlTreeSubSubNode)
{
int roleCount = 0;
if ((roleId == 1001 || roleId == 1002) && (drSubSubNode["TreeSubSubNodeCode"].ToString() == "3021" || drSubSubNode["TreeSubSubNodeCode"].ToString() == "3022" || drSubSubNode["TreeSubSubNodeCode"].ToString() == "3023"))
{
roleCount = 0;
}
else
{
roleCount++;
}
if (roleCount > 0)
{
if (count == 0)
{
count++;
drHoldingsTreeNode["TreeNode1"] = drSubSubNode["TreeSubSubNodeCode"].ToString();
drHoldingsTreeNode["TreeNodeText1"] = drSubSubNode["TreeSubSubNodeText"].ToString();
dtHoldingsTreeNode.Rows.Add(drHoldingsTreeNode);
}
else if (count == 1)
{
count++;
drHoldingsTreeNode["TreeNode2"] = drSubSubNode["TreeSubSubNodeCode"].ToString();
drHoldingsTreeNode["TreeNodeText2"] = drSubSubNode["TreeSubSubNodeText"].ToString();
count = 0;
drHoldingsTreeNode = dtHoldingsTreeNode.NewRow();
}
}
if (roleId == 1009)
{
break;
}
}
rptHoldingTree.DataSource = dtHoldingsTreeNode;
rptHoldingTree.DataBind();
}
private void BindReptUploadGrid()
{
DataTable dtUploadTreeSubSubNode = new DataTable();
DataTable dtUploadTreeSubNode = new DataTable();
DataTable dtRoleAssociationTreeNode = new DataTable();
DataSet dsTreeNodes = new DataSet();
path = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"]).ToString();
dsTreeNodes = XMLBo.GetSuperAdminTreeNodes(path);
dtRoleAssociationTreeNode = XMLBo.GetRoleAssociationTreeNode(path);
DataRow[] drMFXmlTreeSubSubNode;
DataRow[] drEQXmlTreeSubSubNode;
DataRow[] drFIXmlTreeSubSubNode;
DataRow[] drMFXmlRoleToTreeSubSubNode;
DataRow[] drEQXmlRoleToTreeSubSubNode;
DataRow[] drFIXmlRoleToTreeSubSubNode;
DataRow drUploadTreeNode;
DataTable dtUploadTreeNode = new DataTable();
dtUploadTreeNode.Columns.Add("TreeNode1", typeof(Int32));
dtUploadTreeNode.Columns.Add("TreeNodeText1", typeof(String));
dtUploadTreeNode.Columns.Add("Path1", typeof(String));
dtUploadTreeNode.Columns.Add("TreeNode2", typeof(Int32));
dtUploadTreeNode.Columns.Add("TreeNodeText2", typeof(String));
dtUploadTreeNode.Columns.Add("Path2", typeof(String));
//dtUploadTreeNode.Columns.Add("TreeNode3", typeof(Int32));
//dtUploadTreeNode.Columns.Add("TreeNodeText3", typeof(String));
//dtUploadTreeNode.Columns.Add("Path3", typeof(String));
//dtUploadTreeNode.Columns.Add("TreeNode4", typeof(Int32));
//dtUploadTreeNode.Columns.Add("TreeNodeText4", typeof(String));
//dtUploadTreeNode.Columns.Add("Path4", typeof(String));
DataTable dtEQTreeNodes = new DataTable();
dtEQTreeNodes = dtUploadTreeNode.Clone();
DataTable dtFITreeNodes = new DataTable();
dtFITreeNodes = dtUploadTreeNode.Clone();
//For upload 2009 is Tree Node Id in Sub Table in XML...
int treeSubNodeId = 2009;
DataTable dtSubtreeNodes = new DataTable();
DataTable dtMFSubtreeNodes = new DataTable();
DataTable dtEQSubtreeNodes = new DataTable();
DataTable dtFISubtreeNodes = new DataTable();
dtSubtreeNodes = dsTreeNodes.Tables[2].Clone();
dsTreeNodes.Tables[2].Select("Deleted=" + "false").CopyToDataTable(dtSubtreeNodes, LoadOption.Upsert);
dtMFSubtreeNodes = dtSubtreeNodes.Clone();
dtEQSubtreeNodes = dtSubtreeNodes.Clone();
dtFISubtreeNodes = dtSubtreeNodes.Clone();
dtSubtreeNodes.Select("Category='" + "MF" + "'").CopyToDataTable(dtMFSubtreeNodes, LoadOption.OverwriteChanges);
dtSubtreeNodes.Select("Category='" + "EQ" + "'").CopyToDataTable(dtEQSubtreeNodes, LoadOption.Upsert);
dtSubtreeNodes.Select("Category='" + "FI" + "'").CopyToDataTable(dtFISubtreeNodes, LoadOption.Upsert);
drMFXmlTreeSubSubNode = dtMFSubtreeNodes.Select("TreeSubNodeCode=" + treeSubNodeId.ToString());
int count = 0;
int roleCount;
drUploadTreeNode = dtUploadTreeNode.NewRow();
foreach (DataRow drSubSubNode in drMFXmlTreeSubSubNode)
{
drMFXmlRoleToTreeSubSubNode = dtRoleAssociationTreeNode.Select("TreeSubSubNodeCode=" + drSubSubNode["TreeSubSubNodeCode"].ToString());
roleCount = 0;
if (drMFXmlRoleToTreeSubSubNode.Count() > 0)
{
foreach (DataRow drUserRole in drMFXmlRoleToTreeSubSubNode)
{
if (int.Parse(drUserRole["UserRoleId"].ToString()) == roleId)
{
roleCount++;
break;
}
}
}
if (roleCount > 0)
{
if (count == 0)
{
count++;
drUploadTreeNode["TreeNode1"] = drSubSubNode["TreeSubSubNodeCode"].ToString();
drUploadTreeNode["TreeNodeText1"] = drSubSubNode["TreeSubSubNodeText"].ToString();
drUploadTreeNode["Path1"] = drSubSubNode["Path"].ToString();
dtUploadTreeNode.Rows.Add(drUploadTreeNode);
}
else if (count == 1)
{
count++;
drUploadTreeNode["TreeNode2"] = drSubSubNode["TreeSubSubNodeCode"].ToString();
drUploadTreeNode["TreeNodeText2"] = drSubSubNode["TreeSubSubNodeText"].ToString();
drUploadTreeNode["Path2"] = drSubSubNode["Path"].ToString();
count = 0;
drUploadTreeNode = dtUploadTreeNode.NewRow();
}
//else if (count == 2)
//{
// count++;
// drUploadTreeNode["TreeNode3"] = drSubSubNode["TreeSubSubNodeCode"].ToString();
// drUploadTreeNode["TreeNodeText3"] = drSubSubNode["TreeSubSubNodeText"].ToString();
// drUploadTreeNode["Path3"] = drSubSubNode["Path"].ToString();
//}
//else if (count == 3)
//{
// count++;
// drUploadTreeNode["TreeNode4"] = drSubSubNode["TreeSubSubNodeCode"].ToString();
// drUploadTreeNode["TreeNodeText4"] = drSubSubNode["TreeSubSubNodeText"].ToString();
// drUploadTreeNode["Path4"] = drSubSubNode["Path"].ToString();
// count = 0;
// drUploadTreeNode = dtUploadTreeNode.NewRow();
//}
}
else
{
//break;
}
}
rptMFTree.DataSource = dtUploadTreeNode;
rptMFTree.DataBind();
//----------------EQ __----------------------------
//drEQXmlTreeSubSubNode = dtEQSubtreeNodes.Select("TreeSubNodeCode=" + treeSubNodeId.ToString());
//count = 0;
//DataRow drEqUploadTreeNode = dtEQTreeNodes.NewRow();
//foreach (DataRow drSubSubNode in drEQXmlTreeSubSubNode)
//{
// drEQXmlRoleToTreeSubSubNode = dtRoleAssociationTreeNode.Select("TreeSubSubNodeCode=" + drSubSubNode["TreeSubSubNodeCode"].ToString());
// roleCount = 0;
// if (drEQXmlRoleToTreeSubSubNode.Count() > 0)
// {
// foreach (DataRow drUserRole in drEQXmlRoleToTreeSubSubNode)
// {
// if (int.Parse(drUserRole["UserRoleId"].ToString()) == roleId)
// {
// roleCount++;
// break;
// }
// }
// }
// if (roleCount > 0)
// {
// if (count == 0)
// {
// count++;
// drEqUploadTreeNode["TreeNode1"] = drSubSubNode["TreeSubSubNodeCode"].ToString();
// drEqUploadTreeNode["TreeNodeText1"] = drSubSubNode["TreeSubSubNodeText"].ToString();
// drEqUploadTreeNode["Path1"] = drSubSubNode["Path"].ToString();
// dtEQTreeNodes.Rows.Add(drEqUploadTreeNode);
// }
// else if (count == 1)
// {
// count++;
// drEqUploadTreeNode["TreeNode2"] = drSubSubNode["TreeSubSubNodeCode"].ToString();
// drEqUploadTreeNode["TreeNodeText2"] = drSubSubNode["TreeSubSubNodeText"].ToString();
// drEqUploadTreeNode["Path2"] = drSubSubNode["Path"].ToString();
// count = 0;
// drEqUploadTreeNode = dtEQTreeNodes.NewRow();
// }
// //else if (count == 2)
// //{
// // count++;
// // drEqUploadTreeNode["TreeNode3"] = drSubSubNode["TreeSubSubNodeCode"].ToString();
// // drEqUploadTreeNode["TreeNodeText3"] = drSubSubNode["TreeSubSubNodeText"].ToString();
// // drEqUploadTreeNode["Path3"] = drSubSubNode["Path"].ToString();
// //}
// //else if (count == 3)
// //{
// // count++;
// // drEqUploadTreeNode["TreeNode4"] = drSubSubNode["TreeSubSubNodeCode"].ToString();
// // drEqUploadTreeNode["TreeNodeText4"] = drSubSubNode["TreeSubSubNodeText"].ToString();
// // drEqUploadTreeNode["Path4"] = drSubSubNode["Path"].ToString();
// // count = 0;
// // drEqUploadTreeNode = dtEQTreeNodes.NewRow();
// //}
// }
// else
// {
// //break;
// }
//}
//rptTreenodeEQ.DataSource = dtEQTreeNodes;
//rptTreenodeEQ.DataBind();
//-----------------------FI---------------------------
drFIXmlTreeSubSubNode = dtFISubtreeNodes.Select("TreeSubNodeCode=" + treeSubNodeId.ToString());
count = 0;
DataRow drFIUploadTreeNode = dtFITreeNodes.NewRow();
foreach (DataRow drSubSubNode in drFIXmlTreeSubSubNode)
{
drFIXmlRoleToTreeSubSubNode = dtRoleAssociationTreeNode.Select("TreeSubSubNodeCode=" + drSubSubNode["TreeSubSubNodeCode"].ToString());
roleCount = 0;
if (drFIXmlRoleToTreeSubSubNode.Count() > 0)
{
foreach (DataRow drUserRole in drFIXmlRoleToTreeSubSubNode)
{
if (int.Parse(drUserRole["UserRoleId"].ToString()) == roleId)
{
roleCount++;
break;
}
}
}
if (roleCount > 0)
{
if (count == 0)
{
count++;
drFIUploadTreeNode["TreeNode1"] = drSubSubNode["TreeSubSubNodeCode"].ToString();
drFIUploadTreeNode["TreeNodeText1"] = drSubSubNode["TreeSubSubNodeText"].ToString();
drFIUploadTreeNode["Path1"] = drSubSubNode["Path"].ToString();
dtFITreeNodes.Rows.Add(drFIUploadTreeNode);
}
}
else
{
//break;
}
}
rptTreenodeFI.DataSource = dtFITreeNodes;
rptTreenodeFI.DataBind();
//dtUploadTreeSubSubNode = XMLBo.GetSuperAdminTreeSubSubNodes(path);
//dtUploadTreeSubNode = XMLBo.GetSuperAdminTreeSubNodes(path);
//dsTreeNodes.Tables.Add(dtUploadTreeNode);
//dsTreeNodes.Tables.Add(dtUploadTreeSubNode);
//dsTreeNodes.Tables.Add(dtUploadTreeSubSubNode);
//dsTreeNodes.Tables[0].PrimaryKey = new DataColumn[] { dsTreeNodes.Tables[0].Columns["TreeNodeCode"] };
//dsTreeNodes.Tables[1].PrimaryKey = new DataColumn[] { dsTreeNodes.Tables[1].Columns["TreeSubNodeCode"] };
//dsTreeNodes.Tables[2].PrimaryKey = new DataColumn[] { dsTreeNodes.Tables[2].Columns["TreeSubSubNodeCode"] };
//DataRelation drel = new DataRelation("EquiJoin12", dsTreeNodes.Tables[0].Columns["TreeNodeCode"], dsTreeNodes.Tables[1].Columns["TreeNodeCode"]);
//dsTreeNodes.Relations.Add(drel);
//DataRelation drelFull = new DataRelation("EquiJoin23", dsTreeNodes.Tables[1].Columns["TreeSubNodeCode"], dsTreeNodes.Tables[2].Columns["TreeSubSubNodeCode"]);
//DataRow[] drSubNodeDetails;
//if (dtUploadTreeNode.Rows.Count > 0)
//{
// drSubNodeDetails = dtUploadTreeNode.Select("TreeNodeCode =" + treeSubNodeId.ToString());
// foreach (DataRow dr in drSubNodeDetails)
// {
// drSubNode = dtSubNodeDetails.NewRow();
// drSubNode["TreeSubNodeId"] = dr["TreeSubNodeCode"].ToString();
// drSubNode["TreeSubNodetext"] = dr["TreeSubNodeText"].ToString();
// dtSubNodeDetails.Rows.Add(drSubNode);
// }
//}
// dtUploadTreeNode = XMLBo.GetUploadTreeNode(path);
//DataTable jt = new DataTable("Joinedtable");
//jt.Columns.Add("TreeNodeCode", typeof(Int32));
//jt.Columns.Add("TreeSubNodeCode", typeof(Int32));
//jt.Columns.Add("TreeSubSubNodeCode", typeof(Int32));
//jt.Columns.Add("Path", typeof(String));
//jt.Columns.Add("TreeSubSubNodeText", typeof(String));
//dsTreeNodes.Tables.Add(jt);
//foreach (DataRow dr in dsTreeNodes.Tables[0].Rows)
//{
// DataRow parent = dr.GetParentRow("EquiJoin12");
// DataRow current = jt.NewRow();
// // Just add all the columns' data in "dr" to the New table.
// for (int i = 0; i < dsTreeNodes.Tables[0].Columns.Count; i++)
// {
// current[i] = dr[i];
// }
// // Add the column that is not present in the child, which is present in the parent.
// current["TreeNodeCode"] = parent["TreeNodeCode"];
// jt.Rows.Add(current);
//}
//string expression = "NodeType = 'Upload'";
//dtUploadTreeNode.DefaultView.RowFilter = expression;
//rptTree.DataSource = dtUploadTreeNode.DefaultView.ToTable();
//rptTree.DataBind();
}