public long AddSublistEntry(ISublistEntry entry)
{
const string mainSql = @"INSERT INTO Entry " +
"(Title, Completed, CreatedAtUtc) " +
"VALUES " +
"(@title, @completed, @createdAtUtc)";
const string relationSql = @"INSERT INTO EntryRelation " +
"(ParentId, ChildId) " +
"VALUES " +
"(@parentId, @childId)";
using (var transaction = new SQLiteTransaction(SharedConnection))
{
using (var statement = transaction.Prepare(mainSql))
{
statement.Binding("@title", entry.Title);
statement.Binding("@completed", entry.Completed);
statement.Binding("@createdAtUtc", entry.CreatedAtUtc);
transaction.Execute(statement);
}
entry.Id = transaction.LastInsertRowId();
if (entry.ParentId.HasValue)
{
using (var statement = transaction.Prepare(relationSql))
{
statement.Binding("@parentId", entry.ParentId.Value);
statement.Binding("@childId", entry.Id);
transaction.Execute(statement);
}
}
transaction.Commit();
}
return(entry.Id);
}
public long AddSublistEntry(ISublistEntry entry)
{
const string mainSql = @"INSERT INTO Entry " +
"(Title, Completed, CreatedAtUtc) " +
"VALUES " +
"(@title, @completed, @createdAtUtc)";
const string relationSql = @"INSERT INTO EntryRelation " +
"(ParentId, ChildId) " +
"VALUES " +
"(@parentId, @childId)";
using (var transaction = new SQLiteTransaction(SharedConnection))
{
using (var statement = transaction.Prepare(mainSql))
{
statement.Binding("@title", entry.Title);
statement.Binding("@completed", entry.Completed);
statement.Binding("@createdAtUtc", entry.CreatedAtUtc);
transaction.Execute(statement);
}
entry.Id = transaction.LastInsertRowId();
if (entry.ParentId.HasValue)
{
using (var statement = transaction.Prepare(relationSql))
{
statement.Binding("@parentId", entry.ParentId.Value);
statement.Binding("@childId", entry.Id);
transaction.Execute(statement);
}
}
transaction.Commit();
}
return entry.Id;
}