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