Budget is set low, I am not expecting to pay that for the page. Please read the brief and give me a price based on what you need to charge for the job, and only bid if you have the skills needed for the job. I'm sure this is simple for the right person. I will not be responding to folks simply agreeing to my guide price and replying with an AI generated response.
Purpose of this process: We have an MS Access database application which remote users have installed. Each day as part of its automated daily routine, I would like it to send a usage snapshot to our web server so we can calculate the site's support costs. I have a CURL routine in the database for something else which can be recycled, so ideally want to POST a request to our web server as an authorised user with an encrypted string via JSON, string before encryption will be something like:
Example Data: "¬BranchName: Bob Smith;¬Users:9;¬Clients:53;¬ModCore:-1;¬ModKeys:-1;¬ModLW:-1;¬ErrorCount:23;"
user: MyLocalUsername pass: MyLocalPassword nonce: MyCalculatedNonce mystring: Encrypted string containing the data above (we use the WeOnlyDo library to encrypt using a 16 character key and a 16 character calculated iv/nonce)
When the request is received on our server, I would like the web page to authorise the user against a table on our database, and if the user exists I would like it to UPDATE the client table on our back end database with the details received, create a log entry in our dailylog table, and then encrypt and return a resulting value back to the client's database which is made up of a string - a typical example of the unencrypted version is : "ln:My Branch Name;LED:2035-03-13;seats:99;mg:9999;ms:9999;modcore:-1;modkh:-1;modlw:-1;modhw:-1;modsql:-1;sus:0;"
It's the ASP side that I don't fully understand. I would like it coded in vb so I at least have a chance of understanding it and maintaining minor updates moving forwards once it's done.
I would like an error handler included so if there is an issue with the data being sent through, an email is sent to an administration email address using an SMTP server on the same network. I would like well-annotated code so I can understand what it is doing.
Server is running IIS10 and the .net framework v4.0.x. The server-side database is a 32 bit MS Access accdb file. This will essentially be a one-page website with only this function. If the page is accessed in any way other than through a request, I'd like it to throw a 405 error.
Link to WOD library: https://www.weonlydo.com/Crypt/aes-rsa-dsa-component.asp