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