static void Main(string[] args) { var config = new ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json") .Build(); var connString = config.GetConnectionString("DefaultConnection"); IDbConnection conn = new MySqlConnection(connString); var repo = new DapperDepartmentRepository(conn); var departments = repo.GetAllDepartments(); //var repo = new DepartmentRepository(connString); //var departments = repo.GetAllDepartments(); foreach (var dept in departments) { Console.WriteLine($"Department Name: {dept.Name, -20} Department Id: {dept.ID}"); } }
static void Main(string[] args) { IConfigurationRoot config = new ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json") .Build(); string connString = config.GetConnectionString("DefaultConnection"); DepartmentRepository repo = new DepartmentRepository(connString); IEnumerable <Department> DeptList = repo.GetAllDepartments(); foreach (Department dept in DeptList) { Console.WriteLine($"{dept.Name}\n{dept.DepartmentId}"); } IDbConnection conn = new MySqlConnection(connString); DapperDepartmentRepository dapRepo = new DapperDepartmentRepository(conn); IEnumerable <Department> Depts = dapRepo.GetAllDepartments(); do { Console.WriteLine("Would you like to add a new department?"); Console.WriteLine("\n Type Y for yes \n Type EXIT to exit the program"); response = Console.ReadLine().ToUpper(); if (response == "Y") { Console.WriteLine("What is the name of the new department?"); string departmentName = Console.ReadLine(); dapRepo.InsertDepartment(departmentName); Depts = dapRepo.GetAllDepartments(); foreach (Department dept in Depts) { Console.WriteLine($"{dept.Name}\n{dept.DepartmentId}"); } } } while (response != "EXIT"); do { Console.WriteLine("Would you like to update a department name?"); Console.WriteLine("\n Type Y for yes \n Type EXIT to exit the program"); response = Console.ReadLine().ToUpper(); if (response == "Y") { Console.WriteLine("What is the ID of the department?"); string departmentID = Console.ReadLine(); Console.WriteLine("What is the new name of the department?"); string departmentName = Console.ReadLine(); dapRepo.UpdateDepartment(departmentName, departmentID); Depts = dapRepo.GetAllDepartments(); foreach (Department dept in Depts) { Console.WriteLine($"{dept.Name}\n{dept.DepartmentId}"); } } } while (response != "EXIT"); foreach (Department dept in Depts) { Console.WriteLine($"{dept.Name}\n{dept.DepartmentId}"); } do { Console.WriteLine("Would you like to delete a department name?"); Console.WriteLine("\n Type Y for yes \n Type EXIT to exit the program"); response = Console.ReadLine().ToUpper(); if (response == "Y") { Console.WriteLine("What is the ID of the department?"); string departmentID = Console.ReadLine(); dapRepo.DeleteDepartment(departmentID); Depts = dapRepo.GetAllDepartments(); foreach (Department dept in Depts) { Console.WriteLine($"{dept.Name}\n{dept.DepartmentId}"); } } } while (response != "EXIT"); }