예제 #1
0
    public void bindandsavesubject()
    {
        string    subjectno          = "";
        string    parentcode         = "";
        string    unitname           = "";
        string    topicno            = "";
        string    description        = "";
        string    noofhrs            = "";
        string    bookref            = "";
        string    steachaid          = "";
        string    bookdetails        = "";
        string    methogology        = "";
        string    instruction        = "";
        int       count              = 0;
        int       firsttopicnumber   = 0;
        int       inctopicnum        = 0;
        string    bindparentcode     = "";
        string    bindtempparentcode = "";
        string    bindpreviouspcode  = "";
        ArrayList alunitname         = new ArrayList();
        DataSet   dsvalue            = new DataSet();
        DataView  dvvalue            = new DataView();

        if (ddlsubject.SelectedValue != toddlsubject.SelectedValue)
        {
            lblerrormsg.Text    = "";
            lblerrormsg.Visible = false;

            string query = "select * from sub_unit_details where subject_no='" + ddlsubject.SelectedValue + "'";
            dsvalue = d2.select_method_wo_parameter(query, "n");


            string dt_topics  = "";
            string dt_topics1 = "";

            string subjectsno = toddlsubject.SelectedValue.ToString();
            subjectno = ddlsubject.SelectedValue.ToString();
            if (!string.IsNullOrEmpty(subjectsno))
            {
                con.Close();
                con.Open();

                //this.TreeView1.Nodes.Clear();
                HierarchyTrees       hierarchyTrees = new HierarchyTrees();
                HierarchyTrees.HTree objHTree       = null;

                // TreeView2.Nodes.Clear();
                //start=======common tree load
                using (SqlCommand command = new SqlCommand("select topic_no,parent_code,unit_name from sub_unit_details where subject_no='" + subjectno + "' order by parent_code,topic_no ", con))
                {
                    //this.TreeView1.Nodes.Clear();
                    hierarchyTrees.Clear();
                    SqlDataReader reader = command.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
                    while (reader.Read())
                    {
                        objHTree             = new HierarchyTrees.HTree();
                        objHTree.topic_no    = int.Parse(reader["Topic_no"].ToString());
                        objHTree.parent_code = int.Parse(reader["parent_code"].ToString());
                        objHTree.unit_name   = reader["unit_name"].ToString();
                        hierarchyTrees.Add(objHTree);
                    }
                }
                int i = 0;
                foreach (HierarchyTrees.HTree hTree in hierarchyTrees)
                {
                    HierarchyTrees.HTree parentNode = hierarchyTrees.Find(delegate(HierarchyTrees.HTree emp) { return(emp.topic_no == hTree.parent_code); });
                    if (parentNode != null)
                    {
                        foreach (TreeNode tn in TreeView2.Nodes)
                        {
                            if (tn.Value == parentNode.topic_no.ToString())
                            {
                                //tn.ChildNodes.Add(new TreeNode(hTree.unit_name.ToString(), hTree.topic_no.ToString()));
                                //Session["session_tnValue"] = tn;
                            }
                            if (tn.ChildNodes.Count > 0)
                            {
                                foreach (TreeNode ctn in tn.ChildNodes)
                                {
                                    string checkunitname = parentNode.unit_name.ToString();
                                    if (alunitname.Contains(hTree.unit_name) == false)
                                    {
                                        alunitname.Add(hTree.unit_name);

                                        dsvalue.Tables[0].DefaultView.RowFilter = "unit_name='" + hTree.unit_name + "'";
                                        dvvalue = dsvalue.Tables[0].DefaultView;
                                        if (dvvalue.Count > 0)
                                        {
                                            description = Convert.ToString(dvvalue[0]["description"]);
                                        }

                                        string parentsNode     = parentNode.topic_no.ToString();
                                        string bindpparentcode = "select topic_no from sub_unit_details where  subject_no='" + subjectsno + "' and unit_name='" + checkunitname + "' ";
                                        con.Close();
                                        con.Open();
                                        SqlCommand findparentcmd = new SqlCommand(bindpparentcode, con);
                                        string     preparentcode = Convert.ToString(findparentcmd.ExecuteScalar());
                                        unitname = hTree.unit_name;
                                        //=================Modified by Venkat=======================
                                        //string insertvalue = "insert into sub_unit_details(subject_no,Parent_code,unit_name)values('" + subjectsno + "','" + preparentcode + "','" + unitname + "')";
                                        //con.Close();
                                        //con.Open();
                                        //SqlCommand sqlcmd = new SqlCommand(insertvalue, con);
                                        //count = sqlcmd.ExecuteNonQuery();
                                        string insertvalue = "insert into sub_unit_details(subject_no,Parent_code,unit_name)values('" + subjectsno + "','" + preparentcode + "','" + unitname + "')";
                                        int    a           = dal.update_method_wo_parameter(insertvalue, "Text");
                                    }

                                    // tn.ChildNodes.Remove(new TreeNode(hTree.unit_name.ToString(), hTree.topic_no.ToString()));
                                }
                            }
                        }
                    }
                    else
                    {
                        // TreeView1.Nodes.Add(new TreeNode(hTree.unit_name, hTree.topic_no.ToString()));
                        unitname = hTree.unit_name;
                        string pparentNode = "0";

                        //=================Modified by Venkat=======================
                        //string insertvalue = "insert into sub_unit_details(subject_no,Parent_code,unit_name)values('" + subjectsno + "','" + pparentNode + "','" + unitname + "')";
                        //con.Close();
                        //con.Open();
                        //SqlCommand sqlcmd = new SqlCommand(insertvalue, con);
                        //count = sqlcmd.ExecuteNonQuery();

                        string insertvalue = "insert into sub_unit_details(subject_no,Parent_code,unit_name)values('" + subjectsno + "','" + pparentNode + "','" + unitname + "')";
                        count = dal.update_method_wo_parameter(insertvalue, "Text");
                    }
                }

                if (count != 0)
                {
                    ScriptManager.RegisterStartupScript(this, typeof(Page), UniqueID, "alert('Syllabus copied Successfully')", true);
                    clear();
                }
            }
        }
        else
        {
            lblerrormsg.Text    = "Kindly Select Different Subject";
            lblerrormsg.Visible = true;
        }
    }
