コード例 #1
0
ファイル: MainForm.cs プロジェクト: 5l1v3r1/fogbugz-pivot
        private void GenerateButtonClick(object sender, EventArgs e)
        {
            var selectedFilter = FiltersComboBox.SelectedItem as FilterComboItem;

            if (selectedFilter == null)
            {
                return;
            }

            if (string.IsNullOrEmpty(SaveToTextBox.Text))
            {
                SaveToTextBox.Focus();

                return;
            }

            SetBusy("Generating Pivot report...");

            var facets = new FacetCollection();

            foreach (var facet in FacetsListBox.CheckedItems.Cast <Facet>())
            {
                facets.Add(facet);
            }

            if (!Directory.Exists(SaveToTextBox.Text))
            {
                Directory.CreateDirectory(SaveToTextBox.Text);
            }

            CopyDirectory(Path.GetFullPath(".\\pivot_files"), Path.Combine(SaveToTextBox.Text, ".\\pivot_files"));

            var path = Path.Combine(SaveToTextBox.Text, "pivot.cxml");

            Task.Factory.StartNew(() =>
            {
                // You need to set current filter first
                var setFilterDocument = GetCommandResultsAsDocument(
                    "setCurrentFilter",
                    new Dictionary <string, string> {
                    { "sFilter", selectedFilter.Id }
                });

                if (HasResponseError(setFilterDocument))
                {
                    return;
                }

                var cols = string.Join(",", facets.Select(f => f.Name).Where(f => f != "ixBug"));

                using (var stream = GetCommandResultsAsStream("search", new Dictionary <string, string> {
                    { "cols", cols }
                }))
                {
                    GeneratePivotReport(stream, facets, path, selectedFilter.Name);
                }
            }).ContinueWith(task =>
            {
                SetAvailable();

                if (HasTaskException(task))
                {
                    return;
                }
            }, TaskScheduler.FromCurrentSynchronizationContext());
        }
コード例 #2
0
ファイル: MainForm.cs プロジェクト: 5l1v3r1/fogbugz-pivot
        private static void GeneratePivotReport(Stream stream, FacetCollection facets, string path, string collectionName)
        {
            using (var reader = XmlReader.Create(stream))
                using (var writer = new XmlTextWriter(path, Encoding.UTF8))
                {
                    reader.Read();
                    reader.ReadStartElement("response");
                    reader.ReadElementContentAsString("description", string.Empty);

                    if ("sFilter".Equals(reader.Name))
                    {
                        reader.ReadElementContentAsString("sFilter", string.Empty);
                    }

                    reader.ReadStartElement("cases");

                    writer.Formatting = Formatting.Indented;
                    writer.WriteStartDocument();
                    writer.WriteStartElement("Collection", "http://schemas.microsoft.com/collection/metadata/2009");
                    writer.WriteAttributeString("xmlns", "p", null, "http://schemas.microsoft.com/livelabs/pivot/collection/2009");
                    writer.WriteAttributeString("SchemaVersion", "1.0");
                    writer.WriteAttributeString("Name", collectionName);

                    writer.WriteStartElement("FacetCategories");

                    foreach (var facet in facets)
                    {
                        writer.WriteStartElement("FacetCategory");
                        writer.WriteAttributeString("Name", facet.DisplayName);
                        writer.WriteAttributeString("Type", facet.Type);
                        writer.WriteAttributeString("IsFilterVisible", "http://schemas.microsoft.com/livelabs/pivot/collection/2009", facet.IsFilter ? "true" : "false");
                        writer.WriteAttributeString("IsWordWheelVisible", "http://schemas.microsoft.com/livelabs/pivot/collection/2009", "true");
                        writer.WriteAttributeString("IsMetaDataVisible", "http://schemas.microsoft.com/livelabs/pivot/collection/2009", "true");

                        writer.WriteEndElement();                 // FacetCategory
                    }

                    writer.WriteEndElement();             // FacetCategories

                    writer.WriteStartElement("Items");

                    writer.WriteAttributeString("ImgBase", ".\\pivot_files\\images.xml");

                    while (reader.Name == "case")
                    {
                        var id = reader.GetAttribute("ixBug");

                        reader.ReadStartElement("case");

                        writer.WriteStartElement("Item");

                        writer.WriteAttributeString("Id", id);
                        writer.WriteAttributeString("Img", "#0");

                        var properties = new Dictionary <string, string>
                        {
                            { "ixBug", id },
                        };

                        while (reader.NodeType != XmlNodeType.EndElement)
                        {
                            var name    = reader.Name;
                            var content = reader.ReadElementContentAsString(name, string.Empty);

                            properties.Add(name, content);
                        }

                        if (properties.ContainsKey("sTitle"))
                        {
                            writer.WriteElementString("Description", properties["sTitle"]);
                        }

                        writer.WriteStartElement("Facets");

                        foreach (var facet in facets)
                        {
                            facet.WriteTo(writer, properties[facet.Name]);
                        }

                        writer.WriteEndElement();                // Facets

                        writer.WriteEndElement();                // Item

                        reader.ReadEndElement();                 // case
                    }

                    writer.WriteEndElement();            // Items

                    reader.ReadEndElement();             // cases
                    reader.ReadEndElement();             // response
                }
        }