public void FillGridLists()
{
//Retrieve & fill Grid lists
DbCommand oCmd = UpgradeHelpers.DB.AdoFactoryManager.GetFactory().CreateCommand();
int i = 0;
oCmd.Connection = modGlobal.oConn;
oCmd.CommandType = CommandType.Text;
string strSQL = "spSelect_UniformRepairerList ";
oCmd.CommandText = strSQL;
ADORecordSetHelper oRec = ADORecordSetHelper.Open(oCmd, "");
//fill Repairer for all Uniform Repairers
int tempForVar = ViewModel.sprPPEList.MaxRows;
for (int x = 1; x <= tempForVar; x++)
{
ViewModel.sprPPEList.Row = x;
ViewModel.sprPPEList.Col = 2;
i = 0;
while (!oRec.EOF)
{
ViewModel.sprPPEList.TypeComboBoxIndex = i;
ViewModel.sprPPEList.TypeComboBoxString = modGlobal.Clean(oRec["repairer_name"]);
i++;
oRec.MoveNext();
}
;
oRec.MoveFirst();
}
//fill Repairer for all Uniform Types
strSQL = "sp_GetEmployeeCurrentItemList '" + modGlobal.Shared.gAssignID + "' ";
oCmd.CommandText = strSQL;
oRec = ADORecordSetHelper.Open(oCmd, "");
int tempForVar2 = ViewModel.sprPPEList.MaxRows;
for (int x = 1; x <= tempForVar2; x++)
{
ViewModel.sprPPEList.Row = x;
ViewModel.sprPPEList.Col = 1;
i = 0;
while (!oRec.EOF)
{
ViewModel.sprPPEList.TypeComboBoxIndex = i;
ViewModel.sprPPEList.TypeComboBoxString = modGlobal.Clean(oRec["UniformType"]) + ": " + modGlobal.Clean(oRec["tracking_number"]);
i++;
oRec.MoveNext();
}
;
oRec.MoveFirst();
}
}