// 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) { } }