public void RefreshEmployeeGrid() { PTSProject.clsTraining clEmployee = Container.Resolve <clsTraining>(); int iGroup = 0; int iYear = 0; //Clear Employee Grid ViewModel.sprEmployeeList.MaxRows = 500; ViewModel.sprEmployeeList.Row = 1; ViewModel.sprEmployeeList.Row2 = ViewModel.sprEmployeeList.MaxRows; ViewModel.sprEmployeeList.Col = 1; ViewModel.sprEmployeeList.Col2 = ViewModel.sprEmployeeList.MaxCols; ViewModel.sprEmployeeList.BlockMode = true; ViewModel.sprEmployeeList.Text = ""; ViewModel.sprEmployeeList.BackColor = modGlobal.Shared.WHITE; ViewModel.sprEmployeeList.BlockMode = false; //UPGRADE_ISSUE: (2064) FPSpreadADO.fpSpread method sprEmployeeList.ClearSelection was not upgraded. More Information: http://www.vbtonet.com/ewis/ewi2064.aspx ViewModel.sprEmployeeList.ClearSelection(); // 'Fill Employee Grid if (ViewModel.cboYear.SelectedIndex == -1) { iYear = 0; } else { //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx iYear = Convert.ToInt32(modGlobal.GetVal(ViewModel.cboYear.Text)); } if (ViewModel.optFGrp[0].Checked) { iGroup = 0; } else if (ViewModel.optFGrp[1].Checked) { iGroup = 1; } else if (ViewModel.optFGrp[2].Checked) { iGroup = 2; } else if (ViewModel.optFGrp[3].Checked) { iGroup = 3; } else { iGroup = 0; } if (clEmployee.GetParamedicList(iGroup, iYear) != 0) { } else { ViewManager.ShowMessage("Oooops! There were no Paramedics retrieved.", "No Paramedics ??", UpgradeHelpers.Helpers.BoxButtons.OK); return; } int GridRow = 0; while (!clEmployee.Employee.EOF) { GridRow++; ViewModel.sprEmployeeList.MaxRows = GridRow; ViewModel.sprEmployeeList.Row = GridRow; ViewModel.sprEmployeeList.Col = 1; ViewModel.sprEmployeeList.Lock = true; ViewModel.sprEmployeeList.TypeHAlign = FarPoint.ViewModels.CellHorizontalAlignment.Center; ViewModel.sprEmployeeList.Text = modGlobal.Clean(clEmployee.Employee["sap_id"]); ViewModel.sprEmployeeList.Col = 2; ViewModel.sprEmployeeList.Lock = true; ViewModel.sprEmployeeList.Text = modGlobal.Clean(clEmployee.Employee["name_full"]); ViewModel.sprEmployeeList.Col = 3; ViewModel.sprEmployeeList.Lock = true; ViewModel.sprEmployeeList.TypeHAlign = FarPoint.ViewModels.CellHorizontalAlignment.Center; //UPGRADE_WARNING: (1068) GetVal(clEmployee.Employee(group_number)) of type Variant is being forced to double. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx if (modGlobal.Clean(clEmployee.Employee["group_number"]) == "") { ViewModel.sprEmployeeList.Text = ""; } else if (Convert.ToDouble(modGlobal.GetVal(clEmployee.Employee["group_number"])) == 0) { ViewModel.sprEmployeeList.Text = ""; } else { //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to string. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx ViewModel.sprEmployeeList.Text = Convert.ToString(modGlobal.GetVal(clEmployee.Employee["group_number"])); } ViewModel.sprEmployeeList.Col = 4; ViewModel.sprEmployeeList.Lock = true; ViewModel.sprEmployeeList.TypeHAlign = FarPoint.ViewModels.CellHorizontalAlignment.Center; ViewModel.sprEmployeeList.Text = modGlobal.Clean(clEmployee.Employee["unit_code"]); ViewModel.sprEmployeeList.Col = 5; ViewModel.sprEmployeeList.Lock = true; ViewModel.sprEmployeeList.TypeHAlign = FarPoint.ViewModels.CellHorizontalAlignment.Center; ViewModel.sprEmployeeList.Text = modGlobal.Clean(clEmployee.Employee["shift_code"]); ViewModel.sprEmployeeList.Col = 6; ViewModel.sprEmployeeList.Lock = true; ViewModel.sprEmployeeList.TypeHAlign = FarPoint.ViewModels.CellHorizontalAlignment.Center; ViewModel.sprEmployeeList.Text = modGlobal.Clean(clEmployee.Employee["position_code"]); ViewModel.sprEmployeeList.Col = 7; ViewModel.sprEmployeeList.Lock = true; ViewModel.sprEmployeeList.TypeHAlign = FarPoint.ViewModels.CellHorizontalAlignment.Center; if (modGlobal.Clean(clEmployee.Employee["recert_date"]) == "") { ViewModel.sprEmployeeList.Text = ""; } else { ViewModel.sprEmployeeList.Text = Convert.ToDateTime(clEmployee.Employee["recert_date"]).ToString("M/d/yyyy"); } ViewModel.sprEmployeeList.Col = 8; //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to string. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx ViewModel.sprEmployeeList.Text = Convert.ToString(modGlobal.GetVal(clEmployee.Employee["per_sys_id"])); clEmployee.Employee.MoveNext(); } ; if (GridRow > 0) { ViewModel.sprEmployeeList.MaxRows = GridRow; } else { ViewModel.sprEmployeeList.MaxRows = 1; } ViewModel.lbCount.Text = "List Count: " + GridRow.ToString(); ViewModel.sprEmployeeList.Protect = true; ViewModel.CurrPersID = 0; ViewModel.SelectedEmpRow = 0; ViewModel.RecordExists = false; }