public static List <User> GetAllUsers(Guid reminderGuid) { using (var context = new ReminderDBContext()) { return(context.Users.Where(u => u.Reminders.All(r => r.Guid != reminderGuid)).ToList()); } }
public static User GetUserByLogin(string login) { using (var context = new ReminderDBContext()) { return(context.Users.Include(u => u.Reminders).FirstOrDefault(u => u.Login == login)); } }
public static User GetUserByGuid(Guid guid) { using (var context = new ReminderDBContext()) { return(context.Users.Include(u => u.Reminders).FirstOrDefault(u => u.Guid == guid)); } }
public static bool UserExists(string login) { using (var context = new ReminderDBContext()) { return(context.Users.Any(u => u.Login == login)); } }
public static User GetLastUserByDate() { using (var context = new ReminderDBContext()) { var users = context.Users; User user = null; foreach (var us in users) { if (user == null) { user = us; } if (user.LastLoginDate < us.LastLoginDate) { user = us; } } if (user.LogOut == true) { user = null; } return(user); } }
public static void SaveReminder(Reminder reminder) { using (var context = new ReminderDBContext()) { context.Entry(reminder).State = EntityState.Modified; context.SaveChanges(); } }
public static void AddUser(User user) { using (var context = new ReminderDBContext()) { context.Users.Add(user); context.SaveChanges(); } }
public static void AddReminder(Reminder reminder) { using (var context = new ReminderDBContext()) { reminder.DeleteDatabaseValues(); context.Reminders.Add(reminder); context.SaveChanges(); } }
public static void AddUser(User user) { using (var context = new ReminderDBContext()) { context.Users.Add(user); Console.WriteLine("user guid --- " + user.Guid); context.SaveChanges(); } }
public static void DeleteReminder(Reminder selectedReminder) { using (var context = new ReminderDBContext()) { selectedReminder.DeleteDatabaseValues(); context.Reminders.Attach(selectedReminder); context.Reminders.Remove(selectedReminder); context.SaveChanges(); } }
public static void AddReminder(Reminder reminder) { using (var context = new ReminderDBContext()) { reminder.DeleteDatabaseValues(); context.Reminders.Add(reminder); Console.WriteLine("rems guid --- " + reminder.Guid); context.SaveChanges(); } }
public static void SaveUser(User user) { using (var context = new ReminderDBContext()) { context.Users.Attach(user); context.Entry(user).Property(x => x.LastLoginDate).IsModified = true; context.Entry(user).Property(x => x.LogOut).IsModified = true; context.SaveChanges(); } }