Пример #1
0
        public void WritingDataFromExcelFileSuccess()
        {
            var fixture = new Fixture();

            var testRecords =
                fixture
                .CreateMany <SalesOrdersDataModel>()
                .ToList();

            var data = new List <SalesOrdersDataModel>();

            using (var parser = new TestSalesOrdersDataParser())
            {
                parser
                .Bind("./SampleData.xlsx", true)
                .WriteData(testRecords, RowStyles.Simple, false, "SalesOrders");

                data = parser
                       .Bind("./SampleData.xlsx")
                       .ExtractData("SalesOrders")
                       .Result;
            }

            var orderEqualityComparer = new OrderEqualityComparer();
            var result = testRecords.All(x => data.Contains(x, orderEqualityComparer));

            Assert.True(result);
        }
Пример #2
0
        public void ExtractingDataFromExcelFileSuccess()
        {
            var result = new List <SalesOrdersDataModel>();

            using (var parser = new TestSalesOrdersDataParser())
            {
                result =
                    parser
                    .Bind("./SampleData.xlsx")
                    .ExtractData("SalesOrders")
                    .Result;
            }

            Assert.True(result.Any());
        }