private void CopyReport(int ReportId)
{
var objReportController = new ReportController();
var objReport = objReportController.GetReport(ReportId);
objReportController.UpdateReport(ReportSetId, -1, objReport.ReportTypeId, "Copy of " + objReport.ReportName, objReport.ReportTheme, objReport.ReportConnectionId, objReport.ReportHeaderText, objReport.ReportFooterText, objReport.ReportCommand, objReport.ReportConfig, -1, objReport.ReportDrilldownReportId, objReport.ReportDrilldownFieldname, objReport.ReportNoItemsText, objReport.ReportPageTitle, objReport.ReportCommandCacheTimeout, objReport.ReportMetaDescription, objReport.ReportCommandCacheScheme);
}
private void SaveReport()
{
RetrieveReportSettings();
var objReportController = new ReportController();
ReportId = objReportController.UpdateReport(ReportSetId, ReportId, ddReportType.SelectedValue, txtName.Text, cboSkin.SelectedItem.Value, Convert.ToInt32(cpConnection.ConnectionId), txtHeader.Text, txtFooter.Text, txtQuery.Text, ReportConfig, -1, Convert.ToInt32(ddDrilldownReportId.SelectedValue), txtDrilldownFieldname.Text, txtNoItems.Text, txtPageTitle.Text, Convert.ToInt32(txtCommandCacheTimeout.Text), txtMetaDescription.Text, ddCommandCacheScheme.SelectedValue);
}
private void ImportReport(int ReportSetId, XmlNode root)
{
XmlNode xmlReports = root["reports"];
var ctrl = new ReportController();
var reportId = default(int);
var reportTypeId = default(string);
var reportName = default(string);
var reportTheme = default(string);
var reportConnectionId = default(int);
var reportConnectionString = default(string);
var reportFooterText = default(string);
var reportHeaderText = default(string);
var reportCommand = default(string);
var reportConfig = default(string);
var reportOrder = default(int);
var reportDrilldownReportId = default(int);
var reportDrilldownFieldname = default(string);
var reportNoItemsText = default(string);
var reportPageTitle = default(string);
var reportCommandCacheTimeout = default(int);
var reportMapping = new Hashtable(); //map old reportid to new ones for drilldown reference
foreach (XmlNode xmlReport in xmlReports.ChildNodes)
{
reportId = Convert.ToInt32(xmlReport["id"].InnerText);
reportTypeId = xmlReport["reporttype"].InnerText;
reportName = xmlReport["name"].InnerText;
reportTheme = xmlReport["theme"].InnerText;
reportConnectionId = Convert.ToInt32(xmlReport["connectionid"].InnerText);
reportConnectionString = xmlReport["connectionstring"].InnerText;
if (reportConnectionId != (int)ConnectionType.PortalDefault & reportConnectionId != (int)ConnectionType.ReportSetDefault)
{
reportConnectionId = ImportConnection("Imported " + DateTime.Now.ToShortDateString(), reportConnectionString);
}
reportFooterText = xmlReport["footertext"].InnerText;
reportHeaderText = xmlReport["headertext"].InnerText;
reportCommand = xmlReport["command"].InnerText;
reportConfig = xmlReport["config"].InnerText;
reportOrder = Convert.ToInt32(xmlReport["order"].InnerText);
reportDrilldownReportId = Convert.ToInt32(xmlReport["drilldownreportid"].InnerText);
if (reportDrilldownReportId > -1)
{
if (reportMapping.ContainsKey(reportDrilldownReportId))
{
reportDrilldownReportId = Convert.ToInt32(reportMapping[reportDrilldownReportId]);
}
}
reportDrilldownFieldname = xmlReport["drilldownfieldname"].InnerText;
reportNoItemsText = GetNodeInnerText(xmlReport, "noitemstext");
reportPageTitle = GetNodeInnerText(xmlReport, "pagetitle");
reportCommandCacheTimeout = int.Parse(GetNodeInnerText(xmlReport, "cachetimeout", "0"));
var reportMetaDescription = GetNodeInnerText(xmlReport, "metadescription");
var reportCommandCacheScheme = GetNodeInnerText(xmlReport, "cachescheme", "Sliding");
// check if id is already present
var newid = ctrl.UpdateReport(ReportSetId, -1, reportTypeId, reportName, reportTheme, reportConnectionId, reportHeaderText, reportFooterText, reportCommand, reportConfig, reportOrder, reportDrilldownReportId, reportDrilldownFieldname, reportNoItemsText, reportPageTitle, reportCommandCacheTimeout, reportMetaDescription, reportCommandCacheScheme);
reportMapping.Add(reportId, newid);
}
}