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