internal static List<Expense> GetExpenses(string databaseConnectionString)
{
using (var db = new aExpenseDataContext(databaseConnectionString))
{
return db.Expenses.ToList();
}
}
public static void DeleteAllNonDefaultExpenses(string databaseConnectionString)
{
Guid guid1 = new Guid("abafc874-d0cc-4245-9319-1e5a75108a41");
Guid guid2 = new Guid("abafc874-d0cc-4245-9319-1e5c77158b42");
Guid guid3 = new Guid("abafc874-a0cc-4145-9319-1e5c78508a41");
using (var db = new aExpenseDataContext(databaseConnectionString))
{
var expenseDetails = db.ExpenseDetails.Where(e => e.ExpenseId != guid1 &&
e.ExpenseId != guid2 &&
e.ExpenseId != guid3 );
var expenses = db.Expenses.Where(e => e.Id != guid1 &&
e.Id != guid2 &&
e.Id != guid3);
db.ExpenseDetails.DeleteAllOnSubmit(expenseDetails);
db.Expenses.DeleteAllOnSubmit(expenses);
db.SubmitChanges();
}
}
internal static List<ExpenseDetail> GetExpenseDetailsForExpense(string databaseConnectionString, Guid expenseId)
{
using (var db = new aExpenseDataContext(databaseConnectionString))
{
return db.ExpenseDetails.Where(e => e.ExpenseId == expenseId).ToList();
}
}