public void ReadFile(Account account1)
{
var fileName1 = "C:\\Source\\acadotnet\\BankWorm\\transactionfile-data.csv";
var fileContents = File.ReadAllLines(fileName1).ToList().Skip(1);
foreach (var line in fileContents)
{
var cells = line.Split(',');
var transaction = new Transaction
{
CreateDate = DateTime.Parse(cells[0]),
Memo = cells[1],
TransactionTypeId = EnumExtensions.ConvertEFTransactionType(cells[2]),
Amount = Convert.ToDecimal(cells[3]),
Account = account1
};
_context.Transactions.Add(transaction);
}
_context.SaveChanges();
}