public static S1_Messages_GetMessageTemplateRecordResult GetMessageTemplateRecord(int clientid, string messagetemplatename, Dictionary <string, string> messagevalues) { var db = new MessagesDataContext(); var result = db.S1_Messages_GetMessageTemplateRecord(clientid, messagetemplatename).SingleOrDefault(); if (result != null) { string body = result.MessageText; foreach (var item in messagevalues) { body = body.Replace(item.Key, item.Value); } result.MessageText = body; return(result); } else { return(null); } }