internal static List <Expense> GetExpenses(string databaseConnectionString) { using (var db = new aExpenseDataContext(databaseConnectionString)) { return(db.Expenses.ToList()); } }
internal static List <ExpenseDetail> GetExpenseDetailsForExpense(string databaseConnectionString, Guid expenseId) { using (var db = new aExpenseDataContext(databaseConnectionString)) { return(db.ExpenseDetails.Where(e => e.ExpenseId == expenseId).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(); } }