public int VoicingMessageCount(string id)
 {
     Message message = new Message();
     try
     {
         using (MySqlConnection db = new MySqlConnection(Database.ReminderConnection))
         {
             string query =
                 "select id from messages "
                 + " where id = @id";
             message = db.Query<Message>(query, new { @id = id }).SingleOrDefault();
             //message = db.Query<Message>(query, new { @id = 25 }).SingleOrDefault();
             if (message != null)
             {
                 return message.ID;
             }
             else
             {
                 return 0;
             }
         }
     }
     catch (Exception er)
     {
         Log.LogMessage(er.ToString());
         return 0;
     }
 }
 public Message Get(string id)
 {
     Database.ReminderConnection = ConfigurationManager.AppSettings["reminderConnection"];
     Message message = new Message();
     message = messaging.GetMessage(id);
     return message;
 }
 public Message GetMessage(string id)
 {
     Message message = new Message();
     try
     {
         using (MySqlConnection db = new MySqlConnection(Database.ReminderConnection))
         {
             //Select records that have not been completed
             string query = " select message_id as MessageID,message_name as MessageName,"
                 + " message as MessageText"
                 + " from messages"
                 + " where id = @id";
             message = db.Query<Message>(query, new { @id = id }).Single();
             return message;
         }
     }
     catch (Exception er)
     {
         Log.LogMessage(er.ToString());
         return message;
     }
 }
 public Message Get(string id)
 {
     Message message = new Message();
     message = messaging.GetMessage(id);
     return message;
 }