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 = ""; } }