public override DataTransactionResponse Run()
{
var dataTransactionResponse = new DataTransactionResponse();
using (var reader = new StreamReader(Url))
{
var counter = 0;
while (!reader.EndOfStream)
{
var line = reader.ReadLine();
if (counter > 0 && line != null)
{
var response = CheckAndInsertData(line.Split(';'), counter);
dataTransactionResponse.Messages.Add(response);
}
counter++;
}
}
return dataTransactionResponse;
}
public override DataTransactionResponse Run()
{
var dataTransactionResponse = new DataTransactionResponse();
XSSFWorkbook xssfWorkbook;
using (var file = new FileStream(Url, FileMode.Open, FileAccess.Read))
{
xssfWorkbook = new XSSFWorkbook(file);
}
var sheet = xssfWorkbook.GetSheetAt(0);
var rows = sheet.GetRowEnumerator();
rows.MoveNext();
while (rows.MoveNext())
{
IRow row = (XSSFRow) rows.Current;
var response = CheckAndInsertData(row);
dataTransactionResponse.Messages.Add(response);
}
xssfWorkbook = null;
sheet = null;
return dataTransactionResponse;
}
