public void Delete_ShouldSucceed()
        {
            // Insert the Session data row in the database.
            int sessionID = SessionTestTable.InsertWithValues(
                "6dk61ufcuzp3f7vs",
                "Session Alpha",
                new DateTime(2001, 1, 1));

            // Build the Session data row.
            SessionDataRow sessionDataRow = new SessionDataRow();

            sessionDataRow.SessionID   = sessionID;
            sessionDataRow.SessionCode = "6dk61ufcuzp3f7vs";
            sessionDataRow.Name        = "Session Alpha";
            sessionDataRow.StartDate   = new DateTime(2001, 1, 1);

            // Build the database connection.
            using (DatabaseConnection databaseConnection = new DatabaseConnection(TestDatabase.ConnectionString))
            {
                // Open the database connection.
                databaseConnection.Open().Wait();

                // Delete the Session data row.
                SessionDataAccessComponent sessionDataAccessComponent = new SessionDataAccessComponent();
                sessionDataAccessComponent.Delete(databaseConnection, sessionDataRow).Wait();
            }

            // Validate the Session data row was deleted in the database.
            SessionTestTable.AssertAbsence(sessionID);
        }
        public void ReadAll_ShouldReturnOneDataRow()
        {
            // Insert the Session data row in the database.
            int sessionID = SessionTestTable.InsertWithValues(
                "6dk61ufcuzp3f7vs",
                "Session Alpha",
                new DateTime(2001, 1, 1));

            // Build the database connection.
            SessionDataRow[] sessionDataRows = null;
            using (DatabaseConnection databaseConnection = new DatabaseConnection(TestDatabase.ConnectionString))
            {
                // Open the database connection.
                databaseConnection.Open().Wait();

                // Read the Session data rows.
                SessionDataAccessComponent sessionDataAccessComponent = new SessionDataAccessComponent();
                sessionDataRows = sessionDataAccessComponent.ReadAll(databaseConnection).Result;
            }

            // Validate the Session data rows.
            Assert.IsNotNull(sessionDataRows);
            Assert.AreEqual(1, sessionDataRows.Length);

            // Validate the first Session data row.
            Assert.AreEqual(sessionID, sessionDataRows[0].SessionID);
            Assert.AreEqual("6dk61ufcuzp3f7vs", sessionDataRows[0].SessionCode);
            Assert.AreEqual("Session Alpha", sessionDataRows[0].Name);
            Assert.AreEqual(new DateTime(2001, 1, 1), sessionDataRows[0].StartDate);
        }
        public void ReadAll_ShouldReturnMultipleDataRows()
        {
            // Insert the first Session data row in the database.
            int firstSessionID = SessionTestTable.InsertWithValues(
                "6dk61ufcuzp3f7vs",
                "Session Alpha",
                new DateTime(2001, 1, 1));

            // Insert the second Session data row in the database.
            int secondSessionID = SessionTestTable.InsertWithValues(
                "n3p4y556gt9f17hw",
                "Session Bravo",
                new DateTime(2002, 2, 2));

            // Insert the third Session data row in the database.
            int thirdSessionID = SessionTestTable.InsertWithValues(
                "x36s2tccz8yxp1hq",
                "Session Charlie",
                new DateTime(2003, 3, 3));

            // Build the database connection.
            SessionDataRow[] sessionDataRows = null;
            using (DatabaseConnection databaseConnection = new DatabaseConnection(TestDatabase.ConnectionString))
            {
                // Open the database connection.
                databaseConnection.Open().Wait();

                // Read the Session data rows.
                SessionDataAccessComponent sessionDataAccessComponent = new SessionDataAccessComponent();
                sessionDataRows = sessionDataAccessComponent.ReadAll(databaseConnection).Result;
            }

            // Validate the Session data rows.
            Assert.IsNotNull(sessionDataRows);
            Assert.AreEqual(3, sessionDataRows.Length);

            // Validate the first Session data row.
            Assert.AreEqual(firstSessionID, sessionDataRows[0].SessionID);
            Assert.AreEqual("6dk61ufcuzp3f7vs", sessionDataRows[0].SessionCode);
            Assert.AreEqual("Session Alpha", sessionDataRows[0].Name);
            Assert.AreEqual(new DateTime(2001, 1, 1), sessionDataRows[0].StartDate);

            // Validate the second Session data row.
            Assert.AreEqual(secondSessionID, sessionDataRows[1].SessionID);
            Assert.AreEqual("n3p4y556gt9f17hw", sessionDataRows[1].SessionCode);
            Assert.AreEqual("Session Bravo", sessionDataRows[1].Name);
            Assert.AreEqual(new DateTime(2002, 2, 2), sessionDataRows[1].StartDate);

            // Validate the third Session data row.
            Assert.AreEqual(thirdSessionID, sessionDataRows[2].SessionID);
            Assert.AreEqual("x36s2tccz8yxp1hq", sessionDataRows[2].SessionCode);
            Assert.AreEqual("Session Charlie", sessionDataRows[2].Name);
            Assert.AreEqual(new DateTime(2003, 3, 3), sessionDataRows[2].StartDate);
        }
        public void Delete_ShouldThrowException_GivenCourseScheduleDetails()
        {
            // Insert the Session data row in the database.
            int sessionID = SessionTestTable.InsertWithValues(
                "6dk61ufcuzp3f7vs",
                "Session Alpha",
                new DateTime(2001, 1, 1));

            // Insert the details CourseSchedule data row in the database.
            int courseScheduleID = CourseScheduleTestTable.InsertPlaceholder(sessionID: sessionID);

            // Build the Session data row.
            SessionDataRow sessionDataRow = new SessionDataRow();

            sessionDataRow.SessionID   = sessionID;
            sessionDataRow.SessionCode = "6dk61ufcuzp3f7vs";
            sessionDataRow.Name        = "Session Alpha";
            sessionDataRow.StartDate   = new DateTime(2001, 1, 1);

            // Build the database connection.
            using (DatabaseConnection databaseConnection = new DatabaseConnection(TestDatabase.ConnectionString))
            {
                // Open the database connection.
                databaseConnection.Open().Wait();

                try
                {
                    // Delete the Session data row.
                    SessionDataAccessComponent sessionDataAccessComponent = new SessionDataAccessComponent();
                    sessionDataAccessComponent.Delete(databaseConnection, sessionDataRow).Wait();

                    // Validate an exception was thrown.
                    Assert.Fail();
                }
                catch (AggregateException ex)
                {
                    // Validate an SQL exception was thrown.
                    Assert.IsInstanceOfType(ex.InnerExceptions[0], typeof(SqlException));
                }
            }
        }
        public void Update_ShouldThrowException_GivenDuplicateSessionCode()
        {
            // Insert the Session data row in the database.
            int sessionID = SessionTestTable.InsertWithValues(
                "6dk61ufcuzp3f7vs",
                "Session Alpha",
                new DateTime(2001, 1, 1));

            // Insert the duplicate Session data row in the database.
            int duplicateSessionID = SessionTestTable.InsertPlaceholder(sessionCode: "n3p4y556gt9f17hw");

            // Build the Session data row.
            SessionDataRow sessionDataRow = new SessionDataRow();

            sessionDataRow.SessionID   = sessionID;
            sessionDataRow.SessionCode = "n3p4y556gt9f17hw";
            sessionDataRow.Name        = "Session Bravo";
            sessionDataRow.StartDate   = new DateTime(2002, 2, 2);

            // Build the database connection.
            using (DatabaseConnection databaseConnection = new DatabaseConnection(TestDatabase.ConnectionString))
            {
                // Open the database connection.
                databaseConnection.Open().Wait();

                try
                {
                    // Update the Session data row.
                    SessionDataAccessComponent sessionDataAccessComponent = new SessionDataAccessComponent();
                    sessionDataAccessComponent.Update(databaseConnection, sessionDataRow).Wait();

                    // Validate an exception was thrown.
                    Assert.Fail();
                }
                catch (AggregateException ex)
                {
                    // Validate an SQL exception was thrown.
                    Assert.IsInstanceOfType(ex.InnerExceptions[0], typeof(SqlException));
                }
            }
        }
        public void ReadBySessionCode_ShouldReturnNull()
        {
            // Insert the Session data row in the database.
            int sessionID = SessionTestTable.InsertWithValues(
                "6dk61ufcuzp3f7vs",
                "Session Alpha",
                new DateTime(2001, 1, 1));

            // Build the database connection.
            SessionDataRow sessionDataRow = null;

            using (DatabaseConnection databaseConnection = new DatabaseConnection(TestDatabase.ConnectionString))
            {
                // Open the database connection.
                databaseConnection.Open().Wait();

                // Read the Session data row.
                SessionDataAccessComponent sessionDataAccessComponent = new SessionDataAccessComponent();
                sessionDataRow = sessionDataAccessComponent.ReadBySessionCode(databaseConnection, "").Result;
            }

            // Validate the Session data row.
            Assert.IsNull(sessionDataRow);
        }