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