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

Project spending, Is spending in projects constant throughout the project? ...

Is spending in projects constant throughout the project? Generally in initial stage of projects (design and requirement phase) the cost is very less (as you require maximum bus

Perform arithmetic operations - c# program, Perform Arithmetic Operations -...

Perform Arithmetic Operations - c# Program Hello, i didn't find the correct way of using arithmetic operations in c#. I am beginner for this language. Please suggest me some e

Looking for web designer, Looking for web designer Project Description: ...

Looking for web designer Project Description: I am seeking website designer with developing skills of Html, .Net and also supports in all browsers. Please ping your previous

Hash table, What is a Hash Table? You can access an array using the IND...

What is a Hash Table? You can access an array using the INDEX value of that array, but how many times you know the real value of the index. The Hashtable provides a way of acce

Use of connection object, What is the use of connection object? The con...

What is the use of connection object? The connection objects are used to connect a data to the Command object. 1)An OleDbConnection object is used with the  OLE-DB provider

I need game development tutorials, I need Game development tutorials Pro...

I need Game development tutorials Project Description: We need video tutorials like lynda for game development using unity. You must have developed games before and need to s

What are the benefits of using of ado.net in .net 4.0, What are the benefit...

What are the benefits of using of ADO.NET in .NET 4.0. The following are the benefits of using ADO.NET in .NET 4.0 are as follows: Language-Integrated Query (LINQ) - Adds

Develop a iphone and android mobile game, Develop a iPhone and Android mobi...

Develop a iPhone and Android mobile game Project Description: I am seeking a developer to create a mobile game for me. I need an endless runner game with simple controls. The

Basic methods of data adapter, What are basic methods of Data adapter? ...

What are basic methods of Data adapter? The three most commonly used methods of Dataadapter are as follows:- 1)Fill :- It Executes the SelectCommand to fill the DataSet ob

What are the advantages of dlr, What are the advantages of DLR? The var...

What are the advantages of DLR? The various advantages provided by DLR are: Permits you to easily execute the dynamic languages to the .NET Framework. Gives dynamic featu

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