public WorkTaskWithTimesDto[] SelectByYmd(YmdString ymd, bool containsCompleted)
{
var list = new List <WorkTaskWithTimesDto>();
RepositoryAction.Query(c =>
{
var workTaskDao = new WorkTaskDao(c, null);
var workingTimeDao = new WorkingTimeDao(c, null);
var processes = new WorkProcessDao(c, null).SelectAll();
var products = new ProductDao(c, null).SelectAll();
var clients = new ClientDao(c, null).SelectAll();
var completedDao = new WorkTaskCompletedDao(c, null);
var tasks = workTaskDao.SelectPlaned(ymd, containsCompleted);
var times = workingTimeDao.SelectByTaskIds(tasks.Select(t => t.Id).Distinct().ToArray());
var completed = completedDao.SelectCompleted(tasks.Select(t => t.Id).Distinct().ToArray());
foreach (var task in tasks)
{
var dto = new WorkTaskWithTimesDto
{
TaskId = new Identity <Domain.Domain.Tasks.WorkTask>(task.Id),
ClientName = clients.FirstOrDefault(c => c.Id == task.ClientId)?.Name ?? "",
ProcessName = processes.FirstOrDefault(p => p.Id == task.ProcessId)?.Title ?? "",
ProductName = products.FirstOrDefault(p => p.Id == task.ProductId)?.Name ?? "",
TaskCategory = task.TaskCategory,
Title = task.Title,
IsCompleted = completed.Any(c => c == task.Id),
IsScheduled = task.TaskSource == Domain.Domain.Tasks.TaskSource.Schedule,
};
dto.WorkingTimes = times.Where(t => t.TaskId == task.Id)
.Select(t => t.ToDomainObject())
.OrderBy(t => t.TimePeriod.StartDateTime)
.ThenBy(t => t.Id)
.ToArray();
list.Add(dto);
}
});
try
{
return(list.OrderBy(i => i.WorkingTimes.Any(t => t.IsDoing) ? 0 : 1)
.ThenByDescending(i => i.WorkingTimes.Where(t => t.TimePeriod.IsFuture == false).Any() ? i.WorkingTimes.Where(t => t.TimePeriod.IsFuture == false).Max(t => t.TimePeriod.StartDateTime) : DateTime.MinValue)
.ThenBy(i => i.WorkingTimes.Where(t => t.TimePeriod.IsFuture).Any() ? i.WorkingTimes.Where(t => t.TimePeriod.IsFuture).Min(t => t.TimePeriod.StartDateTime) : DateTime.MaxValue)
.ThenBy(i => i.TaskId.Value).ToArray());
}
catch (Exception)
{
return(list.ToArray());
}
}
public WorkTask SelectById(Identity <WorkTask> identity)
{
WorkTask results = null;
RepositoryAction.Query(c =>
{
var dao = new WorkTaskDao(c, null);
var compDao = new WorkTaskCompletedDao(c, null);
var exist = compDao.IsCompleted(identity.Value);
results = WorkTaskFactory.Create(dao.SelectById(identity.Value), exist);
});
return(results);
}
public void Edit(WorkTask task)
{
RepositoryAction.Transaction((c, t) =>
{
var row = WorkTaskTableRow.FromDomainObject(task);
var dao = new WorkTaskDao(c, t);
var compDao = new WorkTaskCompletedDao(c, t);
dao.Update(row);
if (task.IsCompleted)
{
compDao.InsertIfNotExist(task.Id.Value);
}
else
{
compDao.DeleteByWorkTaskId(task.Id.Value);
}
});
}
