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