Ejemplo n.º 1
0
        public bool Upload(string companyID, out string lastErrorMessage, out bool recordsReturned, out int recordCount, Boolean deliveryRecord)
        {
            DateTime    extractedDate  = System.DateTime.Now;
            Guid        extractBatchID = System.Guid.NewGuid();
            List <long> aomPurchaseDeliveryIDs;

            lastErrorMessage = "";
            recordCount      = 0;

            int    ledger         = 0;
            string orderNumber    = "";
            string deliveryNumber = "";
            int    aomPurchaseDeliveryHeaderID;

            recordsReturned = false;

            //Get the customer changes
            var aomPurchaseDeliveryList = dal.GetPurchaseDeliveryHeaders(companyID, Constants.customerBatchSize);


            //Create a reference to the invent Service
            UploadPurchOrderService.TEC_STG_PurchOrderServiceClient axPurchaseOrderClient = new UploadPurchOrderService.TEC_STG_PurchOrderServiceClient();

            //inject my endpoint behavior
            axPurchaseOrderClient.Endpoint.Behaviors.Add(new SimpleEndpointBehavior());

            //This is the completed invent message (1 or more items)
            UploadPurchOrderService.AxdTEC_STG_PurchOrder axPurchaseDeliveries = new UploadPurchOrderService.AxdTEC_STG_PurchOrder();

            //This is the blank call context - this is optional, however the place holder must be in the file
            UploadPurchOrderService.CallContext callContext = new UploadPurchOrderService.CallContext();

            //Set the company ID for teh call context
            callContext.Company = companyID;

            try
            {
                ArrayList axPurchaseDeliveryCollection = new ArrayList();
                aomPurchaseDeliveryIDs = new List <long>();
                foreach (AOMPurchaseDeliveryHeadersEntity sqlPurchaseDeliveryHeader in aomPurchaseDeliveryList)
                {
                    orderNumber = sqlPurchaseDeliveryHeader.EXTERNAL_ORD_ID.Trim();
                    aomPurchaseDeliveryHeaderID = sqlPurchaseDeliveryHeader.AOMPurchaseDeliveryHeaderID;

                    deliveryNumber = string.Format("{0}-{1}", sqlPurchaseDeliveryHeader.EXTERNAL_DEL_ID.Trim(), sqlPurchaseDeliveryHeader.HeaderSequence.ToString());

                    UploadPurchOrderService.AxdEntity_TEC_STG_PurchTable axPurchaseDeliveryHeader = new UploadPurchOrderService.AxdEntity_TEC_STG_PurchTable();

                    Debug.WriteLine(orderNumber);
                    recordCount++;

                    axPurchaseDeliveryHeader.OrderUpdateType = UploadPurchOrderService.AxdEnum_TEC_OrderUpdateType.Delivery;

                    axPurchaseDeliveryHeader.OrderUpdateTypeSpecified = true;
                    axPurchaseDeliveryHeader.EXTERNAL_ORD_ID          = sqlPurchaseDeliveryHeader.EXTERNAL_ORD_ID;

                    //Add in the cost centre to the header - at the momenteverything is 0999
                    ArrayList axOrderHeaderDimensions = new ArrayList();
                    UploadPurchOrderService.AxdType_DimensionAttributeValue dimensionHeader = new UploadPurchOrderService.AxdType_DimensionAttributeValue();
                    dimensionHeader.Name  = "CostCenter";
                    dimensionHeader.Value = "0999"; //ToDo: Add in the correct value
                    axOrderHeaderDimensions.Add(dimensionHeader);
                    //Now add the array to a dimension set
                    UploadPurchOrderService.AxdType_DimensionAttributeValueSet dimensionHeaderSet = new UploadPurchOrderService.AxdType_DimensionAttributeValueSet();
                    dimensionHeaderSet.Values = (UploadPurchOrderService.AxdType_DimensionAttributeValue[])axOrderHeaderDimensions.ToArray(typeof(UploadPurchOrderService.AxdType_DimensionAttributeValue));
                    //Finally add the dimension set the Order
                    axPurchaseDeliveryHeader.DefaultDimension = dimensionHeaderSet;

                    //axPurchaseOrderHeader.Add_Reference = sqlPurchaseOrderHeader.Inv_Add_Reference;
                    axPurchaseDeliveryHeader.Add_City      = sqlPurchaseDeliveryHeader.ADD_CITY;
                    axPurchaseDeliveryHeader.Add_Country   = sqlPurchaseDeliveryHeader.ADD_COUNTRY;
                    axPurchaseDeliveryHeader.Add_Line_1    = sqlPurchaseDeliveryHeader.ADD_LINE_1;
                    axPurchaseDeliveryHeader.Add_Line_2    = sqlPurchaseDeliveryHeader.ADD_LINE_2;
                    axPurchaseDeliveryHeader.Add_Territory = sqlPurchaseDeliveryHeader.ADD_TERRITORY;
                    axPurchaseDeliveryHeader.Add_Zipcode   = sqlPurchaseDeliveryHeader.ADD_ZIPCODE;

                    //Site numbers
                    //string inventLocationID = sqlPurchaseOrderHeader.InventSiteId.ToString();
                    axPurchaseDeliveryHeader.InventLocationId = sqlPurchaseDeliveryHeader.INVENTLOCATIONID;
                    //CJ - 2016-09-01 - This is now populated in the database
                    //axPurchaseDeliveryHeader.InventSiteId = Constants.defaultSpicersSiteId;
                    axPurchaseDeliveryHeader.InventSiteId = sqlPurchaseDeliveryHeader.INVENTSITEID;

                    //axPurchaseOrderHeader.Invoice_Name = sqlPurchaseOrderHeader.Invoice_Name;
                    axPurchaseDeliveryHeader.OperatorCode = sqlPurchaseDeliveryHeader.OPERATORCODE;
                    axPurchaseDeliveryHeader.DlvCity      = sqlPurchaseDeliveryHeader.DLVCITY;
                    //axPurchaseOrderHeader.Shp_Add_Reference = sqlPurchaseDeliveryHeader.Shp_Add_Reference;
                    axPurchaseDeliveryHeader.DlvCountry    = sqlPurchaseDeliveryHeader.DLVCOUNTRY;
                    axPurchaseDeliveryHeader.DlvName       = sqlPurchaseDeliveryHeader.DLVNAME;
                    axPurchaseDeliveryHeader.DlvAdd_Line_1 = sqlPurchaseDeliveryHeader.DLVADD_LINE_1;
                    axPurchaseDeliveryHeader.DlvAdd_Line_2 = sqlPurchaseDeliveryHeader.DLVADD_LINE_2;
                    axPurchaseDeliveryHeader.DlvTerritory  = sqlPurchaseDeliveryHeader.DLVTERRITORY;
                    axPurchaseDeliveryHeader.DlvZipcode    = sqlPurchaseDeliveryHeader.DLVZIPCODE;

                    if (sqlPurchaseDeliveryHeader.HeaderSequence == 1)
                    {
                        axPurchaseDeliveryHeader.Type = UploadPurchOrderService.AxdExtType_TEC_Type.Insert;
                    }
                    else
                    {
                        axPurchaseDeliveryHeader.Type = UploadPurchOrderService.AxdExtType_TEC_Type.Update;
                    }

                    axPurchaseDeliveryHeader.TypeSpecified = true;

                    axPurchaseDeliveryHeader.PurchaseType          = UploadPurchOrderService.AxdEnum_PurchaseType.Purch; //Purchase order type
                    axPurchaseDeliveryHeader.PurchaseTypeSpecified = true;
                    axPurchaseDeliveryHeader.VendAccount           = sqlPurchaseDeliveryHeader.VENDACCOUNT;
                    //Get the purchase lines

                    var aomLineList = dal.GetPurchaseDeliveryLines(companyID, orderNumber, aomPurchaseDeliveryHeaderID);
                    if (aomLineList != null)
                    {
                        ArrayList axPurchaseOrderLines = new ArrayList();
                        foreach (var sqlPurchaseDeliveryLine in aomLineList)
                        {
                            UploadPurchOrderService.AxdEntity_TEC_STG_PurchLine axPurchaseOrderLine = new UploadPurchOrderService.AxdEntity_TEC_STG_PurchLine();
                            axPurchaseOrderLine.EXTERNAL_ORD_ID = sqlPurchaseDeliveryLine.EXTERNAL_ORD_ID;

                            ArrayList axOrderLineDimensions = new ArrayList();
                            UploadPurchOrderService.AxdType_DimensionAttributeValue dimensionLine = new UploadPurchOrderService.AxdType_DimensionAttributeValue();
                            //Add in the cost centre dimension
                            dimensionLine.Name  = "CostCenter";
                            dimensionLine.Value = "0999"; //ToDo: sqlPurchaseOrderLine.Dimension1; //dimensionValue;
                            axOrderLineDimensions.Add(dimensionLine);
                            //Now add the array to a dimension set
                            UploadPurchOrderService.AxdType_DimensionAttributeValueSet dimensionLineSet = new UploadPurchOrderService.AxdType_DimensionAttributeValueSet();
                            dimensionLineSet.Values = (UploadPurchOrderService.AxdType_DimensionAttributeValue[])axOrderLineDimensions.ToArray(typeof(UploadPurchOrderService.AxdType_DimensionAttributeValue));
                            //Finally add the dimension set the Order
                            axPurchaseOrderLine.DefaultDimension = dimensionLineSet;

                            axPurchaseOrderLine.Itemid = sqlPurchaseDeliveryLine.ITEMID;
                            axPurchaseOrderLine.Name   = sqlPurchaseDeliveryLine.NAME;

                            axPurchaseOrderLine.LineAmount          = sqlPurchaseDeliveryLine.LINEAMOUNT;
                            axPurchaseOrderLine.LineAmountSpecified = true;

                            //2016-01-21 -- we were getting rounding errors from AOM
                            axPurchaseOrderLine.PurchPrice          = (sqlPurchaseDeliveryLine.LINEAMOUNT / sqlPurchaseDeliveryLine.PURCHQTY);
                            axPurchaseOrderLine.PurchPriceSpecified = true;

                            axPurchaseOrderLine.LineNum          = sqlPurchaseDeliveryLine.Seq;
                            axPurchaseOrderLine.LineNumSpecified = true;

                            //if (sqlPurchaseDeliveryLine.PURCHPRICE != null)
                            //{
                            //    axPurchaseOrderLine.PurchPrice = sqlPurchaseDeliveryLine.PURCHPRICE;
                            //    axPurchaseOrderLine.PurchPriceSpecified = true;
                            //}

                            axPurchaseOrderLine.PurchQty = sqlPurchaseDeliveryLine.PURCHQTY;

                            axPurchaseOrderLine.PurchReceivedNow = sqlPurchaseDeliveryLine.PURCHQTY;
                            if (deliveryRecord == true)
                            {
                                axPurchaseOrderLine.PurchReceivedNow = sqlPurchaseDeliveryLine.PURCHQTY;
                            }
                            axPurchaseOrderLine.PurchReceivedNowSpecified = true;

                            axPurchaseOrderLine.PurchQtySpecified = true;
                            axPurchaseOrderLine.EXTERNAL_DEL_ID   = deliveryNumber;

                            axPurchaseOrderLine.PriceUnit          = 1;// sqlPurchaseOrderLine.PriceUnit; //Need to get this added
                            axPurchaseOrderLine.PriceUnitSpecified = true;

                            axPurchaseOrderLine.Type = UploadPurchOrderService.AxdExtType_TEC_Type.Insert;

                            //Add the line to the array
                            axPurchaseOrderLines.Add(axPurchaseOrderLine);
                        }
                        //Now add the order lines to the order header.
                        axPurchaseDeliveryHeader.TEC_STG_PurchLine = (UploadPurchOrderService.AxdEntity_TEC_STG_PurchLine[])axPurchaseOrderLines.ToArray(typeof(UploadPurchOrderService.AxdEntity_TEC_STG_PurchLine));
                    }
                    axPurchaseDeliveryCollection.Add(axPurchaseDeliveryHeader);
                    aomPurchaseDeliveryIDs.Add(sqlPurchaseDeliveryHeader.AOMPurchaseDeliveryHeaderID);
                }
                if (recordCount != 0)
                {
                    dal.UpdateAOMPurchaseDeliveryHeaderExtractStatus(aomPurchaseDeliveryIDs, Constants.beingExtracted);
                    axPurchaseDeliveries.TEC_STG_PurchTable = (UploadPurchOrderService.AxdEntity_TEC_STG_PurchTable[])axPurchaseDeliveryCollection.ToArray(typeof(UploadPurchOrderService.AxdEntity_TEC_STG_PurchTable));
                    //Now process the order
                    recordsReturned = true;
                    var response = axPurchaseOrderClient.create(callContext, axPurchaseDeliveries);
                    //Save the records - this updates the status to Updated
                    dal.UpdateAOMPurchaseDeliveryHeaderExtractStatus(aomPurchaseDeliveryIDs, Constants.extracted);
                }
            }
            catch (FaultException exFault)
            {
                Debug.WriteLine("Error occured whilst calling TecPurchOrderService" + exFault.ToString());
                lastErrorMessage = exFault.ToString();
                return(false);
            }
            catch (CommunicationException exComm)
            {
                Debug.WriteLine("Error occured whilst calling TecPurchOrderService" + exComm.ToString());
                lastErrorMessage = exComm.ToString();
                return(false);
            }
            catch (Exception ex)
            {
                Debug.WriteLine("Error occured whilst calling TecPurchOrderService" + ex.ToString());
                lastErrorMessage = ex.ToString();
                return(false);
            }
            lastErrorMessage = "OK";
            return(true);
        }
