public void UpdateTask(SqliteTask task)
{
// Set the task in the store so the model will update the UI.
Gtk.TreeIter iter;
if (!taskIters.ContainsKey(task.SqliteId))
{
return;
}
iter = taskIters [task.SqliteId];
if (task.State == TaskState.Deleted)
{
taskIters.Remove(task.SqliteId);
if (!taskStore.Remove(ref iter))
{
Logger.Debug("Successfully deleted from taskStore: {0}",
task.Name);
}
else
{
Logger.Debug("Problem removing from taskStore: {0}",
task.Name);
}
}
else
{
taskStore.SetValue(iter, 0, task);
}
}
public void RefreshTasks()
{
Gtk.TreeIter iter;
SqliteTask newTask;
bool hasValues = false;
string command = "SELECT id,Category,Name,DueDate,CompletionDate,Priority, State FROM Tasks";
SqliteCommand cmd = db.Connection.CreateCommand();
cmd.CommandText = command;
SqliteDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
int id = dataReader.GetInt32(0);
int category = dataReader.GetInt32(1);
string name = dataReader.GetString(2);
long dueDate = dataReader.GetInt64(3);
long completionDate = dataReader.GetInt64(4);
int priority = dataReader.GetInt32(5);
int state = dataReader.GetInt32(6);
hasValues = true;
newTask = new SqliteTask(this, id, category,
name, dueDate, completionDate,
priority, state);
iter = taskStore.AppendNode();
taskStore.SetValue(iter, 0, newTask);
taskIters [newTask.SqliteId] = iter;
}
dataReader.Close();
cmd.Dispose();
if (!hasValues)
{
newTask = new SqliteTask(this, "Create some tasks");
newTask.Category = defaultCategory;
newTask.DueDate = DateTime.Now;
newTask.Priority = TaskPriority.Medium;
iter = taskStore.AppendNode();
taskStore.SetValue(iter, 0, newTask);
taskIters [newTask.SqliteId] = iter;
}
}
public ITask CreateTask(string taskName, ICategory category)
{
// not sure what to do here with the category
SqliteTask task = new SqliteTask(this, taskName);
// Determine and set the task category
if (category == null || category is Tasque.AllCategory)
{
task.Category = defaultCategory; // Default to work
}
else
{
task.Category = category;
}
Gtk.TreeIter iter = taskStore.AppendNode();
taskStore.SetValue(iter, 0, task);
taskIters [task.SqliteId] = iter;
return(task);
}
public void RefreshTasks()
{
SqliteTask newTask;
var hasValues = false;
var command = "SELECT id,Category,Name,DueDate,CompletionDate,Priority, State FROM Tasks";
var cmd = Database.Connection.CreateCommand ();
cmd.CommandText = command;
var dataReader = cmd.ExecuteReader ();
while (dataReader.Read()) {
var id = dataReader.GetInt32 (0);
var category = dataReader.GetInt32 (1);
var name = dataReader.GetString (2);
var dueDate = dataReader.GetInt64 (3);
var completionDate = dataReader.GetInt64 (4);
var priority = dataReader.GetInt32 (5);
var state = dataReader.GetInt32 (6);
hasValues = true;
newTask = new SqliteTask (this, id, category, name, dueDate,
completionDate, priority, state);
Categories.ElementAt (category).Add (newTask);
}
dataReader.Close ();
cmd.Dispose ();
if (!hasValues) {
var task = CreateTask (Catalog.GetString ("Create some tasks"));
defaultCategory.Add (task);
}
}
public void UpdateTask(SqliteTask task)
{
// Set the task in the store so the model will update the UI.
Gtk.TreeIter iter;
if (!taskIters.ContainsKey (task.SqliteId))
return;
iter = taskIters [task.SqliteId];
if (task.State == TaskState.Deleted) {
taskIters.Remove (task.SqliteId);
if (!taskStore.Remove (ref iter)) {
Logger.Debug ("Successfully deleted from taskStore: {0}",
task.Name);
} else {
Logger.Debug ("Problem removing from taskStore: {0}",
task.Name);
}
} else {
taskStore.SetValue (iter, 0, task);
}
}
public void RefreshTasks()
{
Gtk.TreeIter iter;
SqliteTask newTask;
bool hasValues = false;
string command = "SELECT id,Category,Name,DueDate,CompletionDate,Priority, State FROM Tasks";
SqliteCommand cmd = db.Connection.CreateCommand();
cmd.CommandText = command;
SqliteDataReader dataReader = cmd.ExecuteReader();
while(dataReader.Read()) {
int id = dataReader.GetInt32(0);
int category = dataReader.GetInt32(1);
string name = dataReader.GetString(2);
long dueDate = dataReader.GetInt64(3);
long completionDate = dataReader.GetInt64(4);
int priority = dataReader.GetInt32(5);
int state = dataReader.GetInt32(6);
hasValues = true;
newTask = new SqliteTask(this, id, category,
name, dueDate, completionDate,
priority, state);
iter = taskStore.AppendNode();
taskStore.SetValue (iter, 0, newTask);
taskIters [newTask.SqliteId] = iter;
}
dataReader.Close();
cmd.Dispose();
if(!hasValues)
{
newTask = new SqliteTask (this, "Create some tasks");
newTask.Category = defaultCategory;
newTask.DueDate = DateTime.Now;
newTask.Priority = TaskPriority.Medium;
iter = taskStore.AppendNode ();
taskStore.SetValue (iter, 0, newTask);
taskIters [newTask.SqliteId] = iter;
}
}
public ITask CreateTask(string taskName, ICategory category)
{
// not sure what to do here with the category
SqliteTask task = new SqliteTask (this, taskName);
// Determine and set the task category
if (category == null || category is Tasque.AllCategory)
task.Category = defaultCategory; // Default to work
else
task.Category = category;
Gtk.TreeIter iter = taskStore.AppendNode ();
taskStore.SetValue (iter, 0, task);
taskIters [task.SqliteId] = iter;
return task;
}
