public ActionResult GetSCARFSurveyAnswerData([DataSourceRequest] DataSourceRequest request) { List <SCARFSurveyAnswerModels> SCARFSurveyAnswerModelsList = null; SCARFSurveyAnswerModelsList = BCBSDataAccess.GetDataForSCARFSurveyAnswer(); if (SCARFSurveyAnswerModelsList == null) { return(Json(new List <SCARFSurveyAnswerModels>(), JsonRequestBehavior.AllowGet)); } return(Json(SCARFSurveyAnswerModelsList.ToDataSourceResult(request), JsonRequestBehavior.AllowGet)); }
public ActionResult U65GetReportData([DataSourceRequest] DataSourceRequest request) { List <U65Certificate> U65ModelList = null; U65ModelList = BCBSDataAccess.GetDataForU65Report(); if (U65ModelList == null) { return(Json(new List <U65Certificate>(), JsonRequestBehavior.AllowGet)); } return(Json(U65ModelList.ToDataSourceResult(request), JsonRequestBehavior.AllowGet)); }
public ActionResult GetSalesData([DataSourceRequest] DataSourceRequest request) { List <SalesCertificate> SalesCertificateModelList = null; SalesCertificateModelList = BCBSDataAccess.GetDataForSales(); if (SalesCertificateModelList == null) { return(Json(new List <SalesCertificate>(), JsonRequestBehavior.AllowGet)); } return(Json(SalesCertificateModelList.ToDataSourceResult(request), JsonRequestBehavior.AllowGet)); }
public ActionResult GetReportData([DataSourceRequest] DataSourceRequest request) { List <Certificate> courseModelList = null; courseModelList = BCBSDataAccess.GetDataForReport(); if (courseModelList == null) { return(Json(new List <Certificate>(), JsonRequestBehavior.AllowGet)); } // return View(new GridModel(metadataDocTypesList)); return(Json(courseModelList.ToDataSourceResult(request), JsonRequestBehavior.AllowGet)); }
// POST api/<controller> public string Post(Certificate model) { var certificateLink = string.Empty; // BCBSDataAccess.AddDumCourse("entry"); try { if (string.IsNullOrWhiteSpace(model.EmailAddress) && string.IsNullOrWhiteSpace(model.CourseTitle)) { throw new ApplicationException("Email Address and Course Title required.."); } //if(model == null) // BCBSDataAccess.AddDumCourse("model is null"); Guid userCourseId; // BCBSDataAccess.AddDumCourse("before save data"); var result = BCBSDataAccess.SaveData(model, out userCourseId); Util.LogInfo("Post", "AFter dsave call :" + result); // BCBSDataAccess.AddDumCourse("after save data:"+result); certificateLink = ConfigurationManager.AppSettings["CertificateLink"]; certificateLink = string.Format(certificateLink, userCourseId); // link = string.Format(link,certificateLink); if (result) { var subject = ConfigurationManager.AppSettings["MailSubject"]; var physicalPath = Util.ResolveFileName(@"Template\EmailTemplate.txt"); var content = File.ReadAllText(physicalPath); var emailContent = string.Format(content, model.CourseTitle, certificateLink); // var recipient = ConfigurationManager.AppSettings["Recipient"]; Util.SendMail(model.EmailAddress, subject, emailContent); } } catch (Exception ex) { string DetailsMessageError = null; if (ex.InnerException != null) { DetailsMessageError = ex.InnerException.Message + " " + ex.StackTrace; } else { DetailsMessageError = ex.StackTrace; } Util.LoggError(new System.Diagnostics.StackFrame(0).GetMethod().Name, ex.Message, DetailsMessageError); } return(certificateLink); }
public ActionResult GetExporttoSCARFSurveyAnswerData() { MemoryStream memoryStream = null; List <SCARFSurveyAnswerModels> SCARFSurveyAnswerModelsList = null; const string header = "Workday ID,Learner Name,Manager Name,Manager Email Address,Report Date,Status,Status Text,Certainty,Certainty Text,Autonomy,Autonomy Text,Relatedness,Relatedness Text,Fairness,Fairness Text"; const string format = "{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14}"; string content = string.Empty; SCARFSurveyAnswerModelsList = BCBSDataAccess.GetDataForSCARFSurveyAnswer(); memoryStream = new MemoryStream(); if (SCARFSurveyAnswerModelsList != null && SCARFSurveyAnswerModelsList.Count > 0) { TextWriter tw = new StreamWriter(memoryStream); tw.WriteLine(header); foreach (var item in SCARFSurveyAnswerModelsList) { item.WorkDayId = item.WorkDayId; item.LearnerName = item.LearnerName; item.managerName = item.managerName; item.managerEmailID = item.managerEmailID; item.ReportDateString = item.ReportDate.ToString("MM/dd/yyyy").Trim(); item.Status = item.Status; item.StatusText = item.StatusText; item.Certainty = item.Certainty; item.CertaintyText = item.CertaintyText; item.Autonomy = item.Autonomy; item.AutonomyText = item.AutonomyText; item.Relatedness = item.Relatedness; item.RelatednessText = item.RelatednessText; item.Fairness = item.Fairness; item.FairnessText = item.FairnessText; content = string.Format(format, item.WorkDayId, item.LearnerName, item.managerName, item.managerEmailID, item.ReportDateString, item.Status, item.StatusText, item.Certainty, item.CertaintyText, item.Autonomy, item.AutonomyText, item.Relatedness, item.RelatednessText, item.Fairness, item.FairnessText); tw.WriteLine(content); } tw.Flush(); } string contentType = "application/octet-stream"; byte[] pdfdata = null; pdfdata = memoryStream.ToArray(); var filaName = (ConfigurationManager.AppSettings["ProjectName"]); var Datetime = ""; Datetime = DateTime.Now.ToString("dd_MM_yyyy_T_HH:mm"); return(File(pdfdata, contentType, filaName + "_ExportData_" + Datetime + ".csv")); }
public ActionResult U65Certificate(int id) { if (id > 0) { var model = BCBSDataAccess.U65GetDataForCertificate(id); if (model != null) { model.DateofCompletion = model.DateofCompletion; string fileName = string.Empty; byte[] bytes = new byte[0]; var response = new FileContentResult(bytes, "application/octet-stream"); bytes = ControllerContext.GeneratePdf(model, "_U65CertificatePDF"); Font footerFont = FontFactory.GetFont("Arial", 8, Font.NORMAL, BaseColor.BLACK); using (MemoryStream stream = new MemoryStream()) { Document document = new Document(PageSize.A4_LANDSCAPE); PdfWriter writer = PdfWriter.GetInstance(document, stream); PdfReader reader = new PdfReader(bytes); using (PdfStamper stamper = new PdfStamper(reader, stream)) { stamper.AcroFields.SetFieldProperty("SomeDateField", "textsize", 1f, null); int pages = reader.NumberOfPages; for (int i = 1; i <= pages; i++) { ColumnText.ShowTextAligned(stamper.GetUnderContent(i), Element.ALIGN_LEFT, new Phrase("Page | " + (i) + "/" + pages, footerFont), 20f, 15f, 0); } } bytes = stream.ToArray(); } fileName = "U65_CertificatePDF" + System.DateTime.Now.Ticks + ".pdf"; response = new FileContentResult(bytes, "application/octet-stream"); response.FileDownloadName = fileName; return(response); // return View("U65Certificate", model); // Return Html View Don't Remove } else { return(View("NotFound", model)); } } else { return(View("NotFound")); } }
public ActionResult ExportData() { MemoryStream memoryStream = null; List <Certificate> courseModelList = null; const string header = "Course Name, Provider's Name,Provider Type,Email Address,Medical License Number,National Provider Identifier (NPI),Practice Name,Completion Date,Total Credit Hours,Type of Credit,Delivery Method"; const string format = "{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10}"; string content = string.Empty; courseModelList = BCBSDataAccess.GetDataForReport(); memoryStream = new MemoryStream(); if (courseModelList != null && courseModelList.Count > 0) { TextWriter tw = new StreamWriter(memoryStream); tw.WriteLine(header); foreach (var item in courseModelList) { item.CourseTitle = item.CourseTitle.Contains(",") ? item.CourseTitle.Replace(',', '|') : item.CourseTitle; item.OfficialProviderName = item.OfficialProviderName.Contains(",") ? item.OfficialProviderName.Replace(',', '|') : item.OfficialProviderName; item.ProviderType = item.ProviderType.Contains(",") ? item.ProviderType.Replace(',', '|') : item.ProviderType; item.EmailAddress = item.EmailAddress.Contains(",") ? item.EmailAddress.Replace(',', '|') : item.EmailAddress; item.MedicalLicenseNo = item.MedicalLicenseNo.Contains(",") ? item.MedicalLicenseNo.Replace(',', '|') : item.MedicalLicenseNo; item.NPI = item.NPI.Contains(",") ? item.NPI.Replace(',', '|') : item.NPI; item.PracticeName = item.PracticeName.Contains(",") ? item.PracticeName.Replace(',', '|') : item.PracticeName; item.TotalContactHours = item.TotalContactHours.Contains(",") ? item.TotalContactHours.Replace(',', '|') : item.TotalContactHours;// Chnage 13/05/2019 item.TypeofCredits = item.TypeofCredits.Contains(",") ? item.TypeofCredits.Replace(',', '|') : item.TypeofCredits; item.DeliveryMethod = item.DeliveryMethod.Contains(",") ? item.DeliveryMethod.Replace(',', '|') : item.DeliveryMethod; content = string.Format(format, item.CourseTitle, item.OfficialProviderName, item.ProviderType, item.EmailAddress, item.MedicalLicenseNo, item.NPI, item.PracticeName, item.CompletionDate.ToString("MMMM d yyyy"), item.TotalContactHours, item.TypeofCredits, item.DeliveryMethod); tw.WriteLine(content); } tw.Flush(); } string contentType = "application/octet-stream"; byte[] pdfdata = null; pdfdata = memoryStream.ToArray(); var filaName = ConfigurationManager.AppSettings["CSVFileName"]; return(File(pdfdata, contentType, filaName)); }
public ActionResult U65ExportData() { MemoryStream memoryStream = null; List <U65Certificate> U65CourseModelList = null; const string header = "Agent Name, Agency Name,Address,Managing Health Agent Name,Agent Email,Work Phone Number,National Producer Number,FFM ID,Assessment Score,Pass/Fail Status,Date of Completion"; const string format = "{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10}";//,{8},{9},{10}"; string content = string.Empty; U65CourseModelList = BCBSDataAccess.GetDataForU65Report(); memoryStream = new MemoryStream(); if (U65CourseModelList != null && U65CourseModelList.Count > 0) { TextWriter tw = new StreamWriter(memoryStream); tw.WriteLine(header); foreach (var item in U65CourseModelList) { item.AgentName = !String.IsNullOrEmpty(item.AgentName) ? (item.AgentName.Contains(",") ? item.AgentName.Replace(',', '|') : item.AgentName): string.Empty; item.AgencyName = !String.IsNullOrEmpty(item.AgencyName)? (item.AgencyName.Contains(",") ? item.AgencyName.Replace(',', '|') : item.AgencyName) : string.Empty; item.AgencyAddress = !String.IsNullOrEmpty(item.AgencyAddress)? (item.AgencyAddress.Contains(",") ? item.AgencyAddress.Replace(',', '|') : item.AgencyAddress) : string.Empty; item.AgentManagingHealth = !String.IsNullOrEmpty(item.AgentManagingHealth)? (item.AgentManagingHealth.Contains(",") ? item.AgentManagingHealth.Replace(',', '|') : item.AgentManagingHealth) : string.Empty; item.AgentEmail = !String.IsNullOrEmpty(item.AgentEmail)? (item.AgentEmail.Contains(",") ? item.AgentEmail.Replace(',', '|') : item.AgentEmail) : string.Empty; item.WorkPhoneNumber = !String.IsNullOrEmpty(item.WorkPhoneNumber)? (item.WorkPhoneNumber.Contains(",") ? item.WorkPhoneNumber.Replace(',', '|') : item.WorkPhoneNumber) : string.Empty; item.NationalProducerNumber = !String.IsNullOrEmpty(item.NationalProducerNumber)? (item.NationalProducerNumber.Contains(",") ? item.NationalProducerNumber.Replace(',', '|') : item.NationalProducerNumber) : string.Empty; item.FFMID = !String.IsNullOrEmpty(item.FFMID) ? (item.FFMID.Contains(",") ? item.FFMID.Replace(',', '|') : item.FFMID) : string.Empty; item.AssessmentScore = item.AssessmentScore; //item.PassFailStatus = item.PassFailStatus; item.PassFailStatusstring = Convert.ToBoolean(item.PassFailStatus) ? "PASS" : "FAIL"; item.DateofCompletion = item.DateofCompletion; content = string.Format(format, item.AgentName, item.AgencyName, item.AgencyAddress, item.AgentManagingHealth, item.AgentEmail, item.WorkPhoneNumber, item.NationalProducerNumber, item.FFMID, item.AssessmentScore, item.PassFailStatusstring, item.DateofCompletion.ToString("MM-dd-yyyy h:mm:ss tt")); tw.WriteLine(content); } tw.Flush(); } string contentType = "application/octet-stream"; byte[] pdfdata = null; pdfdata = memoryStream.ToArray(); var filaName = ConfigurationManager.AppSettings["CSVFileName"]; return(File(pdfdata, contentType, filaName)); }
public ActionResult Certificate(string id) { Guid userCourseId; if (!Guid.TryParse(id, out userCourseId)) { return(View("NotFound")); } var model = BCBSDataAccess.GetDataForCertificate(userCourseId); if (model != null) { model.CompletionDateString = model.CompletionDate.ToString("MMMM d, yyyy"); return(View("Certificate", model)); } else { return(View("NotFound", model)); } }
public string Post(U65Certificate model) { var U65CertificateLink = string.Empty; try { if (string.IsNullOrWhiteSpace(model.AgentEmail) && string.IsNullOrWhiteSpace(model.AgentName)) { throw new ApplicationException("Agent Email Address and Agent Name required.."); } var result = BCBSDataAccess.SaveDataU65(model); Util.LogInfo("Post", "AFter dsave call :" + result); if (model.PassFailStatus == true) { U65CertificateLink = ConfigurationManager.AppSettings["CertificateLink"]; U65CertificateLink = string.Format(U65CertificateLink, result); Util.LogInfo("Post", "AFter Sucess Result :" + result); } else { Util.LogInfo("Post", "AFter Status is Fail Result :" + result); U65CertificateLink = string.Format("Status is Fail"); } } catch (Exception ex) { string DetailsMessageError = null; if (ex.InnerException != null) { DetailsMessageError = ex.InnerException.Message + " " + ex.StackTrace; } else { DetailsMessageError = ex.StackTrace; } Util.LoggError(new System.Diagnostics.StackFrame(0).GetMethod().Name, ex.Message, DetailsMessageError); } return(U65CertificateLink); }
public SCARFSurveyAnswerModels SCARFSurveyPost([FromBody] SCARFSurveyAnswerModels SCARFSurveyModel) { SCARFSurveyAnswerModels OnjSCARFSurvey = new SCARFSurveyAnswerModels(); try { if (String.IsNullOrEmpty(SCARFSurveyModel.WorkDayId.Trim())) { SCARFSurveyModel.IsErrrorMsg = true; SCARFSurveyModel.Message = "WorkDay Id is Required"; } else if (String.IsNullOrEmpty(SCARFSurveyModel.LearnerName.Trim())) { SCARFSurveyModel.IsErrrorMsg = true; SCARFSurveyModel.Message = "Learner Name is Required"; } else if (String.IsNullOrEmpty(SCARFSurveyModel.managerName.Trim())) { SCARFSurveyModel.IsErrrorMsg = true; SCARFSurveyModel.Message = "Manager Name is Required"; } else if (String.IsNullOrEmpty(SCARFSurveyModel.managerEmailID.Trim())) { SCARFSurveyModel.IsErrrorMsg = true; SCARFSurveyModel.Message = "Manager Email Address is Required"; } else if (SCARFSurveyModel.StatusText.Length > 300) { SCARFSurveyModel.IsErrrorMsg = true; SCARFSurveyModel.Message = "StatusText length exceeded."; } else if (SCARFSurveyModel.CertaintyText.Length > 300) { SCARFSurveyModel.IsErrrorMsg = true; SCARFSurveyModel.Message = "CertaintyText length exceeded."; } else if (SCARFSurveyModel.AutonomyText.Length > 300) { SCARFSurveyModel.IsErrrorMsg = true; SCARFSurveyModel.Message = "AutonomyText length exceeded."; } else if (SCARFSurveyModel.RelatednessText.Length > 300) { SCARFSurveyModel.IsErrrorMsg = true; SCARFSurveyModel.Message = "RelatednessText length exceeded."; } else if (SCARFSurveyModel.FairnessText.Length > 300) { SCARFSurveyModel.IsErrrorMsg = true; SCARFSurveyModel.Message = "FairnessText length exceeded."; } if (SCARFSurveyModel.IsErrrorMsg == false) { SCARFSurveyModel.SCARFSurveyId = 0; OnjSCARFSurvey.WorkDayId = SCARFSurveyModel.WorkDayId; OnjSCARFSurvey.LearnerName = SCARFSurveyModel.LearnerName; OnjSCARFSurvey.managerName = SCARFSurveyModel.managerName; OnjSCARFSurvey.managerEmailID = SCARFSurveyModel.managerEmailID; OnjSCARFSurvey.Status = SCARFSurveyModel.Status; OnjSCARFSurvey.StatusText = SCARFSurveyModel.StatusText; OnjSCARFSurvey.Certainty = SCARFSurveyModel.Certainty; OnjSCARFSurvey.CertaintyText = SCARFSurveyModel.CertaintyText; OnjSCARFSurvey.Autonomy = SCARFSurveyModel.Autonomy; OnjSCARFSurvey.AutonomyText = SCARFSurveyModel.AutonomyText; OnjSCARFSurvey.Relatedness = SCARFSurveyModel.Relatedness; OnjSCARFSurvey.RelatednessText = SCARFSurveyModel.RelatednessText; OnjSCARFSurvey.Fairness = SCARFSurveyModel.Fairness; OnjSCARFSurvey.FairnessText = SCARFSurveyModel.FairnessText; int result = BCBSDataAccess.SaveDataSCARFSurvey(OnjSCARFSurvey); Util.LogInfo("Post", "After dsave call :" + result); if (result > 0) { SCARFSurveyModel.SCARFSurveyId = result; SCARFSurveyModel.IsErrrorMsg = false; SCARFSurveyModel.Message = "Sucess"; var model = BCBSDataAccess.GetSCARFSurveyDataForPDF(SCARFSurveyModel.SCARFSurveyId); if (model != null) { model.managerName = OnjSCARFSurvey.managerName; string html = RenderViewToString("SCARFSurveyAnswer", "~/views/Shared/_SCARFSurveyAnswerPDF.cshtml", model); model.ReportDate = model.ReportDate; byte[] buffer = Render(html); using (MemoryStream stream = new System.IO.MemoryStream()) { Document pdfDoc = new Document(PageSize.A4, 20f, 20f, 20f, 20f); PdfWriter writer = PdfWriter.GetInstance(pdfDoc, stream); writer.CloseStream = false; pdfDoc.Open(); StringReader sr = new StringReader(html); XMLWorkerHelper.GetInstance().ParseXHtml(writer, pdfDoc, sr); pdfDoc.Close(); buffer = stream.ToArray(); Attachment AttachmentMemoryStream = new Attachment(new MemoryStream(buffer), "SCARFSurveyAnswer" + SCARFSurveyModel.SCARFSurveyId + ".PDF"); //File Write in Folder With Out Mail //string FilePathandName = @"C:\Logs\" + "SCARFSurveyAnswer" + SCARFSurveyModel.SCARFSurveyId + ".PDF"; //File.WriteAllBytes(FilePathandName, buffer); #region Mail Sending var subject = ConfigurationManager.AppSettings["MailSubject"] + model.LearnerName; var physicalPath = Util.ResolveFileName(@"Template\EmailTemplate.txt"); var content = File.ReadAllText(physicalPath); string emailContent = content.Replace("@LearnerName", model.LearnerName).Replace("@ManagerName", model.managerName); Util.SendMail(OnjSCARFSurvey.managerEmailID, subject, emailContent, AttachmentMemoryStream); } #endregion } SCARFSurveyModel.WorkDayId = ""; SCARFSurveyModel.LearnerName = ""; SCARFSurveyModel.managerName = ""; SCARFSurveyModel.managerEmailID = ""; SCARFSurveyModel.Status = ""; SCARFSurveyModel.StatusText = ""; SCARFSurveyModel.Certainty = ""; SCARFSurveyModel.CertaintyText = ""; SCARFSurveyModel.Autonomy = ""; SCARFSurveyModel.AutonomyText = ""; SCARFSurveyModel.Relatedness = ""; SCARFSurveyModel.RelatednessText = ""; SCARFSurveyModel.Fairness = ""; SCARFSurveyModel.FairnessText = ""; } else if (result == -1) { SCARFSurveyModel.SCARFSurveyId = 0; SCARFSurveyModel.IsErrrorMsg = true; SCARFSurveyModel.Message = "Duplicate WorkDayId"; SCARFSurveyModel.WorkDayId = ""; SCARFSurveyModel.LearnerName = ""; SCARFSurveyModel.managerName = ""; SCARFSurveyModel.managerEmailID = ""; SCARFSurveyModel.Status = ""; SCARFSurveyModel.StatusText = ""; SCARFSurveyModel.Certainty = ""; SCARFSurveyModel.CertaintyText = ""; SCARFSurveyModel.Autonomy = ""; SCARFSurveyModel.AutonomyText = ""; SCARFSurveyModel.Relatedness = ""; SCARFSurveyModel.RelatednessText = ""; SCARFSurveyModel.Fairness = ""; } else { SCARFSurveyModel.SCARFSurveyId = 0; SCARFSurveyModel.IsErrrorMsg = true; SCARFSurveyModel.Message = "Fail"; } SCARFSurveyModel.WorkDayId = OnjSCARFSurvey.WorkDayId; SCARFSurveyModel.managerName = OnjSCARFSurvey.managerName; SCARFSurveyModel.LearnerName = OnjSCARFSurvey.LearnerName; SCARFSurveyModel.managerEmailID = OnjSCARFSurvey.managerEmailID; SCARFSurveyModel.Status = OnjSCARFSurvey.Status; SCARFSurveyModel.StatusText = OnjSCARFSurvey.StatusText; SCARFSurveyModel.Certainty = OnjSCARFSurvey.Certainty; SCARFSurveyModel.CertaintyText = OnjSCARFSurvey.CertaintyText; SCARFSurveyModel.Autonomy = OnjSCARFSurvey.Autonomy; SCARFSurveyModel.AutonomyText = OnjSCARFSurvey.AutonomyText; SCARFSurveyModel.Relatedness = OnjSCARFSurvey.Relatedness; SCARFSurveyModel.RelatednessText = OnjSCARFSurvey.RelatednessText; SCARFSurveyModel.Fairness = OnjSCARFSurvey.Fairness; SCARFSurveyModel.FairnessText = OnjSCARFSurvey.FairnessText; SCARFSurveyModel.ReportDate = OnjSCARFSurvey.ReportDate; } } catch (Exception ex) { string DetailsMessageError = null; if (ex.InnerException != null) { DetailsMessageError = ex.InnerException.Message + " " + ex.StackTrace; } else { DetailsMessageError = ex.StackTrace; } Util.LoggError(new System.Diagnostics.StackFrame(0).GetMethod().Name, ex.Message, DetailsMessageError); SCARFSurveyModel.IsErrrorMsg = true; SCARFSurveyModel.Message = "Exception block: " + DetailsMessageError; } return(SCARFSurveyModel); }
public ActionResult Login(UserMst model, string returnUrl) { List <UserMst> courseModelList = null; try { courseModelList = BCBSDataAccess.GetUserInfoById(model); if (courseModelList != null && courseModelList.Count > 0) { foreach (var item in courseModelList) { if (item.LoginIsActive == true) { UserMst TempLocation = new UserMst(); Session["LoginUserId"] = item.LoginUserId; TempLocation.LoginUserId = item.LoginUserId; TempLocation.LoginUserName = item.LoginUserName; TempLocation.LoginPassword = item.LoginPassword; TempLocation.LoginEmail = item.LoginEmail; TempLocation.LoginFirstName = item.LoginFirstName; TempLocation.LoginLastName = item.LoginLastName; TempLocation.LoginIsActive = item.LoginIsActive; courseModelList.Add(TempLocation); Util.LogInfo("Login", "Successfully Login : "******"Index", "U65Report"); return(RedirectToAction("Index", "SalesReport")); } else { Session["LoginUserId"] = null; Session.Abandon(); Util.LogInfo("Login", "User is In-Active. Please contact Administrator : " + item.LoginUserName); ViewBag.ErrorMessage = "User is In-Active. Please contact Administrator"; } } } else { Session["LoginUserId"] = null; Session.Abandon(); ViewBag.ErrorMessage = "Incorrect user name/password."; return(View()); } } catch (Exception ex) { string DetailsMessageError = null; if (ex.InnerException != null) { DetailsMessageError = ex.InnerException.Message + " " + ex.StackTrace; } else { DetailsMessageError = ex.StackTrace; } Util.LoggError(new System.Diagnostics.StackFrame(0).GetMethod().Name, ex.Message, DetailsMessageError); } return(View()); }
public ActionResult SalesExportData() { MemoryStream memoryStream = null; List <SalesCertificate> SalessModelList = null; const string header = "Workday ID, Learner Name,Completion Status,Report Date,Pre-Assm Result,Pre-Assm Score %, Post-Assm Attempt,Post-Assm Result,Post-Assm Score %,Pre-Q01, Pre-Q02, Pre-Q03, Pre-Q04, Pre-Q05, Pre-Q06, Pre-Q07, Pre-Q08, Pre-Q09, Pre-Q10, Pre-Q11, Pre-Q12, Pre-Q13, Pre-Q14, Pre-Q15, Pre-Q16, Pre-Q17, Pre-Q18, Pre-Q19, Pre-Q20, Pre-Q21, Pre-Q22, Pre-Q23, Pre-Q24, Pre-Q25, Post-Q01, Post-Q02, Post-Q03, Post-Q04, Post-Q05, Post-Q06, Post-Q07, Post-Q08, Post-Q09, Post-Q10, Post-Q11, Post-Q12, Post-Q13, Post-Q14, Post-Q15, Post-Q16, Post-Q17, Post-Q18, Post-Q19, Post-Q20, Post-Q21, Post-Q22, Post-Q23, Post-Q24, Post-Q25"; const string format = "{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19},{20},{21},{22},{23},{24},{25},{26},{27},{28},{29},{30},{31},{32},{33},{34},{35},{36},{37},{38},{39},{40},{41},{42},{43},{44},{45},{46},{47},{48},{49},{50},{51},{52},{53},{54},{55},{56},{57},{58}"; string content = string.Empty; SalessModelList = BCBSDataAccess.GetDataForSales(); memoryStream = new MemoryStream(); if (SalessModelList != null && SalessModelList.Count > 0) { TextWriter tw = new StreamWriter(memoryStream); tw.WriteLine(header); foreach (var item in SalessModelList) { item.WorkDayId = !String.IsNullOrEmpty(item.WorkDayId) ? (item.WorkDayId.Contains(",") ? item.WorkDayId.Replace(',', '|') : item.WorkDayId) : string.Empty; item.LearnerName = !String.IsNullOrEmpty(item.LearnerName) ? (item.LearnerName.Contains(",") ? item.LearnerName.Replace(',', '|') : item.LearnerName) : string.Empty; item.CompletionStatusString = !String.IsNullOrEmpty(item.CompletionStatusString) ? (item.CompletionStatusString.Contains(",") ? item.CompletionStatusString.Replace(',', '|') : item.CompletionStatusString) : string.Empty; item.ReportDateString = item.ReportDate.ToString("MM/dd/yyyy"); item.PreAssmResultString = !String.IsNullOrEmpty(item.PreAssmResultString) ? (item.PreAssmResultString.Contains(",") ? item.PreAssmResultString.Replace(',', '|') : item.PreAssmResultString) : string.Empty; item.PreAssmScore = item.PreAssmScore; //item.PostAssmAttempt = item.PostAssmAttempt; item.PostAssmResult = item.PostAssmResult; if (item.PostAssmAttempt == 0) { item.PostAssmAttemptString = "NA"; } else { item.PostAssmAttemptString = item.PostAssmAttempt.ToString(); } if (item.PostAssmAttempt == 0) { item.PostAssmResultString = "NA"; } else { item.PostAssmResultString = !String.IsNullOrEmpty(item.PostAssmResultString) ? (item.PostAssmResultString.Contains(",") ? item.PostAssmResultString.Replace(',', '|') : item.PostAssmResultString) : string.Empty; } item.PostAssmScore = item.PostAssmScore; item.Pre_Q01 = item.Pre_Q01; item.Pre_Q02 = item.Pre_Q02; item.Pre_Q03 = item.Pre_Q03; item.Pre_Q03 = item.Pre_Q03; item.Pre_Q04 = item.Pre_Q04; item.Pre_Q05 = item.Pre_Q05; item.Pre_Q06 = item.Pre_Q06; item.Pre_Q07 = item.Pre_Q07; item.Pre_Q08 = item.Pre_Q08; item.Pre_Q09 = item.Pre_Q09; item.Pre_Q10 = item.Pre_Q10; item.Pre_Q11 = item.Pre_Q11; item.Pre_Q12 = item.Pre_Q12; item.Pre_Q13 = item.Pre_Q13; item.Pre_Q14 = item.Pre_Q14; item.Pre_Q15 = item.Pre_Q15; item.Pre_Q16 = item.Pre_Q16; item.Pre_Q17 = item.Pre_Q17; item.Pre_Q18 = item.Pre_Q18; item.Pre_Q19 = item.Pre_Q19; item.Pre_Q20 = item.Pre_Q20; item.Pre_Q21 = item.Pre_Q21; item.Pre_Q22 = item.Pre_Q22; item.Pre_Q23 = item.Pre_Q23; item.Pre_Q24 = item.Pre_Q24; item.Pre_Q25 = item.Pre_Q25; item.Post_Q01 = item.Post_Q01; item.Post_Q02 = item.Post_Q02; item.Post_Q03 = item.Post_Q03; item.Post_Q04 = item.Post_Q04; item.Post_Q05 = item.Post_Q05; item.Post_Q06 = item.Post_Q06; item.Post_Q07 = item.Post_Q07; item.Post_Q08 = item.Post_Q08; item.Post_Q09 = item.Post_Q09; item.Post_Q10 = item.Post_Q10; item.Post_Q11 = item.Post_Q11; item.Post_Q12 = item.Post_Q12; item.Post_Q13 = item.Post_Q13; item.Post_Q14 = item.Post_Q14; item.Post_Q15 = item.Post_Q15; item.Post_Q16 = item.Post_Q16; item.Post_Q17 = item.Post_Q17; item.Post_Q18 = item.Post_Q18; item.Post_Q19 = item.Post_Q19; item.Post_Q20 = item.Post_Q20; item.Post_Q21 = item.Post_Q21; item.Post_Q22 = item.Post_Q22; item.Post_Q23 = item.Post_Q23; item.Post_Q24 = item.Post_Q24; item.Post_Q25 = item.Post_Q25; content = string.Format(format, item.WorkDayId, item.LearnerName, item.CompletionStatusString, item.ReportDateString, item.PreAssmResultString, item.PreAssmScore, item.PostAssmAttemptString, item.PostAssmResultString, item.PostAssmScore, item.Pre_Q01, item.Pre_Q02, item.Pre_Q03, item.Pre_Q04, item.Pre_Q05, item.Pre_Q06, item.Pre_Q07, item.Pre_Q08, item.Pre_Q09, item.Pre_Q10, item.Pre_Q11, item.Pre_Q12, item.Pre_Q13, item.Pre_Q14, item.Pre_Q15, item.Pre_Q16, item.Pre_Q17, item.Pre_Q18, item.Pre_Q19, item.Pre_Q20, item.Pre_Q21, item.Pre_Q22, item.Pre_Q23, item.Pre_Q24, item.Pre_Q25, item.Post_Q01, item.Post_Q02, item.Post_Q03, item.Post_Q04, item.Post_Q05, item.Post_Q06, item.Post_Q07, item.Post_Q08, item.Post_Q09, item.Post_Q10, item.Post_Q11, item.Post_Q12, item.Post_Q13, item.Post_Q14, item.Post_Q15, item.Post_Q16, item.Post_Q17, item.Post_Q18, item.Post_Q19, item.Post_Q20, item.Post_Q21, item.Post_Q22, item.Post_Q23, item.Post_Q24, item.Post_Q25); tw.WriteLine(content); } tw.Flush(); } string contentType = "application/octet-stream"; byte[] pdfdata = null; pdfdata = memoryStream.ToArray(); var filaName = (ConfigurationManager.AppSettings["ProjectName"]); var Datetime = ""; Datetime = DateTime.Now.ToString("dd_MM_yyyy_T_HH:mm"); return(File(pdfdata, contentType, filaName + "_ExportData_" + Datetime + ".csv")); }