public Projectmanager AddProjectmanager(string naam, DateTime birthday, string username, string password)
{
var toAdd = new Projectmanager(UserRepository.GetNextId(), naam, birthday, username, password);
UserRepository.AddItem(toAdd);
return(toAdd);
}
private Projectmanager getProjectmanagerFromEmployee(User employee)
{
var users = UserRepository.Items.OfType <Projectmanager>().ToList();
Projectmanager returnProjectmanager = null;
foreach (var pm in users.Where(user => user.GetType() == typeof(Projectmanager))
.Where(pm => pm.GetEmployees().Contains((Employee)employee)))
{
returnProjectmanager = pm;
}
return(returnProjectmanager);
}
internal List <User> GetUsersFromDb()
{
var users = new List <User>();
var connection = new MySqlConnection(_connectionString);
var command = new MySqlCommand("SELECT * from tbluser", connection);
connection.Open();
var dataReader = command.ExecuteReader();
while (dataReader.Read())
{
var id = Convert.ToInt32(dataReader["id"]);
var name = Convert.ToString(dataReader["name"]);
var birthday = Convert.ToDateTime(dataReader["birthday"]);
var username = Convert.ToString(dataReader["username"]);
var password = Convert.ToString(dataReader["password"]);
switch (Convert.ToString(dataReader["rol"]).ToLower())
{
case "projectmanager":
var projectmanager = new Projectmanager(id, name, birthday, password, username);
projectmanager.Load(GetEmployeesFromProjectManager(projectmanager.Id));
users.Add(projectmanager);
break;
case "employee":
var employee = new Employee(id, name, birthday, password, username);
users.Add(employee);
break;
default:
var user = new User(id, name, birthday, password, username);
users.Add(user);
break;
}
}
connection.Close();
return(users);
}
public void AddEmployeeToProject(Projectmanager projectmanager, Employee employee)
{
projectmanager.AddEmployee(employee);
UpdateUser(employee);
}
