public void bindsem() { try { ds.Clear(); ddlsem.Items.Clear(); // added by Deepali on 5.4.18 string depts = ddldepartment.SelectedItem.Value; if (depts == "All") { depts = getDdlSelectedValue(ddldepartment); } //--------------------------- //ds = d2.BindSem(ddldepartment.SelectedItem.Value, ddlbatch.SelectedItem.Text, ddlcollege.SelectedItem.Value); ds = d2.BindSem(depts, ddlbatch.SelectedItem.Text, ddlcollege.SelectedItem.Value); if (ds.Tables[0].Rows.Count > 0) { string duration = Convert.ToString(ds.Tables[0].Rows[0][0]); if (duration.Trim() != "") { for (int i = 1; i <= Convert.ToInt32(duration); i++) { ddlsem.Items.Add(Convert.ToString(i)); } } } } catch { } }
public void bindsem1() { try { ddlsem1.Items.Clear(); Boolean first_year; first_year = false; int duration = 0; int i = 0; hat.Clear(); string usercode = Session["usercode"].ToString(); string collegecode = Session["collegecode"].ToString(); 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(); } DataSet ds = new DataSet(); if (chksubwise.Checked == true) { string strsql = "select Max(ndurations),first_year_nonsemester from ndegree where college_code=" + collegecode + " group by first_year_nonsemester order by Max(ndurations) "; ds = da.select_method_wo_parameter(strsql, "TExt"); } else { ds = da.BindSem(ddlbranch1.SelectedValue.ToString(), ddlYear1.SelectedValue.ToString(), collegecode); } if (ds.Tables[0].Rows.Count > 0) { first_year = Convert.ToBoolean(Convert.ToString(ds.Tables[0].Rows[0][1]).ToString()); duration = Convert.ToInt32(Convert.ToString(ds.Tables[0].Rows[0][0]).ToString()); for (i = 1; i <= duration; i++) { if (first_year == false) { ddlsem1.Items.Add(i.ToString()); } else if (first_year == true && i != 2) { ddlsem1.Items.Add(i.ToString()); } } } ddlsem1.Items.Insert(0, new System.Web.UI.WebControls.ListItem(" ", "0")); } catch (Exception ex) { lblerr1.Visible = true; lblerr1.Text = ex.ToString(); } }
private void BindSem(string strbranch, string strbatchyear, string collegecode) { try { strbatchyear = "0"; if (ddlBatch.Items.Count > 0) { strbatchyear = ddlBatch.SelectedValue.ToString(); } strbranch = "0"; if (ddlBranch.Items.Count > 0) { strbranch = ddlBranch.SelectedValue.ToString(); } ddlSem.Items.Clear(); Boolean first_year; first_year = false; int duration = 0; int i = 0; ds.Dispose(); ds.Reset(); ds = d2.BindSem(strbranch, strbatchyear, collegecode); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { first_year = Convert.ToBoolean(Convert.ToString(ds.Tables[0].Rows[0][1]).ToString()); duration = Convert.ToInt32(Convert.ToString(ds.Tables[0].Rows[0][0]).ToString()); for (i = 1; i <= duration; i++) { if (first_year == false) { ddlSem.Items.Add(i.ToString()); } else if (first_year == true && i != 2) { ddlSem.Items.Add(i.ToString()); } } } } catch (Exception ex) { lblMainErr.Text = ex.ToString(); } }
public void bindsem() { try { ddlsem.Items.Clear(); ds = d2.BindSem(ddlbranch.SelectedItem.Value, ddlbatch.SelectedItem.Text, Convert.ToString(ddlcollege.SelectedItem.Value)); if (ds.Tables[0].Rows.Count > 0) { string count = Convert.ToString(ds.Tables[0].Rows[0][0]); if (count != "" && count != "0") { for (int co = 1; co <= Convert.ToInt32(count); co++) { ddlsem.Items.Add(Convert.ToString(co)); } } } } catch { } }
public void bindsem() { try { ds.Clear(); ddlsem.Items.Clear(); ds = d2.BindSem(ddldepartment.SelectedItem.Value, ddlbatch.SelectedItem.Text, ddlcollege.SelectedItem.Value); if (ds.Tables[0].Rows.Count > 0) { string duration = Convert.ToString(ds.Tables[0].Rows[0][0]); if (duration.Trim() != "") { for (int i = 1; i <= Convert.ToInt32(duration); i++) { ddlsem.Items.Add(Convert.ToString(i)); } } } } catch { } }
public void BindSem(string strbranch, string strbatchyear, string collegecode) { try { strbatchyear = ddlbatch.Text.ToString(); strbranch = ddlbranch.SelectedValue.ToString(); ddlsemester.Items.Clear(); Boolean first_year; first_year = false; int duration = 0; int i = 0; ds2.Dispose(); ds2.Reset(); ds2 = d2.BindSem(strbranch, strbatchyear, collegecode); if (ds2.Tables[0].Rows.Count > 0) { first_year = Convert.ToBoolean(Convert.ToString(ds2.Tables[0].Rows[0][1]).ToString()); duration = Convert.ToInt32(Convert.ToString(ds2.Tables[0].Rows[0][0]).ToString()); for (i = 1; i <= duration; i++) { if (first_year == false) { ddlsemester.Items.Add(i.ToString()); } else if (first_year == true && i != 2) { ddlsemester.Items.Add(i.ToString()); } } } BindSubjecttest(strbatch, strbranch, strsem, strsec); // Bindtest(strbatch, strbranch, strsem, strsec1); } catch (Exception ex) { } }
public void bindsem1() { try { ddlsem1.Items.Clear(); bool first_year; first_year = false; int duration = 0; int i = 0; 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(); } int inclBatchYrRights = dirAccess.selectScalarInt("select LinkValue from New_InsSettings where LinkName='IncludeBatchRightsInMarkEntry' and college_code ='" + collegecode + "' and user_code ='" + usercode + "'"); if (inclBatchYrRights == 0) { DataSet ds = new DataSet(); ds = da.BindSem(ddlbranch1.SelectedValue.ToString(), ddlYear1.SelectedValue.ToString(), collegecode); if (ds.Tables[0].Rows.Count > 0) { first_year = Convert.ToBoolean(Convert.ToString(ds.Tables[0].Rows[0][1]).ToString()); duration = Convert.ToInt32(Convert.ToString(ds.Tables[0].Rows[0][0]).ToString()); for (i = 1; i <= duration; i++) { if (first_year == false) { ddlsem1.Items.Add(i.ToString()); } else if (first_year == true && i != 2) { ddlsem1.Items.Add(i.ToString()); } } } } else { string selQ = "select distinct Current_Semester from Registration where Batch_Year in (select distinct batch_year from tbl_attendance_rights where user_id='" + usercode + "' and college_code='" + collegecode + "') and college_code = " + collegecode + " and DelFlag='0' and Exam_Flag<>'debar' order by Current_Semester "; DataTable dtSem = dirAccess.selectDataTable(selQ); if (dtSem.Rows.Count > 0) { ddlsem1.DataSource = dtSem; ddlsem1.DataTextField = "Current_Semester"; ddlsem1.DataValueField = "Current_Semester"; ddlsem1.DataBind(); } } ddlsem1.Items.Insert(0, new System.Web.UI.WebControls.ListItem(" ", "0")); } catch (Exception ex) { lblerr1.Visible = true; lblerr1.Text = ex.ToString(); } }