public async Task Handle(TodayLogsNotificationsAdm notification, CancellationToken cancellationToken)
{
if (DateTime.Now.Hour >= 20 && DateTime.Now.Hour < 23)
{
try
{
var service = await _context.ServiceTimeCheckers
.FirstOrDefaultAsync(x => x.ServiceName == "DailyLogsAdm", cancellationToken);
if (service != null && (!service.ExecutedLastTime.HasValue ||
(DateTime.Now - service.ExecutedLastTime.Value).Hours >= 22))
{
service.ExecutedLastTime = DateTime.Now;
_context.ServiceTimeCheckers.Update(service);
await _context.SaveChangesAsync(cancellationToken);
}
else
{
return;
}
}
catch (Exception exception)
{
Debug.WriteLine(exception.Message);
}
#region Recepients
var administration = await Task.Run(async() =>
{
var owners = await _userManager.GetUsersInRoleAsync("PM Owner");
var admins = await _userManager.GetUsersInRoleAsync("PM Admin");
var activeOwners = owners?.Where(x => x.Active).ToList() ?? new List <ApplicationUser>();
var activeAdmins = admins?.Where(x => x.Active).ToList() ?? new List <ApplicationUser>();
return(activeOwners.Union(activeAdmins));
}, cancellationToken);
#endregion
var teamsReport = await _mediator.Send(new GetReportDetailsByNameQuery()
{
Name = "Teams by filters"
}, cancellationToken);
var projectsReport = await _mediator.Send(new GetReportDetailsByNameQuery()
{
Name = "Projects by filters"
}, cancellationToken);
var now = DateTime.Now;
var today = $"{now.Year}-{now.Month}-{now.Day}";
var yesterday = now.AddDays(-1);
var tableHelper = new ExcelTableHelper();
var excelReportHelper = new ExcelReportHelper();
foreach (var administrator in administration)
{
var userTeamsReport = await _mediator.Send(new GetUserReportDetailsQuery
{
UserId = administrator.Id,
ReportId = teamsReport.Id
}, cancellationToken);
var teamsHtmlContent = new StringBuilder();
#region Team report
byte[] teamsAttachment = null;
if (userTeamsReport.Active)
{
var employeeModelForTeams = await _mediator.Send(new GetUserReportGuidListQuery
{
UserId = administrator.Id,
ReportId = teamsReport.Id,
FilterType = FilterType.EmployeeIds
}, cancellationToken);
var projectModelForTeams = await _mediator.Send(new GetUserReportGuidListQuery
{
UserId = administrator.Id,
ReportId = teamsReport.Id,
FilterType = FilterType.ProjectIds
}, cancellationToken);
var activityTypeForTeams = await _mediator.Send(new GetUserReportGuidListQuery
{
UserId = administrator.Id,
ReportId = teamsReport.Id,
FilterType = FilterType.ActivityTypeIds
}, cancellationToken);
var activityStatusesForTeams = await _mediator.Send(new GetUserReportActivityStatusesQuery
{
UserId = administrator.Id,
ReportId = teamsReport.Id
}, cancellationToken);
var teamsRequest = await _mediator.Send(new GetTeamsByFiltersReportQuery
{
ProjectIds = projectModelForTeams.GuidList,
ActivityStatuses = activityStatusesForTeams.ActivityStatuses,
ActivityTypeIds = activityTypeForTeams.GuidList,
EmployeeIds = employeeModelForTeams.GuidList,
StartDate = new DateTime(yesterday.Year, yesterday.Month, yesterday.Day, 23, 59, 59),
DueDate = now
}, cancellationToken);
var tableHeaders = tableHelper.GetTeamsByFiltersReportTableHeaders();
teamsAttachment = excelReportHelper.GetTeamsByFiltersReport(teamsRequest, tableHeaders);
teamsHtmlContent = GetTeamsHtmlContent(teamsRequest);
}
#endregion
var projectsHtmlContent = new StringBuilder();
#region Projects report
var userProjectsReport = await _mediator.Send(new GetUserReportDetailsQuery
{
UserId = administrator.Id,
ReportId = projectsReport.Id
}, cancellationToken);
byte[] projectsAttachment = null;
if (userProjectsReport.Active)
{
var projectModelForProjects = await _mediator.Send(new GetUserReportGuidListQuery
{
UserId = administrator.Id,
ReportId = projectsReport.Id,
FilterType = FilterType.ProjectIds
}, cancellationToken);
var activityTypeForProjects = await _mediator.Send(new GetUserReportGuidListQuery
{
UserId = administrator.Id,
ReportId = projectsReport.Id,
FilterType = FilterType.ActivityTypeIds
}, cancellationToken);
var activityStatusesForProjects = await _mediator.Send(
new GetUserReportActivityStatusesQuery
{
UserId = administrator.Id,
ReportId = projectsReport.Id
}, cancellationToken);
var projectsRequest = await _mediator.Send(new GetProjectsByFiltersReportQuery
{
ProjectIds = projectModelForProjects.GuidList,
ActivityStatuses = activityStatusesForProjects.ActivityStatuses,
ActivityTypes = activityTypeForProjects.GuidList,
StartDate = new DateTime(yesterday.Year, yesterday.Month, yesterday.Day, 23, 59, 59),
DueDate = now
}, cancellationToken);
var tableHeaders = tableHelper.GetProjectsByFiltersReportTableHeaders();
projectsAttachment =
excelReportHelper.GetProjectsByFiltersReport(projectsRequest, tableHeaders);
projectsHtmlContent = GetProjectsHtmlContent(projectsRequest);
}
#endregion
var attachments = new List <Attachment>();
if (teamsAttachment != null)
{
attachments.Add(new Attachment
{
Content = teamsAttachment,
ContentId = Guid.NewGuid().ToString(),
Disposition = "attachment",
Filename = $"TodayLogs-Employees-YMD-{now.Year}-{now.Month}-{now.Day}.xlsx",
Type = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
});
}
if (projectsAttachment != null)
{
attachments.Add(new Attachment
{
Content = projectsAttachment,
ContentId = Guid.NewGuid().ToString(),
Disposition = "attachment",
Filename = $"TodayLogs-Projects-YMD-{now.Year}-{now.Month}-{now.Day}.xlsx",
Type = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
});
}
if (!attachments.Any())
{
continue;
}
var htmlMessageContent = $"Daily logs report on today for the Administrator {administrator.Email}\n"
+ teamsHtmlContent
+ "\n<hr>\n"
+ projectsHtmlContent;
var message = new Message
{
Subject = $"Daily Logs Tasks Report for {today}",
Body = htmlMessageContent,
To = administrator.Email,
Attachments = attachments,
EventName = "DailyLogsNotifications",
SentTime = now,
From = "*****@*****.**"
};
try
{
await _notification.SendAsync(message);
}
catch (Exception exception)
{
Debug.WriteLine(exception);
}
}
}
}
public byte[] GetProjectsByFiltersReport(ProjectFilteredReportListViewModel request,
IList <ExcelTableCell> tableHeaders)
{
var tableNames = tableHeaders.Where(x => x.IsActive).Select(x => x.Name).ToList();
var tableHelper = new ExcelTableHelper();
var headers = tableHelper.GetProjectsByFiltersReportTableHeaders();
var result = new StringBuilder();
result.Append(string.Join(',', tableNames));
result.AppendLine();
var row = 0;
foreach (var project in request.Projects)
{
foreach (var activity in project.ActivityView.Activities)
{
foreach (var assignee in activity.AssigneeView.Assignees)
{
var activityStatus = assignee.LoggedTimeView.LoggedTimes[0].ActivityStatus;
var activityType = assignee.LoggedTimeView.LoggedTimes[0].ActivityType;
foreach (var name in tableNames)
{
if (name == headers[0].Name)
{
result.Append($"{++row}, ");
}
else if (name == headers[1].Name)
{
result.Append($"{project.ProjectName}, ");
}
else if (name == headers[2].Name)
{
result.Append($"{assignee.AssigneeName}, ");
}
else if (name == headers[3].Name)
{
result.Append($"{activity.ActivityName}, ");
}
else if (name == headers[4].Name)
{
result.Append($"{activityStatus}, ");
}
else if (name == headers[5].Name)
{
result.Append($"{activityType}, ");
}
else if (name == headers[6].Name)
{
result.Append($"{assignee.LoggedTimeView.TotalEstimatedTime}, ");
}
else if (name == headers[7].Name)
{
result.Append($"{assignee.LoggedTimeView.TotalLoggedTime}, ");
}
}
result.AppendLine();
}
}
}
return(Encoding.Unicode.GetBytes(result.ToString()));
}
private StringBuilder GetProjectsHtmlContent(ProjectFilteredReportListViewModel request)
{
var result = new StringBuilder();
result.AppendLine("<table name=\"teams-report\">");
result.AppendLine("<tr>");
var tableHelper = new ExcelTableHelper();
var tableHeaders = tableHelper.GetProjectsByFiltersReportTableHeaders();
foreach (var item in tableHeaders)
{
result.AppendLine($"<th style=\"width:{item.Width}px; alignment:{item.Alignment.ToString().ToLower()};\">{item.Name}</th>");
}
var rowOrder = 0;
result.AppendLine("</tr>");
var previousAssigneeName = string.Empty;
foreach (var project in request.Projects)
{
var previousProjectName = string.Empty;
var previousActivityName = string.Empty;
foreach (var activity in project.ActivityView.Activities)
{
foreach (var assignee in activity.AssigneeView.Assignees)
{
var loggedTime = assignee.LoggedTimeView.LoggedTimes[0];
result.AppendLine("<tr>");
result.AppendLine($"<td>{++rowOrder}</td>");
var projectNameReference =
EliminatedDuplicate(project.ProjectName, previousProjectName) != string.Empty
? $"<a href=\"{IndrivoAddress}/Activities/{project.ProjectId}\">" +
$"{EliminatedDuplicate(project.ProjectName, previousProjectName)}</a>"
: $"{EliminatedDuplicate(project.ProjectName, previousProjectName)}";
result.AppendLine(
$"<td>" +
$"{projectNameReference}</td>");
var activityNameReference =
EliminatedDuplicate(activity.ActivityName, previousActivityName) != string.Empty
? $"<a href=\"{IndrivoAddress}/Activities/Details/{activity.ActivityId}\">" +
$"{EliminatedDuplicate(activity.ActivityName, previousActivityName)}</a>"
: $"{EliminatedDuplicate(activity.ActivityName, previousActivityName)}";
result.AppendLine(
$"<td>" +
$"{activityNameReference}</td>");
var assigneeNameReference =
EliminatedDuplicate(assignee.AssigneeName, previousAssigneeName) != string.Empty
? $"<a href=\"{IndrivoAddress}/ApplicationUsers/Details/{assignee.AssigneeId}\">" +
$"{EliminatedDuplicate(assignee.AssigneeName, previousAssigneeName)}</a>"
: $"{EliminatedDuplicate(assignee.AssigneeName, previousAssigneeName)}";
result.AppendLine(
$"<td>{assigneeNameReference}</td>");
result.AppendLine($"<td>{loggedTime.ActivityStatus}</td>");
result.AppendLine($"<td>{loggedTime.ActivityType}</td>");
result.AppendLine($"<td>{assignee.LoggedTimeView.TotalEstimatedTime}</td>");
result.AppendLine($"<td>{assignee.LoggedTimeView.TotalLoggedTime}</td>");
result.AppendLine("</tr>");
previousAssigneeName = assignee.AssigneeName;
previousActivityName = activity.ActivityName;
previousProjectName = project.ProjectName;
}
}
}
result.AppendLine("</table>");
return(result);
}