public async Task should_return_exception_when_worksheet_invalid()
{
using (var stream = File.OpenRead(Environment.CurrentDirectory + "/Exception.xlsx"))
{
var file = new FormFile(stream, 0, stream.Length, null, Path.GetFileName(Environment.CurrentDirectory + "/Exception.xlsx"));
var controller = new LearnerController();
Task Result() => controller.ImportLearners(file);
await Assert.ThrowsAsync <NullReferenceException>(Result);
}
}
public async Task should_import_learners()
{
using (var stream = File.OpenRead(Environment.CurrentDirectory + "/Sample.xlsx"))
{
var file = new FormFile(stream, 0, stream.Length, null, Path.GetFileName(Environment.CurrentDirectory + "/Sample.xlsx"));
var controller = new LearnerController();
var result = await controller.ImportLearners(file);
var returnOkResult = Assert.IsType <OkObjectResult>(result);
Assert.Equal(9, returnOkResult.Value);
}
}
public async Task should_return_bad_request_when_duplicate_column()
{
using (var stream = File.OpenRead(Environment.CurrentDirectory + "/Duplicate.xlsx"))
{
var file = new FormFile(stream, 0, stream.Length, null, Path.GetFileName(Environment.CurrentDirectory + "/Duplicate.xlsx"));
var controller = new LearnerController();
var result = await controller.ImportLearners(file);
var returnBadRequestResult = Assert.IsType <BadRequestObjectResult>(result);
Assert.Equal("Duplicate column name", returnBadRequestResult.Value);
}
}
public async Task should_return_bad_request_when_file_extensions_invalid()
{
using (var stream = File.OpenRead(Environment.CurrentDirectory + "/Test.xls"))
{
var file = new FormFile(stream, 0, stream.Length, null,
Path.GetFileName(Environment.CurrentDirectory + "/Test.xls"));
var controller = new LearnerController();
var result = await controller.ImportLearners(file);
var returnBadRequestResult = Assert.IsType <BadRequestObjectResult>(result);
Assert.Equal("File type not supported, please upload Excel Package", returnBadRequestResult.Value);
}
}