public override void LoadSettings(Dictionary <string, string> VisualizerSettings) { chkPageData.Checked = Convert.ToBoolean( SettingsUtil.GetDictionarySetting(VisualizerSettings, ReportsConstants.SETTING_Grid_EnablePaging, false)); chkSortData.Checked = Convert.ToBoolean( SettingsUtil.GetDictionarySetting(VisualizerSettings, ReportsConstants.SETTING_Grid_EnableSorting, false)); txtPageSize.Text = Convert.ToString( SettingsUtil.GetDictionarySetting(VisualizerSettings, ReportsConstants.SETTING_Grid_PageSize, "10")); chkShowHeader.Checked = Convert.ToBoolean( SettingsUtil.GetDictionarySetting(VisualizerSettings, ReportsConstants.SETTING_Grid_ShowHeader, true)); txtAdditionalCSS.Text = Convert.ToString( SettingsUtil.GetDictionarySetting(VisualizerSettings, ReportsConstants.SETTING_Grid_AdditionalCSS, "")); txtCSSClass.Text = Convert.ToString( SettingsUtil.GetDictionarySetting(VisualizerSettings, ReportsConstants.SETTING_Grid_CSSClass, "")); var gridLines = Convert.ToString(Utilities.GetGridLinesSetting(VisualizerSettings).ToString()); DropDownUtils.TrySetValue(ddlGridLines, Convert.ToString( SettingsUtil.GetDictionarySetting( VisualizerSettings, ReportsConstants.SETTING_Grid_GridLines, ReportsConstants.DEFAULT_Grid_GridLines)), ReportsConstants.DEFAULT_Grid_GridLines); UpdatePageSizeText(); }
public override void LoadSettings(Dictionary <string, string> Settings) { var useConnectionString = Convert.ToBoolean( SettingsUtil.GetDictionarySetting(Settings, ReportsConstants.SETTING_UseConnectionString, false)); this.AutomaticConnStrRadio.Checked = !useConnectionString; this.ManualConnStrRadio.Checked = useConnectionString; this.ConnStrTextBox.Text = Convert.ToString( SettingsUtil.GetDictionarySetting(Settings, ReportsConstants.SETTING_ConnectionString, string.Empty)); this.ServerTextBox.Text = Convert.ToString( SettingsUtil.GetDictionarySetting(Settings, ReportsConstants.SETTING_Server, string.Empty)); this.DatabaseTextBox.Text = Convert.ToString( SettingsUtil.GetDictionarySetting(Settings, ReportsConstants.SETTING_Database, string.Empty)); this.IntegratedSecurityCheckBox.Checked = Convert.ToBoolean( SettingsUtil.GetDictionarySetting(Settings, ReportsConstants.SETTING_Sql_UseIntegratedSecurity, false)); if (!this.IntegratedSecurityCheckBox.Checked) { this.UserNameTextBox.Text = Convert.ToString( SettingsUtil.GetDictionarySetting(Settings, ReportsConstants.SETTING_UserName, string.Empty)); this.PasswordTextBox.Text = Convert.ToString( SettingsUtil.GetDictionarySetting(Settings, ReportsConstants.SETTING_Password, string.Empty)); } this.SqlDataSourceCommonSettingsControl.LoadSettings(Settings); this.UpdateControlVisibility(); }
public override void LoadSettings(Dictionary <string, string> VisualizerSettings) { this.ctlTemplate.Url = Convert.ToString(SettingsUtil.GetDictionarySetting(VisualizerSettings, ReportsConstants.SETTING_Html_TemplateFile, Null.NullString)); this.ctlTemplate.DataBind(); }
protected override DbParameter CreateParameter(string name, object value) { var factory = this.GetProviderFactory(); var paramPrefix = Convert.ToString(SettingsUtil.GetDictionarySetting(this.CurrentReport.DataSourceSettings, ReportsConstants.SETTING_ADO_ParamPrefix, string.Empty)); var param = factory.CreateParameter(); param.ParameterName = string.Concat(paramPrefix, name); param.Value = value; return(param); }
public override void LoadSettings(Dictionary <string, string> VisualizerSettings) { this.ctlTransform.Url = Convert.ToString(SettingsUtil.GetDictionarySetting(VisualizerSettings, ReportsController.SETTING_Xslt_TransformFile, string.Empty)); this.ctlTransform.DataBind(); if (this.ParentModule.UserInfo.IsSuperUser) { this.StoredExtensionObjects = ReportsController.GetXsltExtensionObjects(this.TabModuleId); } }
public override void DataBind() { // Get the report for this module if (!ValidateDataSource() || !ValidateResults()) { pnlContent.Visible = false; } else { pnlContent.Visible = true; var sFileID = Convert.ToString(SettingsUtil.GetDictionarySetting(Report.VisualizerSettings, ReportsConstants.SETTING_Html_TemplateFile, string.Empty)); if (!string.IsNullOrEmpty(sFileID)) { var sFile = Utilities.MapFileIdPath(ParentModule.PortalSettings, sFileID); if (!string.IsNullOrEmpty(sFile)) { var sHtml = File.ReadAllText(sFile); if (!string.IsNullOrEmpty(sHtml)) { // Iterate over each row foreach (DataRow row in ReportResults.Rows) { var rowHtml = sHtml; foreach (DataColumn dcol in ReportResults.Columns) { rowHtml = rowHtml.Replace(string.Format("[{0}]", dcol.ColumnName), Convert.ToString(row[dcol].ToString())); } var objSec = new PortalSecurity(); var divContent = new HtmlGenericControl("div"); divContent.Attributes["class"] = "DNN_Reports_HTML_Item"; divContent.InnerHtml = objSec.InputFilter(rowHtml, PortalSecurity.FilterFlag.NoScripting); // .MultiLine|PortalSecurity.FilterFlag.NoSQL pnlContent.Controls.Add(divContent); } } base.DataBind(); } } } }
private void ConfigureGridFromSettings() { // Load Paging and Sorting data from Visualizer Settings this.grdResults.AllowPaging = Convert.ToBoolean(SettingsUtil.GetDictionarySetting(this.Report.VisualizerSettings, ReportsConstants.SETTING_Grid_EnablePaging, false)); this.grdResults.AllowSorting = Convert.ToBoolean(SettingsUtil.GetDictionarySetting(this.Report.VisualizerSettings, ReportsConstants.SETTING_Grid_EnableSorting, false)); this.grdResults.PageSize = Convert.ToInt32(SettingsUtil.GetDictionarySetting(this.Report.VisualizerSettings, ReportsConstants.SETTING_Grid_PageSize, 10)); this.grdResults.ShowHeader = Convert.ToBoolean(SettingsUtil.GetDictionarySetting(this.Report.VisualizerSettings, ReportsConstants.SETTING_Grid_ShowHeader, true)); this.grdResults.CssClass += Convert.ToString(SettingsUtil.GetDictionarySetting(this.Report.VisualizerSettings, ReportsConstants.SETTING_Grid_CSSClass, "")); var styleString = Convert.ToString(SettingsUtil.GetDictionarySetting(this.Report.VisualizerSettings, ReportsConstants.SETTING_Grid_AdditionalCSS, "")); foreach (var styleEntry in styleString.Split(';')) { var styleArray = styleEntry.Split(':'); if (styleArray.Length != 2) { continue; } this.grdResults.Style.Add(styleArray[0], styleArray[1]); } this.grdResults.GridLines = Utilities.GetGridLinesSetting(this.Report.VisualizerSettings); }
public override void LoadSettings(Dictionary <string, string> Settings) { this.ConnStrTextBox.Text = Convert.ToString( SettingsUtil.GetDictionarySetting(Settings, ReportsController.SETTING_ConnectionString, string.Empty)); this.ParamPrefixTextBox.Text = Convert.ToString( SettingsUtil.GetDictionarySetting(Settings, ReportsController.SETTING_ADO_ParamPrefix, string.Empty)); var provider = Convert.ToString( SettingsUtil.GetDictionarySetting(Settings, ReportsController.SETTING_ADO_ProviderName, string.Empty)); this.EnsureProviderDropDown(); if (this.ProviderNameDropDown.Items.FindByValue(provider) != null) { this.ProviderNameDropDown.SelectedValue = provider; } this.SqlDataSourceCommonSettingsControl.LoadSettings(Settings); }
public override void DataBind() { // Get the report for this module if (!this.ValidateDataSource() || !this.ValidateResults()) { this.litContent.Visible = false; } else { this.litContent.Visible = true; // Get the extension objects IEnumerable <ExtensionObjectInfo> extensionObjects = ReportsController.GetXsltExtensionObjects(this.TabModuleId); var argList = new XsltArgumentList(); foreach (var extensionObject in extensionObjects) { object obj = this.CreateExtensionObject(extensionObject.ClrType); if (obj != null) { argList.AddExtensionObject(extensionObject.XmlNamespace, obj); } } // Get the Xslt Url var sXsl = SettingsUtil.GetDictionarySetting(this.Report.VisualizerSettings, ReportsConstants.SETTING_Xslt_TransformFile, string.Empty); if (string.IsNullOrEmpty(sXsl)) { return; } if (sXsl.ToLower().StartsWith("fileid=")) { sXsl = Utilities.MapFileIdPath(this.ParentModule.PortalSettings, sXsl); } else if (!sXsl.ToLower().StartsWith("http")) { sXsl = Path.Combine(this.ParentModule.PortalSettings.HomeDirectoryMapPath, sXsl.Replace("/", "\\")); } if (string.IsNullOrEmpty(sXsl)) { return; } // Serialize the results to Xml var sbSource = new StringBuilder(); using (var srcWriter = new StringWriter(sbSource)) { this.ReportResults.WriteXml(srcWriter); } // Load the Transform and transform the Xml var sbDest = new StringBuilder(); var xform = new XslCompiledTransform(); using (var destWriter = new XmlTextWriter(new StringWriter(sbDest))) { xform.Load(sXsl); xform.Transform(new XPathDocument(new StringReader(sbSource.ToString())), argList, destWriter); } var objSec = new PortalSecurity(); this.litContent.Text = objSec.InputFilter(sbDest.ToString(), PortalSecurity.FilterFlag.NoScripting); } base.DataBind(); }
protected override string CreateConnectionString() { var connStr = base.CreateConnectionString(); if (!string.IsNullOrEmpty(connStr)) { return(connStr); } // No connection string setting, we need to build it // First validate the fields var server = Convert.ToString( SettingsUtil.GetDictionarySetting(this.CurrentReport.DataSourceSettings, ReportsConstants.SETTING_Server, string.Empty)); var database = Convert.ToString( SettingsUtil.GetDictionarySetting(this.CurrentReport.DataSourceSettings, ReportsConstants.SETTING_Database, string.Empty)); var useIntegratedSecurity = Convert.ToBoolean( SettingsUtil.GetDictionarySetting(this.CurrentReport.DataSourceSettings, ReportsConstants.SETTING_Sql_UseIntegratedSecurity, false)); var userName = Convert.ToString( SettingsUtil.GetDictionarySetting(this.CurrentReport.DataSourceSettings, ReportsConstants.SETTING_UserName, string.Empty)); var password = Convert.ToString( SettingsUtil.GetDictionarySetting(this.CurrentReport.DataSourceSettings, ReportsConstants.SETTING_Password, string.Empty)); var csBuilder = new SqlConnectionStringBuilder(); if (!string.IsNullOrEmpty(server)) { csBuilder.Add("Server", server); } if (!string.IsNullOrEmpty(database)) { csBuilder.Add("Database", database); } if (!useIntegratedSecurity) { if (!string.IsNullOrEmpty(userName)) { csBuilder.Add("User ID", userName); } if (!string.IsNullOrEmpty(password)) { csBuilder.Add("Password", password); } csBuilder.Add("Trusted_Connection", "False"); } else { csBuilder.Add("Trusted_Connection", "True"); } return(csBuilder.ConnectionString); }
public override void LoadSettings(Dictionary <string, string> Settings) { this.QueryTextBox.Text = Convert.ToString( SettingsUtil.GetDictionarySetting(Settings, ReportsConstants.SETTING_Query, Null.NullString)); }