/// <summary> /// Inserts an expense row. /// </summary> /// <param name="expense">An Expense object.</param> public void Create(ExpenseReview review) { using (ExpenseDataContext ctx = new ExpenseDataContext()) { ctx.AddObject(ENTITY_SET_NAME, review); ctx.SaveChanges(); } }
/// <summary> /// Inserts an expense row. /// </summary> /// <param name="expense">An Expense object.</param> public Expense Create(Expense expense) { using (ExpenseDataContext ctx = new ExpenseDataContext()) { ctx.Expenses.AddObject(expense); ctx.SaveChanges(); } return expense; }
public List<ExpenseReview> SelectByExpenseID(long expenseID) { List<ExpenseReview> resultsList = null; using (ExpenseDataContext ctx = new ExpenseDataContext()) { resultsList = (from review in ctx.ExpenseReviews where review.Expense.ExpenseID == expenseID orderby review.DateApproved select review).ToList(); } return resultsList; }
public List<ExpenseLog> SelectByExpenseID(long expenseID) { List<ExpenseLog> resultsList = null; using (ExpenseDataContext ctx = new ExpenseDataContext()) { resultsList = (from log in ctx.ExpenseLogs where log.Expense.ExpenseID == expenseID orderby log.DateCreated select log).ToList(); } return resultsList; }
public List<Expense> SelectActive() { List<Expense> resultsList = null; using (ExpenseDataContext ctx = new ExpenseDataContext()) { resultsList = (from expense in ctx.Expenses where expense.IsCompleted == false orderby expense.DateSubmitted descending select expense).ToList(); } return resultsList; }
public void Purge() { using (ExpenseDataContext ctx = new ExpenseDataContext()) { List<Expense> resultList = (from expense in ctx.Expenses select expense).ToList(); foreach (Expense expense in resultList) { ctx.DeleteObject(expense); } ctx.SaveChanges(); } }
public List<Expense> SelectForApproval(string reviewer) { List<Expense> resultsList = null; using (ExpenseDataContext ctx = new ExpenseDataContext()) { resultsList = (from expense in ctx.Expenses where expense.AssignedTo == reviewer && expense.IsCompleted == false orderby expense.DateSubmitted descending select expense).ToList(); } return resultsList; }
/// <summary> /// Updates an Expense row. /// </summary> /// <param name="expense">A Expense object.</param> public void Update(Expense expense) { EntityKey key = null; object original = null; using (ExpenseDataContext ctx = new ExpenseDataContext()) { key = ctx.CreateEntityKey(ENTITY_SET_NAME, expense); if (ctx.TryGetObjectByKey(key, out original)) { ctx.ApplyCurrentValues(key.EntitySetName, expense); } ctx.SaveChanges(); } }
/// <summary> /// Returns a set of Expenses that belongs to an employee /// </summary> /// <param name="employeeID">An EmployeeID.</param> /// <returns>A List of expenses.</returns> public List<Expense> SelectForEmployee(string employee) { List<Expense> resultsList = null; using (ExpenseDataContext ctx = new ExpenseDataContext()) { resultsList = (from expense in ctx.Expenses where expense.Employee == employee orderby expense.DateSubmitted descending select expense).ToList(); } return resultsList; }