//************************************************************* // Training Annual OTEP Reporting // Filtered by Year, Battalion/Shift //************************************************************* public void FormatReport() { PTSProject.clsTraining TrainCL = Container.Resolve <clsTraining>(); if (ViewModel.FirstTime) { return; } ViewModel.sprReport.Row = 7; ViewModel.sprReport.Row2 = ViewModel.sprReport.MaxRows; ViewModel.sprReport.Col = 1; ViewModel.sprReport.Col2 = ViewModel.sprReport.MaxCols; ViewModel.sprReport.BlockMode = true; ViewModel.sprReport.Text = ""; ViewModel.sprReport.BlockMode = false; int iGroup = ViewModel.CurrGroup; if (ViewModel.optPM.Checked) { if (TrainCL.GetPMTrainingAnnualOTEPReport(ViewModel.CurrYear, ViewModel.CurrBatt, ViewModel.CurrShift, iGroup) != 0) { //continue } else { ViewManager.ShowMessage("There are no Paramedic/Training Records to report for Year!", "Training Annual OTEPReport", UpgradeHelpers.Helpers.BoxButtons.OK); return; } } else { if (TrainCL.GetTrainingAnnualOTEPReport(ViewModel.CurrYear, ViewModel.CurrBatt, ViewModel.CurrShift, iGroup) != 0) { //continue } else { ViewManager.ShowMessage("There are no Employee/Training Records to report for Year!", "Training Annual OTEPReport", UpgradeHelpers.Helpers.BoxButtons.OK); return; } } string sEmployeeName = ""; int iCodeRow = 6; int iCurrRow = 7; int iCurrCol = 1; while (!TrainCL.TrainingRecord.EOF) { ViewModel.sprReport.Row = iCurrRow; ViewModel.sprReport.Col = iCurrCol; if (sEmployeeName == "") { //first time sEmployeeName = modGlobal.Clean(TrainCL.TrainingRecord["name_full"]); ViewModel.sprReport.Text = sEmployeeName; ViewModel.sprReport.Col = iCurrCol + 1; ViewModel.sprReport.Text = modGlobal.Clean(TrainCL.TrainingRecord["state_number"]); ViewModel.sprReport.Col = iCurrCol + 2; ViewModel.sprReport.Text = modGlobal.Clean(TrainCL.TrainingRecord["unit_code"]) + "-" + modGlobal.Clean(TrainCL.TrainingRecord["shift_code"]); ViewModel.sprReport.Col = iCurrCol + 3; //UPGRADE_WARNING: (1068) GetVal(TrainCL.TrainingRecord(group_number)) of type Variant is being forced to double. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx if (modGlobal.Clean(TrainCL.TrainingRecord["group_number"]) == "") { ViewModel.sprReport.Text = ""; } else if (Convert.ToDouble(modGlobal.GetVal(TrainCL.TrainingRecord["group_number"])) > 0) { //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to string. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx ViewModel.sprReport.Text = Convert.ToString(modGlobal.GetVal(TrainCL.TrainingRecord["group_number"])); } else { ViewModel.sprReport.Text = ""; } if (modGlobal.Clean(TrainCL.TrainingRecord["report_column"]) != "") { ViewModel.sprReport.Row = iCodeRow; int tempForVar = ViewModel.sprReport.MaxCols; for (int i = 5; i <= tempForVar; i++) { ViewModel.sprReport.Col = i; if (modGlobal.Clean(TrainCL.TrainingRecord["report_column"]) == modGlobal.Clean(ViewModel.sprReport.Text)) { ViewModel.sprReport.Col = i; ViewModel.sprReport.Row = iCurrRow; if (modGlobal.Clean(TrainCL.TrainingRecord["training_date"]) != "") { if (modGlobal.Clean(TrainCL.TrainingRecord["pass_fail"]) == "F") { } else { } ViewModel.sprReport.Text = Convert.ToDateTime(TrainCL.TrainingRecord["training_date"]).ToString("MM/dd"); ViewModel.sprReport.Col = i + 1; if (modGlobal.Clean(TrainCL.TrainingRecord["pass_fail"]) == "F") { } else { } ViewModel.sprReport.Text = modGlobal.Clean(TrainCL.TrainingRecord["comments"]); } break; } } } } else if (sEmployeeName == modGlobal.Clean(TrainCL.TrainingRecord["name_full"])) { if (modGlobal.Clean(TrainCL.TrainingRecord["report_column"]) != "") { ViewModel.sprReport.Row = iCodeRow; int tempForVar2 = ViewModel.sprReport.MaxCols; for (int i = 5; i <= tempForVar2; i++) { ViewModel.sprReport.Col = i; if (modGlobal.Clean(TrainCL.TrainingRecord["report_column"]) == modGlobal.Clean(ViewModel.sprReport.Text)) { ViewModel.sprReport.Col = i; ViewModel.sprReport.Row = iCurrRow; if (modGlobal.Clean(TrainCL.TrainingRecord["training_date"]) != "") { if (modGlobal.Clean(TrainCL.TrainingRecord["pass_fail"]) == "F") { } else { } ViewModel.sprReport.Text = Convert.ToDateTime(TrainCL.TrainingRecord["training_date"]).ToString("MM/dd"); ViewModel.sprReport.Col = i + 1; if (modGlobal.Clean(TrainCL.TrainingRecord["pass_fail"]) == "F") { } else { } ViewModel.sprReport.Text = modGlobal.Clean(TrainCL.TrainingRecord["comments"]); } break; } } } } else { iCurrRow++; ViewModel.sprReport.Row = iCurrRow; sEmployeeName = modGlobal.Clean(TrainCL.TrainingRecord["name_full"]); ViewModel.sprReport.Text = sEmployeeName; ViewModel.sprReport.Col = iCurrCol + 1; ViewModel.sprReport.Text = modGlobal.Clean(TrainCL.TrainingRecord["state_number"]); ViewModel.sprReport.Col = iCurrCol + 2; ViewModel.sprReport.Text = modGlobal.Clean(TrainCL.TrainingRecord["unit_code"]) + "-" + modGlobal.Clean(TrainCL.TrainingRecord["shift_code"]); ViewModel.sprReport.Col = iCurrCol + 3; //UPGRADE_WARNING: (1068) GetVal(TrainCL.TrainingRecord(group_number)) of type Variant is being forced to double. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx if (modGlobal.Clean(TrainCL.TrainingRecord["group_number"]) == "") { ViewModel.sprReport.Text = ""; } else if (Convert.ToDouble(modGlobal.GetVal(TrainCL.TrainingRecord["group_number"])) > 0) { //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to string. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx ViewModel.sprReport.Text = Convert.ToString(modGlobal.GetVal(TrainCL.TrainingRecord["group_number"])); } else { ViewModel.sprReport.Text = ""; } if (modGlobal.Clean(TrainCL.TrainingRecord["report_column"]) != "") { ViewModel.sprReport.Row = iCodeRow; int tempForVar3 = ViewModel.sprReport.MaxCols; for (int i = 5; i <= tempForVar3; i++) { ViewModel.sprReport.Col = i; if (modGlobal.Clean(TrainCL.TrainingRecord["report_column"]) == modGlobal.Clean(ViewModel.sprReport.Text)) { ViewModel.sprReport.Col = i; ViewModel.sprReport.Row = iCurrRow; if (modGlobal.Clean(TrainCL.TrainingRecord["training_date"]) != "") { if (modGlobal.Clean(TrainCL.TrainingRecord["pass_fail"]) == "F") { } else { } ViewModel.sprReport.Text = Convert.ToDateTime(TrainCL.TrainingRecord["training_date"]).ToString("MM/dd"); if (modGlobal.Clean(TrainCL.TrainingRecord["pass_fail"]) == "F") { } else { } ViewModel.sprReport.Col = i + 1; ViewModel.sprReport.Text = modGlobal.Clean(TrainCL.TrainingRecord["comments"]); } break; } } } } TrainCL.TrainingRecord.MoveNext(); } ; }