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 static TimeRegistration ToDomain(this TimeRegistrationEntity model)
{
return(new TimeRegistration
{
Id = model.Id,
TaskId = model.TaskId,
EmployeeId = model.EmployeeId,
TimeStart = model.TimeStart,
TimeEnd = model.TimeEnd,
Time = new TimeSpan(model.Time),
Remarks = model.Remarks
});
}
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();
}
public IEnumerable<TimeRegistration> GetTimeRegistrationsForTask(Guid taskId)
{
var task = new TimeRegistrationEntity { TaskId = taskId };
var table = GetTable(RegistrationsTable);
return table.CreateQuery<TimeRegistrationEntity>()
.Where(x => x.PartitionKey == task.PartitionKey)
.ToList()
.Select(x => x.ToDomain());
}
