Ejemplo n.º 1
0
        public Response CreateInvoice(SOPHeader header, SOPDetail[] detail, SOPDistribution[] distribution, SOPCommissions[] commissions, SOPTax[] tax, SopType soptype, string company)
        {
            var      gpservices = new SOPTransactionClient();
            Response response;

            response = gpservices.CreateSOPTransaction(header, detail, distribution, commissions, tax, soptype, company);
            gpservices.Close();

            return(response);
        }
Ejemplo n.º 2
0
        public Response TransactionCreate(SOPHeader header, List <SOPDetail> detail, List <SOPDistribution> distribution, List <SOPTax> taxes, List <SOPCommissions> commissions, SopType soptype, string company)
        {
            Response response;
            string   server         = ConfigKey.ReadSetting("SERVER");
            string   transactionXML = string.Empty;
            //var server = Properties.Settings.Default.SERVER.ToString();
            string CNX      = "data source=" + server + ";initial catalog=" + company + ";integrated security=SSPI;persist security info=False;packet size=4096";
            var    eConnect = new eConnectRequest();

            SOPTransactionType sopTranType = new SOPTransactionType();
            var getnext = new GetNextDocNumbers();

            getnext.RequireServiceProxy = false;
            string INVOICENUMBER;

            try
            {
                if (header.SOPNUMBE == string.Empty)
                {
                    INVOICENUMBER = getnext.GetNextSOPNumber(IncrementDecrement.Increment, header.DOCID, soptype, CNX);
                }
                else
                {
                    INVOICENUMBER = header.SOPNUMBE;
                }


                sopTranType.taSopHdrIvcInsert           = SetHeaderValues(header, INVOICENUMBER);
                sopTranType.taSopLineIvcInsert_Items    = SetDetailValues(detail, INVOICENUMBER);
                sopTranType.taSopDistribution_Items     = SetDistributionValues(distribution, INVOICENUMBER);
                sopTranType.taSopLineIvcTaxInsert_Items = SetTaxValues(taxes, INVOICENUMBER);
                sopTranType.taSopCommissions_Items      = SetCommissionValues(commissions, INVOICENUMBER);

                transactionXML = SerializeSOPTransaction(sopTranType);
                response       = eConnect.CreateGPTransaction(CNX, transactionXML);

                return(response);
            }
            catch (Exception)
            {
                throw;
            }
        }
        //public void DoWork()
        //{
        //}

        /// <summary>
        /// Create Invoince
        /// </summary>
        /// <param name="header"></param>
        /// <param name="detail"></param>
        /// <param name="distribution"></param>
        /// <param name="commissions"></param>
        /// <param name="taxes"></param>
        /// <param name="company"></param>
        /// <returns></returns>
        public Response CreateSOPTransaction(SOPHeader header, List <SOPDetail> detail, List <SOPDistribution> distribution, List <SOPCommissions> commissions, List <SOPTax> taxes, SopType soptype, string company)
        {
            SOPTransactionCreate soptran = new SOPTransactionCreate();

            return(soptran.TransactionCreate(header, detail, distribution, taxes, commissions, soptype, company));
        }
