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