public void binddegree()
{
try
{
//ddl_degree.Items.Clear();
cbl_degree.Items.Clear();
txt_degree.Text = lbl_degree.Text;
cb_degree.Checked = true;
string stream = "";
stream = ddl_strm.Items.Count > 0 ? ddl_strm.SelectedValue : "";
string query = "select distinct degree.course_id,course.course_name from degree,course,deptprivilages where course.course_id=degree.course_id and course.college_code = degree.college_code and degree.college_code in (" + collegeCode + ") and deptprivilages.Degree_code=degree.Degree_code and user_code=" + userCode + " ";
if (ddl_strm.Enabled)
{
query += " and course.type in ('" + stream + "')";
}
DataSet ds = DA.select_method_wo_parameter(query, "Text");
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
//ddl_degree.DataSource = ds;
//ddl_degree.DataTextField = "course_name";
//ddl_degree.DataValueField = "course_id";
//ddl_degree.DataBind();
cbl_degree.DataSource = ds;
cbl_degree.DataTextField = "course_name";
cbl_degree.DataValueField = "course_id";
cbl_degree.DataBind();
reUse.CallCheckBoxChangedEvent(cbl_degree, cb_degree, txt_degree, lbl_degree.Text);
}
}
catch (Exception ex) { }
}
public void bindCollege()
{
try
{
txt_College.Text = "College";
cb_College.Checked = true;
cbl_College.Items.Clear();
string selectQuery = "select cp.college_code,cf.collname from collegeprivilages cp,collinfo cf where user_code=" + userCode + " and cp.college_code=cf.college_code";
DataTable dtCollege = dirAccess.selectDataTable(selectQuery);
if (dtCollege.Rows.Count > 0)
{
cbl_College.DataSource = dtCollege;
cbl_College.DataTextField = "collname";
cbl_College.DataValueField = "college_code";
cbl_College.DataBind();
}
reUse.CallCheckBoxChangedEvent(cbl_College, cb_College, txt_College, "College");
}
catch { }
}
protected void cb_question_CheckedChanged(object sender, EventArgs e)
{
rs.CallCheckBoxChangedEvent(cbl_question, cb_question, txt_question, "Question");
}
protected void cb_dept_CheckedChange(object sender, EventArgs e)
{
rs.CallCheckBoxChangedEvent(cbl_dept, cb_dept, txt_dept, "Department");
}
public void Cb_college_CheckedChanged(object sender, EventArgs e)
{
rs.CallCheckBoxChangedEvent(Cbl_college, Cb_college, Txt_college, "College");
}
protected void cb_certificate_checkedchange(object sender, EventArgs e)
{
rs.CallCheckBoxChangedEvent(cbl_certificate, cb_certificate, txt_certificate, "Certificate Name");
}
protected void cb_degree_CheckedChanged(object sender, EventArgs e)
{
rs.CallCheckBoxChangedEvent(cbl_degree, cb_degree, txtDegree, "Degree");
}
