public ICollection <EmployeeDescription> GetAllEmployeesExceptForCurrentUser(string username)
{
SqlDataReader reader = this.ExecuteReader(
@"SELECT Id,
Username,
Name
FROM Employees
WHERE Username != @username",
new Dictionary <string, object>
{
{ "@username", username }
});
IList <EmployeeDescription> employees = new List <EmployeeDescription>();
using (reader)
{
while (reader.Read())
{
int userId = reader.GetInt32(0);
string userUsername = reader.GetString(1);
string userName = reader.GetString(2);
string userNameRepresentation = this.CombineUsernameAndName(userUsername, userName);
EmployeeDescription employee = new EmployeeDescription(userId, userNameRepresentation);
employees.Add(employee);
}
}
return(employees);
}
public EmployeeWindow(EmployeeDescription e, UIClient db)
{
InitializeComponent();
_currentEmployee = e;
_db = db;
//EmployeeWindowViewModel _viewModel = new EmployeeWindowViewModel(_currentEmployee);
//LayoutRoot.DataContext = _viewModel;
empUI.DataContext = new EmployeeWindowViewModel(_currentEmployee, _db);
}
public IList<WorkRecord> GetRecordsOfEmployeeNonBonuses(EmployeeDescription employee)
{
EnsureManager();
return _db.GetRecordsOfEmployeeNonBonuses(employee);
}
public IList<Summary> GetLastSummaries(EmployeeDescription employee, int ammount)
{
EnsureManager();
return _db.GetLastSummaries(employee, ammount);
}
public IList<Summary> GetSummariesOfEmployee(EmployeeDescription employee)
{
EnsureManager();
return _db.GetSummariesOfEmployee(employee);
}
public void SetHourlyRate(EmployeeDescription employeeDescription, double hourlyRate)
{
//>>>>>>>>>>// AGAIN: WHAT IS ACCESS POLICY?
// HERE: we could get a metohde:
// User ManagerForEmployeeDescription(UInt64 employeeDescription);
EnsureManager();
_db.SetHourlyRate(employeeDescription, hourlyRate);
}
public IEnumerable<WorkRecord> GetRecordsOfEmployeeF(EmployeeDescription employeeDesc, FilterFunction<WorkRecord> filter)
{
EnsureManager();
return _db.GetRecordsOfEmployee(employeeDesc, filter);
}
public IEnumerable<WorkRecord> GetRecordsOfEmployee(EmployeeDescription employeeDesc)
{
// TO ASK: does a manager have access to records of all employees?
// otherwise, we have to get all manager's projects, employees of these projects etc...
EnsureManager();
return _db.GetRecordsOfEmployee(employeeDesc);
}
public void RemoveEmployeeDescription(EmployeeDescription employeeDescription)
{
EnsureAdmin();
_db.RemoveEmployeeDescription(employeeDescription);
}
public void SetEmployeeDescription(EmployeeDescription employeeDescription)
{
EnsureAdmin();
_db.SetEmployeeDescription(employeeDescription);
}
public void GetLastSummariesReturnsLastSummaries()
{
User user = new User { PublicUserInfo = new PublicUserInfo { Login = "******" } };
Project project = new Project { Manager = user.PublicUserInfo };
EmployeeDescription empDesc = new EmployeeDescription { Employee = user.PublicUserInfo, Project = project };
Summary sum1 = new Summary { Date = new DateTime(2012, 10, 01), EmployeeDescription = empDesc };
Summary sum2 = new Summary { Date = new DateTime(2012, 09, 01), EmployeeDescription = empDesc };
Summary sum3 = new Summary { Date = new DateTime(2013, 01, 01), EmployeeDescription = empDesc };
Dao.SetUser(user);
Dao.SetProject(project);
Dao.SetEmployeeDescription(empDesc);
Dao.SetSummary(sum1);
Dao.SetSummary(sum2);
Dao.SetSummary(sum3);
var sums = Dao.GetLastSummaries(empDesc, 2);
Assert.AreEqual(sum3, sums[0]);
Assert.AreEqual(sum1, sums[1]);
Assert.AreEqual(2, sums.Count);
}
public void RelationsFromEmployeeDescriptionMustExist2()
{
User manager = new User() { PublicUserInfo = new PublicUserInfo() { Login = "******" } };
Project project = new Project() { Manager = manager.PublicUserInfo };
Dao.SetProject(project);
EmployeeDescription employeeDescription = new EmployeeDescription() { Project = project, Employee = null };
Dao.SetEmployeeDescription(employeeDescription);
}
public void RelationsFromEmployeeDescriptionMustExist1()
{
User employee = new User() { PublicUserInfo = new PublicUserInfo() { Login = "******" } };
Dao.SetUser(employee);
EmployeeDescription employeeDescription = new EmployeeDescription() { Project = null, Employee = employee.PublicUserInfo };
Dao.SetEmployeeDescription(employeeDescription);
}
private void PrepareForRemoving(String Login)
{
PublicUserInfo userInfo = new PublicUserInfo() { Login = "******" };
User user = new User() { PublicUserInfo = userInfo };
Project project = new Project() { Manager = userInfo };
EmployeeDescription employeeDescription = new EmployeeDescription() { Employee = userInfo, Project = project };
Contract contract = new Contract() { Creator = userInfo, Employee = userInfo, Project = project };
WorkRecord record = new WorkRecord { EmployeeDescription = employeeDescription, MinutesWorked = 12 };
Summary summary = new Summary { EmployeeDescription = employeeDescription };
Dao.SetUser(user);
Assert.IsFalse(Dao.GetEmployeeDescriptions(user).Count > 0);
Assert.IsFalse(Dao.GetRecords(user).Count > 0);
Assert.IsFalse(Dao.GetSummaries(user).Count > 0);
Assert.IsFalse(Dao.GetContracts(user).Count > 0);
Dao.SetProject(project);
Dao.SetEmployeeDescription(employeeDescription);
Dao.SetRecord(record);
Dao.SetSummary(summary);
Dao.SetContract(contract);
Assert.IsTrue(Dao.GetEmployeeDescriptions(user).Count > 0);
Assert.IsTrue(Dao.GetRecords(user).Count > 0);
Assert.IsTrue(Dao.GetContracts(user).Count > 0);
Assert.IsTrue(Dao.GetSummaries(user).Count > 0);
}
public void RemovedRecordIsRemovedPermanently()
{
PublicUserInfo userInfo = new PublicUserInfo() { Login = "******" };
Project project = new Project() { Manager = userInfo };
EmployeeDescription employeeDescription = new EmployeeDescription() { Employee = userInfo, Project = project };
WorkRecord workRecord = new WorkRecord() { EmployeeDescription = employeeDescription };
User user = new User() { PublicUserInfo = userInfo };
Dao.SetUser(user);
Dao.SetProject(project);
Dao.SetEmployeeDescription(employeeDescription);
Dao.SetRecord(workRecord);
Assert.IsTrue(Dao.GetRecordsOfEmployee(employeeDescription).Count > 0);
Dao.RemoveRecord(workRecord);
Assert.IsFalse(Dao.GetRecordsOfEmployee(employeeDescription).Count > 0);
}
public void TestSetHourlyRate()
{
var robinHood = new User { PublicUserInfo = new PublicUserInfo { Login = "******", Name = "Robin" } };
var project = new Project() { Manager = robinHood.PublicUserInfo };
var desc = new EmployeeDescription { HourlyRate = 100, Employee = robinHood.PublicUserInfo, Project = project };
Dao.SetUser(robinHood);
Dao.SetProject(project);
Dao.SetEmployeeDescription(desc);
Dao.SetHourlyRate(desc, 200);
Assert.AreEqual(200, Dao.GetEmployeeDescriptions(robinHood)[0].HourlyRate);
}
