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