public TimeReminderUserReminder SaveMyReminder(TimeReminderUserReminder timeReminderUserReminder)
{
if (timeReminderUserReminder.ID == 0)
{
using (var db = new ReminderDBEntities())
{
UserReminder userreminder = new UserReminder()
{
Reminder = timeReminderUserReminder.Reminder, ReminderDate = timeReminderUserReminder.ReminderDate, UserID = timeReminderUserReminder.UserID
};
db.UserReminders.Add(userreminder);
db.SaveChanges();
timeReminderUserReminder.ID = userreminder.ID;
}
}
else
{
using (var db = new ReminderDBEntities())
{
var userReminder = db.UserReminders.SingleOrDefault(u => u.ID == timeReminderUserReminder.ID);
if (userReminder != null)
{
userReminder.Reminder = timeReminderUserReminder.Reminder;
userReminder.ReminderDate = timeReminderUserReminder.ReminderDate;
userReminder.UserID = timeReminderUserReminder.UserID;
db.SaveChanges();
}
}
}
return(timeReminderUserReminder);
}
public TimeReminderUser SaveTimeReminderUser(TimeReminderUser timeReminderUser)
{
if (timeReminderUser.ID == 0)
{
using (var db = new ReminderDBEntities())
{
User user = new User()
{
UserName = timeReminderUser.UserName
};
db.Users.Add(user);
db.SaveChanges();
timeReminderUser.ID = user.ID;
}
}
else
{
using (var db = new ReminderDBEntities())
{
var user = db.Users.SingleOrDefault(u => u.ID == timeReminderUser.ID);
if (user != null)
{
user.UserName = timeReminderUser.UserName;
db.SaveChanges();
}
}
}
return(timeReminderUser);
}
public TimeReminderUserService()
{
using (var db = new ReminderDBEntities())
{
this.TimeReminderUsers = db.Users.Select(p => new TimeReminderUser {
ID = p.ID, UserName = p.UserName
}).ToList();
}
}
public void DeleteTimeReminderUser(int id)
{
using (var db = new ReminderDBEntities())
{
var result = db.Users.SingleOrDefault(u => u.ID == id);
if (result != null)
{
db.Users.Remove(result);
db.SaveChanges();
}
}
}
public TimeReminderUser GetTimeReminderUser(int id)
{
TimeReminderUser timeReminderUser;
using (var db = new ReminderDBEntities())
{
timeReminderUser = db.Users.Select(p => new TimeReminderUser {
ID = p.ID, UserName = p.UserName
}).FirstOrDefault();
}
return(timeReminderUser);
}
public IEnumerable <TimeReminderUser> TimeReminderUsers()
{
IEnumerable <TimeReminderUser> TimeReminderUsers;
using (var db = new ReminderDBEntities())
{
TimeReminderUsers = db.Users.Select(p => new TimeReminderUser {
ID = p.ID, UserName = p.UserName
}).ToList();
}
return(TimeReminderUsers);
}
public IEnumerable <TimeReminderUserReminder> GetReminders(int UserID)
{
IEnumerable <TimeReminderUserReminder> MyReminders;
using (var db = new ReminderDBEntities())
{
MyReminders = db.UserReminders.Select(
p => new TimeReminderUserReminder {
ID = p.ID, Reminder = p.Reminder, ReminderDate = p.ReminderDate,
UserID = p.UserID, TimeReminderUsers = db.Users.Select
(e => new TimeReminderUser
{
ID = e.ID,
UserName = e.UserName
}
)
}).Where(p => p.UserID == UserID).ToList();
}
return(MyReminders);
}
public TimeReminderUserReminder GetReminderByID(int id)
{
TimeReminderUserReminder Reminder;
using (var db = new ReminderDBEntities())
{
Reminder = db.UserReminders.Select(
p => new TimeReminderUserReminder
{
ID = p.ID,
Reminder = p.Reminder,
ReminderDate = p.ReminderDate,
UserID = p.UserID,
TimeReminderUsers = db.Users.Select
(e => new TimeReminderUser
{
ID = e.ID,
UserName = e.UserName
}
)
}).Where(p => p.ID == id).FirstOrDefault();
}
return(Reminder);
}
