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