public void addExtraGeoGisBoreholeTypes() { List <BoreholeType> extraBoreholeTypes = geoGisDatabase.getBoreholeTypes(); for (int i = 0; i < extraBoreholeTypes.Count; i++) { BoreholeType currentExtraBoreholeType = extraBoreholeTypes[i]; bool extraBoreholeTypeFound = false; for (int j = 0; j < boreholeTypes.Count; j++) { BoreholeType currentBoreholeType = boreholeTypes[j]; if (currentBoreholeType.Code.Equals(currentExtraBoreholeType.Code)) { extraBoreholeTypeFound = true; break; } } if (!extraBoreholeTypeFound) { //Console.WriteLine("Adding: " + currentExtraBoreholeType.ToString()); boreholeTypes.Add(currentExtraBoreholeType); } } }
public List <BoreholeType> getBoreholeTypes() { List <BoreholeType> boreholeTypes = null; String sql = "SELECT Purpose, Description FROM PointPurposes WHERE Setup = 'DK'"; Debug.Log("GeoGis Borings Typer SQL: " + sql); String errMessage = null; DataSet dataset = client.GetDS(this.GEOGIS_DBNAME, this.GEOGIS_USERNAME, this.GEOGIS_PASSWORD, sql, ref errMessage); bool allGood = false; if (errMessage == null) { allGood = true; } else if (errMessage != null) { if (errMessage == "") { allGood = true; } else { Debug.Log("ErrMessage: " + errMessage); } } if (allGood) { boreholeTypes = new List <BoreholeType>(); foreach (DataTable table in dataset.Tables) { String[] columnNames = new String[table.Columns.Count]; for (int i = 0; i < table.Columns.Count; i++) { columnNames[i] = table.Columns[i].ColumnName; //Debug.Log(table.Columns[i].ColumnName); } foreach (System.Data.DataRow row in table.Rows) { object[] itemArray = row.ItemArray; BoreholeType boreholeType = new BoreholeType(); for (int i = 0; i < itemArray.Length; i++) { if (!(itemArray[i] is DBNull)) { switch (columnNames[i]) { case "Purpose": boreholeType.Code = Convert.ToString(itemArray[i]); break; case "Description": boreholeType.Description = Convert.ToString(itemArray[i]); break; default: Debug.Log("Unidentified Column!"); break; } } } boreholeTypes.Add(boreholeType); } } } return(boreholeTypes); }
public List <BoreholeType> getBoreholeTypes() { List <BoreholeType> boreholeTypes = new List <BoreholeType>(); SelectResult selectResult = null; try { String sql = "SELECT CODE, SHORTTEXT, LONGTEXT FROM CODE WHERE CODETYPE = 17"; Debug.Log("Jupiter Borings Typer SQL: " + sql); selectResult = jupiterClient.select(sql); } catch (System.ServiceModel.CommunicationException e) { Debug.Log("Too many results"); } if (selectResult != null) { if (selectResult.DataSetResult != null) { foreach (DataTable table in selectResult.DataSetResult.Tables) { String[] columnNames = new String[table.Columns.Count]; for (int i = 0; i < table.Columns.Count; i++) { columnNames[i] = table.Columns[i].ColumnName; } foreach (System.Data.DataRow row in table.Rows) { object[] itemArray = row.ItemArray; BoreholeType boreholeType = new BoreholeType(); for (int i = 0; i < itemArray.Length; i++) { switch (columnNames[i]) { case "CODE": boreholeType.Code = Convert.ToString(itemArray[i]); break; case "SHORTTEXT": boreholeType.ShortDescription = Convert.ToString(itemArray[i]); break; case "LONGTEXT": boreholeType.Description = Convert.ToString(itemArray[i]); break; default: Debug.Log("Unidentified Column!"); break; } } boreholeTypes.Add(boreholeType); } } } else { Debug.Log("SelectResult's DataSetResult is null"); } if (selectResult.Error != null) { string error = selectResult.Error; Debug.Log("Error getting Borehole Types: " + error); } } else { Debug.Log("SelectResult is null"); } return(boreholeTypes); }