using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using NUnit.Framework;
using System.Data;

namespace DatabaseUnitTesting
{
    [TestFixture]
    public class DASChannelsTests : TestSetups
    {

        //  NOTES:
        //      Deletes DAS channels by DASId. IE: all channels associated with the given DAS hardware ID will be deleted.

        // [Test]
        //  ============================================================
        //  DELETE DAS CHANNELS
        //  Call sp_DASChannelsDelete with a known DAS hardware ID
        //  Verify all DAS channels associated with the hardware ID no longer exists in dbo.DASChannels table.
        //  ============================================================


        // [Test]
        //  =============================================================
        //  GET DAS CHANNELS
        //  Start with a DAS hardware that has a known number of DAS channels included. Call sp_DASChannelsGet for the hardware.
        //  Verify known number of DAS channels are returned
        //  =============================================================


        //[Test]
        //  ============================================================
        //  INSERT DAS CHANNELS
        //   Starting with a known populated test setup call sp_DASChannelsUpdateInsert with parameters for a new valid 
        //   DAS channel and compare all fields. 
        //   Pass if all fields in dbo.DASChannels table are entered.
        //  ============================================================


        //[Test]
        //  ============================================================
        //  INSERT DAS CHANNEL: VERIFY ONLY ONE NEW ROW IS ADDED
        //   Call sp_DASChannelsUpdateInsert with parameters for a new valid 
        //   DAS channel and verify a new row is created in dbo.DASChannels table.
        //   
        //  ============================================================


        //[Test]
        //  ============================================================
        //  UPDATE DAS CHANNEL
        //   Send valid DAS channels parameters to sp_DASChannelsInUpdateInsert for a DAS
        //   channel that already is in the database and compare all fields. 
        //   Pass if all fields in dbo.DASChannels table are entered.
        //  ============================================================

        //[Test]
        //  ============================================================
        //  UPDATE DAS CHANNEL: VERIFY NO NEW ROW IS ADDED
        //   Send valid DAS channels parameters to sp_DASChannelsInUpdateInsert for a DAS
        //   channel that already is in the database and verify no new row is created in dbo.DASChannels table.
        //   
        //  ============================================================
    }
}