public void AddPersonToReminderList(string reminderType, string reminderFrequency, int personId, int churchId)
{
var reminder = Context.Reminders.FirstOrDefault(r => r.ChurchId == churchId && r.ReminderType == reminderType);
if (reminder == null)
{
reminder = new Reminder
{
ChurchId = churchId,
ReminderType = reminderType,
ReminderFrequency = reminderFrequency
};
Context.Reminders.AddObject(reminder);
}
var personToBeAdded = Context.People.FirstOrDefault(p => p.PersonId == personId);
if (personToBeAdded == null) return;
if (personToBeAdded.PersonChurches.Any(pc => pc.ChurchId == churchId))
{
reminder.People.Add(personToBeAdded);
Context.SaveChanges();
}
}
/// <summary>
/// Deprecated Method for adding a new object to the Reminders EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToReminders(Reminder reminder)
{
base.AddObject("Reminders", reminder);
}
/// <summary>
/// Create a new Reminder object.
/// </summary>
/// <param name="reminderId">Initial value of the ReminderId property.</param>
/// <param name="churchId">Initial value of the ChurchId property.</param>
/// <param name="reminderType">Initial value of the ReminderType property.</param>
/// <param name="reminderFrequency">Initial value of the ReminderFrequency property.</param>
public static Reminder CreateReminder(global::System.Int32 reminderId, global::System.Int32 churchId, global::System.String reminderType, global::System.String reminderFrequency)
{
Reminder reminder = new Reminder();
reminder.ReminderId = reminderId;
reminder.ChurchId = churchId;
reminder.ReminderType = reminderType;
reminder.ReminderFrequency = reminderFrequency;
return reminder;
}
public void UpdateReminderList(string reminderType, string reminderFrequency, int churchId)
{
var reminder = Context.Reminders.FirstOrDefault(r => r.ChurchId == churchId && r.ReminderType == reminderType);
if (reminder == null)
{
reminder = new Reminder
{
ChurchId = churchId,
ReminderType = reminderType,
ReminderFrequency = reminderFrequency
};
Context.Reminders.AddObject(reminder);
}
reminder.ReminderFrequency = reminderFrequency;
Context.SaveChanges();
}