// 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;
}
