public int CountEvents()
{
using (var db = new SitecoreEventLogDatabaseCommand())
{
return((int)db.ExecuteStoredProcedureScaler("dbo.CountEvents"));
}
}
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 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 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());
}
}
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());
}
}
