public static IList<string> GetAuthorizedRolesForArea(Area area)
{
var authorizedRoles = new List<string>();
var editRole = EDIT_AREA_ROLE_PREFIX + area.Number;
authorizedRoles.Add(editRole);
authorizedRoles.Add(MANAGE_ALL_AREAS_ROLE);
return authorizedRoles;
}
private ExcelWorksheet WriteAreaData(ExcelWorksheet sheet, Area area)
{
int column = 0;
#region Area Name
Row++;
ExcelRange range_areaName = sheet.Cells[Row, 1, Row, NUM_COLUMNS];
range_areaName.Merge = true;
range_areaName.Style.Font.SetFromFont(new Font("Calibri", 11, FontStyle.Italic));
range_areaName.Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.CenterContinuous;
range_areaName.Value = area.Name;
#endregion
#region Area Funds
IEnumerable<Fund> areaFunds = Funds.Where(f => f.AreaId == area.Id);
if (areaFunds.Count() == 0)
{
Row++;
ExcelRange range_areaData = sheet.Cells[Row, 1, Row, NUM_COLUMNS];
range_areaData.Merge = true;
range_areaData.Style.Font.SetFromFont(new Font("Calibri", 11, FontStyle.Regular));
range_areaData.Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.CenterContinuous;
range_areaData.Value = "No records";
}
else
{
foreach (Fund fund in areaFunds)
{
Row++;
column = 0;
sheet.Cells[Row, ++column].Value = fund.Number;
sheet.Cells[Row, ++column].Value = fund.Title;
sheet.Cells[Row, ++column].Value = fund.Description;
sheet.Cells[Row, ++column].Value = fund.BudgetAdjustmentNote;
sheet.Cells[Row, ++column].Value = fund.BudgetAdjustment * -1;
}
}
#endregion
return sheet;
}
private ExcelWorksheet WriteAreaData(ExcelWorksheet sheet, Area area)
{
int column = 0;
#region Area Name
Row++;
ExcelRange range_areaName = sheet.Cells[Row, 1, Row, NUM_COLUMNS];
range_areaName.Merge = true;
range_areaName.Style.Font.SetFromFont(new Font("Calibri", 11, FontStyle.Italic));
range_areaName.Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.CenterContinuous;
range_areaName.Value = area.Name;
#endregion
#region Area Funds
IEnumerable<Fund> areaFunds = Funds.Where(f => f.AreaId == area.Id);
if (areaFunds.Count() == 0)
{
Row++;
ExcelRange range_areaData = sheet.Cells[Row, 1, Row, NUM_COLUMNS];
range_areaData.Merge = true;
range_areaData.Style.Font.SetFromFont(new Font("Calibri", 11, FontStyle.Regular));
range_areaData.Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.CenterContinuous;
range_areaData.Value = "No records";
}
else
{
foreach (Fund fund in areaFunds)
{
Row++;
column = 0;
sheet.Cells[Row, ++column].Value = fund.Number;
sheet.Cells[Row, ++column].Value = fund.Title;
sheet.Cells[Row, ++column].Value = fund.ResponsiblePerson;
sheet.Cells[Row, ++column].Value = fund.CurrentBudget;
sheet.Cells[Row, ++column].Value = fund.ProjectedExpenditures;
sheet.Cells[Row, ++column].Value = (fund.CurrentBudget + fund.BudgetAdjustment);
sheet.Cells[Row, ++column].Value = fund.BudgetAdjustment * -1;
}
}
#endregion
#region Area Summary
Row++;
column = 0;
ExcelRange range_areaSummary = sheet.Cells[Row, 1, Row, NUM_COLUMNS];
range_areaSummary.Style.Font.SetFromFont(new Font("Calibri", 11, FontStyle.Bold));
range_areaSummary.Style.Font.Color.SetColor(Color.White);
range_areaSummary.Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
range_areaSummary.Style.Fill.BackgroundColor.SetColor(Color.FromArgb(107, 107, 107));
ExcelRange range_areaSummaryTitle = sheet.Cells[Row, 1, Row, NUM_COLUMNS - SUMMARY_DATA_COLUMNS];
range_areaSummaryTitle.Merge = true;
range_areaSummaryTitle.Value = "Total for " + area.Name;
sheet.Cells[Row, SUMMARY_DATA_COLUMNS].Value = areaFunds
.Sum(f => f.CurrentBudget);
sheet.Cells[Row, ++column + SUMMARY_DATA_COLUMNS].Value = areaFunds
.Sum(f => f.ProjectedExpenditures);
sheet.Cells[Row, ++column + SUMMARY_DATA_COLUMNS].Value = areaFunds
.Sum(f => f.CurrentBudget + f.BudgetAdjustment);
sheet.Cells[Row, ++column + SUMMARY_DATA_COLUMNS].Value = areaFunds
.Sum(f => f.BudgetAdjustment * -1);
#endregion
return sheet;
}