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