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");
}
}
}
public static string GetPackedBunch(string strQuoteName)
{
string strPackedBunchId = null;
try
{
string strQuoteID = int.Parse(strQuoteName.Replace("QB", "")).ToString();
CustomRecordSearch objSearch = new CustomRecordSearch();
objSearch.basic = new CustomRecordSearchBasic();
objSearch.basic.recType = new RecordRef();
objSearch.basic.recType.internalId = "524";
objSearch.basic.isInactive = new SearchBooleanField();
objSearch.basic.isInactive.searchValue = false;
objSearch.basic.isInactive.searchValueSpecified = true;
SearchMultiSelectCustomField objQuoteId = new SearchMultiSelectCustomField();
objQuoteId.internalId = "custrecord_vf_qd_quote";
objQuoteId.@operator = SearchMultiSelectFieldOperator.anyOf;
objQuoteId.operatorSpecified = true;
objQuoteId.searchValue = new ListOrRecordRef[1];
objQuoteId.searchValue[0] = new ListOrRecordRef();
objQuoteId.searchValue[0].internalId = strQuoteID;
/*SearchStringCustomField objBatchName = new SearchStringCustomField();
objBatchName.internalId = "custrecordfb_batchname";
objBatchName.@operator = SearchStringFieldOperator.@is;
objBatchName.operatorSpecified = true;
objBatchName.searchValue = "CM1309MP007";*/
objSearch.basic.customFieldList = new SearchCustomField[] { objQuoteId };
CustomRecordSearchAdvanced objSearchAdv = new CustomRecordSearchAdvanced();
objSearchAdv.savedSearchScriptId = "customsearch_spm_quotedetail_export";
objSearchAdv.criteria = objSearch;
SearchResult objSearchResult = _service.search(objSearch);
if (objSearchResult.recordList != null && objSearchResult.recordList.Length > 0)
{
for (int j = 0; j < objSearchResult.recordList.Length; j++)
{
if (objSearchResult.recordList[j] is CustomRecord)
{
CustomRecord objRecord = (CustomRecord)objSearchResult.recordList[j];
strPackedBunchId = GetValue("custrecord_vf_qd_packedbunch", objRecord.customFieldList).ToString();
strPackedBunchId = "PB" + strPackedBunchId.PadLeft(8, '0');
}
}
}
}
catch (Exception)
{
}
return strPackedBunchId;
}
