Ejemplo n.º 1
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="doc"></param>
        /// <param name="oNumber"></param>
        /// <param name="syncRow"></param>
        /// <returns></returns>
        bool ICatalogTables.ProcessConvertOrder(CatalogConvertTable doc, string oNumber, EtlTimer syncRow)
        {
            ServiceResponse rStatus = new ServiceResponse();

            DAL.SupportServices.SupportServices wsm = new DAL.SupportServices.SupportServices();  //  Set WebService methods pointer

            ///  Create error message object and initialice it
            ServiceResponse errMsg = new ServiceResponse();

            errMsg.FileType   = "2";    //  Set Catalog order Type
            errMsg.FileName   = "Catalog Convert orders Table";
            errMsg.NISOrderId = oNumber.ToString();
            errMsg.Status     = "Not Processed";
            errMsg.Message    = "No items found for this order header";
            /// *********************************************************************************************
            //  Order header section
            /// ---------------------------------------------------------------------------------------------
            string json2 = "{ \"WebOrderSummary\":" + Newtonsoft.Json.JsonConvert.SerializeObject(doc.CatalogConvertOrderSummary) + "}";

            /// *********************************************************************************************
            ///  Order Detail Section
            ///  --------------------------------------------------------------------------------------------
            /// ===============================================================================
            /// Send Imported files data content to webServices - information must be complete
            /// Order Header + all related Order Items.
            /// -------------------------------------------------------------------------------
            if (doc.CatalogConvertOrderSummary != null)
            {
                /// ******************************************************************************
                /// Call Web Service
                /// <param name="json2">        Header/detail object Json serialized string.</param>
                /// <param name="fname">        Xml file name </param>
                /// <param name="syncRow.WebServiceOrders">File Type, route to web service(url)</param>
                /// <param name="syncRow">      EtlTimer control data.
                /// <returns>"rStatus.IsOk" true if WebService was processed, else false</returns>
                /// *** Web service url is defined in the App.Config file key 'NisOrder'.
                /// ------------------------------------------------------------------------------
                /// ==============> save order data through the defined web service
                rStatus = wsm.ConsumeWebService(json2, oNumber, syncRow.WebServiceOrders, syncRow);   //"OrderData", syncRow); //// TEMPORARY UNCOMMENT TO SEND JSON INFO
                /// ------------------------------------------------------------------------------
                ///     UNCOMMENT IF WEB SERVICE IS USED TO SEND JSON INFO
                //      rStatus.IsOK = true;         /// set order process to ok TEMPORARY,
                //      rStatus.NISOrderId = "Nav8912345";
                /// ------------------------------------------------------------------------------
                string apiMsg = "";
                int    resp   = 0;          //  Order update response
                DAL.ImportControl.ImportControlRepository ikr = new DAL.ImportControl.ImportControlRepository();
                DAL.ImportControl.ImportCatalogRepository icr = new DAL.ImportControl.ImportCatalogRepository();
                //
                if (rStatus.IsOk)
                {   //  set order condition to imported
                    apiMsg = " Imported";
                    resp   = icr.updCatalogOrder(oNumber, rStatus.NISOrderId, 1);
                }
                else
                {   //  Set order contion to imported with errors.
                    apiMsg = " Not Imported - API errors";
                }
                string ret = ikr.writeSyncLog(1, syncRow.MwEtlTimerId, 1, syncRow.ServiceName, "> " + syncRow.Description + " Catalog Convert Order: <" + doc.CatalogConvertOrderSummary.ReferenceId + "> " + apiMsg + ".");
                //  <==============
            }
            else
            {   /// Incomplete order (No order items included and no xls file Name reported in orderHeader)
                //json2 = json2 + " }";
                /// Send Message to WebService
                wsm.WriteErrorFile(errMsg, syncRow);    //// TEMPORARY UNCOMMENT TO SEND JSON INFO
            }
            return(rStatus.IsOk);
        }
