public void LoaOFCFile()
{
OFXDataBusiness business = new OFXDataBusiness();
var data = new OFXData();
var fileName = @"OFXFIles\extrato1.ofx";
OFXReader r = new OFXReader(fileName);
var _OFXData = business.LoadData(r);
Assert.IsTrue(((List <OFXBankStatement>)_OFXData.statements).Count() == 31);
}
public IActionResult Index()
{
try
{
var file = Request.Form.Files[0];
var folderName = Path.Combine("Resources", "File");
var pathToSave = Path.Combine(Directory.GetCurrentDirectory(), folderName);
if (file.Length > 0)
{
//var fileName = ContentDispositionHeaderValue.Parse(file.ContentDisposition).FileName.Trim('"');
//var fullPath = Path.Combine(pathToSave, fileName);
//var dbPath = Path.Combine(folderName, fileName);
//using (var stream = new FileStream(fullPath, FileMode.Create))
//{
var stream = file.OpenReadStream();
// file.CopyTo(stream);
OFXDataBusiness business = new OFXDataBusiness();
OFXReader OFXReader = new OFXReader(stream);
var data = business.LoadData(OFXReader);
_BankStatementBusiness.Add(new Domain.Enitties.BankStatement()
{
Active = true,
CreatedDate = DateTime.Now,
Accttype = data.ACCTTYPE,
Balamt = data.BALAMT,
Bankid = data.BANKID,
Curdef = data.CURDEF,
Dtasof = data.DTASOF.OFXFormatteddDate(),
Dataserver = data.DTSERVER.OFXFormatteddDate(),
Language = data.LANGUAGE,
Ofx = data.OFX,
Severity = data.SEVERITY,
Acctid = data.ACCTID,
Trnuid = data.TRNUID,
Code = data.CODE,
Accountlaunches = data.statements.Select(x => new Accountlaunche()
{
Active = true,
CreatedDate = DateTime.Now,
Dtposted = x.DTPOSTED.OFXFormatteddDate(),
Memo = x.MEMO,
Trnamt = x.TRNAMT,
Trntype = x.TRNTYPE
}).ToList()
});
_BankStatementBusiness.Save();
}
//var folderName = Path.Combine("Resources", "Images");
//var pathToSave = Path.Combine(Directory.GetCurrentDirectory(), folderName);
//if (file.Length > 0)
//{
// var fileName = ContentDispositionHeaderValue.Parse(file.ContentDisposition).FileName.Trim('"');
// var fullPath = Path.Combine(pathToSave, fileName);
// var dbPath = Path.Combine(folderName, fileName);
// using (var stream = new FileStream(fullPath, FileMode.Create))
// {
// file.CopyTo(stream);
// }
// return Ok(new { dbPath });
//}
//else
//{
// return BadRequest();
//}
}
catch (Exception ex)
{
return(StatusCode(500, $"Internal server error: {ex}"));
}
return(Ok());
}
