public DbExpense GetExpense(int expenseId) { using (var context = new ExpensesContext()) { return context.Expenses.SingleOrDefault(e => e.ExpenseId == expenseId); } }
public IEnumerable<DbExpense> GetExpenses() { using (var context = new ExpensesContext()) { return context.Expenses.ToList(); } }
public DbCharge GetCharge(int chargeId) { using (var context = new ExpensesContext()) { return(context.Charges.Include(r => r.ExpenseReport) .SingleOrDefault(i => i.ChargeId == chargeId)); } }
public void CleanRepository() { using (var context = new ExpensesContext()) { context.Expenses.RemoveRange(context.Expenses); context.SaveChanges(); } }
public DbCharge GetCharge(int chargeId) { using (var context = new ExpensesContext()) { return context.Charges.Include(r => r.ExpenseReport) .SingleOrDefault(i => i.ChargeId == chargeId); } }
public DbEmployee GetEmployee(string employeeAlias) { using (var context = new ExpensesContext()) { return context.Employees.Include(c => c.Charges).Include(r => r.ExpenseReports) .SingleOrDefault(i => i.Alias == employeeAlias); } }
public DbExpenseReport GetExpenseReport(int reportId) { using (var context = new ExpensesContext()) { return context.Reports.Include(r => r.Charges) .SingleOrDefault(i => i.ExpenseReportId == reportId); } }
public DbExpenseReport GetExpenseReport(int reportId) { using (var context = new ExpensesContext()) { return(context.Reports.Include(r => r.Charges) .SingleOrDefault(i => i.ExpenseReportId == reportId)); } }
public DbEmployee GetEmployee(string employeeAlias) { using (var context = new ExpensesContext()) { return(context.Employees.Include(c => c.Charges).Include(r => r.ExpenseReports) .SingleOrDefault(i => i.Alias == employeeAlias)); } }
public DbExpense SaveExpense(DbExpense expense) { using (var context = new ExpensesContext()) { context.Expenses.Add(expense); context.SaveChanges(); return expense; } }
public void CleanRepository() { using (var context = new ExpensesContext()) { context.Charges.RemoveRange(context.Charges); context.Reports.RemoveRange(context.Reports); context.Employees.RemoveRange(context.Employees); context.SaveChanges(); } }
public void DeleteCharge(int chargeId) { using (var context = new ExpensesContext()) { var charge = context.Charges.SingleOrDefault(i => i.ChargeId == chargeId); if (charge != null) { context.Charges.Remove(charge); context.SaveChanges(); } } }
public void DeleteExpenseReport(int reportId) { using (var context = new ExpensesContext()) { var report = context.Reports.SingleOrDefault(i => i.ExpenseReportId == reportId); if (report != null) { context.Reports.Remove(report); context.SaveChanges(); } } }
public DbExpenseReport SaveExpenseReport(DbExpenseReport report) { using (var context = new ExpensesContext()) { if (report.ExpenseReportId != 0) { context.Reports.Attach(report); context.Entry <DbExpenseReport>(report).State = System.Data.Entity.EntityState.Modified; } else { context.Reports.Add(report); } context.SaveChanges(); return(report); } }
public DbCharge SaveCharge(DbCharge charge) { using (var context = new ExpensesContext()) { if (charge.ChargeId != 0) { context.Charges.Attach(charge); context.Entry<DbCharge>(charge).State = System.Data.Entity.EntityState.Modified; } else { context.Charges.Add(charge); } context.SaveChanges(); return charge; } }
public DbCharge SaveCharge(DbCharge charge) { using (var context = new ExpensesContext()) { if (charge.ChargeId != 0) { context.Charges.Attach(charge); context.Entry <DbCharge>(charge).State = System.Data.Entity.EntityState.Modified; } else { context.Charges.Add(charge); } context.SaveChanges(); return(charge); } }
public DbEmployee SaveEmployee(DbEmployee employee) { using (var context = new ExpensesContext()) { if (employee.EmployeeId != 0) { context.Employees.Attach(employee); context.Entry <DbEmployee>(employee).State = System.Data.Entity.EntityState.Modified; } else { context.Employees.Add(employee); } context.SaveChanges(); return(employee); } }
public DbExpenseReport SaveExpenseReport(DbExpenseReport report) { using (var context = new ExpensesContext()) { if (report.ExpenseReportId != 0) { context.Reports.Attach(report); context.Entry<DbExpenseReport>(report).State = System.Data.Entity.EntityState.Modified; } else { context.Reports.Add(report); } context.SaveChanges(); return report; } }
public DbEmployee SaveEmployee(DbEmployee employee) { using (var context = new ExpensesContext()) { if (employee.EmployeeId != 0) { context.Employees.Attach(employee); context.Entry<DbEmployee>(employee).State = System.Data.Entity.EntityState.Modified; } else { context.Employees.Add(employee); } context.SaveChanges(); return employee; } }