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