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