public static void RefreshTasks(SQLiteDatabase db) { try { //UPDATE Tasks SET taskStatus=1 WHERE id=(SELECT id FROM Tasks WHERE taskStatus=0 LIMIT 1) db.ExecuteNonQuery("UPDATE Tasks SET taskStatus='3' WHERE id IN (SELECT id FROM Tasks WHERE taskStatus=-7)"); } catch (Exception fail) { throw new FSSQLiteException("An error occurred when trying to update a task."); } }
private static void ChangeState(string id, int stateCode, SQLiteDatabase db) { try { int res = db.ExecuteNonQuery(String.Format("UPDATE Tasks SET taskStatus={1} WHERE id={0}", id, stateCode)); } catch (Exception fail) { throw new FSSQLiteException("An error occurred when trying to update a task."); } }
public static void UpdateISBN(string id, string ISBN, SQLiteDatabase db) { try { //UPDATE Tasks SET taskStatus=1 WHERE id=(SELECT id FROM Tasks WHERE taskStatus=0 LIMIT 1) db.ExecuteNonQuery(String.Format("UPDATE Tasks SET taskStatus='0', ISBN='{1}' WHERE id={0}", id, SQLiteDatabase.EscapeSpecialChars(ISBN))); } catch (Exception fail) { throw new FSSQLiteException("An error occurred when trying to update a task."); } }