public void AddAttachement(Attachement.Item item)
{
_settingsStorage.AddAttachement(item);
}
public void DeleteAttachement(Attachement.Item item)
{
_settingsStorage.DeleteAttachement(item);
}
public List<Attachement.Item> GetAttachements(string gcCode)
{
List<Attachement.Item> result = new List<Attachement.Item>();
lock (this)
{
if (_dbcon != null)
{
DbDataReader dr;
if (string.IsNullOrEmpty(gcCode))
{
dr = _dbcon.ExecuteReader("select gccode, filename, comments from attachm");
}
else
{
dr = _dbcon.ExecuteReader(string.Format("select gccode, filename, comments from attachm where gccode='{0}'", gcCode));
}
while (dr.Read())
{
Attachement.Item it = new Attachement.Item();
it.GeocacheCode = dr["gccode"] as string;
it.FileName = dr["filename"] as string;
it.Comment = dr["comments"] as string;
result.Add(it);
}
}
}
return result;
}