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