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); }