private T GetTestDataObject <T>(TestCaseWrapper <T> testCaseWrapper, TestSourceWrapper <DataTable, DataRow> testSource)
where T : new()
{
var testCase = testCaseWrapper.Initialize.Invoke();
for (int i = 0; i < testSource.Table.Columns.Count; i++)
{
var value = testSource.Row[i];
var key = testSource.Table.Columns[i].ColumnName;
testCaseWrapper.SetupValue.Invoke(testCase, key, value);
}
return(testCase);
}
private IEnumerable <T> ReadDataFromSource <T>(TestCaseWrapper <T> testCaseWrapper)
where T : new()
{
using (var excelPackage = new ExcelPackage(new FileInfo(FilePath)))
{
var worksheets = excelPackage.Workbook.Worksheets;
var sheet = worksheets.ToList().First(s => s.Name == SheetName);
for (int rowIndex = FirstDataRow; rowIndex <= sheet.Dimension.End.Row; rowIndex++)
{
yield return(GetTestDataObject(testCaseWrapper,
new TestSourceWrapper <ExcelWorksheet, int>(sheet, rowIndex)));
}
}
}
private IEnumerable <T> ReadDataFromSource <T>(TestCaseWrapper <T> testCaseWrapper)
where T : new()
{
using (var sr = new StreamReader(FilePath))
{
string line;
while ((line = sr.ReadLine()) != null)
{
var @object = JsonConvert.DeserializeObject <T>(line);
yield return(GetTestDataObject(testCaseWrapper, line));
}
}
}
private T GetTestDataObject <T>(TestCaseWrapper <T> testCaseWrapper, TestSourceWrapper <ExcelWorksheet, int> testSource)
where T : new()
{
var testCase = testCaseWrapper.Initialize.Invoke();
var endColumnIndex = testSource.Table.Dimension.End.Column;
for (int columnIndex = LabelDataRow; columnIndex <= endColumnIndex; columnIndex++)
{
var labelCell = testSource.Table.Cells[LabelDataRow, columnIndex];
var key = labelCell.Value.ToString();
var value = testSource.Table.Cells[testSource.Row, columnIndex].Value;
testCaseWrapper.SetupValue.Invoke(testCase, key, value);
}
return(testCase);
}
private T GetTestDataObject <T>(TestCaseWrapper <T> testCaseWrapper, string @case)
where T : new()
{
var @object = JsonConvert.DeserializeObject <T>(@case);
if (typeof(T) != typeof(TestCase <,>))
{
return(@object);
}
var testCase = testCaseWrapper.Initialize.Invoke();
var properties = @object.GetType().GetProperties();
foreach (var property in properties)
{
var value = property.GetValue(@object);
testCaseWrapper.SetupValue.Invoke(testCase, property.Name, value);
}
return(testCase);
}
private IEnumerable <T> ReadDataFromSource <T>(TestCaseWrapper <T> testCaseWrapper)
where T : new()
{
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
var command = new SqlCommand($"SELECT * FROM {TableName}", connection);
using (var sqlDataAdapter = new SqlDataAdapter(command))
{
var dataTable = sqlDataAdapter.GetAsDataTable();
foreach (DataRow row in dataTable.Rows)
{
yield return(GetTestDataObject(testCaseWrapper,
new TestSourceWrapper <DataTable, DataRow>(dataTable, row)));
}
}
connection.Close();
}
}