The second phase of the software will add on to the completed software designed from the Rent-a-Coder bid. In the first RAC bid, the software created is for sports card inventory purposes. A user is able to download sports card data from the website web services (choosing which cards they want to download), increase quanities and add notes for individual cards, then upload the manipulated data back to the website for everyone to see. There are features in the already-completed software that allow for fast adding of cards. The software is working by itself as we speak. The user must purchase a subscription to gain access to download the data for the software.
This phase will include three areas of development:
- Registration key generator
- Paypal payment script
- Registration key portion of software
- Misc changes to source code (changes to look/feel)
The program will be able to be downloaded as a "trial" version. Here are the theoretical bundles:
Possible software bundles
- Software key + 1 month updates
- Software key + 3 months updates
Possible subscription renewals
- 1 month
- 3 months
The Paypal payment script portion will accept payments through the website for the bundles above. The script should make use of Paypal’s IPN code. The script will, upon successful transfer of funds and notification from the IPN, activate the registration key generator or update the user database (explained below). The user will need to be logged into the website prior to initiating payment (registration system is complete, but may need revisions as by coder). Continued below...
Continued from above:
The registration key generator should be a server-side script that generates keys upon a successful Paypal payment. This script would need to be accessible by proper website administrators in case of program failure or marketing giveaway. These keys are to be unique, as the key will only be used once. The keys will be linked to the bundle the user purchased. For example, if a user bought the 3 month bundle on 9/1/03, the ability to download updates would expire 90 days from that date. The effective date of the subscription and the subscription length will be kept in the user database on the website. The database will also be updated upon subscription renewal, noting a new expiration date. The current database makes use of an "IsSubscriptionValid" field (0,1). The server and the software will need to be changed to a Date/Time field to reflect the above description.
The registration key portion of the software will allow the user to enter their key (which has conveniently been emailed to them) inside the software and unlock the downloading capabilities. Upon the initial download of the software, the user is only able to download 3 sets (this feature needs to be implemented too). The key they enter will unlock this limit. This should be located by going to About.../Register... in the software’s menu bar. The key will simply unlock the download limit, but then must check the user’s subscription information in the online database to see if they are allowed to download updates (the "Expiration Date" field described earlier).
The misc changes to the software include the following:
- map a double click of a row to open "add card" form
- check local data against online database for changes in software
- take out already downloaded data from the to-be-downloaded data
- progress bars on connecting/downloading/uploading windows
**CODER _*MUST*_ BE FROM THE *_UNITED STATES_* AND MUST BE AVAILABLE 2-3 TIMES PER WEEK TO DISCUSS PROJECT(preferably online chats with AOL/MSN/etc)**
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
The user has a local version of SQL Server (MSDE I believe) installed to store data. The source code available was written with Visual Studio .NET with the .NET Framework (v1.1). More specifically, VB.NET. It also makes use of SQL Server 2000 online and local databases (MSDE). Source code of installer is also available (Install Shield Developer 8, SP2).
Software runs well on:
Windows 95/98/98SE/NT/2000/XP w/ .NET Framework v1.1