示例#1
0
        public void UpdateScoreTest()
        {
            ScoreSystemInfo         scoreSystem        = new ScoreSystemInfo("System 1", 0);
            ScoreSystemMssqlContext scoreSystemContext = new ScoreSystemMssqlContext();
            ScoreMssqlContext       scoreContext       = new ScoreMssqlContext();

            try
            {
                Assert.AreEqual(0, scoreSystemContext.GetScoreSystems().Count, "Cleanup of database failed");
                scoreSystemContext.AddScoreSystem(scoreSystem.Name, scoreSystem.PointsForFastestLap);

                scoreContext.AddOrUpdateScore(1, 10, scoreSystem);
                Assert.AreEqual(1, scoreContext.GetScoresForScoreSystem(scoreSystem).Count);
                Assert.AreEqual(10, scoreContext.GetScoresForScoreSystem(scoreSystem)[0].Points);
                scoreContext.AddOrUpdateScore(1, 5, scoreSystem);
                Assert.AreEqual(1, scoreContext.GetScoresForScoreSystem(scoreSystem).Count);
                Assert.AreEqual(5, scoreContext.GetScoresForScoreSystem(scoreSystem)[0].Points);
            }
            finally
            {
                scoreContext.RemoveScore(1, scoreSystem);
                Assert.AreEqual(0, scoreContext.GetScoresForScoreSystem(scoreSystem).Count);
                scoreSystemContext.RemoveScoreSystem("System 1");
                Assert.AreEqual(0, scoreSystemContext.GetScoreSystems().Count, "Cleanup of database failed");
            }
        }
示例#2
0
        public void RemoveScoreSystemTest()
        {
            ScoreSystemMssqlContext sqlContext = new ScoreSystemMssqlContext();

            try
            {
                sqlContext.AddScoreSystem("System 1", 0);
                sqlContext.AddScoreSystem("System 2", 0);
                Assert.AreEqual(2, sqlContext.GetScoreSystems().Count, "There should be 2 Score systems");
                sqlContext.RemoveScoreSystem("System 2");
                Assert.AreEqual(1, sqlContext.GetScoreSystems().Count, "There should be 1 Score system");
            }
            finally
            {
                sqlContext.RemoveScoreSystem("System 1");
                Assert.AreEqual(0, sqlContext.GetScoreSystems().Count, "Cleanup of the database failed");
            }
        }
示例#3
0
        public void AddScoreSystemTest()
        {
            ScoreSystemMssqlContext sqlContext = new ScoreSystemMssqlContext();

            try
            {
                List <ScoreSystemInfo> scoreSystems = sqlContext.GetScoreSystems();
                Assert.AreEqual(0, scoreSystems.Count, "Precondition for this test is an empty ScoreSystem table");
                sqlContext.AddScoreSystem("System 1", 0);
                scoreSystems = sqlContext.GetScoreSystems();
                Assert.AreEqual(1, scoreSystems.Count, "The number of scoresystems should be 1");
                Assert.AreEqual("System 1", scoreSystems[0].Name, "The added scoresystem should be 'System 1'");
            }
            finally
            {
                sqlContext.RemoveScoreSystem("System 1");
                Assert.AreEqual(0, sqlContext.GetScoreSystems().Count, "Cleanup of database failed");
            }
        }
示例#4
0
        public void AddScoreSystemTwiceTest()
        {
            ScoreSystemMssqlContext sqlContext = new ScoreSystemMssqlContext();

            try
            {
                sqlContext.AddScoreSystem("System 1", 0);
                List <ScoreSystemInfo> scoreSystems = sqlContext.GetScoreSystems();
                Assert.AreEqual(1, scoreSystems.Count, "There should be 1 scoresystem");
                Assert.AreEqual("System 1", scoreSystems[0].Name, "The scoresystem should be System 1");
                sqlContext.AddScoreSystem("System 1", 0);
                Assert.Fail("Adding a discipline twice should fail");
            }
            finally
            {
                Assert.AreEqual(1, sqlContext.GetScoreSystems().Count, "Cleanup cannot be executed");
                sqlContext.RemoveScoreSystem("System 1");
                Assert.AreEqual(0, sqlContext.GetScoreSystems().Count, "Cleanup of the database failed");
            }
        }
示例#5
0
        public void AddInvalidNumberOfPontsTest()
        {
            ScoreSystemMssqlContext sqlContext = new ScoreSystemMssqlContext();

            sqlContext.AddScoreSystem("System 1", -1);
        }
示例#6
0
        public void AddEmptScoreSystemTest()
        {
            ScoreSystemMssqlContext sqlContext = new ScoreSystemMssqlContext();

            sqlContext.AddScoreSystem("", 0);
        }