private void LoadLists()
{
//Load Lists
DbCommand oCmd = UpgradeHelpers.DB.AdoFactoryManager.GetFactory().CreateCommand();
string strName = "";
PTSProject.clsTraining TrainCL = Container.Resolve <clsTraining>();
PTSProject.clsUnit UnitCL = Container.Resolve <clsUnit>();
ViewModel.cboUnitList.Items.Clear();
UnitCL.TFDUnitListRS();
// cboUnitList.ADDItem "OPER"
while (!UnitCL.Unit.EOF)
{
ViewModel.cboUnitList.AddItem(modGlobal.Clean(UnitCL.Unit["unit_code"]));
UnitCL.Unit.MoveNext();
}
;
ViewModel.cboAllStaff.Items.Clear();
oCmd.Connection = modGlobal.oConn;
oCmd.CommandType = CommandType.Text;
if (modGlobal.Shared.gSecurity != "ADM")
{
oCmd.CommandText = "spOpNameListForField";
}
else
{
// oCmd.CommandText = "spOpNameList"
oCmd.CommandText = "spFullNameList";
}
ADORecordSetHelper oRec = ADORecordSetHelper.Open(oCmd, "");
while (!oRec.EOF)
{
strName = Convert.ToString(oRec["name_full"]).Trim() + " :" + Convert.ToString(oRec["employee_id"]);
this.ViewModel.cboAllStaff.AddItem(strName);
oRec.MoveNext();
}
;
ViewModel.cboPrimary.Clear();
TrainCL.GetPrimaryCodesForField();
while (!TrainCL.TrainingPrimaryCode.EOF)
{
ViewModel.cboPrimary.AddItem(modGlobal.Clean(TrainCL.TrainingPrimaryCode["description"]));
//UPGRADE_ISSUE: (2064) LpADOLib.fpComboAdo property cboPrimary.NewIndex was not upgraded. More Information: http://www.vbtonet.com/ewis/ewi2064.aspx
//UPGRADE_ISSUE: (2064) LpADOLib.fpComboAdo property cboPrimary.ItemData was not upgraded. More Information: http://www.vbtonet.com/ewis/ewi2064.aspx
ViewModel.cboPrimary.setItemData(Convert.ToInt32(TrainCL.TrainingPrimaryCode["trn_primary_code"]), ViewModel.cboPrimary.getNewIndex());
TrainCL.TrainingPrimaryCode.MoveNext();
}
;
}