public void WriteDepartment(Department department)
{
_databaseExecutor.Execute(cmd =>
{
cmd.CommandText = "insert into Departments (Id, Name) values ($Id, $Name)";
AddParameter(cmd, "$Id", department.Id.ToByteArray());
AddParameter(cmd, "$Name", department.Name);
cmd.ExecuteNonQuery();
});
}
public void WriteEmployee(Employee employee)
{
_databaseExecutor.Execute(cmd =>
{
cmd.CommandText = "insert into Employees (Id, DepartmentId, FirstName, LastName) values ($Id, $DepartmentId, $FirstName, $LastName)";
AddParameter(cmd, "$Id", employee.Id.ToByteArray());
AddParameter(cmd, "$DepartmentId", employee.DepartmentId.ToByteArray());
AddParameter(cmd, "$FirstName", employee.FirstName);
AddParameter(cmd, "$LastName", employee.LastName);
cmd.ExecuteNonQuery();
});
}
public Department[] ReadAllDepartments()
{
return(_databaseExecutor.Execute(cmd =>
{
cmd.CommandText = "select Id, Name from Departments";
using (var reader = cmd.ExecuteReader())
{
var result = new List <Department>();
while (reader.Read())
{
var dep = new Department()
{
Id = new Guid((byte[])reader["Id"]),
Name = (string)reader["Name"],
};
result.Add(dep);
}
return result.ToArray();
}
}));
}
public Employee[] ReadAllEmployees()
{
return(_databaseExecutor.Execute(cmd =>
{
cmd.CommandText = "select Id, FirstName, LastName, DepartmentId from Employees";
using (var reader = cmd.ExecuteReader())
{
var result = new List <Employee>();
while (reader.Read())
{
var emp = new Employee()
{
Id = new Guid((byte[])reader["Id"]),
FirstName = (string)reader["FirstName"],
LastName = (string)reader["LastName"],
//SupervisorId = new Guid((byte[]) reader["SupervisorId"]),
DepartmentId = new Guid((byte[])reader["DepartmentId"]),
};
result.Add(emp);
}
return result.ToArray();
}
}));
}