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