public static void NewImportInvite() { SqlCommand command = null; SqlCommand command2 = null; SqlDataAdapter dataAdapter = null; SqlDataAdapter dataAdapter2 = null; DataSet ds = null; DataSet dsDel = null; //try { SqlTriggerContext triggContext = SqlContext.TriggerContext; switch (triggContext.TriggerAction) { case TriggerAction.Update: using (SqlConnection connection = new SqlConnection(@"context connection=true")) { connection.Open(); command = new SqlCommand(@"SELECT * FROM INSERTED;", connection); dataAdapter = new SqlDataAdapter(command); ds = new DataSet(); dataAdapter.Fill(ds); //Populate data from the inserted row DataRow updatedRow = ds.Tables[0].Rows[0]; DataColumnCollection updatedColumns = ds.Tables[0].Columns; command2 = new SqlCommand(@"SELECT * FROM DELETED;", connection); dataAdapter2 = new SqlDataAdapter(command2); dsDel = new DataSet(); dataAdapter2.Fill(dsDel); //Populate data from the inserted row DataRow deletedRow = dsDel.Tables[0].Rows[0]; DataColumnCollection deletedColumns = dsDel.Tables[0].Columns; if (((int)deletedRow["InviteState"] == (int)updatedRow["InviteState"]) || ((int)updatedRow["InviteState"] != 2)) { return; } int MemberID = (int)updatedRow["ImporterMemberID"]; string TargetEmailAddress = (string)updatedRow["Email"]; Member sendingMember = Member.GetMemberByMemberID(MemberID, connection); string ReferralString1 = InsertInviteClick(updatedRow, sendingMember, "/signup", connection); //Referral.Encrypt(ReferrerType.ContactImportID, (int)updatedRow["ContactImportID"], "/signup"); string ReferralString2 = InsertInviteClick(updatedRow, sendingMember, "/users/" + sendingMember.NickName, connection); //Referral.Encrypt(ReferrerType.ContactImportID, (int)updatedRow["ContactImportID"], "/users/" + sendingMember.NickName); //ReferralString1 = ReferralString1.Replace(@"/", "xxyyxx12345"); //ReferralString1 = ReferralString1.Replace(@"\", "12345xxyyxx"); //ReferralString2 = ReferralString2.Replace(@"/", "xxyyxx12345"); //ReferralString2 = ReferralString2.Replace(@"\", "12345xxyyxx"); string subject = Templates.NewImportInviteSubject; string body = Templates.NewImportInviteBody; subject = MergeHelper.GenericMerge(subject, updatedRow.Table.Columns, updatedRow); body = MergeHelper.GenericMerge(body, updatedRow.Table.Columns, updatedRow); subject = MergeHelper.MergeMemberInfo(subject, sendingMember); body = MergeHelper.MergeMemberInfo(body, sendingMember); body = MergeHelper.MergeReferral(body, 1, Utility.UrlEncode(ReferralString1)); body = MergeHelper.MergeReferral(body, 2, Utility.UrlEncode(ReferralString2)); MailHelper.SendEmail(TargetEmailAddress, subject, body); } break; } } //catch { } //finally { try { if (command != null) { command.Dispose(); } if (ds != null) { ds.Dispose(); } if (dataAdapter != null) { dataAdapter.Dispose(); } } catch { } } }