Hello Jimmy:
I am trying to save the infopath form data to a sql database via WCF webservice and hoping to save a copy to the sharepoint document library as well . I have already created a wcf web service , I tried to implement your method but nothing seems to be happening. I am new to infopath and I am trying to achieve both objectives. All this has to be done in code behind and I have thus far only implemeted your method, and not the saving to a sharepoint doc lib method yet. Please see the code I have written:
using Microsoft.Office.InfoPath;
using System;
using System.Xml;
using System.Xml.XPath;
using Microsoft.SharePoint;
using Microsoft.SharePoint.Utilities;
using System.Text;
using System.Diagnostics;
using System.Collections.Generic;
using System.Web;
using System.Windows.Forms;
namespace ProjectConceptQAReport
{
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:
public void InternalStartup()
{
((ButtonEvent)EventManager.ControlEvents["CTRL3_5"]).Clicked += new ClickedEventHandler(CTRL3_5_Clicked);
EventManager.FormEvents.Submit += new SubmitEventHandler(FormEvents_Submit);
((ButtonEvent)EventManager.ControlEvents["CTRL4_5"]).Clicked += new ClickedEventHandler(CTRL4_5_Clicked);
((ButtonEvent)EventManager.ControlEvents["bttn_Submit"]).Clicked += new ClickedEventHandler(bttn_Submit_Clicked);
}
public void CTRL3_5_Clicked(object sender, ClickedEventArgs e)
{
// Write your code here.
}
public void FormEvents_Submit(object sender, SubmitEventArgs e)
{
// If the submit operation is successful, set
// e.CancelableArgs.Cancel = false;
// Write your code here.
}
public void CTRL4_5_Clicked(object sender, ClickedEventArgs e)
{
// Write your code here.
}
//public void bttn_Submit_Clicked(object sender, ClickedEventArgs e)
//{
// SaveData();
//}
//public void FormEvents_Submit(object sender, SubmitEventArgs e)
//{
// SaveData();
//}
//public void SaveData()
//{
// try
// {
// //save file to the location and file name as in xml
// XPathNavigator xnDoc = this.MainDataSource.CreateNavigator();
// string saveLocation = xnDoc.SelectSingleNode("/my:ProjectConceptQAReport/my:SaveLocation", NamespaceManager).Value;
// //File Name
// xnDoc.SelectSingleNode("/my:ProjectConceptQAReport/my:FormName", NamespaceManager).SetValue(xnDoc.SelectSingleNode("/my:ProjectConceptQAReport/my:txt_ProjId", NamespaceManager).Value + "Project Concept QA Report" + xnDoc.SelectSingleNode("/my:ProjectConceptQAReport/my:CurrentDate", NamespaceManager).Value);
// string fileName = xnDoc.SelectSingleNode("/my:ProjectConceptQAReport/my:FormName", NamespaceManager).Value;
// SaveFormToSPList(MainDataSource.CreateNavigator().OuterXml, fileName, saveLocation, true);
// }
// catch (Exception ex)
// {
// SetSystemError("Error in 'SaveData:' " + ex.Message + " --- " + ex.InnerException);
// }
//}
public void bttn_Submit_Clicked(object sender, ClickedEventArgs e)
{
//add your code here
XPathNavigator mainDataNavigator = MainDataSource.CreateNavigator();
// Generate a name for the form to be saved in SharePoint
//string Infopath_Form_Library = Guid.NewGuid().ToString();
// Set the name of the form on the data connection
//root.SelectSingleNode(
// "//my:ProjectConceptQAReport", NamespaceManager).SetValue(ProjectConceptQAReport);
// Get objects for the two value nodes hooked up to the data connection
//XPathNavigator submitValue1 = mainDataNavigator.SelectSingleNode("my:myFields/my:Value1", NamespaceManager);
//XPathNavigator submitValue2 = mainDataNavigator.SelectSingleNode("my:myFields/my:Value2", NamespaceManager);
XPathNavigator submitValue1 = mainDataNavigator.SelectSingleNode("my:myFields/my:txt_ProjId", NamespaceManager);
XPathNavigator submitValue2 = mainDataNavigator.SelectSingleNode("my:myFields/my:txt_ProjTitle", NamespaceManager);
XPathNavigator submitValue3 = mainDataNavigator.SelectSingleNode("my:myFields/my:txt_ProjDate", NamespaceManager);
XPathNavigator submitValue4 = mainDataNavigator.SelectSingleNode("my:myFields/my:ddl_Quality", NamespaceManager);
XPathNavigator submitValue5 = mainDataNavigator.SelectSingleNode("my:myFields/my:ddl_Decision", NamespaceManager);
XPathNavigator submitValue6 = mainDataNavigator.SelectSingleNode("my:myFields/my:ddl_Strategic", NamespaceManager);
XPathNavigator submitValue7 = mainDataNavigator.SelectSingleNode("my:myFields/my:ddl_Relevant", NamespaceManager);
XPathNavigator submitValue8 = mainDataNavigator.SelectSingleNode("my:myFields/my:ddl_Monitoring", NamespaceManager);
XPathNavigator submitValue9 = mainDataNavigator.SelectSingleNode("my:myFields/my:ddl_Efficient", NamespaceManager);
XPathNavigator submitValue10 = mainDataNavigator.SelectSingleNode("my:myFields/my:ddl_Effective", NamespaceManager);
XPathNavigator submitValue11 = mainDataNavigator.SelectSingleNode("my:myFields/my:ddl_Sustainability", NamespaceManager);
XPathNavigator submitValue12 = mainDataNavigator.SelectSingleNode("my:myFields/my:txt_qaSummary", NamespaceManager);
XPathNavigator submitValue13 = mainDataNavigator.SelectSingleNode("my:myFields/my:Doc_Status", NamespaceManager);
// Loop through each node of the repeating group
foreach (XPathNavigator values in mainDataNavigator.Select("my:myFields/my:values", NamespaceManager))
{
// copy the values from this group's nodes to the submit fields
submitValue1.SetValue(values.SelectSingleNode("my:txt_Notes", NamespaceManager).Value);
submitValue2.SetValue(values.SelectSingleNode("my:txt_Date", NamespaceManager).Value);
submitValue3.SetValue(values.SelectSingleNode("my:ProjManager/pc:Person/pc:DisplayName", NamespaceManager).Value);
submitValue4.SetValue(values.SelectSingleNode("my:ProjManager/pc:Person/pc:AccountId", NamespaceManager).Value);
submitValue5.SetValue(values.SelectSingleNode("my:ProjManager/pc:Person/pc:AccountType", NamespaceManager).Value);
// Invoke the data connection
DataConnections["WebServiceSubmitQA"].Execute();
}
}
}
}