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