//Deepdive-V3-377354-Step 1-UnitTest

​

using System;

using System.Collections.Generic;

using System.Data.SqlClient;

​

using System.Linq;

using Moq;

using System.Data;

​

public class Product

{

    public int ProductId { get; set; }

    public string ProductName { get; set; }

    public decimal UnitPrice { get; set; }

}

​

​

public class ProductData

{

    public List<Product> GetProducts(string connectionString)

    {

        List<Product> products = new List<Product>();

​

        try

        {

            using (SqlConnection connection = new SqlConnection(connectionString))

            {

                connection.Open();

​

                string query = "SELECT ProductId, ProductName, UnitPrice FROM Products";

​

                using (SqlCommand command = new SqlCommand(query, connection))

                using (SqlDataReader reader = command.ExecuteReader())

                {

                    while (reader.Read())

                    {

                        Product product = new Product

                        {

                            ProductId = reader.GetInt32(0),

                            ProductName = reader.GetString(1),

                            UnitPrice = reader.GetDecimal(2)

                        };

                        products.Add(product);

                    }

                }

            }

        }

        catch (SqlException ex)

        {

            // Log the exception or handle it as per application needs

            Console.WriteLine($"An SQL Exception occurred: {ex.Message}");

            return new List<Product>();  // Return empty list on error

        }

        catch(Exception ex)

        {

            Console.WriteLine($"An Exception occurred: {ex.Message}");

            return new List<Product>();

        }

​

        return products;

    }

}

​

public class Program

{

    public static void Main()

    {

        Console.WriteLine(" ");

        Console.WriteLine("-------------- STARTING ---------------");

        try {

            string connectionString = "ValidConnectionString";

            var mockConnection = new Mock<IDbConnection>();

            var mockCommand = new Mock<IDbCommand>();

            var mockReader = new Mock<IDataReader>();       

​

            mockReader.SetupSequence(r => r.Read())

                .Returns(true)

                .Returns(true)

                .Returns(false);

​

            mockReader.SetupSequence(r => r.GetInt32(0))

                 .Returns(1)

                 .Returns(2);

​

            mockReader.SetupSequence(r => r.GetString(1))

                .Returns("Product A")

                .Returns("Product B");

​

            mockReader.SetupSequence(r => r.GetDecimal(2))

               .Returns(10.99m)

               .Returns(25.50m);

​

            var productData = new ProductData();

​

            using (var con = mockConnection.Object)

            {

                var field = typeof(ProductData).GetField("ConnectionFactory", System.Reflection.BindingFlags.NonPublic | System.Reflection.BindingFlags.Instance);

                var method = typeof(ProductData).GetMethod("GetProducts", System.Reflection.BindingFlags.Public | System.Reflection.BindingFlags.Instance);

                var result = (List<Product>)method.Invoke(productData, new object[] { connectionString });

​

                Console.WriteLine("result.Count: {result.Count}");

​

                /* 

                Assert.IsNotNull(result);

                Assert.AreEqual(2, result.Count);

                Assert.AreEqual(1, result[0].ProductId);

                Assert.AreEqual("Product A", result[0].ProductName);

                Assert.AreEqual(10.99m, result[0].UnitPrice);

                Assert.AreEqual(2, result[1].ProductId);

                Assert.AreEqual("Product B", result[1].ProductName);

                Assert.AreEqual(25.50m, result[1].UnitPrice);

                */

            }

        } catch (Exception ex) {

                Console.WriteLine("Exception: {ex.Message}");           

        }

    }

}