protected void btnAplly_Click(object sender, System.EventArgs e)
{
DateTime StartDate = new DateTime(0);
DateTime EndDate = new DateTime(0);
//SetDates(ddPeriod.Value, out StartDate, out EndDate, txtDateFrom.Text, txtDateTo.Text);
UserReport.GetDates(ddPeriod.Value, out StartDate, out EndDate, dtcStartDate.SelectedDate.ToShortDateString(), dtcEndDate.SelectedDate.ToShortDateString());
pc["GroupAndUserStat_ddPeriod"] = ddPeriod.Value;
if (ddPeriod.Value == "9")
{
pc["GroupAndUserStat_Start"] = StartDate.ToString(culture);
pc["GroupAndUserStat_End"] = EndDate.ToString(culture);
}
if (UserID == 0)
{
BindGroupStat(SGroupID, StartDate, EndDate);
tblGroupStat.Visible = true;
tblUser1.Visible = false;
tblUser2.Visible = false;
tblUser3.Visible = false;
}
else
{
BindUserStat(UserID, StartDate, EndDate);
tblGroupStat.Visible = false;
tblUser1.Visible = true;
tblUser2.Visible = true;
tblUser3.Visible = true;
}
}
private void repTypes_Bound(object sender, System.Web.UI.WebControls.RepeaterItemEventArgs e)
{
int OriginalId = (int)DataBinder.Eval(e.Item.DataItem, "OriginalId");
Repeater repSessions = (Repeater)e.Item.FindControl("repSessions");
Label lblNone = (Label)e.Item.FindControl("lblNone");
if (repSessions != null)
{
DateTime StartDate = DateTime.MinValue;
DateTime EndDate = DateTime.MinValue;
//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());
string sFilter = " " + LocRM.GetString("tGroupName") + ": " + ddContactGroup.SelectedItem.Text;
sFilter += "<br/> " + LocRM.GetString("tPeriod") + ": " + StartDate.ToShortDateString() + " - " + EndDate.ToShortDateString();
_header.Filter = sFilter;
repSessions.DataSource = UserReport.GetListIMSessionsByUserAndDate(OriginalId, StartDate, EndDate);
repSessions.DataBind();
if (repSessions.Items.Count > 0)
{
lblNone.Visible = false;
TotalImSessions += repSessions.Items.Count;
}
else
lblNone.Text = LocRM.GetString("NoneDuring");
}
}
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_Load(object sender, System.EventArgs e)
{
UtilHelper.RegisterCssStyleSheet(Page, "~/Styles/IbnFramework/treeStyle.css");
// Alex Fix
/*
* if(!Security.IsUserInGroup(InternalSecureGroups.Administrator))
* throw new AccessDeniedException();
*/
trLibrary.Visible = false;
trLibrary1.Visible = false;
btnAplly.Text = LocRM.GetString("tShow");
btnExport.Text = LocRM.GetString("tExport");
lblIMStat.Text = String.Format(LocRM.GetString("tIMStatistics"), IbnConst.ProductFamilyShort);
if (!IsPostBack)
{
BindTree();
BindData();
DateTime StartDate = new DateTime(0);
DateTime EndDate = new DateTime(0);
//SetDates(ddPeriod.Value, out StartDate, out EndDate, txtDateFrom.Text, txtDateTo.Text);
UserReport.GetDates(ddPeriod.Value, out StartDate, out EndDate, dtcStartDate.SelectedDate.ToShortDateString(), dtcEndDate.SelectedDate.ToShortDateString());
if (UserID == 0)
{
tblGroupStat.Visible = true;
tblUser1.Visible = false;
tblUser2.Visible = false;
tblUser3.Visible = false;
BindGroupStat(SGroupID, StartDate, EndDate);
}
else
{
tblGroupStat.Visible = false;
tblUser1.Visible = true;
tblUser2.Visible = true;
tblUser3.Visible = true;
if (Mediachase.IBN.Business.User.IsExternal(UserID) || Mediachase.IBN.Business.User.GetUserActivity(UserID) == Mediachase.IBN.Business.User.UserActivity.Pending)
{
trIMGroup.Visible = false;
tblUser2.Visible = false;
}
BindUserStat(UserID, StartDate, EndDate);
}
}
}
protected void btnExport_Click(object sender, System.EventArgs e)
{
DateTime StartDate = new DateTime(0);
DateTime EndDate = new DateTime(0);
//SetDates(ddPeriod.Value, out StartDate, out EndDate, txtDateFrom.Text, txtDateTo.Text);
UserReport.GetDates(ddPeriod.Value, out StartDate, out EndDate, dtcStartDate.SelectedDate.ToShortDateString(), dtcEndDate.SelectedDate.ToShortDateString());
pc["GroupAndUserStat_ddPeriod"] = ddPeriod.Value;
if (ddPeriod.Value == "9")
{
pc["GroupAndUserStat_Start"] = StartDate.ToString(culture);
pc["GroupAndUserStat_End"] = EndDate.ToString(culture);
}
Response.Redirect("~/UserReports/GroupAndUserStat.aspx?Export=1&SGroupID=" + SGroupID.ToString() + "&UserID=" + UserID.ToString());
}
protected void btnAplly_Click(object sender, System.EventArgs e)
{
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["IMStat_ddPeriod"] = ddPeriod.Value;
if (ddPeriod.Value == "9")
{
pc["IMStat_Start"] = StartDate.ToString(culture);
pc["IMStat_End"] = EndDate.ToString(culture);
}
pc["IMStat_ViewBy"] = ddContactGroup.SelectedItem.Value;
GetIMStat();
}
protected void btnApplySelectPeriod_Click(object sender, System.EventArgs e)
{
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["MostActive_ddPeriod"] = ddPeriod.Value;
if (ddPeriod.Value == "9")
{
pc["MostActive_Start"] = StartDate.ToString(culture);
pc["MostActive_End"] = EndDate.ToString(culture);
}
pc["MostActive_ViewBy"] = ddSelectView.SelectedItem.Value;
}
protected void btnExport_Click(object sender, System.EventArgs e)
{
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);
}
/*if(ddPeriod.Value!="9")
* Response.Redirect("~/UserReports/PortalQuickSnapshot.aspx?Export=1&Period="+ddPeriod.Value);
* else
* Response.Redirect("~/UserReports/PortalQuickSnapshot.aspx?Export=1&Start="+fromDate.Text+"&End="+toDate.Text);*/
Response.Redirect("~/UserReports/PortalQuickSnapshot.aspx?Export=1");
}
private void BindTable()
{
DateTime StartDate, EndDate;
//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());
ActivityReportType art = (ActivityReportType)Enum.Parse(typeof(ActivityReportType), ddSelectView.SelectedItem.Value);
DataTable at = null;
switch (rblSelectType.SelectedItem.Value)
{
case "Group":
at = UserReport.GetGroupsActivityTable(StartDate, EndDate, art, topxx);
break;
case "User":
at = UserReport.GetUsersActivityTable(StartDate, EndDate, art, topxx);
break;
case "SecGroup":
switch (art)
{
case ActivityReportType.PortalLogins:
at = UserReport.GetMostActiveGroupsByPortalLoginsReport(StartDate, EndDate, topxx);
break;
case ActivityReportType.ActiveProjects:
at = UserReport.GetMostActiveGroupsByProjectReport(StartDate, EndDate, topxx);
break;
case ActivityReportType.NewIssues:
at = UserReport.GetMostActiveGroupsByIncidentReport(StartDate, EndDate, topxx);
break;
case ActivityReportType.CalendarEntries:
at = UserReport.GetMostActiveGroupsByEventReport(StartDate, EndDate, topxx);
break;
case ActivityReportType.NewTasks:
at = UserReport.GetMostActiveGroupsByTaskReport(StartDate, EndDate, topxx);
break;
case ActivityReportType.NewToDos:
at = UserReport.GetMostActiveGroupsByToDoReport(StartDate, EndDate, topxx);
break;
case ActivityReportType.FilesPublished:
at = UserReport.GetMostActiveGroupsByAssetReport(StartDate, EndDate, topxx);
break;
case ActivityReportType.FileVersionsPublished:
at = UserReport.GetMostActiveGroupsByAssetVersionReport(StartDate, EndDate, topxx);
break;
}
break;
}
if (at.Rows.Count > 0)
{
BuildTable(at);
}
else
{
lblTable.Text = "<td colspan='4'>" + LocRM.GetString("tNoRec") + "</td>";
trLegend.Visible = false;
}
string sFilter = " " + LocRM.GetString("tViewBy") + ": " + ddSelectView.SelectedItem.Text;
if (ddPeriod.Value != "0")
{
sFilter += "<br/> " + LocRM.GetString("tPeriod") + ": " + StartDate.ToShortDateString() + " - " + EndDate.ToShortDateString();
}
_header.Filter = sFilter;
lblRepType.Text = ddSelectView.SelectedItem.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;
}
}
