/// <summary>
        /// Write the <see cref="Iteration"/> data to the workbook as a custom XML part
        /// </summary>
        /// <param name="iteration">
        /// The <see cref="Iteration"/> that is being stored in the workbook
        /// </param>
        private void WriteWorkbookDataToWorkbook(Iteration iteration)
        {
            var workbookData    = new WorkbookData(iteration);
            var workbookDataDal = new WorkbookDataDal(this.workbook);

            workbookDataDal.Write(workbookData);
        }
        public void SetUp()
        {
            this.serviceLocator = new Mock <IServiceLocator>();
            ServiceLocator.SetLocatorProvider(new ServiceLocatorProvider(() => this.serviceLocator.Object));
            this.serviceLocator.Setup(x => x.GetInstance <IMetaDataProvider>()).Returns(new MetaDataProvider());

            var sourcePath = Path.Combine(TestContext.CurrentContext.TestDirectory, @"TestData\test.xlsx");
            var fileinfo   = new FileInfo(sourcePath);

            var targetPath = Path.Combine(TestContext.CurrentContext.TestDirectory, @"TestData\temporarytestfile.xlsx");
            var tempfile   = fileinfo.CopyTo(targetPath, true);

            this.testfilepath = tempfile.FullName;

            this.InstantiateThings();

            this.workbookData = new WorkbookData(this.iteration);
        }
Esempio n. 3
0
        public void VefrifyThatWorkbookDataSerializes()
        {
            string xmlstringpass1 = string.Empty;
            string xmlstringpass2 = string.Empty;

            var settings = new XmlWriterSettings();

            settings.Encoding        = Encoding.UTF8;
            settings.NewLineHandling = NewLineHandling.Entitize;

            var          workbookDataPass1 = new WorkbookData(this.iteration);
            WorkbookData workbookDataPass2;

            using (var writer = new StringWriter())
            {
                var serializer = new XmlSerializer(typeof(WorkbookData));
                serializer.Serialize(writer, workbookDataPass1);
                xmlstringpass1 = writer.ToString();
                Console.WriteLine(xmlstringpass1);
            }

            using (var reader = new StringReader(xmlstringpass1))
            {
                var serializer = new XmlSerializer(typeof(WorkbookData));
                workbookDataPass2 = (WorkbookData)serializer.Deserialize(reader);
            }

            using (var writer = new StringWriter())
            {
                var serializer = new XmlSerializer(typeof(WorkbookData));
                serializer.Serialize(writer, workbookDataPass2);
                xmlstringpass2 = writer.ToString();
                Console.WriteLine(xmlstringpass2);
            }

            xmlstringpass1 = xmlstringpass1.Replace("\r\n", "\n");
            xmlstringpass2 = xmlstringpass2.Replace("\r\n", "\n");

            Assert.AreEqual(xmlstringpass1, xmlstringpass2);
        }