Ejemplo n.º 1
0
        private ReportingCommand ReadQueryFromSharedDataSet(string source, string path, string reference)
        {
            using (var conn = new SqlConnection())
            {
                //create connection and define sql query
                conn.ConnectionString = source;
                var cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandText = ReadQueryFromContent("QueryFromSharedDataSet");

                //create the two parameters for the sql query
                var paramPath = new SqlParameter("SharedDataSetPath", System.Data.SqlDbType.NVarChar, 425);
                paramPath.Value = path;
                cmd.Parameters.Add(paramPath);


                var paramReference = new SqlParameter("SharedDataSetName", System.Data.SqlDbType.NVarChar, 425);
                paramReference.Value = reference;
                cmd.Parameters.Add(paramReference);

                //execute the command
                conn.Open();
                var dr = cmd.ExecuteReader();


                if (dr.Read())
                {
                    var command = new ReportingCommand();
                    command.CommandType = (CommandType)Enum.Parse(typeof(CommandType), dr.GetString(2)); //CommandType
                    command.Text        = dr.GetString(3);                                               //CommandText
                    return(command);
                }
            }
            return(null);
        }
Ejemplo n.º 2
0
        public ReportingCommand ExtractCommand(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 ReportingCommand()
                {
                    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));
        }
Ejemplo n.º 3
0
        private ReportingCommand SearchDataSet(string source, string reportPath, string reportName, string dataSetName, ref List <string> otherDataSets)
        {
            using (var conn = new SqlConnection())
            {
                //create connection and define sql query
                conn.ConnectionString = source;
                var cmd = new SqlCommand();
                cmd.Connection  = conn;
                cmd.CommandText = ReadQueryFromContent("ListDataSet");

                //create the three parameters for the sql query
                var paramReportPath = new SqlParameter("ReportPath", System.Data.SqlDbType.NVarChar, 425);
                paramReportPath.Value = reportPath;
                cmd.Parameters.Add(paramReportPath);
                var paramReportName = new SqlParameter("ReportName", System.Data.SqlDbType.NVarChar, 425);
                paramReportName.Value = reportName;
                cmd.Parameters.Add(paramReportName);

                //execute the command
                conn.Open();
                var dr = cmd.ExecuteReader();

                while (dr.Read())
                {
                    if (dr.GetString(2) == dataSetName)
                    {
                        var command = new ReportingCommand();
                        command.CommandType = (CommandType)Enum.Parse(typeof(CommandType), dr.GetString(4)); //CommandType
                        command.Text        = dr.GetString(5);                                               //CommandText
                        return(command);
                    }
                    else
                    {
                        otherDataSets.Add(dr.GetString(2));
                    }
                }
            }
            return(null);
        }
Ejemplo n.º 4
0
        public ReportingCommand ExtractCommand(ReportDataSetRequest 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 ReportingCommand()
                {
                    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(ExtractCommand(subRequest));
        }