/// <summary>
/// Insert advanced reminder file(s)/folder(s) options (delete/open) for a specific reminder
/// </summary>
/// <param name="avr"></param>
/// <returns></returns>
public static long InsertAVRFilesFolders(AdvancedReminderFilesFolders avr)
{
using (RemindMeDbEntities db = new RemindMeDbEntities())
{
if (db.AdvancedReminderFilesFolders.Where(r => r.Id == avr.Id).Count() > 0)
{
//Exists already. update.
db.AdvancedReminderFilesFolders.Attach(avr);
var entry = db.Entry(avr);
entry.State = System.Data.Entity.EntityState.Modified; //Mark it for update
}
else
{
if (db.AdvancedReminderFilesFolders.Count() > 0)
{
avr.Id = db.AdvancedReminderFilesFolders.Max(i => i.Id) + 1;
}
else
{
avr.Id = 0;
}
db.AdvancedReminderFilesFolders.Add(avr);
}
db.SaveChanges();
db.Dispose();
}
return(avr.Id);
}
/// <summary>
/// Inserts file/folder actions into the database, with a link to the reminder by it's ID
/// </summary>
/// <param name="avr"></param>
/// <returns>The id of the newly inserted row. -1 if something went wrong</returns>
public static long InsertAVRFilesFolders(AdvancedReminderFilesFolders avr)
{
//First check if the reminder exists
if (DLReminders.GetReminderById(avr.Remid) == null)
{
return(-1);
}
return(DLLocalDatabase.AVRProperty.InsertAVRFilesFolders(avr));
}