public bool UpdateTemplate(Common.EmailTemplate emailTemplate)
 {
     return(ExecuteSPCommand("UpdateTemplate",
                             "@Guid", emailTemplate.EmailTemplateGuid,
                             "@Subject", emailTemplate.Subject,
                             "@Body", emailTemplate.Body,
                             "@AttachmentList", emailTemplate.AttachmentList,
                             "UserEmailSettingGuid", emailTemplate.UserEmailSettingGuid));
 }
        public Guid InsertTemplate(Common.EmailTemplate emailTemplate)
        {
            Guid guid = Guid.NewGuid();

            try
            {
                ExecuteSPCommand("InsertTemplate", "@UserEmailSettingGuid", emailTemplate.UserEmailSettingGuid,
                                 "@Guid", guid,
                                 "@Subject", emailTemplate.Subject,
                                 "@Body", emailTemplate.Body,
                                 "@CreateDate", emailTemplate.CreateDate,
                                 "@AttachmentList", emailTemplate.AttachmentList);
                return(guid);
            }
            catch
            {
                guid = Guid.Empty;
                return(guid);
            }
        }