private static void SelectRecordsFromSalesForce(EnterpriseWsdl.SessionHeader header, EnterpriseWsdl.SoapClient apiClient) { Console.WriteLine("Querying ..."); //build up soql query string query = "SELECT first_name__c FROM customer_infos__c"; EnterpriseWsdl.QueryResult apiResult; apiClient.query(header, null, null, null, query, out apiResult); //EnterpriseWsdl.DeleteResult[] deleteResults; //string[] ids = new string[]{}; //EnterpriseWsdl.LimitInfo[] limitInfo; for (int i = 0; i < apiResult.records.Length; i++) { EnterpriseWsdl.customer_infos__c c = (EnterpriseWsdl.customer_infos__c)apiResult.records[i]; Console.WriteLine("Candidate Id : {0}, Name : {1} & AccountNumber : {2} ", c.customerid__c, c.first_name__c, c.account_number__c); //ids[i] = c.first_name__c; //apiClient.delete(header, null, null, null, null, null, null, null, null, ids, out limitInfo, out deleteResults); //EnterpriseWsdl.DeleteResult deleteResult = deleteResults[i]; //if (deleteResult.success) //{ // Console.WriteLine("Record ID " + deleteResult.id + " deleted succesfully."); //} //else //{ // Console.WriteLine("Delete failed"); //} } //foreach (var id in ids) //{ // Console.WriteLine(id); //} Console.ReadLine(); }
private static void InsertRecordsTosalesForce(EnterpriseWsdl.SessionHeader header, EnterpriseWsdl.SoapClient apiClient) { Console.WriteLine("Adding new records ..."); EnterpriseWsdl.customer_infos__c addCustomer = new EnterpriseWsdl.customer_infos__c(); while (myReader.Read()) { addCustomer.customerid__c = myReader["id"].ToString(); addCustomer.account_number__c = myReader["account_number"].ToString(); addCustomer.title__c = myReader["title"].ToString(); addCustomer.first_name__c = myReader["first_name"].ToString(); addCustomer.middle_name__c = myReader["middle_name"].ToString(); addCustomer.last_name__c = myReader["last_name"].ToString(); addCustomer.address_line_1__c = myReader["address_line_1"].ToString(); addCustomer.address_line_2__c = myReader["address_line_2"].ToString(); addCustomer.address_city__c = myReader["address_city"].ToString(); addCustomer.adress_county__c = myReader["adress_county"].ToString(); addCustomer.adress_postcode__c = myReader["adress_postcode"].ToString(); addCustomer.adress_country__c = myReader["adress_country"].ToString(); addCustomer.email__c = myReader["email"].ToString(); addCustomer.new_email_address__c = myReader["new_email_address"].ToString(); addCustomer.phone_landline__c = myReader["phone_landline"].ToString(); addCustomer.new_phone_landline__c = myReader["new_phone_landline"].ToString(); addCustomer.mobile__c = myReader["mobile"].ToString() != "" ? myReader["mobile"].ToString() : "70000000"; addCustomer.new_mobile__c = myReader["new_mobile"].ToString() != "" ? myReader["new_mobile"].ToString() : "0"; addCustomer.name_of_bank__c = myReader["name_of_bank"].ToString(); addCustomer.name_of_new_bank__c = myReader["name_of_new_bank"].ToString(); addCustomer.bank_sortcode__c = myReader["bank_sortcode"].ToString(); addCustomer.new_bank_sortcode__c = myReader["new_bank_sortcode"].ToString(); addCustomer.bank_account_number__c = myReader["bank_account_number"].ToString(); addCustomer.new_account_number__c = myReader["new_account_number"].ToString(); addCustomer.name_on_account__c = myReader["name_on_account"].ToString(); addCustomer.name_on_new_account__c = myReader["name_on_new_account"].ToString(); addCustomer.monthly_net_income__c = myReader["monthly_net_income"].ToString() != "" ? myReader["monthly_net_income"].ToString() : "0"; EnterpriseWsdl.sObject[] outreachArray = new EnterpriseWsdl.sObject[] { addCustomer }; //outreachArray[0].Id = myReader["id"].ToString(); EnterpriseWsdl.SaveResult[] createResult; EnterpriseWsdl.LimitInfo[] limitInfo; apiClient.create(header, null, null, null, null, null, null, null, null, null, outreachArray, out limitInfo, out createResult); if (createResult[0].success) { Console.WriteLine("Record added successfully."); } else { Console.WriteLine("Insertion failed."); } } }