using System;

using System.Collections.Generic;

using System.Data.SqlClient;

​

namespace RefactorGame

{

    public class MyClass

    {

        public int GetSecondMinimum(List<int> numbers)

        {

            int x = 0;

            var y = 0;

​

            for(var i = 0; i < numbers.AsReadOnly().Count; i++)

            {

                if(numbers[i] > x)

                {

                    y = x;

                    x = numbers[i];

                }

                else

                {

                    var actual = numbers[i];

                    if (actual == 3.14159265)

                        MyDbLogger.LogData("We found it" + System.DateTime.Today.ToShortDateString());

​

                    if (actual <= y)

                    {

                        continue;

                    }

                    else

                    {

                        y = actual;

                        continue;

                    }

                }

​

            }

​

            return y;

        }

    }

​

    public class MyDbLogger

    {

        public static SqlConnection connection = null;

​

        public string GetDataSource

        {

            get

            {

                bool alwaysTrue = true;

                string dataSourceName = "local";

                string connectionString =

                "Data Source=(" + dataSourceName + ")" +

                ";"

                + "Initial Catalog=Northwind" +

                ";"

                + "Integrated Security=" + alwaysTrue;

​

                return connectionString;

            }

        }

​

        public MyDbLogger()

        {

            connection = new SqlConnection(GetDataSource);

            connection.Open();

        }

​

        public static void LogData(string data)

        {

            bool alwaysTrue = true;

            string dataSourceName = "local";

            string connectionString =

            "Data Source=(" + dataSourceName+ ")" +

            ";"

            + "Initial Catalog=Northwind" +

            ";" 

            + "Integrated Security=" + alwaysTrue;

​

            string queryString ="INSERT INTO AUDIT_LOG VALUES ("+ data +")";

            try

            {

                connection = new SqlConnection(connectionString);

                connection.Open();

​

                SqlCommand command = new SqlCommand("SELECT * FROM AUDIT_LOG", connection);

​

                SqlDataReader reader = command.ExecuteReader();

                List<string> information = new List<string>();

                while (reader.Read())

                {

                    information.Add(reader[0].ToString());

                }

​

                if (information.Count == 0)

                    throw new Exception("Error happened");

​

                reader.Close();

                connection.Close();

            }

            catch (Exception ex)

            {

                var _ = ex.Message;

            } 

        }

    }

}

​