protected void btnApprove_Click(object sender, EventArgs e) { lblCancelSuccessMSG.Text = ""; lngRecordId = GetRecordId(); acnt = GetApprovalCount(); HttpClient HClient = new HttpClient(); HClient.BaseAddress = new Uri(DataAcces.Url); HClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); Pl_SubmitZeroLevel pl = new Pl_SubmitZeroLevel(); pl.Ind = 2; pl.ApplicationID = Convert.ToInt32(ApplicatioID); pl.UserID = Convert.ToInt32(Session["UserId"]); pl.EntryByIP = (IpAddress = GetIpAddress()); pl.UserTypeId = Convert.ToInt32(Session["UserTypeId"]); pl.recordId = lngRecordId; pl.acnt = acnt; pl.DocType = DocTypeID; pl.Remarks = txtRemark.Text; var uri = "api/SecondLevel/PostApprovalRecord"; var response = HClient.PostAsJsonAsync(uri, pl).Result; if (response.IsSuccessStatusCode) { var getdata = response.Content.ReadAsAsync <IEnumerable <PL_SecondLevel> >().Result; if (getdata != null) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Notify", "alert('Data Submitted.');window.location='FrmZeroLevel.aspx';", true); } getdata = null; } response = null; uri = null; }
void GetCancelApplicationList() { HttpClient HClient = new HttpClient(); HClient.BaseAddress = new Uri(DataAcces.Url); HClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); Pl_SubmitZeroLevel pl = new Pl_SubmitZeroLevel(); pl.Ind = 52; pl.UserID = Convert.ToInt32(Session["UserId"]); pl.CancelInd = 1; var uri = "api/SecondLevel/CancelApplicationList"; var response = HClient.PostAsJsonAsync(uri, pl).Result; if (response.IsSuccessStatusCode) { var getCanceldata = response.Content.ReadAsAsync <DataTable>().Result; if (getCanceldata.Rows.Count > 0) { lblCounter.Text = Convert.ToString(getCanceldata.Rows.Count); grdCancelApplicationList.DataSource = getCanceldata; grdCancelApplicationList.DataBind(); } else { lblCounter.Text = "0"; lblCounter.Visible = true; grdCancelApplicationList.DataSource = new DataTable(); grdCancelApplicationList.DataBind(); } } }
public DataTable PostRejectionRecord(Pl_SubmitZeroLevel pl) { DataTable dt = new DataTable(); objPlSecondlevel.dt = objDlSecondlevel.SubmitRejection(pl); return(objPlSecondlevel.dt); }
public DataTable SubmitRejection(Pl_SubmitZeroLevel pl) { SqlCommand cmd1 = new SqlCommand("SPApplicationEntry", con); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@Ind", pl.Ind); cmd1.Parameters.AddWithValue("@ApplicationID", pl.ApplicationID); cmd1.Parameters.AddWithValue("@DocType", pl.DocType); cmd1.Parameters.AddWithValue("@LevelID", pl.UserTypeId); cmd1.Parameters.AddWithValue("@UserID", pl.UserID); cmd1.Parameters.AddWithValue("@LevelRemark", pl.Remarks); cmd1.Parameters.AddWithValue("@EntryByIP", pl.EntryByIP); cmd1.Parameters.AddWithValue("@ApprovalCount", pl.acnt); // cmd1.Parameters.AddWithValue("@MaxApproval",pl.maxaproval); cmd1.Parameters.AddWithValue("@RecordID", pl.recordId); cmd1.Parameters.AddWithValue("@IsConfirmed", false); cmd1.Parameters.AddWithValue("@IsRejected", true); cmd1.Parameters.AddWithValue("@IsCorrectionReqd", false); da = new SqlDataAdapter(cmd1); DataTable dt = new DataTable(); da.Fill(dt); return(dt); }
protected void lnkSave_Click(object sender, EventArgs e) { lblCancelMSG.Text = lblCancelSuccessMSG.Text = ""; if (string.IsNullOrEmpty(txtCancelReason.Text)) { cancelApplicationModal.Style.Add("display", "block"); lblCancelMSG.Text = "Please Enter Cancel Reason."; txtCancelReason.Text = ""; txtCancelReason.Focus(); } else { if (txtCancelReason.Text.Count() < 10) { cancelApplicationModal.Style.Add("display", "block"); lblCancelMSG.Text = "Please Enter Minimum 10 Char."; //txtCancelReason.Text = ""; txtCancelReason.Focus(); } else { HttpClient HClient = new HttpClient(); HClient.BaseAddress = new Uri(DataAcces.Url); HClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); Pl_SubmitZeroLevel pl = new Pl_SubmitZeroLevel(); pl.Ind = 51; pl.ApplicationID = Convert.ToInt32(lblApplicationID.Text); pl.UserID = Convert.ToInt32(Session["UserId"]); pl.CancelInd = 1; pl.CancelReason = txtCancelReason.Text; pl.CancelDateTime = DateTime.Now; var uri = "api/SecondLevel/PostCancelPopDetail"; var response = HClient.PostAsJsonAsync(uri, pl).Result; if (response.IsSuccessStatusCode) { var getdata = response.Content.ReadAsAsync <DataTable>().Result; if (getdata.Rows.Count > 0) { if (getdata.Rows[0]["ReturnInd"].ToString() == "1") { lblCancelSuccessMSG.Text = "Record Cancel Successfully."; cancelApplicationModal.Style.Add("display", "none"); lblCancelSuccessMSG.Style.Add("color", "#27c24c"); GetAppDetails(); } else { lblCancelMSG.Text = "Record Not Cancelled Successfully."; cancelApplicationModal.Style.Add("display", "block"); } } } txtCancelReason.Text = ""; } } }
public DataTable PostSubmitPopDetail(Pl_SubmitZeroLevel pl) { if (pl != null) { objPlSecondlevel.dt = objDlSecondlevel.SubmitPopDetail(pl); } objPlSecondlevel.dt.TableName = "MyTable"; return(objPlSecondlevel.dt); }
public DataTable CancelApplicationList(Pl_SubmitZeroLevel pl) { if (pl != null) { objPlSecondlevel.dt = objDlSecondlevel.CancelApplicationList(pl); } objPlSecondlevel.dt.TableName = "MyTable"; return(objPlSecondlevel.dt); }
protected void lnkSubmit_Click(object sender, EventArgs e) { try { HttpClient HClient = new HttpClient(); HClient.BaseAddress = new Uri(DataAcces.Url); HClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); Pl_SubmitZeroLevel pl = new Pl_SubmitZeroLevel(); pl.Ind = 1; pl.ApplicationID = Convert.ToInt32(ApplicatioID); pl.Rollno = txtRollNo.Text; pl.SName = txtStudentName.Text; pl.ExamName = txtExamName.Text; pl.BranchName = txtBranchName.Text; pl.ExamSession = Convert.ToString(0); pl.EnrollmentNo = txtEnrollmentlNo.Text == "" ? "0" : txtEnrollmentlNo.Text; pl.College = txtCollege.Text; pl.CGPA = txtCGPA.Text == "" ? "0" : txtCGPA.Text; pl.Division = txtDivision.Text; pl.UserID = Convert.ToInt32(Session["UserId"]); pl.EntryByIP = (IpAddress = GetIpAddress()); pl.UserTypeId = Convert.ToInt32(Session["UserTypeId"]); pl.maxaproval = ApprovalCount; pl.DocType = DocTypeID; pl.SubjectName = txtSubjectName.Text; pl.DistinctionSub = txtDistinctionSub.Text; if (txtMeritNo.Text != string.Empty) { pl.MeritNo = Convert.ToInt32(txtMeritNo.Text); } else { pl.MeritNo = 0; } pl.LaterReferenceNo = txtLaterReferenceNo.Text; pl.PassingYear = txtPassingYear.Text; pl.ExamMedium = txtExamMedium.Text; var uri = "api/SecondLevel/PostSubmitPopDetail/"; var response = HClient.PostAsJsonAsync(uri, pl).Result; if (response.IsSuccessStatusCode) { var getdata = response.Content.ReadAsAsync <DataTable>().Result; if (getdata.Rows.Count > 0) { Server.Transfer("FrmApproval.aspx"); } getdata = null; } response = null; uri = null; } catch { } }
internal DataTable CancelApplicationList(Pl_SubmitZeroLevel pl) { cmd = new SqlCommand("SPApplicationDetail", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Ind", pl.Ind); cmd.Parameters.AddWithValue("@UserID", pl.UserID); cmd.Parameters.AddWithValue("@CancelInd", pl.CancelInd); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); return(dt); }
protected void btnReject_Click(object sender, EventArgs e) { try { if (txtRemark.Text != null && txtRemark.Text != "") { lngRecordId = GetRecordId(); acnt = GetApprovalCount(); HttpClient HClient = new HttpClient(); HClient.BaseAddress = new Uri(DataAcces.Url); HClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); Pl_SubmitZeroLevel pl = new Pl_SubmitZeroLevel(); pl.Ind = 2; pl.ApplicationID = Convert.ToInt32(ApplicatioID); pl.UserID = Convert.ToInt32(Session["UserId"]); pl.EntryByIP = (IpAddress = GetIpAddress()); pl.UserTypeId = Convert.ToInt32(Session["UserTypeId"]); pl.recordId = lngRecordId; pl.acnt = acnt; pl.DocType = DocTypeID; pl.Remarks = txtRemark.Text; // pl.maxaproval = ApprovalCount; var uri = "api/SecondLevel/PostRejectionRecord"; var response = HClient.PostAsJsonAsync(uri, pl).Result; if (response.IsSuccessStatusCode) { var getdata = response.Content.ReadAsAsync <DataTable>().Result; if (getdata.Rows.Count > 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Notify", "alert('Application Rejected');window.location='FrmApproval.aspx';", true); } getdata = null; } response = null; uri = null; } else { lblmsg.Text = "Please Enter Remarks"; } } catch { } }
public DataTable SubmitApproval(Pl_SubmitZeroLevel pl) { DataTable dt = new DataTable(); try { SqlCommand cmd1 = new SqlCommand("SPApplicationEntry", con); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@Ind", 2); cmd1.Parameters.AddWithValue("@ApplicationID", pl.ApplicationID); cmd1.Parameters.AddWithValue("@DocType", pl.DocType); cmd1.Parameters.AddWithValue("@LevelID", pl.UserTypeId); cmd1.Parameters.AddWithValue("@LevelRemark", pl.Remarks); cmd1.Parameters.AddWithValue("@EntryByIP", pl.EntryByIP); cmd1.Parameters.AddWithValue("@ApprovalCount", pl.acnt); cmd1.Parameters.AddWithValue("@UserID", pl.UserID); cmd1.Parameters.AddWithValue("@RecordID", pl.recordId); cmd1.Parameters.AddWithValue("@IsConfirmed", true); cmd1.Parameters.AddWithValue("@IsRejected", false); cmd1.Parameters.AddWithValue("@IsCorrectionReqd", false); da = new SqlDataAdapter(cmd1); con.Close(); da.Fill(dt); if (dt != null && dt.Rows.Count > 0) { // return dt; } else { dt = null; } } catch (Exception ex) { msg = ex.Message; } return(dt); }
protected void lnkSubmit_Click(object sender, EventArgs e) { string progress = ""; lblCancelSuccessMSG.Text = ""; //progress = zeroLevelCheck(); if (txtExamName.Text != "") { if (progress == "") { HttpClient HClient = new HttpClient(); HClient.BaseAddress = new Uri(DataAcces.Url); HClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); Pl_SubmitZeroLevel pl = new Pl_SubmitZeroLevel(); pl.Ind = 1; pl.ApplicationID = Convert.ToInt32(ApplicatioID); pl.Rollno = txtRollNo.Text; pl.SName = txtStudentName.Text; pl.ExamName = txtExamName.Text; pl.BranchName = txtBranchName.Text; pl.ExamSession = Convert.ToString(0); pl.EnrollmentNo = txtEnrollmentlNo.Text == "" ? "0" : txtEnrollmentlNo.Text; pl.College = txtCollege.Text; pl.CGPA = txtCGPA.Text == "" ? "0" : txtCGPA.Text; pl.Division = txtDivision.Text; pl.UserID = Convert.ToInt32(Session["UserId"]); pl.EntryByIP = (IpAddress = GetIpAddress()); pl.UserTypeId = Convert.ToInt32(Session["UserTypeId"]); pl.maxaproval = ApprovalCount; pl.DocType = DocTypeID; pl.SubjectName = txtSubjectName.Text; pl.DistinctionSub = txtDistinctionSub.Text; pl.Remarks = txtRemark.Text; pl.Rank = ddlRank.SelectedItem.Text; pl.AwardedBy = ddlAwardedby.Text; if (ddlAwardedby.SelectedIndex == 3) { pl.AwardPrize = Convert.ToDecimal(txtAwardPrize.Text); } else { pl.AwardPrize = 0; } if (txtMeritNo.Text != string.Empty) { pl.MeritNo = Convert.ToInt32(txtMeritNo.Text); } else { pl.MeritNo = 0; } pl.LaterReferenceNo = txtLaterReferenceNo.Text; if (DocTypeID == 10) { pl.LaterReferenceDate = Convert.ToDateTime(txtDateResultDeclaration.Text); } else if (DocTypeID == 8 || DocTypeID == 9) { pl.LaterReferenceDate = Convert.ToDateTime(txtLaterReferenceDate.Text); } else { pl.LaterReferenceDate = DateTime.Now.Date; } // pl.DateResultDeclaration = Convert.ToDateTime(txtDateResultDeclaration.Text); pl.PassingYear = txtPassingYear.Text; pl.ExamMedium = txtExamMedium.Text; var uri = "api/SecondLevel/PostSubmitPopDetail/"; var response = HClient.PostAsJsonAsync(uri, pl).Result; if (response.IsSuccessStatusCode) { var getdata = response.Content.ReadAsAsync <DataTable>().Result; if (getdata.Rows.Count > 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Notify", "alert('Data Saved.');window.location='FrmZeroLevel.aspx';", true); } getdata = null; } response = null; uri = null; } else { msgVal.Text = progress; viewApplicationModal.Style.Add("display", "block"); //Popup(true); return; } } else { msgVal.Text = "Please Enter Exam Name"; viewApplicationModal.Style.Add("display", "block"); //Popup(true); return; } }
public DataTable SubmitPopDetail(Pl_SubmitZeroLevel pl) { DataTable dt = new DataTable(); SqlCommand cmd = new SqlCommand("SPApplicationEntry", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Ind", pl.Ind); cmd.Parameters.AddWithValue("@ApplicationID", pl.ApplicationID); cmd.Parameters.AddWithValue("@RollNo", pl.Rollno); cmd.Parameters.AddWithValue("@StudentName", pl.SName); cmd.Parameters.AddWithValue("@ExamName", pl.ExamName); cmd.Parameters.AddWithValue("@BranchName", pl.BranchName); cmd.Parameters.AddWithValue("@ExamSession", 0); cmd.Parameters.AddWithValue("@EnrollmentNo", pl.EnrollmentNo); cmd.Parameters.AddWithValue("@College", pl.College); cmd.Parameters.AddWithValue("@CGPA", pl.CGPA); cmd.Parameters.AddWithValue("@Division", pl.Division); cmd.Parameters.AddWithValue("@UserID", pl.UserID); cmd.Parameters.AddWithValue("@EntryByIP", pl.EntryByIP); cmd.Parameters.AddWithValue("@DocType", pl.DocType); cmd.Parameters.AddWithValue("@ExamPassingYear", pl.PassingYear); cmd.Parameters.AddWithValue("@ExamMedium", pl.ExamMedium); cmd.Parameters.AddWithValue("@MeritNo", pl.MeritNo); cmd.Parameters.AddWithValue("@SubjectName", pl.SubjectName); cmd.Parameters.AddWithValue("@DistinctionSubject", pl.DistinctionSub); cmd.Parameters.AddWithValue("@LetterRefNo", pl.LaterReferenceNo); cmd.Parameters.AddWithValue("@LetterRefDate", pl.LaterReferenceDate); cmd.Parameters.AddWithValue("@Ranking", pl.Rank); cmd.Parameters.AddWithValue("@AwardedBy", pl.AwardedBy); cmd.Parameters.AddWithValue("@AwardPrize", pl.AwardPrize); con.Open(); int i = Convert.ToInt16(cmd.ExecuteScalar()); con.Close(); if (i > 0) { SqlCommand cmd1 = new SqlCommand("SPApplicationEntry", con); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@Ind", 2); cmd1.Parameters.AddWithValue("@ApplicationID", pl.ApplicationID); // cmd1.Parameters.AddWithValue("@ApplicationID", pl.UserID); // cmd1.Parameters.AddWithValue("@DocType", pl.DocTypeID); cmd1.Parameters.AddWithValue("@DocType", pl.DocType); cmd1.Parameters.AddWithValue("@UserID", pl.UserID); cmd1.Parameters.AddWithValue("@LevelID", pl.UserTypeId); cmd1.Parameters.AddWithValue("@LevelRemark", pl.Remarks); cmd1.Parameters.AddWithValue("@EntryByIP", pl.EntryByIP); cmd1.Parameters.AddWithValue("@ApprovalCount", 0); // cmd1.Parameters.AddWithValue("@MaxApproval",pl.ApprovalCount); cmd1.Parameters.AddWithValue("@RecordID", i); cmd1.Parameters.AddWithValue("@IsConfirmed", false); cmd1.Parameters.AddWithValue("@IsRejected", false); cmd1.Parameters.AddWithValue("@IsCorrectionReqd", false); con.Open(); // j = Convert.ToInt16(cmd1.ExecuteScalar()); da = new SqlDataAdapter(cmd1); con.Close(); da.Fill(dt); if (dt != null && dt.Rows.Count > 0) { // return dt; } else { dt = null; } } return(dt); }
public DataTable PostApprovalRecord(Pl_SubmitZeroLevel objplSecondLevel) { objPlSecondlevel.dt = objDlSecondlevel.SubmitApproval(objplSecondLevel); return(objPlSecondlevel.dt); }
public void GetDoctypeDetail(DataRow dr) { lblCertifiacate.Attributes.CssStyle.Remove("font-size"); spanforPrize.InnerText = spanAwardPrize.InnerText = ""; pl = new Pl_SubmitZeroLevel(); pl.SName = dr["StudentName"].ToString(); lblNo.Text = dr["SrNo"].ToString(); switch (Convert.ToInt16(Session["DocType"])) { case 2: //Provision Certificate Provisional.Visible = true; lblCertifiacate.Text = "Provisional Certificate"; pl.Rollno = dr["RollNo"].ToString(); pl.EnrollmentNo = dr["EnrollmentNo"].ToString(); pl.ExamName = dr["ExamName"].ToString() + " - " + dr["ExamYear"] + " (" + dr["ExamSession"] + ")."; pl.CGPA = dr["CGPAPercentage"].ToString(); pl.College = dr["College"].ToString(); pl.Division = dr["Division"].ToString().ToUpper(); Signature = "Asstt. Registrar(Tabulation)"; //divFloatRight.Style.Add("margin-top", "30px"); lblVerification.Visible = lblYours.Visible = false; break; case 3: //Passing Certificate passingcertificate.Visible = true; lblCertifiacate.Text = "Passing Certificate"; pl.Rollno = dr["RollNo"].ToString(); pl.EnrollmentNo = dr["EnrollmentNo"].ToString(); pl.ExamName = dr["ExamName"].ToString(); pl.SubjectName = dr["SubjectName"].ToString(); pl.ExamSession = dr["ExamSession"] + " - " + dr["ExamYear"] + "."; pl.DistinctionSub = string.IsNullOrEmpty(dr["DistinctionSubject"].ToString()) ? " None." : dr["DistinctionSubject"].ToString() + "."; Signature = "Asstt. Registrar(Exams.)"; //divFloatRight.Style.Add("margin-top", "30px"); lblVerification.Visible = lblYours.Visible = false; break; case 4: // Merit Certificate MeritCertificate.Visible = true; lblCertifiacate.Text = "Merit Certificate"; pl.Rollno = dr["RollNo"].ToString(); pl.ExamName = dr["ExamName"].ToString(); pl.ExamSession = dr["ExamSession"] + "-" + dr["ExamYear"]; pl.Division = dr["Division"].ToString().ToUpper(); pl.MeritNo = Convert.ToInt32(dr["MeritNo"]); Signature = "Assistant Registrar(Exams.)"; //divFloatRight.Style.Add("margin-top", "30px"); lblVerification.Visible = lblYours.Visible = false; break; case 5: // Attempt Certificate AttempCerificate.Visible = true; lblCertifiacate.Text = "Attempt Certificate"; pl.Rollno = dr["RollNo"].ToString(); pl.ExamName = dr["ExamName"].ToString(); pl.ExamSession = dr["ExamSession"] + " - " + dr["ExamYear"]; Signature = "Asstt. Registrar(Tabulation)"; //divFloatRight.Style.Add("margin-top", "30px"); lblVerification.Visible = lblYours.Visible = false; break; case 6: // Medal Certificate MedalCertificate.Visible = true; lblCertifiacate.Text = "Certificate of Award"; pl.Rollno = dr["RollNo"].ToString(); pl.EnrollmentNo = dr["EnrollmentNo"].ToString(); pl.ExamName = dr["ExamName"].ToString(); pl.ExamSession = dr["ExamSession"] + " - " + dr["ExamYear"]; pl.Division = dr["Division"].ToString().ToUpper(); pl.Rank = dr["Ranking"].ToString(); pl.AwardedBy = dr["AwardedBy"].ToString(); pl.SubjectName = dr["SubjectName"].ToString(); if (pl.AwardedBy == "Cash Prize") { if (!String.IsNullOrEmpty(dr["AwardPrize"].ToString())) { spanforPrize.InnerText = " for Rs. "; spanAwardPrize.InnerText = dr["AwardPrize"].ToString(); } } Signature = "Registrar"; //divFloatRight.Style.Add("margin-top", "30px"); lblVerification.Visible = lblYours.Visible = false; break; //case 7: //Duplicate MarkSheet // MarkSheetVerification.Visible = true; // lblCertifiacate.Text = "Duplicate MarkSheet"; // pl.ExamName = dr["ExamName"].ToString(); // pl.ExamSession = dr["ExamSession"] + " - " + dr["ExamYear"] + "."; // pl.Rollno = dr["RollNo"].ToString(); // pl.Division = dr["Division"].ToString().ToUpper(); // //pl.LaterReferenceNo = dr["LetterRefNo"].ToString(); // //pl.LaterReferenceDate = Convert.ToDateTime(dr["LetterRefDate"]); // //Signature = "Asstt. Registrar()"; // break; case 8: //MarkSheet Verification Certifiacte MarkSheetVerification.Visible = true; lblCertifiacate.Text = "Marks Verification Certificate"; pl.ExamName = dr["ExamName"].ToString(); pl.ExamSession = dr["ExamSession"] + " - " + dr["ExamYear"] + "."; pl.Rollno = dr["RollNo"].ToString(); pl.Division = dr["Division"].ToString().ToUpper(); pl.LaterReferenceNo = dr["LetterRefNo"].ToString(); pl.LaterReferenceDate = Convert.ToDateTime(dr["LetterRefDate"]); Signature = "Asstt. Registrar(Exam)"; //divFloatRight.Style.Add("margin-top", "30px"); lblVerification.Visible = lblYours.Visible = false; break; case 9: //Degree Verification Certificate DegreeVerification.Visible = true; lblCertifiacate.Text = "Degree Verification Certificate"; pl.ExamName = dr["ExamName"].ToString(); pl.ExamSession = dr["ExamSession"] + " - " + dr["ExamYear"] + "."; pl.Rollno = dr["RollNo"].ToString(); pl.Division = dr["Division"].ToString().ToUpper(); pl.BranchName = dr["ExamBranch"].ToString(); pl.LaterReferenceNo = dr["LetterRefNo"].ToString(); pl.LaterReferenceDate = Convert.ToDateTime(dr["LetterRefDate"]); lblVerification.Text = "Verification"; Signature = "Asstt. Registrar(Tabulation)"; //divFloatRight.Style.Add("margin-top", "30px"); lblVerification.Visible = lblYours.Visible = true; break; case 10: //Date Of Dectlaration Certificate DateOfDeclaration.Visible = true; lblCertifiacate.Text = "Certificate of Subjects offered and date of declaration of result"; //"Date Of Declaration Certificate"; pl.Rollno = dr["RollNo"].ToString(); pl.EnrollmentNo = dr["EnrollmentNo"].ToString(); pl.ExamName = dr["ExamName"].ToString(); pl.ExamSession = dr["ExamSession"] + " - " + dr["ExamYear"]; pl.DateResultDeclaration = Convert.ToDateTime(dr["LetterRefDate"]); pl.SubjectName = dr["SubjectName"].ToString(); lblCertifiacate.Attributes.CssStyle.Add("font-size", "16px"); Signature = "Asstt. Registrar(Exams.)"; //divFloatRight.Style.Add("margin-top", "30px"); lblVerification.Visible = lblYours.Visible = false; break; case 11: //Medium of Instruction Certificate MediumOfInstruction.Visible = true; lblCertifiacate.Text = "Medium of Instruction Certificate"; pl.ExamName = dr["ExamName"].ToString(); pl.ExamSession = dr["ExamSession"] + " - " + dr["ExamYear"]; pl.Rollno = dr["RollNo"].ToString(); Signature = "Asstt. Registrar(Exams/Enquiry)"; //divFloatRight.Style.Add("margin-top", "30px"); lblVerification.Visible = lblYours.Visible = false; break; default: break; } }