Ejemplo n.º 2
0
        public bool Upload(string companyID, out string lastErrorMessage, out bool recordsReturned, out int recordCount)
        {
            DateTime    extractedDate  = System.DateTime.Now;
            Guid        extractBatchID = System.Guid.NewGuid();
            List <long> purchaseInvoiceIDs;

            recordsReturned = false;
            string   externalInvID = "";
            DateTime invoiceDate;
            string   vendAccount = "";
            DateTime dateAdded;
            bool     hasPurchaseLines = false;
            int      validRecords     = 0;

            lastErrorMessage = "";
            recordCount      = 0;

            Guid invoiceGUID;

            //Get the purchase invoices
            var purchaseInvoiceList = dal.GetPurchaseInvoices(companyID, Constants.purchaseInvoiceBatchSize);

            //Create a reference to the purchase invoice service
            UploadPurchOrderService.TEC_STG_PurchOrderServiceClient axPurchaseInvoiceClient = new UploadPurchOrderService.TEC_STG_PurchOrderServiceClient();

            //inject my endpoint behavior
            axPurchaseInvoiceClient.Endpoint.Behaviors.Add(new SimpleEndpointBehavior());

            //Set the call context - this contains the company details:
            UploadPurchOrderService.CallContext axContext = new UploadPurchOrderService.CallContext();
            //Set the company ID for teh call context
            axContext.Company = companyID;

            //This is the completed invent message (1 or more items)
            UploadPurchOrderService.AxdTEC_STG_PurchOrder axPurchaseOrders = new UploadPurchOrderService.AxdTEC_STG_PurchOrder();

            try
            {
                ArrayList axPurchaseInvoiceCollection = new ArrayList();
                purchaseInvoiceIDs = new List <long>();
                foreach (PurchaseInvoiceHeaderEntity sqlPurchaseInvoiceHeader in purchaseInvoiceList)
                {
                    recordCount++;
                    //This is the uniue identifier for the invoice record
                    externalInvID = sqlPurchaseInvoiceHeader.EXTERNAL_INV_ID.Trim();
                    invoiceDate   = sqlPurchaseInvoiceHeader.InvoiceDate;
                    vendAccount   = sqlPurchaseInvoiceHeader.VENDACCOUNT.Trim();
                    dateAdded     = sqlPurchaseInvoiceHeader.DateAdded;
                    invoiceGUID   = sqlPurchaseInvoiceHeader.InvoiceGUID;

                    UploadPurchOrderService.AxdEntity_TEC_STG_PurchTable axPurchaseOrderHeader = new UploadPurchOrderService.AxdEntity_TEC_STG_PurchTable();
                    axPurchaseOrderHeader.OrderUpdateType          = UploadPurchOrderService.AxdEnum_TEC_OrderUpdateType.Invoice;
                    axPurchaseOrderHeader.OrderUpdateTypeSpecified = true;

                    axPurchaseOrderHeader.InvoiceDate          = invoiceDate;
                    axPurchaseOrderHeader.InvoiceDateSpecified = true;

                    //get the buyers order number
                    axPurchaseOrderHeader.EXTERNAL_ORD_ID = sqlPurchaseInvoiceHeader.EXTERNAL_ORD_ID.Trim();

                    ArrayList axOrderHeaderDimensions = new ArrayList();
                    UploadPurchOrderService.AxdType_DimensionAttributeValue dimensionHeader = new UploadPurchOrderService.AxdType_DimensionAttributeValue();

                    //dimensionHeader.Name = "CostCenter";
                    //dimensionHeader.Value = "0999"; //dimensionValue - will take the dimensions from the line
                    //axOrderHeaderDimensions.Add(dimensionHeader);
                    ////Now add the array to a dimension set
                    //tecPurchOrderService.AxdType_DimensionAttributeValueSet dimensionHeaderSet = new tecPurchOrderService.AxdType_DimensionAttributeValueSet();
                    //dimensionHeaderSet.Values = (tecPurchOrderService.AxdType_DimensionAttributeValue[])axOrderHeaderDimensions.ToArray(typeof(tecPurchOrderService.AxdType_DimensionAttributeValue));
                    ////Finally add the dimension set the Order
                    //axPurchaseOrderHeader.DefaultDimension = dimensionHeaderSet;

                    //axPurchaseOrderHeader.Add_Reference = sqlPurchaseOrderHeader.Inv_Add_Reference;
                    axPurchaseOrderHeader.Add_City      = ""; // sqlPurchaseInvoiceHeader.SupplierCity;
                    axPurchaseOrderHeader.Add_Country   = ""; // sqlPurchaseInvoiceHeader.SupplierState;
                    axPurchaseOrderHeader.Add_Line_1    = ""; // sqlPurchaseInvoiceHeader.SupplierAddressLine;
                    axPurchaseOrderHeader.Add_Line_2    = "";
                    axPurchaseOrderHeader.Add_Territory = ""; // sqlPurchaseInvoiceHeader.SupplierCountryCode;
                    axPurchaseOrderHeader.Add_Zipcode   = ""; // sqlPurchaseInvoiceHeader.SupplierPostCode.Substring(1, 16);


                    //This is an odd one as we will need to get the site number from the purchase order first
                    //axPurchaseOrderHeader.InventLocationId = "0";// sqlPurchaseOrderHeader.Inventlocationid; (Do not update the site as this has already been provided)
                    axPurchaseOrderHeader.InventSiteId = Constants.defaultSpicersSiteId.ToString();

                    //axPurchaseOrderHeader.Invoice_Name = sqlPurchaseOrderHeader.Invoice_Name;
                    axPurchaseOrderHeader.OperatorCode          = ""; //Not on an Invoice
                    axPurchaseOrderHeader.DlvCity               = ""; //sqlPurchaseInvoiceHeader.DeliveryToCity;
                    axPurchaseOrderHeader.DlvCountry            = ""; //sqlPurchaseInvoiceHeader.InvoiceToCountryCode;
                    axPurchaseOrderHeader.DlvName               = ""; //sqlPurchaseInvoiceHeader.DeliveryToName;
                    axPurchaseOrderHeader.DlvAdd_Line_1         = ""; //sqlPurchaseInvoiceHeader.DeliveryToAddressLine ;
                    axPurchaseOrderHeader.DlvAdd_Line_2         = "";
                    axPurchaseOrderHeader.DlvTerritory          = ""; //sqlPurchaseInvoiceHeader.DeliveryToState;
                    axPurchaseOrderHeader.DlvZipcode            = ""; //sqlPurchaseInvoiceHeader.DeliveryToPostCode;
                    axPurchaseOrderHeader.Type                  = UploadPurchOrderService.AxdExtType_TEC_Type.Update;
                    axPurchaseOrderHeader.TypeSpecified         = true;
                    axPurchaseOrderHeader.PurchaseType          = UploadPurchOrderService.AxdEnum_PurchaseType.Purch; //Purchase order type
                    axPurchaseOrderHeader.PurchaseTypeSpecified = true;
                    axPurchaseOrderHeader.VendAccount           = vendAccount;

                    axPurchaseOrderHeader.VATAmount          = sqlPurchaseInvoiceHeader.VATAmount;
                    axPurchaseOrderHeader.VATAmountSpecified = true;

                    axPurchaseOrderHeader.Order_Total_Gross          = sqlPurchaseInvoiceHeader.Order_Total_Gross;
                    axPurchaseOrderHeader.Order_Total_GrossSpecified = true;

                    axPurchaseOrderHeader.Order_Total_Net          = sqlPurchaseInvoiceHeader.Order_Total_Net;
                    axPurchaseOrderHeader.Order_Total_NetSpecified = true;

                    axPurchaseOrderHeader.VendorRef   = externalInvID;
                    axPurchaseOrderHeader.InvoiceDate = invoiceDate;

                    axPurchaseOrderHeader.InvoiceId = externalInvID;

                    //Get the purchase invoice lines
                    hasPurchaseLines = false;
                    var sqlPurchaseInvoiceLines = dal.GetPurchaseInvoiceLines(companyID, invoiceDate, externalInvID, vendAccount);
                    if (sqlPurchaseInvoiceLines != null && sqlPurchaseInvoiceLines.Count() > 0)
                    {
                        hasPurchaseLines = true;
                        ArrayList axPurchaseInvoiceLines = new ArrayList();
                        foreach (var sqlPurchaseInvoiceLine in sqlPurchaseInvoiceLines)
                        {
                            UploadPurchOrderService.AxdEntity_TEC_STG_PurchLine axPurchaseInvoiceLine = new UploadPurchOrderService.AxdEntity_TEC_STG_PurchLine();
                            axPurchaseInvoiceLine.EXTERNAL_ORD_ID = sqlPurchaseInvoiceLine.EXTERNAL_ORD_ID;

                            //ArrayList axOrderLineDimensions = new ArrayList();
                            //tecPurchOrderService.AxdType_DimensionAttributeValue dimensionLine = new tecPurchOrderService.AxdType_DimensionAttributeValue();
                            //dimensionLine.Name = "CostCenter";
                            //dimensionLine.Value = "0999"; //sqlPurchaseOrderLine.Dimension1; //dimensionValue;
                            //axOrderLineDimensions.Add(dimensionLine);
                            ////Now add the array to a dimension set
                            //tecPurchOrderService.AxdType_DimensionAttributeValueSet dimensionLineSet = new tecPurchOrderService.AxdType_DimensionAttributeValueSet();
                            //dimensionLineSet.Values = (tecPurchOrderService.AxdType_DimensionAttributeValue[])axOrderLineDimensions.ToArray(typeof(tecPurchOrderService.AxdType_DimensionAttributeValue));
                            ////Finally add the dimension set the Order
                            //axPurchaseInvoiceLine.DefaultDimension = dimensionLineSet;

                            //axPurchaseInvoiceLine.InventSiteId = sqlPurchaseOrderLine.InventSiteId; //Takes the site from the order header
                            axPurchaseInvoiceLine.Itemid = sqlPurchaseInvoiceLine.ItemID;
                            axPurchaseInvoiceLine.Name   = sqlPurchaseInvoiceLine.Name;

                            //axPurchaseInvoiceLine.LineNum = sqlPurchaseInvoiceLine.LineNumber;
                            axPurchaseInvoiceLine.LineNum          = sqlPurchaseInvoiceLine.LineNum;
                            axPurchaseInvoiceLine.LineNumSpecified = true;

                            //axPurchaseInvoiceLine.EXTERNAL_DEL_ID = sqlPurchaseInvoiceLine.DeliveryNoteNumber;
                            axPurchaseInvoiceLine.EXTERNAL_DEL_ID = sqlPurchaseInvoiceLine.EXTERNAL_DEL_ID;

                            //axPurchaseInvoiceLine.PurchPrice = sqlPurchaseInvoiceLine.UnitPrice;
                            axPurchaseInvoiceLine.PurchPrice          = sqlPurchaseInvoiceLine.PurchPrice;
                            axPurchaseInvoiceLine.PurchPriceSpecified = true;

                            axPurchaseInvoiceLine.PurchQty                  = sqlPurchaseInvoiceLine.PurchQty;          //This is the original qty
                            axPurchaseInvoiceLine.LineAmount                = sqlPurchaseInvoiceLine.LINE_TOTAL_EX_VAT; //Done
                            axPurchaseInvoiceLine.PurchReceivedNow          = sqlPurchaseInvoiceLine.PurchReceivedNow;  //Done
                            axPurchaseInvoiceLine.VATLineAmount             = sqlPurchaseInvoiceLine.VATAmount;         //Done
                            axPurchaseInvoiceLine.LineAmountSpecified       = true;                                     //Done
                            axPurchaseInvoiceLine.PurchQtySpecified         = true;                                     //Done
                            axPurchaseInvoiceLine.PurchReceivedNowSpecified = true;                                     //Done
                            axPurchaseInvoiceLine.VATLineAmountSpecified    = true;                                     //Done
                            axPurchaseInvoiceLine.EXTERNAL_INV_ID           = externalInvID;                            //Done
                            axPurchaseInvoiceLine.PriceUnit                 = 1;                                        // sqlPurchaseOrderLine.PriceUnit; //Need to get this added
                            axPurchaseInvoiceLine.PriceUnitSpecified        = true;

                            //2016-07-08 New field for the Invoice Price - basically the Line Amount / Receievd Qty
                            axPurchaseInvoiceLine.InvoicePrice          = (sqlPurchaseInvoiceLine.LINE_TOTAL_EX_VAT / sqlPurchaseInvoiceLine.PurchReceivedNow);
                            axPurchaseInvoiceLine.InvoicePriceSpecified = true;

                            axPurchaseInvoiceLine.Type          = UploadPurchOrderService.AxdExtType_TEC_Type.Update;
                            axPurchaseInvoiceLine.TypeSpecified = true;
                            //Add the line to the array
                            axPurchaseInvoiceLines.Add(axPurchaseInvoiceLine);
                        }//End of  add lines loop
                        //Now add the order lines to the order header.
                        axPurchaseOrderHeader.TEC_STG_PurchLine = (UploadPurchOrderService.AxdEntity_TEC_STG_PurchLine[])axPurchaseInvoiceLines.ToArray(typeof(UploadPurchOrderService.AxdEntity_TEC_STG_PurchLine));
                    }
                    if (hasPurchaseLines == true)
                    {
                        axPurchaseInvoiceCollection.Add(axPurchaseOrderHeader);
                        purchaseInvoiceIDs.Add(sqlPurchaseInvoiceHeader.PurchaseInvoiceHeadersID);
                        validRecords++;
                    }
                }
                if (recordCount != 0)
                {
                    dal.UpdateAOMPurchaseInvoiceHeaderExtractStatus(purchaseInvoiceIDs, Constants.beingExtracted);
                    recordsReturned = true;
                }
                if (validRecords > 0)
                {
                    axPurchaseOrders.TEC_STG_PurchTable = (UploadPurchOrderService.AxdEntity_TEC_STG_PurchTable[])axPurchaseInvoiceCollection.ToArray(typeof(UploadPurchOrderService.AxdEntity_TEC_STG_PurchTable));
                    var response = axPurchaseInvoiceClient.create(axContext, axPurchaseOrders);
                    dal.UpdateAOMPurchaseInvoiceHeaderExtractStatus(purchaseInvoiceIDs, Constants.extracted);
                }
            }
            catch (FaultException exFault)
            {
                Debug.WriteLine("Error occured whilst calling tecPurchaseInvoiceOrderService" + exFault.ToString());
                lastErrorMessage = exFault.ToString();
                return(false);
            }
            catch (CommunicationException exComm)
            {
                Debug.WriteLine("Error occured whilst calling tecPurchaseInvoiceOrderService" + exComm.ToString());
                lastErrorMessage = exComm.ToString();
                return(false);
            }
            catch (Exception ex)
            {
                Debug.WriteLine("Error occured whilst calling tecPurchaseInvoiceOrderService" + ex.ToString());
                lastErrorMessage = ex.ToString();
                return(false);
            }
            return(true);
        }