The solution needed is a SQL Server 2008 table/trigger/proc that sends an SMS using the Clickatell API ([login to view URL]) each time data is inserted into the table. Data will contain phone number and the message. System needs to be robust and able to handle large volumes of data
Here is some code I found in internet which is pretty much is the start of what I want. Please use HTTP/S API not the COM Object. Also, I don't think cursors are a good idea for performance reasons.
[login to view URL]
Here is the Clickatell documentation for HTTP/S API:
[login to view URL]
I also require the following features:
1) Record any errors that are generated by the Clickatell gateway during a validation phase
before message is accepted by Clickatell. Refer to Appendix A: Error codes
2) Record the message statuses that are generated after the Clickatell gateway has accepted the message
for delivery. Refer to Appendix B: Message statuses
3) Use a Clickatell Callback URL using an HTTP GET so that Clickatell posts message status updates to our application via means of a Callback URL. Detailed information can be found in the “Callback URL” section under “Message parameters”. Please pass user id and password pamameters and use authentication in a C# callback function. Also require that the database be updated with the message status information received in the callback.
I think this is very clear, but contact me if you have any ideas or questions
Hi,
I understand your requirements and propose the below
develop the solution using dotNet, making use of SQL dependencies. Log the status of the call to the backend(sql2008). Callback url would be a webservice exposed which again is written in C#(.Net).
About us:
We are a bunch of professional programmers to the core. We have developer a variety of web application ranging from simple shopping carts to enterprise applications. We also have developed a number of web services in .Net. We will be providing a kind of technical documentation and then proceeding things further.
$50 USD dalam 10 hari
5.0 (1 ulasan)
1.4
1.4
20 pekerja bebas membida secara purata $311 USD untuk pekerjaan ini
Hi
Thank you for asked me to Bid.
I have gone through the documentation and mssql code. We shall do this in the way you have asked. But I think there are some different ways instead of using SP and Mssql, such as using asp.net api or php apis. But you may think about it and PM me.
Hi,
I have read the description.
I give the approximate time and bid.
I will send you the resolution after I read the Clickatell_HTTP.PDF.
thianks!
Leslie
Hi
Iam MCAD,MCSD in .NET with over 5yrs of expericence.I have already designed such system for one of my client too.. For further details please go through the PM.
Regards
Vikas