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); }