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