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