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