Пример #1
0
        static void MainPr(string[] args)
        {
            try
            {
                Navision_ItemCategory_Service.ItemCategories nv_Item_Cat = new Navision_ItemCategory_Service.ItemCategories();

                Navision_ItemList_Service.ItemList_PortClient client = new Navision_ItemList_Service.ItemList_PortClient();

                Navision_ItemList_Service.ItemList nv_ItemList = new Navision_ItemList_Service.ItemList();

                Navision_ItemList_Service.ItemList[] nv_ItemLists;

                client.ClientCredentials.Windows.ClientCredential.UserName = "******";

                client.ClientCredentials.Windows.ClientCredential.Password = "******";

                client.ClientCredentials.Windows.ClientCredential.Domain = "122.166.222.116";

                Navision_ItemList_Service.ItemList_Filter f = new Navision_ItemList_Service.ItemList_Filter();

                nv_ItemLists = client.ReadMultiple(new Navision_ItemList_Service.ItemList_Filter[] { f }, null, 10000);

                MagentoConnectService.PortTypeClient mage_client = new MagentoConnectService.PortTypeClient();

                string token_id = mage_client.login("webserviceuser", "apikey");

                DBConnect db = new DBConnect();

                Hashtable hs = db.fetch_CategoryMapping();

                Hashtable hsp = db.fetch_ProductMapping();

                for (int i = 0; i < nv_ItemLists.Length; i++)
                {
                    MagentoConnectService.catalogProductCreateEntity mage_Product = new MagentoConnectService.catalogProductCreateEntity();


                    try
                    {
                        mage_Product.description = nv_ItemLists[i].Description;
                        mage_Product.name        = nv_ItemLists[i].Description;
                        mage_Product.weight      = "1";

                        mage_Product.price             = nv_ItemLists[i].Last_Direct_Cost.ToString();
                        mage_Product.short_description = nv_ItemLists[i].Search_Description;
                        string mage_cat_id = null;

                        if (nv_ItemLists[i].Item_Category_Code != null)
                        {
                            mage_cat_id = (string)hs[nv_ItemLists[i].Item_Category_Code];
                        }

                        string[] array = { mage_cat_id };
                        mage_Product.category_ids = array;
                        mage_Product.status       = "1";
                        mage_Product.visibility   = "4";
                        String productType = "simple";

                        var stock = new catalogInventoryStockItemUpdateEntity
                        {
                            is_in_stockSpecified = true,
                            is_in_stock          = 1,
                            qty = nv_ItemLists[i].Inventory.ToString()
                        };

                        mage_Product.stock_data = stock;
                        int productid = 0;
                        try
                        {
                            if (db.fetch_Product(nv_ItemLists[i].No))
                            {
                                mage_client.catalogProductUpdate(token_id, (string)hsp[nv_ItemLists[i].No], mage_Product, "default", productType);
                            }
                            else
                            {
                                productid = mage_client.catalogProductCreate(token_id, productType, "4", nv_ItemLists[i].No, mage_Product, "default");
                                db.InsertProductMapping(nv_ItemLists[i].No, productid.ToString(), nv_ItemLists[i].No);
                                db.InsertLog("Product", nv_ItemLists[i].No, "Navision Product Code", "SUCCESS");
                            }
                        }
                        catch (Exception ex)
                        {
                            db.InsertLog("Product", nv_ItemLists[i].No, ex.ToString(), "FAILED");
                        }
                    }
                    catch (Exception ex)
                    {
                        db.InsertLog("Product", nv_ItemLists[i].No, ex.ToString(), "FAILED");
                    }
                }
            }
            catch (Exception ex)
            {
                MNC_Product_Sync.ErrorLog errLog = new MNC_Product_Sync.ErrorLog();
                errLog.LogError("C:\\MNC_Logs", "Product " + ex.Message);
            }
        }
Пример #2
0
        static void MainCat(string[] args)
        {
            //AppConfigFileSettings.UpdateAppSettings("address", "http://103.238.216.254:7047/DynamicsNAV71/WS/CRONUS%20India%20Ltd/Page/ItemCategory");
            Navision_ItemCategory_Service.ItemCategories nv_Item_Cat = new Navision_ItemCategory_Service.ItemCategories();


            Navision_ItemCategory_Service.ItemCategories_PortClient client = new Navision_ItemCategory_Service.ItemCategories_PortClient();

            Navision_ItemCategory_Service.ItemCategories[] nv_ItemCats = null;


            client.ClientCredentials.Windows.ClientCredential.UserName = "******";

            client.ClientCredentials.Windows.ClientCredential.Password = "******";

            client.ClientCredentials.Windows.ClientCredential.Domain = "122.166.222.116";

            string token_id = null;

            DBConnect db = null;

            db = new DBConnect();

            Hashtable hscat = db.fetch_CategoryMapping();

            MagentoConnectService.PortTypeClient mage_client = null;

            try
            {
                nv_ItemCats = client.ReadMultiple(null, null, 5000);

                mage_client = new MagentoConnectService.PortTypeClient();

                token_id = mage_client.login("webserviceuser", "apikey");
            }
            catch (Exception ex)
            {
                MNC_Product_Sync.ErrorLog errLog = new MNC_Product_Sync.ErrorLog();

                errLog.LogError("C:\\MNC_Logs", "ProductCategory : " + ex.Message);
            }
            finally
            {
                // mage_client.endSession(token_id);
            }
            try
            {
                for (int i = 0; i < nv_ItemCats.Length; i++)
                {
                    if (!db.fetch_ProductCat(nv_ItemCats[i].Code))
                    {
                        string[] sortby_values;
                        string   sortbyval = "name";
                        sortby_values = sortbyval.ToString().Split(',');
                        catalogCategoryEntityCreate cat = new catalogCategoryEntityCreate();
                        cat.description = nv_ItemCats[i].Description;
                        cat.name        = nv_ItemCats[i].Code;

                        cat.available_sort_by = sortby_values;
                        cat.include_in_menu   = 1;

                        cat.default_sort_by          = "name";
                        cat.is_active                = 1;
                        cat.include_in_menuSpecified = true;
                        cat.include_in_menu          = 1;

                        cat.is_activeSpecified = true;
                        cat.is_active          = 1;


                        int id = mage_client.catalogCategoryCreate(token_id, 1, cat, null);
                        db.InsertProductCatMapping(nv_ItemCats[i].Code, id.ToString(), cat.name);
                        db.InsertLog("Category", nv_ItemCats[i].Code, "Navision Category Code", "SUCCESS");
                    }
                }
            }

            catch (Exception ex)
            {
                MNC_Product_Sync.ErrorLog errLog = new MNC_Product_Sync.ErrorLog();

                errLog.LogError("C:\\MNC_Logs", "ProductCategory : " + ex.Message);
            }
            finally
            {
                mage_client.endSession(token_id);
            }
            //mage_client.catalogProductCreate(token_id,
        }