/// <summary>
/// Method #2: Inserts an FinancialListBoxExpenseItem into Database
/// </summary>
/// <param name="item"></param>
/// <returns>Primary key of inserted item</returns>
public int insertExpenseItem2(FinancialListBoxExpenseItem item)
{
int primaryKey = 0;
connection.RunInTransaction(() =>
{
connection.Insert(item);
primaryKey = connection.ExecuteScalar <int>("SELECT last_insert_rowid()");
});
return(primaryKey);
}
/// <summary>
/// Method #1: Inserts an FinancialListBoxExpenseItem into Database
/// </summary>
/// <param name="item"></param>
/// <returns>Primary key of inserted item</returns>
public int insertExpenseItem(FinancialListBoxExpenseItem item)
{
int primaryKey = 0;
connection.RunInTransaction(() =>
{
connection.Insert(item);
primaryKey = item.expenseID;
});
return(primaryKey);
}
