public void WriteExcelMultiRowsWithFilterTest()
{
//Arrange
ActExcel actExcel = new ActExcel();
actExcel.RunOnBusinessFlow = new GingerCore.BusinessFlow();
actExcel.AddOrUpdateInputParamValueAndCalculatedValue(nameof(ActExcel.ExcelFileName),
TestResources.GetTestResourcesFile(excelPathWriteTemp));
actExcel.AddOrUpdateInputParamValueAndCalculatedValue(nameof(ActExcel.SheetName), "Sheet1");
actExcel.AddOrUpdateInputParamValueAndCalculatedValue(nameof(ActExcel.SelectRowsWhere), "Last='Cohen'");
actExcel.AddOrUpdateInputParamValueAndCalculatedValue(nameof(ActExcel.ColMappingRules), "First='Simon'");
actExcel.ExcelActionType = ActExcel.eExcelActionType.WriteData;
actExcel.SelectAllRows = true;
//Act
actExcel.Execute();
//Assert
IExcelOperations excelOperations = new ExcelNPOIOperations();
DataTable dt = excelOperations.ReadData(excelPathWriteTemp, actExcel.SheetName, actExcel.SelectRowsWhere, actExcel.SelectAllRows);
string actual = "";
foreach (DataRow dr in dt.Rows)
{
string current = string.Join(',', dr.ItemArray.Select(x => x).ToList());
actual = string.Join(',', actual, current);
}
Assert.AreEqual(actual.TrimStart(','), "1,Simon,Cohen,2109 Fox Dr,4,Simon,Cohen,NY");
}
public void WriteExcelOneRowWithPKTest()
{
//Arrange
ActExcel actExcel = new ActExcel();
actExcel.RunOnBusinessFlow = new GingerCore.BusinessFlow();
actExcel.AddOrUpdateInputParamValueAndCalculatedValue(nameof(ActExcel.ExcelFileName),
TestResources.GetTestResourcesFile(excelPathWriteTemp));
actExcel.AddOrUpdateInputParamValueAndCalculatedValue(nameof(ActExcel.SheetName), "Sheet1");
actExcel.AddOrUpdateInputParamValueAndCalculatedValue(nameof(ActExcel.SelectRowsWhere), "Last='Cohen'");
actExcel.AddOrUpdateInputParamValueAndCalculatedValue(nameof(ActExcel.PrimaryKeyColumn), "ID");
actExcel.AddOrUpdateInputParamValueAndCalculatedValue(nameof(ActExcel.ColMappingRules), "First='Marco'");
actExcel.ExcelActionType = ActExcel.eExcelActionType.WriteData;
//Act
actExcel.Execute();
//Assert
IExcelOperations excelOperations = new ExcelNPOIOperations();
DataTable dt = excelOperations.ReadData(excelPathWriteTemp, actExcel.SheetName, actExcel.SelectRowsWhere, false);
Assert.AreEqual(string.Join(',', dt.Rows[0].ItemArray.Select(x => x).ToList()), "1,Marco,Cohen,2109 Fox Dr");
}
