Esempio n. 1
0
 public HomeController(CompareContext _db, ICsvWriter _csv, IHostingEnvironment _env, IGenerate _gen)
 {
     this.db        = _db;
     this.CsvWriter = _csv;
     this.env       = _env;
     this.gen       = _gen;
 }
Esempio n. 2
0
 public GetSubmissionChangesCsvHandler(IWeeeAuthorization authorization, IGetSubmissionChangesCsvDataAccess dataAccess,
                                       ICsvWriter <SubmissionChangesCsvData> csvWriter)
 {
     this.authorization = authorization;
     this.dataAccess    = dataAccess;
     this.csvWriter     = csvWriter;
 }
Esempio n. 3
0
 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));
 }
Esempio n. 4
0
 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 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();
 }
Esempio n. 9
0
 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;
 }
Esempio n. 10
0
 /// <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 );
     }
 }
Esempio n. 11
0
 /// <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);
            }
        }
Esempio n. 13
0
        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));
                }
            }
        }
Esempio n. 14
0
 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;
        }
Esempio n. 16
0
 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);
            }
        }
Esempio n. 18
0
        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;
        }
Esempio n. 19
0
 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;
 }
Esempio n. 20
0
        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));
                }
            }
        }
Esempio n. 21
0
        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);
        }
Esempio n. 22
0
        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));
                }
            }
        }
Esempio n. 24
0
        /// <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;
            }
        }
Esempio n. 25
0
        public void Close()
        {
            if (_csvWriter != null)
            {
                _csvWriter.Dispose();
                _csvWriter = null;
            }

            if (_csvReader == null)
            {
                return;
            }

            _csvReader.Dispose();
            _csvReader = null;
        }
Esempio n. 26
0
        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);
            }
        }
Esempio n. 27
0
        /// <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;
        }
Esempio n. 28
0
        /// <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);
            }
        }
Esempio n. 29
0
        /// <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);
            }
        }
Esempio n. 30
0
        /// <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);
            }
        }
Esempio n. 31
0
 public void WriteTo(ICsvWriter writer)
 => WriteTo(writer.Write);
Esempio n. 32
0
 /// <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);
 }
Esempio n. 33
0
 public CSVFileMerge(ICsvReader reader, ICsvWriter writer, IConfiguration config)
 {
     this.reader = reader;
     this.writer = writer;
     this.config = config;
 }
Esempio n. 34
0
 public Converter(IDataSetProvider dataSetProvider, IPocoGenerator pocoGenerator, ICsvWriter csvWriter)
 {
     DataSetProvider = dataSetProvider;
     PocoGenerator   = pocoGenerator;
     CsvWriter       = csvWriter;
 }
Esempio n. 35
0
 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);
 }
Esempio n. 36
0
        /// <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;
        }
Esempio n. 37
0
 public void Before_each_test()
 {
     _writer = new CsvWriter();
 }
Esempio n. 38
0
 public GraphViewModel(ICsvWriter csvWriter)
 {
     this.csvWriter = csvWriter;
 }
Esempio n. 39
0
 public void Initialize()
 {
     _container = new Mock<IContainer>();
     _container.Setup(x => x.GetInstance<ICsvWriter>()).Returns(new CsvWriter());
     _csvWriter = _container.Object.GetInstance<ICsvWriter>();
 }
Esempio n. 40
0
        /// <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;
            }
        }