Ejemplo n.º 2
0
        /// *****************************************************************************************
        /// General Tables process - Only Web/convert orders rows are processed here:
        ///     (1) - Select order type process depending on order type.
        ///     (2) - Route process to the corresponding order types import process using delegates.
        ///     (3) - Unrecognized data types and Service reading errors are detected here.
        ///     (4) - Errors are logged in service log and reported through web services.
        /// -----------------------------------------------------------------------------------------
        public void ProcessOrder(string order, EtlTimer sync)
        {
            /// Initialize Error messages object basic information
            string          OrdNumber = "";
            ServiceResponse errMsg    = new ServiceResponse();

            errMsg.FileType   = "1";
            errMsg.FileName   = "Catalog web Order: " + order.ToString();
            errMsg.NISOrderId = "0";
            errMsg.Status     = "Not Processed";
            errMsg.Message    = string.Empty;
            try
            {
                /// *********************************************************************************
                /// Select files acceptable to be process, all other file types (extension) will not
                /// be processed (they stay in the newFiles folder) and an error message is generated
                /// to the WebServices.
                /// Only Catalog Web Order (1) row are processed by entry.
                /// ---------------------------------------------------------------------------------
                //  access catalog convert orders list
                if (sync.OrderType == 1)
                {   /// ======== >
                    CatalogConvertTable convertOrder = new CatalogConvertTable();
                    convertOrder = icr.getCatalogConvertOrder(order);
                    /// <=========
                    OrdNumber = convertOrder.CatalogConvertOrderSummary.ReferenceId;
                    //
                    /// Instanciate NBI Tables methods delegate
                    DelConvert handler = null;
                    // Declare a class instance xml:
                    ImportProcedure_Catalog.CatalogJson.ImportProcess table = new ImportProcedure_Catalog.CatalogJson.ImportProcess();
                    /// Declare an interface instance Table:
                    ImportProcedure_Catalog.CatalogJson.ICatalogTables orderClass = (ImportProcedure_Catalog.CatalogJson.ICatalogTables)table;
                    /// +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
                    /// Identify Catalog Web order table and route them to the corresponding import procedure
                    ///  ----------------------------------------------------------------------------
                    //  Catalog Web Order table process
                    handler = orderClass.ProcessConvertOrder;
                    //    /// =========== >
                    bool ok = false;
                    ok = handler(convertOrder, order, sync);                 //  Process file and WebService
                    //
                    OrdNumber = (convertOrder.CatalogConvertOrderSummary.ReferenceId).ToString();
                    //
                }
                else if (sync.OrderType == 2)
                {
                    CatalogOrderTables catalogOrder = new CatalogOrderTables();
                    catalogOrder = icr.getCatalogOrder(order);
                    //if (catalogOrder != null && catalogOrder.CatalogWebOrderItems != null)
                    //{
                    /// Instanciate NBI Tables methods delegate
                    Del handler = null;
                    // Declare a class instance xml:
                    ImportProcedure_Catalog.CatalogJson.ImportProcess table = new ImportProcedure_Catalog.CatalogJson.ImportProcess();
                    /// Declare an interface instance Table:
                    ImportProcedure_Catalog.CatalogJson.ICatalogTables orderClass = (ImportProcedure_Catalog.CatalogJson.ICatalogTables)table;
                    /// +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
                    /// Identify Catalog Web order table and route them to the corresponding import procedure
                    ///  ----------------------------------------------------------------------------
                    //  Catalog Web Order table process
                    handler = orderClass.ProcessCatalogOrder;
                    //    /// =========== >
                    bool ok = false;
                    ok = handler(catalogOrder, order, sync);                     //  Process file and WebService
                    //
                    OrdNumber = (catalogOrder.CatalogWebOrderSummary.OrderNumber).ToString();
                    //}
                    //else
                    //{   //  update error order - set imported on and import problem on
                    //    ikr.writeSyncLog(1, sync.MwEtlTimerId, 1, sync.ServiceName, "Table reading error order header not found or no items in file, order " + catalogOrder.CatalogWebOrderSummary.OrderNumber);
                    //}
                }
                else
                {   //  update error order - set imported on and import problem on
                    ikr.writeSyncLog(1, sync.MwEtlTimerId, 1, sync.ServiceName, "Table reading error order header not found or no items in file, order " + OrdNumber);
                }
            }
            catch (Exception fle)
            {
                int res = ikr.updImportControl(sync.MwEtlTimerId, 0);     //  set EtlTimer for this service to not Running (isRunning = false)
                errMsg.Message = "(Catalog Web order Process) Table reading error - in order " + errMsg.FileName + ". " + fle;
                ikr.writeSyncLog(1, sync.MwEtlTimerId, 1, sync.ServiceName, errMsg.Message);
            }
        }