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 table. Called when the "Delete table" button is pressed.
/// Expects the CreateReportTable method to be run first.
/// </summary>
private bool DeleteReportTable()
{
// Get the report table
ReportTableInfo deleteTable = ReportTableInfoProvider.GetReportTableInfo("MyNewTable");
// Delete the report table
ReportTableInfoProvider.DeleteReportTableInfo(deleteTable);
return(deleteTable != null);
}
/// <summary>
/// Gets and updates report table. Called when the "Get and update table" button is pressed.
/// Expects the CreateReportTable method to be run first.
/// </summary>
private bool GetAndUpdateReportTable()
{
// Get the report table
ReportTableInfo updateTable = ReportTableInfoProvider.GetReportTableInfo("MyNewTable");
if (updateTable != null)
{
// Update the properties
updateTable.TableDisplayName = updateTable.TableDisplayName.ToLower();
// Save the changes
ReportTableInfoProvider.SetReportTableInfo(updateTable);
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)
{
// Test permission for query
if (!CMSContext.CurrentUser.IsAuthorizedPerResource("CMS.Reporting", "EditSQLQueries"))
{
txtQuery.Enabled = false;
}
else
{
txtQuery.Enabled = true;
}
versionList.OnAfterRollback += new EventHandler(versionList_onAfterRollback);
// Own javascript tab change handling -> because tab control raises changetab after prerender - too late
// Own selected tab change handling
RegisterTabScript(hdnSelectedTab.ClientID, tabControlElem);
// Register common resize and refresh scripts
RegisterResizeAndRollbackScript(divFooter.ClientID, divScrolable.ClientID);
string[,] tabs = new string[4, 4];
tabs[0, 0] = GetString("general.general");
tabs[0, 1] = "SetHelpTopic('helpTopic', 'report_table_properties')";
tabs[1, 0] = GetString("general.preview");
tabs[0, 1] = "SetHelpTopic('helpTopic', 'report_table_properties')";
tabControlElem.Tabs = tabs;
tabControlElem.UsePostback = true;
CurrentMaster.Title.HelpName = "helpTopic";
CurrentMaster.Title.HelpTopicName = "report_table_properties";
CurrentMaster.Title.TitleCssClass = "PageTitleHeader";
rfvCodeName.ErrorMessage = GetString("general.requirescodename");
rfvDisplayName.ErrorMessage = GetString("general.requiresdisplayname");
btnApply.Text = GetString("General.apply");
btnOk.Text = GetString("General.OK");
btnCancel.Text = GetString("General.Cancel");
int reportId = QueryHelper.GetInteger("reportid", 0);
bool preview = QueryHelper.GetBoolean("preview", false);
if (reportId > 0)
{
reportInfo = ReportInfoProvider.GetReportInfo(reportId);
}
// If preview by URL -> select preview tab
bool isPreview = QueryHelper.GetBoolean("preview", false);
if (isPreview && !RequestHelper.IsPostBack())
{
SelectedTab = 1;
}
if (PersistentEditedObject == null)
{
if (reportInfo != null) // Must be valid reportid parameter
{
string tableName = ValidationHelper.GetString(Request.QueryString["itemname"], "");
// Try to load tableName from hidden field (adding new graph & preview)
if (tableName == String.Empty)
{
tableName = txtNewTableHidden.Value;
}
if (ValidationHelper.IsIdentifier(tableName))
{
PersistentEditedObject = ReportTableInfoProvider.GetReportTableInfo(reportInfo.ReportName + "." + tableName);
tableInfo = PersistentEditedObject as ReportTableInfo;
}
}
}
else
{
tableInfo = PersistentEditedObject as ReportTableInfo;
}
if (reportInfo != null)
{
// Control text initializations
if (tableInfo != null)
{
CurrentMaster.Title.TitleText = GetString("Reporting_ReportTable_Edit.TitleText");
CurrentMaster.Title.TitleImage = GetImageUrl("Objects/Reporting_ReportTable/object.png");
tableId = tableInfo.TableID;
if (ObjectVersionManager.DisplayVersionsTab(tableInfo))
{
tabs[2, 0] = GetString("objectversioning.tabtitle");
tabs[2, 1] = "SetHelpTopic('helpTopic', 'objectversioning_general');";
versionList.Object = tableInfo;
versionList.IsLiveSite = false;
}
}
else // New item
{
CurrentMaster.Title.TitleText = GetString("Reporting_ReportTable_Edit.NewItemTitleText");
CurrentMaster.Title.TitleImage = GetImageUrl("Objects/Reporting_ReportTable/new.png");
if (!RequestHelper.IsPostBack())
{
txtPageSize.Text = "15";
txtQueryNoRecordText.Text = GetString("attachmentswebpart.nodatafound");
chkExportEnable.Checked = true;
}
newTable = true;
}
// Set help key
CurrentMaster.Title.HelpTopicName = "report_table_properties";
if (!RequestHelper.IsPostBack())
{
DataHelper.FillListControlWithEnum(typeof(PagerButtons), drpPageMode, "PagerButtons.", null);
// Preselect page numbers paging
drpPageMode.SelectedValue = ((int)PagerButtons.Numeric).ToString();
LoadData();
}
}
if ((preview) && (!RequestHelper.IsPostBack()))
{
tabControlElem.SelectedTab = 1;
ShowPreview();
}
// In case of preview paging without saving table
if (RequestHelper.IsPostBack() && tabControlElem.SelectedTab == 1)
{
// Reload deafult parameters
FormInfo fi = new FormInfo(reportInfo.ReportParameters);
// Get datarow with required columns
ctrlReportTable.ReportParameters = fi.GetDataRow();
fi.LoadDefaultValues(ctrlReportTable.ReportParameters, true);
// Colect data and put them in talbe info
Save(false);
ctrlReportTable.TableInfo = tableInfo;
}
}
/// <summary>
/// Saves data
/// </summary>
/// <returns></returns>
protected bool Save(bool save)
{
string errorMessage = String.Empty;
// Check 'Modify' permission
if (!CMSContext.CurrentUser.IsAuthorizedPerResource("cms.reporting", "Modify"))
{
RedirectToAccessDenied("cms.reporting", "Modify");
}
if (save)
{
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();
ReportTableInfo codeNameCheck = ReportTableInfoProvider.GetReportTableInfo(fullName);
if ((errorMessage == "") && (codeNameCheck != null) && (codeNameCheck.TableID != tableId))
{
errorMessage = GetString("Reporting_ReportTable_Edit.ErrorCodeNameExist");
}
}
// Test query in all cases
if (errorMessage == String.Empty)
{
errorMessage = new Validator().NotEmpty(txtQuery.Text, GetString("Reporting_ReportGraph_Edit.ErrorQuery")).Result;
}
if ((errorMessage == "") && (txtPageSize.Text.Trim() != String.Empty) && (!ValidationHelper.IsInteger(txtPageSize.Text) || !ValidationHelper.IsPositiveNumber(txtPageSize.Text)))
{
errorMessage = GetString("Reporting_ReportTable_Edit.errorinvalidpagesize");
}
if ((errorMessage == ""))
{
// New table
if (tableInfo == null)
{
tableInfo = new ReportTableInfo();
}
tableInfo.TableDisplayName = txtDisplayName.Text.Trim();
tableInfo.TableName = txtCodeName.Text.Trim();
if (CMSContext.CurrentUser.IsAuthorizedPerResource("CMS.Reporting", "EditSQLQueries"))
{
tableInfo.TableQuery = txtQuery.Text.Trim();
}
tableInfo.TableQueryIsStoredProcedure = chkIsProcedure.Checked;
tableInfo.TableReportID = reportInfo.ReportID;
tableInfo.TableSettings["SkinID"] = txtSkinID.Text.Trim();
tableInfo.TableSettings["enablepaging"] = chkEnablePaging.Checked.ToString();
tableInfo.TableSettings["pagesize"] = txtPageSize.Text;
tableInfo.TableSettings["pagemode"] = drpPageMode.SelectedValue;
tableInfo.TableSettings["QueryNoRecordText"] = txtQueryNoRecordText.Text;
tableInfo.TableSettings["ExportEnabled"] = chkExportEnable.Checked.ToString();
if (save)
{
ReportTableInfoProvider.SetReportTableInfo(tableInfo);
}
}
else
{
lblError.Visible = true;
lblError.Text = errorMessage;
return(false);
}
return(true);
}
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;
// Register common resize and refresh scripts
RegisterResizeAndRollbackScript("divFooter", divScrolable.ClientID);
tabControlElem.TabItems.Add(new UITabItem
{
Text = GetString("general.general")
});
tabControlElem.TabItems.Add(new UITabItem
{
Text = GetString("general.preview")
});
tabControlElem.UsePostback = true;
rfvCodeName.ErrorMessage = GetString("general.requirescodename");
rfvDisplayName.ErrorMessage = GetString("general.requiresdisplayname");
Save += (s, ea) =>
{
if (SetData(true))
{
ltlScript.Text += ScriptHelper.GetScript("window.RefreshContent();CloseDialog();");
}
};
int reportId = QueryHelper.GetInteger("reportid", 0);
bool preview = QueryHelper.GetBoolean("preview", false);
if (reportId > 0)
{
mReportInfo = ReportInfoProvider.GetReportInfo(reportId);
}
// If preview by URL -> select preview tab
bool isPreview = QueryHelper.GetBoolean("preview", false);
if (isPreview && !RequestHelper.IsPostBack())
{
tabControlElem.SelectedTab = 1;
}
if (PersistentEditedObject == null)
{
if (mReportInfo != null) // Must be valid reportid parameter
{
int id = QueryHelper.GetInteger("objectid", 0);
// Try to load tableName from hidden field (adding new graph & preview)
if (id == 0)
{
id = ValidationHelper.GetInteger(txtNewTableHidden.Value, 0);
}
if (id > 0)
{
PersistentEditedObject = ReportTableInfoProvider.GetReportTableInfo(id);
mReportTableInfo = PersistentEditedObject as ReportTableInfo;
}
}
}
else
{
mReportTableInfo = PersistentEditedObject as ReportTableInfo;
}
if (mReportInfo != null)
{
ucSelectString.DefaultConnectionString = mReportInfo.ReportConnectionString;
// Control text initializations
if (mReportTableInfo != null)
{
PageTitle.TitleText = GetString("Reporting_ReportTable_Edit.TitleText");
mTableId = mReportTableInfo.TableID;
if (ObjectVersionManager.DisplayVersionsTab(mReportTableInfo))
{
tabControlElem.TabItems.Add(new UITabItem
{
Text = GetString("objectversioning.tabtitle")
});
versionList.Object = mReportTableInfo;
versionList.IsLiveSite = false;
}
}
else // New item
{
PageTitle.TitleText = GetString("Reporting_ReportTable_Edit.NewItemTitleText");
if (!RequestHelper.IsPostBack())
{
ucSelectString.Value = String.Empty;
txtPageSize.Text = "15";
txtQueryNoRecordText.Text = GetString("attachmentswebpart.nodatafound");
chkExportEnable.Checked = true;
chkSubscription.Checked = true;
}
}
if (!RequestHelper.IsPostBack())
{
ControlsHelper.FillListControlWithEnum <PagerButtons>(drpPageMode, "PagerButtons");
// Preselect page numbers paging
drpPageMode.SelectedValue = ((int)PagerButtons.Numeric).ToString();
LoadData();
}
}
if ((preview) && (!RequestHelper.IsPostBack()))
{
tabControlElem.SelectedTab = 1;
ShowPreview();
}
// In case of preview paging without saving table
if (RequestHelper.IsPostBack() && tabControlElem.SelectedTab == 1)
{
// Reload default parameters
FormInfo fi = new FormInfo(mReportInfo.ReportParameters);
// Get datarow with required columns
ctrlReportTable.ReportParameters = fi.GetDataRow(false);
fi.LoadDefaultValues(ctrlReportTable.ReportParameters, true);
// Collect data and put them in table info
SetData();
ctrlReportTable.TableInfo = mReportTableInfo;
}
CurrentMaster.PanelContent.RemoveCssClass("dialog-content");
CurrentMaster.PanelContent.RemoveCssClass("ModalDialogContent");
}