protected CertificatesSourceExcelFileBase(AwardsPeriod awardsPeriod, IEnumerable <AwardWinner> certificateRecipients)
: base((com, worksheet) => BuildWorksheet(com,
awardsPeriod ?? throw new ArgumentNullException(nameof(awardsPeriod)),
certificateRecipients ?? throw new ArgumentNullException(nameof(certificateRecipients)),
worksheet))
{
}
private AwardsPeriod GetAwardPeriod(out CommandResult <CommandOutput.None> unsuccessfulResult)
{
var awardCategory = GetAwardCategory(out unsuccessfulResult);
if (awardCategory == null)
{
return(null);
}
var year = GetCommandResult(new GetYearCommand(Context), out unsuccessfulResult);
if (year == null)
{
return(null);
}
if (awardCategory == AwardCategory.SuperStarAwards)
{
return(AwardsPeriod.CreateForSuperStarAwards(year));
}
if (awardCategory != AwardCategory.QuarterlyAwards)
{
throw new NotSupportedException($@"Unsupported award category: {awardCategory.Value}");
}
var quarter = GetCommandResult(new GetQuarterCommand(Context), out unsuccessfulResult);
return(quarter == null
? null
: AwardsPeriod.CreateForQuarterlyAwards(year, quarter));
}
protected NominationNotificationEmailSourceExcelFileBase(AwardsPeriod awardsPeriod,
IEnumerable <Nomination> nominations)
: base((com, worksheet) => BuildWorksheet(com,
awardsPeriod ?? throw new ArgumentNullException(nameof(awardsPeriod)),
nominations ?? throw new ArgumentNullException(nameof(nominations)),
worksheet))
{
}
internal NominationList(AwardsPeriod awardsPeriod, IEnumerable <Nomination> nominations,
IEnumerable <AwardWinner> awardWinners = null)
: base(awardsPeriod?.Value ?? -1)
{
AwardsPeriod = awardsPeriod ?? throw new ArgumentNullException(nameof(awardsPeriod));
_nominations = nominations?.ToList() ?? throw new ArgumentNullException(nameof(nominations));
_awardWinners = awardWinners?.ToList() ?? new List <AwardWinner>();
SetNomineeIdentifiers();
}
private static void BuildWorksheet(ComObjectManager com, AwardsPeriod awardsPeriod,
IEnumerable <Nomination> nominations, Worksheet worksheet)
{
var cells = com.Get(() => worksheet.Cells);
cells.NumberFormat = "@"; // Format all cells as text.
SetCellValue(cells, 1, 1, @"Year");
SetCellValue(cells, 1, 2, @"Quarter");
SetCellValue(cells, 1, 3, @"Submitted by");
SetCellValue(cells, 1, 4, @"NOMINEE'S NAME");
SetCellValue(cells, 1, 5, @"NOMINEE'S OFFICE");
SetCellValue(cells, 1, 6, @"Continuously_Improving");
SetCellValue(cells, 1, 7, @"Driving_Innovation");
SetCellValue(cells, 1, 8, @"Delighting_Customers");
SetCellValue(cells, 1, 9, @"Behaving_with_Integrity");
SetCellValue(cells, 1, 10, @"Delivering_Meaningful_Outcomes");
SetCellValue(cells, 1, 11, @"Streaming_Good");
SetCellValue(cells, 1, 12, @"WRITE-UP");
SetCellValue(cells, 1, 13, @"Email");
var rowNumber = 2;
foreach (var nomination in nominations)
{
SetCellValue(cells, rowNumber, 1, awardsPeriod.Year.ToString());
SetCellValue(cells, rowNumber, 2, awardsPeriod.Quarter.Abbreviation);
SetCellValue(cells, rowNumber, 3, nomination.NominatorName.FullName);
SetCellValue(cells, rowNumber, 4, nomination.NomineeName.FullName);
SetCellValue(cells, rowNumber, 5, nomination.NomineeOfficeLocation.ToString());
SetCellValue(cells, rowNumber, 6, GetCompanyValue(nomination, CompanyValue.ContinuouslyImproving));
SetCellValue(cells, rowNumber, 7, GetCompanyValue(nomination, CompanyValue.DrivingInnovation));
SetCellValue(cells, rowNumber, 8, GetCompanyValue(nomination, CompanyValue.DelightingCustomers));
SetCellValue(cells, rowNumber, 9, GetCompanyValue(nomination, CompanyValue.BehavingWithIntegrity));
SetCellValue(cells, rowNumber, 10, GetCompanyValue(nomination, CompanyValue.DeliveringMeaningfulOutcomes));
SetCellValue(cells, rowNumber, 11, GetCompanyValue(nomination, CompanyValue.StreamingGood));
SetCellValue(cells, rowNumber, 12, nomination.WriteUp.ToString());
SetCellValue(cells, rowNumber, 13, nomination.NomineeEmailAddress.ToString());
++rowNumber;
}
}
private static void BuildWorksheet(ComObjectManager com, AwardsPeriod awardsPeriod,
IEnumerable <AwardWinner> certificateRecipients, Worksheet worksheet)
{
var cells = com.Get(() => worksheet.Cells);
cells.NumberFormat = "@"; // Format all cells as text.
SetCellValue(cells, 1, 1, @"Year");
SetCellValue(cells, 1, 2, @"Quarter");
SetCellValue(cells, 1, 3, @"Name");
var rowNumber = 2;
foreach (var certificateRecipient in certificateRecipients)
{
SetCellValue(cells, rowNumber, 1, awardsPeriod.Year.ToString());
SetCellValue(cells, rowNumber, 2, awardsPeriod.Quarter.FullName);
SetCellValue(cells, rowNumber, 3, certificateRecipient.Name.FullName);
++rowNumber;
}
}
public void Initialize(DirectoryPath starAwardsDirectoryPath, AwardsPeriod awardsPeriod, Person eiaCoChair1,
Person eiaCoChair2, ICollection <Person> hrPeople, ICollection <Person> luncheonPlannerPeople,
Person certificatePrinterPerson)
{
_starAwardsDirectoryPath = starAwardsDirectoryPath ??
throw new ArgumentNullException(nameof(starAwardsDirectoryPath));
_awardsPeriod = awardsPeriod ?? throw new ArgumentNullException(nameof(awardsPeriod));
_workingDirectoryPath = _starAwardsDirectoryPath.GetWorkingDirectory(_awardsPeriod);
_eiaCoChair1 = eiaCoChair1 ?? throw new ArgumentNullException(nameof(eiaCoChair1));
_eiaCoChair2 = eiaCoChair2 ?? throw new ArgumentNullException(nameof(eiaCoChair2));
_hrPeople = hrPeople?.ToList() ?? throw new ArgumentNullException(nameof(hrPeople));
_luncheonPlannerPeople = luncheonPlannerPeople?.ToList() ??
throw new ArgumentNullException(nameof(luncheonPlannerPeople));
_certificatePrinterPerson = certificatePrinterPerson ??
throw new ArgumentNullException(nameof(certificatePrinterPerson));
var nominationListRepository = new NominationListRepository(_workingDirectoryPath);
_nominationListContext = new NominationListContext(nominationListRepository, awardsPeriod.AwardCategory);
IsInitialized = true;
}
