public ResultAnswers(AnswerTable answerTable)
{
id = answerTable.id;
Answers = new bool[28];
Answers[0] = answerTable.Answer1;
Answers[1] = answerTable.Answer2;
Answers[2] = answerTable.Answer3;
Answers[3] = answerTable.Answer4;
Answers[4] = answerTable.Answer5;
Answers[5] = answerTable.Answer6;
Answers[6] = answerTable.Answer7;
Answers[7] = answerTable.Answer8;
Answers[8] = answerTable.Answer9;
Answers[9] = answerTable.Answer10;
Answers[10] = answerTable.Answer11;
Answers[11] = answerTable.Answer12;
Answers[12] = answerTable.Answer13;
Answers[13] = answerTable.Answer14;
Answers[14] = answerTable.Answer15;
Answers[15] = answerTable.Answer16;
Answers[16] = answerTable.Answer17;
Answers[17] = answerTable.Answer18;
Answers[18] = answerTable.Answer19;
Answers[19] = answerTable.Answer20;
Answers[20] = answerTable.Answer21;
Answers[21] = answerTable.Answer22;
Answers[22] = answerTable.Answer23;
Answers[23] = answerTable.Answer24;
Answers[24] = answerTable.Answer25;
Answers[25] = answerTable.Answer26;
Answers[26] = answerTable.Answer27;
Answers[27] = answerTable.Answer28;
}
public ActionResult SurveyQuestion(List <QuestionViewModel> list)
{
surveyEntities entity = new surveyEntities();
List <AnswerTable> objectTable = new List <AnswerTable>();
try
{
foreach (var questionData in list)
{
AnswerTable obj = new AnswerTable();
obj.Question_ID = questionData.Question_ID;
obj.SelectedAnswer = questionData.SelectedAnswer;
obj.User_ID = 1027;
obj.Survey_ID = 1;
objectTable.Add(obj);
}
}
catch
{
return(View(list));
}
foreach (var item in objectTable)
{
entity.AnswerTables.Add(item);
entity.SaveChanges();
}
return(View());
}
public Task <string> SaveToDB(ResultModel result) //int[] groupAnswers, int[] arrayAnswers, string currentTime)
{
_groupAnswers = result.GroupOfAnswers;
try
{
using (var socionicEntities = new SocionicEntities())
{
var answerBools = result.ArrayAnswers.Select(i => i != 0).ToArray();
var last = socionicEntities.Results.ToList().Last();
var answerTable = new AnswerTable
{
id = last.ID + 1,
Answer1 = answerBools[0],
Answer2 = answerBools[1],
Answer3 = answerBools[2],
Answer4 = answerBools[3],
Answer5 = answerBools[4],
Answer6 = answerBools[5],
Answer7 = answerBools[6],
Answer8 = answerBools[7],
Answer9 = answerBools[8],
Answer10 = answerBools[9],
Answer11 = answerBools[10],
Answer12 = answerBools[11],
Answer13 = answerBools[12],
Answer14 = answerBools[13],
Answer15 = answerBools[14],
Answer16 = answerBools[15],
Answer17 = answerBools[16],
Answer18 = answerBools[17],
Answer19 = answerBools[18],
Answer20 = answerBools[19],
Answer21 = answerBools[20],
Answer22 = answerBools[21],
Answer23 = answerBools[22],
Answer24 = answerBools[23],
Answer25 = answerBools[24],
Answer26 = answerBools[25],
Answer27 = answerBools[26],
Answer28 = answerBools[27]
};
var results = new Results
{
ID = last.ID + 1,
LoginName = result.UserInfo,
MassiveAnswers = SocionicTypeAnswers(),
PCName = result.Device,
Result = SocioType(),
TimeData = result.CurrentTime,
AnswerTable = answerTable
};
socionicEntities.Results.Add(results);
//socionicEntities.AnswerTable.Add(answerTable);
socionicEntities.SaveChanges();
}
TaskResult = SocioType();
}
catch (Exception e)
{
TaskResult = e.ToString();
}
return(Task.FromResult(TaskResult));
}
