예제 #1
0
 protected void insertcity_Click(object sender, EventArgs e)
 {
     if ((TextBox1.Text != ""))
     {
         int t = controllerObj.insertcity(TextBox1.Text, Convert.ToInt32(DropDownList6.SelectedValue));
         if (t == 0)
         {
             Label1.Text = "this city is already exist .";
         }
         else
         {
             Label1.Text = "this city inserts corectly .";
         }
         DropDownList7.DataBind();
         DropDownList6.DataBind();
         DropDownList5.DataBind();
         DropDownList4.DataBind();
         DropDownList3.DataBind();
         DropDownList2.DataBind();   // to make change which happens when delete and insert apeare in other droplists
         DropDownList11.DataBind();
         DropDownList12.DataBind();
         DropDownList13.DataBind();
     }
     else
     {
         Label1.Text = "You enter missing data !!.";
     }
 }
예제 #2
0
 protected void insertcountry_Click(object sender, EventArgs e)
 {
     if (TextBox2.Text != "")
     {
         int t = controllerObj.insertcountry(TextBox2.Text);
         if (t == 0)
         {
             Label2.Text = "this country is already exist .";
         }
         else
         {
             Label2.Text = "this country inserts corectly .";
         }
         DropDownList7.DataBind();
         DropDownList6.DataBind();
         DropDownList5.DataBind();
         DropDownList4.DataBind();
         DropDownList3.DataBind();
         DropDownList2.DataBind();
         DropDownList11.DataBind();
         DropDownList12.DataBind();
         DropDownList13.DataBind();
     }
     else
     {
         Label2.Text = "You enter missing data !!.";
     }
 }
예제 #3
0
 protected void delcity_Click(object sender, EventArgs e)
 {
     controllerObj.deletecity(Convert.ToInt32(DropDownList12.SelectedValue));
     DropDownList7.DataBind();
     DropDownList6.DataBind();
     DropDownList5.DataBind();
     DropDownList4.DataBind();
     DropDownList3.DataBind();
     DropDownList2.DataBind();
     DropDownList11.DataBind();
     DropDownList12.DataBind();
     DropDownList13.DataBind();
 }
        protected void DropDownList12_SelectedIndexChanged(object sender, EventArgs e)
        {
            int ch        = Convert.ToInt32(DropDownList12.SelectedValue);
            var stateid   = from Tbl_chapter in db.Tbl_chapter where Tbl_chapter.Subject_ID.Equals(ch) select new { Tbl_chapter.Name_En, Tbl_chapter.Chapter_ID };
            var statename = stateid.ToList();

            if (statename.Count > 0)
            {
                DropDownList13.DataValueField = "Chapter_ID";
                DropDownList13.DataTextField  = "Name_En";
                DropDownList13.DataSource     = statename;
                DropDownList13.DataBind();
                //DropDownList1.Items.Insert(0, "--- select chapter ----");
            }
        }
 protected void Page_Load(object sender, EventArgs e)
 {
     empno = Convert.ToInt32(Request.QueryString["Empno"].ToString());
     if (!IsPostBack)
     {
         string         Q    = "Select * from mstrCategory";
         SqlCommand     com  = new SqlCommand(Q, dbcls.CONN());
         SqlDataAdapter adpt = new SqlDataAdapter(com);
         DataTable      dt   = new DataTable();
         adpt.Fill(dt);
         TextBox38.DataSource = dt;
         TextBox38.DataBind();
         TextBox38.DataTextField  = "category";
         TextBox38.DataValueField = "cid";
         TextBox38.DataBind();
         DropDownList7.DataSource = dt;
         DropDownList7.DataBind();
         DropDownList7.DataTextField  = "category";
         DropDownList7.DataValueField = "cid";
         DropDownList7.DataBind();
         DropDownList9.DataSource = dt;
         DropDownList9.DataBind();
         DropDownList9.DataTextField  = "category";
         DropDownList9.DataValueField = "cid";
         DropDownList9.DataBind();
         DropDownList11.DataSource = dt;
         DropDownList11.DataBind();
         DropDownList11.DataTextField  = "category";
         DropDownList11.DataValueField = "cid";
         DropDownList11.DataBind();
         DropDownList13.DataSource = dt;
         DropDownList13.DataBind();
         DropDownList13.DataTextField  = "category";
         DropDownList13.DataValueField = "cid";
         DropDownList13.DataBind();
         DropDownList15.DataSource = dt;
         DropDownList15.DataBind();
         DropDownList15.DataTextField  = "category";
         DropDownList15.DataValueField = "cid";
         DropDownList15.DataBind();
         BindTextBoxvalues();
     }
 }
