Newbie Questions

Re: Custom coded C# email button issue

jinh@globaledgesys.com — Thu, 12 Nov 2009 17:43:33 GMT

Hello Hilary,

Once again, thank you for all the helps.

I don't know if this is the best way, but it seems to work for me. Please feel free let me know if you have any better advice.

Here is my code:

public void btnSend_Clicked(object sender, ClickedEventArgs e)

{

// Write your code here.

string valueField1 = null;

string valueField2 = null;

string valueField3 = null;

string valueField4 = null;

//string subject = null;

string bodyTrue = null;

string bodyFalse = null;

XPathNavigator mds = MainDataSource.CreateNavigator();

EmailSubmitConnection escTrue = null;

EmailSubmitConnection escFalse = null;

XPathNodeIterator xi4 = mds.Select("/my:myFields/my:myGroup/my:Field4", NamespaceManager);

foreach (XPathNavigator xn4 in xi4)

{

valueField4 = xn4.Value;

if (valueField4 == "true")

{

escTrue = (EmailSubmitConnection)this.DataConnections["ToHim Email Submit"];

valueField1 = xn4.SelectSingleNode("../my:Field1", NamespaceManager).Value;

valueField2 = xn4.SelectSingleNode("../my:Field2", NamespaceManager).Value;

valueField3 = xn4.SelectSingleNode("../my:Field3", NamespaceManager).Value;

bodyTrue += valueField1 + " " + valueField2 + " " + valueField3 + "\n";

}

if (valueField4 == "false")

{

escFalse = (EmailSubmitConnection)this.DataConnections["ToHer Email Submit"];

valueField1 = xn4.SelectSingleNode("../my:Field1", NamespaceManager).Value;

valueField2 = xn4.SelectSingleNode("../my:Field2", NamespaceManager).Value;

valueField3 = xn4.SelectSingleNode("../my:Field3", NamespaceManager).Value;

bodyFalse += valueField1 + " " + valueField2 + " " + valueField3 + "\n";

}

if (escTrue != null)

{

escTrue.Introduction = bodyTrue;

escTrue.Execute();

}

if (escFalse != null)

{

escFalse.Introduction = bodyFalse;

escFalse.Execute();

}

Re: Custom coded C# email button issue

jinh@globaledgesys.com — Thu, 12 Nov 2009 17:01:55 GMT

Hello again Hilary,

Thank you very much that works!

However, I've decided to make some changes. Instead of just email to the one that's being checked.

I've added another checkbox whish will email to another person, & now it's not working on both.

Here is my code

public void btnSend_Clicked(object sender, ClickedEventArgs e)

{

// Write your code here.

string valueField1 = null;

string valueField2 = null;

string valueField3 = null;

string valueField4 = null;

string valueField5 = null;

//string subject = null;

string body = null;

XPathNavigator mds = MainDataSource.CreateNavigator();

EmailSubmitConnection esc;

XPathNodeIterator xi4 = mds.Select("/my:myFields/my:myGroup/my:Field4", NamespaceManager);

XPathNodeIterator xi5 = mds.Select("/my:myFields/my:myGroup/my:Field5", NamespaceManager);foreach (XPathNavigator xn4 in xi4)

{

valueField4 = xn4.Value;

if (valueField4 == "true")

{

valueField1 = xn4.SelectSingleNode("../my:Field1", NamespaceManager).Value;

valueField2 = xn4.SelectSingleNode("../my:Field2", NamespaceManager).Value;

valueField3 = xn4.SelectSingleNode("../my:Field3", NamespaceManager).Value;body += valueField1 + " " + valueField2 + " " + valueField3 + "\n";

}

foreach (XPathNavigator xn5 in xi5)

{

valueField5 = xn5.Value;

if (valueField5 == "true")

{

valueField1 = xn5.SelectSingleNode("../my:Field1", NamespaceManager).Value;

valueField2 = xn5.SelectSingleNode("../my:Field2", NamespaceManager).Value;

valueField3 = xn5.SelectSingleNode("../my:Field3", NamespaceManager).Value;body += valueField1 + " " + valueField2 + " " + valueField3 + "\n";

}

if (valueField4 == "true")

{

esc = (EmailSubmitConnection)this.DataConnections["ToHim Email Submit"];

esc.Introduction = body;

esc.Execute();

}

if (valueField5 == "true")

{

esc = (EmailSubmitConnection)this.DataConnections["ToHer Email Submit"];

esc.Introduction = body;

esc.Execute();

}

Re: Custom coded C# email button issue

Hilary Stoupa — Thu, 12 Nov 2009 00:37:27 GMT

Well, not quite. You see, you are still using the full xpath, which takes you back to the first item. So instead of this:

valueField1 += xn.SelectSingleNode("/my:myFields/my:myGroup/my:Field1", NamespaceManager).Value + "\n";

You'd want this:

valueField1 += xn.SelectSingleNode("../my:Field1", NamespaceManager).Value + "\n";

Re: Custom coded C# email button issue

jinh@globaledgesys.com — Wed, 11 Nov 2009 23:43:18 GMT

Sorry Hilary,

Would this be what you mean?

public void btnSend_Clicked(object sender, ClickedEventArgs e)

{

// Write your code here.

string valueField1 = null;

string valueField2 = null;

string valueField3 = null;

string subject = null;

string body = null;

XPathNavigator mds = MainDataSource.CreateNavigator();

EmailSubmitConnection esc;

XPathNodeIterator xi = mds.Select("/my:myFields/my:myGroup/my:Field4", NamespaceManager);

foreach (XPathNavigator xn in xi)

{

string valueField4 = xn.Value;if (valueField4 == "true")

{

valueField1 += xn.SelectSingleNode("/my:myFields/my:myGroup/my:Field1", NamespaceManager).Value + "\n";

valueField2 += xn.SelectSingleNode("/my:myFields/my:myGroup/my:Field2", NamespaceManager).Value + "\n";valueField3 += xn.SelectSingleNode("/my:myFields/my:myGroup/my:Field3", NamespaceManager).Value + "\n";

}

//subject = valueField1 + " " + valueField2;

body = valueField1 + "\n" + valueField2 + "\n" + valueField3;esc = (EmailSubmitConnection)this.DataConnections["Email Submit"];

esc.Introduction = body;

esc.Execute();

}

Re: Custom coded C# email button issue

Hilary Stoupa — Wed, 11 Nov 2009 23:31:46 GMT

You are selecting the first row when you use:

mds.SelectSingleNode("/my:myFields/my:myGroup/my:Field1", NamespaceManager).Value

for example. Instead, you could use:

xn.SelectSingleNode("../my:Field1", NamespaceManager).Value

to get the value of Field1 for the same Group instance as the Field4 that is 'True'.

Re: Custom coded C# email button issue

jinh@globaledgesys.com — Wed, 11 Nov 2009 23:13:30 GMT

Hello Hilary!

Thank you for your quick respond!

Here is the code:

using Microsoft.Office.InfoPath;

using System;

using System.Windows.Forms;

using System.Xml;

using System.Xml.XPath;

using mshtml;

namespace TestEmail

{

public partial class FormCode

{

// Member variables are not supported in browser-enabled forms.

// Instead, write and read these values from the FormState

// dictionary using code such as the following:

// private object _memberVariable

// {

// get

// {

// return FormState["_memberVariable"];

// }

// set

// {

// FormState["_memberVariable"] = value;

// }

// NOTE: The following procedure is required by Microsoft Office InfoPath.

// It can be modified using Microsoft Office InfoPath.

public void InternalStartup()

{

((ButtonEvent)EventManager.ControlEvents["btnSend"]).Clicked += new ClickedEventHandler(btnSend_Clicked);

}

public void btnSend_Clicked(object sender, ClickedEventArgs e)

{

// Write your code here.

string valueField1 = null;

string valueField2 = null;

string valueField3 = null;

string body = null;

XPathNavigator mds = MainDataSource.CreateNavigator();

EmailSubmitConnection esc;

XPathNodeIterator xi = mds.Select("/my:myFields/my:myGroup/my:Field4", NamespaceManager);foreach (XPathNavigator xn in xi)

{

string valueField4 = xn.Value;

if (valueField4 == "True")

{

valueField1 += mds.SelectSingleNode("/my:myFields/my:myGroup/my:Field1", NamespaceManager).Value + "\n";

valueField2 += mds.SelectSingleNode("/my:myFields/my:myGroup/my:Field2", NamespaceManager).Value + "\n";

valueField3 += mds.SelectSingleNode("/my:myFields/my:myGroup/my:Field3", NamespaceManager).Value + "\n";

}

body = valueField1 + "\n" + valueField2 + "\n" + valueField3;esc = (EmailSubmitConnection)this.DataConnections["Email Submit"];

esc.Introduction = body;

esc.Execute();

}

Re: Custom coded C# email button issue

Hilary Stoupa — Wed, 11 Nov 2009 21:59:11 GMT

Hi:

Does the button have code on it to do this? Can you post your code?

Custom coded C# email button issue

jinh@globaledgesys.com — Wed, 11 Nov 2009 20:47:50 GMT

Hello All!

Wondering if anyone would be able to help me.

I've a simple form with a repeating table inside, there are only 4 columns.

The last column is a checkbox where if the box is checked, it'll send an email of the data on that row to someone when the button is clicked.

What it's happening right now is that, it only send the 1st row of data when I've about 4 out of 10 rows checked.

Any idea what I'm doing wrong?

Thank you very much in advance!