/* ***** General Information ***** Creator: coresystems software USA, laja Create Date: 2012 07 10   ***** StartConfDesc ***** If the BP email address is not present when generating a marketing document, then advise to add and don't add document. ***** EndConfDesc *****   ***** Updates ***** YYYY-MM-DD, name: Update Comment */ string ruleName = pVal.RuleInfo.RuleName.ToString(); string errorMessage = "Error in [Optimizer Rule] '" + ruleName + "'"; try { string CardNumber = TextEdit.GetFromUID(pVal.Form, "4").Value; string mySQL = "SELECT TOP 1 COALESCE(E_Mail,'') FROM OCRD WHERE CardCode='" + CardNumber + "'"; string myEmail = LayoutHelper.LD.QueryData(mySQL); string myRegex = @"^[\w!#$%&'*+\-/=?\^_`{|}~]+(\.[\w!#$%&'*+\-/=?\^_`{|}~]+)*" + "@" + @"((([\-\w]+\.)+[a-zA-Z]{2,4})|(([0-9]{1,3}\.){3}[0-9]{1,3}))$"; bool validEmail = System.Text.RegularExpressions.Regex.IsMatch( myEmail, myRegex, System.Text.RegularExpressions.RegexOptions.IgnoreCase); if (!validEmail) { MessageBox.Show("Please define an email address in the BP record", "OK"); return false; } } catch(System.Exception ex) { MessageBox.Show(errorMessage + ": \n" + ex.Message, "OK"); StatusBar.WriteError(errorMessage + ": " + ex.Message); Debug.WriteMessage(errorMessage + ": " + ex.Message, Debug.DebugLevel.Exception); } return true;