/// <summary> Insert a user status into the UserQuizStatus table </summary>
private static void InsertQuizStatus(int userID, int moduleID, QuizStatus quizStatus)
{
string sqlInsertQuiz = @"
if (SELECT TOP 1 QuizStatusID FROM tblUserQuizStatus WHERE UserID = @UserID AND ModuleID = @ModuleID ORDER BY UserQuizStatusID DESC) <> 5
BEGIN
INSERT into tblUserQuizStatus (UserID, ModuleID, QuizStatusID)
VALUES(@UserID, @ModuleID, @QuizStatusID)
END
" ;
System.Data.SqlClient.SqlParameter[] sqlParams =
{
new SqlParameter("@userID", userID),
new SqlParameter("@ModuleID", moduleID),
new SqlParameter("@quizStatusID", (int)Enum.Parse(typeof(QuizStatus), quizStatus.ToString()))
};
string connectionString = ConfigurationSettings.AppSettings["ConnectionString"] + "password="******"password"] + ";";
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(connectionString, System.Data.CommandType.Text, sqlInsertQuiz, sqlParams);
}
