public T1 GetView(ApplicationDbContext db)
{
SurveyUserData model = Parameters as SurveyUserData;
SurveyUserDataReturn surveyUserDataReturn = new SurveyUserDataReturn();
SurveyPart surveyPart = new SurveyPart();
int id = StringToValue.ParseInt(model.Id);
surveyPart = db.T_SurveyPart.Where(sp => sp.SurveyId == id).FirstOrDefault();
SurveyPartTemplate surveyPartTemplate = db.T_SurveyPartTemplate.Find(surveyPart.SurveyPartTemplateId);
surveyUserDataReturn.TotalSections = db.T_SurveyPart.Where(sp => sp.SurveyId == id).Count();
surveyUserDataReturn.TotalQuestions = db.T_SurveyPart
.Join(db.T_SurveyQuestion,
sp => sp.Id, sq => sq.SurveyPartId,
(sp, sq) => sp).Where(sp => sp.SurveyId == id).Count();
surveyUserDataReturn.TotalSectionQuestions = db.T_SurveyQuestion.Where(sq => sq.SurveyPartId == surveyPart.Id).Count();
surveyUserDataReturn.SectionName = surveyPartTemplate.Name;
surveyUserDataReturn.SectionTitle = surveyPartTemplate.SummaryTitle;
surveyUserDataReturn.SectionId = surveyPart.Id;
surveyUserDataReturn.QuestionId = 0;
surveyUserDataReturn.SectionNo = db.T_SurveyPart.Where(sp => sp.SurveyId == id && sp.Id <= surveyPart.Id).Count();
return(surveyUserDataReturn as T1);
}
public T1 GetView(ApplicationDbContext db)
{
SurveyUserData model = Parameters as SurveyUserData;
SurveyUserDataReturn surveyUserDataReturn = new SurveyUserDataReturn();
int id = StringToValue.ParseInt(model.Id);
int surveyPartId = StringToValue.ParseInt(model.SectionId);
int surveyQuestionId = StringToValue.ParseInt(model.QuestionId);
SurveyPart surveyPart = db.T_SurveyPart.Where(sp => sp.SurveyId == id && sp.Id == surveyPartId).FirstOrDefault();
List <SurveyQuestion> surveyQuestions = db.T_SurveyQuestion.Where(sq => sq.SurveyPartId == surveyPart.Id && sq.Id < surveyQuestionId).ToList();
SurveyQuestion surveyQuestion = surveyQuestions[surveyQuestions.Count() - 1];
SurveyPartTemplate surveyPartTemplate = db.T_SurveyPartTemplate.Find(surveyPart.SurveyPartTemplateId);
SurveyQuestionTemplate surveyQuestionTemplate = db.T_SurveyQuestionTemplate.Find(surveyQuestion.SurveyQuestionTemplateId);
surveyUserDataReturn.TotalSections = db.T_SurveyPart.Where(sp => sp.SurveyId == id).Count();
surveyUserDataReturn.TotalQuestions = db.T_SurveyPart
.Join(db.T_SurveyQuestion,
sp => sp.Id, sq => sq.SurveyPartId,
(sp, sq) => sp).Where(sp => sp.SurveyId == id).Count();
surveyUserDataReturn.TotalSectionQuestions = db.T_SurveyQuestion.Where(sq => sq.SurveyPartId == surveyPart.Id).Count();
surveyUserDataReturn.QuestionSectionNo = db.T_SurveyQuestion.Where(sq => sq.SurveyPartId == surveyPart.Id && sq.Id <= surveyQuestion.Id).Count();
surveyUserDataReturn.SectionName = surveyPartTemplate.Name;
surveyUserDataReturn.SectionTitle = surveyPartTemplate.SummaryTitle;
surveyUserDataReturn.SectionId = surveyPart.Id;
surveyUserDataReturn.QuestionId = surveyQuestion.Id;
surveyUserDataReturn.QuestionName = surveyQuestionTemplate.Name;
surveyUserDataReturn.QuestionDescription = surveyQuestionTemplate.Definition;
surveyUserDataReturn.QuestionType = surveyQuestionTemplate.QuestionType;
surveyUserDataReturn.QuestionEmployeeScore = surveyQuestion.EmployeeScore;
surveyUserDataReturn.QuestionEmployeeComment = surveyQuestion.EmployeeComment;
surveyUserDataReturn.SectionNo = db.T_SurveyPart.Where(sp => sp.SurveyId == id && sp.Id <= surveyPart.Id).Count();
return(surveyUserDataReturn as T1);
}
public JsonResult SectionHeaderView(SurveyUserData model)
{
IPrepareExtendedView <SurveyUserDataReturn, SurveyUserData> prepareStartSurveyView = new PrepareSectionHeaderView <SurveyUserDataReturn, SurveyUserData>();
prepareStartSurveyView.Parameters = model;
SurveyUserDataReturn surveyUserDataReturn = prepareStartSurveyView.GetView(_db);
return(getResult(surveyUserDataReturn));
}
public JsonResult FirstSectionQuestionView(SurveyUserData model)
{
IPrepareExtendedView <SurveyUserDataReturn, SurveyUserData> prepareExtendedView = new PrepareSectionPrevQuestionView <SurveyUserDataReturn, SurveyUserData>();
prepareExtendedView.Parameters = model;
SurveyUserDataReturn surveyUserDataReturn = prepareExtendedView.GetView(_db);
return(getResult(surveyUserDataReturn));
}
private JsonResult getResult(SurveyUserDataReturn surveyUserDataReturn)
{
return(Json(new
{
success = true,
result = "OK",
surveyUserDataReturn = surveyUserDataReturn,
JsonRequestBehavior.AllowGet
}));
}
public JsonResult SectionHeader(SurveyUserData model)
{
ISaveModel <SurveyUserData> saveEmployeeSurveyScore = new SaveEmployeeSurveyScore <SurveyUserData>();
saveEmployeeSurveyScore.Save(model, _db);
IPrepareExtendedView <SurveyUserDataReturn, SurveyUserData> prepareStartSurveyView = new PrepareSectionHeaderView <SurveyUserDataReturn, SurveyUserData>();
prepareStartSurveyView.Parameters = model;
SurveyUserDataReturn surveyUserDataReturn = prepareStartSurveyView.GetView(_db);
return(getResult(surveyUserDataReturn));
}
public JsonResult CompleteSurveyn(SurveyUserData model)
{
ISaveModel <SurveyUserData> saveEmployeeSurveyScore = new SaveEmployeeSurveyScore <SurveyUserData>();
saveEmployeeSurveyScore.Save(model, _db);
ISaveModel <SurveyUserData> saveEmployeeSurveyComplete = new SaveEmployeeSurveyComplete <SurveyUserData>();
saveEmployeeSurveyComplete.Save(model, _db);
SurveyUserDataReturn surveyUserDataReturn = new SurveyUserDataReturn();
return(getResult(surveyUserDataReturn));
}
