public int GetAverageExpense()
{
try
{
using (SQLite.Net.SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), App.DB_PATH))
{
var allExpenses = conn.Table <ExpenseItem>();
var expenses = (from r in allExpenses
group r by r.Date into g
select new { Amount = g.Sum((t) => (t.Amount)) }
);
float avgCurrency = (float)expenses.Average(o => o.Amount) / 100.0f;
int avg = DataConversion.ConvertCurrencyToCents(avgCurrency);
return(avg);
}
}
catch
{
return(0); // error!!
}
}
