Beispiel #1
0
        private static void Main(string[] args)
        {
            var connectionString = ConfigurationManager.ConnectionStrings["SQLServer"].ConnectionString;

            _dataReader = new EmployeeSalaryReader(connectionString);

            Console.WriteLine("Welcome to the Employee Salary Console!");
            Console.WriteLine();
            Console.WriteLine("To search for an employee press 1");
            Console.WriteLine("To view all 'Staff' employee's press 2");
            var option = Console.ReadKey().KeyChar;

            if (option == '1')
            {
                Console.WriteLine();
                SearchByName();
            }
            else if (option == '2')
            {
                Console.WriteLine();
                ShowStaffSalaries();
            }
            else
            {
                Console.WriteLine("Option not found");
            }

            Console.WriteLine();
            Console.WriteLine("Press any key to exit");
            Console.ReadKey();
        }
        public void SetUp()
        {
            try
            {
                _conn = new SqlConnection(TestConnectionString);
                _conn.Open();
                SetUpDatabase();
            }
            finally
            {
                _conn.Close();
            }

            _employeeSalaryReader = new EmployeeSalaryReader(TestConnectionString);
        }