public SmartCategory(TableRow row)
{
CategoryTitle = new SmartParagraph(row.Elements <TableCell>().ElementAt(1));
CategoryWeight = new SmartParagraph(row.Elements <TableCell>().ElementAt(2));
CategoryRating0 = new SmartParagraph(row.Elements <TableCell>().ElementAt(3));
CategoryRating1 = new SmartParagraph(row.Elements <TableCell>().ElementAt(4));
CategoryRating2 = new SmartParagraph(row.Elements <TableCell>().ElementAt(5));
CategoryRating3 = new SmartParagraph(row.Elements <TableCell>().ElementAt(6));
CategoryRating4 = new SmartParagraph(row.Elements <TableCell>().ElementAt(7));
CategoryTotal = new SmartParagraph(row.Elements <TableCell>().ElementAt(8));
}
public SmartJobDescriptionMappedFieldSet(MainDocumentPart mainPart)
{
Table JOBFields = mainPart.Document.Body.Elements <Table>().ElementAt(0);
JOB_EmployeeName = new SmartParagraph(JOBFields.Elements <TableRow>().ElementAt(3).Elements <TableCell>().ElementAt(0));
JOB_DistrictDivision = new SmartParagraph(JOBFields.Elements <TableRow>().ElementAt(1).Elements <TableCell>().ElementAt(2));
JOB_AgencyActivity = new SmartParagraph(JOBFields.Elements <TableRow>().ElementAt(1).Elements <TableCell>().ElementAt(3));
JOB_PositionNumber = new SmartParagraph(JOBFields.Elements <TableRow>().ElementAt(1).Elements <TableCell>().ElementAt(4));
JOB_ClassTitle = new SmartParagraph(JOBFields.Elements <TableRow>().ElementAt(3).Elements <TableCell>().ElementAt(1));
JOB_Grade = new SmartParagraph(JOBFields.Elements <TableRow>().ElementAt(3).Elements <TableCell>().ElementAt(2));
JOB_WorkingTitle = new SmartParagraph(JOBFields.Elements <TableRow>().ElementAt(5).Elements <TableCell>().ElementAt(1));
JOB_WorkAddress = new SmartParagraph(JOBFields.Elements <TableRow>().ElementAt(7).Elements <TableCell>().ElementAt(0));
JOB_WorkingHours = new SmartParagraph(JOBFields.Elements <TableRow>().ElementAt(7).Elements <TableCell>().ElementAt(1));
JOB_Supervisor = new SmartParagraph(JOBFields.Elements <TableRow>().ElementAt(9).Elements <TableCell>().ElementAt(0));
JOB_Supervises = new SmartParagraph(JOBFields.Elements <TableRow>().ElementAt(11).Elements <TableCell>().ElementAt(0));
JobDescriptionTable = mainPart.Document.Body.Elements <Table>().ElementAt(1);
}
public SmartAwardMappedFieldSet(MainDocumentPart mainPart)
{
Table HeaderFields = mainPart.Document.Body.Elements <Table>().ElementAt(0);
AgencyName = new SmartParagraph(HeaderFields.Elements <TableRow>().ElementAt(1).Elements <TableCell>().ElementAt(1));
EmployeeName = new SmartParagraph(HeaderFields.Elements <TableRow>().ElementAt(2).Elements <TableCell>().ElementAt(1));
EmployeeClassTitle = new SmartParagraph(HeaderFields.Elements <TableRow>().ElementAt(3).Elements <TableCell>().ElementAt(1));
EmployeeDivision = new SmartParagraph(HeaderFields.Elements <TableRow>().ElementAt(3).Elements <TableCell>().ElementAt(3));
Table MainTable = mainPart.Document.Body.Elements <Table>().ElementAt(1);
DedicatedAttendanceAward = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(1).Elements <TableCell>().ElementAt(0));
HonoraryAward = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(2).Elements <TableCell>().ElementAt(0));
CreativityAward = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(3).Elements <TableCell>().ElementAt(0));
ExemplaryPerformanceAward = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(4).Elements <TableCell>().ElementAt(0));
ExemplaryPerformanceDateRange = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(4).Elements <TableCell>().ElementAt(3));
SpecialAchievementAward = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(6).Elements <TableCell>().ElementAt(0));
EmployeeOfTheMonth = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(7).Elements <TableCell>().ElementAt(0));
EmployeeOfTheMonthDate = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(7).Elements <TableCell>().ElementAt(3));
EmployeeOfTheYear = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(8).Elements <TableCell>().ElementAt(0));
EmployeeOfTheYearDate = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(8).Elements <TableCell>().ElementAt(3));
CountyExecutiveAward = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(9).Elements <TableCell>().ElementAt(0));
LetterOfCommendation = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(11).Elements <TableCell>().ElementAt(0));
Certificate = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(12).Elements <TableCell>().ElementAt(0));
ConversionOfLeave = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(13).Elements <TableCell>().ElementAt(0));
ConversionOfLeaveConvertFromCount = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(13).Elements <TableCell>().ElementAt(2));
ConversionOfLeaveConvertToCount = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(13).Elements <TableCell>().ElementAt(4));
GrantOfLeave = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(14).Elements <TableCell>().ElementAt(0));
GrantOfLeaveCount = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(14).Elements <TableCell>().ElementAt(2));
NonBaseSalaryBonus = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(15).Elements <TableCell>().ElementAt(0));
NonBaseSalaryBonusPayDaysCount = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(15).Elements <TableCell>().ElementAt(2));
NonBaseSalaryBonusPayAmount = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(15).Elements <TableCell>().ElementAt(4));
OtherNonBaseSalaryBonus = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(16).Elements <TableCell>().ElementAt(0));
OtherNonBaseSalaryBonusAmount = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(16).Elements <TableCell>().ElementAt(2));
OtherRecognition = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(17).Elements <TableCell>().ElementAt(0));
OtherRecognitionSpecified = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(17).Elements <TableCell>().ElementAt(2));
OutstandingPerformance1 = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(22).Elements <TableCell>().ElementAt(0));
OutstandingPerformance2 = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(21).Elements <TableCell>().ElementAt(0));
OutstandingPerformance3 = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(20).Elements <TableCell>().ElementAt(0));
GoodConductAppraisalMinimumRatingRequirement = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(24).Elements <TableCell>().ElementAt(0));
GoodConductApprovalObtained = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(25).Elements <TableCell>().ElementAt(0));
GoodConductApprovalObtainedDate = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(25).Elements <TableCell>().ElementAt(3));
OtherJustification = new SmartParagraph(MainTable.Elements <TableRow>().ElementAt(27).Elements <TableCell>().ElementAt(0));
}
/// <summary>
/// Constructs a new instance of the class.
/// </summary>
/// <param name="mainPart">The template document's <see cref="MainDocumentPart"/></param>
public SmartPAFMappedFieldSet(MainDocumentPart mainPart)
{
Table PAFFields = mainPart.Document.Body.Elements <Table>().ElementAt(0);
PAF_ProbationaryMidpoint = new SmartParagraph(PAFFields.Elements <TableRow>().ElementAt(1).Elements <TableCell>().ElementAt(1));
PAF_PeriodicPerformanceAssessment = new SmartParagraph(PAFFields.Elements <TableRow>().ElementAt(2).Elements <TableCell>().ElementAt(1));
PAF_RatingJustification = new SmartParagraph(PAFFields.Elements <TableRow>().ElementAt(3).Elements <TableCell>().ElementAt(1));
PAF_EmployeeName = new SmartParagraph(PAFFields.Elements <TableRow>().ElementAt(5).Elements <TableCell>().ElementAt(1));
PAF_PayrollId = new SmartParagraph(PAFFields.Elements <TableRow>().ElementAt(6).Elements <TableCell>().ElementAt(1));
PAF_StartDate = new SmartParagraph(PAFFields.Elements <TableRow>().ElementAt(7).Elements <TableCell>().ElementAt(1));
PAF_EndDate = new SmartParagraph(PAFFields.Elements <TableRow>().ElementAt(7).Elements <TableCell>().ElementAt(3));
PAF_ClassGrade = new SmartParagraph(PAFFields.Elements <TableRow>().ElementAt(9).Elements <TableCell>().ElementAt(1));
PAF_DistrictDivision = new SmartParagraph(PAFFields.Elements <TableRow>().ElementAt(8).Elements <TableCell>().ElementAt(1));
PAF_Assessment = new SmartParagraph(mainPart.Document.Body.Elements <Table>().ElementAt(1).Elements <TableRow>().ElementAt(1).Elements <TableCell>().ElementAt(0));
PAF_Assessment_Chunk = mainPart.AddAlternativeFormatImportPart(AlternativeFormatImportPartType.Html, "assessmentChunk");
PAF_Recommendations = new SmartParagraph(mainPart.Document.Body.Elements <Table>().ElementAt(2).Elements <TableRow>().ElementAt(1).Elements <TableCell>().ElementAt(0));
PAF_Recommendations_Chunk = mainPart.AddAlternativeFormatImportPart(AlternativeFormatImportPartType.Html, "recommendationsChunk");
}
/// <summary>
/// Constructs a new instance of the class.
/// </summary>
/// <param name="mainPart">The template document's <see cref="MainDocumentPart"/></param>
public SmartPPAMappedFieldSet(MainDocumentPart mainPart)
{
// PPA Fields start in table 1
Table PPAFields = mainPart.Document.Body.Elements <Table>().ElementAt(0);
PPA_EmployeeName = new SmartParagraph(PPAFields.Elements <TableRow>().ElementAt(0).Elements <TableCell>().ElementAt(1));
PPA_PayrollId = new SmartParagraph(PPAFields.Elements <TableRow>().ElementAt(0).Elements <TableCell>().ElementAt(3));
PPA_ClassTitle = new SmartParagraph(PPAFields.Elements <TableRow>().ElementAt(2).Elements <TableCell>().ElementAt(3));
PPA_Grade = new SmartParagraph(PPAFields.Elements <TableRow>().ElementAt(2).Elements <TableCell>().ElementAt(4));
PPA_PositionNumber = new SmartParagraph(PPAFields.Elements <TableRow>().ElementAt(2).Elements <TableCell>().ElementAt(5));
PPA_StartDate = new SmartParagraph(PPAFields.Elements <TableRow>().ElementAt(2).Elements <TableCell>().ElementAt(0));
PPA_EndDate = new SmartParagraph(PPAFields.Elements <TableRow>().ElementAt(2).Elements <TableCell>().ElementAt(2));
PPA_DistrictDivision = new SmartParagraph(PPAFields.Elements <TableRow>().ElementAt(4).Elements <TableCell>().ElementAt(3));
PPA_AgencyActivity = new SmartParagraph(PPAFields.Elements <TableRow>().ElementAt(4).Elements <TableCell>().ElementAt(4));
PPA_Categories = new List <SmartCategory>();
Table PPACategories = mainPart.Document.Body.Elements <Table>().ElementAt(0);
for (int i = 6; i < 12; i++)
{
PPA_Categories.Add(new SmartCategory(PPACategories.Elements <TableRow>().ElementAt(i)));
}
PPA_TotalRatingValue = new SmartParagraph(PPACategories.Elements <TableRow>().ElementAt(12).Elements <TableCell>().ElementAt(1));
PPA_UnsatisfactoryRatingCheckBox = new SmartParagraph(PPAFields.Elements <TableRow>().ElementAt(13).Elements <TableCell>().ElementAt(1));
PPA_NeedsImprovementRatingCheckBox = new SmartParagraph(PPAFields.Elements <TableRow>().ElementAt(13).Elements <TableCell>().ElementAt(3));
PPA_SatisfactoryRatingCheckBox = new SmartParagraph(PPAFields.Elements <TableRow>().ElementAt(13).Elements <TableCell>().ElementAt(5));
PPA_ExceedsSatisfactoryRatingCheckBox = new SmartParagraph(PPAFields.Elements <TableRow>().ElementAt(13).Elements <TableCell>().ElementAt(7));
PPA_OutstandingRatingCheckBox = new SmartParagraph(PPAFields.Elements <TableRow>().ElementAt(13).Elements <TableCell>().ElementAt(9));
PPA_MeritApprovedCheckBox = new SmartParagraph(PPAFields.Elements <TableRow>().ElementAt(16).Elements <TableCell>().ElementAt(1));
PPA_MeritNotApprovedCheckBox = new SmartParagraph(PPAFields.Elements <TableRow>().ElementAt(16).Elements <TableCell>().ElementAt(5));
PPA_MeritNotApplicableCheckBox = new SmartParagraph(PPAFields.Elements <TableRow>().ElementAt(16).Elements <TableCell>().ElementAt(3));
// TODO: Consider adding Probationary Midpoint/Rating Justification?
Table PAFFields = mainPart.Document.Body.Elements <Table>().ElementAt(1);
PAF_EmployeeName = new SmartParagraph(PAFFields.Elements <TableRow>().ElementAt(5).Elements <TableCell>().ElementAt(1));
PAF_PayrollId = new SmartParagraph(PAFFields.Elements <TableRow>().ElementAt(6).Elements <TableCell>().ElementAt(1));
PAF_StartDate = new SmartParagraph(PAFFields.Elements <TableRow>().ElementAt(7).Elements <TableCell>().ElementAt(1));
PAF_EndDate = new SmartParagraph(PAFFields.Elements <TableRow>().ElementAt(7).Elements <TableCell>().ElementAt(3));
PAF_ClassGrade = new SmartParagraph(PAFFields.Elements <TableRow>().ElementAt(9).Elements <TableCell>().ElementAt(1));
PAF_DistrictDivision = new SmartParagraph(PAFFields.Elements <TableRow>().ElementAt(8).Elements <TableCell>().ElementAt(1));
PAF_Assessment = new SmartParagraph(mainPart.Document.Body.Elements <Table>().ElementAt(2).Elements <TableRow>().ElementAt(1).Elements <TableCell>().ElementAt(0));
PAF_Assessment_Chunk = mainPart.AddAlternativeFormatImportPart(AlternativeFormatImportPartType.Html, "assessmentChunk");
PAF_Recommendations = new SmartParagraph(mainPart.Document.Body.Elements <Table>().ElementAt(3).Elements <TableRow>().ElementAt(1).Elements <TableCell>().ElementAt(0));
PAF_Recommendations_Chunk = mainPart.AddAlternativeFormatImportPart(AlternativeFormatImportPartType.Html, "recommendationsChunk");
Table JOBFields = mainPart.Document.Body.Elements <Table>().ElementAt(4);
JOB_EmployeeName = new SmartParagraph(JOBFields.Elements <TableRow>().ElementAt(3).Elements <TableCell>().ElementAt(0));
JOB_DistrictDivision = new SmartParagraph(JOBFields.Elements <TableRow>().ElementAt(1).Elements <TableCell>().ElementAt(2));
JOB_AgencyActivity = new SmartParagraph(JOBFields.Elements <TableRow>().ElementAt(1).Elements <TableCell>().ElementAt(3));
JOB_PositionNumber = new SmartParagraph(JOBFields.Elements <TableRow>().ElementAt(1).Elements <TableCell>().ElementAt(4));
JOB_ClassTitle = new SmartParagraph(JOBFields.Elements <TableRow>().ElementAt(3).Elements <TableCell>().ElementAt(1));
JOB_Grade = new SmartParagraph(JOBFields.Elements <TableRow>().ElementAt(3).Elements <TableCell>().ElementAt(2));
JOB_WorkingTitle = new SmartParagraph(JOBFields.Elements <TableRow>().ElementAt(5).Elements <TableCell>().ElementAt(1));
JOB_WorkAddress = new SmartParagraph(JOBFields.Elements <TableRow>().ElementAt(7).Elements <TableCell>().ElementAt(0));
JOB_WorkingHours = new SmartParagraph(JOBFields.Elements <TableRow>().ElementAt(7).Elements <TableCell>().ElementAt(1));
JOB_Supervisor = new SmartParagraph(JOBFields.Elements <TableRow>().ElementAt(9).Elements <TableCell>().ElementAt(0));
JOB_Supervises = new SmartParagraph(JOBFields.Elements <TableRow>().ElementAt(11).Elements <TableCell>().ElementAt(0));
JobDescriptionTable = mainPart.Document.Body.Elements <Table>().ElementAt(5);
}
