public static string GetMessageTemplate(int clientid, string messagetemplatename, Dictionary <string, string> messagevalues)
        {
            var db     = new MessagesDataContext();
            var result = db.S1_Messages_GetMessageTemplate(clientid, messagetemplatename).SingleOrDefault();

            if (result != null)
            {
                string body = result.MessageText.ToString();

                foreach (var item in messagevalues)
                {
                    body = body.Replace(item.Key, item.Value);
                }

                return(body);
            }
            else
            {
                return(null);
            }
        }