コード例 #1
0
        private void GenerateCSV(IEnumerable <ReportContact> reportContacts, string fileName)
        {
            if (reportContacts.IsAny())
            {
                Log.Informational("Request received for generating CSV with filename as : " + fileName);
                string location = _jobConfig.NeverBounceCsvFiles;
                location += fileName.Replace(".xls", ".csv").Replace(".xlsx", ".csv").Replace(".xml", ".csv");

                DataTable table = ConvertToDataTable(reportContacts);
                ReadExcel ex    = new ReadExcel();
                byte[]    bytes = ex.ConvertDataSetToCSV(table, string.Empty);
                File.WriteAllBytes(location, bytes);
                Log.Informational("CSV generated successfully");
            }
            else
            {
                throw new UnsupportedOperationException("Couldn't find contacts with email for filename : " + fileName);
            }
        }