/// <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); }
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); }