static async Task Main(string[] args)
{
if (args.Length != 1 || string.IsNullOrEmpty(args[0]))
{
Console.WriteLine("Please supply the connection string as the only argument. Press enter to quit");
Console.ReadKey();
return;
}
var connectionString = args[0];
Console.WriteLine($"Initializing Database! {connectionString}");
var source = new EmployeeSource(new System.Net.Http.HttpClient()
{
BaseAddress = new Uri("https://randomuser.me")
});
var tb = new TableBuilder(connectionString);
var ec = new EmployeeCommands(connectionString);
var bootstrapper = new DBBootstrapper(tb, ec, source);
await bootstrapper.Initialize();
Console.WriteLine($"Initialized Database! {connectionString}");
}
public static void Question1()
{
IEmployeeCommands employeeCommand = new EmployeeCommands(new EmployeeCommandsRepository());
var firstEmployee = new Employee(1, "test", "test");
employeeCommand.AddEmployee(firstEmployee);
Console.WriteLine(
$"Adding first employee :{firstEmployee.EmployeeId}, Name:{firstEmployee.FirstName}, Address:{firstEmployee.LastName}");
var secondEmployee = new Employee(2, "test1", "test1");
employeeCommand.AddEmployee(secondEmployee);
Console.WriteLine(
$"Adding second employee :{secondEmployee.EmployeeId}, Name:{secondEmployee.FirstName}, Address:{secondEmployee.LastName}");
var thirdEmployee = new Employee(3, "test2", "test2");
employeeCommand.AddEmployee(thirdEmployee);
Console.WriteLine(
$"Adding third employee :{thirdEmployee.EmployeeId}, Name:{thirdEmployee.FirstName}, Address:{thirdEmployee.LastName}");
IEmployeeQueries employeeQuery = new EmployeeQueries(new EmployeeQueryRepository());
var result = employeeQuery.GetEmployee(1);
Console.WriteLine($"Get Employee ID =1 :{result.EmployeeId}, Name:{result.FirstName}, Address:{result.LastName}");
var orderList = employeeQuery.GetOrderedEmployeeArray();
for (int employeeCount = 1; employeeCount >= orderList.Count; employeeCount++)
{
Console.WriteLine(
$" Employee Ordered Array :{orderList[employeeCount].EmployeeId}, Name:{orderList[employeeCount].FirstName}, Address:{orderList[employeeCount].LastName}");
}
}
static void Main()
{
using (var context = new EmployeesDbContext())
{
var input = Console.ReadLine().Split(" ", StringSplitOptions.RemoveEmptyEntries);
while (true)
{
var confMapper = new MapperConfiguration(conf => conf.AddProfile <EmployeeProfile>());
var mapper = new Mapper(confMapper);
EmployeeCommands empCommands = new EmployeeCommands(context, mapper);
ManagerCommands managerCommands = new ManagerCommands(context, mapper);
var args = input.Skip(1).ToArray();
switch (input[0])
{
case "AddEmployee":
Console.WriteLine(empCommands.AddEmployee(args));
break;
case "SetBirthday":
empCommands.SetBirthday(args);
break;
case "SetAddress":
empCommands.SetAddress(args);
break;
case "EmployeeInfo":
var id = int.Parse(args[0]);
Console.WriteLine(empCommands.EmployeeInfo(id));
break;
case "EmployeePersonalInfo":
var Employeeid = int.Parse(args[0]);
Console.WriteLine(empCommands.EmployeePersonalInfo(Employeeid));
break;
case "SetManager":
Console.WriteLine(managerCommands.SetManager(args));
break;
case "ManagerInfo":
Console.WriteLine(managerCommands.ManagerInfo(args));
break;
case "ListEmployeesOlderThan":
Console.WriteLine(empCommands.ListEmployeesOlderThan(int.Parse(args[0])));
break;
}
if (input[0] == "Exit")
{
break;
}
input = Console.ReadLine().Split(" ", StringSplitOptions.RemoveEmptyEntries);
}
}
}
