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();
}
}
