public void Execute_Should_Check_Errors_On_Xlsx(int idLine, string errorMessage)
{
var dt = new DataTransaction();
var results = dt.Execute(@"..\..\Datas\Business\FakeFiles\BadDatas.xlsx");
var message = results.Messages.FirstOrDefault(x => x.IdLine == idLine);
Assert.IsNotNull(message);
Assert.AreEqual(errorMessage, message.Messages.FirstOrDefault());
Assert.AreEqual(DataTransactionState.Ignored, message.State);
Assert.AreEqual(0, Repositories.Informations.FindAll().Count);
}
public void Execute_Should_Add_Information_On_Xlsx()
{
var dt = new DataTransaction();
var results = dt.Execute(@"..\..\Datas\Business\FakeFiles\GoodDatas.xlsx");
foreach (var dataTransaction in results.Messages)
{
Assert.IsNotNull(dataTransaction);
Assert.AreEqual(0, dataTransaction.Messages.Count);
Assert.AreEqual(DataTransactionState.Valid, dataTransaction.State);
}
var resultDatas = Repositories.Informations.FindAll();
Assert.AreEqual(1, resultDatas.Count);
Assert.AreEqual(10.55, resultDatas.ElementAt(0).Amount);
}
public ActionResult Upload(HttpPostedFileBase file)
{
ViewBag.Title = Common.Upload_Title;
var response = new DataTransactionResponse();
if (ModelState.IsValid && file != null && file.IsValidForUpload())
{
var dataTransaction = new DataTransaction();
response = dataTransaction.Execute(SaveFile(file));
ViewBag.Message = InformationMessage.Success_File_Uploaded;
}
else
{
ViewBag.Message = InformationMessage.Error_File_Is_Invalid;
}
return View(response);
}