public void AddAnswersToDatabase(List <string> allAnswerText, List <int> allQuestionID, int userID, int formID)
{
for (int count = 0; count < allAnswerText.Count; count++)
{
using var command = _connection.CreateCommand();
command.CommandText = $"INSERT INTO answers (question_id, answer_text, user_id) VALUES ('{allQuestionID[count]}', '{allAnswerText[count]}', '{userID}')";
command.ExecuteNonQuery();
}
SQLUsersFormsConnectionController sQLUsersFormsConnection = new SQLUsersFormsConnectionController(_connection);
sQLUsersFormsConnection.SetUserFilledTheForm(formID, userID);
}
public List <FormModel> GetAllFormsForUser(int userID)
{
List <FormModel> forms = new List <FormModel>();
SQLUsersFormsConnectionController sQLUsersFormsConnection = new SQLUsersFormsConnectionController(_connection);
List <int> formIDsForUser = sQLUsersFormsConnection.GetFormIdsForUser(userID);
foreach (var formID in formIDsForUser)
{
var form = GetFormByID(formID);
form.questionList = GetallQuestionForForm(formID);
forms.Add(form);
}
return(SetFormsFillings(forms, userID));
}
