public List<UIControls.Trackables.TrackableItem> GetTrackables(UIControls.Trackables.TrackableGroup grp)
{
List<UIControls.Trackables.TrackableItem> result = new List<UIControls.Trackables.TrackableItem>();
lock (this)
{
if (_dbcon != null)
{
DbDataReader dr = _dbcon.ExecuteReader(string.Format("select * from trktrackables where groupid={0}", grp.ID));
while (dr.Read())
{
UIControls.Trackables.TrackableItem trk = new UIControls.Trackables.TrackableItem();
trk.Code = (string)dr["Code"];
if (dr["AllowedToBeCollected"] != null && dr["AllowedToBeCollected"].GetType() != typeof(DBNull))
{
trk.AllowedToBeCollected = (int)dr["AllowedToBeCollected"] != 0;
}
else
{
trk.AllowedToBeCollected = null;
}
trk.Archived = (int)dr["Archived"] != 0;
trk.BugTypeID = (int)dr["BugTypeID"];
trk.CurrentGeocacheCode = (string)dr["CurrentGeocacheCode"];
trk.CurrentGoal = (string)dr["CurrentGoal"];
trk.DateCreated = DateTime.Parse((string)dr["DateCreated"]);
trk.Description = (string)dr["Description"];
trk.IconUrl = (string)dr["IconUrl"];
trk.Id = (int)dr["Id"];
trk.InCollection = (int)dr["InCollection"] != 0;
trk.Name = (string)dr["Name"];
trk.TBTypeName = (string)dr["TBTypeName"];
trk.Url = (string)dr["Url"];
trk.WptTypeID = (int)dr["WptTypeID"];
trk.Owner = (string)dr["Owner"];
if (dr["HopCount"] != null && dr["HopCount"].GetType() != typeof(DBNull))
{
trk.HopCount = (int)dr["HopCount"];
}
else
{
trk.HopCount = 0;
}
if (dr["DiscoverCount"] != null && dr["DiscoverCount"].GetType() != typeof(DBNull))
{
trk.DiscoverCount = (int)dr["DiscoverCount"];
}
else
{
trk.DiscoverCount = 0;
}
if (dr["InCacheCount"] != null && dr["InCacheCount"].GetType() != typeof(DBNull))
{
trk.InCacheCount = (int)dr["InCacheCount"];
}
else
{
trk.InCacheCount = 0;
}
if (dr["DistanceKm"] != null && dr["DistanceKm"].GetType() != typeof(DBNull))
{
trk.DistanceKm = (double)dr["DistanceKm"];
}
else
{
trk.DistanceKm = 0.0;
}
if (dr["Lat"] != null && dr["Lat"].GetType() != typeof(DBNull))
{
trk.Lat = (double)dr["Lat"];
}
else
{
trk.Lat = null;
}
if (dr["Lon"] != null && dr["Lon"].GetType() != typeof(DBNull))
{
trk.Lon = (double)dr["Lon"];
}
else
{
trk.Lon = null;
}
result.Add(trk);
}
foreach(var t in result)
{
t.IconData = _dbcon.ExecuteScalar(string.Format("select imagedata from trkimages where url='{0}'", t.IconUrl ?? "")) as byte[];
}
}
}
return result;
}
public void UpdateTrackableLogs(UIControls.Trackables.TrackableItem trackable, List <UIControls.Trackables.LogItem> logs)
{
_settingsStorage.UpdateTrackableLogs(trackable, logs);
}
public void UpdateTrackableTravels(UIControls.Trackables.TrackableItem trackable, List <UIControls.Trackables.TravelItem> travels)
{
_settingsStorage.UpdateTrackableTravels(trackable, travels);
}
public List <UIControls.Trackables.LogItem> GetTrackableLogs(UIControls.Trackables.TrackableItem trackable)
{
return(_settingsStorage.GetTrackableLogs(trackable));
}
public void DeleteTrackable(UIControls.Trackables.TrackableGroup grp, UIControls.Trackables.TrackableItem trackable)
{
_settingsStorage.DeleteTrackable(grp, trackable);
}
