public bool SaveSurvey(List <SurveyTakenModel> lst, SurveyCompledModel _model)
{
bool flag = false;
try
{
using (LBCData context = new LBCData(ConnectionHelper.getConnectionString()))
{
foreach (var item in lst)
{
LBC_SURVEY_TAKEN _survey = new LBC_SURVEY_TAKEN()
{
STARS_ID = item.STARS_ID,
SURVEY_ID = item.SURVEY_ID,
QUESTION_ID = item.QUESTION_ID,
ANSWER_ID = item.ANSWER_ID,
ANSWER_MSG = item.ANSWER_MSG,
CREATED_BY = item.CREATED_BY,
CREATED_DATE = DateTime.Now
};
context.LBC_SURVEY_TAKEN.Add(_survey);
}
LBC_SURVERY_COMPLETED _survey_completed = new LBC_SURVERY_COMPLETED()
{
COMPLETED_DATE = DateTime.Now,
SURVEY_ID = _model.SURVEY_ID,
STARS_ID = _model.STARS_ID,
PA_CODE = _model.PA_CODE,
CREATED_DATE = _model.CREATED_DATE,
CREATED_BY = _model.CREATED_BY
};
context.LBC_SURVERY_COMPLETED.Add(_survey_completed);
context.SaveChanges();
flag = true;
}
}
catch (Exception ex)
{
flag = false;
}
return(flag);
}
//public List<SurveyQuestionModel> GetReportQuestions()
//{
// SurveyRepository _survey = new SurveyRepository();
// return _survey.GetReportQuestions();
//}
public bool SaveSurvey(List <SurveyTakenModel> lst, SurveyCompledModel _model)
{
SurveyRepository _survey = new SurveyRepository();
return(_survey.SaveSurvey(lst, _model));
}
public ActionResult Survey(FormCollection frm)
{
SurveyBL _surBL = new SurveyBL();
decimal surveyId = 1; // Make sure you get the Survey Id from the table or session
List <SurveyQuestionModel> lstQuestions = _surBL.getQuestions(surveyId);
List <SurveyTakenModel> lst = new List <SurveyTakenModel>();
var starsId = Session["StarsIdProfile"].ToString();
var pacode = Session["w_pacode"].ToString();
var wslx = Session["w_user"].ToString();
for (int i = 0; i <= frm.Count - 1; i++)
{
string type = "";
//string test1 = frm.GetValue(Convert.ToString(frm[i])).AttemptedValue;
// string[] arr1 = frm.GetValues(i);
foreach (var item in lstQuestions)
{
if (item.QUESTION_ID == Convert.ToDecimal(frm.GetKey(i)))
{
type = item.QUESTION_TYPE;
break;
}
}
if (type == "FI")
{
string[] arr = frm.GetValue(Convert.ToString(frm.GetKey(i))).AttemptedValue.Split(',');
lst.Add(new SurveyTakenModel()
{
STARS_ID = starsId,
SURVEY_ID = surveyId,
QUESTION_ID = Convert.ToDecimal(frm.GetKey(i).ToString()),
ANSWER_ID = 1,
ANSWER_MSG = arr[0].ToString(),
CREATED_BY = wslx
});
}
else if (type == "MS")
{
string[] arr = frm.GetValue(Convert.ToString(frm.GetKey(i))).AttemptedValue.Split(',');
if (arr.Count() > 0)
{
for (int j = 0; j <= arr.Count() - 1; j = j + 2)
{
lst.Add(new SurveyTakenModel()
{
STARS_ID = starsId,
SURVEY_ID = surveyId,
QUESTION_ID = Convert.ToDecimal(arr[j].ToString()),
ANSWER_ID = Convert.ToDecimal(arr[j + 1].ToString()),
ANSWER_MSG = string.Empty,
CREATED_BY = wslx
});
}
}
}
else
{
string[] arr = frm.GetValue(Convert.ToString(frm.GetKey(i))).AttemptedValue.Split(',');
lst.Add(new SurveyTakenModel()
{
STARS_ID = starsId,
SURVEY_ID = surveyId,
QUESTION_ID = Convert.ToDecimal(arr[0].ToString()),
ANSWER_ID = Convert.ToDecimal(arr[1].ToString()),
ANSWER_MSG = string.Empty,
CREATED_BY = wslx
});
}
}
SurveyCompledModel _surveyModel = new SurveyCompledModel();
_surveyModel.COMPLETED_DATE = DateTime.Now;
_surveyModel.PA_CODE = pacode;
_surveyModel.STARS_ID = starsId;
_surveyModel.SURVEY_ID = surveyId;
_surveyModel.CREATED_DATE = DateTime.Now;
_surveyModel.CREATED_BY = wslx;
if (_surBL.SaveSurvey(lst, _surveyModel))
{
return(RedirectToAction("Confirmation", "Resources"));
}
return(RedirectToAction("Survey", "Resources"));
//return RedirectToAction("Welcome", "LBC");
}
