// GET: PCPSurvey public ActionResult Index(string surveyCode) { if (!string.IsNullOrEmpty(surveyCode)) { var surveyDto = _serviceSurvey.GetBySurveyCode(surveyCode); if (surveyDto == null ) { ViewBag.Message = Messages.GetMessage(Messages.MessageType.NotExist); return View("../Message/Message"); } if (surveyDto != null && surveyDto.SurveyType != Core.Common.SurveyType.PCP) { return RedirectToAction("Index", "Survey", new { surveyCode = surveyCode }); } if (surveyDto != null && surveyDto.IsComplete) { ViewBag.Message = Messages.GetMessage(Messages.MessageType.Completed, surveyDto.ProviderLastName, surveyDto.FacilityName); return View("../Message/Message"); } if (surveyDto != null && surveyDto.IsExpired) { ViewBag.Message = Messages.GetMessage(Messages.MessageType.Expired, surveyDto.ProviderLastName, surveyDto.FacilityName); return View("../Message/Message"); } if (surveyDto != null) { var questionsDto = _serviceQuestion.GetBySurveyType(surveyDto.SurveyType); PCPSurvey pcpSurvey = new PCPSurvey(surveyDto); var props = pcpSurvey.GetType().GetProperties(BindingFlags.Public | BindingFlags.Instance).ToList(); props.ForEach(prop => { if (prop.PropertyType == typeof(Question)) { var attr = prop.GetCustomAttribute<QuestionKeyAttribute>(); var question = new Question(); if(questionsDto != null && questionsDto.Count > 0) { var questionDto = questionsDto.First(d => d.Key.Equals(attr.QuestionKey)); if(questionDto != null) { question.QuestionText = questionDto.QuestionText; } } prop.SetValue(pcpSurvey, question); } }); return View(pcpSurvey); } } return null;// View("../Message/Message"); }
public ActionResult Index(PCPSurvey pcpSurvey) { if (ModelState.IsValid) { var surveyDto = _serviceSurvey.GetBySurveyCode(pcpSurvey.Survey.SurveyCode); bool isEscalationReport = false; if (surveyDto != null && !surveyDto.IsComplete && !surveyDto.IsExpired) { List<AnswerDto> answerList = new List<AnswerDto>(); var questionsDto = _serviceQuestion.GetBySurveyType(surveyDto.SurveyType); var props = pcpSurvey.GetType().GetProperties(BindingFlags.Public | BindingFlags.Instance).ToList(); var surveyAnswerDto = new SurveyAnswerDto() { SurveyId = pcpSurvey.Survey.Id, RespondDate = DateTime.Today }; surveyAnswerDto = _serviceSurveyAnswer.Insert(surveyAnswerDto); props.ForEach(prop => { if (prop.PropertyType == typeof(Question)) { var attr = prop.GetCustomAttribute<QuestionKeyAttribute>(); var question = questionsDto.First(d => d.Key.Equals(attr.QuestionKey)); var answer = new AnswerDto() { SurveyAnswerId = surveyAnswerDto.Id, QuestionId = question.Id, ResponseText = ((Question)prop.GetValue(pcpSurvey, null)).Response, Note = ((Question)prop.GetValue(pcpSurvey, null)).Note }; answerList.Add(answer); //To know if Disagre or Strongly Disagree was selected as an answer, for send an email if ((answer.ResponseText != null) && QuestionKey.PCPSurvey.ContainsKey(question.Key)) { if (answer.ResponseText.ToLower().Equals("disagree") || answer.ResponseText.ToLower().Equals("strongly disagree")) isEscalationReport = true; } } }); //Add answer _serviceAnswer.Insert(answerList); _serviceSurvey.UpdateComplete(pcpSurvey.Survey.Id); ViewBag.Message = Messages.GetMessage(Messages.MessageType.Succefully); //Send Email To Performance Management if (isEscalationReport) { HospitalDetailsDto hospitalDetails = _serviceSurvey.GetHospitalDetailsByName(pcpSurvey.Survey.FacilityName); byte[] fileToSend = GetDataToExportPCPSurvey(pcpSurvey, hospitalDetails); _emailSender.SendEmail(fileToSend, ConfigurationManager.AppSettings["PerformanceManagementEmail"].ToString()); } return View("../Message/Message"); } if (surveyDto != null && surveyDto.IsComplete) { ViewBag.Message = Messages.GetMessage(Messages.MessageType.Completed, surveyDto.ProviderLastName, surveyDto.FacilityName); return View("../Message/Message"); } } return View(pcpSurvey); }
public byte[] GetDataToExportPCPSurvey(PCPSurvey pcpSurvey, HospitalDetailsDto hospitalDetails) { string fileName = @"C:\Escalation_PCP_Report_" + Guid.NewGuid() + ".xlsx"; var configureCells = new ConfigureEscalationReport(); var workbook = new XLWorkbook(); var worksheet = workbook.Worksheets.Add("Survey Escalation Report"); configureCells.ConfigureCell(worksheet, pcpSurvey.Survey.SurveyType); #region Headers worksheet.Cell("A1").Value = "Survey Type"; worksheet.Cell("B1").Value = "Region"; worksheet.Cell("C1").Value = "Site"; worksheet.Cell("D1").Value = "Site #"; worksheet.Cell("E1").Value = "Provider Last Name"; worksheet.Cell("F1").Value = "Provider First Name"; worksheet.Cell("G1").Value = "Date of Survey"; worksheet.Cell("H1").Value = pcpSurvey.Question2A.QuestionText; worksheet.Cell("I1").Value = pcpSurvey.Question2B.QuestionText; worksheet.Cell("J1").Value = pcpSurvey.Question2C.QuestionText; worksheet.Cell("K1").Value = pcpSurvey.Question2D.QuestionText; worksheet.Cell("L1").Value = pcpSurvey.Question2E.QuestionText; worksheet.Cell("M1").Value = pcpSurvey.Question2F.QuestionText; worksheet.Cell("N1").Value = pcpSurvey.Question2G.QuestionText; worksheet.Cell("O1").Value = pcpSurvey.Question2H.QuestionText; worksheet.Cell("P1").Value = pcpSurvey.Question2Why.QuestionText; #endregion #region Rows // write some values into column 2 worksheet.Cell("A2").Value = "PCP"; worksheet.Cell("B2").Value = hospitalDetails.RegionName; worksheet.Cell("C2").Value = pcpSurvey.Survey.FacilityName; worksheet.Cell("D2").Value = hospitalDetails.SiteNumber; worksheet.Cell("E2").Value = pcpSurvey.Survey.ProviderLastName; worksheet.Cell("F2").Value = pcpSurvey.Survey.ProviderFirstName; worksheet.Cell("G2").Value = DateTime.Now.ToString("MM/dd/yyyy"); worksheet.Cell("H2").Value = pcpSurvey.Question2A.Response; worksheet.Cell("I2").Value = pcpSurvey.Question2B.Response; worksheet.Cell("J2").Value = pcpSurvey.Question2C.Response; worksheet.Cell("K2").Value = pcpSurvey.Question2D.Response; worksheet.Cell("L2").Value = pcpSurvey.Question2E.Response; worksheet.Cell("M2").Value = pcpSurvey.Question2F.Response; worksheet.Cell("N2").Value = pcpSurvey.Question2G.Response; worksheet.Cell("O2").Value = pcpSurvey.Question2H.Response; worksheet.Cell("P2").Value = pcpSurvey.Question2Why.Response; #endregion workbook.SaveAs(fileName); var bytes = System.IO.File.ReadAllBytes(fileName); System.IO.FileInfo newFile = new System.IO.FileInfo(fileName); if (newFile.Exists) newFile.Delete(); return bytes; }