public JsonResult FillData(string For = "All") { List <mDocumentVerificationView> _list = new List <mDocumentVerificationView>(); DocumentVerification_Repository _objRepository = new DocumentVerification_Repository(); DataSet _ds = _objRepository.Opr_DocumentVerification_Admin("SELECT", ConfigurationManager.AppSettings["CurrentPhase"].ToString(), For); if (_ds != null) { if (_ds.Tables[0].Rows.Count > 0) { foreach (System.Data.DataRow _dr in _ds.Tables[0].Rows) { _list.Add(new mDocumentVerificationView { Srno = _dr["Srno"].ToString(), studentid = _dr["studentid"].ToString(), StudentName = _dr["StudentName"].ToString(), Country_Name = _dr["Country_Name"].ToString(), ProgramLevel = _dr["ProgramLevel"].ToString(), IsVerified = _dr["IsVerified"].ToString(), VerifiedDate = _dr["VerifiedDate"].ToString() }); } } } var jsonResult = Json(new { data = _list }, JsonRequestBehavior.AllowGet); jsonResult.MaxJsonLength = int.MaxValue; return(jsonResult); }
#pragma warning disable SCS0016 // Controller method is vulnerable to CSRF public JsonResult SaveStudentData(string id, string Docs) #pragma warning restore SCS0016 // Controller method is vulnerable to CSRF { string Message = string.Empty, Code = string.Empty, Error = string.Empty; try { DocumentVerification_Repository _objRepo = new DocumentVerification_Repository(); DataSet _ds = _objRepo.Opr_VerifyDocuments(id, Docs); if (_ds != null) { if (_ds.Tables[0].Rows.Count > 0) { if (_ds.Tables[0].Rows[0]["COUNTS"].ToString() == "1") { SendEmail _objseedemail = new SendEmail(); string strform = ""; string Subject = "Study in India - Data Verification"; #region Code to send mails simultaneously in a loop (By Amit: 15-05-2020 10:11 AM) if (System.Web.HttpContext.Current.Application["UserCountForMail"] == null) { System.Web.HttpContext.Current.Application["UserCountForMail"] = 1; } else { } int UserCountForMail = Convert.ToInt32(System.Web.HttpContext.Current.Application["UserCountForMail"]); if (UserCountForMail < 4) { UserCountForMail++; } else { UserCountForMail = 1; } System.Web.HttpContext.Current.Application["UserCountForMail"] = UserCountForMail; if (System.Web.HttpContext.Current.Application["UserCountForMail"] == null) { System.Web.HttpContext.Current.Application["UserCountForMail"] = 1; } if (UserCountForMail == 1) { strform = System.Configuration.ConfigurationManager.AppSettings["Emailusername1"]; } else if (UserCountForMail == 2) { strform = System.Configuration.ConfigurationManager.AppSettings["Emailusername2"]; } else if (UserCountForMail == 3) { strform = System.Configuration.ConfigurationManager.AppSettings["Emailusername3"]; } else if (UserCountForMail == 4) { strform = System.Configuration.ConfigurationManager.AppSettings["Emailusername4"]; } #endregion string Email = _ds.Tables[1].Rows[0]["Email"].ToString(); string Name = _ds.Tables[1].Rows[0]["FirstName"].ToString() + ' ' + _ds.Tables[1].Rows[0]["LastName"].ToString(); StringBuilder MailBody = new StringBuilder(); MailBody.Append("<br/>Dear Student,<br/>"); MailBody.Append("<br/>Greetings from Study in India!."); if (_ds.Tables[2].Rows.Count > 0 || _ds.Tables[3].Rows.Count > 0) { // For Rejected MailBody.Append("<br/>The documents uploaded by you are checked by Study in India team and some of your documents /percentage filled are found to be <strong>incorrect</strong>."); MailBody.Append("<br/>Following issues were found with your documents/percentage provided:"); MailBody.Append("<table border=\"1\" style=\"border-collapse: collapse;\">"); MailBody.Append("<thead>"); MailBody.Append("<tr>"); MailBody.Append("<th>S. No</th>"); MailBody.Append("<th>Qualification</th>"); MailBody.Append("<th>Verification status</th>"); MailBody.Append("<th>Reason</th>"); MailBody.Append("<th>Comments</th>"); MailBody.Append("</tr>"); MailBody.Append("</thead>"); MailBody.Append("<tbody>"); int i = 1; if (_ds.Tables[2].Rows.Count > 0) { foreach (DataRow _dr in _ds.Tables[2].Rows) { MailBody.Append("<tr>"); MailBody.Append("<td>" + (i++) + "</td>"); MailBody.Append("<td>" + _dr["EduQualificationsName"].ToString() + (_dr["IsGiven"].ToString() == "2" ? " <label class='badge badge-danger'>Result Awaited</label>" : "") + " </td>"); MailBody.Append("<td>" + _dr["IsVerified"].ToString() + "</td>"); MailBody.Append("<td>" + _dr["Reason"].ToString() + "</td>"); MailBody.Append("<td>" + _dr["Comment"].ToString() + "</td>"); MailBody.Append("</tr>"); } } if (_ds.Tables[3].Rows.Count > 0) { foreach (DataRow _dr in _ds.Tables[3].Rows) { MailBody.Append("<tr>"); MailBody.Append("<td>" + (i++) + "</td>"); MailBody.Append("<td>" + _dr["AditionalExams"].ToString() + "</td>"); MailBody.Append("<td>" + _dr["IsVerified"].ToString() + "</td>"); MailBody.Append("<td>" + _dr["Reason"].ToString() + "</td>"); MailBody.Append("<td>" + _dr["Comment"].ToString() + "</td>"); MailBody.Append("</tr>"); } } MailBody.Append("</tbody>"); MailBody.Append("</table>"); MailBody.Append("<br/>The status of the same may be checked on your dashboard."); MailBody.Append("<br/><strong>Kindly upload the correct documents/percentage within three days on your dashboard otherwise your application for Study in India shall stand cancelled</strong>."); } else { // For Verified MailBody.Append("<br/>The documents uploaded by you are verified by Study in India team and all your documents are found to be correct."); MailBody.Append("<br/>The status of the same may be checked on your dashboard."); } MailBody.Append("<br/>"); MailBody.Append("<br/>"); MailBody.Append("<br/>"); MailBody.Append("<br/>For further queries, please contact at our toll-free number: +919899450350.<br/>"); MailBody.Append("<br/><br/><br/>Regards,<br/>"); MailBody.Append("Study in India cell<br/>"); string bcc = ""; string cc = ""; _objseedemail.Send_Email(strform, Email, bcc, cc, Subject, MailBody.ToString(), "", true); Message = "Details has been saved successfully!"; Code = "success"; } } else { Message = "Error from server side. Kindly refresh the page and try again."; Code = "servererror"; } } else { Message = "Error from server side. Kindly refresh the page and try again."; Code = "servererror"; } } catch (NullReferenceException ex) { Message = "Your session has been expired. Kindly login again."; Code = "sessionexpired"; Error = ex.Message; } catch (Exception ex) { Message = "Error from server side. Kindly refresh the page and try again."; Code = "servererror"; Error = ex.Message; } return(Json(new { m = Message, c = Code, e = Error }, JsonRequestBehavior.AllowGet )); }
public ActionResult ExportToExcel(string For = "All") { DocumentVerification_Repository _objRepository = new DocumentVerification_Repository(); DataSet _ds = _objRepository.Opr_DocumentVerification_Admin("EXPORT", ConfigurationManager.AppSettings["CurrentPhase"].ToString(), For); DataTable _dt = _ds.Tables[0]; if (_dt.Rows.Count > 0) { _dt.Columns["Srno"].ColumnName = "Srno"; _dt.Columns["studentid"].ColumnName = "Student ID"; _dt.Columns["StudentName"].ColumnName = "Student Name"; _dt.Columns["Country_Name"].ColumnName = "Country"; _dt.Columns["ProgramLevel"].ColumnName = "Program Level"; _dt.Columns["OverallStatus"].ColumnName = "Overall Status"; _dt.Columns["VerifiedDate"].ColumnName = "Verified Date"; _dt.Columns["10th"].ColumnName = "10th"; _dt.Columns["10thReason"].ColumnName = "10thReason"; _dt.Columns["10thComment"].ColumnName = "10thComment"; _dt.Columns["12th"].ColumnName = "12th"; _dt.Columns["12thReason"].ColumnName = "12thReason"; _dt.Columns["12thComment"].ColumnName = "12thComment"; _dt.Columns["Diploma"].ColumnName = "Diploma"; _dt.Columns["DiplomaReason"].ColumnName = "DiplomaReason"; _dt.Columns["DiplomaComment"].ColumnName = "DiplomaComment"; _dt.Columns["UG"].ColumnName = "UG"; _dt.Columns["UGReason"].ColumnName = "UGReason"; _dt.Columns["UGComment"].ColumnName = "UGComment"; _dt.Columns["PG"].ColumnName = "PG"; _dt.Columns["PGReason"].ColumnName = "PGReason"; _dt.Columns["PGComment"].ColumnName = "PGComment"; _dt.Columns["MPhil"].ColumnName = "MPhil"; _dt.Columns["MPhilReason"].ColumnName = "MPhilReason"; _dt.Columns["MPhilComment"].ColumnName = "MPhilComment"; _dt.Columns["GRE"].ColumnName = "GRE"; _dt.Columns["GREReason"].ColumnName = "GREReason"; _dt.Columns["GREComment"].ColumnName = "GREComment"; _dt.Columns["GMAT"].ColumnName = "GMAT"; _dt.Columns["GMATReason"].ColumnName = "GMATReason"; _dt.Columns["GMATComment"].ColumnName = "GMATComment"; _dt.Columns["SATLevelI"].ColumnName = "SAT Level I"; _dt.Columns["SATLevelIReason"].ColumnName = "SATLevelIReason"; _dt.Columns["SATLevelIComment"].ColumnName = "SATLevelIComment"; _dt.Columns["SATLevelII"].ColumnName = "SAT Level II"; _dt.Columns["SATLevelIIReason"].ColumnName = "SATLevelIIReason"; _dt.Columns["SATLevelIIComment"].ColumnName = "SATLevelIIComment"; _dt.Columns["TOEFL"].ColumnName = "TOEFL"; _dt.Columns["TOEFLReason"].ColumnName = "TOEFLReason"; _dt.Columns["TOEFLComment"].ColumnName = "TOEFLComment"; _dt.Columns["IELTS"].ColumnName = "IELTS"; _dt.Columns["IELTSReason"].ColumnName = "IELTSReason"; _dt.Columns["IELTSComment"].ColumnName = "IELTSComment"; _dt.Columns["GATE"].ColumnName = "GATE"; _dt.Columns["GATEReason"].ColumnName = "GATEReason"; _dt.Columns["GATEComment"].ColumnName = "GATEComment"; _dt.Columns["JEEAdvanced"].ColumnName = "JEEAdvanced"; _dt.Columns["JEEAdvancedReason"].ColumnName = "JEEAdvancedReason"; _dt.Columns["JEEAdvancedComment"].ColumnName = "JEEAdvancedComment"; _dt.Columns["JEEMain"].ColumnName = "JEEMain"; _dt.Columns["JEEMainReason"].ColumnName = "JEEMainReason"; _dt.Columns["JEEMainComment"].ColumnName = "JEEMainComment"; _dt.Columns["NATA"].ColumnName = "NATA"; _dt.Columns["NATAReason"].ColumnName = "NATAReason"; _dt.Columns["NATAComment"].ColumnName = "NATAComment"; } using (XLWorkbook wb = new XLWorkbook()) { wb.Worksheets.Add(_dt); wb.Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center; wb.Style.Font.Bold = true; Response.Clear(); Response.Buffer = true; Response.Charset = ""; Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.AddHeader("content-disposition", "attachment;filename=SIIDocumentVerification.xlsx"); using (MemoryStream MyMemoryStream = new MemoryStream()) { wb.SaveAs(MyMemoryStream); MyMemoryStream.WriteTo(Response.OutputStream); Response.Flush(); Response.End(); } } return(Redirect("~/Admin/VerifyDocuments/")); }