Application was made to make work of my friends from old department much easier and quicker. Instead of manually copying informations from first excel file and finding additional info like zip code depending on the street address and city from first file and pasting it to the second excel file app does it for them in the blink of an eye! Application uses 2 excel files to create waybill template in excel format. First - the source, contains a lot of informations about all placed orders, Second one is a template to which read specified data from first file is inserted. Application uses a database with 2 tables in it. First table is named 'Computers' it contains all computer models which occurs in a source file with info of: model name, price, weight. Second table is named 'Localisations' it contains all localisations which occurs and are often used in a source file with info of: street, city, zip code.
I have built this application using:
- .NET Core 3.1 - console application
- Entity Framework Core
- AutoMapper
- EPPLUS - To work with excel files
In properties of project click debug and set argumentssourceFilePath to path of downloaded SourceFile.xlsx, templateFilePath to path of downloaded TemplateFile.xlsx and savingDirectory to saving directory which in you want to have created files and SenderSettingsJsonPath to path of downloaded SenderSettings.json
Run the application, set range of rows to be copied from source file and then file will be created.
My Email - arek.pazola1998@gmail.com
Project Link: https://github.com/w00lfer/Waybill-Application