public ReportCommand ExtractQuery(SharedDatasetRequest request) { var query = ReadQueryFromSharedDataSet(request.Source, request.Path, request.SharedDatasetName); if (query != null) { return(query); } throw new ArgumentException(string.Format("The requested shared dataset ('{1}') wasn't found on path '{0}'.", request.Path, request.SharedDatasetName)); }
public ReportCommand ExtractQuery(SharedDatasetRequest request) { var reportName = request.SharedDatasetName.EndsWith(".rsd") ? request.SharedDatasetName : request.SharedDatasetName + ".rsd"; var fullPath = string.Format("{0}{1}{2}", request.Source, request.Path, reportName); if (!File.Exists(fullPath)) { throw new ArgumentException(string.Format("No shared dataset found on path '{0}{1}' with name '{2}'", request.Source, request.Path, reportName)); } //If the file is found then we need to select the query inside the file var docXml = new XmlDocument(); docXml.Load(fullPath); var root = docXml.FirstChild; if (root.NodeType == XmlNodeType.XmlDeclaration) { root = root.NextSibling; } var xpath = string.Format("//rd:SharedDataSet/rd:DataSet[@Name=\"\"]/rd:Query/rd:CommandText"); var nsmgr = new XmlNamespaceManager(docXml.NameTable); nsmgr.AddNamespace("rd", root.GetNamespaceOfPrefix(string.Empty)); var node = docXml.SelectSingleNode(xpath, nsmgr); if (node != null) { var text = node.InnerText; // We've found the query var reportCommand = new ReportCommand() { Text = text }; xpath = string.Format("//rd:SharedDataSet/rd:DataSet[@Name=\"\"]/rd:Query/rd:CommandType"); node = docXml.SelectSingleNode(xpath, nsmgr); if (node == null) { reportCommand.CommandType = CommandType.Text; } else { reportCommand.CommandType = (CommandType)Enum.Parse(typeof(CommandType), node.InnerText); } return(reportCommand); } throw new ArgumentException(string.Format("Cannot find the command text in the shared dataSet at '{0}'", fullPath)); }
public ReportCommand ExtractQuery(DatasetRequest request) { var reportName = request.ReportName.EndsWith(".rdl") ? request.ReportName : request.ReportName + ".rdl"; var fullPath = string.Format("{0}{1}{2}", request.Source, request.Path, reportName); if (!File.Exists(fullPath)) { throw new ArgumentException(string.Format("No report found on path '{0}{1}' with name '{2}'", request.Source, request.Path, request.ReportName)); } //Load the xml var docXml = new XmlDocument(); docXml.Load(fullPath); var root = docXml.FirstChild; if (root.NodeType == XmlNodeType.XmlDeclaration) { root = root.NextSibling; } //Check that the data set exist var xpath = string.Format("//rd:Report/rd:DataSets/rd:DataSet[@Name=\"{0}\"]", request.DataSetName); //var xpath = "//Report"; var nsmgr = new XmlNamespaceManager(docXml.NameTable); nsmgr.AddNamespace("rd", root.GetNamespaceOfPrefix(string.Empty)); var node = docXml.SelectSingleNode(xpath, nsmgr); if (node == null) { throw BuildDataSetNotFoundException(request, docXml, "//rd:Report/rd:DataSets/rd:DataSet", nsmgr); } //Search in the xml the DataSet and especially the CommandText within this dataset xpath = string.Format("//rd:Report/rd:DataSets/rd:DataSet[@Name=\"{0}\"]/rd:Query/rd:CommandText", request.DataSetName); node = docXml.SelectSingleNode(xpath, nsmgr); if (node != null) { var text = node.InnerText; // Weve fond the query var reportCommand = new ReportCommand() { Text = text }; xpath = string.Format("//rd:Report/rd:DataSets/rd:DataSet[@Name=\"{0}\"]/rd:Query/rd:CommandType", request.DataSetName); node = docXml.SelectSingleNode(xpath, nsmgr); if (node == null) { reportCommand.CommandType = CommandType.Text; } else { reportCommand.CommandType = (CommandType)Enum.Parse(typeof(CommandType), node.InnerText); } return(reportCommand); } //If not found then we'll check if it's not a shared dataset xpath = string.Format("//rd:Report/rd:DataSets/rd:DataSet[@Name=\"{0}\"]/rd:SharedDataSet/rd:SharedDataSetReference", request.DataSetName); node = docXml.SelectSingleNode(xpath, nsmgr); if (node == null) { throw new ArgumentException(string.Format("The data set named '{0}' has been found but no command text or shared dataset reference has been found", request.DataSetName)); } var sharedDataSetName = node.InnerText + ".rsd"; var subRequest = new SharedDatasetRequest ( request.Source, request.Path, sharedDataSetName ); return(ExtractQuery(subRequest)); }