Completed

automatically email results of sql query periodically

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.

Skills: C# Programming, SQL, Microsoft SQL Server, Software Architecture

About the Employer:
( 20 reviews ) city, United States

Project ID: #32762676

Awarded to:

HajiAhmad

As we agreed on the terms please assign me the task so that I can complete it. Thank you Haji Ahmad Khan

$250 USD in 7 days
(21 Reviews)
5.5

9 freelancers are bidding on average $213 for this job

(433 Reviews)
8.1
(99 Reviews)
6.7
apgrl123

I CAN COMPLETE YOUR PROJECT EASILY Hello, I am programmer with enough experiences on C#/.NET for 10+ years. C#/.NET is nice programming language and I am majoring on it for long years so I have confident to complete yo More

$200 USD in 7 days
(12 Reviews)
5.3
mihhailovajulia5

Hello. I have read your description very carefully and I can complete it perfectly in short time. I am confident in my skills and always value for client's trust. So I have rich experience in these fields. I can use th More

$140 USD in 7 days
(5 Reviews)
4.6
eagleeyesvw

Hi, Based on your requirements, i will fulfill all the tasks required by you. I am a c# .net expert with many projects in my profile. professional expertise in sql server database. Please discuss on chat you can c More

$250 USD in 15 days
(61 Reviews)
4.7
Muhammadsamran

Hello Sir/ Ma’am A skilled full stack developer, I have rich experience in JAVA,C, C++, C#, Python, .NET , MYSQL, SQL, IONIC , MATLAB,PHP and ARDUINO. I am very confident with my skills and I'd like to help your bu More

$40 USD in 7 days
(13 Reviews)
4.8
umairkaramat24

Hello sir how are you doing? I have read the project detail and really interested in your project, I am full stack developer with multiple frameworks, I have great experience doing similar jobs regarding to these skill More

$250 USD in 14 days
(7 Reviews)
3.4
tohamelnik

Dear client! At first, I wish you the best of luck in everything. I am honored to be contacted with you. I've just read your project description carefully and got interested this project because it fits on my skills. I More

$100 USD in 3 days
(0 Reviews)
0.0