private void BindExamGrid()
{
adp = new SqlDataAdapter("select SN,SID,IMID,Course,Part,City from ExamForms where SID='" + txticesn.Text.ToString() + "' and ExamSeason='" + lblExamSeasonHidden.Text.ToString() + "'", con);
DataTable dt = new DataTable();
adp.Fill(dt);
GridExam.DataSource = dt;
GridExam.DataBind();
}
private void ok()
{
lblExceptionOK.Text = "";
try
{
con.Close(); con.Open();
int i = 0;
SqlCommand cmd = new SqlCommand();
cmd = new SqlCommand("select SID,Part from ExamForms where SID='" + txticesn.Text.ToString() + "' and ExamSeason='" + lblExamSeasonHidden.Text.ToString() + "'", con);
string apno = "", Part = "";
SqlDataReader reader;
reader = cmd.ExecuteReader();
if (reader.Read())
{
apno = reader["SID"].ToString(); lblPart.Text = reader["Part"].ToString();
}
reader.Close();
if (apno != "")
{
lblEnrolment.Text = apno.ToString();
apno = "1";
}
else
{
string sn = txticesn.Text.ToString();
cmd = new SqlCommand("select Enrolment,Part from AppRecord where Exam= 'E" + sn.ToString() + "' and Session='" + lblExamSeasonHidden.Text.ToString() + "'", con);
reader = cmd.ExecuteReader();
if (reader.Read())
{
apno = reader["Enrolment"].ToString(); Part = reader["Part"].ToString();
}
reader.Close();
if (apno != "")
{
lblEnrolment.Text = apno.ToString();
apno = "2";
cmd = new SqlCommand("select SN from ExamForms where SID='" + lblEnrolment.Text.ToString() + "' and Part='" + Part.ToString() + "' and ExamSeason='" + lblExamSeasonHidden.Text.ToString() + "'", con);
string chk = Convert.ToString(cmd.ExecuteScalar());
if (chk != "")
{
lblSN.Text = chk.ToString();
}
else
{
}
}
else
{
lblExceptionOK.Text = "Record Not Found !"; lblName.Text = ""; lblCourse.Text = ""; lblIMID.Text = ""; BindExamGrid(); GridExamForms.DataBind(); pnlDetails.Visible = false;
}
if (apno == "2")
{
SqlCommand cmdg = new SqlCommand("select * from AppRecord where Exam ='E" + sn + "' and Session='" + lblExamSeasonHidden.Text.ToString() + "'", con);
SqlDataReader sdr;
sdr = cmdg.ExecuteReader();
while (sdr.Read())
{
lblIMID.Text = sdr["IMID"].ToString();
lblName.Text = sdr["Name"].ToString() + " s/o " + sdr["FName"].ToString();
lblCourse.Text = sdr["Stream"].ToString() + ", " + sdr["Course"].ToString();
lblPart.Text = sdr["Part"].ToString();
lblIMID.Text = "IMID: " + sdr["IMID"].ToString();
lblEnrolment.Text = sdr["Enrolment"].ToString();
if (lblEnrolment.Text == sdr["AppNo"].ToString())
{
lblTempEnrol.Text = "[TEMP]";
}
else
{
lblTempEnrol.Text = "";
}
lblExceptionOK.Text = "";
}
sdr.Close(); BindExamGrid(); GridExam.Focus();
sdr.Dispose();
}
}
if (apno == "1")
{
cmd = new SqlCommand("select * from ExamForms where SID='" + txticesn.Text.ToString() + "' and Part='" + lblPart.Text.ToString() + "' and ExamSeason='" + lblExamSeasonHidden.Text.ToString() + "'", con);
reader = cmd.ExecuteReader();
while (reader.Read())
{
lblName.Text = "";
lblCourse.Text = reader["Course"].ToString() + "- " + reader["Part"].ToString();
lblPart.Text = reader["Part"].ToString();
lblIMID.Text = "IMID: " + reader["IMID"].ToString();
lblEnrolment.Text = reader["SID"].ToString();
lblSN.Text = reader["SN"].ToString();
}
reader.Close(); BindExamGrid(); GridExam.Focus();
reader.Dispose();
}
}
catch (SqlException ex) { lblExceptionOK.Text = ex.ToString(); }
catch (FormatException ex) { lblExceptionOK.Text = ex.ToString(); }
finally { con.Close(); con.Dispose(); }
}
protected void txtSID_TextChanged(object sender, EventArgs e)
{
if (rbtnMembership.Checked == true && txtSID.Text.ToString().Contains("A") == true)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "success", "alert('Please Insert Correct Membership No')", true);
}
else if (rbtnSerailNo.Checked == true && txtSID.Text.ToString().Contains("A") != true)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "success", "alert('Please Insert Correct Serial No.')", true);
}
else
{
tblApps.Visible = true;
con.Close(); con.Open();
cmd = new SqlCommand();
cmd.Connection = con;
SqlDataReader reader;
fillResult(txtSID.Text.ToString(), con);
//if (rbtnMembership.Checked == true)
// cmd.CommandText = "select count(Enrolment) from AppRecord where Enrolment='" + txtSID.Text + "' and Session='" + lblSeasonHidden.Text.ToString() + "' and (FormType like '%Exam%') ";
//else
// cmd.CommandText = "select count(Enrolment) from AppRecord where Sid='" + txtSID.Text + "' and Session='" + lblSeasonHidden.Text.ToString() + "' and (FormType like '%Exam%') ";
//cmd.Connection = con;
//lblExamCount.Text = cmd.ExecuteScalar().ToString();
if (rbtnMembership.Checked == true)
{
cmd.CommandText = "select * from AppRecord where Enrolment='" + txtSID.Text + "' and Session='" + lblSeasonHidden.Text.ToString() + "' and (FormType like '%Admission%') ";
}
else
{
cmd.CommandText = "select * from AppRecord where Sid='" + txtSID.Text + "' and Session='" + lblSeasonHidden.Text.ToString() + "' and (FormType like '%Admission%') ";
}
cmd.Connection = con;
reader = cmd.ExecuteReader();
if (reader.Read())
{
if (reader["Status"].ToString() == "NotApproved")
{
lblApplication.Text = "NotApproved";
}
else
{
lblApplication.Text = "Approved";
}
lblExamSerialNo.Text = reader["Exam"].ToString();
lblITISerialNo.Text = reader["ITI"].ToString();
lblName.Text = reader["Name"].ToString();
lblFatherName.Text = reader["FName"].ToString();
ddlCourse.Enabled = true; ddlPart.Enabled = true; btnUpdate.Enabled = true;
}
else
{
lblApplication.Text = "Application Not Found";
}
reader.Close();
if (rbtnNewAdmission.Checked == true || rbtnNewAdmissiontoOld.Checked == true)
{
cmd.CommandText = "select * from Student where SID='" + txtSID.Text.ToString() + "' and Session='" + lblSeasonHidden.Text.ToString() + "'";
}
else
{
cmd.CommandText = "select * from Student where SID='" + txtSID.Text.ToString() + "'";
}
reader = cmd.ExecuteReader();
if (reader.Read())
{
lblCourseAdmisison.Text = reader["Course"].ToString();
lblPartAdmission.Text = reader["Part"].ToString();
lblAdmissionStatus.Text = reader["Status"].ToString();
lblName.Text = reader["Name"].ToString();
lblFatherName.Text = reader["FName"].ToString();
}
else
{
lblAdmissionStatus.Text = "NotSubmitted";
}
reader.Close();
cmd = new SqlCommand("select * from ExamCurrent where sid='" + txtSID.Text.ToString() + "'", con);
reader = cmd.ExecuteReader();
if (reader.Read())
{
lblExamFormStatus.Text = reader["ExamStatus"].ToString();
lblCourseCurrent.Text = reader["Course"].ToString();
lblPartCurrent.Text = reader["Part"].ToString();
txtRemarks.Text = reader["CourseRemarks"].ToString();
lblEnrolment.Text = reader["IMID"].ToString();
ddlCourse.SelectedValue = lblCourseCurrent.Text;
ddlPart.SelectedValue = lblPartCurrent.Text;
ddlCourseStatus.SelectedValue = reader["CourseStatus"].ToString();
ddlCourse.Enabled = true; ddlPart.Enabled = true; btnUpdate.Enabled = true;
lblException.Text = "";
btnUpdate.Enabled = true;
}
else
{
lblException.Text = "Membership Not Found.";
}
reader.Close(); reader.Dispose();
if (ddlCourseStatus.SelectedValue == "Promotted" || ddlCourseStatus.SelectedValue == "Submitted")
{
lblExamCount.Text = "2";
}
if (lblExamFormStatus.Text == "Filled")
{
pnlExamForm.Visible = true;
SqlDataAdapter ad = new SqlDataAdapter("select Course,Part,Status,ExamSeason,IMID,CenterCode,RollNo,City,City2,Remarks from ExamForms where SID='" + txtSID.Text.ToString() + "' and ExamSeason='" + lblSeasonHidden.Text.ToString() + "'", con);
DataTable dt = new DataTable();
ad.Fill(dt);
GridExam.DataSource = dt;
GridExam.DataBind();
}
lblITIFormStatus.Text = ITIForm();
chkAmount();
chkAdditionalPaper();
con.Close(); con.Dispose();
}
txtSID.Focus();
}
private void clear()
{
txtSID.Text = ""; lblName.Text = ""; lblFatherName.Text = ""; GridExam.DataSource = null; GridExam.DataBind();
lblApplication.Text = ""; lblAdmissionStatus.Text = ""; lblExamFormStatus.Text = ""; lblITIFormStatus.Text = ""; lblExamSerialNo.Text = ""; lblITISerialNo.Text = "";
lblPartICount.Text = "0"; lblPartIICount.Text = "0"; lblSectionACount.Text = "0"; lblSectionBCount.Text = "0"; lblOldName.Text = ""; lblOldFatherName.Text = ""; lblOldPart.Text = ""; lblOldCourse.Text = ""; lblOldCourseStatus.Text = ""; lblOldExamStatus.Text = ""; lblOldCompositeStatus.Text = ""; lblOldDOB.Text = "";
lblExamCount.Text = "0";
pnlExamForm.Visible = false; tblApps.Visible = false;
}
