dll bridge between a .Net accounting program (using an SDK) and VFP9
$100-500 USD
Dibatalkan
Disiarkan hampir 12 tahun yang lalu
$100-500 USD
Dibayar semasa penghantaran
The Sage 200 accounting program ([login to view URL]) is written in .Net and has an SDK, which will be supplied. A .Net 3.5 bridge dll is required, to interface between it and a calling program written in VFP9. (VFP knowledge and knowledge of Sage 200 is advantageous but not essential). The bridge dll will be required to carry out approximately 6 functions.
This initial project will encompass two simple functions only. On satisfactory completion of that, a second project will be raised on a 'pay for time' basis for the remaining functions.
## Deliverables
Sage 200 is written in .Net 3.5 and uses a SQL server database. If required, I will supply (via FTP download), for the duration of the project only, a copy of the Sage 200 database and its SDK. It is assumed that
you will already have available a copy of MS SQL Server 2008.
The Sage 200 SDK uses a series of .Net assemblies that sit on the local PC. The requirement is to interface - bridge - between these local assemblies and a calling VFP9 program. There is no requirement to interface to the SQL database directly.
The requirement is for a COM-enabled dll (that will sit on the local PC) and will perform the following functions:
1) Log on to 200. Calling parameters are the user name, password and company name of the database to be used.
2) Given an 8-character sales account code, return the account details (name and address, contact details, account balance, credit limit and account status).
3) Create a new sales ledger account.
4) Amend name/address/contact details on an existing sales ledger account.
5) Create a multi-item Sales Order
6) Post a Sales Receipt
The initial fixed contract will be for items 1 and 2 in the above list. On satisfactory completion of that stage, a new 'pay for time' based contract will be raised for the remaining four items.
Other things:
a) The project is, unfortunately, very time-constrained. This initial phase will be required to complete in approximately 1 week from go-ahead and the subsequent stages in 2-3 weeks from there. If you don't think you can meet these timescales please don't bid.
b) Your code will need to be well commented.
c) In addition to the normal legal stuff, it is a specific requirement that on completion you will delete Sage 200, its databases and its SDK and help files from your system and will provide confirmation that this has been done.