/// <summary>
/// Retrieve WorkItem from the database by its Id
/// </summary>
/// <param name="id">Guid ID of the WorkItem</param>
/// <returns>The WorkItem</returns>
public WorkItem GetItemById(Guid id)
{
using (var db = new PunchDatabase())
{
return(GetItemById(id, db));
}
}
/// <summary>
/// Update or Insert the WorkItem to the database
/// </summary>
/// <param name="workItem">WorkItem to be saved</param>
public void SaveWorkItem(WorkItem workItem)
{
using (var db = new PunchDatabase())
{
var times = db.Times;
var wits = db.WorkItems;
foreach (var entry in workItem.Entries)
{
if (times.FindById(new BsonValue(entry.Id)) == null)
{
times.Insert(entry);
}
else
{
times.Update(entry);
}
}
if (wits.FindById(new BsonValue(workItem.Id)) == null)
{
wits.Insert(workItem);
}
else
{
wits.Update(workItem);
}
}
}
private IOrderedQueryable <ReportByWeekGroup> GetItemsGroupedByWeek(PunchDatabase db)
{
var reportItems = db.WorkItems.Include(e => e.Entries).FindAll().AsQueryable <WorkItem>()
.SelectMany(item => item.Entries.Select(e => new ReportByWeekItem
{
ItemGuid = item.Id,
TfsId = item.TfsId,
ServiceCall = item.ServiceCall,
Change = item.Change,
Title = item.Title,
Description = e.Description,
Effort = item.Effort,
StartDate = e.StartDate,
EndDate = e.EndDate,
State = item.Status,
Status = e.Status,
WorkType = item.WorkType
})).GroupBy(r => new
{
WeekOfYear = r.StartDate.GetWeekOfYear(),
Title = r.Title,
Effort = r.Effort
}).Select(g => new ReportByWeekGroup
{
WeekOfYear = g.Key.WeekOfYear,
Title = g.Key.Title,
Effort = g.Key.Effort,
MinDate = g.Min(e => e.StartDate),
MaxDate = g.Max(e => e.EndDate ?? DateTime.Now),
ReportItems = g.Select(e => e).ToList()
}).OrderBy(r => r.WeekOfYear).ThenBy(r => r.Title);
return(reportItems);
}
public void DeleteWorkItem(Guid workItemId)
{
using (var db = new PunchDatabase())
{
var times = db.Times;
var wits = db.WorkItems.Include(e => e.Entries);
var workItem = wits.FindById(new BsonValue(workItemId));
foreach (var entry in workItem.Entries)
{
times.Delete(new BsonValue(entry.Id));
}
wits.Delete(new BsonValue(workItem.Id));
}
}
/// <summary>
/// Retrieve all WorkItems from the database
/// </summary>
/// <returns>List of all WorkItems</returns>
public List <WorkItem> GetWorkItems()
{
List <WorkItem> list;
using (var db = new PunchDatabase())
{
list = db.WorkItems.Include(e => e.Entries).FindAll().ToList();
}
if (list != null)
{
return(list);
}
else
{
return(new List <WorkItem>());
}
}
public List <ReportExportItem> GetSummaryReportExportItems(Predicate <ReportByWeekGroup> predicate)
{
List <ReportExportItem> exportItems = new List <ReportExportItem>();
using (var db = new PunchDatabase())
{
foreach (var item in GetItemsGroupedByWeek(db).Where(g => predicate(g)))
{
ReportByWeekItem wit = item.ReportItems.FirstOrDefault();
double effort = item.Effort * 8;
TimeSpan completed = new TimeSpan();
item.ReportItems.ForEach(new Action <ReportByWeekItem>(e =>
{
DateTime end = e.EndDate ?? e.StartDate;
completed = completed.Add(end - e.StartDate);
}));
double hoursRemain = effort - completed.TotalHours;
exportItems.Add(new ReportExportItem
{
ItemGuid = wit.ItemGuid,
TfsId = wit.TfsId,
ServiceCall = wit.ServiceCall,
Change = wit.Change,
Title = item.Title,
Effort = item.Effort,
HoursCompleted = completed.TotalHours,
HoursRemaining = (hoursRemain > 0 ? hoursRemain : 0),
StartDate = wit.StartDate,
EndDate = wit.EndDate,
State = wit.State,
Status = wit.Status,
WorkType = wit.WorkType,
WeekOfYear = item.WeekOfYear,
WeekStarting = item.WeekOfYear.GetWeekOfYearDate()
});
}
}
return(exportItems);
}
/// <summary>
/// Gets a list of <see cref="ReportExportItem"/> filtered by <see cref="Predicate<WorkByWeekGroup>"/>
/// </summary>
/// <param name="predicate"><see cref="WorkByWeekGroup"/> predicate</param>
/// <returns>List of <see cref="ReportExportItem"/></returns>
public List <ReportExportItem> GetReportExportItems(Predicate <ReportByWeekGroup> predicate)
{
using (var db = new PunchDatabase())
{
var exportItems = new List <ReportExportItem>();
var items = GetItemsGroupedByWeek(db).Where(g => predicate(g));
foreach (var item in items)
{
double effort = item.Effort * 8;
foreach (var time in item.ReportItems.OrderBy(t => t.StartDate))
{
TimeSpan completed = ((time.EndDate ?? DateTime.Now) - time.StartDate);
double hoursRemain = effort -= completed.TotalHours;
exportItems.Add(new ReportExportItem
{
ItemGuid = time.ItemGuid,
TfsId = time.TfsId,
ServiceCall = time.ServiceCall,
Change = time.Change,
Title = item.Title,
Description = time.Description,
Effort = item.Effort,
HoursCompleted = completed.TotalHours,
HoursRemaining = (hoursRemain > 0 ? hoursRemain : 0),
StartDate = time.StartDate,
EndDate = time.EndDate,
State = time.State,
Status = time.Status,
WorkType = time.WorkType,
WeekOfYear = item.WeekOfYear,
WeekStarting = item.WeekOfYear.GetWeekOfYearDate()
});
}
}
return(exportItems);
}
}
private WorkItem GetItemById(Guid id, PunchDatabase db)
{
return(db.WorkItems.Include(e => e.Entries).FindById(new BsonValue(id)));
}
