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