Custom XML Creator

We supply recruitment software to HR companies. Presently they have to log into our systems to review their job application. Now we want the ability for them to poll a unique XML so they can integrate into their own systems.


Creating the XML Feed:

From within our own system we want to use a DevExpress TreeView controller to tailor make the XML feed. This will be built as follows:

Parent Child(s)

Job: JobID; Job Title; Job Location

Application Date & Time

Applicant Details: First Name; Surname; Email; Telephone; Mobile; Address 1; Address 2; City/Town; County; Postcode; Country; HR-XML; CV File

Suitability Calculations: Skills Rejected/Accepted; Distance; Distance Rejected/Accepted; Overall Rejected/Accepted; Score

A URL should be created for the client to poll. There should be authentication within the URL for security purposes using the user’s username and ID and a hash (SHA-256) of the password.
Ex. http://rg.com/Services/xml.ashx?id=732&un=user@domain.com&pwh=2cf24dba5fb0a30e26e83b2ac5b9e29e1b161e5c1fa7425e73043362938b9824

ALL inputs will need to be sanitized as this service will access the database

For additional security we should have the option of locking the URL down to a fixed IP.


Create a Cache of XML:

The system should create the XML feed and save a cached copy. At a predetermined time it should create a new cached XML feed.


Solution:

The solution will operate on Windows Servers, developed in ASP.net in C# using SQL Enterprise Server and entity framework.