private Workbook ConstructWorkbook()
{
Workbook workBook = new Workbook();
Worksheet workSheet = AddWorkSheet(ref workBook);
workSheet = AddColumnHeadings(workSheet);
for (int i = 0; i < this.NominatedRequestPersons.Count; i++)
{
RequestPerson rp = this.NominatedRequestPersons[i];
workSheet.Cells[i + 1, 0].PutValue(rp.Person.Name);
int j = 0;
for (j = 0; j < this.ScreeningEntities.Count; j++)
{
ScreeningEntity se = this.ScreeningEntities[j];
ScreeningRequestPersonEntity srpe = rp.GetMostRecentScreeningRequestPersonEntity(se.ScreeningEntityName);
if (srpe != null)
{
workSheet.Cells[i + 1, j + 1].PutValue(srpe.ScreeningResult.ToString());
workSheet.Cells[i + 1, j + 1].SetStyle(GetCellStyleForResult(srpe.ScreeningResult.ToString()));
}
}
//dsrsg
ScreeningRequestPersonRecommendation srpr = rp.GetScreeningRequestPersonRecommendation();
if (srpr != null)
{
workSheet.Cells[i + 1, j + 1].PutValue(srpr.ScreeningResult.ToString());
workSheet.Cells[i + 1, j + 1].SetStyle(GetCellStyleForResult(srpr.ScreeningResult.ToString()));
}
//the user's commentary and reason; dsrsg commentary if no screening entity
if (!string.IsNullOrEmpty(this.UserScreeningEntityName))
{
ScreeningRequestPersonEntity srpe = rp.GetMostRecentScreeningRequestPersonEntity(this.UserScreeningEntityName);
if (srpe != null)
{
workSheet.Cells[i + 1, j + 2].PutValue(srpe.Reason);
workSheet.Cells[i + 1, j + 3].PutValue(srpe.Commentary);
}
}
else
if (srpr != null)
{
workSheet.Cells[i + 1, j + 3].PutValue(srpr.Commentary);
}
}
workSheet.AutoFitColumns();
return(workBook);
}
/// <summary>
/// Sets a row in the person attached
/// </summary>
/// <param name="row">The row that has already been added to the persons attached table</param>
/// <param name="person">The person whose details should be added to the row</param>
/// <returns>Pdf row object</returns>
private Row SetPersonAttachedRow(ScreeningEntity screeningEntity, Row row, RequestPerson requestPerson)
{
string personName;
Text text;
Cell cell;
TextInfo textInfo = new TextInfo();
row.VerticalAlignment = VerticalAlignmentType.Top;
row.IsBroken = false;
//text customization for labels in request details
textInfo.FontSize = 12;
textInfo.IsTrueTypeFontBold = false;
textInfo.Alignment = AlignmentType.Center;
//Name Column
personName = requestPerson.Person.Name;
cell = row.Cells.Add(personName.Trim(), textInfo);
//Military ID Column
cell = row.Cells.Add(requestPerson.Person.MilitaryIDNumber, textInfo);
//Color
ScreeningRequestPersonEntity srpe = requestPerson.GetMostRecentScreeningRequestPersonEntity(screeningEntity.ScreeningEntityName);
string color = string.Empty;
if (srpe != null)
{
color = srpe.ScreeningResult.ToString();
}
cell = row.Cells.Add();
text = new Text(color);
if (!string.IsNullOrEmpty(color))
{
//Green
if (color.Equals(ScreeningResult.GREEN, StringComparison.OrdinalIgnoreCase))
{
text.TextInfo.BackgroundColor = new Color("Green");
text.TextInfo.Color = new Color("White");
}
//Yellow
else if (color.Equals(ScreeningResult.YELLOW, StringComparison.OrdinalIgnoreCase))
{
text.TextInfo.BackgroundColor = new Color("Yellow");
text.TextInfo.Color = new Color("Black");
}
//Red
else if (color.Equals(ScreeningResult.RED, StringComparison.OrdinalIgnoreCase))
{
text.TextInfo.BackgroundColor = new Color("Red");
text.TextInfo.Color = new Color("White");
}
}
text.TextInfo.Alignment = AlignmentType.Center;
text.TextInfo.LineSpacing = 6;
cell.Paragraphs.Add(text);
//Reason
cell = row.Cells.Add(srpe != null ? srpe.Reason : string.Empty, textInfo);
//Commentary
cell = row.Cells.Add(srpe != null ? srpe.Commentary : string.Empty, textInfo);
return(row);
}