public ActionResult UnitSalariesByFacultyType(string id)
{
var authorizedDepartments = GetAuthorizedDepartments(id);
if (authorizedDepartments.Count > 0)
{
var salaries = DbContext.Salaries
.Include("FacultyType")
.Where(s => s.Person.Employments.Any(e => e.Department.UnitId == id));
var package = new ExcelPackage();
var header = "Salaries By Faculty Type: " + authorizedDepartments.FirstOrDefault().Unit.Name +
" " + TimeZoneInfo.ConvertTimeBySystemTimeZoneId(
System.DateTime.Now, TimeZoneInfo.Local.Id, "Eastern Standard Time").ToString("MMMM dd, yyyy");
var report = new SalariesByFacultyTypeReport(package, authorizedDepartments, salaries, true,
header, null, "Salaries by faculty type");
return File(report.Package.GetAsByteArray(), report.FileType, report.FileName);
}
return new HttpUnauthorizedResult();
}
public ActionResult ExecutiveUnitMeeting(string id)
{
var authorizedDepartments = GetAuthorizedDepartments(id);
if (authorizedDepartments.Count > 0)
{
var salaries = GetUnitMeetingSalaries(id);
var package = new ExcelPackage();
var fileName = "FacSal_ExecutiveMeetingReport_" +
TimeZoneInfo.ConvertTimeBySystemTimeZoneId(
System.DateTime.Now, TimeZoneInfo.Local.Id, "Eastern Standard Time").ToString()
+ ".xlsx";
new MeetingReport(package, authorizedDepartments, salaries, 15, true,
fileName);
var header = "Virginia Tech Meeting Report: " + authorizedDepartments.FirstOrDefault().Unit.Name +
" " + TimeZoneInfo.ConvertTimeBySystemTimeZoneId(
System.DateTime.Now, TimeZoneInfo.Local.Id, "Eastern Standard Time").ToString("MMMM dd, yyyy");
var report = new SalariesByFacultyTypeReport(package, authorizedDepartments, salaries, true, header,
fileName, "Unit summary");
return File(report.Package.GetAsByteArray(), report.FileType, report.FileName);
}
return new HttpUnauthorizedResult();
}
public ActionResult DepartmentSalariesByFacultyType(string id)
{
if (User.IsInRole("manage-all") ||
User.IsInRole("read-" + id))
{
var department = DbContext.Departments
.Include("Unit")
.Where(d => d.Id == id)
.ToList()[0];
var salaries = DbContext.Salaries
.Include("FacultyType")
.Where(s => s.Person.Employments.Any(e => e.DepartmentId == id));
var package = new ExcelPackage();
var header = "Salaries By Faculty Type: " + department.Unit.Name +
" " + TimeZoneInfo.ConvertTimeBySystemTimeZoneId(
System.DateTime.Now, TimeZoneInfo.Local.Id, "Eastern Standard Time").ToString("MMMM dd, yyyy");
var departments = new List<Department>() { department };
var report = new SalariesByFacultyTypeReport(package, departments, salaries, false,
header, null, "Salaries by faculty type");
return File(report.Package.GetAsByteArray(), report.FileType, report.FileName);
}
return new HttpUnauthorizedResult();
}
