Want a database management app, DOT NET Programming

Assignment Help:

Project Description:

Overview:

Prepare Windows program that runs in the background and on start up on the client's computer that grabs CERTAIN data from a.SDF file (SQL ServerCE 3.5 File) and saves it on our web server. Prepare a second Windows program on our machines that retrieves the data described above and ADDS it to the .SDF file.

Details of design:

Three terms:

1) Client = client machine (Windows),

2) FTP = Web server,

3) Server = Our local machine(s) (Windows).

The Windows program on the client's computer has an input for First Name, Last Name and Password and email address connected with it. Client will input this data on install or by accessing program from tray. The client SQL file will have data under the heading SIM101. This field will eventually be changed to the client name and password in the subsequent format (Last Name+Password+ FirstName) on the Server machine. At the suitable times and if there is a change from the last time a file was written, Client uploads it to FTP (address as specified in an ftp file). Client program runs in the background and on startup on the client machine and otherwise needs no user management. There is a button for the client to hide it and there are controls in the tray to make it show or to exit.

If new files are present, Server downloads client files and integrates them into SQLServer3.5CE DB. Only relevant data is transferred connected with the Sim101 key on Client and the data associated with that key is integrated into Server DB in the proper format but on the Server it is labeled with the above provided client name instead of Sim101. Server control has an input for where the .SDF file is kept. Compression will be used if relevant. No FTP information will be viewed on Client machine. As mentioned, there is a file on FTP that specify the ftp address and password for all clients.

The above transfer will occur every day starting at the specified times. There is a server side file that specifies the interval and/or the end time (specified in Eastern Time). For example, the transfer can occur starting at 930 AM Eastern Time and additionally at 30 minute intervals until the end time which is the final upload for the day. If it seems the files are large which they possibly will not be, then set the intervals to the user's log in time instead of clock intervals (i.e. 30 min after the hour). In order that clients do not all send files to FTP at the similar time, the transfers will occur off a slightly random time on the client.

There is never more than one file for each client on the ftp. Only the most recent, so old files can be removed. Further, the client may only send a file to ftp if there has been a change since the last file was written. On the server: If the file is found to be smaller than preceding uploads, then a line is appended to a server side file that indicates the date and time, Last Name+FirstName+Password, and the words "File is Smaller" On the Server: Scan the file nt_order column labeled "filled" for any values > a particular amount (default to 1). If any value in this column exceeds the default level then a line is appended to a server side file that shows the date and time, Last Name+FirstName+Password, email (live link) and the words "Contracts Exceeds Default of [+ Default Value].

The above can be done for any number of clients. For example we expect to be able to handle as many as 200 clients and ideally we will only have client send data once per day as specified in the FTP located file. This defaults to 1630 Eastern Time.

The resulting SQL ServerCE 3.5_File on the Server machine can be organized in such a way that it will be read by NinjaTrader. NinjaTrader is the program that created the original files and is the program that will read the appended files.

Client can use a Windows installer and will have a license we will provide in the installation procedure. Code will work on any windows machine.

Skills required are .NET, C# Programming, Software Architecture, XML, Windows Server


Related Discussions:- Want a database management app

Online portal for hotel n holidays, Project Description: It is online po...

Project Description: It is online portal for hotel n packages sales. The project requires to be built on sql, Jquery and c#. The project should be submitted with all coding a

I want a sportsbook platform, Project Description: We want to design and...

Project Description: We want to design and develop a new Sportbook Platform from scratch, subsequent functionality: - Have a full functionality like other similar websites (S

I need some a vba expert urgent, I need some a VBA expert urgent Project...

I need some a VBA expert urgent Project Description: I require a VBA expert for scraping data from internet. .NET, Excel, Data Processing, Visual Basic

Create page website to catalog some of the music, Create page website to ca...

Create page website to catalog some of the music: A homepage:  that automatically comes up when you go to 127.0.0.1:3000 (instead of the default Ruby-on-Rails pa

Wfp and windows hook drivers expert required, WFP and windows hook drivers ...

WFP and windows hook drivers expert required Project Description: I want a class which will have a function to block a particular url. I want this to be done using Windows

It governance definition, IT governance defined In this section, a shor...

IT governance defined In this section, a short literature survey will be conducted. The results will be presented in a final comparative table. Before starting defining IT gove

What is adrotator scheduler, Question: (a) List and describe the four ...

Question: (a) List and describe the four parameters contained in the second section of the AdRotator Scheduler File. (b) Distinguish between the following types of "Locks"

Design patterns, What are design patterns? The Design patterns are recu...

What are design patterns? The Design patterns are recurring solution to the recurring problems in the software architecture. There are 3 basic classification of patterns Behavi

Auto trading software for nse, Project Description: Step 1: Buy 1 sha...

Project Description: Step 1: Buy 1 share at existing market price (ex: buy 1 at 100.00) If 4 points profit then close position if not go to step 2 Step 2: if 2 point

Windows 8.1 project - asset management slate app, I need Windows 8.1 Projec...

I need Windows 8.1 Project, Asset management slate App Project Description: We are seeking a Windows 8 app developer with PROVABLE experience to prepare a project and asset m

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd