//************************************************************* // TFD Training Paramedic Recertification // Paramedics Filtered by DateRane, Battalion/Shift //************************************************************* private void FormatReport() { PTSProject.clsTraining TrainCL = Container.Resolve< clsTraining>(); bool bDisplay = false; if ( ViewModel.FirstTime) { return; } ViewModel.sprReport2.Row = 6; ViewModel.sprReport2.Row2 = ViewModel.sprReport2.MaxRows; ViewModel.sprReport2.Col = 1; ViewModel.sprReport2.Col2 = ViewModel.sprReport2.MaxCols; ViewModel.sprReport2.BlockMode = true; ViewModel.sprReport2.Text = ""; ViewModel.sprReport2.BlockMode = false; if (TrainCL.GetTrainingPMRecertificationReport(ViewModel.dtStart.Text, ViewModel.dtEnd.Text, ViewModel.CurrBatt, ViewModel.CurrShift, ViewModel.CurrGroup) != 0) { //continue } else { ViewManager.ShowMessage("There are no Employee/Training Records to report!", "Training Paramedic Recertification", UpgradeHelpers.Helpers.BoxButtons.OK); return; } string sEmployeeName = ""; int iCodeRow = 5; int iCurrRow = 6; int iCurrCol = 1; while(!TrainCL.TrainingRecord.EOF) { ViewModel.sprReport2.Row = iCurrRow; ViewModel.sprReport2.Col = iCurrCol; bDisplay = false; if (sEmployeeName == "") { //first time sEmployeeName = modGlobal.Clean(TrainCL.TrainingRecord["name_full"]); ViewModel.sprReport2.Text = sEmployeeName; ViewModel.sprReport2.Col = iCurrCol + 1; if (modGlobal.Clean(TrainCL.TrainingRecord["shift_code"]) == "") { ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["unit_code"]); } else if (modGlobal.Clean(TrainCL.TrainingRecord["shift_code"]) == "*") { ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["unit_code"]); } else { ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["unit_code"]) + " " + modGlobal.Clean(TrainCL.TrainingRecord["shift_code"]); } ViewModel.sprReport2.Col = iCurrCol + 2; ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["group_number"]); ViewModel.sprReport2.Col = iCurrCol + 3; if (modGlobal.Clean(TrainCL.TrainingRecord["recert_date"]) == "") { ViewModel.sprReport2.Text = ""; } else { ViewModel.sprReport2.Text = Convert.ToDateTime(TrainCL.TrainingRecord["recert_date"]).ToString("M/d/yyyy"); } if (modGlobal.Clean(TrainCL.TrainingRecord["report_column"]) != "") { ViewModel.sprReport2.Row = iCodeRow; int tempForVar = ViewModel.sprReport2.MaxCols; for (int i = 5; i <= tempForVar; i++) { ViewModel.sprReport2.Col = i; if (modGlobal.Clean(TrainCL.TrainingRecord["report_column"]) == modGlobal.Clean(ViewModel.sprReport2.Text)) { ViewModel.sprReport2.Col = i + 1; //UPGRADE_WARNING: (1068) GetVal(sprReport2.Text) of type Variant is being forced to double. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx if (Convert.ToDouble(modGlobal.GetVal(ViewModel.sprReport2.Text)) == 3) { bDisplay = true; } ViewModel.sprReport2.Col = i; ViewModel.sprReport2.Row = iCurrRow; if (modGlobal.Clean(TrainCL.TrainingRecord["LatestDate"]) != "") { ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["LatestDate"]); ViewModel.sprReport2.Col = i + 1; ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["TotalHours"]); // If bDisplay Then // sprReport2.Col = i + 2 // sprReport2.Text = Clean(TrainCL.TrainingRecord("FlagComment"]) // End If } break; } } } } else if (sEmployeeName == modGlobal.Clean(TrainCL.TrainingRecord["name_full"])) { if (modGlobal.Clean(TrainCL.TrainingRecord["report_column"]) != "") { ViewModel.sprReport2.Row = iCodeRow; int tempForVar2 = ViewModel.sprReport2.MaxCols; for (int i = 5; i <= tempForVar2; i++) { ViewModel.sprReport2.Col = i; if (modGlobal.Clean(TrainCL.TrainingRecord["report_column"]) == modGlobal.Clean(ViewModel.sprReport2.Text)) { ViewModel.sprReport2.Col = i + 1; //UPGRADE_WARNING: (1068) GetVal(sprReport2.Text) of type Variant is being forced to double. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx if (Convert.ToDouble(modGlobal.GetVal(ViewModel.sprReport2.Text)) == 3) { bDisplay = true; } ViewModel.sprReport2.Col = i; ViewModel.sprReport2.Row = iCurrRow; if (modGlobal.Clean(TrainCL.TrainingRecord["LatestDate"]) != "") { ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["LatestDate"]); ViewModel.sprReport2.Col = i + 1; ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["TotalHours"]); // If bDisplay Then // sprReport2.Col = i + 2 // sprReport2.Text = Clean(TrainCL.TrainingRecord("FlagComment"]) // End If } break; } } } } else { iCurrRow++; ViewModel.sprReport2.Row = iCurrRow; sEmployeeName = modGlobal.Clean(TrainCL.TrainingRecord["name_full"]); ViewModel.sprReport2.Text = sEmployeeName; ViewModel.sprReport2.Col = iCurrCol + 1; if (modGlobal.Clean(TrainCL.TrainingRecord["shift_code"]) == "") { ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["unit_code"]); } else if (modGlobal.Clean(TrainCL.TrainingRecord["shift_code"]) == "*") { ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["unit_code"]); } else { ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["unit_code"]) + " " + modGlobal.Clean(TrainCL.TrainingRecord["shift_code"]); } ViewModel.sprReport2.Col = iCurrCol + 2; if (modGlobal.Clean(TrainCL.TrainingRecord["group_number"]) == "0") { ViewModel.sprReport2.Text = ""; } else { ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["group_number"]); } ViewModel.sprReport2.Col = iCurrCol + 3; if (modGlobal.Clean(TrainCL.TrainingRecord["recert_date"]) == "") { ViewModel.sprReport2.Text = ""; } else { ViewModel.sprReport2.Text = Convert.ToDateTime(TrainCL.TrainingRecord["recert_date"]).ToString("M/d/yyyy"); } if (modGlobal.Clean(TrainCL.TrainingRecord["report_column"]) != "") { ViewModel.sprReport2.Row = iCodeRow; int tempForVar3 = ViewModel.sprReport2.MaxCols; for (int i = 5; i <= tempForVar3; i++) { ViewModel.sprReport2.Col = i; if (modGlobal.Clean(TrainCL.TrainingRecord["report_column"]) == modGlobal.Clean(ViewModel.sprReport2.Text)) { ViewModel.sprReport2.Col = i + 1; //UPGRADE_WARNING: (1068) GetVal(sprReport2.Text) of type Variant is being forced to double. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx if (Convert.ToDouble(modGlobal.GetVal(ViewModel.sprReport2.Text)) == 3) { bDisplay = true; } ViewModel.sprReport2.Col = i; ViewModel.sprReport2.Row = iCurrRow; if (modGlobal.Clean(TrainCL.TrainingRecord["LatestDate"]) != "") { ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["LatestDate"]); ViewModel.sprReport2.Col = i + 1; ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["TotalHours"]); if (bDisplay) { ViewModel.sprReport2.Col = i + 2; ViewModel.sprReport2.Text = modGlobal.Clean(TrainCL.TrainingRecord["FlagComment"]); } } break; } } } } TrainCL.TrainingRecord.MoveNext(); } ; }