public void FormatHeadings() { PTSProject.clsTraining TrainCL = Container.Resolve <clsTraining>(); if (ViewModel.FirstTime) { return; } ViewModel.sprReport.Row = 3; ViewModel.sprReport.Row2 = ViewModel.sprReport.MaxRows; ViewModel.sprReport.Col = 1; ViewModel.sprReport.Col2 = ViewModel.sprReport.MaxCols; ViewModel.sprReport.BlockMode = true; ViewModel.sprReport.Text = ""; // sprReport.BackColor = WHITE ViewModel.sprReport.BlockMode = false; string sHeading = "Annual OTEP Modules For "; sHeading = sHeading + ViewModel.CurrYear.ToString(); ViewModel.sprReport.Row = 2; ViewModel.sprReport.Col = 1; ViewModel.sprReport.Text = sHeading; sHeading = "OTEP Module Reporting For "; if (ViewModel.optPM.Checked) { if (ViewModel.CurrShift == "") { sHeading = sHeading + "Paramedics Only \\ All Shifts"; } else { sHeading = sHeading + "Paramedics Only \\ Shift " + ViewModel.CurrShift; } if (ViewModel.CurrGroup != 0) { sHeading = sHeading + " \\ Group " + ViewModel.CurrGroup.ToString(); } } else { if (ViewModel.CurrBatt == "") { if (ViewModel.CurrShift == "") { sHeading = sHeading + "All Battalions \\ Shifts"; } else { sHeading = sHeading + "All Battalions \\ Shift " + ViewModel.CurrShift; } if (ViewModel.CurrGroup != 0) { sHeading = sHeading + " \\ Group " + ViewModel.CurrGroup.ToString(); } } else { sHeading = sHeading + "Battalion " + ViewModel.CurrBatt + " "; if (ViewModel.CurrShift == "") { sHeading = sHeading + "\\ All Shifts"; } else { sHeading = sHeading + "\\ Shift " + ViewModel.CurrShift; } if (ViewModel.CurrGroup != 0) { sHeading = sHeading + " \\ Group " + ViewModel.CurrGroup.ToString(); } } } ViewModel.sprReport.Row = 3; ViewModel.sprReport.Col = 1; ViewModel.sprReport.Text = sHeading; ViewModel.sprReport.Row = 5; ViewModel.sprReport.Col = 1; ViewModel.sprReport.Text = "Name"; ViewModel.sprReport.Col = 2; ViewModel.sprReport.Text = "Cert #"; ViewModel.sprReport.Col = 3; ViewModel.sprReport.Text = "Unit"; ViewModel.sprReport.Col = 4; ViewModel.sprReport.Text = "Grp"; ViewModel.sprReport.Col = 5; ViewModel.sprReport.Text = "Date"; ViewModel.sprReport.Col = 6; ViewModel.sprReport.Text = "Skills"; ViewModel.sprReport.Col = 7; ViewModel.sprReport.Text = "Date"; ViewModel.sprReport.Col = 8; ViewModel.sprReport.Text = "Skills"; ViewModel.sprReport.Col = 9; ViewModel.sprReport.Text = "Date"; ViewModel.sprReport.Col = 10; ViewModel.sprReport.Text = "Skills"; ViewModel.sprReport.Col = 11; ViewModel.sprReport.Text = "Date"; ViewModel.sprReport.Col = 12; ViewModel.sprReport.Text = "Skills"; ViewModel.sprReport.Col = 13; ViewModel.sprReport.Text = "Date"; ViewModel.sprReport.Col = 14; ViewModel.sprReport.Text = "Skills"; ViewModel.sprReport.Col = 15; ViewModel.sprReport.Text = "Date"; ViewModel.sprReport.Col = 16; ViewModel.sprReport.Text = "Skills"; ViewModel.sprReport.Col = 17; ViewModel.sprReport.Text = "Date"; ViewModel.sprReport.Col = 18; ViewModel.sprReport.Text = "Skills"; ViewModel.sprReport.Col = 19; ViewModel.sprReport.Text = "Date"; ViewModel.sprReport.Col = 20; ViewModel.sprReport.Text = "Skills"; ViewModel.sprReport.Col = 21; ViewModel.sprReport.Text = "Date"; ViewModel.sprReport.Col = 22; ViewModel.sprReport.Text = "Skills"; ViewModel.sprReport.Col = 23; ViewModel.sprReport.Text = "Date"; ViewModel.sprReport.Col = 24; ViewModel.sprReport.Text = "Skills"; ViewModel.sprReport.Col = 25; ViewModel.sprReport.Text = "Date"; ViewModel.sprReport.Col = 26; ViewModel.sprReport.Text = "Skills"; ViewModel.sprReport.Col = 27; ViewModel.sprReport.Text = "Date"; ViewModel.sprReport.Col = 28; ViewModel.sprReport.Text = "Skills"; if (TrainCL.GetTrainingSchedOTEPByYear(ViewModel.CurrYear) != 0) { //continue } else { ViewManager.ShowMessage("Oh No! There are no Training Scheduled OTEP Modules set up for Year!", "Training Annual OTEP Report", UpgradeHelpers.Helpers.BoxButtons.OK); return; } int iCurrRow = 3; int iCurrCol = 5; int iCodeRow = 6; string sSubHeading = ""; string sModuleName = ""; int iReportColumn = 1; while (!TrainCL.TrainingRecord.EOF) { ViewModel.sprReport.Row = iCurrRow; ViewModel.sprReport.Col = iCurrCol; //UPGRADE_WARNING: (1068) GetVal(TrainCL.TrainingRecord(sched_month)) of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx switch (Convert.ToInt32(modGlobal.GetVal(TrainCL.TrainingRecord["sched_month"]))) { case 1: sSubHeading = "January"; break; case 2: sSubHeading = "February"; break; case 3: sSubHeading = "March"; break; case 4: sSubHeading = "April"; break; case 5: sSubHeading = "May"; break; case 6: sSubHeading = "June"; break; case 7: sSubHeading = "July"; break; case 8: sSubHeading = "August"; break; case 9: sSubHeading = "September"; break; case 10: sSubHeading = "October"; break; case 11: sSubHeading = "November"; break; case 12: sSubHeading = "December"; break; default: sSubHeading = ""; break; } ViewModel.sprReport.Text = sSubHeading; ViewModel.sprReport.Row = iCurrRow + 1; sModuleName = modGlobal.Clean(TrainCL.TrainingRecord["description"]); ViewModel.sprReport.Text = sModuleName; ViewModel.sprReport.Row = iCodeRow; //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx iReportColumn = Convert.ToInt32(modGlobal.GetVal(TrainCL.TrainingRecord["report_column"])); ViewModel.sprReport.Text = iReportColumn.ToString(); iCurrCol += 2; TrainCL.TrainingRecord.MoveNext(); } ; }