public override void Get() { /// <summary> This method get all items (with types we need in POS) from netsuite and check item type, /// after that get all item info and save in DB.</summary> /// string IntrnelID = GetCustomizationId("customrecord_da_payment_method_percentag"); CustomRecordSearch customRecordSearch = new CustomRecordSearch(); CustomRecordSearchBasic customRecordSearchBasic = new CustomRecordSearchBasic(); RecordRef recordRef = new RecordRef(); recordRef.internalId = IntrnelID; recordRef.type = RecordType.customTransaction; customRecordSearchBasic.recType = recordRef; customRecordSearch.basic = customRecordSearchBasic; SearchResult response = Service(true).search(customRecordSearch); if (response.status.isSuccess) { if (response.totalRecords > 0) { CustomRecord item_Custom; CustomFieldRef[] flds; List <Foodics.NetSuite.Shared.Model.PaymentMethod> lstsetting = new List <Foodics.NetSuite.Shared.Model.PaymentMethod>(); for (int i = 0; i < response.recordList.Length; i++) { item_Custom = (CustomRecord)response.recordList[i]; flds = item_Custom.customFieldList; Foodics.NetSuite.Shared.Model.PaymentMethod payObj = new Foodics.NetSuite.Shared.Model.PaymentMethod(); //payObj.Netsuite_Id = Utility.ConvertToInt(item_Custom.internalId); for (int c = 0; c < flds.Length; c++) { if (flds[c].scriptId == "custrecord_da_percentage") { payObj.Percentage = Utility.ConvertToInt(((com.netsuite.webservices.DoubleCustomFieldRef)flds[c]).value.ToString()); } if (flds[c].scriptId == "custrecord_da_payment_method_ref") { payObj.Netsuite_Id = Utility.ConvertToInt(((com.netsuite.webservices.SelectCustomFieldRef)flds[c]).value.internalId.ToString()); } } lstsetting.Add(payObj); } new GenericeDAO <Foodics.NetSuite.Shared.Model.PaymentMethod>().UpdatePaymentMethod(lstsetting); } } }
public override void Get() { /// <summary> This method get all items (with types we need in POS) from netsuite and check item type, /// after that get all item info and save in DB.</summary> /// string IntrnelID = GetCustomizationId("customrecord_da_foodics_settings"); CustomRecordSearch customRecordSearch = new CustomRecordSearch(); CustomRecordSearchBasic customRecordSearchBasic = new CustomRecordSearchBasic(); RecordRef recordRef = new RecordRef(); recordRef.internalId = IntrnelID; recordRef.type = RecordType.customTransaction; customRecordSearchBasic.recType = recordRef; customRecordSearch.basic = customRecordSearchBasic; SearchResult response = Service(true).search(customRecordSearch); if (response.status.isSuccess) { if (response.totalRecords > 0) { CustomRecord item_Custom; CustomFieldRef[] flds; List <Setting.integerate> lstsetting = new List <Setting.integerate>(); for (int i = 0; i < response.recordList.Length; i++) { item_Custom = (CustomRecord)response.recordList[i]; flds = item_Custom.customFieldList; Setting.integerate settingObj = new Setting.integerate(); settingObj.Netsuite_Id = Utility.ConvertToInt(item_Custom.internalId); for (int c = 0; c < flds.Length; c++) { if (flds[c].scriptId == "custrecord_da_foodics_tax_rate") { settingObj.TaxRate = Utility.ConvertToInt(((com.netsuite.webservices.DoubleCustomFieldRef)flds[c]).value.ToString()); } if (flds[c].scriptId == "custrecord_da_foodics_currency") { settingObj.Currency_Netsuite_Id = Utility.ConvertToInt(((com.netsuite.webservices.SelectCustomFieldRef)flds[c]).value.internalId.ToString()); } if (flds[c].scriptId == "custrecord_da_foodics_subsidiary") { settingObj.Subsidiary_Netsuite_Id = Utility.ConvertToInt(((com.netsuite.webservices.SelectCustomFieldRef)flds[c]).value.internalId.ToString()); } if (flds[c].scriptId == "custrecord_da_tax_code") { settingObj.TaxCode_Netsuite_Id = Utility.ConvertToInt(((com.netsuite.webservices.SelectCustomFieldRef)flds[c]).value.internalId.ToString()); } if (flds[c].scriptId == "custrecord_da_foodics_default_customer") { settingObj.Customer_Netsuite_Id = Utility.ConvertToInt(((com.netsuite.webservices.SelectCustomFieldRef)flds[c]).value.internalId.ToString()); } } lstsetting.Add(settingObj); } new GenericeDAO <Setting.integerate>().BaseNetSuiteIntegration(lstsetting, "Setting"); } } }
public override void Get() { /// <summary> This method get all items (with types we need in POS) from netsuite and check item type, /// after that get all item info and save in DB.</summary> /// string IntrnelID = GetCustomizationId("customrecord_da_foodics_class_account"); CustomRecordSearch customRecordSearch = new CustomRecordSearch(); CustomRecordSearchBasic customRecordSearchBasic = new CustomRecordSearchBasic(); RecordRef recordRef = new RecordRef(); recordRef.internalId = IntrnelID; recordRef.type = RecordType.customTransaction; customRecordSearchBasic.recType = recordRef; customRecordSearch.basic = customRecordSearchBasic; SearchResult response = Service(true).search(customRecordSearch); if (response.status.isSuccess) { if (response.totalRecords > 0) { CustomRecord item_Custom; CustomFieldRef[] flds; List <Categories.CategoriesAccounts> lstCat = new List <Categories.CategoriesAccounts>(); for (int i = 0; i < response.recordList.Length; i++) { item_Custom = (CustomRecord)response.recordList[i]; flds = item_Custom.customFieldList; Categories.CategoriesAccounts CatObj = new Categories.CategoriesAccounts(); for (int c = 0; c < flds.Length; c++) { if (flds[c].scriptId == "custrecord_da_item_class") { CatObj.Netsuite_Id = Utility.ConvertToInt(((com.netsuite.webservices.SelectCustomFieldRef)flds[c]).value.internalId.ToString()); } if (flds[c].scriptId == "custrecord_cogs_account") { CatObj.cogs_account = Utility.ConvertToInt(((com.netsuite.webservices.SelectCustomFieldRef)flds[c]).value.internalId.ToString()); } if (flds[c].scriptId == "custrecord_inter_cogs_account") { CatObj.inter_cogs_account = Utility.ConvertToInt(((com.netsuite.webservices.SelectCustomFieldRef)flds[c]).value.internalId.ToString()); } if (flds[c].scriptId == "custrecord_da_income_account") { CatObj.income_account = Utility.ConvertToInt(((com.netsuite.webservices.SelectCustomFieldRef)flds[c]).value.internalId.ToString()); } if (flds[c].scriptId == "custrecord_da_gainloss_account") { CatObj.gainloss_account = Utility.ConvertToInt(((com.netsuite.webservices.SelectCustomFieldRef)flds[c]).value.internalId.ToString()); } if (flds[c].scriptId == "custrecord_da_assetaccount") { CatObj.asset_account = Utility.ConvertToInt(((com.netsuite.webservices.SelectCustomFieldRef)flds[c]).value.internalId.ToString()); } if (flds[c].scriptId == "custrecord_cust_income_intercompany") { CatObj.income_intercompany_account = Utility.ConvertToInt(((com.netsuite.webservices.SelectCustomFieldRef)flds[c]).value.internalId.ToString()); } if (flds[c].scriptId == "custrecord_cust_da_price_variance") { CatObj.price_variance_account = Utility.ConvertToInt(((com.netsuite.webservices.SelectCustomFieldRef)flds[c]).value.internalId.ToString()); } if (flds[c].scriptId == "custrecord_da_cust_qty_variance") { CatObj.cust_qty_variance_account = Utility.ConvertToInt(((com.netsuite.webservices.SelectCustomFieldRef)flds[c]).value.internalId.ToString()); } if (flds[c].scriptId == "custrecord_da_cust_ex_rate") { CatObj.cust_ex_rate_account = Utility.ConvertToInt(((com.netsuite.webservices.SelectCustomFieldRef)flds[c]).value.internalId.ToString()); } if (flds[c].scriptId == "custrecord_da_cust_customer_account_vari") { CatObj.customer_vari_account = Utility.ConvertToInt(((com.netsuite.webservices.SelectCustomFieldRef)flds[c]).value.internalId.ToString()); } if (flds[c].scriptId == "custrecord_da_cust_vendor") { CatObj.cust_vendor_account = Utility.ConvertToInt(((com.netsuite.webservices.SelectCustomFieldRef)flds[c]).value.internalId.ToString()); } } lstCat.Add(CatObj); } new GenericeDAO <Categories.CategoriesAccounts>().BaseNetSuiteIntegration(lstCat, "Categories"); } } }