private bool InsertElementsToLayout() { // Get report object by report code name ReportInfo report = ReportInfoProvider.GetReportInfo("MyNewReport"); // If report exists if (report != null) { ReportGraphInfo graph = ReportGraphInfoProvider.GetReportGraphInfo("MyNewGraph"); if (graph != null) { report.ReportLayout += "<br/>%%control:Report" + ReportItemType.Graph + "?" + report.ReportName + "." + graph.GraphName + "%%<br/>"; } ReportTableInfo table = ReportTableInfoProvider.GetReportTableInfo("MyNewTable"); if (table != null) { report.ReportLayout += "<br/>%%control:Report" + ReportItemType.Table + "?" + report.ReportName + "." + table.TableName + "%%<br/>"; } ReportValueInfo value = ReportValueInfoProvider.GetReportValueInfo("MyNewValue"); if (value != null) { report.ReportLayout += "<br/>%%control:Report" + ReportItemType.Value + "?" + report.ReportName + "." + value.ValueName + "%%<br/>"; } ReportInfoProvider.SetReportInfo(report); return(true); } return(false); }
/// <summary> /// Deletes report value. Called when the "Delete value" button is pressed. /// Expects the CreateReportValue method to be run first. /// </summary> private bool DeleteReportValue() { // Get the report value ReportValueInfo deleteValue = ReportValueInfoProvider.GetReportValueInfo("MyNewValue"); // Delete the report value ReportValueInfoProvider.DeleteReportValueInfo(deleteValue); return(deleteValue != null); }
/// <summary> /// Gets and updates report value. Called when the "Get and update value" button is pressed. /// Expects the CreateReportValue method to be run first. /// </summary> private bool GetAndUpdateReportValue() { // Get the report value ReportValueInfo updateValue = ReportValueInfoProvider.GetReportValueInfo("MyNewValue"); if (updateValue != null) { // Update the properties updateValue.ValueDisplayName = updateValue.ValueDisplayName.ToLower(); // Save the changes ReportValueInfoProvider.SetReportValueInfo(updateValue); return(true); } return(false); }
protected void btnHdnDelete_Click(object sender, EventArgs e) { // Check 'Modify' permission if (!CMSContext.CurrentUser.IsAuthorizedPerResource("cms.reporting", "Modify")) { CMSReportingPage.RedirectToCMSDeskAccessDenied("cms.reporting", "Modify"); } string itemName = ""; if (hdnItemId.Value != "") { itemName = Report.ReportName + "." + ValidationHelper.GetString(hdnItemId.Value, ""); if ((mItemType == ReportItemType.Graph) || (mItemType == ReportItemType.HtmlGraph)) { ReportGraphInfo rgi = ReportGraphInfoProvider.GetReportGraphInfo(itemName); if (rgi != null) { ReportGraphInfoProvider.DeleteReportGraphInfo(rgi.GraphID); } } else if (mItemType == ReportItemType.Table) { ReportTableInfo rti = ReportTableInfoProvider.GetReportTableInfo(itemName); if (rti != null) { ReportTableInfoProvider.DeleteReportTableInfo(rti.TableID); } } else if (mItemType == ReportItemType.Value) { ReportValueInfo rvi = ReportValueInfoProvider.GetReportValueInfo(itemName); if (rvi != null) { ReportValueInfoProvider.DeleteReportValueInfo(rvi.ValueID); } } } }
public static string GetReportItemName(string type, int id) { // Switch by type switch (ReportInfoProvider.StringToReportItemType(type)) { // Graph case ReportItemType.Graph: case ReportItemType.HtmlGraph: ReportGraphInfo rgi = ReportGraphInfoProvider.GetReportGraphInfo(id); if (rgi != null) { return(rgi.GraphName); } break; // Table case ReportItemType.Table: ReportTableInfo rti = ReportTableInfoProvider.GetReportTableInfo(id); if (rti != null) { return(rti.TableName); } break; // Value case ReportItemType.Value: ReportValueInfo rvi = ReportValueInfoProvider.GetReportValueInfo(id); if (rvi != null) { return(rvi.ValueName); } break; } return(String.Empty); }
protected void Page_Load(object sender, EventArgs e) { ucSelectString.Scope = ReportInfo.OBJECT_TYPE; ConnectionStringRow.Visible = MembershipContext.AuthenticatedUser.IsAuthorizedPerResource("cms.reporting", "SetConnectionString"); txtQuery.FullScreenParentElementID = pnlWebPartForm_Properties.ClientID; // Test permission for query txtQuery.Enabled = MembershipContext.AuthenticatedUser.IsAuthorizedPerResource("CMS.Reporting", "EditSQLQueries"); versionList.OnAfterRollback += versionList_onAfterRollback; PageTitle.HelpTopicName = HELP_TOPIC_LINK; tabControlElem.TabItems.Add(new UITabItem { Text = GetString("general.general") }); tabControlElem.TabItems.Add(new UITabItem { Text = GetString("general.preview") }); tabControlElem.UsePostback = true; RegisterResizeAndRollbackScript("divFooter", divScrolable.ClientID); rfvCodeName.ErrorMessage = GetString("general.requirescodename"); rfvDisplayName.ErrorMessage = GetString("general.requiresdisplayname"); int reportId = QueryHelper.GetInteger("reportid", 0); bool preview = QueryHelper.GetBoolean("preview", false); if (reportId > 0) { mReportInfo = ReportInfoProvider.GetReportInfo(reportId); } if (mReportInfo != null) //must be valid reportid parameter { ucSelectString.DefaultConnectionString = mReportInfo.ReportConnectionString; // If preview by URL -> select preview tab bool isPreview = QueryHelper.GetBoolean("preview", false); if (isPreview && !RequestHelper.IsPostBack()) { tabControlElem.SelectedTab = 1; } if (PersistentEditedObject == null) { int id = QueryHelper.GetInteger("objectid", 0); if (id > 0) { PersistentEditedObject = ReportValueInfoProvider.GetReportValueInfo(id); mReportValueInfo = PersistentEditedObject as ReportValueInfo; } } else { mReportValueInfo = PersistentEditedObject as ReportValueInfo; } if (mReportValueInfo != null) { PageTitle.TitleText = GetString("Reporting_ReportValue_Edit.TitleText"); mValueId = mReportValueInfo.ValueID; if (ObjectVersionManager.DisplayVersionsTab(mReportValueInfo)) { tabControlElem.TabItems.Add(new UITabItem { Text = GetString("objectversioning.tabtitle") }); versionList.Object = mReportValueInfo; versionList.IsLiveSite = false; } } else //new item { PageTitle.TitleText = GetString("Reporting_ReportValue_Edit.NewItemTitleText"); chkSubscription.Checked = true; if (!RequestHelper.IsPostBack()) { ucSelectString.Value = String.Empty; } } if (!RequestHelper.IsPostBack()) { LoadData(); } } else { ShowError(GetString("Reporting_ReportValue_Edit.InvalidReportId")); } Save += (s, ea) => { if (SetData(true)) { ltlScript.Text += ScriptHelper.GetScript("window.RefreshContent();CloseDialog();"); } }; if (preview && !RequestHelper.IsPostBack()) { tabControlElem.SelectedTab = 1; ShowPreview(); } CurrentMaster.PanelContent.RemoveCssClass("dialog-content"); CurrentMaster.PanelContent.RemoveCssClass("ModalDialogContent"); }
/// <summary> /// Save data. /// </summary> /// <param name="saveToDatabase">If true, data are saved into database</param> private bool SetData(bool saveToDatabase = false) { string errorMessage = String.Empty; if (saveToDatabase) { // Check 'Modify' permission if (!MembershipContext.AuthenticatedUser.IsAuthorizedPerResource("cms.reporting", "Modify")) { RedirectToAccessDenied("cms.reporting", "Modify"); } errorMessage = new Validator() .NotEmpty(txtDisplayName.Text, rfvDisplayName.ErrorMessage) .NotEmpty(txtCodeName.Text, rfvCodeName.ErrorMessage) .NotEmpty(txtQuery.Text, GetString("Reporting_ReportGraph_Edit.ErrorQuery")).Result; if ((errorMessage == "") && (!ValidationHelper.IsIdentifier(txtCodeName.Text.Trim()))) { errorMessage = GetString("general.erroridentifierformat"); } string fullName = mReportInfo.ReportName + "." + txtCodeName.Text.Trim(); ReportValueInfo codeNameCheck = ReportValueInfoProvider.GetReportValueInfo(fullName); if ((errorMessage == "") && (codeNameCheck != null) && (codeNameCheck.ValueID != mValueId)) { errorMessage = GetString("Reporting_ReportValue_Edit.ErrorCodeNameExist"); } } //test query in all cases if (!saveToDatabase) { errorMessage = new Validator().NotEmpty(txtQuery.Text, GetString("Reporting_ReportGraph_Edit.ErrorQuery")).Result; } if ((errorMessage == "")) { //new Value if (mReportValueInfo == null) { mReportValueInfo = new ReportValueInfo(); } mReportValueInfo.ValueDisplayName = txtDisplayName.Text.Trim(); mReportValueInfo.ValueName = txtCodeName.Text.Trim(); if (MembershipContext.AuthenticatedUser.IsAuthorizedPerResource("CMS.Reporting", "EditSQLQueries")) { mReportValueInfo.ValueQuery = txtQuery.Text.Trim(); } mReportValueInfo.ValueQueryIsStoredProcedure = chkIsProcedure.Checked; mReportValueInfo.ValueFormatString = txtFormatString.Text.Trim(); mReportValueInfo.ValueReportID = mReportInfo.ReportID; mReportValueInfo.ValueSettings["SubscriptionEnabled"] = chkSubscription.Checked.ToString(); mReportValueInfo.ValueConnectionString = ValidationHelper.GetString(ucSelectString.Value, String.Empty); if (saveToDatabase) { ReportValueInfoProvider.SetReportValueInfo(mReportValueInfo); } } else { ShowError(errorMessage); return(false); } return(true); }
protected void Page_Load(object sender, EventArgs e) { ucSelectString.Scope = PredefinedObjectType.REPORT; ConnectionStringRow.Visible = CMSContext.CurrentUser.IsAuthorizedPerResource("cms.reporting", "SetConnectionString"); txtQuery.FullScreenParentElementID = pnlWebPartForm_Properties.ClientID; // Test permission for query if (!CMSContext.CurrentUser.IsAuthorizedPerResource("CMS.Reporting", "EditSQLQueries")) { txtQuery.Enabled = false; } else { txtQuery.Enabled = true; } versionList.OnAfterRollback += new EventHandler(versionList_onAfterRollback); string[,] tabs = new string[4, 4]; tabs[0, 0] = GetString("general.general"); tabs[0, 1] = "SetHelpTopic('helpTopic', 'report_value_properties')"; tabs[1, 0] = GetString("general.preview"); tabs[0, 1] = "SetHelpTopic('helpTopic', 'report_value_properties')"; tabControlElem.Tabs = tabs; tabControlElem.UsePostback = true; CurrentMaster.Title.HelpName = "helpTopic"; CurrentMaster.Title.HelpTopicName = "report_value_properties"; CurrentMaster.Title.TitleCssClass = "PageTitleHeader"; // Own javascript tab change handling -> because tab control raises changetab after prerender - too late // Own selected tab change handling RegisterTabScript(hdnSelectedTab.ClientID, tabControlElem); RegisterResizeAndRollbackScript(divFooter.ClientID, divScrolable.ClientID); rfvCodeName.ErrorMessage = GetString("general.requirescodename"); rfvDisplayName.ErrorMessage = GetString("general.requiresdisplayname"); int reportId = QueryHelper.GetInteger("reportid", 0); bool preview = QueryHelper.GetBoolean("preview", false); if (reportId > 0) { reportInfo = ReportInfoProvider.GetReportInfo(reportId); } if (reportInfo != null) //must be valid reportid parameter { ucSelectString.DefaultConnectionString = reportInfo.ReportConnectionString; // If preview by URL -> select preview tab bool isPreview = QueryHelper.GetBoolean("preview", false); if (isPreview && !RequestHelper.IsPostBack()) { SelectedTab = 1; } if (PersistentEditedObject == null) { int id = QueryHelper.GetInteger("itemid", 0); if (id > 0) { PersistentEditedObject = ReportValueInfoProvider.GetReportValueInfo(id); valueInfo = PersistentEditedObject as ReportValueInfo; } } else { valueInfo = PersistentEditedObject as ReportValueInfo; } if (valueInfo != null) { CurrentMaster.Title.TitleText = GetString("Reporting_ReportValue_Edit.TitleText"); CurrentMaster.Title.TitleImage = GetImageUrl("Objects/Reporting_ReportValue/object_light.png"); valueId = valueInfo.ValueID; if (ObjectVersionManager.DisplayVersionsTab(valueInfo)) { tabs[2, 0] = GetString("objectversioning.tabtitle"); tabs[2, 1] = "SetHelpTopic('helpTopic', 'objectversioning_general');"; versionList.Object = valueInfo; versionList.IsLiveSite = false; } } else //new item { CurrentMaster.Title.TitleText = GetString("Reporting_ReportValue_Edit.NewItemTitleText"); CurrentMaster.Title.TitleImage = GetImageUrl("Objects/Reporting_ReportValue/new_light.png"); chkSubscription.Checked = true; newValue = true; if (!RequestHelper.IsPostBack()) { ucSelectString.Value = String.Empty; } } // set help key CurrentMaster.Title.HelpTopicName = "report_value_properties"; if (!RequestHelper.IsPostBack()) { LoadData(); } } else { btnOk.Visible = false; ShowError(GetString("Reporting_ReportValue_Edit.InvalidReportId")); } btnOk.Text = GetString("General.OK"); btnCancel.Text = GetString("General.Cancel"); btnApply.Text = GetString("General.Apply"); if (preview && !RequestHelper.IsPostBack()) { tabControlElem.SelectedTab = 1; ShowPreview(); } }
/// <summary> /// Save data. /// </summary> /// <returns>return true if save was successfull</returns> protected bool Save(bool save) { string errorMessage = String.Empty; if (save) { // Check 'Modify' permission if (!CMSContext.CurrentUser.IsAuthorizedPerResource("cms.reporting", "Modify")) { RedirectToAccessDenied("cms.reporting", "Modify"); } errorMessage = new Validator() .NotEmpty(txtDisplayName.Text, rfvDisplayName.ErrorMessage) .NotEmpty(txtCodeName.Text, rfvCodeName.ErrorMessage) .NotEmpty(txtQuery.Text, GetString("Reporting_ReportGraph_Edit.ErrorQuery")).Result; if ((errorMessage == "") && (!ValidationHelper.IsIdentifier(txtCodeName.Text.Trim()))) { errorMessage = GetString("general.erroridentificatorformat"); } string fullName = reportInfo.ReportName + "." + txtCodeName.Text.Trim(); ReportValueInfo codeNameCheck = ReportValueInfoProvider.GetReportValueInfo(fullName); if ((errorMessage == "") && (codeNameCheck != null) && (codeNameCheck.ValueID != valueId)) { errorMessage = GetString("Reporting_ReportValue_Edit.ErrorCodeNameExist"); } } //test query in all cases if (!save) { errorMessage = new Validator().NotEmpty(txtQuery.Text, GetString("Reporting_ReportGraph_Edit.ErrorQuery")).Result; } if ((errorMessage == "")) { //new Value if (valueInfo == null) { valueInfo = new ReportValueInfo(); } valueInfo.ValueDisplayName = txtDisplayName.Text.Trim(); valueInfo.ValueName = txtCodeName.Text.Trim(); if (CMSContext.CurrentUser.IsAuthorizedPerResource("CMS.Reporting", "EditSQLQueries")) { valueInfo.ValueQuery = txtQuery.Text.Trim(); } valueInfo.ValueQueryIsStoredProcedure = chkIsProcedure.Checked; valueInfo.ValueFormatString = txtFormatString.Text.Trim(); valueInfo.ValueReportID = reportInfo.ReportID; if (save) { ReportValueInfoProvider.SetReportValueInfo(valueInfo); } } else { lblError.Visible = true; lblError.Text = errorMessage; return(false); } return(true); }
protected void Page_Load(object sender, EventArgs e) { // Test permission for query if (!CMSContext.CurrentUser.IsAuthorizedPerResource("CMS.Reporting", "EditSQLQueries")) { txtQuery.Enabled = false; } else { txtQuery.Enabled = true; } versionList.OnAfterRollback += new EventHandler(versionList_onAfterRollback); string[,] tabs = new string[4, 4]; tabs[0, 0] = GetString("general.general"); tabs[0, 1] = "SetHelpTopic('helpTopic', 'report_value_properties')"; tabs[1, 0] = GetString("general.preview"); tabs[0, 1] = "SetHelpTopic('helpTopic', 'report_value_properties')"; tabControlElem.Tabs = tabs; tabControlElem.UsePostback = true; CurrentMaster.Title.HelpName = "helpTopic"; CurrentMaster.Title.HelpTopicName = "report_value_properties"; CurrentMaster.Title.TitleCssClass = "PageTitleHeader"; RegisterResizeAndRollbackScript(divFooter.ClientID, divScrolable.ClientID); rfvCodeName.ErrorMessage = GetString("general.requirescodename"); rfvDisplayName.ErrorMessage = GetString("general.requiresdisplayname"); int reportId = QueryHelper.GetInteger("reportid", 0); bool preview = QueryHelper.GetBoolean("preview", false); if (reportId > 0) { reportInfo = ReportInfoProvider.GetReportInfo(reportId); } if (reportInfo != null) //must be valid reportid parameter { if (PersistentEditedObject == null) { string valueName = ValidationHelper.GetString(Request.QueryString["itemname"], ""); if (ValidationHelper.IsIdentifier(valueName)) { PersistentEditedObject = ReportValueInfoProvider.GetReportValueInfo(reportInfo.ReportName + "." + valueName); valueInfo = PersistentEditedObject as ReportValueInfo; } } else { valueInfo = PersistentEditedObject as ReportValueInfo; } if (valueInfo != null) { CurrentMaster.Title.TitleText = GetString("Reporting_ReportValue_Edit.TitleText"); CurrentMaster.Title.TitleImage = GetImageUrl("Objects/Reporting_ReportValue/object.png"); valueId = valueInfo.ValueID; if (ObjectVersionManager.DisplayVersionsTab(valueInfo)) { tabs[2, 0] = GetString("objectversioning.tabtitle"); tabs[2, 1] = "SetHelpTopic('helpTopic', 'objectversioning_general');"; versionList.Object = valueInfo; versionList.IsLiveSite = false; } } else //new item { CurrentMaster.Title.TitleText = GetString("Reporting_ReportValue_Edit.NewItemTitleText"); CurrentMaster.Title.TitleImage = GetImageUrl("Objects/Reporting_ReportValue/new.png"); newValue = true; } // set help key CurrentMaster.Title.HelpTopicName = "report_value_properties"; if (!RequestHelper.IsPostBack()) { LoadData(); } } else { btnOk.Visible = false; lblError.Visible = true; lblError.Text = GetString("Reporting_ReportValue_Edit.InvalidReportId"); } btnOk.Text = GetString("General.OK"); btnCancel.Text = GetString("General.Cancel"); btnApply.Text = GetString("General.Apply"); if (preview) { tabControlElem.SelectedTab = 1; ShowPreview(); } }