private static WorkDoneExport GetWorkDoneExport(ReportQuery query) { var workDoneItems = query.GetWorkDoneItems(); var workDone = new WorkDoneExport(); foreach (var w in workDoneItems) { workDone.Add(new WorkDoneItem { AccountName = w.Account.Name, InvoiceName = w.Invoice.Name, InvoiceDate = MonthStart(w.Invoice.InvoiceDate), InvoiceMargin = w.Invoice.Margin.GetValueOrDefault(), InvoiceStatus = w.Invoice.Status.GetValueOrDefault(), WorkDoneDate = MonthStart(w.WorkDoneItem.WorkDoneDate), WorkDoneMargin = w.WorkDoneItem.Margin.GetValueOrDefault(), WorkDoneForecast = w.WorkDoneItem.Forecast.GetValueOrDefault() }); } return(workDone); }