public TimeRegistration CreateTimeRegistration(Guid taskId, string employeeId, DateTimeOffset start, DateTimeOffset end, string remarks)
{
var task = new TimeRegistrationEntity
{
TaskId = taskId,
EmployeeId = employeeId,
Id = Guid.NewGuid(),
TimeStart = start,
TimeEnd = end,
Time = (end - start).Ticks,
Remarks = remarks
};
var taskPerEmployee = new TimeRegistrationByEmployeeEntity
{
EmployeeId = employeeId,
TaskId = taskId,
Id = task.Id
};
var table = GetTable(RegistrationsTable);
var table2 = GetTable(RegistrationsEmployeeTable);
var tableOp = TableOperation.Insert(task);
var tableOp2 = TableOperation.Insert(taskPerEmployee);
table.Execute(tableOp);
table2.Execute(tableOp2);
// Note: a transaction is only possible when the two operations share the same partition key
return task.ToDomain();
}
public IEnumerable<TimeRegistration> GetTimeRegistrationsForEmployee(string employeeId)
{
var search = new TimeRegistrationByEmployeeEntity { EmployeeId = employeeId };
var table = GetTable(RegistrationsEmployeeTable);
var query = table.CreateQuery<TimeRegistrationByEmployeeEntity>()
.Where(x => x.PartitionKey == search.PartitionKey)
.ToList();
var tasks = query.OrderBy(x => x.TaskId).Select(x => x.TaskId).Distinct();
var results = new List<TimeRegistrationEntity>();
var tableResults = GetTable(RegistrationsTable);
foreach (var task in tasks)
{
results.AddRange(tableResults.CreateQuery<TimeRegistrationEntity>()
.Where(x => x.PartitionKey == task.ToString("D")));
}
return results.Select(x => x.ToDomain());
}
public TimeRegistration GetTimeRegistrationByIdForEmployee(string employeeId, Guid registrationId)
{
var search = new TimeRegistrationByEmployeeEntity { EmployeeId = employeeId, Id = registrationId };
var table = GetTable(RegistrationsEmployeeTable);
var key = table
.CreateQuery<TimeRegistrationByEmployeeEntity>()
.Where(x => x.PartitionKey == search.PartitionKey && x.RowKey == search.RowKey)
.SingleOrDefault();
if (key == null)
{
return null;
}
var regKey = new TimeRegistrationEntity { TaskId = key.TaskId, Id = registrationId };
var regTable = GetTable(RegistrationsTable);
return regTable
.CreateQuery<TimeRegistrationEntity>()
.Where(x => x.PartitionKey == regKey.PartitionKey && x.RowKey == regKey.RowKey)
.Single()
.ToDomain();
}