public List <OmadaSurvey> GetOpinionsFromCurrentWeek(OmadaTeam team, int week) { List <OmadaSurvey> opinions = new List <OmadaSurvey>(); using (SqlConnection connection = DatabaseConnector.CreateConnection()) { using (SqlCommand command = connection.CreateCommand()) { command.CommandText = @"SELECT SecondAnswer, ThirdAnswer FROM Surveys WHERE UserId IN (SELECT UserID FROM Users_Teams WHERE TeamId = @TeamId AND YEAR(SurveyDate) = @SurveysYear) AND DATEPART(ww, SurveyDate) = @Week"; command.Parameters.AddWithValue("@TeamId", team.Id); command.Parameters.AddWithValue("@SurveysYear", DateTime.UtcNow.Year); command.Parameters.AddWithValue("@Week", week); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { OmadaSurvey opinion = new OmadaSurvey(); opinion.SecondAnswer = reader.GetString(0); opinion.ThirdAnswer = reader.GetString(1); opinions.Add(opinion); } } } return(opinions); } }
public void AddSurvey(OmadaSurvey survey) { using (SqlConnection connection = DatabaseConnector.CreateConnection()) { using (SqlCommand command = connection.CreateCommand()) { command.CommandText = @"INSERT INTO dbo.Surveys VALUES(@UserId, @FirstAnswer, @SecondAnswer, @ThirdAnswer, @Date)"; command.Parameters.AddWithValue("@UserId", survey.UserId); command.Parameters.AddWithValue("@FirstAnswer", survey.FirstAnswer); command.Parameters.AddWithValue("@SecondAnswer", survey.SecondAnswer); command.Parameters.AddWithValue("@ThirdAnswer", survey.ThirdAnswer); command.Parameters.AddWithValue("@Date", survey.Date); command.ExecuteNonQuery(); } } }