public void ExamDate()
{
try
{
cbl_date.Items.Clear();
cb_date.Checked = false;
txt_date.Text = "---Select---";
ds.Clear();
ds = d2.BindBatch();
string Query = "select distinct Convert(varchar(10),e.exam_date,103) as exam_date from CriteriaForInternal ci,Registration r,syllabus_master sm,Exam_type e where ci.syll_code=sm.syll_code and ci.Criteria_no=e.criteria_no and sm.semester=r.Current_Semester and sm.Batch_Year=r.Batch_Year and r.degree_code=sm.degree_code and r.CC='0' and r.DelFlag='0' and r.Exam_Flag<>'debar'";
ds.Clear();
ds = d2.select_method_wo_parameter(Query, "Text");
if (ds.Tables[0].Rows.Count > 0)
{
cbl_date.DataSource = ds;
cbl_date.DataTextField = "exam_date";
cbl_date.DataValueField = "exam_date";
cbl_date.DataBind();
if (cbl_date.Items.Count > 0)
{
for (int i = 0; i < cbl_date.Items.Count; i++)
{
cbl_date.Items[i].Selected = true;
}
txt_date.Text = "Date(" + cbl_date.Items.Count + ")";
cb_date.Checked = true;
}
}
}
catch (Exception ex) { d2.sendErrorMail(ex, collegecode, "InvigilationAlterStaff"); }
}
public void bindhall()
{
try
{
cbl_hall.Items.Clear();
txt_hall.Text = "---Select---";
ds.Clear();
ds = d2.BindBatch();
string Query = "select distinct e.exam_date as exam_date,i.hallNo from CriteriaForInternal ci,Registration r,syllabus_master sm,Exam_type e,internalSeatingArragement i where ci.syll_code=sm.syll_code and ci.Criteria_no=e.criteria_no and sm.semester=r.Current_Semester and sm.Batch_Year=r.Batch_Year and r.degree_code=sm.degree_code and i.examCode=e.exam_code and r.CC='0' and r.DelFlag='0' and r.Exam_Flag<>'debar' ";
ds.Clear();
ds = d2.select_method_wo_parameter(Query, "Text");
if (ds.Tables[0].Rows.Count > 0)
{
cbl_hall.DataSource = ds;
cbl_hall.DataTextField = "hallNo";
cbl_hall.DataValueField = "hallNo";
cbl_hall.DataBind();
if (cbl_hall.Items.Count > 0)
{
for (int i = 0; i < cbl_hall.Items.Count; i++)
{
cbl_hall.Items[i].Selected = true;
}
txt_hall.Text = "Hall(" + cbl_hall.Items.Count + ")";
cb_hall.Checked = true;
}
}
}
catch { }
}
public void bindbatch()
{
try
{
hat.Clear();
ds = d2.BindBatch();
if (ds.Tables[0].Rows.Count > 0)
{
cbl_batch.DataSource = ds;
cbl_batch.DataTextField = "batch_year";
cbl_batch.DataValueField = "batch_year";
cbl_batch.DataBind();
if (cbl_batch.Items.Count > 0)
{
//for (int i = 0; i < cbl_degree.Items.Count; i++)
//{
cbl_batch.Items[0].Selected = true;
//}
txt_batch.Text = lbl_batch.Text + " (" + 1 + ")";
cb_batch.Checked = true;
}
else
{
txt_batch.Text = "--Select--";
cb_batch.Checked = false;
}
}
}
catch
{
}
}
public void BindBatch()
{
try
{
cbl_batch.Items.Clear();
cb_batch.Checked = false;
txt_batch.Text = "--Select--";
string college_cd = rs.GetSelectedItemsValueAsString(Cbl_college);
if (college_cd != "")
{
ds = d2.BindBatch();
if (ds.Tables[0].Rows.Count > 0)
{
cbl_batch.DataSource = ds;
cbl_batch.DataTextField = "batch_year";
cbl_batch.DataValueField = "batch_year";
cbl_batch.DataBind();
}
if (cbl_batch.Items.Count > 0)
{
cbl_batch.Items[0].Selected = true;
txt_batch.Text = "Batch(1)";
}
else
{
txt_batch.Text = "--Select--";
}
}
BindDegree();
}
catch (Exception ex)
{
}
}
public void BindBatch()
{
try
{
chklsbatch.Items.Clear();
chkbatch.Checked = false;
txtbatch.Text = "---Select---";
ds2.Dispose();
ds2.Reset();
ds2 = d2.BindBatch();
if (ds2.Tables[0].Rows.Count > 0)
{
chklsbatch.DataSource = ds2;
chklsbatch.DataTextField = "Batch_year";
chklsbatch.DataValueField = "Batch_year";
chklsbatch.DataBind();
for (int i = 0; i < chklsbatch.Items.Count; i++)
{
chklsbatch.Items[i].Selected = true;
}
txtbatch.Text = "Batch(" + (chklsbatch.Items.Count) + ")";
chkbatch.Checked = true;
}
}
catch (Exception ex)
{
lbl_errmsg.Text = ex.ToString();
lbl_errmsg.Visible = true;
}
}
//------Load Function for the Batch Details-----
public void BindBatch()
{
try
{
ds2.Dispose();
ds2.Reset();
ds2 = d2.BindBatch();
if (ds2.Tables[0].Rows.Count > 0)
{
chklstbatch.DataSource = ds2;
chklstbatch.DataTextField = "Batch_year";
chklstbatch.DataValueField = "Batch_year";
chklstbatch.DataBind();
chklstbatch.SelectedIndex = chklstbatch.Items.Count - 1;
for (int i = 0; i < chklstbatch.Items.Count; i++)
{
chklstbatch.Items[i].Selected = true;
if (chklstbatch.Items[i].Selected == true)
{
count += 1;
}
if (chklstbatch.Items.Count == count)
{
chkbatch.Checked = true;
}
}
}
}
catch (Exception ex)
{
errmsg.Text = "Please Choose Batch";
//errmsg.Visible = true;
}
}
public void bindBtch()
{
try
{
cbl_batch.Items.Clear();
cb_batch.Checked = false;
txt_batch.Text = "---Select---";
ds.Clear();
ds = da.BindBatch();
if (ds.Tables[0].Rows.Count > 0)
{
cbl_batch.DataSource = ds;
cbl_batch.DataTextField = "batch_year";
cbl_batch.DataValueField = "batch_year";
cbl_batch.DataBind();
if (cbl_batch.Items.Count > 0)
{
for (int i = 0; i < cbl_batch.Items.Count; i++)
{
cbl_batch.Items[i].Selected = true;
}
txt_batch.Text = "Batch(" + cbl_batch.Items.Count + ")";
cb_batch.Checked = true;
}
}
}
catch { }
}
public void bindbatch()
{
try
{
gview.Visible = false;
cbl_batch.Items.Clear();
hat.Clear();
ds = d2.BindBatch();
if (ds.Tables[0].Rows.Count > 0)
{
cbl_batch.DataSource = ds;
cbl_batch.DataTextField = "batch_year";
cbl_batch.DataValueField = "batch_year";
cbl_batch.DataBind();
//ddl_batch1.SelectedIndex = 3;
if (cbl_batch.Items.Count > 0)
{
for (int i = 0; i < cbl_batch.Items.Count; i++)
{
cbl_batch.Items[0].Selected = true;
}
txt_batch.Text = "Batch(" + 1 + ")";
}
else
{
txt_batch.Text = "--Select--";
cb_batch.Checked = false;
}
}
}
catch
{
}
}
public void BindBatch()
{
try
{
ds.Dispose();
ds.Reset();
ds = da.BindBatch();
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
chklsbatch.DataSource = ds;
chklsbatch.DataTextField = "Batch_year";
chklsbatch.DataValueField = "Batch_year";
chklsbatch.DataBind();
chklsbatch.SelectedIndex = chklsbatch.Items.Count - 1;
for (int i = 0; i < chklsbatch.Items.Count; i++)
{
chklsbatch.Items[i].Selected = true;
if (chklsbatch.Items[i].Selected == true)
{
count += 1;
}
if (chklsbatch.Items.Count == count)
{
chkbatch.Checked = true;
}
}
if (chkbatch.Checked == true)
{
for (int i = 0; i < chklsbatch.Items.Count; i++)
{
chklsbatch.Items[i].Selected = true;
txtbatch.Text = "Batch(" + (chklsbatch.Items.Count) + ")";
}
}
else
{
for (int i = 0; i < chklsbatch.Items.Count; i++)
{
chklsbatch.Items[i].Selected = false;
txtbatch.Text = "---Select---";
}
}
}
}
catch (Exception ex)
{
}
}
public void BindBatch()
{
try
{
ddlbatch.Items.Clear();
ds = d2.BindBatch();
if (ds.Tables[0].Rows.Count > 0)
{
ddlbatch.DataSource = ds;
ddlbatch.DataTextField = "batch_year";
ddlbatch.DataValueField = "batch_year";
ddlbatch.DataBind();
}
}
catch { }
}
public void bindbatch()
{
try
{
ds = d2.BindBatch();
if (ds.Tables[0].Rows.Count > 0)
{
ddl_batch.DataSource = ds;
ddl_batch.DataTextField = "batch_year";
ddl_batch.DataValueField = "batch_year";
ddl_batch.DataBind();
degree();
}
}
catch
{
}
}
public void BindBatch()
{
try
{
ds2.Dispose();
ds2.Reset();
ds2 = d2.BindBatch();
if (ds2.Tables[0].Rows.Count > 0)
{
ddlbatch.DataSource = ds2;
ddlbatch.DataTextField = "Batch_year";
ddlbatch.DataValueField = "Batch_year";
ddlbatch.DataBind();
}
}
catch (Exception ex)
{
}
}
public void bindBtch()
{
try
{
ddl_batch.Items.Clear();
ds.Clear();
ds = d2.BindBatch();
if (ds.Tables[0].Rows.Count > 0)
{
ddl_batch.DataSource = ds;
ddl_batch.DataTextField = "batch_year";
ddl_batch.DataValueField = "batch_year";
ddl_batch.DataBind();
}
binddeg();
binddept();
}
catch (Exception ex) { }
}
public void BindBatch()
{
try
{
ddlbatch.Items.Clear();
ds = d2.BindBatch();
if (ds.Tables[0].Rows.Count > 0)
{
ddlbatch.DataSource = ds;
ddlbatch.DataTextField = "Batch_year";
ddlbatch.DataValueField = "Batch_year";
ddlbatch.DataBind();
ddlbatch.SelectedIndex = ddlbatch.Items.Count - 1;
}
}
catch (Exception ex)
{
}
}
public void loadbatch()
{
try
{
ddlbatch.Items.Clear();
ds = d2.BindBatch();
if (ds.Tables[0].Rows.Count > 0)
{
ddlbatch.Enabled = true;
ddlbatch.DataSource = ds;
ddlbatch.DataTextField = "batch_year";
ddlbatch.DataBind();
}
}
catch (Exception ex)
{
errmsg.Visible = true;
errmsg.Text = ex.ToString();
}
}
public void bindbatch()
{
try
{
ddlbatch.Items.Clear();
ds = da.BindBatch();
int count = ds.Tables[0].Rows.Count;
if (count > 0)
{
ddlbatch.DataSource = ds;
ddlbatch.DataTextField = "batch_year";
ddlbatch.DataValueField = "batch_year";
ddlbatch.DataBind();
}
}
catch (Exception ex)
{
lblerror.Text = ex.ToString();
lblerror.Visible = true;
}
}
public void BindBatch()
{
try
{
ds2.Dispose();
ds2.Reset();
ds2 = d2.BindBatch();
if (ds2.Tables[0].Rows.Count > 0)
{
ddlbatch.DataSource = ds2;
ddlbatch.DataTextField = "Batch_year";
ddlbatch.DataValueField = "Batch_year";
ddlbatch.DataBind();
ddlbatch.SelectedIndex = ddlbatch.Items.Count - 1;
}
}
catch (Exception ex)
{
norecordlbl.Text = ex.ToString();
}
}
public void BindBatch()
{
try
{
cbl_batch.Items.Clear();
cb_batch.Checked = false;
txt_batch.Text = "--Select--";
string college_cd = rs.GetSelectedItemsValueAsString(Cbl_college);
if (college_cd != "")
{
ds = d2.BindBatch();
if (ds.Tables[0].Rows.Count > 0)
{
cbl_batch.DataSource = ds;
cbl_batch.DataTextField = "batch_year";
cbl_batch.DataValueField = "batch_year";
cbl_batch.DataBind();
}
if (cbl_batch.Items.Count > 0)
{
//for (int row = 0; row < cbl_batch.Items.Count; row++)
//{
cbl_batch.Items[0].Selected = true;
//cb_batch.Checked = true;
//}
txt_batch.Text = "Batch(1)";
}
else
{
txt_batch.Text = "--Select--";
}
}
BindDegree();
}
catch (Exception ex)
{
d2.sendErrorMail(ex, collegecode1, "Feedback_anonymousisgender");
}
}
public void bindbatch()
{
try
{
ds.Dispose();
ds.Reset();
ds = d2.BindBatch();
if (ds.Tables[0].Rows.Count > 0)
{
ddlbatch.DataSource = ds;
ddlbatch.DataTextField = "Batch_year";
ddlbatch.DataValueField = "Batch_year";
ddlbatch.DataBind();
}
lblrptname.Visible = false;
txtexcelname.Visible = false;
btnxl.Visible = false;
btnmasterprint.Visible = false;
GridView1.Visible = false;
}
catch
{
}
}
public void BindBatch()
{
try
{
chklsbatch.Items.Clear();
chkbatch.Checked = false;
txtbatch.Text = "---Select---";
ds2.Dispose();
ds2.Reset();
ds2 = d2.BindBatch();
if (ds2.Tables[0].Rows.Count > 0)
{
chklsbatch.DataSource = ds2;
chklsbatch.DataTextField = "Batch_year";
chklsbatch.DataValueField = "Batch_year";
chklsbatch.DataBind();
chklsbatch.SelectedIndex = chklsbatch.Items.Count - 1;
txtbatch.Text = "Batch (1)";
}
}
catch
{
}
}
