Code

Re: Date Calculation in a Repeating Table

whapakk — Thu, 20 Oct 2005 01:13:18 GMT

Nice! Works great, thanks Franck!

quote:
Practice makes perfect, but then, nobody's perfect. So, why practice?

Re: Date Calculation in a Repeating Table

franck — Mon, 17 Oct 2005 14:22:52 GMT

Sorry, read your post too fast..

Try in your SyncDifference:
IXMLDOMNode oN = e.Site.selectSingleNode( ".." );
IXMLDOMNode date1Node = oN.selectSingleNode( "my:ResourceStartDate" );
IXMLDOMNode date2Node = oN.selectSingleNode( "my:ResourceReleaseDate" );
IXMLDOMNode diffNode = oN.selectSingleNode( "my:ManDays" );

Franck Dauché

Re: Date Calculation in a Repeating Table

whapakk — Mon, 17 Oct 2005 13:18:49 GMT

Hi Franck!

I already changed my code to what you suggested, but the field still doesn't change. I might be doing something wrong. Here's what I did

private void SyncDifference(DataDOMEvent e)

{
IXMLDOMNode date1Node = e.Source.selectSingleNode( "my:ResourceStartDate" );
IXMLDOMNode date2Node = e.Source.selectSingleNode( "my:ResourceReleaseDate" );
IXMLDOMNode diffNode = e.Source.selectSingleNode( "my:ManDays" );

if( date1Node != null && date2Node != null && diffNode != null )
{
try
{
DateTime dt1 = Iso8601ToDate( date1Node.text );
DateTime dt2 = Iso8601ToDate( date2Node.text );

TimeSpan ts = dt2 - dt1;
diffNode.text = ts.Days.ToString();
}
catch( FormatException ) {}
}
}

private static DateTime Iso8601ToDate( string iso8601Date )
{
if( iso8601Date == null )
throw new ArgumentNullException( "iso8601Date" );
return DateTime.ParseExact( iso8601Date, "yyyy-MM-dd", null );
}
private static string DateToIso8601( DateTime dateTime )
{
return dateTime.ToString( "yyyy-MM-dd" );
}

[InfoPathEventHandler(MatchPath="/my:ServiceOrder/my:ResourceRequirementDetails/my:Items/my:ResourceStartDate", EventType=InfoPathEventType.OnAfterChange)]
public void ResourceStartDate_OnAfterChange(DataDOMEvent e)
{

if (e.IsUndoRedo)
{
return;

}
SyncDifference(e);
}

[InfoPathEventHandler(MatchPath="/my:ServiceOrder/my:ResourceRequirementDetails/my:Items/my:ResourceReleaseDate", EventType=InfoPathEventType.OnAfterChange)]
public void ResourceReleaseDate_OnAfterChange(DataDOMEvent e)
{
if (e.IsUndoRedo)
{
return;
}

SyncDifference(e);
}

quote:
Practice makes perfect, but then, nobody's perfect. So, why practice?

Re: Date Calculation in a Repeating Table

franck — Mon, 17 Oct 2005 13:07:38 GMT

Hi,

For repeating sections, pass you event e to SyncDifference() and to get to date1Node, date2Node and diffNode, use: e.Source.selectSingleNode("my:fieldName");

Hope that it heps.

Regards,

Franck Dauché

Date Calculation in a Repeating Table

whapakk — Mon, 17 Oct 2005 12:48:21 GMT

Hi, I have a repeating section that has a date picker for the 'Start' and 'End' dates. It also has a field that computes for the difference in days between the two dates. I found an article that shows how to do date calculations at this site,

http://blogs.msdn.com/infopath/archive/2005/01/25/360318.aspx

It works for fields that are not repeating. But for my repeating table, nothing happens to the 'ManDays' field. Even after trying relative paths. Here's a snippet of my code. Using managed code,

// Date calculations for man days
private static DateTime Iso8601ToDate( string iso8601Date )
{
if( iso8601Date == null )
throw new ArgumentNullException( "iso8601Date" );
return DateTime.ParseExact( iso8601Date, "yyyy-MM-dd", null );
}
private static string DateToIso8601( DateTime dateTime )
{
return dateTime.ToString( "yyyy-MM-dd" );
}

[InfoPathEventHandler(MatchPath="/my:ServiceOrder/my:ResourceRequirementDetails/my:Items/my:ResourceStartDate", EventType=InfoPathEventType.OnAfterChange)]
public void ResourceStartDate_OnAfterChange(DataDOMEvent e)
{

if (e.IsUndoRedo)
{
return;

}

SyncDifference();
}

private void SyncDifference()

{
IXMLDOMNode date1Node = thisXDocument.DOM.selectSingleNode( "../my:ResourceStartDate" );
IXMLDOMNode date2Node = thisXDocument.DOM.selectSingleNode( "../my:ResourceReleaseDate" );
IXMLDOMNode diffNode = thisXDocument.DOM.selectSingleNode( "../my:ManDays" );

if( date1Node != null && date2Node != null && diffNode != null )
{
try
{
DateTime dt1 = Iso8601ToDate( date1Node.text );
DateTime dt2 = Iso8601ToDate( date2Node.text );

TimeSpan ts = dt2 - dt1;
diffNode.text = ts.Days.ToString();
}
catch( FormatException ) {}
}
}

// The following function handler is created by Microsoft Office InfoPath. Do not
// modify the type or number of arguments.
[InfoPathEventHandler(MatchPath="/my:ServiceOrder/my:ResourceRequirementDetails/my:Items/my:ResourceReleaseDate", EventType=InfoPathEventType.OnAfterChange)]
public void ResourceReleaseDate_OnAfterChange(DataDOMEvent e)
{
if (e.IsUndoRedo)
{
return;
}

SyncDifference();
}

I also tried "../FieldName" and "//FieldName" but it doesn't work also.
Thanks.

quote:
Practice makes perfect, but then, nobody's perfect. So, why practice?