private void SaveReportSet() { var objReportSetController = new ReportSetController(); var obj = new ReportSetConfig(); ReportSetId = objReportSetController.UpdateReportSet(ModuleId, ReportSetId, txtName.Text, cboSkin.SelectedItem.Value, System.Convert.ToInt32(cpConnection.ConnectionId), txtHeader.Text, txtFooter.Text, chkDebug.Checked, txtRunCaption.Text, txtBackCaption.Text, txtParameterLayout.Text, chkAlwaysShowParameters.Checked, ddlRenderMode.SelectedValue, chkAutoRun.Checked, Serialization.SerializeObject(obj, typeof(ReportSetConfig))); }
private void BindDrilldownReport() { var objReportList = default(ArrayList); var objReportSetController = new ReportSetController(); objReportList = objReportSetController.GetReportSetReport(ReportSetId); ddDrilldownReportId.DataValueField = "ReportId"; ddDrilldownReportId.DataTextField = "ReportName"; ddDrilldownReportId.DataSource = objReportList; ddDrilldownReportId.DataBind(); // add the default to the start of the list var li = new ListItem((string)(Localization.GetString("NoDrilldown.Text", LocalResourceFile)), "-1"); ddDrilldownReportId.Items.Insert(0, li); // remove this report if (ReportId > -1) { li = ddDrilldownReportId.Items.FindByValue(ReportId.ToString()); if (li != null) { ddDrilldownReportId.Items.Remove(li); } } }
private void InitReportSet() { // init stack for drilldown if (Session[DrilldownStackKey] == null) { _DrilldownStack = new ArrayListStack(); } else { _DrilldownStack = (ArrayListStack)(Session[DrilldownStackKey]); } var objReportSetController = new ReportSetController(); _ReportSet = objReportSetController.GetReportSetByModule(EffectiveModuleId); if (_ReportSet != null) { if (_ReportSet.ReportSetTheme != "None") { DNNUtilities.InjectCSS(Page, ResolveUrl(string.Format("skins/{0}/styles.css", _ReportSet.ReportSetTheme))); } // get reports _Reports = objReportSetController.GetReportSetReport(ReportSet.ReportSetId); } }
private void InitParameters() { // get report set var objReportSetController = new ReportSetController(); // store parameters _Parameters = objReportSetController.GetReportSetParameter(ReportSet.ReportSetId); }
public void ImportModule(int ModuleID, string Content, string Version, int UserID) { // remove current reportset var ctrl = new ReportSetController(); ctrl.DeleteReportSet(ModuleID); var xmlSqlViewPro = DotNetNuke.Common.Globals.GetContent(Content, "sqlviewpro"); var ReportSetId = ImportReportSet(ModuleID, xmlSqlViewPro); ImportReport(ReportSetId, xmlSqlViewPro); ImportParameter(ReportSetId, xmlSqlViewPro); }
private int ImportReportSet(int ModuleId, XmlNode root) { XmlNode xmlReportSet = root["reportset"]; var ctrl = new ReportSetController(); var reportSetId = default(int); var reportSetName = default(string); var reportSetTheme = default(string); var reportSetConnectionId = default(int); var reportSetConnectionString = default(string); var reportSetFooterText = default(string); var reportSetHeaderText = default(string); var reportSetDebug = default(bool); var runCaption = default(string); var backCaption = default(string); var parameterLayout = default(string); var alwaysShowParameters = default(bool); var renderMode = default(string); var autoRun = default(bool); var reportSetConfig = default(string); reportSetId = -1; reportSetName = xmlReportSet["name"].InnerText; reportSetTheme = xmlReportSet["theme"].InnerText; reportSetConnectionId = Convert.ToInt32(xmlReportSet["connectionid"].InnerText); reportSetConnectionString = xmlReportSet["connectionstring"].InnerText; if (reportSetConnectionId != (int)ConnectionType.PortalDefault) { reportSetConnectionId = ImportConnection("Imported " + DateTime.Now.ToShortDateString(), reportSetConnectionString); } reportSetFooterText = xmlReportSet["footertext"].InnerText; reportSetHeaderText = xmlReportSet["headertext"].InnerText; reportSetDebug = Convert.ToBoolean(xmlReportSet["debug"].InnerText); runCaption = GetNodeInnerText(xmlReportSet, "runcaption"); backCaption = GetNodeInnerText(xmlReportSet, "backcaption"); parameterLayout = GetNodeInnerText(xmlReportSet, "parameterlayout"); alwaysShowParameters = Convert.ToBoolean(GetNodeInnerText(xmlReportSet, "alwaysshowparameters", "false")); renderMode = GetNodeInnerText(xmlReportSet, "rendermode", "default"); autoRun = Convert.ToBoolean(GetNodeInnerText(xmlReportSet, "autoRun", "false")); reportSetConfig = GetNodeInnerText(xmlReportSet, "reportsetconfig", ""); // check if id is already present reportSetId = ctrl.UpdateReportSet(ModuleId, reportSetId, reportSetName, reportSetTheme, reportSetConnectionId, reportSetHeaderText, reportSetFooterText, reportSetDebug, runCaption, backCaption, parameterLayout, alwaysShowParameters, renderMode, autoRun, reportSetConfig); return(reportSetId); }
public static string GetConnectionString(int ConnectionId, int ReportSetId) { switch (ConnectionId) { case (int)ConnectionType.PortalDefault: return(""); case (int)ConnectionType.ReportSetDefault: var rsc = new ReportSetController(); var rsi = rsc.GetReportSet(ReportSetId); return(rsi.ReportSetConnectionString); default: var csi = GetConnection(ConnectionId); return(csi.ConnectionString); } }
private void BindParameter() { Localization.LocalizeDataGrid(ref dgParameter, LocalResourceFile); var objParameterList = default(ArrayList); var objReportSetController = new ReportSetController(); objParameterList = objReportSetController.GetReportSetParameter(ReportSetId); // save parameter count _ParameterCount = objParameterList.Count; // bind dgParameter.DataSource = objParameterList; dgParameter.DataBind(); // commands cmdAddParameter.Visible = ReportSetId > -1; }
private void BindReport() { Localization.LocalizeDataGrid(ref dgReport, LocalResourceFile); var objReportList = default(ArrayList); var objReportSetController = new ReportSetController(); objReportList = objReportSetController.GetReportSetReport(ReportSetId); // save Report count _ReportCount = objReportList.Count; // bind dgReport.DataSource = objReportList; dgReport.DataBind(); // commands cmdAddReport.Visible = ReportSetId > -1; }
private void LoadReportSet() { var objReportSetController = new ReportSetController(); var objReportSet = objReportSetController.GetReportSet(ReportSetId); if (objReportSet == null) { // create new txtName.Text = "New Report Set"; SaveReportSet(); Response.Redirect(NavigateReportSet(ReportSetId)); } txtName.Text = objReportSet.ReportSetName; var item = cboSkin.Items.FindByValue(objReportSet.ReportSetTheme); if (item != null) { item.Selected = true; } else { cboSkin.Items[0].Selected = true; } cpConnection.ConnectionId = objReportSet.ReportSetConnectionId; txtHeader.Text = objReportSet.ReportSetHeaderText; txtFooter.Text = objReportSet.ReportSetFooterText; chkDebug.Checked = objReportSet.ReportSetDebug; txtRunCaption.Text = objReportSet.RunCaption; txtBackCaption.Text = objReportSet.BackCaption; txtParameterLayout.Text = objReportSet.ParameterLayout; chkAlwaysShowParameters.Checked = objReportSet.AlwaysShowParameters; ControlHelpers.InitDropDownByValue(ddlRenderMode, objReportSet.RenderMode); chkAutoRun.Checked = objReportSet.AutoRun; // report grid BindReport(); // parameter grid BindParameter(); }
public string ExportModule(int ModuleID) { var ctrl = new ReportSetController(); var strXML = ""; strXML += "<sqlviewpro>"; var info = ctrl.GetReportSetByModule(ModuleID); strXML += ExportReportSet(info); strXML += ExportReport(info.ReportSetId); strXML += ExportParameter(info.ReportSetId); // close it off strXML += "</sqlviewpro>"; return(strXML); }