private string HandleAssetDetailsData(string assetFilter)
{
string assetValue;
string assetCriteria;
DataTable resultsDataTable = new DataTable();
AssetDAO lAssetDAO = new AssetDAO();
AssetTypesDAO lAssetTypesDAO = new AssetTypesDAO();
LocationsDAO lLocationsDAO = new LocationsDAO();
string newIds = String.Empty;
string complianceCriteria = String.Empty;
//foreach (string assetFilter in applicationFilters)
//{
assetCriteria = assetFilter.Substring(41, assetFilter.IndexOf("and _value") - 43);
switch (assetCriteria)
{
case "Asset Name":
complianceCriteria = "_name";
break;
case "Location":
complianceCriteria = "_locationid";
break;
case "Date of last Audit":
complianceCriteria = "_lastaudit";
break;
case "IP Address":
complianceCriteria = "_ipaddress";
break;
case "MAC Address":
complianceCriteria = "_macaddress";
break;
case "Make":
complianceCriteria = "_make";
break;
case "Model":
complianceCriteria = "_model";
break;
case "Serial Number":
complianceCriteria = "_serial_number";
break;
case "Category":
complianceCriteria = "_category";
break;
case "Type":
complianceCriteria = "_type";
break;
case "Asset Tag":
complianceCriteria = "_assettag";
break;
}
if (complianceCriteria == "_category")
{
assetValue = assetFilter.Substring(assetFilter.LastIndexOf("=") + 2);
resultsDataTable = lAssetTypesDAO.GetCompliantAssetCategoriesValue(assetValue);
}
else if (complianceCriteria == "_type")
{
assetValue = assetFilter.Substring(assetFilter.LastIndexOf("=") + 2);
resultsDataTable = lAssetTypesDAO.GetCompliantAssetTypesValue(assetValue);
}
else if (complianceCriteria == "_locationid")
{
assetValue = assetFilter.Substring(assetFilter.LastIndexOf("=") + 2);
resultsDataTable = lLocationsDAO.GetCompliantLocationValues(assetValue);
}
else if (complianceCriteria == "_lastaudit")
{
if (assetFilter.IndexOf("and _value") != -1)
{
resultsDataTable =
lAssetDAO.GetCompliantAssetValueForLastAudit(assetFilter.Substring(assetFilter.IndexOf("and _value") + 11));
}
}
else
{
assetValue = assetFilter.Substring(assetFilter.LastIndexOf("=") + 2);
//resultsDataTable = lAssetDAO.GetCompliantAssetValue(complianceCriteria, assetValue, compliantIds);
resultsDataTable = lAssetDAO.GetCompliantAssetValue(complianceCriteria, assetValue);
}
foreach (DataRow compliantRow in resultsDataTable.Rows)
{
if (!newIds.Contains(compliantRow.ItemArray[0].ToString()))
{
newIds += compliantRow.ItemArray[0].ToString() + ",";
}
}
newIds = newIds.TrimEnd(',');
return(newIds);
}
private void PopulatePickerList(List <string> itemParts)
{
string category;
string name;
string value;
if (itemParts.Count == 3)
{
category = itemParts[0] + "|" + itemParts[1];
name = itemParts[2];
}
else if (itemParts.Count == 4)
{
category = itemParts[0] + "|" + itemParts[1] + "|" + itemParts[2];
name = itemParts[3];
}
else if (itemParts.Count == 5)
{
category = itemParts[0] + "|" + itemParts[1] + "|" + itemParts[2] + "|" + itemParts[3];
name = itemParts[4];
}
else
{
category = itemParts[0];
name = itemParts[1];
}
cbValuePicker.Items.Clear();
cbValuePicker.Text = String.Empty;
cbValuePicker.Refresh();
DataTable pickerValuesDataTable = new DataTable();
if (category.StartsWith("UserData|"))
{
pickerValuesDataTable = new UserDataDefinitionsDAO().GetUserDataPickerValues(name, category.Split('|')[1]);
}
else if (category.StartsWith("Asset Details"))
{
string columnName = String.Empty;
switch (name)
{
case "Asset Name":
columnName = "_name";
break;
case "Location":
columnName = "_locationid";
break;
case "Date of last Audit":
columnName = "_lastaudit";
break;
case "IP Address":
columnName = "_ipaddress";
break;
case "MAC Address":
columnName = "_macaddress";
break;
case "Make":
columnName = "_make";
break;
case "Model":
columnName = "_model";
break;
case "Serial Number":
columnName = "_serial_number";
break;
case "Category":
columnName = "_category";
break;
case "Type":
columnName = "_type";
break;
case "Asset Tag":
columnName = "_assettag";
break;
}
if (columnName == "_category")
{
pickerValuesDataTable = new AssetTypesDAO().GetAssetCategoriesPickerValues();
}
else if (columnName == "_lastaudit")
{
pickerValuesDataTable = new AssetDAO().GetAssetPickerValuesForLastAudit();
}
else if (columnName == "_locationid")
{
pickerValuesDataTable = new LocationsDAO().GetLocationPickerValues();
}
else if (columnName == "_type")
{
pickerValuesDataTable = new AssetTypesDAO().GetAssetTypesPickerValues();
}
else
{
pickerValuesDataTable = new AssetDAO().GetAssetPickerValues(columnName);
}
}
else if (category.StartsWith("Operating Systems"))
{
switch (name)
{
case "Family":
pickerValuesDataTable = new ApplicationsDAO().GetOSPickerValues("_name");
break;
case "Version":
pickerValuesDataTable = new ApplicationsDAO().GetOSPickerValues("_version");
break;
case "CD Key":
pickerValuesDataTable = new ApplicationInstanceDAO().GetOSPickerValues("_cdkey");
break;
case "Serial Number":
pickerValuesDataTable = new ApplicationInstanceDAO().GetOSPickerValues("_productid");
break;
}
}
else
{
pickerValuesDataTable = lAuditedItemsDAO.GetPickerValue(category, name);
lblUnits.Text = lAuditedItemsDAO.GetDisplayUnitValue(category, name);
}
foreach (DataRow pickerValueRow in pickerValuesDataTable.Rows)
{
value = pickerValueRow.ItemArray[0].ToString();
if (value != String.Empty)
{
cbValuePicker.Items.Add(value);
}
}
if (cbValuePicker.Items.Count > 0)
{
cbValuePicker.SelectedIndex = 0;
}
}
