private void LoadCalculatedAssets() { try { m_listAssets = GlobalDatabaseOperations.GetAssets(); } catch (Exception ex) { Global.WriteOutput("Error: Retrieving RoadCare Assets from ASSET table." + ex.Message); return; } try { m_listCalculatedAssets = GlobalDatabaseOperations.GetCalculatedAssets(); } catch (Exception ex) { Global.WriteOutput("Error: Retrieving RoadCare Calculated Assets from CALCULATED_ASSETS table. " + ex.Message); return; } DataGridViewComboBoxCell dgvComboAsset; foreach (CalculatedAssetObject asset in m_listCalculatedAssets) { int nIndex = dataGridViewCalculatedAssets.Rows.Add(asset.Asset, asset.CalculatedProperty, asset.Type, asset.Equation.Replace("|", "'"), asset.Criteria.Replace("|", "'")); dataGridViewCalculatedAssets.Rows[nIndex].Tag = asset.PrimaryKey; dgvComboAsset = (DataGridViewComboBoxCell)dataGridViewCalculatedAssets[0, nIndex]; foreach (AssetObject assetTable in m_listAssets) { dgvComboAsset.Items.Add(assetTable.Asset); } } dgvComboAsset = (DataGridViewComboBoxCell)dataGridViewCalculatedAssets[0, dataGridViewCalculatedAssets.Rows.Count - 1]; foreach (AssetObject assetTable in m_listAssets) { dgvComboAsset.Items.Add(assetTable.Asset); } }
private void FormAssetToAttribute_Load(object sender, EventArgs e) { List <AttributeObject> listAssetAttributes = GlobalDatabaseOperations.GetAssetToAttributes(); try { m_listAsset = GlobalDatabaseOperations.GetAssets(); } catch (Exception ex) { Global.WriteOutput("Error: Retrieving RoadCare Assets from ASSET table." + ex.Message); return; } String strAsset = ""; foreach (AttributeObject attributeObject in listAssetAttributes) { if (attributeObject.Type == "NUMBER") { int nIndexTag = dataGridViewAssetToAttribute.Rows.Add(attributeObject.Asset, attributeObject.AssetProperty, attributeObject.Attribute, attributeObject.Format, attributeObject.DefaultNumber, attributeObject.Minimum, attributeObject.Maximum); dataGridViewAssetToAttribute.Rows[nIndexTag].Tag = attributeObject.Type; } else { int nIndexTag = dataGridViewAssetToAttribute.Rows.Add(attributeObject.Asset, attributeObject.AssetProperty, attributeObject.Attribute, "", attributeObject.DefaultString, "", ""); dataGridViewAssetToAttribute.Rows[nIndexTag].Tag = attributeObject.Type; } } int nIndex = 0; DataGridViewComboBoxCell dgvComboAsset; foreach (DataGridViewRow row in dataGridViewAssetToAttribute.Rows) { dgvComboAsset = (DataGridViewComboBoxCell)dataGridViewAssetToAttribute[0, nIndex]; dataGridViewAssetToAttribute[2, nIndex].ReadOnly = true; foreach (AssetObject assetTable in m_listAsset) { dgvComboAsset.Items.Add(assetTable.Asset); } nIndex++; } DataGridViewComboBoxCell dgvComboProperty; List <String> listProperty; nIndex = 0; foreach (DataGridViewRow row in dataGridViewAssetToAttribute.Rows) { if (dataGridViewAssetToAttribute[0, nIndex].Value != null) { dgvComboProperty = (DataGridViewComboBoxCell)dataGridViewAssetToAttribute[1, nIndex]; strAsset = dataGridViewAssetToAttribute[0, nIndex].Value.ToString(); listProperty = DBMgr.GetTableColumns(strAsset); foreach (String strProperty in listProperty) { dgvComboProperty.Items.Add(strProperty); } } nIndex++; } }