internal static TaskInfo FetchTaskInfo(
Data.Task data,
decimal? duration,
int? numberOfNotes,
int? numberOfAttachments,
int? numberOfInvoices)
{
var result = new TaskInfo();
result.Fetch(data, duration, numberOfNotes, numberOfAttachments, numberOfInvoices);
return result;
}
private void DataPortal_Fetch(TaskCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
this.RaiseListChangedEvents = false;
this.IsReadOnly = false;
IQueryable <Data.Task> query = ctx.ObjectContext.Tasks
.Include("Category")
.Include("Status")
.Include("Project")
.Include("Sprint")
.Include("AssignedToUser");
if (criteria.TaskId != null)
{
query = query.Where(row => row.TaskId == criteria.TaskId);
}
if (criteria.ProjectId != null && criteria.ProjectId.Count() != 0)
{
query = query.Where(row => criteria.ProjectId.Contains(row.ProjectId));
}
if (criteria.SprintId != null)
{
query = query.Where(row => row.SprintId == criteria.SprintId);
}
if (criteria.CategoryId != null && criteria.CategoryId.Count() != 0)
{
query = query.Where(row => criteria.CategoryId.Contains(row.CategoryId));
}
if (criteria.StatusId != null && criteria.StatusId.Count() != 0)
{
query = query.Where(row => criteria.StatusId.Contains(row.StatusId));
}
if (criteria.Description != null)
{
query = query.Where(row => row.Description == criteria.Description);
}
if (criteria.AssignedTo != null && criteria.AssignedTo.Count() != 0)
{
query = query.Where(row => criteria.AssignedTo.Contains(row.AssignedTo));
}
if (criteria.AssignedDate.DateFrom.Date != DateTime.MinValue.Date)
{
query = query.Where(row => row.AssignedDate >= criteria.AssignedDate.DateFrom);
}
if (criteria.AssignedDate.DateTo.Date != DateTime.MaxValue.Date)
{
query = query.Where(row => row.AssignedDate <= criteria.AssignedDate.DateTo);
}
if (criteria.StartDate.DateFrom.Date != DateTime.MinValue.Date)
{
query = query.Where(row => row.StartDate >= criteria.StartDate.DateFrom);
}
if (criteria.StartDate.DateTo.Date != DateTime.MaxValue.Date)
{
query = query.Where(row => row.StartDate <= criteria.StartDate.DateTo);
}
if (criteria.CompletedDate.DateFrom.Date != DateTime.MinValue.Date)
{
query = query.Where(row => row.CompletedDate >= criteria.CompletedDate.DateFrom);
}
if (criteria.CompletedDate.DateTo.Date != DateTime.MaxValue.Date)
{
query = query.Where(row => row.CompletedDate <= criteria.CompletedDate.DateTo);
}
if (criteria.EstimatedCompletedDate.DateFrom.Date != DateTime.MinValue.Date)
{
query = query.Where(row => row.EstimatedCompletedDate >= criteria.EstimatedCompletedDate.DateFrom);
}
if (criteria.EstimatedCompletedDate.DateTo.Date != DateTime.MaxValue.Date)
{
query = query.Where(row => row.EstimatedCompletedDate <= criteria.EstimatedCompletedDate.DateTo);
}
if (criteria.Duration != null)
{
query = query.Where(row => row.Duration == criteria.Duration);
}
if (criteria.EstimatedDuration != null)
{
query = query.Where(row => row.EstimatedDuration == criteria.EstimatedDuration);
}
if (criteria.Label != null)
{
query = query.Where(row => row.Notes.Contains(criteria.Label));
}
if (criteria.IsArchived != null)
{
query = query.Where(row => row.IsArchived == criteria.IsArchived);
}
if (criteria.Notes != null)
{
query = query.Where(row => row.Notes == criteria.Notes);
}
if (criteria.ModifiedBy != null)
{
query = query.Where(row => row.ModifiedBy == criteria.ModifiedBy);
}
if (criteria.ModifiedDate.DateFrom.Date != DateTime.MinValue.Date)
{
query = query.Where(row => row.ModifiedDate >= criteria.ModifiedDate.DateFrom);
}
if (criteria.ModifiedDate.DateTo.Date != DateTime.MaxValue.Date)
{
query = query.Where(row => row.ModifiedDate <= criteria.ModifiedDate.DateTo);
}
if (criteria.CreatedBy != null)
{
query = query.Where(row => row.CreatedBy == criteria.CreatedBy);
}
if (criteria.CreatedDate.DateFrom.Date != DateTime.MinValue.Date)
{
query = query.Where(row => row.CreatedDate >= criteria.CreatedDate.DateFrom);
}
if (criteria.CreatedDate.DateTo.Date != DateTime.MaxValue.Date)
{
query = query.Where(row => row.CreatedDate <= criteria.CreatedDate.DateTo);
}
if (criteria.TaskLabels != null &&
criteria.TaskLabels.Count() != 0)
{
query = query.Join(ctx.ObjectContext.TaskLabels
.Where(tl => criteria.TaskLabels.Contains(tl.Name)), t => t.TaskId, tl => tl.TaskId, (t, tl) => t);
}
if (criteria.Text != null)
{
query = query.Where(row => SqlFunctions.StringConvert((double)row.TaskId).Contains(criteria.Text) ||
row.Description.Contains(criteria.Text) ||
row.Project.Name.Contains(criteria.Text));
}
if (criteria.SortBy != null)
{
query = query.OrderBy(string.Format(
"{0} {1}",
criteria.SortBy,
criteria.SortOrder == ListSortDirection.Ascending ? "ASC" : "DESC"));
}
if (criteria.MaximumRecords != null)
{
query = query.Take(criteria.MaximumRecords.Value);
}
var data = query.AsEnumerable().Select(row => TaskInfo.FetchTaskInfo(row,
ctx.ObjectContext.Hours.Where(hour => hour.TaskId == row.TaskId).Sum(hour => (decimal?)hour.Duration),
ctx.ObjectContext.Notes.Count(note => note.SourceType == (int)SourceType.Task && note.SourceId == row.TaskId),
ctx.ObjectContext.Attachments.Count(attachment => attachment.SourceType == (int)SourceType.Task && attachment.SourceId == row.TaskId),
ctx.ObjectContext.Invoices.Count(invoice => invoice.TaskId == row.TaskId)));
this.AddRange(data);
this.IsReadOnly = true;
this.RaiseListChangedEvents = true;
}
}