private static ServerData ResultToServerData(SQLiteDataReader result)
{
ServerData serverToReturn = null;
Guid id = result.GetGuid(0);
string name = result.GetString(1);
string description = result.GetString(2);
string location = result.GetString(3);
byte[] imageBytes = (byte[])result.GetValue(4);
SensorDescriptionsData sensorData = new SensorDescriptionsData();
SensorDefinition[] sensor = new SensorDefinition[4] { new SensorDefinition(), new SensorDefinition(), new SensorDefinition(), new SensorDefinition()};
for (int s = 0; s < 4; s++)
{
// Do 4 sensor descriptions and 4 fields for each
sensor[s].Name = (string)SQLHelper.ValueIfNull(result, s + 5, "");
sensor[s].Unit = (string)SQLHelper.ValueIfNull(result, s + 9, "");
sensor[s].ID = Convert.ToInt16(SQLHelper.ValueIfNull(result, s + 13, 255));
sensor[s].Range = Convert.ToInt16(SQLHelper.ValueIfNull(result, s + 17, 255));
sensorData.Add(sensor[s]);
}
serverToReturn = new ServerData(id, name, location, description, sensorData, imageBytes);
return serverToReturn;
}
private CrashReport MakeCrashReport(SQLiteDataReader reader)
{
Guid g = reader.GetGuid(0); //Guid.Parse(reader.GetString(0)));
long l = reader.GetInt64(1);
string s1 = reader.GetString(2);
string s2 = reader.GetString(3);
string s3 = reader.GetString(4);
string s4 = reader.GetString(5);
Version v = Version.Parse(reader.GetString(6));
string s6 = reader.GetValue(7) as string; //Not GetString as GetString throws an invalidCast
string s7 = reader.GetValue(8) as string; //(or another exception, cannot rmbr)
string userstory = reader.GetValue(9) as string; //If the value is null, and this and following fields
string trace = reader.GetValue(10) as string; //can be null as they aren't set before zip is downloaded
return new CrashReport(innerApi, g, l, s1, s2, s3, s4, v, s6, s7, trace, userstory);
}
