public static void WriteFile(FileType fileType, List <RacerDetail> racer) { var file = FileLocationEnum.None; if (fileType == FileType.CN) { file = FileLocationEnum.CN; } else if (fileType == FileType.ST) { file = FileLocationEnum.ST; } else if (fileType == FileType.FT) { file = FileLocationEnum.FT; } else if (fileType == FileType.Name) { file = FileLocationEnum.Name; } try { var fileLoction = FileLocation.GetFilePath(file); switch (fileType) { case FileType.CN: WriteToFile(racer, fileLoction, FileType.CN); break; case FileType.ST: WriteToFile(racer, fileLoction, FileType.ST); break; case FileType.FT: WriteToFile(racer, fileLoction, FileType.FT); break; case FileType.Name: WriteToFile(racer, fileLoction, FileType.Name); break; default: break; } } catch (Exception ex) { Logger.Info("XlsReaderService.WriteFile Error:" + ex.Message); } Console.ReadLine(); }
public static void WriteFile(FileType fileType, List <RacerDetail> racer) { log4net.Config.XmlConfigurator.Configure(); var fileLoction = FileLocation.GetFilePath(FileLocationEnum.Txt); switch (fileType) { case FileType.CN: if (File.Exists(fileLoction)) { File.Delete(fileLoction); } StringBuilder sb = new StringBuilder(); int cnIndex = 1; foreach (var item in racer) { sb.Append("<C" + cnIndex + "\t" + item.Number); sb.Append(System.Environment.NewLine); cnIndex++; } try { using (System.IO.StreamWriter file = new System.IO.StreamWriter(fileLoction, true)) { file.Write(sb.ToString()); } } catch (UnauthorizedAccessException ex) { Logger.Info(ex.Message); } catch (Exception ex) { Logger.Info(ex.Message); } break; default: break; } Console.ReadLine(); }
public void Extract() { string xlsFile = string.Empty; string _pdfFile = string.Empty; var rootFolder = FileLocation.CreateBaseFolderIsfNotExists(); var files = Directory.GetFiles(rootFolder + ConfigurationManager.AppSettings["PdfFileLocation"]).Where(x => x.EndsWith(".pdf")).ToArray(); if (files.Length == 0) { Logger.Info("No Pdf File Found"); return; } var extractor = new XLSExtractor(); FileInfo info = null; extractor.RegistrationName = "NOT - FOR - RESALE - SINGLE - ENDUSER - ONLY - NO - PRIVATE - SUPPORT - [email protected]"; extractor.RegistrationKey = "10C9-AC43-B36E-997C-CCCF-BDEB-C9D"; _pdfFile = files[0]; Logger.Info("Total file Loaded: " + files.Length); Logger.Info("Pdf file loaded: " + _pdfFile); extractor.PageDataCaching = PageDataCaching.None; Logger.Info("Xsl file loaded: " + xlsFile); extractor.AutoAlignColumnsToHeader = true; Logger.Info("Pdf file extraction started"); Logger.Info("Loaded file:" + files[0]); info = new FileInfo(_pdfFile); xlsFile = FileLocation.GetFilePath(FileLocationEnum.Xls); xlsFile += info.Name.Split('.')[0] + ".xls"; try { extractor.LoadDocumentFromFile(files[0]); extractor.SaveToXLSFile(xlsFile); extractor.Reset(); } catch (PDFExtractorException ex) { Logger.Info("PDFExtractorException: " + ex.Message); } if (extractor.IsDocumentLoaded) { extractor.Dispose(); } XlsReaderService.ReadXls(xlsFile); try { var destination = FileLocation.GetFilePath(FileLocationEnum.ProcessedPdf); var fileName = info.Name.Split('.')[0]; info.MoveTo(destination + fileName + ".pdf"); } catch (IOException ex) { Logger.Info("Delete Error: " + ex.Message); } }