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();
}
}