Ejemplo n.º 4
0
        private taSopHdrIvcInsert SetHeaderValues(SOPHeader header, string invoicenumber)
        {
            try
            {
                var sopHeaderInsert = new taSopHdrIvcInsert();
                sopHeaderInsert.SOPTYPE = header.SOPTYPE;
                sopHeaderInsert.DOCID   = header.DOCID;
                //sopHeaderInsert.DOCDATE = header.DOCDATE.ToString("dd/MM/yyyy");
                sopHeaderInsert.DOCDATE  = header.DOCDATE.ToString("yyyy-MM-dd");
                sopHeaderInsert.SOPNUMBE = invoicenumber;
                sopHeaderInsert.ORIGNUMB = header.ORIGNUMB;
                sopHeaderInsert.ORIGTYPE = header.ORIGTYPE.GetValueOrDefault();
                sopHeaderInsert.TAXSCHID = header.TAXSCHID;
                sopHeaderInsert.FRTSCHID = header.FRTSCHID;
                sopHeaderInsert.MSCSCHID = header.MSCSCHID;
                sopHeaderInsert.SHIPMTHD = header.SHIPMTHD;
                sopHeaderInsert.TAXAMNT  = header.TAXAMNT.GetValueOrDefault();
                sopHeaderInsert.LOCNCODE = header.LOCNCODE;
                sopHeaderInsert.FREIGHT  = header.FREIGHT.GetValueOrDefault();
                sopHeaderInsert.MISCAMNT = header.MISCAMNT.GetValueOrDefault();
                sopHeaderInsert.TRDISAMT = header.TRDISAMT.GetValueOrDefault();
                sopHeaderInsert.TRADEPCT = header.TRADEPCT.GetValueOrDefault();
                sopHeaderInsert.DISTKNAM = header.DISTKNAM.GetValueOrDefault();
                sopHeaderInsert.MRKDNAMT = header.MRKDNAMT.GetValueOrDefault();

                sopHeaderInsert.CUSTNAME                      = header.CSTPONBR;
                sopHeaderInsert.ShipToName                    = header.ShipToName;
                sopHeaderInsert.ADDRESS1                      = header.ADDRESS1;
                sopHeaderInsert.ADDRESS2                      = header.ADDRESS2;
                sopHeaderInsert.ADDRESS3                      = header.ADDRESS3;
                sopHeaderInsert.CNTCPRSN                      = header.CNTCPRSN;
                sopHeaderInsert.FAXNUMBR                      = header.FAXNUMBR;
                sopHeaderInsert.CITY                          = header.CITY;
                sopHeaderInsert.STATE                         = header.STATE;
                sopHeaderInsert.ZIPCODE                       = header.ZIPCODE;
                sopHeaderInsert.COUNTRY                       = header.COUNTRY;
                sopHeaderInsert.PHNUMBR1                      = header.PHNUMBR1;
                sopHeaderInsert.PHNUMBR2                      = header.PHNUMBR2;
                sopHeaderInsert.PHNUMBR3                      = header.PHNUMBR3;
                sopHeaderInsert.Print_Phone_NumberGB          = 0;
                sopHeaderInsert.Print_Phone_NumberGBSpecified = true;
                sopHeaderInsert.SUBTOTAL                      = header.SUBTOTAL.GetValueOrDefault();
                sopHeaderInsert.DOCAMNT                       = header.DOCAMNT.GetValueOrDefault();
                sopHeaderInsert.PYMTRCVD                      = header.PYMTRCVD.GetValueOrDefault();
                sopHeaderInsert.SALSTERR                      = header.SALSTERR;
                sopHeaderInsert.SLPRSNID                      = header.SLPRSNID;
                sopHeaderInsert.UPSZONE                       = header.UPSZONE;
                sopHeaderInsert.USER2ENT                      = header.USER2ENT;
                sopHeaderInsert.BACHNUMB                      = header.BACHNUMB;
                sopHeaderInsert.PRBTADCD                      = header.PRBTADCD;
                sopHeaderInsert.PRSTADCD                      = header.PRSTADCD;
                sopHeaderInsert.FRTTXAMT                      = header.FRTTXAMT.GetValueOrDefault();
                sopHeaderInsert.MSCTXAMT                      = header.MSCTXAMT.GetValueOrDefault();

                if (header.ORDRDATE != null)
                {
                    sopHeaderInsert.ORDRDATE = header.ORDRDATE.GetValueOrDefault().ToString("yyyy-MM-dd");
                }

                sopHeaderInsert.MSTRNUMB = header.MSTRNUMB.GetValueOrDefault();
                sopHeaderInsert.PYMTRMID = header.PYMTRMID;

                if (header.DUEDATE != null)
                {
                    sopHeaderInsert.DUEDATE = header.DUEDATE.GetValueOrDefault().ToString("yyyy-MM-dd");
                }

                if (header.DISCDATE != null)
                {
                    sopHeaderInsert.DISCDATE = header.DISCDATE.GetValueOrDefault().ToString("yyyy-MM-dd");
                }

                sopHeaderInsert.REFRENCE = header.REFRENCE;
                sopHeaderInsert.USINGHEADERLEVELTAXES = header.USINGHEADERLEVELTAXES.GetValueOrDefault();
                sopHeaderInsert.BatchCHEKBKID         = header.BatchCHEKBKID;
                sopHeaderInsert.CREATECOMM            = header.CREATECOMM.GetValueOrDefault();
                sopHeaderInsert.COMMAMNT    = header.COMMAMNT;
                sopHeaderInsert.COMPRCNT    = header.COMPRCNT;
                sopHeaderInsert.CREATEDIST  = header.CREATEDIST.GetValueOrDefault();
                sopHeaderInsert.CREATETAXES = header.CREATETAXES.GetValueOrDefault();
                sopHeaderInsert.DEFTAXSCHDS = header.DEFTAXSCHDS.GetValueOrDefault();
                sopHeaderInsert.CURNCYID    = header.CURNCYID;
                sopHeaderInsert.XCHGRATE    = header.XCHGRATE.GetValueOrDefault();
                sopHeaderInsert.RATETPID    = header.RATETPID;

                if (header.EXPNDATE != null)
                {
                    sopHeaderInsert.EXPNDATE = header.EXPNDATE.GetValueOrDefault().ToString("yyyy-MM-dd");
                }

                if (header.EXCHDATE != null)
                {
                    sopHeaderInsert.EXCHDATE = header.EXCHDATE.GetValueOrDefault().ToString("yyyy-MM-dd");
                }

                sopHeaderInsert.EXGTBDSC = header.EXGTBDSC;
                sopHeaderInsert.EXTBLSRC = header.EXTBLSRC;
                sopHeaderInsert.RATEEXPR = header.RATEEXPR.GetValueOrDefault();
                sopHeaderInsert.DYSTINCR = header.DYSTINCR.GetValueOrDefault();
                sopHeaderInsert.RATEVARC = header.RATEVARC.GetValueOrDefault();
                sopHeaderInsert.TRXDTDEF = header.TRXDTDEF.GetValueOrDefault();
                sopHeaderInsert.RTCLCMTD = header.RTCLCMTD.GetValueOrDefault();
                sopHeaderInsert.PRVDSLMT = header.PRVDSLMT.GetValueOrDefault();
                sopHeaderInsert.DATELMTS = header.DATELMTS.GetValueOrDefault();

                if (header.TIME1 != null)
                {
                    sopHeaderInsert.TIME1 = header.TIME1.GetValueOrDefault().ToString("yyyy-MM-dd");
                }

                sopHeaderInsert.DISAVAMT           = header.DISAVAMT.GetValueOrDefault();
                sopHeaderInsert.DSCDLRAM           = header.DSCDLRAM.GetValueOrDefault();
                sopHeaderInsert.DSCPCTAM           = header.DSCPCTAM.GetValueOrDefault();
                sopHeaderInsert.FREIGTBLE          = header.FREIGTBLE.GetValueOrDefault();
                sopHeaderInsert.MISCTBLE           = header.MISCTBLE.GetValueOrDefault();
                sopHeaderInsert.COMMNTID           = header.COMMNTID;
                sopHeaderInsert.COMMENT_1          = header.COMMENT_1;
                sopHeaderInsert.COMMENT_2          = header.COMMENT_2;
                sopHeaderInsert.COMMENT_3          = header.COMMENT_3;
                sopHeaderInsert.COMMENT_4          = header.COMMENT_4;
                sopHeaderInsert.GPSFOINTEGRATIONID = header.GPSFOINTEGRATIONID;
                sopHeaderInsert.INTEGRATIONSOURCE  = header.INTEGRATIONSOURCE.GetValueOrDefault();
                sopHeaderInsert.INTEGRATIONID      = header.INTEGRATIONID;

                if (header.ReqShipDate != null)
                {
                    sopHeaderInsert.ReqShipDate = header.ReqShipDate.GetValueOrDefault().ToString("yyyy-MM-dd");
                }

                sopHeaderInsert.RequesterTrx   = header.RequesterTrx.GetValueOrDefault();
                sopHeaderInsert.CKCreditLimit  = header.CKCreditLimit.GetValueOrDefault();
                sopHeaderInsert.CKHOLD         = header.CKHOLD.GetValueOrDefault();
                sopHeaderInsert.UpdateExisting = header.UpdateExisting.GetValueOrDefault();

                if (header.QUOEXPDA != null)
                {
                    sopHeaderInsert.QUOEXPDA = header.QUOEXPDA.GetValueOrDefault().ToShortDateString();
                }

                if (header.QUOTEDAT != null)
                {
                    sopHeaderInsert.QUOTEDAT = header.QUOTEDAT.GetValueOrDefault().ToShortDateString();
                }

                if (header.INVODATE != null)
                {
                    sopHeaderInsert.INVODATE = header.INVODATE.GetValueOrDefault().ToShortDateString();
                }

                if (header.BACKDATE != null)
                {
                    sopHeaderInsert.BACKDATE = header.BACKDATE.GetValueOrDefault().ToShortDateString();
                }

                if (header.RETUDATE != null)
                {
                    sopHeaderInsert.RETUDATE = header.RETUDATE.GetValueOrDefault().ToShortDateString();
                }


                sopHeaderInsert.CMMTTEXT      = header.CMMTTEXT;
                sopHeaderInsert.PRCLEVEL      = header.PRCLEVEL;
                sopHeaderInsert.DEFPRICING    = header.DEFPRICING.GetValueOrDefault();
                sopHeaderInsert.TAXEXMT1      = header.TAXEXMT1;
                sopHeaderInsert.TAXEXMT2      = header.TAXEXMT2;
                sopHeaderInsert.TXRGNNUM      = header.TXRGNNUM;
                sopHeaderInsert.REPTING       = header.REPTING.GetValueOrDefault();
                sopHeaderInsert.TRXFREQU      = header.TRXFREQU.GetValueOrDefault();
                sopHeaderInsert.TIMETREP      = header.TIMETREP.GetValueOrDefault();
                sopHeaderInsert.QUOTEDYSTINCR = header.QUOTEDYSTINCR.GetValueOrDefault();
                sopHeaderInsert.NOTETEXT      = header.NOTETEXT;
                sopHeaderInsert.CUSTNMBR      = header.CUSTNMBR;

                return(sopHeaderInsert);
            }
            catch (Exception)
            {
                throw;
            }
        }