public static bool UserExistsInDB(User user)
{
using (var context = new AlarmDBContext())
{
return(context.Users.Any(u => (u.Login == user.Login) || (u.Email == user.Email)));
}
}
public static IEnumerable <Alarm> GetAlarms(Guid guid)
{
using (var context = new AlarmDBContext())
{
return(context.Alarms.Where(r => r.UserGuid == guid).ToList());
}
}
public static void SaveAlarm(Alarm alarm)
{
using (var context = new AlarmDBContext())
{
context.Entry(alarm).State = EntityState.Modified;
context.SaveChanges();
}
}
public static void AddAlarm(Alarm alarm)
{
using (var context = new AlarmDBContext())
{
context.Alarms.Add(alarm);
context.SaveChanges();
}
}
public static void AddUser(User user)
{
using (var context = new AlarmDBContext())
{
context.Users.Add(user);
context.SaveChanges();
}
}
public static void DeleteAlarm(Alarm alarm)
{
using (var context = new AlarmDBContext())
{
alarm.deleteDBValues();
context.Alarms.Attach(alarm);
context.Alarms.Remove(alarm);
context.SaveChanges();
}
}
public static void UpdateAlarms()
{
using (var context = new AlarmDBContext())
{
foreach (Alarm al in context.Alarms)
{
al.BeginTime = al.CountDate(al.Hour, al.Minutes);
}
context.SaveChanges();
}
}
public static void EndAlarm(Alarm alarm, DateTime end)
{
using (var context = new AlarmDBContext())
{
Alarm al = context.Alarms.Where(u => u.Guid == alarm.Guid).First();
if (al != null)
{
al.EndTime = end;
}
context.SaveChanges();
}
}
public static void UpdateAlarm(Alarm alarm, int h, int m)
{
using (var context = new AlarmDBContext())
{
if (context.Alarms.Any(u => u.Hour == h && u.Minutes == m && u.Guid != alarm.Guid))
{
throw new Exception("This alarm is already exists!");
}
Alarm al = context.Alarms.Where(u => u.Guid == alarm.Guid).First();
al.Hour = h;
al.Minutes = m;
context.SaveChanges();
}
}
public static User UserByGuid(Guid guid)
{
using (var context = new AlarmDBContext())
return(context.Users.Include(us => us.Alarms).FirstOrDefault(us => us.Guid == guid));
}
public static User UserByLogin(string login)
{
using (var context = new AlarmDBContext())
return(context.Users.Include(us => us.Alarms).FirstOrDefault(us => us.Login == login));
}