/* * This inserts all expenses in a report into Expenses table. * The expenses in the same report will have the same value reportId * while inserting values into Expenses table, this will calculate total amount * of expenses in a report and call updateReportToTalAmount method will total amount. */ public void AddExpenses(int reportId) { ExpensesTableAdapter adapter = new ExpensesTableAdapter(); Reports.ExpensesDataTable expensesTable = new Reports.ExpensesDataTable(); double totalExpenses = 0; adapter.Fill(expensesTable); foreach (Expense expense in Expenses) { adapter.Insert(expense.Date, expense.Location, expense.Description, expense.Amount, expense.Currency, expense.Amount_aud, expense.Receipt, reportId); totalExpenses += expense.Amount_aud; } UpdateReportTotalAmount(reportId, totalExpenses); }