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 InitReport() { var objReportController = new ReportController(); var objReport = objReportController.GetReport(ReportId); // load from database if (objReport == null) { Report = new ReportInfo(); } else { Report = objReport; } }
private string ExportReport(int ReportSetId) { var ctrl = new ReportController(); var al = ctrl.ListReport(ReportSetId); var info = default(ReportInfo); var s = "<reports>"; for (var i = 0; i <= al.Count - 1; i++) { info = (ReportInfo)(al[i]); s += "<report>"; s += "<id>" + XmlUtils.XMLEncode(info.ReportId.ToString()) + "</id>"; s += "<reportsetid>" + XmlUtils.XMLEncode(info.ReportSetId.ToString()) + "</reportsetid>"; s += "<name>" + XmlUtils.XMLEncode(info.ReportName) + "</name>"; s += "<theme>" + XmlUtils.XMLEncode(info.ReportTheme) + "</theme>"; s += "<command>" + XmlUtils.XMLEncode(info.ReportCommand) + "</command>"; s += "<reporttype>" + XmlUtils.XMLEncode(info.ReportTypeId.ToString()) + "</reporttype>"; s += "<config>" + XmlUtils.XMLEncode(info.ReportConfig) + "</config>"; s += "<connectionid>" + XmlUtils.XMLEncode(info.ReportConnectionId.ToString()) + "</connectionid>"; s += "<connectionstring>" + XmlUtils.XMLEncode(info.ReportConnectionString.ToString()) + "</connectionstring>"; s += "<footertext>" + XmlUtils.XMLEncode(info.ReportFooterText) + "</footertext>"; s += "<headertext>" + XmlUtils.XMLEncode(info.ReportHeaderText) + "</headertext>"; s += "<order>" + XmlUtils.XMLEncode(info.ReportOrder.ToString()) + "</order>"; s += "<drilldownreportid>" + XmlUtils.XMLEncode(info.ReportDrilldownReportId.ToString()) + "</drilldownreportid>"; s += "<drilldownfieldname>" + XmlUtils.XMLEncode(info.ReportDrilldownFieldname) + "</drilldownfieldname>"; s += "<noitemstext>" + XmlUtils.XMLEncode(info.ReportNoItemsText) + "</noitemstext>"; s += "<pagetitle>" + XmlUtils.XMLEncode(info.ReportPageTitle) + "</pagetitle>"; s += "<cachetimeout>" + XmlUtils.XMLEncode(info.ReportCommandCacheTimeout.ToString()) + "</cachetimeout>"; s += "<metadescription>" + XmlUtils.XMLEncode(info.ReportMetaDescription) + "</metadescription>"; s += "<cachescheme>" + XmlUtils.XMLEncode(info.ReportCommandCacheScheme.ToString()) + "</cachescheme>"; s += "</report>"; } s += "</reports>"; return(s); }
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); } }
private void MoveReport(int ReportId, int Increment) { var objReportController = new ReportController(); objReportController.UpdateReportOrder(ReportId, Increment); }
// report private void DeleteReport(int ReportId) { var objReportController = new ReportController(); objReportController.DeleteReport(ReportId); }