I have an existing Ecommerce Store running NopCommerce. I need to have a program that has the following features:
a) Set SQL Server Host Name / Username / Password and perform connection Test
b) Set Output Directory
c) Set certain optional data fields (I can provide these details later)
2) Main Application
a) Runs in the background (no GUI). We will use Windows Task Scheduler to start this application
b) Runs a SQL Query against the NOPCommerce server to obtain order information
c) Outputs a fixed file format
In my mind, this type of project would take eight to ten hours to do by someone skilled. Therefore, I have set the project to be a "simple project" Upon project award, I can provide a sample NOPCommerce Database and the output file specifications.
Also any errors about the application (such as no connection to SQL) should be posted in the Windows Event Log.
5 pekerja bebas membida secara purata $204 untuk pekerjaan ini
So you need a program to execute some certain SQL, to query data from a MS SQL SERVER, and output it in a certain format. I'm a new freelancer, but I have a good experience in C# programing for 4 years.