public HomeController(CompareContext _db, ICsvWriter _csv, IHostingEnvironment _env, IGenerate _gen) { this.db = _db; this.CsvWriter = _csv; this.env = _env; this.gen = _gen; }
public GetSubmissionChangesCsvHandler(IWeeeAuthorization authorization, IGetSubmissionChangesCsvDataAccess dataAccess, ICsvWriter <SubmissionChangesCsvData> csvWriter) { this.authorization = authorization; this.dataAccess = dataAccess; this.csvWriter = csvWriter; }
private static CustomerCapturer CreateCustomerCapturer(ICsvWriter csvWriter = null, ISerialiser serialiser = null, IDataCleaner dataCleaner = null) { csvWriter = csvWriter ?? Substitute.For <ICsvWriter>(); serialiser = serialiser ?? Substitute.For <ISerialiser>(); dataCleaner = dataCleaner ?? new DataCleaner(); return(new CustomerCapturer(csvWriter, serialiser, dataCleaner)); }
private void WriteHeader(ICsvWriter writer) { foreach (var item in _fieldMapping) { writer.WriteField(item.StrName()); } writer.NextRecord(); }
private static void WriteRowValues(Row row, ICsvWriter writer) { foreach (var column in row) { writer.WriteField(column.Value); } writer.NextRecord(); }
private static void WriteHeaders(IEnumerable <Row> rows, ICsvWriter writer) { foreach (var column in rows.First()) { writer.WriteField(column.Header); } writer.NextRecord(); }
private static void WriteHeaders(IEnumerable<Row> rows, ICsvWriter writer) { foreach (var column in rows.First()) { writer.WriteField(column.Header); } writer.NextRecord(); }
public CustomerCapturer(ICsvWriter csvWriter, ISerialiser serialiser, IDataCleaner dataCleaner) { if (csvWriter == null) throw new ArgumentNullException(nameof(csvWriter)); if (serialiser == null) throw new ArgumentNullException(nameof(serialiser)); _csvWriter = csvWriter; _serialiser = serialiser; _dataCleaner = dataCleaner; }
/// <summary> /// Creates a new instance of <see cref="CsvHelper"/> /// using defaults. /// </summary> /// <param name="stream">The <see cref="Stream"/> attached to a CSV file.</param> public CsvHelper( Stream stream ) { if( stream.CanRead ) { reader = new CsvReader( new CsvParser( new StreamReader( stream ), configuration ) ); } if( stream.CanWrite ) { writer = new CsvWriter( new StreamWriter( stream ), configuration ); } }
/// <summary> /// Creates a new instance of <see cref="CsvHelper"/> /// using defaults. /// </summary> /// <param name="stream">The <see cref="Stream"/> attached to a CSV file.</param> public CsvHelper(Stream stream) { if (stream.CanRead) { reader = new CsvReader(new CsvParser(new StreamReader(stream), configuration)); } if (stream.CanWrite) { writer = new CsvWriter(new StreamWriter(stream), configuration); } }
public static void WriteToCsv(ICsvWriter writer, IList<Row> rows) { if (!rows.Any()) throw new InvalidOperationException("No rows to be written"); WriteHeaders(rows, writer); foreach (var row in rows) { WriteRowValues(row, writer); } }
public void WriteReferenceData() { var destinationFile = Path.Combine(ConfigurationManager.AppSettings["DataDirectory"], "RegionReferenceData.csv"); using (_referenceDataWriter = new CsvWriter(new StreamWriter(destinationFile))) { _referenceDataWriter.WriteHeader <PostcodeReferenceData>(); foreach (var pair in _postcodeToRegionMap) { _referenceDataWriter.WriteRecord(new PostcodeReferenceData(pair.Key, pair.Value)); } } }
public UserController( RowinContext dbContext, UserManager <User> userManager, IEmailService emailService, RoleManager <IdentityRole <int> > roleManager, ICsvWriter csvWriter) { this.dbContext = dbContext; this.userManager = userManager; this.emailService = emailService; this.roleManager = roleManager; this.csvWriter = csvWriter; telemetryClient = new TelemetryClient(); }
public RegistrationCsvManager( IRegistrationManager manager, IEventAccessor eventAccessor, ICsvWriter csvWriter) { Guard.NotNull(manager, nameof(manager)); Guard.NotNull(eventAccessor, nameof(eventAccessor)); Guard.NotNull(csvWriter, nameof(csvWriter)); _manager = manager; _eventAccessor = eventAccessor; _csvWriter = csvWriter; }
public CustomerCapturer(ICsvWriter csvWriter, ISerialiser serialiser, IDataCleaner dataCleaner) { if (csvWriter == null) { throw new ArgumentNullException(nameof(csvWriter)); } if (serialiser == null) { throw new ArgumentNullException(nameof(serialiser)); } _csvWriter = csvWriter; _serialiser = serialiser; _dataCleaner = dataCleaner; }
public static void WriteToCsv(ICsvWriter writer, IList <Row> rows) { if (!rows.Any()) { throw new InvalidOperationException("No rows to be written"); } WriteHeaders(rows, writer); foreach (var row in rows) { WriteRowValues(row, writer); } }
private void OpenCsvFile() { var fileName = string.Format("{0}-Generations.csv", optimizerConfig.InstanceId); if (File.Exists(fileName)) { File.Delete(fileName); } this.textWriter = File.CreateText(fileName); this.csvWriter = new CsvWriter(textWriter); csvWriter.Configuration.RegisterClassMap <GenerationStateMap>(); this.csvFileOpen = true; }
public ProductsController(Dispatcher dispatcher, ILogger <ProductsController> logger, IHtmlGenerator htmlGenerator, IPdfConverter pdfConverter, ICsvWriter <ProductModel> productCsvWriter, ICsvReader <ProductModel> productCsvReader) { _dispatcher = dispatcher; _logger = logger; _htmlGenerator = htmlGenerator; _pdfConverter = pdfConverter; _productCsvWriter = productCsvWriter; _productCsvReader = productCsvReader; }
public void WriteReferenceData() { var destinationFile = Path.Combine(ConfigurationManager.AppSettings["DataDirectory"], "LocationReferenceData.csv"); using (_referenceDataWriter = new CsvWriter(new StreamWriter(destinationFile))) { _referenceDataWriter.WriteHeader <LocationReferenceData>(); foreach (var row in _practiceToPostcodeMap) { _referenceDataWriter.WriteRecord(new LocationReferenceData(row.Item1, row.Item2)); } } }
public void OutputQueryToCsv() { ICsvWriter csv = CsvWriter.Create(path: _root + "output_from_table.csv", queryString: "SELECT * FROM dbo.TestTable", connectionString: _connectionString); bool success = csv.OutputToCsv(); string error = csv.Error; csv.Dispose(); if (error != null) { throw new Exception(error); } Assert.IsTrue(success); }
private void OpenFileWriter(string fileName) { if (_csvWriter != null) { return; } FileInfo fileInfo = new FileInfo(fileName); _writerStream = fileInfo.CreateText(); _csvWriter = new CsvWriter(_writerStream); _csvWriter.Configuration.Delimiter = "\t"; _csvWriter.Configuration.HasHeaderRecord = false; _csvWriter.Configuration.ThrowOnBadData = true; }
public void WriteReferenceData() { var destinationFile = Path.Combine(ConfigurationManager.AppSettings["DataDirectory"], ConfigurationManager.AppSettings["AddressReferenceData"]); using (_referenceDataWriter = new CsvWriter(new StreamWriter(destinationFile))) { _referenceDataWriter.WriteHeader <AddressReferenceDataRow>(); foreach (var row in _practicesToPostcodeMap) { _referenceDataWriter.WriteRecord(new AddressReferenceDataRow(row.Key, row.Value)); } } }
/// <summary> /// Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. /// </summary> /// <param name="disposing">True if the instance needs to be disposed of.</param> protected virtual void Dispose(bool disposing) { if (!disposed) { if (disposing) { Reader.Dispose(); Writer.Dispose(); } disposed = true; Reader = null; Writer = null; } }
public void Close() { if (_csvWriter != null) { _csvWriter.Dispose(); _csvWriter = null; } if (_csvReader == null) { return; } _csvReader.Dispose(); _csvReader = null; }
public void Open(string fileName, Mode mode) { switch (mode) { case Mode.Read: _csvReader = _builder.BuildReader(fileName); break; case Mode.Write: _csvWriter = _builder.BuildWriter(fileName); break; default: throw new Exception("Unknown file mode for " + fileName); } }
/// <summary> /// Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. /// </summary> /// <param name="disposing">True if the instance needs to be disposed of.</param> protected virtual void Dispose(bool disposing) { if (disposed) { return; } if (disposing) { using ( reader ) {} using ( writer ) {} } disposed = true; reader = null; writer = null; }
/// <summary> /// Regular constructor /// </summary> public Extractor() { _paused = false; _ukCulture = CultureInfo.GetCultureInfo("en-GB"); _serviceErrorDelay = 5 * 1000; //repeat delay in case of TradingService exception var logFile = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "diagnostics.log"); _logger = new StreamWriter(logFile, true); //System.Diagnostics.Debugger.Launch(); //read app.config //csv folder var folder = ConfigurationManager.AppSettings[CfgCsvFolderName]; if (string.IsNullOrEmpty(folder)) { Log("Csv folder is not set or empty. Using default value"); folder = DefaultCsvFolder; AddOrUpdateAppSettings(CfgCsvFolderName, DefaultCsvFolder); } //extract frequency if (!int.TryParse(ConfigurationManager.AppSettings[CfgFreqName], out int freq)) { Log("Extraction frequency is not set or has invalid format. Using default value"); freq = DefaultFreq; AddOrUpdateAppSettings(CfgFreqName, DefaultFreq.ToString(_ukCulture)); } _timer = new System.Timers.Timer(); _timer.Interval = freq * 60 * 1000; try { _csvWriter = new CsvWriter(folder, CsvFileHeader); _tradingService = new TradingService(); } catch (Exception ex) { Log(ex.Message); } }
/// <summary> /// /// </summary> /// <returns></returns> public void Load(List <COReDataRecord> data) { if (!Directory.Exists(this.folderPath)) { throw new ArgumentException("Dir path was not found"); } if (data == null) { throw new Exception("DataRecord was not found, did you call CreateDataRecord()?"); } string filePath = Path.Combine(folderPath, constructFileName(data.Last())); using (var file = File.CreateText(filePath)) { writer = new CsvHelper.CsvWriter(file); writer.WriteRecords(data); } }
/// <summary> /// Test constructor /// </summary> /// <param name="csvWriter">Csv writer interface</param> /// <param name="repeatDelay">Repeat delay in case of TradingService exception</param> internal Extractor(ICsvWriter csvWriter, int repeatDelay) { _paused = false; _ukCulture = CultureInfo.GetCultureInfo("en-GB"); _serviceErrorDelay = repeatDelay; var logFile = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "diagnostics.log"); _logger = new StreamWriter(logFile, true); _csvWriter = csvWriter; try { _tradingService = new TradingService(); } catch (Exception ex) { Log(ex.Message); } }
public void WriteTo(ICsvWriter writer) => WriteTo(writer.Write);
/// <summary> /// Creates a new instance of <see cref="CsvHelper"/> /// using defaults. /// </summary> /// <param name="stream">The <see cref="Stream"/> attached to a CSV file.</param> public CsvHelper(Stream stream) { Reader = new CsvReader(new CsvParser(new StreamReader(stream), configuration)); Writer = new CsvWriter(new StreamWriter(stream), configuration); }
public CSVFileMerge(ICsvReader reader, ICsvWriter writer, IConfiguration config) { this.reader = reader; this.writer = writer; this.config = config; }
public Converter(IDataSetProvider dataSetProvider, IPocoGenerator pocoGenerator, ICsvWriter csvWriter) { DataSetProvider = dataSetProvider; PocoGenerator = pocoGenerator; CsvWriter = csvWriter; }
private static CustomerCapturer CreateCustomerCapturer(ICsvWriter csvWriter = null, ISerialiser serialiser = null, IDataCleaner dataCleaner = null) { csvWriter = csvWriter ?? Substitute.For<ICsvWriter>(); serialiser = serialiser ?? Substitute.For<ISerialiser>(); dataCleaner = dataCleaner ?? new DataCleaner(); return new CustomerCapturer(csvWriter, serialiser, dataCleaner); }
/// <summary> /// Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. /// </summary> /// <param name="disposing">True if the instance needs to be disposed of.</param> protected virtual void Dispose( bool disposing ) { if( disposed ) { return; } if( disposing ) { using( reader ) {} using( writer ) {} } disposed = true; reader = null; writer = null; }
public void Before_each_test() { _writer = new CsvWriter(); }
public GraphViewModel(ICsvWriter csvWriter) { this.csvWriter = csvWriter; }
public void Initialize() { _container = new Mock<IContainer>(); _container.Setup(x => x.GetInstance<ICsvWriter>()).Returns(new CsvWriter()); _csvWriter = _container.Object.GetInstance<ICsvWriter>(); }
/// <summary> /// Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. /// </summary> /// <param name="disposing">True if the instance needs to be disposed of.</param> protected virtual void Dispose( bool disposing ) { if( !disposed ) { if( disposing ) { Reader.Dispose(); Writer.Dispose(); } disposed = true; Reader = null; Writer = null; } }