private void CreateContent(TradeInformation info) { var contentLine = ConsoleTableCreator.CreateContentLine(info.Name.TruncateLength(35), info.TypeOfAction, info.Quantity.ToString(), info.Rate.ToString()); ConsoleTableCreator.PrintLine(contentLine); }
private static TradeActionEvent CreateTradeAction(TradeInformation line) { return(new TradeActionEvent { RecordNumber = line.RecordNumber, DateOfAction = line.DateOfAction, Quantity = line.Quantity, Rate = Convert.ToSingle(line.Rate * line.ExchangeCurrency), TotalTransactionAmount = Convert.ToSingle(line.TotalTransactionCost) }); }
private IEnumerable <TradeInformation> ReadExcelFileContent(string fileName) { var collection = new List <TradeInformation>(); using (var stream = File.Open(fileName, FileMode.Open, FileAccess.Read)) { using (var reader = ExcelReaderFactory.CreateReader(stream)) { reader.Read(); do { while (reader.Read()) { var info = new TradeInformation(recordNumber: reader.GetString(0), typeOfAction: reader.GetString(1), name: reader.GetString(2), isinCode: reader.GetString(3), tradeIdentifier: reader.GetString(4), stockExchange: reader.GetString(5), dateOfAction: reader.GetString(6), paymentDate: reader.GetString(7), quantity: reader.GetValue(8), rate: reader.GetDouble(9), currency: reader.GetString(10), exchangeCurrency: reader.GetDouble(11), marketValue: reader.GetValue(12), commision: reader.GetValue(13), totalTransactionCost: reader.GetValue(14)); collection.Add(info); } } while (reader.NextResult()); } } return(collection); }