예제 #6
0
    private void BindDropDownList13()
    {
        DataSet        ds      = new DataSet();
        DatabaseHelper DbQuery = new DatabaseHelper();
        DataTable      dt      = new DataTable();
        DataRow        ndr     = dt.NewRow();

        dt.Columns.Add("Filed1", typeof(String));
        dt.Columns.Add("Filed2", typeof(String));
        //Y,N

        dt.Rows.Add(new Object[] { "Y", "Y" });
        dt.Rows.Add(new Object[] { "N", "N" });

        DropDownList13.DataSource     = dt;
        DropDownList13.DataTextField  = "Filed2";
        DropDownList13.DataValueField = "Filed1";
        DropDownList13.DataBind();
    }
예제 #7
0
    private void proirity()
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["connection"]);
        SqlCommand    cmd = new SqlCommand("Select * from Lead_Priority ORDER BY No asc", con);

        con.Open();
        DataSet        ds = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter(cmd);

        da.Fill(ds);


        DropDownList13.DataSource     = ds;
        DropDownList13.DataTextField  = "Lead_Priority";
        DropDownList13.DataValueField = "No";
        DropDownList13.DataBind();
        DropDownList13.Items.Insert(0, new ListItem("-- Choose Option --", "0"));

        con.Close();
    }
예제 #8
0
    protected void Page_Load(object sender, EventArgs e)
    {
        int    advisor_Id = 100, id = 100;
        string date = "4/16/2013";
        string stID = "822459053";

        lblAdvisorID.Text = advisor_Id.ToString();
        lblDate.Text      = date;
        lblStudentID.Text = stID;
        int time = 9;


        this.Util(100);
        DropDownList1.DataSource = getAdvisorIDs();
        DropDownList1.DataBind();

        Label2.Text = getAdvisorImage(advisor_Id);
        Label3.Text = getName(advisor_Id);
        Label4.Text = getDepartment(advisor_Id);
        //   Label5.Text = getMonday(advisor_Id);
        // ////Label6.Text = getTuesday(advisor_Id);
        // ////Label7.Text = getWednesday(advisor_Id);
        // ////Label8.Text = getThursday(advisor_Id);
        // ////Label9.Text = getFriday(advisor_Id);
        DropDownList10.DataSource = getSlots(advisor_Id, date);
        DropDownList10.DataBind();
        DropDownList11.DataSource = getTaken(advisor_Id, date);
        DropDownList11.DataBind();
        DropDownList12.DataSource = getAvailability(getSlots(advisor_Id, date), getTaken(advisor_Id, date));
        DropDownList12.DataBind();
        DropDownList13.DataSource = getDaysAvailable(id);
        DropDownList13.DataBind();
        // //Label14.Text = getAvailableID(time);
        Label15.Text = getCheck(stID).ToString();
        DropDownList16.DataSource = getAdvisor2WeekSchedule();
        DropDownList16.DataBind();
        DropDownList17.DataSource = getAdvisor2WeekSchedule(id);
        DropDownList17.DataBind();
        DropDownList18.DataSource = getStudentIds();
        DropDownList18.DataBind();
    }
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!this.IsPostBack)
     {
         string         Q    = "Select * from mstrCategory";
         SqlCommand     com  = new SqlCommand(Q, dbcls.CONN());
         SqlDataAdapter adpt = new SqlDataAdapter(com);
         DataTable      dt   = new DataTable();
         adpt.Fill(dt);
         TextBox38.DataSource = dt;
         TextBox38.DataBind();
         TextBox38.DataTextField  = "category";
         TextBox38.DataValueField = "cid";
         TextBox38.DataBind();
         DropDownList7.DataSource = dt;
         DropDownList7.DataBind();
         DropDownList7.DataTextField  = "category";
         DropDownList7.DataValueField = "cid";
         DropDownList7.DataBind();
         DropDownList9.DataSource = dt;
         DropDownList9.DataBind();
         DropDownList9.DataTextField  = "category";
         DropDownList9.DataValueField = "cid";
         DropDownList9.DataBind();
         DropDownList11.DataSource = dt;
         DropDownList11.DataBind();
         DropDownList11.DataTextField  = "category";
         DropDownList11.DataValueField = "cid";
         DropDownList11.DataBind();
         DropDownList13.DataSource = dt;
         DropDownList13.DataBind();
         DropDownList13.DataTextField  = "category";
         DropDownList13.DataValueField = "cid";
         DropDownList13.DataBind();
         DropDownList15.DataSource = dt;
         DropDownList15.DataBind();
         DropDownList15.DataTextField  = "category";
         DropDownList15.DataValueField = "cid";
         DropDownList15.DataBind();
     }
 }
