InfoPath Dev

Hi,

I have this code that calculates the amount of days between two dates (DateDebut and DateFin) which are parts of a repeating table.

The calcul is made when the second date field (DateFin) is changed. Until there, everything just work fine.

My main problem is that when I add another row the my repeating table, I don't know the names of the new controls created by the action of adding a new row to the repeating table ! Is there any way to increment an ID field name or anything ?

The code which calcultes the amount of days between the two dates field. These are named "DateEnd" and "DateFin". How can I "call" these once a new row is created ?

XPathNavigator MainData2 = MainDataSource.CreateNavigator();

DateTime dt1 = MainData2.SelectSingleNode("/my:DemandeConge/my:Conges/my:DateDebut", NamespaceManager).ValueAsDateTime;

DateTime dt2 = MainData2.SelectSingleNode("/my:DemandeConge/my:Conges/my:DateFin", NamespaceManager).ValueAsDateTime;

System.TimeSpan span = dt2.Subtract(dt1);

double final = span.TotalDays;

string final2 = final.ToString();

MainData2.SelectSingleNode("/my:DemandeConge/my:Conges/my:Total", NamespaceManager).SetValue(final2);

THANKS A LOT !

Hi Shiva,

Thanks for you explanation which I understand, I think !

Unfortunately, it doesn't work completely. I think your code is ok because the calcul is still done but for me, it's the XmlEvents for the DateFin (second date field) in my code that doesn't work because it checkes

EventManager.XmlEvents["/my:DemandeConge/my:Conges/my:DateFin"].Changed

instead of the last inserted one as

e.Site.EventManager.XmlEvents["/my:DemandeConge/my:Conges/my:DateFin"].Changed

But how to translate this into a correct code to get the last DateFin event field ?

 Here's the full code :

using Microsoft.Office.InfoPath;

using System;

using System.Xml;

using System.Xml.XPath;

using System.Collections.Generic;

using System.Text;

using System.Globalization;

public partial class FormCode

XPathNavigator MainData = MainDataSource.CreateNavigator();

double final = span.TotalDays;

//Here my:field1 -> my:DateDebutmy:field2 -> my:DateFinmy:field3 -> my:Total

 Thanks !

DateFin_Changed(..) event will be called every time when the DateFin field value is changed. The field name should not be changed when we insert a new row. But if we use MainData2.SelectSingleNode("/my:DemandeConge/my:Conges/my:DateFin", NamespaceManager), in the changed event, every time the first row’s DateFin is considered. If we want to know the present inserted row DateFin, then we can refer that as e.Site.

There is no event for last DateFin event field. But we can get the last DateFin using MainData2.SelectSingleNode("/my:DemandeConge/my:Conges[position() = last()]/my:DateFin", NamespaceManager).

Hi Swathip !

Thanks again for the time you are giving to me.

Below, you will find a concrete example of what I'm doing. First row acts as I want. The calcul is well made once "DateFin" field is changed. The problem is that when I insert a new row, nothing happens in the "Total" field of this new row when the "DateFin" field is changed.

But if I replace the code that affects the value of the "Total" field by MainData2.SelectSingleNode("/my:DemandeConge/my:Conges[position() = last()]/my:Total", NamespaceManager).SetValue(final2); instead of e.Site.SelectSingleNode("/my:DemandeConge/my:Conges/my:Total", NamespaceManager).SetValue(final2); everytime I insert a row, the "Total" field will get the value of the first row "Total" field...

I hope I'm clear with this. I put you the public void DateFin_Changed() code below :

Hi,

Every time you are setting the first row total value. You can solve your problem by altering some code which is formatted as BOLD.

Man, it finally works, thanks to you !!!

Can you tell me what you have exactly done ? Does "../my:DateFin"  mean that we "play" with the control of a specific row of a repeating table ?

THANKS A LOT, I couldn't achieve it without you.