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); } }