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); }