C#

using System;
using System.Runtime.InteropServices;
using System.IO;
using System.Text;
using System.Data.SqlClient;
using System.Net;



namespace SMSApp
{
    [Guid("694C1820-04B6-4988-928F-FD858B95C880")]
    public interface SendSMSInterface
    {
        [DispId(1)]
        void Init(string userid, string password);
        [DispId(2)]
        bool ExecuteSelectCommand(string selCommand);
        [DispId(3)]
        bool NextRow();
        [DispId(4)]
        void ExecuteNonSelectCommand(string insCommand);
        [DispId(5)]
        string GetColumnData(int pos);
        [DispId(6)]
        string sendMessage(string user, string password, string customer, string cardno, string MobileNo, string CreditPt, string DebitPt, string balancept);
        [DispId(7)]
        string sendSmsFirstTime(string user, string password, string customer, string cardno, string MobileNo, string balancept);

    }

    //interface Database_COMObjectEvents 
    [Guid("47C976E0-C208-4740-AC42-41212D3C34F0"),
    InterfaceType(ComInterfaceType.InterfaceIsIDispatch)]
    public interface DBCOM_Events
    {
    }


    [Guid("9E5E5FB2-219D-4ee7-AB27-E4DBED8E123E"),
    ClassInterface(ClassInterfaceType.None),
    ComSourceInterfaces(typeof(DBCOM_Events))]

    public class SendSMS : SendSMSInterface
    {
        private SqlConnection myConnection = null;
        SqlDataReader myReader = null;

        public SendSMS()
        {
        }

        public void Init(string userid, string password)
        {
            try
            {
                string myConnectString = "user id=" + userid + ";password=" + password +
                    ";Database=NorthWind;Server=SKYWALKER;Connect Timeout=30";
                myConnection = new SqlConnection(myConnectString);
                myConnection.Open();
                //MessageBox.Show("CONNECTED");
            }
            catch (Exception)
            {
                //MessageBox.Show(e.Message);
            }
        }

        public bool ExecuteSelectCommand(string selCommand)
        {
            if (myReader != null)
                myReader.Close();

            SqlCommand myCommand = new SqlCommand(selCommand);
            myCommand.Connection = myConnection;
            myCommand.ExecuteNonQuery();
            myReader = myCommand.ExecuteReader();
            return true;
        }

        public bool NextRow()
        {
            if (!myReader.Read())
            {
                myReader.Close();
                return false;
            }
            return true;
        }

        public string GetColumnData(int pos)
        {
            Object obj = myReader.GetValue(pos);
            if (obj == null) return "";
            return obj.ToString();
        }

        public void ExecuteNonSelectCommand(string insCommand)
        {
            SqlCommand myCommand = new SqlCommand(insCommand, myConnection);
            int retRows = myCommand.ExecuteNonQuery();
        }

        public string sendMessage(string user, string password, string customer, string cardno, string MobileNo, string CreditPt, string DebitPt, string balancept)
        {
            UnicodeEncoding unicode = new UnicodeEncoding();
            string strUrl = "http://api.mVaayoo.com/mvaayooapi/MessageCompose?user=";
            string strUr2 = user + ':' + password;
            string strUr3 = "&senderID=ETHOSW&receipientno=";
            string strUr4 = MobileNo + "&msgtxt=";
            string Strur5 = "Dear " + customer + " , thank u for using ur Club Echo card no. " + cardno + " . " + DebitPt + " Pts dr " + "%26 " + CreditPt + " pts cr to ur card. A/c Bal " + balancept + " pts.";
            string finalurl = strUrl + strUr2 + strUr3 + strUr4 + Strur5;
            WebRequest request = HttpWebRequest.Create(finalurl);
            HttpWebResponse response = (HttpWebResponse)request.GetResponse();
            Stream s = (Stream)response.GetResponseStream();
            StreamReader readStream = new StreamReader(s);
            string dataString = readStream.ReadToEnd();
            string responsemsg = finalurl;
            //response.StatusDescription.ToString(); 

            response.Close();
            s.Close();
            readStream.Close();
            return (responsemsg);

        }

        public string sendSmsFirstTime(string user, string password, string customer, string cardno, string MobileNo, string balancept)
        {
            UnicodeEncoding unicode = new UnicodeEncoding();
            string strUrl = "http://api.mVaayoo.com/mvaayooapi/MessageCompose?user=";
            string strUr2 = user + ':' + password;
            string strUr3 = "&senderID=ETHOSW&receipientno=";
            string strUr4 = MobileNo + "&msgtxt=";
            string Strur5 = "Dear " + customer + " , thank u for shopping with us. Your card no. is " + cardno + " . A/c Bal is " + balancept + " points.";
            string finalurl = strUrl + strUr2 + strUr3 + strUr4 + Strur5;
            WebRequest request = HttpWebRequest.Create(finalurl);
            HttpWebResponse response = (HttpWebResponse)request.GetResponse();
            Stream s = (Stream)response.GetResponseStream();
            StreamReader readStream = new StreamReader(s);
            string dataString = readStream.ReadToEnd();
            string responsemsg = finalurl;

            //response.StatusDescription.ToString(); 

            response.Close();
            s.Close();
            readStream.Close();
            return (responsemsg);

        }