private void FillBranches()
{
tvBranches.Nodes.Clear();
GetSelectedBranchTypes();
objAuditDB = new AuditDB();
DataSet ds = new DataSet();
chkComp.Visible = false;
ds = objAuditDB.GetAuditBranchRegions("", "", "", "", CommonData.LogUserId, "PARENT");
TreeNode tNode;
if (strBranTypes.Length >= 2)
{
try
{
if (ds.Tables[0].Rows.Count > 0)
{
chkComp.Visible = true;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
tvBranches.Nodes.Add(ds.Tables[0].Rows[i]["COMPANY_CODE"].ToString(), ds.Tables[0].Rows[i]["COMPANY_NAME"].ToString());
DataSet dschild = new DataSet();
dschild = objAuditDB.GetAuditBranchRegions(ds.Tables[0].Rows[i]["COMPANY_CODE"].ToString(), strBranTypes, "", "", "", "ZONES");
if (dschild.Tables[0].Rows.Count > 0)
{
for (int j = 0; j < dschild.Tables[0].Rows.Count; j++)
{
tvBranches.Nodes[i].Nodes.Add(dschild.Tables[0].Rows[j]["ABM_STATE"].ToString(), dschild.Tables[0].Rows[j]["ABM_STATE"].ToString());
DataSet dschild1 = new DataSet();
dschild1 = objAuditDB.GetAuditBranchRegions(ds.Tables[0].Rows[i]["COMPANY_CODE"].ToString(), strBranTypes, dschild.Tables[0].Rows[j]["ABM_STATE"].ToString(), "", "", "REGIONS");
if (dschild1.Tables[0].Rows.Count > 0)
{
for (int k = 0; k < dschild1.Tables[0].Rows.Count; k++)
{
tvBranches.Nodes[i].Nodes[j].Nodes.Add(dschild1.Tables[0].Rows[k]["ABM_REGION"].ToString(), dschild1.Tables[0].Rows[k]["ABM_REGION"].ToString());
DataSet dschild2 = new DataSet();
dschild2 = objAuditDB.GetAuditBranchRegions(ds.Tables[0].Rows[i]["COMPANY_CODE"].ToString(), strBranTypes, dschild.Tables[0].Rows[j]["ABM_STATE"].ToString(), dschild1.Tables[0].Rows[k]["ABM_REGION"].ToString(), CommonData.LogUserId, "BRANCHES");
if (dschild2.Tables[0].Rows.Count > 0)
{
for (int ivar = 0; ivar < dschild2.Tables[0].Rows.Count; ivar++)
{
tvBranches.Nodes[i].Nodes[j].Nodes[k].Nodes.Add(dschild2.Tables[0].Rows[ivar]["BranchCode"].ToString(), dschild2.Tables[0].Rows[ivar]["BranchName"].ToString());
}
}
}
}
}
}
}
}
for (int i = 0; i < tvBranches.Nodes.Count; i++)
{
for (int j = 0; j < tvBranches.Nodes[i].Nodes.Count; j++)
{
if (tvBranches.Nodes[i].Nodes[j].Nodes.Count > 0)
{
tvBranches.Nodes[i].FirstNode.Expand();
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
private void FillBranchandRegions()
{
tvBranches.Nodes.Clear();
objAuditDB = new AuditDB();
DataSet ds = new DataSet();
ds = objAuditDB.GetAuditBranchRegions("", "", "", "", CommonData.LogUserId, "PARENT");
TreeNode tNode;
try
{
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
tvBranches.Nodes.Add(ds.Tables[0].Rows[i]["COMPANY_CODE"].ToString(), ds.Tables[0].Rows[i]["COMPANY_NAME"].ToString());
DataSet dschild = new DataSet();
dschild = objAuditDB.GetAuditBranchRegions(ds.Tables[0].Rows[i]["COMPANY_CODE"].ToString(), "", "", "", CommonData.LogUserId, "ZONES");
if (dschild.Tables[0].Rows.Count > 0)
{
for (int j = 0; j < dschild.Tables[0].Rows.Count; j++)
{
tvBranches.Nodes[i].Nodes.Add(dschild.Tables[0].Rows[j]["ABM_STATE"].ToString(), dschild.Tables[0].Rows[j]["ABM_STATE"].ToString());
DataSet dschild1 = new DataSet();
dschild1 = objAuditDB.GetAuditBranchRegions(ds.Tables[0].Rows[i]["COMPANY_CODE"].ToString(), "", dschild.Tables[0].Rows[j]["ABM_STATE"].ToString(), "", CommonData.LogUserId, "REGIONS");
if (dschild1.Tables[0].Rows.Count > 0)
{
for (int k = 0; k < dschild1.Tables[0].Rows.Count; k++)
{
tvBranches.Nodes[i].Nodes[j].Nodes.Add(dschild1.Tables[0].Rows[k]["ABM_REGION"].ToString(), dschild1.Tables[0].Rows[k]["ABM_REGION"].ToString());
DataSet dschild2 = new DataSet();
dschild2 = objAuditDB.GetAuditBranchRegions(ds.Tables[0].Rows[i]["COMPANY_CODE"].ToString(), "HO", dschild.Tables[0].Rows[j]["ABM_STATE"].ToString(), dschild1.Tables[0].Rows[k]["ABM_REGION"].ToString(), CommonData.LogUserId, "BRANCHES");
tvBranches.Nodes[i].Nodes[j].Nodes[k].Nodes.Add("HO" + "(" + dschild2.Tables[0].Rows.Count + ")");
if (dschild2.Tables[0].Rows.Count > 0)
{
for (int ivar = 0; ivar < dschild2.Tables[0].Rows.Count; ivar++)
{
tvBranches.Nodes[i].Nodes[j].Nodes[k].Nodes[0].Nodes.Add(dschild2.Tables[0].Rows[ivar]["BranchCode"].ToString(), dschild2.Tables[0].Rows[ivar]["BranchName"].ToString());
}
}
dschild2 = objAuditDB.GetAuditBranchRegions(ds.Tables[0].Rows[i]["COMPANY_CODE"].ToString(), "BR", dschild.Tables[0].Rows[j]["ABM_STATE"].ToString(), dschild1.Tables[0].Rows[k]["ABM_REGION"].ToString(), CommonData.LogUserId, "BRANCHES");
tvBranches.Nodes[i].Nodes[j].Nodes[k].Nodes.Add("BRANCHES" + "(" + dschild2.Tables[0].Rows.Count + ")");
if (dschild2.Tables[0].Rows.Count > 0)
{
for (int ivar = 0; ivar < dschild2.Tables[0].Rows.Count; ivar++)
{
tvBranches.Nodes[i].Nodes[j].Nodes[k].Nodes[1].Nodes.Add(dschild2.Tables[0].Rows[ivar]["BranchCode"].ToString(), dschild2.Tables[0].Rows[ivar]["BranchName"].ToString());
}
}
dschild2 = objAuditDB.GetAuditBranchRegions(ds.Tables[0].Rows[i]["COMPANY_CODE"].ToString(), "SP", dschild.Tables[0].Rows[j]["ABM_STATE"].ToString(), dschild1.Tables[0].Rows[k]["ABM_REGION"].ToString(), CommonData.LogUserId, "BRANCHES");
tvBranches.Nodes[i].Nodes[j].Nodes[k].Nodes.Add("STOCK POINTS" + "(" + dschild2.Tables[0].Rows.Count + ")");
if (dschild2.Tables[0].Rows.Count > 0)
{
for (int ivar = 0; ivar < dschild2.Tables[0].Rows.Count; ivar++)
{
tvBranches.Nodes[i].Nodes[j].Nodes[k].Nodes[2].Nodes.Add(dschild2.Tables[0].Rows[ivar]["BranchCode"].ToString(), dschild2.Tables[0].Rows[ivar]["BranchName"].ToString());
}
}
dschild2 = objAuditDB.GetAuditBranchRegions(ds.Tables[0].Rows[i]["COMPANY_CODE"].ToString(), "PU", dschild.Tables[0].Rows[j]["ABM_STATE"].ToString(), dschild1.Tables[0].Rows[k]["ABM_REGION"].ToString(), CommonData.LogUserId, "BRANCHES");
tvBranches.Nodes[i].Nodes[j].Nodes[k].Nodes.Add("PRODUCTION UNITS" + "(" + dschild2.Tables[0].Rows.Count + ")");
if (dschild2.Tables[0].Rows.Count > 0)
{
for (int ivar = 0; ivar < dschild2.Tables[0].Rows.Count; ivar++)
{
tvBranches.Nodes[i].Nodes[j].Nodes[k].Nodes[3].Nodes.Add(dschild2.Tables[0].Rows[ivar]["BranchCode"].ToString(), dschild2.Tables[0].Rows[ivar]["BranchName"].ToString());
}
}
dschild2 = objAuditDB.GetAuditBranchRegions(ds.Tables[0].Rows[i]["COMPANY_CODE"].ToString(), "TU", dschild.Tables[0].Rows[j]["ABM_STATE"].ToString(), dschild1.Tables[0].Rows[k]["ABM_REGION"].ToString(), CommonData.LogUserId, "BRANCHES");
tvBranches.Nodes[i].Nodes[j].Nodes[k].Nodes.Add("TRANSPORT UNITS" + "(" + dschild2.Tables[0].Rows.Count + ")");
if (dschild2.Tables[0].Rows.Count > 0)
{
for (int ivar = 0; ivar < dschild2.Tables[0].Rows.Count; ivar++)
{
tvBranches.Nodes[i].Nodes[j].Nodes[k].Nodes[4].Nodes.Add(dschild2.Tables[0].Rows[ivar]["BranchCode"].ToString(), dschild2.Tables[0].Rows[ivar]["BranchName"].ToString());
}
}
dschild2 = objAuditDB.GetAuditBranchRegions(ds.Tables[0].Rows[i]["COMPANY_CODE"].ToString(), "OL", dschild.Tables[0].Rows[j]["ABM_STATE"].ToString(), dschild1.Tables[0].Rows[k]["ABM_REGION"].ToString(), CommonData.LogUserId, "BRANCHES");
tvBranches.Nodes[i].Nodes[j].Nodes[k].Nodes.Add("OUTLETS" + "(" + dschild2.Tables[0].Rows.Count + ")");
if (dschild2.Tables[0].Rows.Count > 0)
{
for (int ivar = 0; ivar < dschild2.Tables[0].Rows.Count; ivar++)
{
tvBranches.Nodes[i].Nodes[j].Nodes[k].Nodes[5].Nodes.Add(dschild2.Tables[0].Rows[ivar]["BranchCode"].ToString(), dschild2.Tables[0].Rows[ivar]["BranchName"].ToString());
}
}
}
}
}
}
}
}
for (int i = 0; i < tvBranches.Nodes.Count; i++)
{
for (int j = 0; j < tvBranches.Nodes[i].Nodes.Count; j++)
{
if (tvBranches.Nodes[i].Nodes[j].Nodes.Count > 0)
{
tvBranches.Nodes[i].FirstNode.Expand();
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}