private async void ResetPausedTimeItemTapped(object sender, TappedRoutedEventArgs args) { ListView listView = GetListView(sender as DependencyObject); if (listView != null) { var resetList = listView.SelectedItems.Cast <PlayListFile>().ToList(); SQLitePCL.SQLiteResult result = SQLitePCL.SQLiteResult.DONE; foreach (var plf in resetList) { plf.PausedTime = TimeSpan.Zero; var rslt = playListDAO.UpdatePausedTime(plf); if (rslt != SQLitePCL.SQLiteResult.DONE) { result = rslt; } } if (result != SQLitePCL.SQLiteResult.DONE) { var resource = ResourceLoader.GetForCurrentView(); var dlg = DialogHelper.GetSimpleContentDialog( resource.GetString("Message/Error/Update"), resource.GetString("Message/Error/Retry"), resource.GetString("Button/Close/Content")); await dlg.ShowAsync(); App.ContentDlgOp = null; } } }
internal override Tuple <SQLitePCL.SQLiteResult, long> StepWithRowId(SqliteStatement stmt) { lock (dbLock) { long rowid = -1; var result = Tuple.Create <SQLitePCL.SQLiteResult, long>(SQLitePCL.SQLiteResult.ERROR, rowid); if (stmt != null && stmt._sqlite_stmt != null) { SQLitePCL.SQLiteResult stmtResult = stmt._sqlite_stmt.Step(); if (!_okResultMessages.Contains(stmtResult)) { _lastError = SqliteConvert.ToResultText(stmtResult); _lastErrorStatement = stmt._sqlStatement ?? "(none)"; throw new Exception(_lastError); } rowid = stmt._sql.LastInsertRowIdNoThreadLock; result = Tuple.Create(stmtResult, rowid); } return(result); } }
/// <summary> /// Translates a SQLite result message into a helpful text description (note: creating these helpful text descriptions is currently a work-in-progress). /// </summary> /// <param name="result">The SQLite result to translate</param> /// <returns>Text description</returns> public static string ToResultText(SQLitePCL.SQLiteResult result) { string resultText = "An unexpected SQLite result was encountered"; switch (result) { case SQLitePCL.SQLiteResult.ABORT: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.AUTH: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.BUSY: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.CANTOPEN: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.CONSTRAINT: resultText = "A SQLite table/column constraint violation occurred."; break; case SQLitePCL.SQLiteResult.CORRUPT: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.DONE: resultText = "A SQLite DONE result was returned."; break; case SQLitePCL.SQLiteResult.EMPTY: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.ERROR: resultText = "A SQLite ERROR result was returned."; break; case SQLitePCL.SQLiteResult.FORMAT: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.FULL: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.INTERNAL: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.INTERRUPT: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.IOERR: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.LOCKED: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.MISMATCH: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.MISUSE: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.NOLFS: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.NOMEM: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.NOTADB: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.NOTFOUND: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.NOTICE: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.OK: resultText = "A SQLite OK result was returned."; break; case SQLitePCL.SQLiteResult.PERM: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.PROTOCOL: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.RANGE: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.READONLY: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.ROW: resultText = "A SQLite ROW result was returned."; break; case SQLitePCL.SQLiteResult.SCHEMA: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.TOOBIG: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.WARNING: resultText += ": " + result.ToString(); break; default: resultText += "."; break; } return(resultText); }