//Assemble single project public FinalReport AssembleBreakingProjectByMonth(ReportParametrsFromToProjectIdJson parametres) { var result = new FinalReport(); UnitOfWork uow = new UnitOfWork(); var currentUser = new UserHelper().GetCurrent(); TimeSheetManager TimeSheetManager = new TimeSheetManager(uow); var from = DateUtility.GetMiladiDate(parametres.FromDate); var to = DateUtility.GetMiladiDate(parametres.ToDate); var currentDate = from; var workHours = TimeSheetManager.GetByProjectID (parametres.ProjectId, from, to).ToList(); if (workHours.Count() > 0) { foreach (var group in workHours.GroupBy(x => x.TaskID)) { var row = new ReportRow(); row.ID = group.First().TaskID; row.Title = group.First().Task.Title; result.Rowes.Add(row); } } var SumTotal = new ReportRow(); SumTotal.ID = Guid.NewGuid(); SumTotal.Title = "جمع کل"; result.Rowes.Add(SumTotal); while (currentDate.Date <= to) { var firstDayOfMonth = DateUtility.GetMiladiDate(DateUtility.GetPersianYear(currentDate) + "/" + DateUtility.GetPersianMonth(currentDate) + "/" + "1"); var day = "30"; if (DateUtility.GetPersianMonth(currentDate) < 7) { day = "31"; } var LastDayOfMonth = DateUtility.GetMiladiDate(DateUtility.GetPersianYear(currentDate) + "/" + DateUtility.GetPersianMonth(currentDate) + "/" + day); var field = new Field(); field.ID = Guid.NewGuid(); field.Title = DateUtility.GetPersianYear(currentDate) + "/" + DateUtility.GetPersianMonth(currentDate); result.Fields.Add(field); double workhours = 0; foreach (var row in result.Rowes) { if (row.Title == "جمع کل") { var sumWorkHour = workHours.Where(x => x.Date.Date <= LastDayOfMonth && x.Date.Date >= firstDayOfMonth).Sum(x => x.Hours); workhours = sumWorkHour; var fieldValuesumWorkHour = new FieldValue(); fieldValuesumWorkHour.FieldId = field.ID; fieldValuesumWorkHour.RowId = row.ID; fieldValuesumWorkHour.Value = DateUtility.ConvertToTimeSpan(sumWorkHour); row.Values.Add(fieldValuesumWorkHour); } else { var value = workHours.Where(x => x.TaskID == row.ID && x.Date.Date <= LastDayOfMonth && x.Date.Date >= firstDayOfMonth).Sum(x => x.Hours); var fieldValue = new FieldValue(); fieldValue.FieldId = field.ID; fieldValue.RowId = row.ID; fieldValue.Value = DateUtility.ConvertToTimeSpan(value); row.Values.Add(fieldValue); } } currentDate = LastDayOfMonth.AddDays(1).Date; } var Aggregation = new Field(); Aggregation.Title = "جمع کل"; Aggregation.ID = Guid.NewGuid(); result.Fields.Add(Aggregation); double Alltotalsum = 0; foreach (var row in result.Rowes) { var sum = workHours.Where(x => x.TaskID == row.ID).Sum(y => y.Hours); var fieldvalue = new FieldValue(); fieldvalue.CalculativeValue = sum; fieldvalue.FieldId = Guid.NewGuid(); fieldvalue.RowId = row.ID; fieldvalue.Value = DateUtility.ConvertToTimeSpan(sum); row.Values.Add(fieldvalue); Alltotalsum += sum; } result.Rowes[result.Rowes.Count() - 1].Values[result.Rowes[result.Rowes.Count() - 1]. Values.Count() - 1].Value = DateUtility.ConvertToTimeSpan(Alltotalsum); result.HeaderTitle = "گزارش یک پروژه به تفکیک ماه"; result.FirstColumnTitle = "عنوان وظیفه"; return(result); }