private void BindVarData() { DateTime StartDate = new DateTime(0); DateTime EndDate = new DateTime(0); //SetDates(ddPeriod.Value, out StartDate, out EndDate, fromDate.Text, toDate.Text); UserReport.GetDates(ddPeriod.Value, out StartDate, out EndDate, dtcStartDate.SelectedDate.ToShortDateString(), dtcEndDate.SelectedDate.ToShortDateString()); using (IDataReader reader = UserReport.GetQuickSnapshotReport(StartDate, EndDate, 0)) { if (reader.Read()) { lblTotalProjects.Text = reader["ProjectsCount"].ToString(); lblTotalCalendarEntries.Text = reader["EventsCount"].ToString(); lblTotalIssues.Text = reader["IncidentsCount"].ToString(); lblTotalToDo.Text = reader["ToDosCount"].ToString(); lblTotalTasks.Text = reader["TasksCount"].ToString(); //lblTotalLibraryFiles.Text = reader["AssetsCount"].ToString(); //lblTotalLibraryFileVersions.Text = reader["AssetVersionsCount"].ToString(); lblNewProjectsCreated.Text = reader["NewProjectsCount"].ToString(); lblNewCalendarEntries.Text = reader["NewEventsCount"].ToString(); //lblNewFiles.Text = reader["NewAssetsCount"].ToString(); //lblNewFileVersions.Text = reader["NewAssetVersionsCount"].ToString(); lblNewIssuesCreated.Text = reader["NewIncidentsCount"].ToString(); lblNewToDo.Text = reader["NewToDosCount"].ToString(); lblNewTask.Text = reader["NewTasksCount"].ToString(); } } lblAuthenticatedUsers.Text = UserReport.GetAuthenticatedUsers(StartDate, EndDate).ToString(); lblPerTotalIMMaessages.Text = UserReport.GetCountIMMessages(StartDate, EndDate, false).ToString(); lblPerTotalChatMessages.Text = UserReport.GetCountChatMessages(StartDate, EndDate).ToString(); lblPerTotalFilesTransferred.Text = UserReport.GetFilesTransferred(StartDate, EndDate).ToString(); dgTop10.DataSource = UserReport.GetTop10Users(StartDate, EndDate); dgTop10.DataBind(); if (ddPeriod.Value != "0") { _header.Filter = LocRM.GetString("tPeriod") + ":<br/> " + StartDate.ToShortDateString() + " - " + EndDate.ToShortDateString(); } else { _header.Filter = ""; } if (ddPeriod.Value != "0") { lblInterval.Text = StartDate.ToShortDateString() + " - " + EndDate.ToShortDateString(); } else { lblInterval.Text = ""; } }
protected void Page_PreRender(object sender, System.EventArgs e) { if (Page.IsPostBack) { DateTime StartDate = new DateTime(0); DateTime EndDate = new DateTime(0); //SetDates(ddPeriod.Value, out StartDate, out EndDate, fromDate.Text, toDate.Text); UserReport.GetDates(ddPeriod.Value, out StartDate, out EndDate, dtcStartDate.SelectedDate.ToShortDateString(), dtcEndDate.SelectedDate.ToShortDateString()); pc["PortalQuickSnapshot_ddPeriod"] = ddPeriod.Value; if (ddPeriod.Value == "9") { pc["PortalQuickSnapshot_Start"] = StartDate.ToString(culture); pc["PortalQuickSnapshot_End"] = EndDate.ToString(culture); } } int nImMessages = UserReport.GetCountIMMessages(false); int nChatMessages = UserReport.GetCountChatMessages(); lblTotalIMMessages.Text = nImMessages.ToString(); lblTotalConfMessages.Text = nChatMessages.ToString(); lblTotalMessages.Text = (nImMessages + nChatMessages).ToString(); lblTotalFilesTransferred.Text = UserReport.GetFilesTransferred().ToString(); using (IDataReader reader = Mediachase.IBN.Business.User.GetUserStatistic()) { if (reader.Read()) { try { lblTotalGroups.Text = ((int)reader["SecureGroupCount"] + (int)reader["PartnerGroupCount"]).ToString(); } catch { } lblTotalUsers.Text = reader["TotalUserCount"].ToString(); lblTotalActiveUsers.Text = reader["ActiveUserCount"].ToString(); lblTotalInactiveUsers.Text = reader["InactiveUserCount"].ToString(); lblTotalExternalUsers.Text = reader["ExternalCount"].ToString(); lblTotalPendingUsers.Text = reader["PendingCount"].ToString(); } } BindVarData(); if (ddPeriod.Value == "9") { tableDate.Style.Add("display", "block"); } else { tableDate.Style.Add("display", "none"); } _header.ForPrintOnly = true; _header.Title = LocRM.GetString("tPrtQSnap"); if (Request["Export"] != null && Request["Export"] == "1") { ExportStatistics(); } if (!Mediachase.IBN.Business.Configuration.ProjectManagementEnabled) { trProjects.Visible = false; trTasks.Visible = false; trTotProjects.Visible = false; trTotTasks.Visible = false; } if (!Mediachase.IBN.Business.Configuration.HelpDeskEnabled) { trIssues.Visible = false; trTotIssues.Visible = false; } }