protected void SendConfirmation(string strMembershipID, string strMembershipName, string strEmail) { int nEdmId = 71; string tmp_strEncryptionKey = ""; string tmp_strSubject = ""; string tmp_strContent = ""; string tmp_strSender = ""; Random rnd = new Random(); DateTime dtToday = DateTime.Today; string dtExpiryDate = String.Format("{0:MMM d, yyyy}", dtToday.AddMonths(1)); //Blast the email consent to the leads if email is not null if (strEmail.Trim() != "" && IsEmailValid(strEmail.ToLower())) { DataTable dtEdmContent = new DataTable(); TblMember myMember = new TblMember(); dtEdmContent = myMember.GetMemberConfirmationEmail(); if (dtEdmContent.Rows.Count > 0) { foreach (DataRow rs in dtEdmContent.Rows) { tmp_strSender = rs["strSender"].ToString().Trim(); tmp_strSubject = rs["strSubject"].ToString().Trim(); tmp_strContent = rs["strContent"].ToString().Trim(); } } dtEdmContent.Dispose(); //nEdmId = myContacts.CreateNewEdm(tmp_strSender, tmp_strSubject, tmp_strContent, 1, 9, "L"); //Insert Into DB string tmp_strMembershipID = strMembershipID.ToString(); string tmp_strMemberName = strMembershipName; //Generate random order number 1-5 int tmp_nOrder = GetRandomOrderNo(rnd); string tmp_strDate = GetToday(); //Generate Encryption Key, status = 0 tmp_strEncryptionKey = GetEncryptionKey(nEdmId, tmp_strMembershipID, strEmail.Trim(), tmp_strDate); //Need to check if email has been sent - from logs if (!IsDuplicatedSubmission(tmp_strMembershipID, strEmail.Trim(), nEdmId, tmp_strEncryptionKey)) { //Send Email SendEDM(StrMembershipID, tmp_strMemberName.ToUpper(), dtExpiryDate, strEmail, tmp_strSender, tmp_strSubject, tmp_strContent, nEdmId.ToString(), tmp_strEncryptionKey); InsertEmailSendingLog(strEmail.Trim(), nEdmId, tmp_strMembershipID, tmp_strMemberName, tmp_strDate, tmp_strEncryptionKey, "M"); MessageBox.Show("Email sent"); } } }