public void updateTaskInDatabase(TaskRecord task, string dbPath)
{
var connectionString = String.Format("Data Source ={0}; Version = 3;", dbPath);
using (var conn = new SqliteConnection(connectionString))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "UPDATE task SET isCompleted = true, startTask = @startTask, stopTask = @stopTask WHERE _id = @_id";
cmd.Parameters.Add(new SqliteParameter("@_id", task._id));
cmd.Parameters.Add(new SqliteParameter("@startTask", task.startTask));
cmd.Parameters.Add(new SqliteParameter("@stopTask", task.stopTask));
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
uploadTaskData();
}
conn.Close();
}
}
public TaskRecord getTaskByTaskId(string dbPath, string task_id)
{
TaskRecord task = null;
var connectionString = String.Format("Data Source={0};Version=3;", dbPath);
using (var conn = new SqliteConnection(connectionString))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "SELECT * FROM task WHERE (_id) = @task_id";
cmd.Parameters.Add(new SqliteParameter("@task_id", task_id));
cmd.CommandType = CommandType.Text;
using (var reader = cmd.ExecuteReader())
{
int i = 0;
while (reader.Read())
{
i++;
task = new TaskRecord(reader);
}
if (i > 1)
{
Config.log("ERROR MORE CLIENT RECORDS THAN EXPECTED!");
}
if (task == null)
{
throw new ArgumentException("No such task! ", task_id);
}
}
}
conn.Close();
}
return(task);
}
public static void updateTaskInDatabase(TaskRecord task)
{
db.updateTaskInDatabase(task, dbPath);
}
