public IEnumerable <DBModels.AlarmClock> GetAlarmClocks(Guid userGuid) { using (var context = new AlarmClockDbContext()) { return(context.AlarmClocks.Where(x => x.OwnerGuid == userGuid).ToList()); } }
public void AddUser(string firstName, string lastName, string login, string email, string password) { using (var context = new AlarmClockDbContext()) { var resUserLogin = context.Users.FirstOrDefault(u => u.Login == login || u.Email == email); if (resUserLogin != null) { throw new ArgumentException("User with that login or email already exists"); } context.Users.Add(new User(firstName, lastName, login, email, password)); context.SaveChanges(); } }
public void DeleteAlarmClock(Guid alarmGuid) { using (var context = new AlarmClockDbContext()) { var cl = context.AlarmClocks.FirstOrDefault(c => c.Guid == alarmGuid); if (cl != null) { context.AlarmClocks.Remove(cl); } else { throw new ArgumentException("Couldn't find clock in database: " + alarmGuid); } context.SaveChanges(); } }
public void AddAlarmClock(Guid userGuid, DBModels.AlarmClock clock) { using (var context = new AlarmClockDbContext()) { var user = context.Users.Include(i => i.AlarmClocks) .FirstOrDefault(u => u.Guid == userGuid); if (user != null) { user.AlarmClocks.Add(clock); context.SaveChanges(); } else { throw new ArgumentException("Couldn't find user with that guid"); } } }
public User GetUser(string login, string password) { using (var context = new AlarmClockDbContext()) { var resUser = context.Users.FirstOrDefault(u => u.Login == login); if (resUser != null) { if (!resUser.CheckPassword(password)) { throw new ArgumentException("Couldn't find user with that login or password"); } } else { throw new ArgumentException("Couldn't find user with that login or password"); } return(resUser); } }
public void UpdateAlarmClock(Guid alarmGuid, DateTime lastTime, DateTime nextTime) { using (var context = new AlarmClockDbContext()) { try { var cl = context.AlarmClocks.FirstOrDefault(c => c.Guid == alarmGuid); if (cl != null) { cl.LastAlarmTime = lastTime; cl.NextAlarmTime = nextTime; context.SaveChanges(); } else { throw new ArgumentException("Couldn't find clock in database: "); } } catch (Exception e) { throw e; } } }