private static void PopulateMunisAttributes() // How to pull this from cache? { var tmpAttribs = new DbAttributes(); using (var results = DBFactory.GetSqliteCacheDatabase().DataTableFromQueryString(Queries.Munis.SelectLocations()))//MunisDatabase.ReturnSqlTable(Queries.Munis.SelectLocations())) { foreach (DataRow row in results.Rows) { tmpAttribs.Add(row[MunisLocations.Description].ToString().Trim(), row[MunisLocations.Code].ToString().Trim(), Convert.ToInt32(row[MunisLocations.Code])); } } AttributeInstances.MunisAttributes.MunisLocations = tmpAttribs; }
private static void PopulateMunisToAssetAttributes() { var tmpAttribs = new DbAttributes(); using (var results = DBFactory.GetSqliteCacheDatabase().DataTableFromQueryString(Queries.Assets.SelectMunisAndAssetLocationCodes())) { foreach (DataRow row in results.Rows) { tmpAttribs.Add(row[DeviceCodesTable.HumanValue].ToString(), row[MunisDepartmentsTable.MunisLocation].ToString(), Convert.ToInt32(row[MunisDepartmentsTable.Id])); } } AttributeInstances.MunisAttributes.MunisToAssetLocations = tmpAttribs; }
private static void PopulateSubnetLocationAttributes() { var tmpAttribs = new DbAttributes(); using (var results = DBFactory.GetSqliteCacheDatabase().DataTableFromQueryString(Queries.Assets.SelectSubnetLocations())) { foreach (DataRow row in results.Rows) { tmpAttribs.Add(row[SubnetLocationsTable.Description].ToString(), row[SubnetLocationsTable.Subnet].ToString(), Convert.ToInt32(row[SubnetLocationsTable.Id])); } } AttributeInstances.DeviceAttributes.SubnetLocation = tmpAttribs; }
private static DbAttributes BuildIndex(string attribTable, string attribName) { //try //{ using (DataTable results = DBFactory.GetSqliteCacheDatabase().DataTableFromQueryString(Queries.Assets.SelectAttributeCodes(attribTable, attribName))) { var tmpAttrib = new DbAttributes(); foreach (DataRow r in results.Rows) { string displayValue = ""; if (r.Table.Columns.Contains("munis_code")) { if (r["munis_code"] != DBNull.Value) { displayValue = r[ComboCodesBaseCols.DisplayValue].ToString() + " - " + r["munis_code"].ToString(); } else { displayValue = r[ComboCodesBaseCols.DisplayValue].ToString(); } } else { displayValue = r[ComboCodesBaseCols.DisplayValue].ToString(); } Color attribColor = Color.Empty; if (!string.IsNullOrEmpty(r[ComboCodesBaseCols.Color].ToString())) { attribColor = ColorTranslator.FromHtml(r[ComboCodesBaseCols.Color].ToString()); } tmpAttrib.Add(displayValue, r[ComboCodesBaseCols.CodeValue].ToString(), Convert.ToInt32(r[ComboCodesBaseCols.Id]), attribColor); } return(tmpAttrib); } //} //catch (Exception ex) //{ // // ErrorHandling.ErrHandle(ex, System.Reflection.MethodBase.GetCurrentMethod()); // return null; //} }