protected void SelectionChange(Object sender, EventArgs e) { DateTime d = DateTime.Now; foreach (DateTime day in Calendar1.SelectedDates) { d = day; } MyRecentContentGridView.DataSource = GetRecentContent(d); MyRecentContentGridView.DataBind(); }
override protected void OnInit(EventArgs e) { base.OnInit(e); this.AddResourceToClientDependency("Moriyama.Workflow.Umbraco6.Web.Workflow.Css.Grid.css", ClientDependencyType.Css); SendToWorkflowButton.Text = TheGlobalisationService.GetString("send_selected_content_to_workflow"); var user = User.GetCurrent(); var sevenDaysAgo = DateTime.Now.AddDays(-7); MyRecentContentGridView.DataSource = GetRecentContent(sevenDaysAgo); MyRecentContentGridView.DataBind(); }
protected override void OnInit(EventArgs e) { base.OnInit(e); this.AddResourceToClientDependency("Moriyama.Workflow.Umbraco6.Web.Workflow.Css.Grid.css", ClientDependencyType.Css); SendToWorkflowButton.Text = TheGlobalisationService.GetString("send_selected_content_to_workflow"); var user = User.GetCurrent(); var sevenDaysAgo = DateTime.Now.AddDays(-7); var db = new Database("umbracoDbDSN"); var items = user.UserType.Alias == AdminUserTypeAlias ? db.Query<LogEntry>("select * from umbracoLog where logHeader = 'Save' and Datestamp > @0", sevenDaysAgo) : db.Query<LogEntry>("select * from umbracoLog where logHeader = 'Save' and Datestamp > @0 and userId = @1", sevenDaysAgo, user.Id); //var logItems = user.UserType.Alias == AdminUserTypeAlias // ? Log.Instance.GetLogItems(LogTypes.Save, sevenDaysAgo) // : Log.Instance.GetLogItems(user, LogTypes.Save, sevenDaysAgo); var recentContent = items .Select(item => item.NodeId).Distinct() .Select(id => { try { return new Document(id); } catch (ArgumentException) { return null; } }) .Where(d => d != null) .OrderByDescending(d => d.UpdateDate) .ToList(); if (!recentContent.Any()) return; MyRecentContentGridView.DataSource = recentContent; MyRecentContentGridView.DataBind(); }
override protected void OnInit(EventArgs e) { base.OnInit(e); this.AddResourceToClientDependency("FergusonMoriyam.Workflow.Umbraco.Web.Ui.Css.Grid.css", ClientDependencyType.Css); SendToWorkflowButton.Text = TheGlobalisationService.GetString("send_selected_content_to_workflow"); var user = User.GetCurrent(); var sevenDaysAgo = DateTime.Now.Subtract(new TimeSpan(7, 0, 0, 0, 0)); var logReader = user.UserType.Alias == AdminUserTypeAlias?Log.GetLogReader(LogTypes.Save, sevenDaysAgo) : Log.GetLogReader(user, LogTypes.Save, sevenDaysAgo); var recentContentItems = new Dictionary <int, Document>(); // if (!logReader.HasRecords) return; while (logReader.Read()) { var id = logReader.GetInt("NodeId"); if (recentContentItems.ContainsKey(id)) { continue; } recentContentItems.Add(id, new Document(id)); } if (recentContentItems.Count == 0) { return; } MyRecentContentGridView.DataSource = recentContentItems.Values; MyRecentContentGridView.DataBind(); }