jueves, 14 de junio de 2012 11:10
Currently i'm working on Core banking project, it use ASP.Net with C# as front-end and MS SQL Server as Back-end. actually i am facing a problem in project that i want to send SMS to the customer when they will do any kind of transaction like Credit/Debit.
in this project when customer do any kind of transcation it is not inserted into table untill officer is not confirm the records, onces the officer is confirm individal transcation or bunch of transcation after that sms send to the bank Customer.i getting confuse how to send SMS From MS Sql Server 2008 to mobile phone, pl help me to do this either using Store procedure or Triggers Waiting for reply.
- Editado Harshal Vadnere jueves, 14 de junio de 2012 11:11
Todas las respuestas
lunes, 18 de junio de 2012 1:27
We also send sms alerts to customers for their bills.
what we do
1. insert all the data with mobile_no into a table to whom you want to send sms.
2. we will email all the mobile nos to one third party mail address who transmit them to customers
you can add a columns 'status' and 'mobileno' to the table to which you adds data of customer.
is status = 'new' then do nothing
status = 'confirm' then send the mobile no to the sms provider from where you can send sms and change status = 'sent'
status = 'sent' then do nothing