public static List <TimeSheetJson> ToJsonsForConfirm(IEnumerable <PresenceHour> presenceHours, IEnumerable <WorkHour> workHours, User user) { UnitOfWork uow = new UnitOfWork(); TimeSheetManager timesheetMnager = new TimeSheetManager(uow); var result = new List <TimeSheetJson>(); int timeSheetID = 1; var groupingTasks = workHours.GroupBy(x => x.TaskID).Select(y => y.FirstOrDefault()).ToList(); var groupingProjects = workHours.GroupBy(x => x.ProjectId).Select(y => y.FirstOrDefault()).ToList(); List <WorkHour> approveItems = new List <WorkHour>(); List <WorkHour> notApproveItems = new List <WorkHour>(); foreach (var item in workHours) { if (timesheetMnager.ApprovementStatus(item, new UserHelper().GetCurrent().UserName) == "Approve") { approveItems.Add(item); } if (timesheetMnager.ApprovementStatus(item, new UserHelper().GetCurrent().UserName) == "NotApprove") { notApproveItems.Add(item); } } var groupingTasksApprove = approveItems.GroupBy(x => x.TaskID).Select(y => y.FirstOrDefault()).ToList(); var groupingProjectsApprove = approveItems.GroupBy(x => x.ProjectId).Select(y => y.FirstOrDefault()).ToList(); var groupingTasksNotApprove = notApproveItems.GroupBy(x => x.TaskID).Select(y => y.FirstOrDefault()).ToList(); var groupingProjectsNotApprove = notApproveItems.GroupBy(x => x.ProjectId).Select(y => y.FirstOrDefault()).ToList(); TimeSheetJson tsjPresHours = new TimeSheetJson(); tsjPresHours.UID = Guid.NewGuid(); tsjPresHours.id = timeSheetID++; tsjPresHours.parentId = null; tsjPresHours.Title = "حضور"; tsjPresHours.Values = new List <TimeSheetValueJson>(); List <TimeSheetJson> tsjWorkHours = new List <TimeSheetJson>(); var PrentWorkHour = new TimeSheetJson(); PrentWorkHour.UID = Guid.NewGuid(); PrentWorkHour.id = timeSheetID++; PrentWorkHour.parentId = null; PrentWorkHour.Title = "کارکرد"; PrentWorkHour.Values = new List <TimeSheetValueJson>(); tsjWorkHours.Add(PrentWorkHour); foreach (var item in groupingProjects) { var ProjectChild = new TimeSheetJson(); ProjectChild.Type = "Project"; var timesheetIdwork = timeSheetID; ProjectChild.UID = item.ProjectId; ProjectChild.id = timeSheetID++; ProjectChild.parentId = 2; ProjectChild.Title = item.Project.Title; ProjectChild.Values = new List <TimeSheetValueJson>(); tsjWorkHours.Add(ProjectChild); foreach (var w in groupingTasks) { if (item.ProjectId == w.ProjectId) { var TaskChilde = new TimeSheetJson(); TaskChilde.Type = "Task"; TaskChilde.UID = w.TaskID; TaskChilde.id = timeSheetID++; TaskChilde.parentId = timesheetIdwork; TaskChilde.Title = w.Task.Title; TaskChilde.Values = new List <TimeSheetValueJson>(); tsjWorkHours.Add(TaskChilde); } } } TimeSheetJson tsjDiffPH_WH = new TimeSheetJson(); tsjDiffPH_WH.UID = Guid.NewGuid(); tsjDiffPH_WH.id = timeSheetID++; tsjDiffPH_WH.parentId = null; tsjDiffPH_WH.Title = "اختلاف حضور و کارکرد"; tsjDiffPH_WH.Values = new List <TimeSheetValueJson>(); tsjDiffPH_WH.Type = "Defference"; List <TimeSheetJson> approveWHs = new List <TimeSheetJson>(); var approvechiled = new TimeSheetJson(); approvechiled.UID = Guid.NewGuid(); var timesheetIdapproveproject = timeSheetID; approvechiled.id = timeSheetID++; approvechiled.parentId = null; approvechiled.Title = "تایید شده"; approvechiled.Values = new List <TimeSheetValueJson>(); approvechiled.Type = "Approve"; approveWHs.Add(approvechiled); foreach (var projectApprove in groupingProjectsApprove) { var timesheetIdapproveaskt = timeSheetID; var counter = 0; foreach (var worktask in groupingTasksApprove) { if (timesheetMnager.ApprovementStatus(worktask, new UserHelper().GetCurrent().UserName) == "Approve" && projectApprove.ProjectId == worktask.ProjectId) { if (counter == 0) { var ProjectChildapprove = new TimeSheetJson(); ProjectChildapprove.Type = "ProjectApprove"; ProjectChildapprove.UID = projectApprove.ProjectId; ProjectChildapprove.id = timeSheetID++; ProjectChildapprove.parentId = timesheetIdapproveproject; ProjectChildapprove.Title = projectApprove.Project.Title; ProjectChildapprove.Values = new List <TimeSheetValueJson>(); approveWHs.Add(ProjectChildapprove); } counter++; var approveChildetask = new TimeSheetJson(); approveChildetask.Type = "TaskApprove"; approveChildetask.UID = worktask.TaskID; approveChildetask.id = timeSheetID++; approveChildetask.parentId = timesheetIdapproveaskt; approveChildetask.Title = worktask.Task.Title; approveChildetask.Values = new List <TimeSheetValueJson>(); approveWHs.Add(approveChildetask); } } } List <TimeSheetJson> notApproveWHs = new List <TimeSheetJson>(); var reject = new TimeSheetJson(); reject.UID = Guid.NewGuid(); var timesheetIdNotapproveproject = timeSheetID; reject.id = timeSheetID++; reject.parentId = null; reject.Title = "تایید نشده"; reject.Values = new List <TimeSheetValueJson>(); reject.Type = "Reject"; notApproveWHs.Add(reject); foreach (var item in groupingProjectsNotApprove) { var counter = 0; var timesheetIdapproveaskt = timeSheetID; foreach (var w in groupingTasksNotApprove) { if (timesheetMnager.ApprovementStatus(w, new UserHelper().GetCurrent().UserName) == "NotApprove" && item.ProjectId == w.ProjectId) { if (counter == 0) { var ProjectChildNotapprove = new TimeSheetJson(); ProjectChildNotapprove.Type = "ProjectNotApprove"; ProjectChildNotapprove.UID = item.ProjectId; ProjectChildNotapprove.id = timeSheetID++; ProjectChildNotapprove.parentId = timesheetIdNotapproveproject; ProjectChildNotapprove.Title = item.Project.Title; ProjectChildNotapprove.Values = new List <TimeSheetValueJson>(); notApproveWHs.Add(ProjectChildNotapprove); } counter++; var NotapproveChildetask = new TimeSheetJson(); NotapproveChildetask.Type = "TaskNotApprove"; NotapproveChildetask.UID = w.TaskID; NotapproveChildetask.id = timeSheetID++; NotapproveChildetask.parentId = timesheetIdapproveaskt; NotapproveChildetask.Title = w.Task.Title; NotapproveChildetask.Values = new List <TimeSheetValueJson>(); notApproveWHs.Add(NotapproveChildetask); } } } presenceHours.OrderBy(phItem => phItem.Date) .ToList().ForEach(phItem => { double phHours = phItem.Hours; List <WorkHour> selWorkHour = workHours.Where(whItem => whItem.Date.Equals(phItem.Date)).ToList(); double whHours = (selWorkHour != null && selWorkHour.Count >= 0) ? selWorkHour.Sum(x => x.Hours) : 0; List <WorkHour> appWorkHour = approveItems.Where(whItem => whItem.Date.Equals(phItem.Date)).ToList(); double apphours = (appWorkHour != null && appWorkHour.Count >= 0) ? appWorkHour.Sum(x => x.Hours) : 0; List <WorkHour> notappWorkHour = notApproveItems.Where(whItem => whItem.Date.Equals(phItem.Date)).ToList(); double notapphours = (notappWorkHour != null && notappWorkHour.Count >= 0) ? notappWorkHour.Sum(x => x.Hours) : 0; //Create Columns/Values for Presence Hours TimeSheetValueJson phTSJValue = new TimeSheetValueJson(); phTSJValue.Date = phItem.Date; phTSJValue.Day = phItem.Date.DayOfWeek.ToString(); phTSJValue.PersianDate = phItem.Date.ToPersianDateString(); phTSJValue.PersianDay = phItem.Date.ToPersianDayOfWeek(); phTSJValue.Title = phTSJValue.PersianDate + "-" + phTSJValue.PersianDay; phTSJValue.Value = DateUtility.ConvertToTimeSpan(phHours); tsjPresHours.Values.Add(phTSJValue); //Create Columns/Values for Work Hours TimeSheetValueJson whTSJValue = new TimeSheetValueJson(); whTSJValue.Date = phItem.Date; whTSJValue.Day = phItem.Date.DayOfWeek.ToString(); whTSJValue.PersianDate = phItem.Date.ToPersianDateString(); whTSJValue.PersianDay = phItem.Date.ToPersianDayOfWeek(); whTSJValue.Title = whTSJValue.PersianDate + "-" + whTSJValue.PersianDay; whTSJValue.Value = DateUtility.ConvertToTimeSpan(whHours); tsjWorkHours[0].Values.Add(whTSJValue); var groupingByDate = workHours.GroupBy(x => x.Date).Select(y => y.FirstOrDefault()).ToList(); var co = tsjWorkHours.Count(); for (int i = 1; i < co; i++) { TimeSheetValueJson whTSJValue1 = new TimeSheetValueJson(); whTSJValue1.Date = phItem.Date; whTSJValue1.Day = phItem.Date.DayOfWeek.ToString(); whTSJValue1.PersianDate = phItem.Date.ToPersianDateString(); whTSJValue1.PersianDay = phItem.Date.ToPersianDayOfWeek(); whTSJValue1.Title = whTSJValue1.PersianDate + "-" + whTSJValue1.PersianDay; whTSJValue1.Value = " "; tsjWorkHours[i].Values.Add(whTSJValue1); if (tsjWorkHours[i].Type == "Project") { var hourCount = selWorkHour.Where(y => y.ProjectId == tsjWorkHours[i].UID).Sum(x => x.Hours); whTSJValue1.Value = DateUtility.ConvertToTimeSpan(hourCount); } if (tsjWorkHours[i].Type == "Task") { var hourCount = selWorkHour.Where(y => y.TaskID == tsjWorkHours[i].UID).Sum(x => x.Hours); whTSJValue1.Value = DateUtility.ConvertToTimeSpan(hourCount); } } //Create Row for Different between Presence Hour And Work Hour TimeSheetValueJson diffPH_WHTSJValue = new TimeSheetValueJson(); diffPH_WHTSJValue.Date = phItem.Date; diffPH_WHTSJValue.Day = phItem.Date.DayOfWeek.ToString(); diffPH_WHTSJValue.PersianDate = phItem.Date.ToPersianDateString(); diffPH_WHTSJValue.PersianDay = phItem.Date.ToPersianDayOfWeek(); diffPH_WHTSJValue.Title = diffPH_WHTSJValue.PersianDate + "-" + diffPH_WHTSJValue.PersianDay; diffPH_WHTSJValue.Value = DateUtility.ConvertToTimeSpan(Math.Abs(phHours - whHours)); tsjDiffPH_WH.Values.Add(diffPH_WHTSJValue); //Create Columns/Values for Approve TimeSheetValueJson appTSJValue = new TimeSheetValueJson(); appTSJValue.Date = phItem.Date; appTSJValue.Day = phItem.Date.DayOfWeek.ToString(); appTSJValue.PersianDate = phItem.Date.ToPersianDateString(); appTSJValue.PersianDay = phItem.Date.ToPersianDayOfWeek(); appTSJValue.Title = appTSJValue.PersianDate + "-" + appTSJValue.PersianDay; appTSJValue.Value = DateUtility.ConvertToTimeSpan(apphours); approveWHs[0].Values.Add(appTSJValue); for (int i = 1; i < approveWHs.Count(); i++) { TimeSheetValueJson whTSJValue1 = new TimeSheetValueJson(); whTSJValue1.Date = phItem.Date; whTSJValue1.Day = phItem.Date.DayOfWeek.ToString(); whTSJValue1.PersianDate = phItem.Date.ToPersianDateString(); whTSJValue1.PersianDay = phItem.Date.ToPersianDayOfWeek(); whTSJValue1.Title = whTSJValue1.PersianDate + "-" + whTSJValue1.PersianDay; whTSJValue1.Value = " "; approveWHs[i].Values.Add(whTSJValue1); if (approveWHs[i].Type == "ProjectApprove") { var hourCount = appWorkHour.Where(y => y.ProjectId == approveWHs[i].UID).Sum(x => x.Hours); whTSJValue1.Value = DateUtility.ConvertToTimeSpan(hourCount); } if (approveWHs[i].Type == "TaskApprove") { var hourCount = appWorkHour.Where(y => y.TaskID == approveWHs[i].UID).Sum(x => x.Hours); whTSJValue1.Value = DateUtility.ConvertToTimeSpan(hourCount); } } //Create Columns/Values for NotApprove TimeSheetValueJson notappTSJValue = new TimeSheetValueJson(); notappTSJValue.Date = phItem.Date; notappTSJValue.Day = phItem.Date.DayOfWeek.ToString(); notappTSJValue.PersianDate = phItem.Date.ToPersianDateString(); notappTSJValue.PersianDay = phItem.Date.ToPersianDayOfWeek(); notappTSJValue.Title = notappTSJValue.PersianDate + "-" + notappTSJValue.PersianDay; notappTSJValue.Value = DateUtility.ConvertToTimeSpan(notapphours); notApproveWHs[0].Values.Add(notappTSJValue); for (int i = 1; i < notApproveWHs.Count(); i++) { TimeSheetValueJson whTSJValue1 = new TimeSheetValueJson(); whTSJValue1.Date = phItem.Date; whTSJValue1.Day = phItem.Date.DayOfWeek.ToString(); whTSJValue1.PersianDate = phItem.Date.ToPersianDateString(); whTSJValue1.PersianDay = phItem.Date.ToPersianDayOfWeek(); whTSJValue1.Title = whTSJValue1.PersianDate + "-" + whTSJValue1.PersianDay; whTSJValue1.Value = " "; notApproveWHs[i].Values.Add(whTSJValue1); if (notApproveWHs[i].Type == "ProjectNotApprove") { var hourCount = notappWorkHour.Where(y => y.ProjectId == notApproveWHs[i].UID).Sum(x => x.Hours); whTSJValue1.Value = DateUtility.ConvertToTimeSpan(hourCount); } if (notApproveWHs[i].Type == "TaskNotApprove") { var hourCount = notappWorkHour.Where(y => y.TaskID == notApproveWHs[i].UID).Sum(x => x.Hours); whTSJValue1.Value = DateUtility.ConvertToTimeSpan(hourCount); } } }); result.Add(tsjPresHours); foreach (var item in tsjWorkHours) { result.Add(item); } result.Add(tsjDiffPH_WH); foreach (var approve in approveWHs) { result.Add(approve); } foreach (var notapprove in notApproveWHs) { result.Add(notapprove); } return(result); }