public void ToPdf(AuxDocument auxDocument, string documentsFolder, ICollection <AuxDocument> convertedDocuments, Config config) { License license = new License(); license.SetLicense(config.AsposeLicenseFile); AuxDocument convertedDocumentDetails = convertedDocuments.FirstOrDefault(d => d.Id == auxDocument.Id); if (convertedDocumentDetails != null) { auxDocument.ConversionRequired = false; auxDocument.ConvertedFile = convertedDocumentDetails.ConvertedFile; return; } Workbook workbook = new Workbook(documentsFolder + auxDocument.SourceFile) { FileFormat = FileFormatType.Pdf }; auxDocument.ConvertedFile = string.Format("excel_{0}.pdf", Guid.NewGuid()); workbook.Save(documentsFolder + auxDocument.ConvertedFile, new PdfSaveOptions { OnePagePerSheet = config.ConvertExcelToOnePagePerSheet }); convertedDocuments.Add(auxDocument); }
public void ToPdf(AuxDocument auxDocument, string documentsFolder, ICollection <AuxDocument> convertedDocuments) { AuxDocument convertedDocumentDetails = convertedDocuments.FirstOrDefault(d => d.Id == auxDocument.Id); if (convertedDocumentDetails != null) { auxDocument.ConversionRequired = false; auxDocument.ConvertedFile = convertedDocumentDetails.ConvertedFile; auxDocument.PageCount = TotalPages.GetCount(auxDocument.ConvertedFile); return; } string copiedFileName = string.Format("pdf_{0}.pdf", Guid.NewGuid()); File.Copy(documentsFolder + auxDocument.SourceFile, documentsFolder + copiedFileName); auxDocument.ConvertedFile = copiedFileName; convertedDocuments.Add(auxDocument); }
public PackageService WithDocumentItems() { foreach (Section section in Package.Sections) { using (Dal dal = new Dal(Config.ConnString)) { IDataParameter[] param = { dal.GetParameter("@section_id", section.Id) }; using ( IDataReader dr = dal.GetReader("sc_package_load_documents", param, CommandType.StoredProcedure)) { while (dr.Read()) { Item item = new Item(); item.ItemType = ItemType.AuxiliaryDocument; item.Name = dr.GetDrValue <string>(0); item.Order = dr.GetDrValue <short>(1); AuxDocument auxDocument = new AuxDocument(); auxDocument.Id = dr.GetDrValue <int>(2); auxDocument.DocumentType = MapDocumentType.Of(dr.GetDrValue <string>(3).Trim()); auxDocument.SourceFile = dr.GetDrValue <string>(4); auxDocument.ConvertedFile = dr.GetDrValue <string>(5); auxDocument.ConversionRequired = dr.GetDrValue <bool>(6); item.AuxiliaryDocument = auxDocument; section.Items.Add(item); } } } } return(this); }