public void ContactSurvey(int submittedSurveyID) { using (var context = new FSOSSContext()) { try { SubmittedSurvey ss = context.SubmittedSurveys.Find(submittedSurveyID); ss.contacted = true; context.Entry(ss).Property(y => y.contacted).IsModified = true; context.SaveChanges(); } catch (Exception e) { throw new Exception("Please contact the Administrator with the error message: " + e.Message); } } }
/// <summary> /// This method returns if the participants submitted survey indicates if they want to be contacted or not. /// </summary> /// <param name="submittedSurveyID">the submitted survey id of the survey which we want to know if they want contact</param> /// <returns>true, wants contact. false, no contact wanted/needed</returns> public bool RequestsContact(int submittedSurveyID) { using (var context = new FSOSSContext()) { try { SubmittedSurvey ss = context.SubmittedSurveys.Find(submittedSurveyID); if (ss.contacted == false && ss.contact_request == true) // if the submitted survey has a contact request and it has not been resolved, return true { return(true); } else // else, return false { return(false); } } catch (Exception e) { throw new Exception("Please contact the Administrator with the error message: " + e.Message); } } }
/// <summary> /// This is the method used when submitting a survey into the database in both the SubmittedSurvey and ParticipantResponse tables /// </summary> /// <param name="survey_version_id_param"></param> /// <param name="unit_id_param"></param> /// <param name="meal_id_param"></param> /// <param name="participant_type_id_param"></param> /// <param name="age_range_id_param"></param> /// <param name="gender_id_param"></param> /// <param name="contact_request_param"></param> /// <param name="contact_room_number_param"></param> /// <param name="contact_phone_number_param"></param> /// <param name="Q1AResponse_param"></param> /// <param name="Q1BResponse_param"></param> /// <param name="Q1CResponse_param"></param> /// <param name="Q1DResponse_param"></param> /// <param name="Q1EResponse_param"></param> /// <param name="Q2Response_param"></param> /// <param name="Q3Response_param"></param> /// <param name="Q4Response_param"></param> /// <param name="Q5Response_param"></param> public void SubmitSurvey(int survey_version_id_param, int unit_id_param, int meal_id_param, int participant_type_id_param, int age_range_id_param, int gender_id_param, bool contact_request_param, string contact_room_number_param, string contact_phone_number_param, string Q1AResponse_param, string Q1BResponse_param, string Q1CResponse_param, string Q1DResponse_param, string Q1EResponse_param, string Q2Response_param, string Q3Response_param, string Q4Response_param, string Q5Response_param) { using (var context = new FSOSSContext()) { SubmittedSurvey newSurvey = new SubmittedSurvey(); newSurvey.survey_version_id = survey_version_id_param; newSurvey.date_entered = DateTime.Now; newSurvey.unit_id = unit_id_param; newSurvey.meal_id = meal_id_param; newSurvey.participant_type_id = participant_type_id_param; newSurvey.age_range_id = age_range_id_param; newSurvey.gender_id = gender_id_param; newSurvey.contact_request = contact_request_param; newSurvey.contact_room_number = contact_room_number_param; newSurvey.contact_phone_number = contact_phone_number_param; context.SubmittedSurveys.Add(newSurvey); context.SaveChanges(); var newSurveyId = (from x in context.SubmittedSurveys select x.submitted_survey_id).Max(); ParticipantResponse q1AResponse = new ParticipantResponse(); q1AResponse.submitted_survey_id = newSurveyId; q1AResponse.question_id = 2; q1AResponse.participant_answer = Q1AResponse_param; context.ParticipantResponses.Add(q1AResponse); context.SaveChanges(); ParticipantResponse q1BResponse = new ParticipantResponse(); q1BResponse.submitted_survey_id = newSurveyId; q1BResponse.question_id = 3; q1BResponse.participant_answer = Q1BResponse_param; context.ParticipantResponses.Add(q1BResponse); context.SaveChanges(); ParticipantResponse q1CResponse = new ParticipantResponse(); q1CResponse.submitted_survey_id = newSurveyId; q1CResponse.question_id = 4; q1CResponse.participant_answer = Q1CResponse_param; context.ParticipantResponses.Add(q1CResponse); context.SaveChanges(); ParticipantResponse q1DResponse = new ParticipantResponse(); q1DResponse.submitted_survey_id = newSurveyId; q1DResponse.question_id = 5; q1DResponse.participant_answer = Q1DResponse_param; context.ParticipantResponses.Add(q1DResponse); context.SaveChanges(); ParticipantResponse q1EResponse = new ParticipantResponse(); q1EResponse.submitted_survey_id = newSurveyId; q1EResponse.question_id = 6; q1EResponse.participant_answer = Q1EResponse_param; context.ParticipantResponses.Add(q1EResponse); context.SaveChanges(); ParticipantResponse q2Response = new ParticipantResponse(); q2Response.submitted_survey_id = newSurveyId; q2Response.question_id = 8; q2Response.participant_answer = Q2Response_param; context.ParticipantResponses.Add(q2Response); context.SaveChanges(); ParticipantResponse q3Response = new ParticipantResponse(); q3Response.submitted_survey_id = newSurveyId; q3Response.question_id = 9; q3Response.participant_answer = Q3Response_param; context.ParticipantResponses.Add(q3Response); context.SaveChanges(); ParticipantResponse q4Response = new ParticipantResponse(); q4Response.submitted_survey_id = newSurveyId; q4Response.question_id = 10; q4Response.participant_answer = Q4Response_param; context.ParticipantResponses.Add(q4Response); context.SaveChanges(); ParticipantResponse q5Response = new ParticipantResponse(); q5Response.submitted_survey_id = newSurveyId; q5Response.question_id = 11; q5Response.participant_answer = Q5Response_param; context.ParticipantResponses.Add(q5Response); context.SaveChanges(); } }