I need a small app that can be installed and connect to a sql express db.
The app will run a predefined query and email the results as an embedded table in an email to a user.
The query needs to accept several variables.
The app should have its down db to store:
a) recurring reports table: queries to be run, variables to run the queries, email address of recipients and frequency to email.
b) settings table: email server sign in info and data needed to connect to sqlserver db for related query data
c) log of reports sent
An example use case:
Each of our users receives survey ratings throughout the day. In the report table, we would provide the query text (it would likely include some sort of placeholder variables), the userID#, user email address, daily frequency, getdate() and user email. The query would be run filtering for items received for that user ID and the getdate() data. Those results would be emailed to the user email address as a table embedded in the email. In terms of scale, i would expect the data being emailed is between 0-20 rows per user per day. There are approx 10 users which will be setup to receive reports.
Deliverables will include all code in visual studio which can be reviewed and compiled. We will also need an installer. This should run as a system service in windows server.
50% milestone on proof of concept (remote session showing it working on your machine or sending of code to be compiled) and 50% upon successful testing of application.