public void CleanRepository() { using (var context = new ExpensesContext()) { context.Expenses.RemoveRange(context.Expenses); context.SaveChanges(); } }
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 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 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 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); } }
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 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; } }