public ActionResult EditRecurringEvent(int id = 0) { List <EventLocation> locations = this._db.Query <EventLocation>("SELECT * FROM ec_locations").ToList(); locations.Insert(0, new EventLocation() { LocationName = "No Location", Id = 0 }); var e = _db.Single <RecurringEvent>(id); //Create SelectList with selected location SelectList list = new SelectList(locations, "Id", "LocationName", e.locationId); EditRecurringEventModel ere = new EditRecurringEventModel() { title = e.title, description = e.description, allDay = e.allDay, id = e.Id, day = (DayOfWeekEnum)e.day, frequency = (FrequencyTypeEnum)e.frequency, monthly = (MonthlyIntervalEnum)e.monthly_interval, calendar = e.calendarId, locations = list, selectedLocation = e.locationId }; return(PartialView(ere)); }
public void FlagMigrationAsFinished(IUmbracoMigration migration) { var migrationName = migration.GetType().Name; var migrationHistory = UmbracoDatabase.Single <MigrationHistory>("WHERE Name = @Name", new { Name = migrationName }); migrationHistory.Completed = true; UmbracoDatabase.Update(migrationHistory); }
/// <summary> /// Gets the audit log detail for one entry /// </summary> /// <param name="id">The Id of the row</param> /// <returns>A detail record</returns> public LogEntryDetail GetLogDetail(int id) { const string sql = @"SELECT L.Id, L.NodeId as NodeId, CT.icon as Icon, N.[text] as Name, U.id as UserId, U.userName as UserName, U.userEmail as UserEmail, L.Datestamp as DateStamp, L.logHeader as LogType, L.logComment as Comment, CT.Alias as Alias, CT.[description] as Description, L.nodeId FROM umbracoLog L LEFT JOIN umbracoUser U ON L.userId = U.id LEFT JOIN cmsDocument D ON L.NodeId = D.nodeId LEFT JOIN umbracoNode N ON N.id = L.nodeId LEFT JOIN cmsContent C ON C.nodeId = L.nodeId LEFT JOIN cmsContentType CT ON C.contentType = CT.nodeId WHERE L.Id = @0 AND (D.newest = 1 OR D.newest IS NULL)" ; return(db.Single <LogEntryDetail>(sql, id)); }
public ActionResult EditRecurringEvent(int id = 0) { List <EventLocation> locations = this._db.Query <EventLocation>("SELECT * FROM ec_locations").ToList(); locations.Insert(0, new EventLocation() { LocationName = "No Location", Id = 0 }); var e = _db.Single <RecurringEvent>(id); //Create SelectList with selected location SelectList list = new SelectList(locations, "Id", "LocationName", e.locationId); EditRecurringEventModel ere = new EditRecurringEventModel() { title = e.title, allDay = e.allDay, id = e.Id, day = (DayOfWeekEnum)e.day, frequency = (FrequencyTypeEnum)e.frequency, monthly = (MonthlyIntervalEnum)e.monthly_interval, calendar = e.calendarId, locations = list, selectedLocation = e.locationId }; //Get Descriptions for Event Dictionary <string, EventDesciption> descriptions = this._db.Query <EventDesciption>("SELECT * FROM ec_eventdescriptions WHERE eventid = @0 AND type = 1 AND calendarid = @1", id, e.calendarId).ToDictionary(x => x.CultureCode); List <ILanguage> languages = Services.LocalizationService.GetAllLanguages().ToList(); foreach (var lang in languages) { if (!descriptions.ContainsKey(lang.CultureInfo.ToString())) { descriptions.Add(lang.CultureInfo.ToString(), new EventDesciption() { CultureCode = lang.CultureInfo.ToString(), EventId = ere.id, Id = 0, Type = (int)EventType.Recurring, CalendarId = ere.calendar }); } } ere.Descriptions = descriptions; return(PartialView(ere)); }
public CustomMember GetMemberById(Guid id) { var member = _db.Single <CustomMember>("SELECT TOP 1 * FROM CustomMembers WHERE Id = @0", id); return(member); }