Create C# script to export documents and XML file to folder (asp.net)

We have a ASP.net site built in C# which manages documents and forms. We need to add a feature that will export the documents and a linked XML file to a directory on the site. Project requirements are below: 1. For each document with a status of 'Approved' add an option under the 'Action' column called 'Export to ECM.' This will trigger the export for that document. (screen shot attached) 2. Create a directory for the exports called 'ecm' in the root directory. In the code this location will be referenced through a variable in appSettings. Add a new value in [login to view URL] under <appSettings> as <add key="ECMDirectory" value="~/ecm" so that we can easily change the directory in the future. Reference this key when writing your code instead of a direct path to the directory. 4. Database Changes - Create new column in database to store ECM_id: documents>doc_ecm_id (varchar(255), allow NULL). This id will link to a related table that stores export history. When a document is exported if ECM_id doesn't exist the script will create a new unique value for this, if it already exists script will use the current value. - Create new table to store export history: table name = ECMExportHistory fields: id: int, primary key, unique id, No NULLs ECM_id: int, No NULLs, key which links to documents table FileName: varchar(255), No NULLs, name of the XML file exported CreatedDate: datetime, No NULLs, date of the export 4. Create the script to export the document: - Place script in /App_Code/[login to view URL] file - This script will be accessed through different methods later so should be flexible. - Input parameters = (string doc_id) the id of the document from the database: documents > id - Output = return false on error or 'ECM_id' if successful. ECM_id is a unique id to identify that this document has been exported. Will be stored in the database column create above: documents > doc_ecm_id << Script >> 5. Script will create a unique name for the exported files so they don't overwrite any other export. This name will be used for both the exported file and the XML file placed in the export folder. - Name should be: {document id} + {loan id} + {date} + {incremental number if file already exists in folder} - Example: 45862-55285-09062017-8 - Example of exported files with this name: [login to view URL] [login to view URL] 6. Export/copy the document - could be pdf, Excel, zip or Word doc - The below items determine where the file is located: if (doc_status == "Submitted" OR doc_status == "Saved" OR doc_revert_status == "Saved" OR doc_revert_status == "Saved") - get document from /generated/ + {doc_pdf_submission_link} if (doc_status == "Uploaded" OR doc_revert_status == "Uploaded") - get document from /upload/ + {doc_pdf_submission_link} if (doc_pdf_submission_link == "multi") - Need to compress multiple files into a zip file. Check [login to view URL] line 672 for an example of this - Once you have the correct file create a copy in the /ecm/ directory and rename it to {file name (step 5)} + extension 7. Create the XML file. The export will contain a matching XML file with additional data about the document. The XML file will be named the same as the file but with a .xml extension. The XML file should contain the following info in XML format: - ECM_id - ECMName: the generated file name created in step 5 with no extension - FileName: the document from step 6. ie. [login to view URL] - All fields from the attached SQL statement (modify WHERE to use the correct document>id) 8. Update the Database Once the export is completed and both files have been moved to the /ecm/ directory update the datebase: - Update documents>doc_ecm_id with the ECM_id if this is a new export. If the document has previously been exported don't change the value. - Insert entry into: ECMExportHistory. Always add a new entry, the field ECM_id is the key that will tie all entries to the original document Let me know if there are any questions.