public static void AddUser(User user) { using (var context = new ClockDbContext()) { context.Users.Add(user); context.SaveChanges(); } }
public static void SaveClock(Clock clock) { using (var context = new ClockDbContext()) { context.Entry(clock).State = EntityState.Modified; context.SaveChanges(); } }
public static void UpdateUser(User user) { using (var context = new ClockDbContext()) { context.Entry(user).State = EntityState.Modified; context.SaveChanges(); } }
public static void DeleteClock(Clock selectedClock) { using (var context = new ClockDbContext()) { selectedClock.ClearReferences(); context.Clocks.Attach(selectedClock); context.Clocks.Remove(selectedClock); context.SaveChanges(); } }
public static User GetUserByGuid(Guid guid) { try { using (var context = new ClockDbContext()) return(context.Users.Include(u => u.Clocks).FirstOrDefault(u => u.Id == guid)); } catch (Exception) { throw new InvalidOperationException(Resources.InvalidOperationException); } }
public static User GetUserByLogin(string login) { try { using (var context = new ClockDbContext()) return(context.Users.Include(u => u.Clocks).FirstOrDefault(u => u.Login == login)); } catch (Exception) { throw new InvalidOperationException(Resources.CantGetUserError); } }
public static bool UserExists(string login) { try { using (var context = new ClockDbContext()) return(context.Users.Any(u => u.Login == login)); } catch (Exception) { throw new InvalidOperationException(Resources.InvalidOperationException); } }
public static Clock AddClock(Clock clock) { using (var context = new ClockDbContext()) { clock.ClearReferences(); context.Clocks.Add(clock); context.SaveChanges(); } return(clock); }
public static void UpdateUser(User user) { using (var context = new ClockDbContext()) { context.Entry(user).State = EntityState.Modified; try { context.SaveChanges(); } catch (Exception) { throw new DbUpdateException(Resources.CantUpdateUserError); } } }
public static void AddUser(User user) { using (var context = new ClockDbContext()) { context.Users.Add(user); try { context.SaveChanges(); } catch (Exception) { throw new DbUpdateException(Resources.CantAddUserError); } } }
public static void SaveClock(Clock clock) { using (var context = new ClockDbContext()) { context.Entry(clock).State = EntityState.Modified; try { context.SaveChanges(); } catch (Exception) { throw new DbUpdateException(Resources.CantSaveClockError); } } }
public static void DeleteClock(Clock clock) { using (var context = new ClockDbContext()) { clock.ClearReferences(); context.Clocks.Attach(clock); context.Clocks.Remove(clock); try { context.SaveChanges(); } catch (Exception) { throw new DbUpdateException(Resources.CantDeleteClockError); } } }
public static Clock AddClock(Clock clock) { using (var context = new ClockDbContext()) { clock.ClearReferences(); context.Clocks.Add(clock); try { context.SaveChanges(); } catch (Exception) { throw new DbUpdateException(Resources.CantAddClockError); } } return(clock); }
public static User GetUserByGuid(Guid guid) { using (var context = new ClockDbContext()) return(context.Users.Include(u => u.Clocks).FirstOrDefault(u => u.Id == guid)); }
public static User GetUserByLogin(string login) { using (var context = new ClockDbContext()) return(context.Users.Include(u => u.Clocks).FirstOrDefault(u => u.Login == login)); }
public static bool UserExists(string login) { using (var context = new ClockDbContext()) return(context.Users.Any(u => u.Login == login)); }