C# webservice required to sync data
$30-5000 USD
着払い
I need you to provide a client app and a webservice that will allow me to sync my local SQL Server CE database with a SQL Server database.
The client app will:
1. Connect to a local SQL Server CE database located on the C drive
2. Attempt to connect to? the new? webservice.
3. If successful will? go through some authentication (i.e. we do not want anyone uploading!)
4. If successful it will send this timesheet data:
- ProjectID? int?
- TaskID? int?
- StartTime? datetime?
- EndTime? datetime?
- LastUpdate? datetime?
- Notes? nvarchar? 50
- TimeID? int?
- Status? bit?
- Minutes? int?
- Source? nchar? 1
- Charge? float?
-? CheckSum? nvarchar? 50
5. Will update a column called LastSynced datetime with the current date/time for all successfully synced entries.
The webservice will:
1. Allow client applications to connect and authenticated
2.? Accept the timesheet data and save that data to a SQL Server 2008 database table.
3. Return results so that the client app can mark the appropriate rows as synced.
Note: From there I can write a stored procedure to import it.
I am not familiar with webservices so I am not sure about the terminology etc.
プロジェクトID: #2690014