private void RenderNameCell(Gtk.TreeViewColumn column, Gtk.CellRenderer cell, Gtk.TreeModel model, Gtk.TreeIter iter)
{
TravelBug bug = (TravelBug)model.GetValue(iter, 0);
CellRendererText text = cell as CellRendererText;
text.Text = bug.Name;
}
public override TravelBug[] GetTravelBugs(string cachecode)
{
Trace("Getting Travel bugs for " + cachecode);
IDataReader rdr = ExecuteSQLQuery(String.Format(GET_TB, cachecode));
List<TravelBug> bugs = new List<TravelBug>();
while (rdr.Read())
{
TravelBug bug = new TravelBug();
bug.ID = rdr.GetString(0);
bug.Ref = rdr.GetString(1);
bug.Name = rdr.GetString(2);
bug.Cache = cachecode;
bugs.Add(bug);
}
return bugs.ToArray();
}
public override Dictionary<string, List<TravelBug>> GetTravelBugMulti(string[] cachecodes)
{
Trace("Getting Travel bugs multi ");
IDataReader rdr = ExecuteSQLQuery(String.Format(GET_TB_MULTI, ArrayToSQL(cachecodes)));
Dictionary<string, List<TravelBug>> bugs = new Dictionary<string, List<TravelBug>>();
while (rdr.Read())
{
TravelBug bug = new TravelBug();
bug.ID = rdr.GetString(0);
bug.Ref = rdr.GetString(1);
bug.Name = rdr.GetString(2);
bug.Cache = rdr.GetString(3);
if (!bugs.ContainsKey(bug.Cache))
{
bugs.Add(bug.Cache, new List<TravelBug>());
}
bugs[bug.Cache].Add(bug);
}
return bugs;
}
public override void AddTravelBug(string parent, TravelBug bug)
{
Trace("Adding travel bug for " + bug);
ExecuteSQLCommand(String.Format(ADD_TB, parent, bug.ID, bug.Ref, Escape(bug.Name)));
}
