// Branch load function-------
public void BindBranch(string singleuser, string group_user, string course_id, string collegecode, string usercode)
{
try
{
for (int i = 0; i < chklstdegree.Items.Count; i++)
{
if (chklstdegree.Items[i].Selected == true)
{
if (course_id == "")
{
course_id = "" + chklstdegree.Items[i].Value.ToString() + "";
}
else
{
course_id = course_id + "," + "" + chklstdegree.Items[i].Value.ToString() + "";
}
}
}
//course_id = chklstdegree.SelectedValue.ToString();
chklstbranch.Items.Clear();
if (group_user.Contains(';'))
{
string[] group_semi = group_user.Split(';');
group_user = group_semi[0].ToString();
}
ds2.Dispose();
ds2.Reset();
ds2 = d2.BindBranchMultiple(singleuser, group_user, course_id, collegecode, usercode);
if (ds2.Tables[0].Rows.Count > 0)
{
chklstbranch.DataSource = ds2;
chklstbranch.DataTextField = "dept_name";
chklstbranch.DataValueField = "degree_code";
chklstbranch.DataBind();
chklstbranch.Items[0].Selected = true;
for (int i = 0; i < chklstbranch.Items.Count; i++)
{
chklstbranch.Items[i].Selected = true;
if (chklstbranch.Items[i].Selected == true)
{
count2 += 1;
}
if (chklstbranch.Items.Count == count2)
{
chkbranch.Checked = true;
}
}
}
}
catch (Exception ex)
{
errmsg.Text = "Please Select the Degree";
}
}
public void binddept()
{
try
{
cbl_dept.Items.Clear();
cb_dept.Checked = false;
txt_dept.Text = "---Select---";
string degree = "";
for (int i = 0; i < cbl_degree.Items.Count; i++)
{
if (cbl_degree.Items[i].Selected == true)
{
if (degree == "")
{
degree = Convert.ToString(cbl_degree.Items[i].Value);
}
else
{
degree += "," + Convert.ToString(cbl_degree.Items[i].Value);
}
}
}
string collegecode = ddlcollege.SelectedItem.Value.ToString();
if (degree != "")
{
ds.Clear();
ds = d2.BindBranchMultiple(singleuser, group_user, degree, collegecode, usercode);
if (ds.Tables[0].Rows.Count > 0)
{
cbl_dept.DataSource = ds;
cbl_dept.DataTextField = "dept_name";
cbl_dept.DataValueField = "degree_code";
cbl_dept.DataBind();
if (cbl_dept.Items.Count > 0)
{
for (int i = 0; i < cbl_dept.Items.Count; i++)
{
cbl_dept.Items[i].Selected = true;
}
txt_dept.Text = lbldept.Text + "(" + cbl_dept.Items.Count + ")";
cb_dept.Checked = true;
}
}
}
}
catch { }
}
public void bindbranch()
{
dicParameter.Clear();
ddlbranch.Items.Clear();
usercode = Session["usercode"].ToString();
collegecode = Convert.ToString(ddlCollege.SelectedValue);;
singleuser = Session["single_user"].ToString();
group_user = Session["group_code"].ToString();
if (group_user.Contains(';'))
{
string[] group_semi = group_user.Split(';');
group_user = group_semi[0].ToString();
}
//dicParameter.Add("single_user", singleuser);
//dicParameter.Add("group_code", group_user);
//dicParameter.Add("course_id", ddldegree.SelectedValue);
//dicParameter.Add("college_code", collegecode);
//dicParameter.Add("user_code", usercode);
ds.Dispose();
ds.Reset();
ds = da.BindBranchMultiple(singleuser, group_user, ddldegree.SelectedValue.ToString(), collegecode, usercode);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
ddlbranch.DataSource = ds;
ddlbranch.DataTextField = "dept_name";
ddlbranch.DataValueField = "degree_code";
ddlbranch.DataBind();
}
}
public void bindbranch1()
{
try
{
cbl_Dept.Items.Clear();
hat.Clear();
string usercode = Session["usercode"].ToString();
string collegecode = Convert.ToString(ddlCollege.SelectedValue);
string singleuser = Session["single_user"].ToString();
string group_user = Session["group_code"].ToString();
if (group_user.Contains(';'))
{
string[] group_semi = group_user.Split(';');
group_user = group_semi[0].ToString();
}
string degree = "";
for (int i = 0; i < cbl_Degree.Items.Count; i++)
{
if (cbl_Degree.Items[i].Selected == true)
{
if (degree == "")
{
degree = Convert.ToString(cbl_Degree.Items[i].Value);
}
else
{
degree += "," + Convert.ToString(cbl_Degree.Items[i].Value);
}
}
}
ds = da.BindBranchMultiple(singleuser, group_user, degree, collegecode, usercode);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
int count2 = ds.Tables[0].Rows.Count;
if (count2 > 0)
{
cbl_Dept.DataSource = ds;
cbl_Dept.DataTextField = "dept_name";
cbl_Dept.DataValueField = "degree_code";
cbl_Dept.DataBind();
if (cbl_Dept.Items.Count > 0)
{
for (int i = 0; i < cbl_Dept.Items.Count; i++)
{
cbl_Dept.Items[i].Selected = true;
}
txt_Dept.Text = "Department(" + cbl_Dept.Items.Count + ")";
cb_Dept.Checked = true;
}
}
}
// cbl_Dept.Items.Insert(0, new System.Web.UI.WebControls.ListItem(" ", "0"));
}
catch (Exception ex)
{
}
}
public void BindBranchMultiple()
{
try
{
txtbranch.Text = "---Select---";
chkbranch.Checked = false;
chklstbranch.Items.Clear();
for (int i = 0; i < chklstdegree.Items.Count; i++)
{
if (chklstdegree.Items[i].Selected == true)
{
if (course_id == "")
{
course_id = "" + chklstdegree.Items[i].Value.ToString() + "";
}
else
{
course_id = course_id + "," + "" + chklstdegree.Items[i].Value.ToString() + "";
}
}
}
if (group_user.Contains(";"))
{
string[] group_semi = group_user.Split(';');
group_user = group_semi[0].ToString();
}
collegecode = ddlclg.SelectedValue.ToString();
ds2.Dispose();
ds2.Reset();
ds2 = d2.BindBranchMultiple(singleuser, group_user, course_id, collegecode, usercode);
if (ds2.Tables[0].Rows.Count > 0)
{
chklstbranch.DataSource = ds2;
chklstbranch.DataTextField = "dept_name";
chklstbranch.DataValueField = "degree_code";
chklstbranch.DataBind();
chklstbranch.Items[0].Selected = true;
for (int i = 0; i < chklstbranch.Items.Count; i++)
{
chklstbranch.Items[i].Selected = true;
}
chkbranch.Checked = true;
txtbranch.Text = "Branch(" + (chklstbranch.Items.Count) + ")";
}
}
catch (Exception ex)
{
lbl_errmsg.Text = ex.ToString();
lbl_errmsg.Visible = true;
}
}
public void bindbranch(string branch)
{
try
{
//branch = Convert.ToString(ddl_degree.SelectedItem.Value);
string rights = "";
if (group_user.Contains(";"))
{
string[] group_semi = group_user.Split(';');
group_user = group_semi[0].ToString();
}
if ((group_user.ToString().Trim() != "") && (group_user.Trim() != "0") && (group_user.ToString().Trim() != "-1"))
{
rights = "and group_code='" + group_user + "'";
}
else
{
rights = " and user_code='" + usercode + "'";
}
cb_branch.Checked = false;
string commname = "";
//if (branch != "")
//{
// commname = "select distinct degree.degree_code,department.dept_name,degree.Acronym from degree,department,course,deptprivilages where course.course_id=degree.course_id and department.dept_code=degree.dept_code and course.college_code = degree.college_code and department.college_code = degree.college_code and degree.course_id in('" + branch + "') and deptprivilages.Degree_code=degree.Degree_code and degree.college_code='" + ddlcollege.SelectedItem.Value + "' " + rights + " ";
//}
//else
//{
// commname = " select distinct degree.degree_code,department.dept_name,degree.Acronym from degree,department,course,deptprivilages where course.course_id=degree.course_id and department.dept_code=degree.dept_code and course.college_code = degree.college_code and department.college_code = degree.college_code and deptprivilages.Degree_code=degree.Degree_code and degree.college_code='" + ddlcollege.SelectedItem.Value + "' " + rights + "";
//}
ds.Clear();
cbl_branch.Items.Clear();
// ds = d2.select_method(commname, hat, "Text");
ds.Clear();
ds = d2.BindBranchMultiple(singleuser, group_user, branch, collegecode, usercode);
if (ds.Tables[0].Rows.Count > 0)
{
cbl_branch.DataSource = ds;
cbl_branch.DataTextField = "dept_name";
cbl_branch.DataValueField = "degree_code";
cbl_branch.DataBind();
for (int i = 0; i < cbl_branch.Items.Count; i++)
{
cbl_branch.Items[i].Selected = true;
}
txt_branch.Text = lbl_branch.Text + "(" + cbl_branch.Items.Count + ")";
cb_branch.Checked = true;
}
}
catch (Exception ex) { }
}
private void BindBranch(string singleuser, string group_user, string course_id, string collegecode, string usercode)
{
try
{
course_id = "0";
string Batch = "0";
string Branch = "0";
string Sem = "0";
if (ddlDegree.Items.Count > 0)
{
course_id = Convert.ToString(ddlDegree.SelectedItem.Value);
}
ddlBranch.Items.Clear();
if (group_user.Contains(';'))
{
string[] group_semi = group_user.Split(';');
group_user = group_semi[0].ToString();
}
ds.Dispose();
ds.Reset();
ds = d2.BindBranchMultiple(singleuser, group_user, course_id, collegecode, usercode);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
ddlBranch.DataSource = ds;
ddlBranch.DataTextField = "dept_name";
ddlBranch.DataValueField = "degree_code";
ddlBranch.DataBind();
}
if (ddlBatch.Items.Count > 0)
{
Batch = Convert.ToString(ddlBatch.SelectedItem.Value);
}
if (ddlBranch.Items.Count > 0)
{
Branch = Convert.ToString(ddlBranch.SelectedItem.Value);
}
BindSem(Branch, Batch, collegecode);
if (ddlSem.Items.Count > 0)
{
Sem = Convert.ToString(ddlSem.SelectedItem.Value);
}
BindSectionDetail(Batch, Branch, Sem, collegecode);
}
catch (Exception ex)
{
lblMainErr.Text = "Please Select the Degree";
}
}
public void bindbranch()
{
try
{
string degreecode = "";
txt_branch.Text = "---Select---";
chk_branch.Checked = false;
chklst_branch.Items.Clear();
for (int h = 0; h < Chklst_degree.Items.Count; h++)
{
if (Chklst_degree.Items[h].Selected == true)
{
if (degreecode == "")
{
degreecode = Chklst_degree.Items[h].Value;
}
else
{
degreecode = degreecode + ',' + Chklst_degree.Items[h].Value;
}
}
}
if (degreecode.Trim() != "")
{
ds.Clear();
ds = da.BindBranchMultiple(Session["single_user"].ToString(), Session["group_code"].ToString(), degreecode, collegecode = Session["collegecode"].ToString(), Session["usercode"].ToString());
if (ds.Tables[0].Rows.Count > 0)
{
chklst_branch.DataSource = ds;
chklst_branch.DataTextField = "dept_name";
chklst_branch.DataValueField = "degree_code";
chklst_branch.DataBind();
for (int h = 0; h < chklst_branch.Items.Count; h++)
{
chklst_branch.Items[h].Selected = true;
}
txt_branch.Text = "Branch(" + (chklst_branch.Items.Count) + ")";
chk_branch.Checked = true;
}
}
}
catch (Exception ex)
{
lbl_err.Visible = true;
lbl_err.Text = ex.ToString();
}
}
public void binddept()
{
try
{
ddl_dept.Items.Clear();
degree = "";
degree = Convert.ToString(ddl_degree.SelectedValue.ToString());
if (degree != "")
{
ds.Clear();
ds = d2.BindBranchMultiple(singleuser, group_user, degree, collegecode1, usercode);
if (ds.Tables[0].Rows.Count > 0)
{
ddl_dept.DataSource = ds;
ddl_dept.DataTextField = "dept_name";
ddl_dept.DataValueField = "degree_code";
ddl_dept.DataBind();
}
}
}
catch { }
}
public void binddept()
{
try
{
cbl_dept.Items.Clear();
cb_dept.Checked = false;
txt_dept.Text = "---Select---";
string batch = "";
batch = getCblSelectedText(cbl_batch);
string degree = "";
degree = "'" + getCblSelectedValue(cbl_degree) + "'";
string collegecode = ddlcollegename.SelectedItem.Value.ToString();
if (batch != "" && degree != "")
{
ds.Clear();
ds = d2.BindBranchMultiple(singleuser, group_user, degree, collegecode, usercode);
if (ds.Tables[0].Rows.Count > 0)
{
cbl_dept.DataSource = ds;
cbl_dept.DataTextField = "dept_name";
cbl_dept.DataValueField = "degree_code";
cbl_dept.DataBind();
if (cbl_dept.Items.Count > 0)
{
for (int i = 0; i < cbl_dept.Items.Count; i++)
{
cbl_dept.Items[i].Selected = true;
}
txt_dept.Text = lbldept.Text + "(" + cbl_dept.Items.Count + ")";
cb_dept.Checked = true;
}
}
}
}
catch { }
}
public void BindBranchMultiple(string singleuser, string group_user, string collegecode, string usercode)
{
try
{
txtbranch.Text = "---Select---";
selectcount = 0;
string course_id = "";
for (int i = 0; i < chklsdegree.Items.Count; i++)
{
if (chklsdegree.Items[i].Selected == true)
{
if (course_id == "")
{
course_id = "" + chklsdegree.Items[i].Value.ToString() + "";
}
else
{
course_id = course_id + "," + "" + chklsdegree.Items[i].Value.ToString() + "";
}
}
}
chklsbranch.Items.Clear();
if (course_id != "")
{
if (group_user.Contains(';'))
{
string[] group_semi = group_user.Split(';');
group_user = group_semi[0].ToString();
}
ds.Dispose();
ds.Reset();
collegecode = ddlcollege.SelectedValue.ToString();
ds = da.BindBranchMultiple(singleuser, group_user, course_id, collegecode, usercode);
if (ds.Tables[0].Rows.Count > 0)
{
chklsbranch.DataSource = ds;
chklsbranch.DataTextField = "dept_name";
chklsbranch.DataValueField = "degree_code";
chklsbranch.DataBind();
chklsbranch.Items[0].Selected = true;
for (int i = 0; i < chklsbranch.Items.Count; i++)
{
chklsbranch.Items[i].Selected = true;
if (chklsbranch.Items[i].Selected == true)
{
selectcount += 1;
}
if (chklsbranch.Items.Count == selectcount)
{
chkbranch.Checked = true;
}
}
}
BindSectionDetail();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void BindBranchMultiple(string singleuser, string group_user, string course_id, string collegecode, string usercode)
{
try
{
count = 0;
collegecode = Session["collegecode"].ToString();
for (int i = 0; i < chklstdegree.Items.Count; i++)
{
if (chklstdegree.Items[i].Selected == true)
{
if (course_id == "")
{
course_id = "" + chklstdegree.Items[i].Value.ToString() + "";
}
else
{
course_id = course_id + "," + "" + chklstdegree.Items[i].Value.ToString() + "";
}
}
}
chklstbranch.Items.Clear();
if (group_user.Contains(';'))
{
string[] group_semi = group_user.Split(';');
group_user = group_semi[0].ToString();
}
ds.Dispose();
ds.Reset();
if (course_id.Trim() != "")
{
ds = da.BindBranchMultiple(singleuser, group_user, course_id, collegecode, usercode);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
chklstbranch.DataSource = ds;
chklstbranch.DataTextField = "dept_name";
chklstbranch.DataValueField = "degree_code";
chklstbranch.DataBind();
chklstbranch.Items[0].Selected = true;
for (int i = 0; i < chklstbranch.Items.Count; i++)
{
chklstbranch.Items[i].Selected = true;
if (chklstbranch.Items[i].Selected == true)
{
count += 1;
}
if (chklstbranch.Items.Count == count)
{
chkbranch.Checked = true;
}
}
if (chkbranch.Checked == true)
{
for (int i = 0; i < chklstbranch.Items.Count; i++)
{
chklstbranch.Items[i].Selected = true;
txtbranch.Text = "Branch(" + (chklstbranch.Items.Count) + ")";
}
}
else
{
for (int i = 0; i < chklstbranch.Items.Count; i++)
{
chkbranch.Checked = false;
chklstbranch.Items[i].Selected = false;
txtbranch.Text = "---Select---";
}
}
}
}
else
{
txtbranch.Text = "---Select---";
chklstbranch.Items.Clear();
}
}
catch (Exception ex)
{
}
}