Exemplo n.º 1
0
        static void Main(string[] args)
        {
            Navision_CustomerListService.CustomerList            nv_Customer = new Navision_CustomerListService.CustomerList();
            Navision_CustomerListService.CustomerList_PortClient client      = new Navision_CustomerListService.CustomerList_PortClient();
            Navision_CustomerListService.CustomerList[]          nv_CustomerLists;
            client.ClientCredentials.UserName.UserName = "******";
            client.ClientCredentials.UserName.Password = "******";
            //client.ClientCredentials.Windows.ClientCredential.UserName = "******";

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

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


            nv_CustomerLists = client.ReadMultiple(null, null, 10000);

            MagentoConnectService.PortTypeClient mage_client = new MagentoConnectService.PortTypeClient();
            DBConnect db = new DBConnect();
            int       newCustomerCreateID = 0;
            int       createAddressID     = 0;
            string    token_id            = "";
            filters   myfilter            = new filters();

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

            Hashtable hsc = db.fetch_CustomerMapping();

            for (int i = 0; i < nv_CustomerLists.Length; i++)
            {
                // Create Customer
                customerCustomerEntityToCreate customerCreate = new customerCustomerEntityToCreate();
                try
                {
                    customerCreate.firstname           = nv_CustomerLists[i].Name;
                    customerCreate.lastname            = ".";
                    customerCreate.middlename          = "";
                    customerCreate.password            = "******";
                    customerCreate.store_id            = 1;
                    customerCreate.store_idSpecified   = true;
                    customerCreate.website_id          = 1;
                    customerCreate.website_idSpecified = true;
                    customerCreate.group_id            = 1;
                    customerCreate.group_idSpecified   = true;
                    customerCreate.suffix          = "P";
                    customerCreate.email           = nv_CustomerLists[i].E_Mail;
                    customerCreate.gender          = 1; //1-Male;2-Female
                    customerCreate.genderSpecified = true;
                    //customer address
                    customerAddressEntityCreate customerAddress = new customerAddressEntityCreate();
                    if (nv_CustomerLists[i].Location_Code == null)
                    {
                        customerAddress.city = "NA";
                    }
                    else
                    {
                        customerAddress.city = nv_CustomerLists[i].Location_Code;
                    }
                    customerAddress.region_id          = 2; //CountryID
                    customerAddress.region_idSpecified = true;
                    if (nv_CustomerLists[i].Country_Region_Code == null)
                    {
                        customerAddress.country_id = "NA";
                    }
                    else
                    {
                        customerAddress.country_id = nv_CustomerLists[i].Country_Region_Code;
                    }
                    customerAddress.fax        = nv_CustomerLists[i].Fax_No;
                    customerAddress.firstname  = nv_CustomerLists[i].Name;
                    customerAddress.lastname   = ".";
                    customerAddress.middlename = "";
                    string[] streettxt = { nv_CustomerLists[i].Address };
                    customerAddress.street = streettxt;

                    customerAddress.postcode = nv_CustomerLists[i].Post_Code;
                    customerAddress.prefix   = "M";
                    customerAddress.suffix   = "P";
                    //  customerAddress.street = nv_CustomerLists[i].Address.ToString();
                    if (nv_CustomerLists[i].Phone_No == null)
                    {
                        customerAddress.telephone = "NA";
                    }
                    else
                    {
                        customerAddress.telephone = nv_CustomerLists[i].Phone_No;
                    }
                    //If you specify 'true' for is_default_billing and is_default_shipping. Then this address will be your default shipping and billing. Otherwise none.
                    customerAddress.is_default_billing  = true;
                    customerAddress.is_default_shipping = true;

                    if (db.fetch_Customer(nv_CustomerLists[i].No.ToString()))
                    {
                        mage_client.customerCustomerUpdate(token_id, Convert.ToInt16(hsc[nv_CustomerLists[i].No]), customerCreate);
                    }
                    else
                    {
                        newCustomerCreateID = mage_client.customerCustomerCreate(token_id, customerCreate);
                        createAddressID     = mage_client.customerAddressCreate(token_id, newCustomerCreateID, customerAddress);
                        db.InsertCustomerMapping(nv_CustomerLists[i].No, newCustomerCreateID.ToString(), nv_CustomerLists[i].E_Mail);
                        db.InsertLog("Customer", nv_CustomerLists[i].No, "Navision Customer Code", "SUCCESS");
                    }
                }

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

                    errLog.LogError("C:\\MNC_Logs", "Customer :" + ex.Message);
                    db.InsertLog("Customer", nv_CustomerLists[i].No, ex.Message, "FAILED");
                }


                finally
                {
                    //mage_client.endSession(token_id);
                }
            }
            mage_client.endSession(token_id);
        }
Exemplo n.º 2
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);
            }
        }
Exemplo n.º 3
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,
        }