protected void LoadTestResultReport(string ids) { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.strCourseID = ids; objBEAdmin.strExamStartDate = txtFromDate.SelectedDate.Value; objBEAdmin.strExamEndDate = txtToDate.SelectedDate.Value; objBEAdmin.IntUserID = Convert.ToInt32(Session[EnumPageSessions.USERID]); objBAdmin.BGetTestResultReportDetails(objBEAdmin); gvReports.DataSource = objBEAdmin.DtResult; gvReports.DataBind(); ViewState["gvReports"] = objBEAdmin.DtResult; }
protected void LoadTestResultReportForSorting(string ids) { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.strCourseID = ids; DateTime ST = Convert.ToDateTime(ExamStartRadDatePicker.SelectedDate); DateTime ED = Convert.ToDateTime(ExamEndRadDatePicker.SelectedDate); objBEAdmin.DtStartDate = ST.ToString("MM/dd/yyyy"); objBEAdmin.DtEndDate = ED.ToString("MM/dd/yyyy"); objBEAdmin.IntUserID = Convert.ToInt32(Session[EnumPageSessions.USERID]); objBAdmin.BGetTestResultReportDetails(objBEAdmin); gvReports.DataSource = objBEAdmin.DtResult; ViewState["gvReports"] = objBEAdmin.DtResult; }
protected void LoadTestResultReport(string ids) { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.strCourseID = ids; objBEAdmin.IntUserID = 0; //for admin DateTime ST = Convert.ToDateTime(ExamStartRadDatePicker.SelectedDate); DateTime ED = Convert.ToDateTime(ExamEndRadDatePicker.SelectedDate); objBEAdmin.DtStartDate = ST.ToString("MM/dd/yyyy"); objBEAdmin.DtEndDate = ED.ToString("MM/dd/yyyy"); objBAdmin.BGetTestResultReportDetails(objBEAdmin); gvReports.DataSource = objBEAdmin.DtResult; gvReports.DataBind(); ViewState["gvReports"] = objBEAdmin.DtResult; }
public void SendEmail() { lblResult.Text = ""; BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.strCourseID = GetExamIds(); //objBEAdmin.strExamStartDate = txtFromDate.SelectedDate.Value; //objBEAdmin.strExamEndDate = txtToDate.SelectedDate.Value; objBEAdmin.IntUserID = 0; //for admin DateTime ST = Convert.ToDateTime(ExamStartRadDatePicker.SelectedDate); DateTime ED = Convert.ToDateTime(ExamEndRadDatePicker.SelectedDate); objBEAdmin.DtStartDate = ST.ToString("MM/dd/yyyy"); objBEAdmin.DtEndDate = ED.ToString("MM/dd/yyyy"); objBAdmin.BGetTestResultReportDetails(objBEAdmin); DataTable objDt = objBEAdmin.DtResult; objDt.AcceptChanges(); objDt.Columns["ExamID"].ColumnName = "Exam ID"; objDt.Columns["StudentFirstName"].ColumnName = "Student First Name"; objDt.Columns["StudentLastName"].ColumnName = "Student Last Name"; objDt.Columns["EmailAddress"].ColumnName = "Email Address"; objDt.Columns["CourseName"].ColumnName = "Course Name"; objDt.Columns["ExamName"].ColumnName = "Exam Name"; objDt.Columns["InstructorName"].ColumnName = "Instructor Name"; objDt.Columns["AppointmentCreationDate"].ColumnName = "Appointment Creation Date [EST]"; objDt.Columns["AppointmentDate"].ColumnName = "Appointment Date [EST]"; objDt.Columns["ExamDuration"].ColumnName = "Exam Duration"; objDt.Columns["FairExamLevel"].ColumnName = "Fair ExamLevel"; objDt.Columns["StatusName"].ColumnName = "Status"; objDt.Columns["AlertCount"].ColumnName = "Blue"; objDt.Columns["Alert"].ColumnName = "Blue Comments"; objDt.Columns["Green"].ColumnName = "Green Comments"; objDt.Columns["GreenCount"].ColumnName = "Green"; objDt.Columns["Orange"].ColumnName = "Yellow Comments"; objDt.Columns["OrangeCount"].ColumnName = "Yellow"; objDt.Columns["Red"].ColumnName = "Red Comments"; objDt.Columns["RedCount"].ColumnName = "Red"; objDt.Columns.Remove("CourseID"); FileInfo rptFileName = new FileInfo(Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["Reports"].ToString()) + @"\Exam status from_" + DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss").Replace("/", "-").Replace(":", "-") + ".xls"); // If any file exists in this directory having name 'Sample1.xlsx', then delete it if (rptFileName.Exists) { rptFileName.Delete(); // ensures we create a new workbook rptFileName = new FileInfo(Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["Reports"].ToString()) + @"\Exam status from_" + DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss").Replace("/", "-").Replace(":", "-") + ".xls"); } ExcelSheetGenerator objExcel = new ExcelSheetGenerator(); objExcel.GenerateReport(objDt, rptFileName, "Exam status _", "UserName"); string ToEmail = txtEmail.Text; System.Net.Mail.MailMessage email = new System.Net.Mail.MailMessage(); StringBuilder body = new StringBuilder(); email.From = new MailAddress("*****@*****.**"); email.To.Add(ToEmail.Replace(" ", "")); email.Subject = "Exam status"; body.Append("<table style='font-family:Helvetica;font-size:9pt;width:600px;'>"); body.Append(@"<tr><td>Hi,<br/><br/>Please find the enclosed Exam status report. <br/><br/><br/>Thank you,<br/>Examity.<br/><b>***DO NOT REPLY TO THIS EMAIL***</b></td></tr>"); body.Append("</table>"); // Attachment goes here Attachment attachment = new Attachment(rptFileName.ToString()); attachment.Name = "Exam status" + ".xlsx"; email.Attachments.Add(attachment); //add the attachment email.Body = body.ToString(); email.IsBodyHtml = true; SmtpClient obj = new SmtpClient { Host = ConfigurationManager.AppSettings["smtpServer"], Port = Convert.ToInt32(ConfigurationManager.AppSettings["smtpPort"]), EnableSsl = true, DeliveryMethod = SmtpDeliveryMethod.Network, UseDefaultCredentials = false, Credentials = new System.Net.NetworkCredential(ConfigurationManager.AppSettings["smtpUser"].ToString(), ConfigurationManager.AppSettings["Reportspassword"].ToString()) }; obj.Send(email); lblResult.Text = "<font color='Blue' size='4px'>" + "Report emailed sucessfully." + "</font>"; }
public void GenerateReport() { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.strCourseID = GetExamIds(); objBEAdmin.IntUserID = 0; //for admin DateTime ST = Convert.ToDateTime(ExamStartRadDatePicker.SelectedDate); DateTime ED = Convert.ToDateTime(ExamEndRadDatePicker.SelectedDate); objBEAdmin.DtStartDate = ST.ToString("MM/dd/yyyy"); objBEAdmin.DtEndDate = ED.ToString("MM/dd/yyyy"); objBAdmin.BGetTestResultReportDetails(objBEAdmin); if (gvReports.Items.Count > 0) { DataTable objDt = objBEAdmin.DtResult; objDt.AcceptChanges(); objDt.Columns["ExamID"].ColumnName = "Exam ID"; objDt.Columns["StudentFirstName"].ColumnName = "Student First Name"; objDt.Columns["StudentLastName"].ColumnName = "Student Last Name"; objDt.Columns["EmailAddress"].ColumnName = "Email Address"; objDt.Columns["CourseName"].ColumnName = "Course Name"; objDt.Columns["ExamName"].ColumnName = "Exam Name"; objDt.Columns["InstructorName"].ColumnName = "Instructor Name"; objDt.Columns["AppointmentCreationDate"].ColumnName = "Appointment Creation Date [EST]"; objDt.Columns["AppointmentDate"].ColumnName = "Appointment Date [EST]"; objDt.Columns["ExamDuration"].ColumnName = "Exam Duration"; objDt.Columns["FairExamLevel"].ColumnName = "Fair ExamLevel"; objDt.Columns["StatusName"].ColumnName = "Status"; objDt.Columns["AlertCount"].ColumnName = "Blue"; objDt.Columns["Alert"].ColumnName = "Blue Comments"; objDt.Columns["Green"].ColumnName = "Green Comments"; objDt.Columns["GreenCount"].ColumnName = "Green"; objDt.Columns["Orange"].ColumnName = "Yellow Comments"; objDt.Columns["OrangeCount"].ColumnName = "Yellow"; objDt.Columns["Red"].ColumnName = "Red Comments"; objDt.Columns["RedCount"].ColumnName = "Red"; objDt.Columns.Remove("CourseID"); string Examsummary = Server.MapPath(ConfigurationManager.AppSettings["Reports"].ToString()) + '\\' + "Exam status" + DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss").Replace("/", "-").Replace(":", "-") + ".xls"; if (File.Exists(Examsummary)) { File.Delete(Examsummary); } FileInfo rptFileName = new FileInfo(Examsummary); // this.DeleteHistoricFiles(); ExcelSheetGenerator objExcel = new ExcelSheetGenerator(); objExcel.GenerateReport(objDt, rptFileName, " Exam status ", "UserName"); Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.AppendHeader("Content-Disposition", "attachment; filename=" + "Examstatus" + DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss").Replace("/", "-") + ".xlsx"); Response.TransmitFile(rptFileName.ToString()); Response.End(); } }