예제 #2
0
    private void toPopulateTreeview()
    {
        string dt_topics  = "";
        string dt_topics1 = "";

        string subjectno = ddlsubject.SelectedValue.ToString();

        if (!string.IsNullOrEmpty(subjectno))
        {
            con.Close();
            con.Open();

            //this.TreeView1.Nodes.Clear();
            HierarchyTrees       hierarchyTrees = new HierarchyTrees();
            HierarchyTrees.HTree objHTree       = null;

            //start=======common tree load
            using (SqlCommand command = new SqlCommand("select topic_no,parent_code,unit_name from sub_unit_details where subject_no='" + subjectno + "' order by parent_code,topic_no ", con))
            {
                //this.TreeView1.Nodes.Clear();
                hierarchyTrees.Clear();
                SqlDataReader reader = command.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
                while (reader.Read())
                {
                    objHTree             = new HierarchyTrees.HTree();
                    objHTree.topic_no    = int.Parse(reader["Topic_no"].ToString());
                    objHTree.parent_code = int.Parse(reader["parent_code"].ToString());
                    objHTree.unit_name   = reader["unit_name"].ToString();
                    hierarchyTrees.Add(objHTree);
                }
            }

            foreach (HierarchyTrees.HTree hTree in hierarchyTrees)
            {
                HierarchyTrees.HTree parentNode = hierarchyTrees.Find(delegate(HierarchyTrees.HTree emp)
                {
                    return(emp.topic_no == hTree.parent_code);
                }
                                                                      );
                if (parentNode != null)
                {
                    foreach (TreeNode tn in TreeView2.Nodes)
                    {
                        if (tn.Value == parentNode.topic_no.ToString())
                        {
                            tn.ChildNodes.Add(new TreeNode(hTree.unit_name.ToString(), hTree.topic_no.ToString()));
                            //Session["session_tnValue"] = tn;
                        }
                        if (tn.ChildNodes.Count > 0)
                        {
                            foreach (TreeNode ctn in tn.ChildNodes)
                            {
                                RecursiveChild(ctn, parentNode.topic_no.ToString(), hTree);
                            }
                        }
                    }
                }
                else
                {
                    TreeView2.Nodes.Add(new TreeNode(hTree.unit_name, hTree.topic_no.ToString()));
                }

                TreeView2.ExpandAll();
            }

            TreeView2.ExpandAll();
            if (TreeView2.Nodes.Count < 1)
            {
            }
            else
            {
                TreeView2.Visible = true;
                btnsave.Visible   = true;
            }
        }
    }