public async Task WriteFileTo(DirectoryInfo directoryInfo, string filename)
{
PropertyLister.Load();
var datasource = await AwesomeCorpDatasource.GetSubscribers();
using (var excel = ExcelListWriter.Write(datasource.List))
{
var path = Path.Combine(directoryInfo.FullName, filename);
Logger.LogDebug("Saving excel document in " + path);
excel.SaveAs(path);
}
}
public void ShouldWriteHeader()
{
var datasoure = new List <Subscriber> {
};
var excelRowWriter = Mock.Of <IExcelRowWriter <Subscriber> >();
var headerWriter = Mock.Of <IExcelHeaderWriter <Subscriber> >();
var t = new ExcelListWriter <Subscriber>(headerWriter, excelRowWriter);
var excel = t.Write(datasoure);
Mock.Get(headerWriter).Verify(x =>
x.WriteHeader(It.IsAny <IXLWorksheet>()), Times.Once);
Assert.Pass();
}
/// <summary>
/// Outputs list of strings with header into specified in configuration file way
/// </summary>
/// <param name="files">List of strings to be outputed</param>
/// <param name="header">Header of output</param>
/// <param name="outputFile">String of file in configuration</param>
private void OutputList(List <string> files, string header, string outputFile = "")
{
IListWriter listWriter;
//If output value in configuraton file is set to 'excel' - write to excel file
//Otherwise - write to console.
if (this.Configuration["output"] == "excel")
{
listWriter = new ExcelListWriter(this.Configuration[outputFile]);
}
else
{
listWriter = new ConsoleListWriter();
}
listWriter.WriteList(files, header);
}
public void ShouldWriteTwoRows()
{
var datasoure = new List <Subscriber> {
new Subscriber
{
},
new Subscriber
{
}
};
var excelRowWriter = Mock.Of <IExcelRowWriter <Subscriber> >();
var headerWriter = Mock.Of <IExcelHeaderWriter <Subscriber> >();
var t = new ExcelListWriter <Subscriber>(headerWriter, excelRowWriter);
var excel = t.Write(datasoure);
Mock.Get(excelRowWriter).Verify(x =>
x.WriteRow(It.IsAny <IXLWorksheet>(), It.IsAny <Subscriber>(), It.IsAny <int>()), Times.Exactly(2));
Assert.Pass();
}
