protected void ddl_semester_selectindexchanged(object sender, EventArgs e)
    {
        try
        {
            gV_View.DataSource = null;
            gV_View.DataBind();

            int semesterId = Convert.ToInt16(ddl_semester.SelectedItem.Value);
            try
            {
                int    id   = Convert.ToInt32(Session["UserId"]);
                string role = Convert.ToString(Session["Role"]);

                if (role == "Faculty")
                {
                    ddl_employee.DataSource     = P.BindERPFacultyOnly(id, semesterId);
                    ddl_employee.DataTextField  = "FACULTY_NAME";
                    ddl_employee.DataValueField = "FACULTY_ID";
                    ddl_employee.DataBind();
                }
                else
                {
                    ddl_employee.DataSource     = P.BindERPFacultyOnly(0, semesterId);
                    ddl_employee.DataTextField  = "FACULTY_NAME";
                    ddl_employee.DataValueField = "FACULTY_ID";
                    ddl_employee.DataBind();
                    if (ddl_reportList.SelectedItem.Value == "Sp_StudentContactDetails")
                    {
                        ddl_employee.Items.Insert(0, new ListItem("ALL", "0"));
                    }
                }


                try
                {
                    ddl_batch.DataSource     = P.BindERPSemester(semesterId, Convert.ToInt16(ddl_employee.SelectedItem.Value));
                    ddl_batch.DataTextField  = "BatchCode";
                    ddl_batch.DataValueField = "Batch_Id";
                    ddl_batch.DataBind();
                    if (ddl_reportList.SelectedItem.Value == "Sp_StudentContactDetails")
                    {
                        ddl_batch.Items.Insert(0, new ListItem("ALL", "0"));
                    }
                }
                catch
                {
                    ddl_batch.Items.Clear();
                    gV_View.DataSource = null;
                    gV_View.DataBind();
                }
                bindgrid();
            }
            catch (Exception Ex)
            {
            }
        }
        catch
        {
        }
    }