private async Task UpdateEmployee()
{
var repo = new MsSqlRepo.EmployeesRepository("Employees");
var employeeToUpdate = new Employees();
employeeToUpdate.ID = Parameters.GetAndShift("id").Value;
foreach (var item in Parameters)
{
if (item.Key == "name")
{
employeeToUpdate.Name = item.Value;
}
if (item.Key == "lastname")
{
employeeToUpdate.LastName = item.Value;
}
if (item.Key == "email")
{
employeeToUpdate.Email = item.Value;
}
if (item.Key == "password")
{
employeeToUpdate.Password = item.Value;
}
}
await repo.UpdateAsync(employeeToUpdate);
View.WriteLine("1 employee was updated");
}
private async Task ListEmployee()
{
var repo = new MsSqlRepo.EmployeesRepository("Employees");
List <Employees> employees = new List <Employees>();
employees = (await repo.GetAllAsync()).ToList();
employees[0].PrintKeys();
employees.ForEach(article => article.Print());
}
private async Task DeleteEmployee()
{
var repo = new MsSqlRepo.EmployeesRepository("Employees");
int id;
id = Parameters.GetAndShift("id").Value;
await repo.DeleteRowAsync(id);
View.WriteLine(String.Format($"Deleted row with id={id}"));
}
private async Task AddEmployee()
{
var repo = new MsSqlRepo.EmployeesRepository("Employees");
var newEmployee = new Employees();
newEmployee.Name = Parameters.GetAndShift("firstname").Value;
newEmployee.LastName = Parameters.GetAndShift("lastname").Value;
newEmployee.Email = Parameters.GetAndShift("email").Value;
newEmployee.Password = Parameters.GetAndShift("password").Value;
int n = (await repo.InsertWithReturnAsync(newEmployee));
View.WriteLine(String.Format($"Added {n} employee"));
}
