This is my scenario. I have to create an Invoice Batch file. Users will select multiple orders from a grid then I need to loop through these orders and create an invoice for each order. Here is the caveat. For each order there is another table called order_docs that has an order number and physical file location on the network to a scanned PDF document. For each order I create an invoice for I need to attach 'behind' that invoice the scanned PDF document if it exists then continue for each order, invoice then behind it scanned pdf merged into the next pages for example.
I assume I may need to use a console application to handle this scenario, launch from MVC app or put in queue table then console app would create the file. Worst case scenario I will be sending it direct to the printer within a loop.
Any suggestions on this, best tool to use aka can iTextSharp handle this SSRS etc?
Hope this makes sense looking for best possible approach.