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