static void Main(string[] args) { DatabaseHandlerFactory factory = new DatabaseHandlerFactory(); Console.WriteLine("Enter Input as described below:"); Console.WriteLine("Enter " + (int)Databases.SQL + " to create a SQL database handler for employee"); Console.WriteLine("Enter " + (int)Databases.MYSQL + " to create a MYSQL database handler for employee"); Console.WriteLine("Enter " + (int)Databases.NOSQL + " to create a NOSQL database handler for employee"); Console.WriteLine("Input: "); EmployeeDatabaseHandler handler = null; var input = Console.ReadLine(); int database = int.Parse(input); if (database == (int)Databases.MYSQL) { handler = factory.createEmployeeDatabaseHandler(Databases.MYSQL); } else if (database == (int)Databases.SQL) { handler = factory.createEmployeeDatabaseHandler(Databases.SQL); } else { handler = factory.createEmployeeDatabaseHandler(Databases.NOSQL); } handler.CreateEmployee(); handler.DeleteEmployee(); handler.GetEmployee(); handler.UpdateEmployee(); }
public static List <Employee> GetAllEmployees() { List <Employee> allEmployees = new List <Employee>(); EmployeeDatabaseHandler handler = new EmployeeDatabaseHandler(); var employeeFromDatabase = handler.GetAllEmployees(); foreach (var empDto in employeeFromDatabase) { Employee employee = new Employee(empDto.FirstName, empDto.LastName, empDto.PersonnelNumber); employee.DateOfBirth = empDto.DateOfBirth; employee.StartDate = empDto.StartDate; allEmployees.Add(employee); } return(allEmployees); }
static void Main(string[] args) { DatabaseHandlerFactory factory; Console.WriteLine("Enter Input as described below:"); Console.WriteLine("Enter " + (int)Databases.SQL + " to create a SQL database handler for employee"); Console.WriteLine("Enter " + (int)Databases.MYSQL + " to create a MYSQL database handler for employee"); Console.WriteLine("Enter " + (int)Databases.NOSQL + " to create a NOSQL database handler for employee"); Console.WriteLine("Input: "); DatabaseHandler handler = null; var input = Console.ReadLine(); int database = int.Parse(input); if (database == (int)Databases.MYSQL) { factory = MYSQLDatabaseHandlerFactory.GetInstance(); } else if (database == (int)Databases.NOSQL) { factory = NOSQLDatabaseHandlerFactory.GetInstance(); } else { factory = SQLDatabaseHandlerFactory.GetInstance(); } EmployeeDatabaseHandler employeeHandler = factory.GetDatabaseHandler().GetEmployeeDatabaseHandler(); DepartmentDatabaseHandler departmentHandler = factory.GetDatabaseHandler().GetDepartmentDatabaseHandler(); employeeHandler.CreateEmployee(); employeeHandler.DeleteEmployee(); employeeHandler.GetEmployee(); employeeHandler.UpdateEmployee(); departmentHandler.CreateDepartment(); departmentHandler.DeleteDepartment(); departmentHandler.GetDepartment(); departmentHandler.UpdateDepartment(); }