public void SyncVendorTradeType(string SystemCode)
        {
            OCRVVendorService CRVWebService = new OCRVVendorService(OApplicationSetting.Current.CRVVendorServiceURL);
            CRVWebService.Codes = CRVWebService.GetVendorTypeCodes(SystemCode);
            if (CRVWebService.Codes == null) return;

            OCode Parent = TablesLogic.tCode.Load(TablesLogic.tCode.ObjectName == "VendorType" &
                                                  TablesLogic.tCode.CodeType.ObjectName == "VendorRelated");
            OCode CodeType = TablesLogic.tCode.Load(TablesLogic.tCode.CodeType.ObjectName == "VendorType");
            if (Parent == null) return;
            for (int i = 0; i < CRVWebService.Codes.Length; i++)
            {
                OCode VendorType = TablesLogic.tCode.Load(TablesLogic.tCode.ObjectName == CRVWebService.Codes[i].ObjectName.Trim() &
                                                            TablesLogic.tCode.CodeTypeID == CodeType.ObjectID &
                                                            TablesLogic.tCode.ParentID == Parent.ObjectID);
                if (VendorType == null)
                {
                    VendorType = TablesLogic.tCode.Create();
                    VendorType.ParentID = Parent.ObjectID;
                    VendorType.CodeTypeID = CodeType.ObjectID;
                    VendorType.ObjectName = CRVWebService.Codes[i].ObjectName.Trim();
                    using (Connection c = new Connection())
                    {
                        VendorType.Save();
                        c.Commit();
                    }
                }
            }
        }