public List <QuestionSessionDTO> GetAllQuestionSessions()
{
List <QuestionSessionDTO> questionList = new List <QuestionSessionDTO>();
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("SP_GetAllQuestionSessions", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
QuestionSessionDTO questionSession = new QuestionSessionDTO();
questionSession.ID = Convert.ToInt32(dr["ID"].ToString());
questionSession.UserID = Convert.ToInt32(dr["UserId"].ToString());
questionSession.AmountCorrect = Convert.ToInt32(dr["AmountCorrect"].ToString());
questionSession.AmountWrong = Convert.ToInt32(dr["AmountWrong"].ToString());
questionSession.DateFinished = Convert.ToDateTime(dr["DateFinished"]);
questionList.Add(questionSession);
}
}
return(questionList);
}
} // Default constructor
public QuestionSession(QuestionSessionDTO questionSessionDTO)
{
ID = questionSessionDTO.ID;
UserID = questionSessionDTO.UserID;
AmountCorrect = questionSessionDTO.AmountCorrect;
AmountWrong = questionSessionDTO.AmountWrong;
DateFinished = questionSessionDTO.DateFinished;
}
public void AddQuestionSession(QuestionSessionDTO questionSession)
{
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("SP_InsertQuestionSession", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", 2);
cmd.Parameters.AddWithValue("@AmountCorrect", questionSession.AmountCorrect);
cmd.Parameters.AddWithValue("@AmountWrong", questionSession.AmountWrong);
cmd.Parameters.AddWithValue("@DateFinished", questionSession.DateFinished);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
public void VerifyInitializingQuestionSession()
{
// Arrange
QuestionSessionDTO questionSessionDTO = new QuestionSessionDTO();
questionSessionDTO.ID = 6;
questionSessionDTO.AmountCorrect = 0;
questionSessionDTO.AmountWrong = 0;
questionSessionDTO.UserID = 2;
questionSessionDTO.DateFinished = DateTime.Today;
// Act
QuestionSession questionSession = new QuestionSession(questionSessionDTO);
// Assert
Assert.IsNotNull(questionSessionDTO);
Assert.IsNotNull(questionSession);
Assert.AreEqual(questionSession.ID, questionSessionDTO.ID);
Assert.AreEqual(questionSession.UserID, questionSessionDTO.UserID);
Assert.AreEqual(questionSession.AmountCorrect, 0);
Assert.AreEqual(questionSession.AmountWrong, 0);
Assert.AreEqual(questionSession.DateFinished, questionSessionDTO.DateFinished);
}
public QuestionSessionDTO GetQuestionSessionById(int?questionId)
{
QuestionSessionDTO questionSession = new QuestionSessionDTO();
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("SP_GetQuestionById", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@QuestionId", questionId);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
questionSession.ID = Convert.ToInt32(dr["QuestionId"].ToString());
questionSession.UserID = Convert.ToInt32(dr["UserId"].ToString());
questionSession.AmountCorrect = Convert.ToInt32(dr["AmountCorrect"].ToString());
questionSession.AmountWrong = Convert.ToInt32(dr["AmountWrong"].ToString());
questionSession.DateFinished = Convert.ToDateTime(dr["DateFinished"]);
}
con.Close();
}
return(questionSession);
}