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

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

        // NOTES
        //      Name cannot be null as that is the identifying field for insert or update.


        // [Test]
        //  ============================================================
        //  DELETE CUSTOMER DETAILS
        //  Call sp_CustomerDetailsDelete with a known details
        //  Verify customer detials no longer exists in dbo.CustomerDetails table.
        //  ============================================================


        // [Test]
        //  =============================================================
        //  GET CUSTOMER DETAILS
        //  Start with a known customer details in the database. Call sp_CustomerDetailsGet with name
        //  Verify known customer details are returned
        //  =============================================================


        //[Test]
        //  ============================================================
        //  INSERT CUSTOMER DETAILS
        //   call sp_CustomerDetailsUpdateInsert with parameters for a new valid 
        //   customer details record and compare all fields. 
        //   Pass if all fields in dbo.CustomerDetails table are entered.
        //  ============================================================

        //[Test]
        //  ============================================================
        //   call sp_CustomerDetailsUpdateInsert with parameters for a new valid 
        //   customer details and verify a new row is created in dbo.CustomerDetails table.
        //   
        //  ============================================================


        //[Test]
        //  ============================================================
        //  UPDATE CUSTOMER DETAILS
        //   Send valid customer details parameters to sp_CustomerDetailsInUpdateInsert for a 
        //   customer detail record that already is in the database and compare all fields. 
        //   Pass if all fields in dbo.CustomerDetails table are entered.
        //  ============================================================


        //[Test]
        //  UPDATE CUSTOMER DETAILS
        //  ============================================================
        //   Send valid customer details parameters to sp_CustomerDetailsInUpdateInsert for a 
        //   customer details record that already is in the database. 
        //   pass if no new row is created in dbo.CustomerDetails table.
        //  ============================================================

    }
}