예제 #10
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                Panel4.Visible = false;
                Panel2.Visible = false;
                Panel3.Visible = false;
                string cs = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
                using (SqlConnection con = new SqlConnection(cs))
                {
                    SqlCommand cmd = new SqlCommand("Select subjectcode,subjectname from subjectdetails", con);
                    con.Open();
                    SqlDataReader sd;
                    sd = cmd.ExecuteReader();
                    DropDownList4.DataSource = sd;
                    DropDownList4.DataBind();
                    DropDownList4.Items.Insert(0, new ListItem("Select Subject", "NA"));
                    sd.Close();
                    SqlCommand cmd1 = new SqlCommand("Select teacherid,teachername,email,contact from Teacherdeatils", con);
                    sd = cmd1.ExecuteReader();
                    DropDownList5.DataSource = sd;
                    DropDownList5.DataBind();
                    DropDownList5.Items.Insert(0, new ListItem("Select Teacher", "NA"));
                    sd.Close();
                    SqlCommand cmd2 = new SqlCommand("Select teacherid,teachername,email,contact from Teacherdeatils", con);
                    sd = cmd2.ExecuteReader();
                    DropDownList6.DataSource = sd;
                    DropDownList6.DataBind();
                    DropDownList6.Items.Insert(0, new ListItem("Select Assisstant", "NA"));
                    sd.Close();
                    SqlCommand cmd3 = new SqlCommand("Select teacherid,teachername,email,contact from Teacherdeatils", con);
                    sd = cmd3.ExecuteReader();
                    DropDownList9.DataSource = sd;
                    DropDownList9.DataBind();
                    DropDownList9.Items.Insert(0, new ListItem("Select Teacher", "NA"));
                    sd.Close();
                    SqlCommand cmd4 = new SqlCommand("Select teacherid,teachername,email,contact from Teacherdeatils", con);
                    sd = cmd4.ExecuteReader();
                    DropDownList12.DataSource = sd;
                    DropDownList12.DataBind();
                    DropDownList12.Items.Insert(0, new ListItem("Select Teacher", "NA"));
                    sd.Close();
                    SqlCommand cmd5 = new SqlCommand("Select teacherid,teachername,email,contact from Teacherdeatils", con);
                    sd = cmd5.ExecuteReader();
                    DropDownList14.DataSource = sd;
                    DropDownList14.DataBind();
                    DropDownList14.Items.Insert(0, new ListItem("Select Teacher", "NA"));
                    sd.Close();
                    SqlCommand cmd6 = new SqlCommand("Select subjectcode,subjectname from subjectdetails", con);
                    sd = cmd6.ExecuteReader();
                    DropDownList8.DataSource = sd;
                    DropDownList8.DataBind();
                    DropDownList8.Items.Insert(0, new ListItem("Select Subject", "NA"));
                    sd.Close();
                    SqlCommand cmd7 = new SqlCommand("Select subjectcode,subjectname from subjectdetails", con);
                    sd = cmd7.ExecuteReader();
                    DropDownList11.DataSource = sd;
                    DropDownList11.DataBind();
                    DropDownList11.Items.Insert(0, new ListItem("Select Subject", "NA"));
                    sd.Close();
                    SqlCommand cmd8 = new SqlCommand("Select subjectcode,subjectname from subjectdetails", con);
                    sd = cmd8.ExecuteReader();
                    DropDownList13.DataSource = sd;
                    DropDownList13.DataBind();
                    DropDownList13.Items.Insert(0, new ListItem("Select Subject", "NA"));
                    sd.Close();
                    SqlCommand cmd9 = new SqlCommand("Select Id,classroom,lab from Room", con);
                    sd = cmd9.ExecuteReader();
                    DropDownList3.DataSource = sd;
                    DropDownList3.DataBind();
                    DropDownList3.Items.Insert(0, new ListItem("Select Lab Room", "NA"));
                    sd.Close();
                    SqlCommand cmd10 = new SqlCommand("Select Id,classroom,lab from Room", con);
                    sd = cmd10.ExecuteReader();
                    DropDownList7.DataSource = sd;
                    DropDownList7.DataBind();
                    DropDownList7.Items.Insert(0, new ListItem("Select Class Room", "NA"));
                    sd.Close();
                    //SqlCommand cmd11 = new SqlCommand("Insert into ROOM 1,"+DropDownList7.SelectedItem.Text+", "+DropDownList3.SelectedItem.Text, con);

                    /*  if (DropDownList11.Items.Contains(DropDownList8.SelectedItem))
                     * {
                     *    DropDownList11.Items.IndexOf(DropDownList8.SelectedItem);
                     *    DropDownList11.SelectedItem.Enabled = false;
                     * }*/
                }
            }
            //Panel1.Visible = true;
        }
