public SaveDetail AddSaveDetailItem(SaveDetail item) { using (var db = new SitecoreEventLogDatabaseCommand()) { db.AddParameter("Language", item.Language); db.AddParameter("Changes", item.Changes); return(db.ExecuteStoredProcedureQuery <SaveDetail>("dbo.AddSaveDetailItem").FirstOrDefault()); } }
public List <Event> GetEventsByItemId(Guid itemId, int maximumRows, int startRows) { using (var db = new SitecoreEventLogDatabaseCommand()) { db.AddParameter("ItemId", itemId); db.AddParameter("MaximumRows", maximumRows); db.AddParameter("StartRows", startRows); return(db.ExecuteStoredProcedureQuery <Event>("dbo.GetEventsByItemId")); } }
public List <Event> GetPagedEvents(int maximumRows, int startRows) { using (var db = new SitecoreEventLogDatabaseCommand()) { db.AddParameter("MaximumRows", maximumRows); db.AddParameter("StartRows", startRows); //TODO get PublishDetail inside Events return(db.ExecuteStoredProcedureQuery <Event>("dbo.GetPagedEvents")); } }
public int CountEventsByItemId(Guid itemId) { using (var db = new SitecoreEventLogDatabaseCommand()) { db.AddParameter("ItemId", itemId); return((int)db.ExecuteStoredProcedureScaler("dbo.CountEventsByItemId")); } }
public Event GetEventItemById(int id) { using (var db = new SitecoreEventLogDatabaseCommand()) { db.AddParameter("Id", id); return(db.ExecuteStoredProcedureQuery <Event>("dbo.GetEventItemById").FirstOrDefault()); } }
public Event AddEventItem(Event item) { using (var db = new SitecoreEventLogDatabaseCommand()) { db.AddParameter("ItemId", item.ItemId); db.AddParameter("ItemPath", item.ItemPath); db.AddParameter("EventType", item.EventType); db.AddParameter("Date", item.Date); db.AddParameter("UserName", item.UserName); db.AddParameter("SourceDatabase", item.SourceDatabase); db.AddParameter("ItemVersion", item.ItemVersion); db.AddParameter("PublishDetailId", item.PublishDetailId); db.AddParameter("SaveDetailId", item.SaveDetailId); return(db.ExecuteStoredProcedureQuery <Event>("dbo.AddEventItem").FirstOrDefault()); } }
public PublishDetail AddPublishDetailItem(PublishDetail item) { using (var db = new SitecoreEventLogDatabaseCommand()) { db.AddParameter("Cultures", item.Cultures); db.AddParameter("TargetDatabases", item.TargetDatabases); db.AddParameter("IsSitePublish", item.IsSitePublish); db.AddParameter("WithSubItems", item.WithSubItems); db.AddParameter("WithRelatedItems", item.WithRelatedItems); db.AddParameter("RootItemId", item.RootItemId); db.AddParameter("RootItemPath", item.RootItemPath); db.AddParameter("PublishType", item.PublishType); return(db.ExecuteStoredProcedureQuery <PublishDetail>("dbo.AddPublishDetailItem").FirstOrDefault()); } }