public static bool getActToXML(Company myCompany)
{
if (myCompany != null && myCompany.Connected)
{
//metodo precedente all'introduzione del CRM in sap
ActivitiesService acts = myCompany.GetCompanyService().GetBusinessService(ServiceTypes.ActivitiesService) as ActivitiesService;
Activity myAct = acts.GetDataInterface(ActivitiesServiceDataInterfaces.asActivity);
//get dei dati
string TodayDateQuery = DateTime.Now.ToString("yyyy-MM-dd");
Recordset RecSet = myCompany.GetBusinessObject(BoObjectTypes.BoRecordset);
RecSet.DoQuery("select * from \"OCLG\",\"DUMMY\" WHERE \"CntctDate\"= TO_TIMESTAMP ('" + TodayDateQuery + " 00:00:00', 'YYYY-MM-DD HH24:MI:SS')");
string pathToXml = Path.GetDirectoryName(Application.ExecutablePath);
string TodayDate = DateTime.Now.ToString("dd-MM-yyyy");
RecSet.SaveXML(TodayDate + "_activities.xml");
MessageBox.Show("File saved in '" + pathToXml + "' ", "Export to XML", MessageBoxButtons.OK, MessageBoxIcon.Information);
/*
* var o = RecSet.RecordCount;
* while (!RecSet.EoF)
* {
* var CardCode = RecSet.Fields.Item("CardCode");
* RecSet.MoveNext();
* }
*/
return(true);
}
else
{
return(false);
}
}
public void SaveXML(ref string fileName)
{
recordset.SaveXML(fileName);
}
