public void FormulaResultMappedTest() { var excel = new ExcelMapper(@"..\..\..\ProductsAsString.xlsx"); excel.AddMapping <ProductFormulaMapped>("Value", p => p.Result); excel.AddMapping <ProductFormulaMapped>("ValueDefaultAsFormula", p => p.Formula); excel.AddMapping <ProductFormulaMapped>("ValueAsString", p => p.ResultString).AsFormulaResult(); var products = excel.Fetch <ProductFormulaMapped>().ToList(); var expectedProducts = new List <ProductFormulaMapped> { new ProductFormulaMapped { Result = 119.4m, Formula = "C2*D2", ResultString = "119.4" }, new ProductFormulaMapped { Result = 98.67m, Formula = "C3*D3", ResultString = "98.67" }, new ProductFormulaMapped { Result = 99m, Formula = "C5*D5", ResultString = "99" }, }; Assert.AreEqual(expectedProducts[0], products[0]); CollectionAssert.AreEqual(expectedProducts, products); }
private void MapTimeSummaryEvent(ExcelMapper mapper) { mapper.AddMapping <TimeSummaryEvent>(tsc.EventHeaderName, x => x.EventType) .SetPropertyUsing(v => tsc.ParseEventType(v as string)); mapper.AddMapping <TimeSummaryEvent>(tsc.ProjectHeaderName, x => x.ProjectType) .SetPropertyUsing(v => tsc.ParseProjectType(v as string)); mapper.AddMapping <TimeSummaryEvent>(tsc.CreatedAtHeaderName, x => x.CreatedAt) .SetPropertyUsing(x => tsc.ConvertToDate(x)); }
public void GetterSetterTest() { var excel = new ExcelMapper(@"..\..\..\productsconvert.xlsx") { TrackObjects = true }; excel.AddMapping <GetterSetterProduct>("Name", p => p.Name); excel.AddMapping <GetterSetterProduct>("OfferEnd", p => p.OfferEnd) .SetCellUsing((c, o) => { if (o == null) { c.SetCellValue("NULL"); } else { c.SetCellValue((DateTime)o); } }) .SetPropertyUsing(v => { if ((v as string) == "NULL") { return(null); } return(Convert.ChangeType(v, typeof(DateTime), CultureInfo.InvariantCulture)); }); var products = excel.Fetch <GetterSetterProduct>().ToList(); var file = @"productsconverttracked.xlsx"; excel.Save(file); var productsFetched = new ExcelMapper(file).Fetch <GetterSetterProduct>().ToList(); CollectionAssert.AreEqual(products, productsFetched); }
public void SaveTrackedObjectsTest() { var excel = new ExcelMapper(@"..\..\..\products.xlsx") { TrackObjects = true }; excel.AddMapping(typeof(ProductMapped), "Name", "NameX"); excel.AddMapping <ProductMapped>("Number", p => p.NumberX); excel.AddMapping <ProductMapped>("Price", p => p.PriceX); var products = excel.Fetch <ProductMapped>().ToList(); products[1].PriceX += 1.0m; var file = @"productssavetracked.xlsx"; excel.Save(file); var productsFetched = new ExcelMapper(file).Fetch <ProductMapped>().ToList(); CollectionAssert.AreEqual(products, productsFetched); }
public void JsonMappedTest() { var excel = new ExcelMapper(@"..\..\..\productsjson.xlsx"); excel.AddMapping <ProductJsonMapped>("Product", p => p.Product).AsJson(); var products = excel.Fetch <ProductJsonMapped>().ToList(); CollectionAssert.AreEqual(new List <Product> { new Product { Name = "Nudossi", NumberInStock = 60, Price = 1.99m, Value = "C2*D2" }, new Product { Name = "Halloren", NumberInStock = 33, Price = 2.99m, Value = "C3*D3" }, new Product { Name = "Filinchen", NumberInStock = 100, Price = 0.99m, Value = "C4*D4" }, }, products.Select(p => p.Product)); }
/// <summary> /// Update Test Results. /// </summary> /// <param name="filePath">file path.</param> /// <param name="isJson">Is input file type Json?</param> /// <param name="account">Account.</param> /// <param name="project">Project.</param> /// <param name="token">Token.</param> /// <returns>Integer.</returns> public static int UpdateTestResults(string filePath, bool isJson, string account, string project, string token) { AzureDevOpsUtility.UpdateAccountDetails(account, project, token); if (isJson) { var json = File.ReadAllText(filePath); TestResults = JsonConvert.DeserializeObject <TestResults>(json); } else { var excel = new ExcelMapper(filePath); excel.AddMapping <TestCaseOutcome>("TestCaseId", t => t.TestCaseId); excel.AddMapping <TestCaseOutcome>("TestSuiteId", t => t.TestSuiteId); excel.AddMapping <TestCaseOutcome>("Outcome", t => t.Outcome) .SetPropertyUsing(v => { if ((v as string).Equals(Constants.NotExecuted)) { return(OutcomeType.NotExecuted); } if ((v as string).Equals(Constants.Failed)) { return(OutcomeType.Failed); } else { return(OutcomeType.Passed); } }); var testCases = excel.Fetch <TestCaseOutcome>().ToList(); TestResults = new TestResults() { SuiteId = 0, TestCases = testCases }; } try { GetTestCasesByPlanAsync().GetAwaiter().GetResult(); GetTestPointIdsAsync().GetAwaiter().GetResult(); CreateNewTestRunsAsync().GetAwaiter().GetResult(); UpdateTestRunsAsync().GetAwaiter().GetResult(); } catch (FlurlHttpException e) { var statusCode = e.Call.Response.StatusCode.ToString(); if (statusCode.Equals(Constants.NonAuthoritativeInformation) || statusCode.Equals(Constants.Unauthorized)) { Log.Error("Authentication Error!!! Please provide valid Account Details...\n"); } } catch (Exception e) { CommonUtility.DeleteTestRunsAsync(NewTestRunIds).GetAwaiter().GetResult(); throw e; } return(0); }
public void SaveTrackedObjectsTest() { var excel = new ExcelMapper(@"..\..\products.xlsx") { TrackObjects = true }; excel.AddMapping(typeof(ProductMapped), "Name", "NameX"); excel.AddMapping<ProductMapped>("Number", p => p.NumberX); excel.AddMapping<ProductMapped>("Price", p => p.PriceX); var products = excel.Fetch<ProductMapped>().ToList(); products[1].PriceX += 1.0m; var file = @"productssavetracked.xlsx"; excel.Save(file); var productsFetched = new ExcelMapper(file).Fetch<ProductMapped>().ToList(); CollectionAssert.AreEqual(products, productsFetched); }