public static Boolean SendData(string xmlDocument) { eConnectMethods eConCall = new eConnectMethods(); try { //Create a connection string to the Microsoft Dynamics GP database server //string cnnString = ConfigurationManager.AppSettings["GPCnnString"]; //string cnnString = "data source=WEBMASTERNT02;initial catalog=TWO;integrated security=SSPI;persist security info=False;packet size=4096"; //string cnnString = "Data Source=192.168.1.4;initial catalog=TWO;integrated security=SSPI;persist security info=False;packet size=4096"; //string cnnString = ConfigurationManager.AppSettings["GPCnnString"]; //Use the eConnect_EntryPoint to create the document in Microsoft Dynamics GP eConCall.eConnect_EntryPoint(FactoryCompany.ErpConnection.CnnString, EnumTypes.ConnectionStringType.SqlClient, xmlDocument, EnumTypes.SchemaValidationType.None, ""); return(true); } catch (eConnectException) { throw; //return false; } catch (Exception) { throw; //return false; } }
private void saveToSOP(Transaction assessment, string documentID, string defaultSiteID) { try { using (eConnectMethods eConnect = new eConnectMethods()) { string sAssessment; string sXSD; XmlDocument XSDdoc = new XmlDocument(); XSDdoc.Load(@"eConnect.xsd"); sXSD = XSDdoc.OuterXml; serializeSOPObject("assessment.xml", assessment, documentID, defaultSiteID); XmlDocument xmldoc = new XmlDocument(); xmldoc.Load("assessment.xml"); sAssessment = xmldoc.OuterXml; eConnect.eConnect_EntryPoint(connString, EnumTypes.ConnectionStringType.SqlClient, sAssessment, EnumTypes.SchemaValidationType.XSD, sXSD); rollback = false; //20100625 } } catch (Exception ex) { log.Error(ex); throw ex; } }
private void btnSend_Click(object sender, System.EventArgs e) { eConnectMethods eConnect = new eConnectMethods(); XmlDocument myXmlDoc = new XmlDocument(); XmlNode eConnectProcessInfoOutgoing; try { checkBox1.Checked = false; myXmlDoc.LoadXml(txtXml.Text); eConnectProcessInfoOutgoing = myXmlDoc.SelectSingleNode("//Outgoing"); if ((eConnectProcessInfoOutgoing == null) || (string.IsNullOrEmpty(eConnectProcessInfoOutgoing.InnerText) == true)) { eConnect.eConnect_EntryPoint(txtConnString.Text, EnumTypes.ConnectionStringType.SqlClient, myXmlDoc.OuterXml, EnumTypes.SchemaValidationType.None, string.Empty); this.txtResults.Text = "Message successfully entered into the BackOffice."; } else { if (eConnectProcessInfoOutgoing.InnerText == "TRUE") { this.txtResults.Text = eConnect.eConnect_Requester(txtConnString.Text, EnumTypes.ConnectionStringType.SqlClient, myXmlDoc.OuterXml); } } } catch (Exception ex) { this.txtResults.Text = ex.ToString(); } finally { eConnect.Dispose(); } }
// public static string InvoiceDOCID(string con) // { // SqlCommand command = new SqlCommand(); // string res = ""; // command.Connection = new SqlConnection(con); // command.CommandType = System.Data.CommandType.Text; // command.CommandText = "SELECT INVDOCID FROM SOP40100"; // try{ // if(command.Connection.State != ConnectionState.Open) // { // command.Connection.Open(); // } // res = (string) command.ExecuteScalar(); // }catch(Exception ex) // { // IEvent e = new ErrorEvent("","",ex.Message); // e.Publish(); // }finally // { // command.Connection.Close(); // } // return res; //} //public static string returnDOCID(string con) //{ // SqlCommand command = new SqlCommand(); // string res = ""; // command.Connection = new SqlConnection(con); // command.CommandType = System.Data.CommandType.Text; // command.CommandText = "SELECT RETDOCID FROM SOP40100"; // try // { // if (command.Connection.State != ConnectionState.Open) // { // command.Connection.Open(); // } // res = (string)command.ExecuteScalar(); // } // catch (Exception ex) // { // IEvent e = new ErrorEvent("", "", ex.Message); // e.Publish(); // } // finally // { // command.Connection.Close(); // } // return res; //} //public static bool insertFiscalInfo(string SOPNUMBE, string COO, string DATEGEN, string SERIALPRINTER,string con) //{ // SqlCommand command = new SqlCommand(); // bool res = false; // command.Connection = new SqlConnection(con); // command.CommandType = System.Data.CommandType.Text; // command.Parameters.AddWithValue("@INVOICE", SOPNUMBE); // command.Parameters.AddWithValue("@COO", COO); // command.Parameters.AddWithValue("@DATEGEN", DATEGEN); // command.Parameters.AddWithValue("@SERIALPRINTER", SERIALPRINTER); // command.CommandText = "INSERT INTO CSG_FISCAL_PRINT (COO,INVOICE,DATEGEN,SERIALPRINTER) VALUES(@COO,@INVOICE,@DATEGEN,@SERIALPRINTER);"; // try // { // if (command.Connection.State != ConnectionState.Open) // { // command.Connection.Open(); // } // res = command.ExecuteNonQuery()>0; // } // catch (Exception ex) // { // IEvent e = new ErrorEvent("", "", ex.Message); // e.Publish(); // } // finally // { // command.Connection.Close(); // } // return res; //} public static bool eConnectSendToGP(string eConnectDocument, string TrustedConnStr) { //string status; bool res = true; // ((IEvent)(new InfoEvent("", "", "Documento a Procesar: " + eConnectDocument))).Publish(); try { eConnectMethods eConCall = new eConnectMethods(); //'Dim econnect As New eConnectType //' Dim serializer As New XmlSerializer(GetType(eConnectType)) //' Dim memstream As New MemoryStream //' Dim scServices = New ServiceController //'scServices = ServiceController.GetServices(); //' scService.ServiceName == "DynGP11eConnect" //'MsgBox(eConnect_ConnectionString) res = eConCall.eConnect_EntryPoint(TrustedConnStr, EnumTypes.ConnectionStringType.SqlClient, eConnectDocument, EnumTypes.SchemaValidationType.None, ""); //'status = eConCall.CreateTransactionEntity(eConnect_ConnectionString, Xml) }catch (Exception ex) { // res = false; // IEvent e = new ErrorEvent("","","Error en la transacción: " + ex.Message); //e.Publish(); } finally {} return(res); }
static void Main() { string sCustomerDocument; string sXsdSchema; string sConnectionString; using (eConnectMethods e = new eConnectMethods()) { try { // Create the customer data file SerializeCustomerObject("Customer.xml"); // Use an XML document to create a string representation of the customer XmlDocument xmldoc = new XmlDocument(); xmldoc.Load("Customer.xml"); sCustomerDocument = xmldoc.OuterXml; // Specify the Microsoft Dynamics GP server and database in the connection string sConnectionString = @"data source=MYSERVER;initial catalog=DATABASE;integrated security=SSPI;persist security info=False;packet size=4096"; // Create an XML Document object for the schema XmlDocument XsdDoc = new XmlDocument(); // Default path to the eConnect.xsd file // Change the filepath if the eConnect 10.0.0.0 SDK is installed in a location other than the default. XsdDoc.Load(@"\Program files\Common Files\Microsoft Shared\eConnect 10\XML Schemas\Incoming XSD Schemas\eConnect.xsd"); // Create a string representing the eConnect schema sXsdSchema = XsdDoc.OuterXml; // Pass in xsdSchema to validate against. e.eConnect_EntryPoint(sConnectionString, EnumTypes.ConnectionStringType.SqlClient, sCustomerDocument, EnumTypes.SchemaValidationType.XSD, sXsdSchema); } // The eConnectException class will catch eConnect business logic errors. // display the error message on the console catch (eConnectException exc) { Console.Write(exc.ToString()); } // Catch any system error that might occurr. // display the error message on the console catch (System.Exception ex) { Console.Write(ex.ToString()); } } // end of using statement }
public void PushtoGP(XElement payablex) { eConnectMethods e = new eConnectMethods(); string payableVoucher = payablex.ToString(); // Specify the Microsoft Dynamics GP server and database in the connection string string sConnectionString = @"data source=sc-gpd;initial catalog=TMI;integrated security=SSPI;persist security info=False;packet size=4096"; // Create an XML Document object for the schema XmlDocument XsdDoc = new XmlDocument(); // Default path to the eConnect.xsd file // Change the filepath if the eConnect 10.0.0.0 SDK is installed in a location other than the default. XsdDoc.Load(@"C:\Program Files (x86)\Common Files\Microsoft Shared\eConnect 10\XML Sample Documents\Incoming XSD Schemas\eConnect.xsd"); // Create a string representing the eConnect schema string sXsdSchema = XsdDoc.OuterXml; // Pass in xsdSchema to validate against. e.eConnect_EntryPoint(sConnectionString, EnumTypes.ConnectionStringType.SqlClient, payableVoucher, EnumTypes.SchemaValidationType.XSD, sXsdSchema); }
public void PushtoGP(XElement payablex) { eConnectMethods e = new eConnectMethods(); string payableVoucher = payablex.ToString(); // Specify the Microsoft Dynamics GP server and database in the connection string string sConnectionString = @"data source=sc-gpd;initial catalog=TMI;integrated security=SSPI;persist security info=False;packet size=4096"; // Create an XML Document object for the schema XmlDocument XsdDoc = new XmlDocument(); // Default path to the eConnect.xsd file // Change the filepath if the eConnect 10.0.0.0 SDK is installed in a location other than the default. XsdDoc.Load(@"C:\Program Files (x86)\Common Files\Microsoft Shared\eConnect 10\XML Sample Documents\Incoming XSD Schemas\eConnect.xsd"); // Create a string representing the eConnect schema string sXsdSchema = XsdDoc.OuterXml; // Pass in xsdSchema to validate against. e.eConnect_EntryPoint(sConnectionString, EnumTypes.ConnectionStringType.SqlClient, payableVoucher, EnumTypes.SchemaValidationType.XSD, sXsdSchema); }
// public static string InvoiceDOCID(string con) // { // SqlCommand command = new SqlCommand(); // string res = ""; // command.Connection = new SqlConnection(con); // command.CommandType = System.Data.CommandType.Text; // command.CommandText = "SELECT INVDOCID FROM SOP40100"; // try{ // if(command.Connection.State != ConnectionState.Open) // { // command.Connection.Open(); // } // res = (string) command.ExecuteScalar(); // }catch(Exception ex) // { // IEvent e = new ErrorEvent("","",ex.Message); // e.Publish(); // }finally // { // command.Connection.Close(); // } // return res; //} //public static string returnDOCID(string con) //{ // SqlCommand command = new SqlCommand(); // string res = ""; // command.Connection = new SqlConnection(con); // command.CommandType = System.Data.CommandType.Text; // command.CommandText = "SELECT RETDOCID FROM SOP40100"; // try // { // if (command.Connection.State != ConnectionState.Open) // { // command.Connection.Open(); // } // res = (string)command.ExecuteScalar(); // } // catch (Exception ex) // { // IEvent e = new ErrorEvent("", "", ex.Message); // e.Publish(); // } // finally // { // command.Connection.Close(); // } // return res; //} //public static bool insertFiscalInfo(string SOPNUMBE, string COO, string DATEGEN, string SERIALPRINTER,string con) //{ // SqlCommand command = new SqlCommand(); // bool res = false; // command.Connection = new SqlConnection(con); // command.CommandType = System.Data.CommandType.Text; // command.Parameters.AddWithValue("@INVOICE", SOPNUMBE); // command.Parameters.AddWithValue("@COO", COO); // command.Parameters.AddWithValue("@DATEGEN", DATEGEN); // command.Parameters.AddWithValue("@SERIALPRINTER", SERIALPRINTER); // command.CommandText = "INSERT INTO CSG_FISCAL_PRINT (COO,INVOICE,DATEGEN,SERIALPRINTER) VALUES(@COO,@INVOICE,@DATEGEN,@SERIALPRINTER);"; // try // { // if (command.Connection.State != ConnectionState.Open) // { // command.Connection.Open(); // } // res = command.ExecuteNonQuery()>0; // } // catch (Exception ex) // { // IEvent e = new ErrorEvent("", "", ex.Message); // e.Publish(); // } // finally // { // command.Connection.Close(); // } // return res; //} public static bool eConnectSendToGP(string eConnectDocument, string TrustedConnStr) { //string status; bool res = true; try { eConnectMethods eConCall = new eConnectMethods(); res = eConCall.eConnect_EntryPoint(TrustedConnStr, EnumTypes.ConnectionStringType.SqlClient, eConnectDocument, EnumTypes.SchemaValidationType.None, ""); //'status = eConCall.CreateTransactionEntity(eConnect_ConnectionString, Xml) } catch (Exception ex) { string sSource; string sLog; string sEvent; sSource = "GP Integration TShirt"; sLog = "Application"; sEvent = ex.Message; if (!EventLog.SourceExists(sSource)) { EventLog.CreateEventSource(sSource, sLog); } EventLog.WriteEntry(sSource, sEvent); EventLog.WriteEntry(sSource, sEvent, EventLogEntryType.Warning, 234); } finally { } return(res); }
public bool createOrUpdateCustomer(Customer c) { bool status = false; if ((c.CustomerName == null) || (c.CustomerID == null) || (c.CustomerClass == null)) return false; eConnectMethods eConnect = new eConnectMethods(); try { StringBuilder xml = new StringBuilder(); xml.Append("<eConnect>"); xml.Append("<RMCustomerMasterType>"); xml.Append("<taUpdateCreateCustomerRcd>"); xml.Append("<CUSTNMBR><![CDATA[" + c.CustomerID + "]]></CUSTNMBR>"); xml.Append("<CUSTNAME><![CDATA[" + c.CustomerName + "]]></CUSTNAME>"); xml.Append("<CUSTCLAS><![CDATA[" + c.CustomerClass + "]]></CUSTCLAS>"); xml.Append("<INACTIVE><![CDATA[" + c.Inactive.GetHashCode() + "]]></INACTIVE>"); if (c.ShortName != null) xml.Append("<SHRTNAME><![CDATA[" + c.ShortName + "]]></SHRTNAME>"); if (c.StatementName != null) xml.Append("<STMTNAME><![CDATA[" + c.StatementName + "]]></STMTNAME>"); if (c.ShipTo != null) xml.Append("<PRSTADCD><![CDATA[" + c.ShipTo + "]]></PRSTADCD>"); if (c.StatementTo != null) xml.Append("<STADDRCD><![CDATA[" + c.StatementTo + "]]></<STADDRCD>"); if (c.BillTo != null) xml.Append("<PRBTADCD><![CDATA[" + c.BillTo + "]]></PRBTADCD>"); if (c.Type != null) xml.Append("<USERDEF1><![CDATA[" + c.Type + "]]></USERDEF1>"); if (c.StudentStatus != null) xml.Append("<USERDEF2><![CDATA[" + c.StudentStatus + "]]></USERDEF2>"); /* * This data is part of the address */ if (c.CustomerAddress.AddressString != null) { if (c.CustomerAddress.AddressString.Length < 50) { xml.Append("<ADDRESS1><![CDATA[" + c.CustomerAddress.AddressString + "]]></ADDRESS1>"); } else { xml.Append("<ADDRESS1><![CDATA[" + c.CustomerAddress.AddressString.Substring(0, 50) + "]]></ADDRESS1>"); xml.Append("<ADDRESS2><![CDATA[" + c.CustomerAddress.AddressString.Substring(50, c.CustomerAddress.AddressString.Length - 50) + "]]></ADDRESS2>"); } } if (c.CustomerAddress.AddressCode != null) xml.Append("<ADRSCODE><![CDATA[" + c.CustomerAddress.AddressCode + "]]></ADRSCODE>"); if (c.CustomerAddress.AddressContact != null) xml.Append("<CNTCPRSN><![CDATA[" + c.CustomerAddress.AddressContact + "]]></CNTCPRSN>"); if (c.CustomerAddress.City != null) xml.Append("<CITY><![CDATA[" + c.CustomerAddress.City + "]]></CITY>"); if (c.CustomerAddress.State != null) xml.Append("<STATE><![CDATA[" + c.CustomerAddress.State + "]]></STATE>"); if (c.CustomerAddress.Country != null) xml.Append("<COUNTRY><![CDATA[" + c.CustomerAddress.Country + "]]></COUNTRY>"); if (c.CustomerAddress.Zipcode != null) xml.Append("<ZIPCODE><![CDATA[" + c.CustomerAddress.Zipcode + "]]></ZIPCODE>"); if (c.CustomerAddress.PhoneNumber1 != null) xml.Append("<PHNUMBR1><![CDATA[" + c.CustomerAddress.PhoneNumber1 + "]]></PHNUMBR1>"); if (c.CustomerAddress.PhoneNumber2 != null) xml.Append("<PHNUMBR2><![CDATA[" + c.CustomerAddress.PhoneNumber2 + "]]></PHNUMBR2>"); if (c.CustomerAddress.FaxNumber != null) xml.Append("<FAX><![CDATA[" + c.CustomerAddress.FaxNumber + "]]></FAX>"); //CAUSES ERRORS IF COUNTRYCODE DOESNT EXIST //if (c.CustomerAddress.CountryCode != null) xml.Append("<CCODE>" + c.CustomerAddress.CountryCode + "</CCODE>"); xml.Append("<UseCustomerClass>1</UseCustomerClass>"); xml.Append("<UpdateIfExists>1</UpdateIfExists>"); xml.Append("</taUpdateCreateCustomerRcd>"); xml.Append("</RMCustomerMasterType>"); xml.Append("</eConnect>"); status = eConnect.eConnect_EntryPoint(sConnectionString, EnumTypes.ConnectionStringType.SqlClient, xml.ToString(), EnumTypes.SchemaValidationType.None, ""); } catch (eConnectException ex) { Console.WriteLine(ex.ToString()); } return status; }
public void Execute(string xml) { eConnectMethods eConnectObject = new eConnectMethods(); eConnectObject.eConnect_EntryPoint(connectionString, EnumTypes.ConnectionStringType.SqlClient, xml, EnumTypes.SchemaValidationType.None); }
//public void watcher_Created() public void watcher_Created(object sender, FileSystemEventArgs e) { string sSource; string sLog; string sEvent; string documentType; string sName = "RCT2001"; string pathFile = e.FullPath; try { Thread.Sleep(70000); //Then we need to check file is exist or not which is created. if (CheckFileExistance(wathO, e.Name)) { bool res = true; try { XDocument xml = XDocument.Load(pathFile); //lee xml para obtener datos y llenar lineas de tablas SElSI string value = File.ReadAllText(pathFile); //lee contenido XML para enviar a GP eConnectMethods eConCall = new eConnectMethods(); documentType = e.Name.Substring(0, 3); if (documentType == "AJP" || documentType == "RCT" || documentType == "TXI" || documentType == "CMB" || documentType == "MST") { res = eConCall.eConnect_EntryPoint(pathBD, EnumTypes.ConnectionStringType.SqlClient, value, EnumTypes.SchemaValidationType.None, ""); if (res) { System.IO.File.Move(pathFile, wathD + e.Name); //Update codigo int number = 0; int totalQty = 0; string qry = string.Empty; bool _result = false; int numberDocument = 0; string DocumentCode = string.Empty; switch (documentType) { case "AJP": var q = (from b in xml.Descendants("taIVTransactionHeaderInsert") select new { code = (string)b.Element("IVDOCNBR") ?? string.Empty }) .FirstOrDefault(); if (q != null) { DocumentCode = q.code; } numberDocument = GetNumber(DocumentCode); number = numberDocument + 1; //obtine numero de la secuencia y lo incremente en 1 qry = "UPDATE selSI_IV40100 SET selSI_NextNumber ='" + "00000" + number.ToString() + "' WHERE selSI_IV_Type_ID ='AJP'"; _result = InsertLineInTSGLV(qry); //actualiza secuencia de numero //qry = string.Empty; //qry += // "INSERT INTO SElSI_IV_TRX_DATE (ivdoctyp,docnumbr,docdate,inuser) VALUES "; //qry += "('1', 'AJP" + "00000" + numberDocument + "','" + DateTime.Now + // "','dbo')"; //_result = InsertLineInTSGLV(qry); //guarda Header //var _line = (from b in xml.Descendants("taIVTransactionLotInsert") // select new // { // totalUnits = (string) b.Element("SERLTQTY") ?? string.Empty, // }).ToList(); //totalQty += _line.Sum(item => Convert.ToInt32(item.totalUnits)); // //suma totalUnits //qry = ""; //qry += "INSERT INTO selSI_IV_TRX_HDR (IVDOCTYP,DOCNUMBR,TotalUnits) VALUES "; //qry += "('1', 'AJP" + "00000" + numberDocument + "','" + totalQty + "')"; //_result = InsertLineInTSGLV(qry); //guarda Linea break; case "RCT": var y = (from b in xml.Descendants("taPopRcptHdrInsert") select new { code = (string)b.Element("POPRCTNM") ?? string.Empty }) .FirstOrDefault(); if (y != null) { DocumentCode = y.code; } numberDocument = GetNumber(DocumentCode); number = numberDocument + 1; qry = "UPDATE pop40100 SET POPRCTNM ='" + "RCT" + number.ToString() + "' WHERE INDEX1 = 1"; _result = InsertLineInTSGLV(qry); //actualiza secuencia de numero break; case "TXI": var z = (from b in xml.Descendants("taIVTransferHeaderInsert") select new { code = (string)b.Element("IVDOCNBR") ?? string.Empty }) .FirstOrDefault(); if (z != null) { DocumentCode = z.code; } numberDocument = GetNumber(DocumentCode); number = numberDocument + 1; //obtine numero de la secuencia y lo incremente en 1 qry = "UPDATE selSI_IV40100 SET selSI_NextNumber ='" + "000" + number.ToString() + "' WHERE selSI_IV_Type_ID ='TXI'"; _result = InsertLineInTSGLV(qry); //actualiza secuencia de numero break; case "MST": var x = (from b in xml.Descendants("taIVTransactionHeaderInsert") select new { code = (string)b.Element("IVDOCNBR") ?? string.Empty }) .FirstOrDefault(); if (x != null) { DocumentCode = x.code; } numberDocument = GetNumber(DocumentCode); number = numberDocument + 1; //obtine numero de la secuencia y lo incremente en 1 qry = "UPDATE selSI_IV40100 SET selSI_NextNumber ='" + "000" + number.ToString() + "' WHERE selSI_IV_Type_ID ='MST'"; _result = InsertLineInTSGLV(qry); //actualiza secuencia de numero break; case "CMB": var w = (from b in xml.Descendants("taIVTransactionHeaderInsert") select new { code = (string)b.Element("IVDOCNBR") ?? string.Empty }) .FirstOrDefault(); if (w != null) { DocumentCode = w.code; } numberDocument = GetNumber(DocumentCode); number = numberDocument + 1; //obtine numero de la secuencia y lo incremente en 1 qry = "UPDATE selSI_IV40100 SET selSI_NextNumber ='" + "00000" + number.ToString() + "' WHERE selSI_IV_Type_ID ='CMB'"; _result = InsertLineInTSGLV(qry); //actualiza secuencia de numero break; } } else { System.IO.File.Move(pathFile, wathE + e.Name); } } else { sSource = "GP Services TShirt"; sLog = "Application"; sEvent = "Archivo no Reconocido, las tres primera iniciales del nombre del archivo deben coincidir con el tipo de documento"; if (!EventLog.SourceExists(sSource)) { EventLog.CreateEventSource(sSource, sLog); } EventLog.WriteEntry(sSource, sEvent); } } catch (Exception ex) { sSource = "GP Services TShirt"; sLog = "Application"; sEvent = ex.Message; if (!EventLog.SourceExists(sSource)) { EventLog.CreateEventSource(sSource, sLog); } EventLog.WriteEntry(sSource, sEvent); throw; } } } catch (Exception ex) { throw ex; } }
public static Boolean SendData(string xmlDocument) { eConnectMethods eConCall = new eConnectMethods(); try { //Create a connection string to the Microsoft Dynamics GP database server //string cnnString = ConfigurationManager.AppSettings["GPCnnString"]; //string cnnString = "data source=WEBMASTERNT02;initial catalog=TWO;integrated security=SSPI;persist security info=False;packet size=4096"; //string cnnString = "Data Source=192.168.1.4;initial catalog=TWO;integrated security=SSPI;persist security info=False;packet size=4096"; //string cnnString = ConfigurationManager.AppSettings["GPCnnString"]; //Use the eConnect_EntryPoint to create the document in Microsoft Dynamics GP eConCall.eConnect_EntryPoint(FactoryCompany.ErpConnection.CnnString, EnumTypes.ConnectionStringType.SqlClient, xmlDocument, EnumTypes.SchemaValidationType.None, ""); return true; } catch (eConnectException) { throw; //return false; } catch (Exception) { throw; //return false; } }
private void saveToSOP(Transaction assessment, string documentID, string defaultSiteID) { try { using (eConnectMethods eConnect = new eConnectMethods()) { string sAssessment; string sXSD; XmlDocument XSDdoc = new XmlDocument(); XSDdoc.Load(@"eConnect.xsd"); sXSD = XSDdoc.OuterXml; serializeSOPObject("assessment.xml", assessment, documentID, defaultSiteID); XmlDocument xmldoc = new XmlDocument(); xmldoc.Load("assessment.xml"); sAssessment = xmldoc.OuterXml; eConnect.eConnect_EntryPoint(connString, EnumTypes.ConnectionStringType.SqlClient, sAssessment, EnumTypes.SchemaValidationType.XSD, sXSD); rollback = false; //20100625 } } catch (Exception ex) { log.Error(ex); throw ex; } }
public bool createOrUpdateCustomer(Customer c) { bool status = false; if ((c.CustomerName == null) || (c.CustomerID == null) || (c.CustomerClass == null)) { return(false); } eConnectMethods eConnect = new eConnectMethods(); try { StringBuilder xml = new StringBuilder(); xml.Append("<eConnect>"); xml.Append("<RMCustomerMasterType>"); xml.Append("<taUpdateCreateCustomerRcd>"); xml.Append("<CUSTNMBR><![CDATA[" + c.CustomerID + "]]></CUSTNMBR>"); xml.Append("<CUSTNAME><![CDATA[" + c.CustomerName + "]]></CUSTNAME>"); xml.Append("<CUSTCLAS><![CDATA[" + c.CustomerClass + "]]></CUSTCLAS>"); xml.Append("<INACTIVE><![CDATA[" + c.Inactive.GetHashCode() + "]]></INACTIVE>"); if (c.ShortName != null) { xml.Append("<SHRTNAME><![CDATA[" + c.ShortName + "]]></SHRTNAME>"); } if (c.StatementName != null) { xml.Append("<STMTNAME><![CDATA[" + c.StatementName + "]]></STMTNAME>"); } if (c.ShipTo != null) { xml.Append("<PRSTADCD><![CDATA[" + c.ShipTo + "]]></PRSTADCD>"); } if (c.StatementTo != null) { xml.Append("<STADDRCD><![CDATA[" + c.StatementTo + "]]></<STADDRCD>"); } if (c.BillTo != null) { xml.Append("<PRBTADCD><![CDATA[" + c.BillTo + "]]></PRBTADCD>"); } if (c.Type != null) { xml.Append("<USERDEF1><![CDATA[" + c.Type + "]]></USERDEF1>"); } if (c.StudentStatus != null) { xml.Append("<USERDEF2><![CDATA[" + c.StudentStatus + "]]></USERDEF2>"); } /* * This data is part of the address */ if (c.CustomerAddress.AddressString != null) { if (c.CustomerAddress.AddressString.Length < 50) { xml.Append("<ADDRESS1><![CDATA[" + c.CustomerAddress.AddressString + "]]></ADDRESS1>"); } else { xml.Append("<ADDRESS1><![CDATA[" + c.CustomerAddress.AddressString.Substring(0, 50) + "]]></ADDRESS1>"); xml.Append("<ADDRESS2><![CDATA[" + c.CustomerAddress.AddressString.Substring(50, c.CustomerAddress.AddressString.Length - 50) + "]]></ADDRESS2>"); } } if (c.CustomerAddress.AddressCode != null) { xml.Append("<ADRSCODE><![CDATA[" + c.CustomerAddress.AddressCode + "]]></ADRSCODE>"); } if (c.CustomerAddress.AddressContact != null) { xml.Append("<CNTCPRSN><![CDATA[" + c.CustomerAddress.AddressContact + "]]></CNTCPRSN>"); } if (c.CustomerAddress.City != null) { xml.Append("<CITY><![CDATA[" + c.CustomerAddress.City + "]]></CITY>"); } if (c.CustomerAddress.State != null) { xml.Append("<STATE><![CDATA[" + c.CustomerAddress.State + "]]></STATE>"); } if (c.CustomerAddress.Country != null) { xml.Append("<COUNTRY><![CDATA[" + c.CustomerAddress.Country + "]]></COUNTRY>"); } if (c.CustomerAddress.Zipcode != null) { xml.Append("<ZIPCODE><![CDATA[" + c.CustomerAddress.Zipcode + "]]></ZIPCODE>"); } if (c.CustomerAddress.PhoneNumber1 != null) { xml.Append("<PHNUMBR1><![CDATA[" + c.CustomerAddress.PhoneNumber1 + "]]></PHNUMBR1>"); } if (c.CustomerAddress.PhoneNumber2 != null) { xml.Append("<PHNUMBR2><![CDATA[" + c.CustomerAddress.PhoneNumber2 + "]]></PHNUMBR2>"); } if (c.CustomerAddress.FaxNumber != null) { xml.Append("<FAX><![CDATA[" + c.CustomerAddress.FaxNumber + "]]></FAX>"); } //CAUSES ERRORS IF COUNTRYCODE DOESNT EXIST //if (c.CustomerAddress.CountryCode != null) xml.Append("<CCODE>" + c.CustomerAddress.CountryCode + "</CCODE>"); xml.Append("<UseCustomerClass>1</UseCustomerClass>"); xml.Append("<UpdateIfExists>1</UpdateIfExists>"); xml.Append("</taUpdateCreateCustomerRcd>"); xml.Append("</RMCustomerMasterType>"); xml.Append("</eConnect>"); status = eConnect.eConnect_EntryPoint(sConnectionString, EnumTypes.ConnectionStringType.SqlClient, xml.ToString(), EnumTypes.SchemaValidationType.None, ""); } catch (eConnectException ex) { Console.WriteLine(ex.ToString()); } return(status); }