protected void btnView_Onclick(object sender, EventArgs e) { SqlCommand cmd = new SqlCommand(); con.Close(); con.Open(); DataTable dtDatas = (DataTable)ViewState["dtDatas"]; SqlDataAdapter ad = new SqlDataAdapter("select distinct ef.SID, st.Name, st.IMID from ExamForm ef, Student st where ef.MarkStatus='Approved' and ef.ExamSession='" + lblSessionHiddend.Text.ToString() + "' and ef.Course='" + ddlCourse.SelectedValue.ToString() + "' and ef.Part='" + ddlPart.SelectedValue.ToString() + "' and ef.SID=st.SID", con); DataSet ds = new DataSet(); ad.Fill(ds); GridSID.DataSource = ds; GridSID.DataBind(); for (int i = 0; i < GridSID.Rows.Count; i++) { cmd = new SqlCommand("select CourseID from ExamCurrent where SID='" + GridSID.Rows[i].Cells[0].Text.ToString() + "'", con); string cid = Convert.ToString(cmd.ExecuteScalar()); fillddl(cid, GridSID.Rows[i].Cells[0].Text.ToString()); int k = 0; for (int jj = 0; jj < ddlSyllabus.Items.Count; jj++) { cmd = new SqlCommand("select SID from SExamMarks where SID='" + GridSID.Rows[i].Cells[0].Text.ToString() + "' and SubID='" + ddlSyllabus.Items[jj].Value.ToString() + "' and Status='Pass' and MarkStatus='Submitted'", con); string id = Convert.ToString(cmd.ExecuteScalar()); if (id != "") { k = k + 1; } if (ddlPart.SelectedValue.ToString() == "SectionB") { if (k == 10) { k = ddlSyllabus.Items.Count; } } } if (k >= ddlSyllabus.Items.Count) { // cmd = new SqlCommand("update SExamMarks set MarkStatus='Approved' where SID='" + GridSID.Rows[i].Cells[0].Text.ToString() + "' and Part='" + ddlPart.SelectedValue.ToString() + "'", con); // cmd.ExecuteNonQuery(); DataRow drNewRow = dtDatas.NewRow(); drNewRow["SID"] = GridSID.Rows[i].Cells[0].Text.ToString(); drNewRow["Name"] = GridSID.Rows[i].Cells[1].Text.ToString(); drNewRow["Stream"] = lblHiddendStream.Text.ToString(); drNewRow["Course"] = ddlCourse.SelectedValue.ToString(); drNewRow["Part"] = ddlPart.SelectedValue.ToString(); drNewRow["IMID"] = GridSID.Rows[i].Cells[2].Text.ToString(); dtDatas.Rows.Add(drNewRow); GridExamForms.DataSource = dtDatas; GridExamForms.DataBind(); } } con.Close(); con.Dispose(); btnView.Focus(); }
protected void rbtnNotGenerated_CheckedChanged(object sender, EventArgs e) { if (txtIMID.Text != "") { GridExamForms.DataSource = GetDataSource(); GridExamForms.DataBind(); lblMsg.Text = ""; } else { lblMsg.Text = "Enter IMID"; } if (GridExamForms.Rows.Count > 0) { GridExamForms.Focus(); } else { txtIMID.Focus(); } }
protected void ibtnExportDocAppTableDoc_click(object sender, ImageClickEventArgs e) { GridExamForms.AllowPaging = false; GridExamForms.DataSource = GetDataSource(); GridExamForms.DataBind(); if (GridExamForms.Rows.Count > 0) { Response.Clear(); Response.Buffer = true; Response.AddHeader("content-disposition", "attachment;filename=ExaminationFormRollNumberNotGenerated.doc"); Response.Charset = ""; Response.ContentType = "application/vnd.ms-word "; StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); GridExamForms.RenderControl(hw); Response.Output.Write(sw.ToString()); Response.Flush(); Response.End(); } }
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(); } }
private void BindGridExamForms() { adp = new SqlDataAdapter("select ExamForm.SubID,ExamForm.SubName,ExamForms.Status,ExamForms.City, ExamForms.RollNo from ExamForm inner join ExamForms on ExamForm.SN=ExamForms.SN and ExamForms.SID='" + lblEnrolment.Text.ToString() + "' and ExamForms.ExamSeason='" + lblExamSeasonHidden.Text.ToString() + "' and ExamForms.SN='" + GridExam.SelectedDataKey.Value + "'", con); DataSet ds = new DataSet(); adp.Fill(ds); GridExamForms.DataSource = ds; GridExamForms.DataBind(); }
protected void DeleteRecord(object sender, GridViewDeleteEventArgs e) { con.Open(); string SN = GridExam.DataKeys[e.RowIndex].Value.ToString(); cmd = con.CreateCommand(); SqlTransaction trans; trans = con.BeginTransaction("RangeTrans"); cmd.Connection = con; cmd.Transaction = trans; try { cmd.CommandText = "delete ExamForms where SN='" + SN + "' and Part='" + lblPart.Text + "' and ExamSeason='" + lblExamSeasonHidden.Text.ToString() + "'"; cmd.ExecuteNonQuery(); cmd.CommandText = "delete ExamForm where SN='" + SN + "'"; cmd.ExecuteNonQuery(); if (lblPart.Text == "PartII") { cmd.CommandText = "update ExamCurrent set CourseStatus=@CourseStatus where SId='" + lblEnrolment.Text.ToString() + "'"; cmd.Parameters.AddWithValue("@CourseStatus", "Approved"); } else { cmd.CommandText = "update ExamCurrent set ExamStatus=@ExamStatus where SId='" + lblEnrolment.Text.ToString() + "'"; cmd.Parameters.AddWithValue("@ExamStatus", "Approved"); } cmd.ExecuteNonQuery(); trans.Commit(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "success", "alert('Record Re-Submit successfully !')", true); BindExamGrid(); GridExamForms.DataBind(); pnlDetails.Visible = false; lblEnrolment.Text = ""; txticesn.Text = ""; txticesn.Focus(); } catch (Exception ex) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "success", "alert('Not deleted.!')", true); BindExamGrid(); pnlDetails.Visible = false; lblEnrolment.Text = ""; txticesn.Text = ""; txticesn.Focus(); try { trans.Rollback(); } catch (Exception ex2) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "success", "alert('Not deleted due to transaction rollback fail.!')", true); BindExamGrid(); pnlDetails.Visible = false; BindGridExamForms(); lblEnrolment.Text = ""; txticesn.Text = ""; txticesn.Focus(); } } finally { con.Close(); con.Dispose(); } }