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 = ""; } }
private void BindUserStat(int iUserId, DateTime StartDate, DateTime EndDate) { int iIMGroupId = 0; using (IDataReader reader = UserReport.GetUserInfo(iUserId, false)) { if (reader.Read()) { if (reader["Login"] != DBNull.Value) { lblUserAccountName.Text = reader["Login"].ToString(); } lblUserEmail.Text = reader["Email"].ToString(); lblUserFirstName.Text = reader["FirstName"].ToString(); lblUserLastName.Text = reader["LastName"].ToString(); lblUserStatus.Text = ((bool)reader["IsActive"]) ? LocRM.GetString("tActive") : LocRM.GetString("tNotActive"); if (reader["IMGroupId"] != DBNull.Value) { iIMGroupId = (int)reader["IMGroupId"]; } } } if (!Mediachase.IBN.Business.User.IsExternal(iUserId) && Mediachase.IBN.Business.User.GetUserActivity(iUserId) != Mediachase.IBN.Business.User.UserActivity.Pending) { DataTable dt = UserReport.GetUserStats(iUserId, StartDate, EndDate); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; lblClientLoginsCount.Text = ((int)dr["LoginsClient"]).ToString(); lblUserConfCreated.Text = ((int)dr["ConfCreated"]).ToString(); lblUserConfMessagesSent.Text = ((int)dr["ConfMsgSent"]).ToString(); lblUserMessagesReceived.Text = ((int)dr["MsgReceived"]).ToString(); lblUserMessagesSent.Text = ((int)dr["MsgSent"]).ToString(); lblUserTotalFilesReceived.Text = ((int)dr["FilesReceived"]).ToString(); lblUserTotalFilesReceivedBytes.Text = FormatBytes((long)dr["FRBytes"]); lblUserTotalFilesSent.Text = ((int)dr["FilesSent"]).ToString(); lblUserTotalFilesSentBytes.Text = FormatBytes((long)dr["FSBytes"]); } using (IDataReader rdr = UserReport.GetIMGroup(iIMGroupId)) { if (rdr.Read() && rdr["IMGroupName"] != DBNull.Value) { lblUserGroupName.Text = rdr["IMGroupName"].ToString(); } } } using (IDataReader reader = UserReport.GetListSecureGroup(iUserId)) { while (reader.Read()) { lblUserSecurityLevel.Text += CommonHelper.GetResFileString(reader["GroupName"].ToString()) + "<br/>"; } } using (IDataReader reader = UserReport.GetQuickSnapshotReport(StartDate, EndDate, iUserId)) { if (reader.Read()) { lblPortalLoginsCount.Text = ((int)reader["PortalLogins"]).ToString(); lblUserProjectTotalCreated.Text = ((int)reader["NewProjectsCount"]).ToString(); lblUserIssuesTotalCreated.Text = ((int)reader["NewIncidentsCount"]).ToString(); lblUserToDoTotalCreated.Text = ((int)reader["NewToDosCount"]).ToString(); lblUserTasksTotalCreated.Text = ((int)reader["NewTasksCount"]).ToString(); lblUserCalendarTotalEntriesCreated.Text = ((int)reader["NewEventsCount"]).ToString(); } } 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 = ""; } }