예제 #11
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                var x = Request.QueryString["page"].ToString();
                int y = int.Parse(x);
                if (y == 1)
                {
                    Panel2.Visible = true;
                    var x1 = Request.QueryString["id"].ToString();
                    int y1 = int.Parse(x1);

                    Tbl_department rr      = db.Tbl_department.First(u => u.Department_ID == y1);
                    int            dep     = Convert.ToInt32(rr.Level_ID);
                    var            stateid = from Tbl_Level in db.Tbl_Level where Tbl_Level.Level_ID.Equals(dep) select new { Tbl_Level.Name_Ar, Tbl_Level.Name_Er, Tbl_Level.Level_ID };
                    var            le      = from Tbl_Level in db.Tbl_Level select new { Tbl_Level.Name_Er, Tbl_Level.Level_ID, Tbl_Level.Name_Ar };
                    DropDownList1.DataSource     = le.ToList();
                    DropDownList1.DataValueField = "Level_ID";
                    DropDownList1.DataTextField  = "Name_Er";
                    DropDownList1.DataBind();
                    DropDownList1.SelectedValue = dep.ToString();

                    name_ar_dep.Text = rr.Name_Ar;
                    name_en_dep.Text = rr.Name_En;
                }

                else if (y == 112)
                {
                    Panel7.Visible = true;
                    var x1 = Request.QueryString["id"].ToString();
                    int y1 = int.Parse(x1);

                    Tbl_department rr      = db.Tbl_department.First(u => u.Department_ID == y1);
                    int            dep     = Convert.ToInt32(rr.Level_ID);
                    var            stateid = from Tbl_Level in db.Tbl_Level where Tbl_Level.Level_ID.Equals(dep) select new { Tbl_Level.Name_Ar, Tbl_Level.Name_Er, Tbl_Level.Level_ID };
                    var            le      = from Tbl_Level in db.Tbl_Level select new { Tbl_Level.Name_Er, Tbl_Level.Level_ID, Tbl_Level.Name_Ar };
                    DropDownList9.DataSource     = le.ToList();
                    DropDownList9.DataValueField = "Level_ID";
                    DropDownList9.DataTextField  = "Name_Ar";
                    DropDownList9.DataBind();
                    DropDownList9.SelectedValue = dep.ToString();

                    TextBox14.Text = rr.Name_Ar;
                    TextBox13.Text = rr.Name_En;
                }



                else if (y == 21)
                {
                    Panel8.Visible = true;

                    var x1 = Request.QueryString["id"].ToString();
                    int y1 = int.Parse(x1);

                    Tbl_Subject rr      = db.Tbl_Subject.First(u => u.Subject_ID == y1);
                    int         pro     = Convert.ToInt32(rr.Prof_ID);
                    var         stateid = from Tbl_Prof in db.Tbl_Prof where Tbl_Prof.Approval.Equals("1") select new { Tbl_Prof.Prof_ID, Tbl_Prof.Name };
                    //var pr = from Tbl_Prof in db.Tbl_Prof select new { Tbl_Prof.Name, Tbl_Prof.Prof_ID };
                    DropDownList10.DataSource     = stateid.ToList();
                    DropDownList10.DataValueField = "Prof_ID";
                    DropDownList10.DataTextField  = "Name";
                    DropDownList10.DataBind();
                    DropDownList10.SelectedValue = pro.ToString();

                    int            dep = Convert.ToInt32(rr.Department_ID);
                    Tbl_department de  = db.Tbl_department.First(d => d.Department_ID == dep);
                    int            lev = Convert.ToInt32(de.Level_ID);
                    var            le  = from Tbl_Level in db.Tbl_Level select new { Tbl_Level.Name_Er, Tbl_Level.Level_ID, Tbl_Level.Name_Ar };
                    DropDownList11.DataSource     = le.ToList();
                    DropDownList11.DataValueField = "Level_ID";
                    DropDownList11.DataTextField  = "Name_Ar";
                    DropDownList11.DataBind();
                    DropDownList11.SelectedValue = lev.ToString();

                    var stateidDep = from Tbl_department in db.Tbl_department where Tbl_department.Level_ID.Equals(lev) select new { Tbl_department.Department_ID, Tbl_department.Level_ID, Tbl_department.Name_En, Tbl_department.Name_Ar };

                    var statename = stateidDep.ToList();
                    if (statename.Count > 0)
                    {
                        DropDownList12.DataSource     = statename;
                        DropDownList12.DataValueField = "Department_ID";
                        DropDownList12.DataTextField  = "Name_Ar";
                        DropDownList12.DataBind();
                        DropDownList12.SelectedValue = dep.ToString();
                    }

                    TextBox15.Text = rr.Name_Er;
                    TextBox16.Text = rr.Name_Ar;
                }

                else if (y == 2)
                {
                    Panel3.Visible = true;

                    var x1 = Request.QueryString["id"].ToString();
                    int y1 = int.Parse(x1);

                    Tbl_Subject rr      = db.Tbl_Subject.First(u => u.Subject_ID == y1);
                    int         pro     = Convert.ToInt32(rr.Prof_ID);
                    var         stateid = from Tbl_Prof in db.Tbl_Prof where Tbl_Prof.Approval.Equals("1") select new { Tbl_Prof.Prof_ID, Tbl_Prof.Name };
                    //var pr = from Tbl_Prof in db.Tbl_Prof select new { Tbl_Prof.Name, Tbl_Prof.Prof_ID };
                    DropDownList4.DataSource     = stateid.ToList();
                    DropDownList4.DataValueField = "Prof_ID";
                    DropDownList4.DataTextField  = "Name";
                    DropDownList4.DataBind();
                    DropDownList4.SelectedValue = pro.ToString();

                    int            dep = Convert.ToInt32(rr.Department_ID);
                    Tbl_department de  = db.Tbl_department.First(d => d.Department_ID == dep);
                    int            lev = Convert.ToInt32(de.Level_ID);
                    var            le  = from Tbl_Level in db.Tbl_Level select new { Tbl_Level.Name_Er, Tbl_Level.Level_ID };
                    DropDownList2.DataSource     = le.ToList();
                    DropDownList2.DataValueField = "Level_ID";
                    DropDownList2.DataTextField  = "Name_Er";
                    DropDownList2.DataBind();
                    DropDownList2.SelectedValue = lev.ToString();

                    var stateidDep = from Tbl_department in db.Tbl_department where Tbl_department.Level_ID.Equals(lev) select new { Tbl_department.Department_ID, Tbl_department.Level_ID, Tbl_department.Name_En };

                    var statename = stateidDep.ToList();
                    if (statename.Count > 0)
                    {
                        DropDownList3.DataSource     = statename;
                        DropDownList3.DataValueField = "Department_ID";
                        DropDownList3.DataTextField  = "Name_En";
                        DropDownList3.DataBind();
                        DropDownList3.SelectedValue = dep.ToString();
                    }

                    TextBox1.Text = rr.Name_Er;
                    TextBox2.Text = rr.Name_Ar;
                }


                else if (y == 31)
                {
                    Panel9.Visible = true;
                    var      x1 = Request.QueryString["id"].ToString();
                    int      y1 = int.Parse(x1);
                    Tbl_Prof rr = db.Tbl_Prof.First(u => u.Prof_ID == y1);
                    TextBox17.Text = rr.Name.ToString();
                    TextBox18.Text = rr.Password.ToString();
                    TextBox19.Text = rr.Email.ToString();
                }

                else if (y == 3)
                {
                    Panel1.Visible = true;
                    var      x1 = Request.QueryString["id"].ToString();
                    int      y1 = int.Parse(x1);
                    Tbl_Prof rr = db.Tbl_Prof.First(u => u.Prof_ID == y1);
                    TextBox4.Text = rr.Name.ToString();
                    TextBox5.Text = rr.Password.ToString();
                    TextBox6.Text = rr.Email.ToString();
                }



                else if (y == 41)
                {
                    Panel10.Visible = true;
                    var         x1 = Request.QueryString["id"].ToString();
                    int         y1 = int.Parse(x1);
                    Tbl_Student rr = db.Tbl_Student.First(u => u.Student_ID == y1);
                    TextBox20.Text = rr.Name.ToString();
                    TextBox21.Text = rr.Password.ToString();
                    TextBox22.Text = rr.Email.ToString();
                    var lev = rr.Level_ID;
                    var dep = rr.Department_ID;

                    var le = from Tbl_Level in db.Tbl_Level select new { Tbl_Level.Name_Er, Tbl_Level.Level_ID, Tbl_Level.Name_Ar };
                    DropDownList13.DataSource     = le.ToList();
                    DropDownList13.DataValueField = "Level_ID";
                    DropDownList13.DataTextField  = "Name_Ar";
                    DropDownList13.DataBind();
                    DropDownList13.SelectedValue = lev.ToString();

                    var stateidDep = from Tbl_department in db.Tbl_department where Tbl_department.Level_ID.Equals(lev) select new { Tbl_department.Department_ID, Tbl_department.Level_ID, Tbl_department.Name_En, Tbl_department.Name_Ar };

                    var statename = stateidDep.ToList();
                    if (statename.Count > 0)
                    {
                        DropDownList14.DataSource     = statename;
                        DropDownList14.DataValueField = "Department_ID";
                        DropDownList14.DataTextField  = "Name_Ar";
                        DropDownList14.DataBind();
                        DropDownList14.SelectedValue = dep.ToString();
                    }
                }



                else if (y == 4)
                {
                    Panel4.Visible = true;
                    var         x1 = Request.QueryString["id"].ToString();
                    int         y1 = int.Parse(x1);
                    Tbl_Student rr = db.Tbl_Student.First(u => u.Student_ID == y1);
                    TextBox3.Text = rr.Name.ToString();
                    TextBox7.Text = rr.Password.ToString();
                    TextBox8.Text = rr.Email.ToString();
                    var lev = rr.Level_ID;
                    var dep = rr.Department_ID;

                    var le = from Tbl_Level in db.Tbl_Level select new { Tbl_Level.Name_Er, Tbl_Level.Level_ID };
                    DropDownList5.DataSource     = le.ToList();
                    DropDownList5.DataValueField = "Level_ID";
                    DropDownList5.DataTextField  = "Name_Er";
                    DropDownList5.DataBind();
                    DropDownList5.SelectedValue = lev.ToString();

                    var stateidDep = from Tbl_department in db.Tbl_department where Tbl_department.Level_ID.Equals(lev) select new { Tbl_department.Department_ID, Tbl_department.Level_ID, Tbl_department.Name_En };

                    var statename = stateidDep.ToList();
                    if (statename.Count > 0)
                    {
                        DropDownList6.DataSource     = statename;
                        DropDownList6.DataValueField = "Department_ID";
                        DropDownList6.DataTextField  = "Name_En";
                        DropDownList6.DataBind();
                        DropDownList6.SelectedValue = dep.ToString();
                    }
                }



                else if (y == 61)
                {
                    Panel11.Visible = true;
                    var x1 = Request.QueryString["id"].ToString();
                    int y1 = int.Parse(x1);

                    Tbl_chapter rr  = db.Tbl_chapter.First(u => u.Chapter_ID == y1);
                    int         dep = Convert.ToInt32(rr.Subject_ID);

                    var x2        = Request.QueryString["pr"].ToString();
                    int y2        = int.Parse(x2);
                    var stateid   = from Tbl_Subject in db.Tbl_Subject where Tbl_Subject.Prof_ID.Equals(y2) select new { Tbl_Subject.Subject_ID, Tbl_Subject.Name_Ar };
                    var statename = stateid.ToList();
                    if (statename.Count > 0)
                    {
                        DropDownList15.DataValueField = "Subject_ID";
                        DropDownList15.DataTextField  = "Name_Ar";
                        DropDownList15.DataSource     = statename;
                        DropDownList15.DataBind();
                        DropDownList15.Items.Insert(0, "--- select sub----");
                    }
                    DropDownList15.SelectedValue = dep.ToString();

                    TextBox24.Text = rr.Name_Ar;
                    TextBox23.Text = rr.Name_En;
                }

                else if (y == 6)
                {
                    Panel5.Visible = true;
                    var x1 = Request.QueryString["id"].ToString();
                    int y1 = int.Parse(x1);

                    Tbl_chapter rr  = db.Tbl_chapter.First(u => u.Chapter_ID == y1);
                    int         dep = Convert.ToInt32(rr.Subject_ID);

                    var x2        = Request.QueryString["pr"].ToString();
                    int y2        = int.Parse(x2);
                    var stateid   = from Tbl_Subject in db.Tbl_Subject where Tbl_Subject.Prof_ID.Equals(y2) select new { Tbl_Subject.Subject_ID, Tbl_Subject.Name_Er };
                    var statename = stateid.ToList();
                    if (statename.Count > 0)
                    {
                        DropDownList7.DataValueField = "Subject_ID";
                        DropDownList7.DataTextField  = "Name_Er";
                        DropDownList7.DataSource     = statename;
                        DropDownList7.DataBind();
                        DropDownList7.Items.Insert(0, "--- select sub----");
                    }
                    DropDownList7.SelectedValue = dep.ToString();

                    TextBox10.Text = rr.Name_Ar;
                    TextBox9.Text  = rr.Name_En;
                }



                else if (y == 71)
                {
                    Panel12.Visible = true;
                    var          x1 = Request.QueryString["id"].ToString();
                    int          y1 = int.Parse(x1);
                    Tbl_Question rr = db.Tbl_Question.First(u => u.Question_ID == y1);
                    TextBox26.Text = rr.Question_Ar.ToString();
                    TextBox25.Text = rr.Question_En.ToString();
                    DropDownList16.SelectedValue = rr.Question_Level.ToString();
                    var x2 = Request.QueryString["pr"].ToString();
                    int y2 = int.Parse(x2);
                }

                else if (y == 7)
                {
                    Panel6.Visible = true;
                    var          x1 = Request.QueryString["id"].ToString();
                    int          y1 = int.Parse(x1);
                    Tbl_Question rr = db.Tbl_Question.First(u => u.Question_ID == y1);
                    TextBox12.Text = rr.Question_Ar.ToString();
                    TextBox11.Text = rr.Question_En.ToString();
                    DropDownList8.SelectedValue = rr.Question_Level.ToString();
                    var x2 = Request.QueryString["pr"].ToString();
                    int y2 = int.Parse(x2);
                }
            }
        }