4. ERP Contact-Us form submissions

[teresaleelim]

After the connection between the HTML and our local SQL server was established, I needed to create a way for the submissions to be able to be viewed in the INT ERP.

[teresaleelim]

I created a separate page in the INT and did the same thing we do for every project (create DTOs, Services, Interfaces, create stored procedures and connect everything) and display it in the ERP. The functions of this table were to edit and delete the instances of the table, and I decided not to include an Add function as it wouldn't make sense that an admin wants to add a new instance of a contact submission within the ERP.

Here is what the finished page looks like:

As you can see, there is a checkbox function where the admin can easily check the messages that have been replied to, and an edit & delete button.