The electronic price handbook for field staff and back office regularly creates PDF and Excel documents from the data of a price calculation system and publishes these documents on the intranet. The price manual is extended by another application for another department to present price data from an Excel sheet in a layout similar to the data from the database. The display options are significantly expanded by configurable text attributes and images. The various price manuals are also published in Google Drive. Additional filter options are implemented in the database-based application.
Supplement
The applications for creating the electronic price manuals are implemented with C # as an application without a UI, since they are subject to job controls. Database bank access is implemented via the Microsoft Entity Framework. The MS Open XML SDK is used to process and create the Excel documents, PdfSharp and MigraDoc are used to create the PDF documents. The PDF documents are protected so that the content cannot be easily copied. The documents are published on a SharePoint page on the intranet and in Google Drive.
Subject description
The electronic price manuals are created based on the data of an existing application for price calculation or on the basis of a complex Excel sheet. In this way, the field service and back office are provided with daily updated prices in the form of documents that offer search and filter options.