/// <summary>
/// Integra un documento xml sDocXml a GP.
/// </summary>
public void integraTransactionXml()
{
iError = 0;
string eConnResult;
eConnectMethods eConnObject = new eConnectMethods();
try
{
//El método que integra eConnect_EntryPoint retorna True si fue exitoso
//eConnResult = eConnObject.eConnect_EntryPoint(_DatosConexionDB.Elemento.ConnStr, EnumTypes.ConnectionStringType.SqlClient, _sDocXml, EnumTypes.SchemaValidationType.None);
eConnResult = eConnObject.CreateTransactionEntity(_DatosConexionDB.Elemento.ConnStr, _sDocXml);
this.sMensaje = "--> Integrado a GP";
//sMensaje += _sDocXml;
}
catch (eConnectException eConnErr)
{
this.sMensaje = "Excepción eConnect: " + eConnErr.Message + " " + eConnErr.TargetSite.ToString() + " [integraTransactionXml] " + _sDocXml;
this.iError++;
}
catch (ApplicationException ex)
{
this.sMensaje = "Excepción de aplicación: " + ex.Message + "[integraTransactionXml]";
this.iError++;
}
catch (Exception errorGral)
{
this.sMensaje = "Excepción desconocida: " + errorGral.Message + "[integraTransactionXml]";
this.iError++;
}
}
public static bool InsertTransaction(ref string response, string transactionXML, string gpDatabase)
{
string connString = DataAccess.ConnectionStringWindows;
string returnValue;
response = "";
eConnectMethods eConnCall = new eConnectMethods();
try
{
returnValue = eConnCall.CreateTransactionEntity(connString, transactionXML);
return(true);
}
catch (eConnectException ex)
{
response = ex.Message;
return(false);
}
catch (SqlException ex)
{
foreach (SqlError sqlErr in ex.Errors)
{
response += sqlErr.Message + "\r\n";
}
return(false);
}
catch (Exception ex)
{
response = ex.Message;
return(false);
}
}
/// <summary>
/// Crea el xml de una factura sop a partir de una vista sql.
/// </summary>
private taSopHdrIvcInsert IntegraFacturaSOP(vwIntegracionesVentas preFacturasAIntegrar, string sTimeStamp)
{
string eConnResult = String.Empty;
eConnectType docEConnectSOP = new eConnectType();
eConnectType entEconnect = new eConnectType();
FacturaDeVentaSOPBandejaDB documentoSOP = new FacturaDeVentaSOPBandejaDB(parametrosDB);
eConnectMethods eConnObject = new eConnectMethods();
var dpf = getPrefacturasDetalle(preFacturasAIntegrar.NUMDOCARN, preFacturasAIntegrar.TIPODOCARN);
string tipoContribuyente = LocArgentina_GetTipoContribuyente(preFacturasAIntegrar.IDCLIENTE);
documentoSOP.preparaFacturaSOP(preFacturasAIntegrar, dpf, sTimeStamp, tipoContribuyente);
docEConnectSOP.SOPTransactionType = new SOPTransactionType[] { documentoSOP.FacturaSop };
serializa(docEConnectSOP);
eConnResult = eConnObject.CreateTransactionEntity(parametrosDB.ConnStringTarget, this.SDocXml);
return(documentoSOP.FacturaSop.taSopHdrIvcInsert);
}
public void createNewItem(part newpart)
{
using (eConnectMethods eConCall = new eConnectMethods())
{
try
{
// Create the eConnect document and store it in a file
serializeObject("C:\\newItem.xml", newpart);
// Load the eConnect XML document from the file into
// and XML document object
XmlDocument xmldoc = new XmlDocument();
xmldoc.Load("C:\\newItem.xml");
// Create an XML string from the document object
string salesOrderDocument = xmldoc.OuterXml;
// Create a connection string
// Integrated Security is required. Integrated security=SSPI
// Update the data source and initial catalog to use the names of
// data server and company database
string sConnectionString = "data source=Sandbox-PC\\DTIGP;initial catalog=DTI;integrated security=SSPI;persist security info=False;packet size=4096";
// Use the CreateTransactionEntity method to create the sales document in Microsoft Dynamics GP
// The method returns a string that contains the doc ID number of the new sales document
string salesOrder = eConCall.CreateTransactionEntity(sConnectionString, salesOrderDocument);
}
// The eConnectException class will catch any business logic related errors from eConnect_EntryPoint.
catch (eConnectException exp)
{
Console.Write(exp.ToString());
}
// Catch any system error that might occurr. Display the error to the user
catch (Exception ex)
{
Console.Write(ex.ToString());
}
finally
{
// Use the Dipose method to release resources associated with the
// eConnectMethods objects
eConCall.Dispose();
}
}
}
public static void MySer()
{
using (eConnectMethods eConCall = new eConnectMethods())
{
try
{
// Create the eConnect document and store it in a file
SerializeObject("SalesOrder.xml");
// Load the eConnect XML document from the file into
// and XML document object
XmlDocument xmldoc = new XmlDocument();
xmldoc.Load("SalesOrder.xml");
string salesOrderDocument = xmldoc.OuterXml;
string sConnectionString = @"Data Source=LAPTOP-BUDQ9SBN\DYNAMICGP;Integrated Security = SSPI; Persist Security Info = false ; Initial Catalog = GP_DE;";
string salesOrder = eConCall.CreateTransactionEntity(sConnectionString, salesOrderDocument);
Console.WriteLine(salesOrder);
Console.ReadLine();
}
catch (eConnectException exp)
{
Console.Write(exp.ToString());
Console.ReadLine();
}
catch (Exception ex)
{
Console.Write(ex.ToString());
Console.ReadLine();
}
finally
{
eConCall.Dispose();
}
}
}
public Response CreateGPTransaction(string strCNX, string strXML)
{
var eConnCall = new eConnectMethods();
var response = new Response();
try
{
response.MESSAGE = eConnCall.CreateTransactionEntity(strCNX, strXML);
response.SUCCESS = true;
return(response);
}
catch (eConnectException ex)
{
response.SUCCESS = false;
response.MESSAGE = ex.Message + " - " + strXML;;
response.STACK = ex.StackTrace;
if (ex.InnerException != null)
{
response.STACK += ex.InnerException.Message;
}
return(response);
}
catch (Exception ex)
{
response.SUCCESS = false;
response.MESSAGE = ex.Message;
response.STACK = ex.StackTrace;
if (ex.InnerException != null)
{
response.STACK += ex.InnerException.Message;
}
return(response);
}
finally
{
eConnCall.Dispose();
}
}
/// <summary>
/// Crea el xml de una factura sop a partir de una fila de datos en una hoja excel.
/// </summary>
/// <param name="hojaXl">Hoja excel</param>
/// <param name="filaXl">Fila de la hoja excel a procesar</param>
public void IntegraFacturaSOP(ExcelWorksheet hojaXl, int filaXl, string sTimeStamp)
{
_iError = 0;
_mensaje = String.Empty;
string eConnResult = String.Empty;
eConnectType docEConnectSOP = new eConnectType();
eConnectType entEconnect = new eConnectType();
FacturaDeVentaSOP documentoSOP = new FacturaDeVentaSOP(_ParamExcel.ConnectionStringTargetEF);
eConnectMethods eConnObject = new eConnectMethods();
Cliente entidadCliente;
try
{
_mensaje = " Número Doc: " + hojaXl.Cells[filaXl, _ParamExcel.FacturaSopnumbe].Value.ToString().Trim();
entidadCliente = new Cliente(_ParamExcel.ConnectionStringTargetEF, _ParamExcel.FacturaSopTXRGNNUM.ToString(), _ParamExcel.FacturaSopCUSTNAME.ToString(), _ParamExcel.ClienteDefaultCUSTCLAS);
if (entidadCliente.preparaClienteEconn(hojaXl, filaXl))
{
entEconnect.RMCustomerMasterType = entidadCliente.ArrCustomerType;
serializa(entEconnect);
if (eConnObject.CreateEntity(_ParamExcel.ConnStringTarget, _sDocXml))
{
_mensaje += "--> Cliente Integrado a GP";
}
}
documentoSOP.preparaFacturaSOP(hojaXl, filaXl, sTimeStamp, _ParamExcel);
docEConnectSOP.SOPTransactionType = new SOPTransactionType[] { documentoSOP.FacturaSop };
serializa(docEConnectSOP);
eConnResult = eConnObject.CreateTransactionEntity(_ParamExcel.ConnStringTarget, _sDocXml);
_sMensajeErr = "--> Integrado a GP";
}
catch (NullReferenceException nr)
{
string sInner = nr.InnerException == null ? String.Empty : nr.InnerException.Message;
if (nr.InnerException != null)
{
sInner += nr.InnerException.InnerException == null ? String.Empty : " " + nr.InnerException.InnerException.Message;
}
_sMensajeErr = "Excepción al validar datos de la factura SOP. " + nr.Message + " " + sInner + " [" + nr.TargetSite.ToString() + "]";
_iError++;
}
catch (eConnectException eConnErr)
{
string sInner = eConnErr.InnerException == null ? String.Empty : eConnErr.InnerException.Message;
_sMensajeErr = "Excepción eConnect al integrar factura SOP. " + eConnErr.Message + " " + sInner + " [" + eConnErr.TargetSite.ToString() + "]";
_iError++;
}
catch (Exception errorGral)
{
string sInner = errorGral.InnerException == null ? String.Empty : errorGral.InnerException.Message;
if (errorGral.InnerException != null)
{
sInner += errorGral.InnerException.InnerException == null ? String.Empty : " " + errorGral.InnerException.InnerException.Message;
}
_sMensajeErr = "Excepción desconocida al integrar factura SOP. " + errorGral.Message + " " + sInner + " [" + errorGral.TargetSite.ToString() + "]";
_iError++;
}
finally
{
_filaNuevaFactura = filaXl + 1;
_mensaje = "Fila: " + filaXl.ToString() + _mensaje;
}
}