コード例 #1
0
        public SMSMessage MessageHandler(string From, string Body)
        {
            SMSMessage message = new SMSMessage();

            message.message_in  = Body;
            message.message_out = ReverseIt(Body).ToString();
            message.Timestamp   = DateTime.Now;

            var accountSid = "ACa3955b3a8072e7e0d5efd4e181ccd729";
            var authToken  = "4c9c9b0f6095d2954cfaec8aa48e28c2";

            TwilioClient.Init(accountSid, authToken);


            try
            {
                var SMS = MessageResource.Create(to: new PhoneNumber(From), from: new PhoneNumber("+15873295321"), body: message.message_out);
                return(message);
            }
            catch (ApiException ex)
            {
                Console.WriteLine(ex.Message);
                return(null);
            }
        }
コード例 #2
0
        public List <SMSMessage> GetMessages()
        {
            List <SMSMessage> messages = new List <SMSMessage>();

            string myConnectionString;

            myConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["symendsMySQL"].ConnectionString;

            MySqlConnection conn = null;

            try
            {
                conn = new MySqlConnection(myConnectionString);
                conn.Open();

                MySqlCommand cmd = new MySqlCommand();
                cmd.Connection = conn;

                cmd.CommandText = "SELECT id, message_in, message_out, Timestamp FROM messages";

                cmd.Prepare();

                MySqlDataReader reader = cmd.ExecuteReader();

                while (reader.Read())
                {
                    SMSMessage message = new SMSMessage();
                    message.id          = reader.GetInt32(0);
                    message.message_in  = reader.GetString(1);
                    message.message_out = reader.GetString(2);
                    message.Timestamp   = reader.GetDateTime(3);

                    messages.Add(message);
                }
            }

            catch (MySqlException ex)
            {
                Console.WriteLine("Error: {0}", ex.ToString());
            }

            finally
            {
                if (conn != null)
                {
                    conn.Close();
                }
            }

            return(messages);
        }
コード例 #3
0
        public bool SaveMessage(SMSMessage message)
        {
            string myConnectionString;

            myConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["symendsMySQL"].ConnectionString;

            MySqlConnection conn = null;

            try
            {
                conn = new MySqlConnection(myConnectionString);
                conn.Open();

                MySqlCommand cmd = new MySqlCommand();
                cmd.Connection = conn;

                cmd.CommandText += string.Format("INSERT INTO messages (message_in, message_out, Timestamp)  VALUES (@message_in, @message_out, @Timestamp);");
                cmd.Parameters.AddWithValue("@message_in", message.message_in);
                cmd.Parameters.AddWithValue("@message_out", message.message_out);
                cmd.Parameters.AddWithValue("@Timestamp", message.Timestamp);

                Console.WriteLine("Executing insert.... this could take a second.");

                try
                {
                    cmd.ExecuteNonQuery();
                    return(true);
                }
                catch (MySqlException ex)
                {
                    Console.WriteLine("Error: {0}", ex.ToString());
                    return(false);
                }
            }

            catch (MySqlException ex)
            {
                Console.WriteLine("Error: {0}", ex.ToString());
                return(false);
            }

            finally
            {
                if (conn != null)
                {
                    conn.Close();
                }
            }
        }
コード例 #4
0
        public void ProcessMessage(Stream TwilioResponse)
        {
            //Lets open our plaintext stream test
            StreamReader messageReader = new StreamReader(TwilioResponse);
            String       rawBody       = messageReader.ReadToEnd();

            NameValueCollection qs = HttpUtility.ParseQueryString(rawBody);
            string From            = qs["From"];
            string Body            = qs["Body"];

            WebOperationContext.Current.OutgoingRequest.Accept = "text/xml";
            WebOperationContext.Current.OutgoingResponse.Headers.Add("Access-Control-Allow-Origin", "*");

            ProcessMessage messageHandler = new ProcessMessage();

            SMSMessage SMSMessage = messageHandler.MessageHandler(From, Body);

            if (SMSMessage != null)
            {
                SaveToDatabase saveMessage = new SaveToDatabase();

                saveMessage.SaveMessage(SMSMessage);
            }
        }