public async void Update_Account_NameChanged()
{
const string originalName = "New Account";
const string newName = "New Account 2";
var account = new Account {
Name = originalName, Description = "New Account Description"
};
var id = await _client.CreateAsync("Account", account);
account.Name = newName;
await _client.UpdateAsync("Account", id, account);
var result = await _client.QueryByIdAsync <Account>("Account", id);
Assert.True(result.Name == newName);
}
public async Task Update_Account_NameChanged()
{
const string originalName = "New Account";
const string newName = "New Account 2";
var account = new Account {
Name = originalName, Description = "New Account Description"
};
var successResponse = await _client.CreateAsync("Account", account);
account.Name = newName;
await _client.UpdateAsync("Account", successResponse.Id, account);
var result = await _client.QueryByIdAsync <Account>("Account", successResponse.Id);
Assert.IsTrue(result.Name == newName);
}
/// <summary>
/// Getting details of particular opportunity
/// </summary>
/// <param name="client">Force client instance</param>
/// <param name="opportunityId">Opportunity Id</param>
/// <returns></returns>
public async Task <Opportunity> GetOpportunityById(ForceClient client, string opportunityId)
{
Opportunity opportunityModel = new Opportunity();
var opportunity = await client.QueryByIdAsync <Opportunity>(Constants.Opportunity, opportunityId);
if (opportunity != null)
{
opportunityModel = opportunity;
}
return(opportunityModel);
}
/// <summary>
/// Getting details of particular opportunity line item
/// </summary>
/// <param name="client">Force client instance</param>
/// <param name="lineItemId">Line item Id</param>
/// <returns>Details of opportunity line item</returns>
public async Task <OpportunityLineItem> GetOpportunityLineItemById(ForceClient client, string lineItemId)
{
OpportunityLineItem lineitemModel = new OpportunityLineItem();
var lineitem = await client.QueryByIdAsync <OpportunityLineItem>(Constants.OpportunityLineItem, lineItemId);
if (lineitem != null)
{
lineitemModel = lineitem;
}
return(lineitemModel);
}
public async Task <ActionResult> LeadEdit(string id)
{
// Ensure the user is authenticated
if (!SalesforceService.IsUserLoggedIn())
{
// Should include a state argument to the URI so that when the dance is done, we can redirect to the page that we were requesting
string myUri = SalesforceOAuthRedirectHandler.AuthorizationUri.ToString() + "&state=" + this.Url.RequestContext.HttpContext.Request.RawUrl;
return(this.Redirect(myUri));
}
// Initalize the Force client
SalesforceService service = new SalesforceService();
ForceClient client = service.GetForceClient();
Lead lead = await client.QueryByIdAsync <Lead>("Lead", id);
return(View(lead));
}
public async Task <SalesForceModels.OpportunityModel> GetOpportunityById(ForceClient client, string opportunityId)
{
var opportunityModel = new SalesForceModels.OpportunityModel();
var opportunity = await client.QueryByIdAsync <SalesForceModels.OpportunityModel>("Opportunity", opportunityId);
if (opportunity != null)
{
opportunityModel.Id = opportunity.Id;
opportunityModel.LeadSource = opportunity.LeadSource;
opportunityModel.StageName = opportunity.StageName;
opportunityModel.Type = opportunity.Type;
opportunityModel.Amount = opportunity.Amount;
opportunityModel.Name = opportunity.Name;
opportunityModel.Probability = opportunity.Probability;
opportunityModel.CloseDate = opportunity.CloseDate;
}
return(opportunityModel);
}
public async Task <SalesForceModels.LeadModel> GetLeadById(ForceClient client, string leadId)
{
var leadModel = new SalesForceModels.LeadModel();
var lead = await client.QueryByIdAsync <SalesForceModels.LeadModel>("Lead", leadId);
if (lead != null)
{
leadModel.Id = lead.Id;
leadModel.FirstName = lead.FirstName;
leadModel.LastName = lead.LastName;
leadModel.Company = lead.Company;
leadModel.Email = lead.Email;
leadModel.Status = lead.Status;
leadModel.Phone = lead.Phone;
leadModel.LastEditedBy__c = lead.LastEditedBy__c ?? string.Empty;
leadModel.LastEditedOn__c = lead.LastEditedOn__c;
}
;
return(leadModel);
}
private static async Task RunSample()
{
var auth = new AuthenticationClient();
// Authenticate with Salesforce
Console.WriteLine("Authenticating with Salesforce");
var url = IsSandboxUser.Equals("true", StringComparison.CurrentCultureIgnoreCase)
? "https://test.salesforce.com/services/oauth2/token"
: "https://login.salesforce.com/services/oauth2/token";
await auth.UsernamePasswordAsync(ConsumerKey, ConsumerSecret, Username, Password, url);
Console.WriteLine("Connected to Salesforce");
var client = new ForceClient(auth.InstanceUrl, auth.AccessToken, auth.ApiVersion);
string sql = "SELECT Id, CaseNumber, Current_Version__c, Priority, Go_Live_Critical__c, Case.Account.name, " +
"Case.Owner.name, Origin, Patch_Number__c, Subject, OwnerId, Type, Description, CreatedDate, " +
"Case.createdBy.name, status, bzid__c, product__c, Customer__r.name, " +
"( SELECT CommentBody, CaseComment.createdBy.name, CaseComment.lastModifiedBy.name, CreatedDate, LastModifiedDate FROM CaseComments ORDER BY CreatedDate DESC NULLS LAST LIMIT 1 ) " +
"FROM Case WHERE Status ='Eng New' AND Case.product__c='Accela ACA' AND Case.Owner.name='Engineering'";
//const string qry = "SELECT ID, Name FROM Account";
var accts = new List<Account>();
var results = await client.QueryAsync<Account>(sql);
var totalSize = results.TotalSize;
Console.WriteLine("Queried " + totalSize + " records.");
accts.AddRange(results.Records);
var nextRecordsUrl = results.NextRecordsUrl;
if (!string.IsNullOrEmpty(nextRecordsUrl))
{
Console.WriteLine("Found nextRecordsUrl.");
while (true)
{
var continuationResults = await client.QueryContinuationAsync<Account>(nextRecordsUrl);
totalSize = continuationResults.TotalSize;
Console.WriteLine("Queried an additional " + totalSize + " records.");
accts.AddRange(continuationResults.Records);
if (string.IsNullOrEmpty(continuationResults.NextRecordsUrl)) break;
//pass nextRecordsUrl back to client.QueryAsync to request next set of records
nextRecordsUrl = continuationResults.NextRecordsUrl;
}
}
Console.WriteLine("Retrieved accounts = " + accts.Count() + ", expected size = " + totalSize);
// Create a sample record
Console.WriteLine("Creating test record.");
var account = new Account { Name = "Test Account" };
account.Id = await client.CreateAsync(Account.SObjectTypeName, account);
if (account.Id == null)
{
Console.WriteLine("Failed to create test record.");
return;
}
Console.WriteLine("Successfully created test record.");
// Update the sample record
// Shows that annonymous types can be used as well
Console.WriteLine("Updating test record.");
var success = await client.UpdateAsync(Account.SObjectTypeName, account.Id, new { Name = "Test Update" });
if (!string.IsNullOrEmpty(success.Errors.ToString()))
{
Console.WriteLine("Failed to update test record!");
return;
}
Console.WriteLine("Successfully updated the record.");
// Retrieve the sample record
// How to retrieve a single record if the id is known
Console.WriteLine("Retrieving the record by ID.");
account = await client.QueryByIdAsync<Account>(Account.SObjectTypeName, account.Id);
if (account == null)
{
Console.WriteLine("Failed to retrieve the record by ID!");
return;
}
Console.WriteLine("Retrieved the record by ID.");
// Query for record by name
Console.WriteLine("Querying the record by name.");
var accounts = await client.QueryAsync<Account>("SELECT ID, Name FROM Account WHERE Name = '" + account.Name + "'");
account = accounts.Records.FirstOrDefault();
if (account == null)
{
Console.WriteLine("Failed to retrieve account by query!");
return;
}
Console.WriteLine("Retrieved the record by name.");
// Delete account
Console.WriteLine("Deleting the record by ID.");
var deleted = await client.DeleteAsync(Account.SObjectTypeName, account.Id);
if (!deleted)
{
Console.WriteLine("Failed to delete the record by ID!");
return;
}
Console.WriteLine("Deleted the record by ID.");
// Selecting multiple accounts into a dynamic
Console.WriteLine("Querying multiple records.");
var dynamicAccounts = await client.QueryAsync<dynamic>("SELECT ID, Name FROM Account LIMIT 10");
foreach (dynamic acct in dynamicAccounts.Records)
{
Console.WriteLine("Account - " + acct.Name);
}
// Creating parent - child records using a Dynamic
Console.WriteLine("Creating a parent record (Account)");
dynamic a = new ExpandoObject();
a.Name = "Account from .Net Toolkit";
a.Id = await client.CreateAsync("Account", a);
if (a.Id == null)
{
Console.WriteLine("Failed to create parent record.");
return;
}
Console.WriteLine("Creating a child record (Contact)");
dynamic c = new ExpandoObject();
c.FirstName = "Joe";
c.LastName = "Blow";
c.AccountId = a.Id;
c.Id = await client.CreateAsync("Contact", c);
if (c.Id == null)
{
Console.WriteLine("Failed to create child record.");
return;
}
Console.WriteLine("Deleting parent and child");
// Delete account (also deletes contact)
Console.WriteLine("Deleting the Account by Id.");
deleted = await client.DeleteAsync(Account.SObjectTypeName, a.Id);
if (!deleted)
{
Console.WriteLine("Failed to delete the record by ID!");
return;
}
Console.WriteLine("Deleted the Account and Contact.");
}
private static async Task RunSample()
{
var auth = new AuthenticationClient();
// Authenticate with Salesforce
Console.WriteLine("Authenticating with Salesforce");
await auth.UsernamePasswordAsync(ConsumerKey, ConsumerSecret, Username, Password);
Console.WriteLine("Connected to Salesforce");
var client = new ForceClient(auth.InstanceUrl, auth.AccessToken, auth.ApiVersion);
// Create a sample record
Console.WriteLine("Creating test record.");
var account = new Account { Name = "Test Account" };
account.Id = await client.CreateAsync(Account.SObjectTypeName, account);
if (account.Id == null)
{
Console.WriteLine("Failed to create test record.");
return;
}
Console.WriteLine("Successfully created test record.");
// Update the sample record
// Shows that annonymous types can be used as well
Console.WriteLine("Updating test record.");
var success = await client.UpdateAsync(Account.SObjectTypeName, account.Id, new { Name = "Test Update" });
if (!success)
{
Console.WriteLine("Failed to update test record!");
return;
}
Console.WriteLine("Successfully updated the record.");
// Retrieve the sample record
// How to retrieve a single record if the id is known
Console.WriteLine("Retrieving the record by ID.");
account = await client.QueryByIdAsync<Account>(Account.SObjectTypeName, account.Id);
if (account == null)
{
Console.WriteLine("Failed to retrieve the record by ID!");
return;
}
Console.WriteLine("Retrieved the record by ID.");
// Query for record by name
Console.WriteLine("Querying the record by name.");
var accounts = await client.QueryAsync<Account>("SELECT ID, Name FROM Account WHERE Name = '" + account.Name + "'");
account = accounts.records.FirstOrDefault();
if (account == null)
{
Console.WriteLine("Failed to retrieve account by query!");
return;
}
Console.WriteLine("Retrieved the record by name.");
// Delete account
Console.WriteLine("Deleting the record by ID.");
success = await client.DeleteAsync(Account.SObjectTypeName, account.Id);
if (!success)
{
Console.WriteLine("Failed to delete the record by ID!");
return;
}
Console.WriteLine("Deleted the record by ID.");
// Selecting multiple accounts into a dynamic
Console.WriteLine("Querying multiple records.");
var dynamicAccounts = await client.QueryAsync<dynamic>("SELECT ID, Name FROM Account LIMIT 10");
foreach (dynamic acct in dynamicAccounts.records)
{
Console.WriteLine("Account - " + acct.Name);
}
// Creating parent - child records using a Dynamic
Console.WriteLine("Creating a parent record (Account)");
dynamic a = new ExpandoObject();
a.Name = "Account from .Net Toolkit";
a.Id = await client.CreateAsync("Account", a);
if (a.Id == null)
{
Console.WriteLine("Failed to create parent record.");
return;
}
Console.WriteLine("Creating a child record (Contact)");
dynamic c = new ExpandoObject();
c.FirstName = "Joe";
c.LastName = "Blow";
c.AccountId = a.Id;
c.Id = await client.CreateAsync("Contact", c);
if (c.Id == null)
{
Console.WriteLine("Failed to create child record.");
return;
}
Console.WriteLine("Press Enter to delete parent and child and continue");
Console.Read();
// Delete account (also deletes contact)
Console.WriteLine("Deleting the Account by Id.");
success = await client.DeleteAsync(Account.SObjectTypeName, a.Id);
if (!success)
{
Console.WriteLine("Failed to delete the record by ID!");
return;
}
Console.WriteLine("Deleted the Account and Contact.");
}
private static async Task RunSample()
{
var auth = new AuthenticationClient();
// Authenticate with Salesforce
Console.WriteLine("Authenticating with Salesforce");
var url = IsSandboxUser.Equals("true", StringComparison.CurrentCultureIgnoreCase)
? "https://test.salesforce.com/services/oauth2/token"
: "https://login.salesforce.com/services/oauth2/token";
await auth.UsernamePasswordAsync(ConsumerKey, ConsumerSecret, Username, Password, url);
Console.WriteLine("Connected to Salesforce");
var client = new ForceClient(auth.InstanceUrl, auth.AccessToken, auth.ApiVersion);
// retrieve all accounts
Console.WriteLine("Get Accounts");
const string qry = "SELECT ID, Name FROM Account";
var accts = new List <Account>();
var results = await client.QueryAsync <Account>(qry);
var totalSize = results.TotalSize;
Console.WriteLine("Queried " + totalSize + " records.");
accts.AddRange(results.Records);
var nextRecordsUrl = results.NextRecordsUrl;
if (!string.IsNullOrEmpty(nextRecordsUrl))
{
Console.WriteLine("Found nextRecordsUrl.");
while (true)
{
var continuationResults = await client.QueryContinuationAsync <Account>(nextRecordsUrl);
totalSize = continuationResults.TotalSize;
Console.WriteLine("Queried an additional " + totalSize + " records.");
accts.AddRange(continuationResults.Records);
if (string.IsNullOrEmpty(continuationResults.NextRecordsUrl))
{
break;
}
//pass nextRecordsUrl back to client.QueryAsync to request next set of records
nextRecordsUrl = continuationResults.NextRecordsUrl;
}
}
Console.WriteLine("Retrieved accounts = " + accts.Count() + ", expected size = " + totalSize);
// Create a sample record
Console.WriteLine("Creating test record.");
var account = new Account {
Name = "Test Account"
};
var createAccountResponse = await client.CreateAsync(Account.SObjectTypeName, account);
account.Id = createAccountResponse.Id;
if (account.Id == null)
{
Console.WriteLine("Failed to create test record.");
return;
}
Console.WriteLine("Successfully created test record.");
// Update the sample record
// Shows that annonymous types can be used as well
Console.WriteLine("Updating test record.");
var success = await client.UpdateAsync(Account.SObjectTypeName, account.Id, new { Name = "Test Update" });
if (!string.IsNullOrEmpty(success.Errors.ToString()))
{
Console.WriteLine("Failed to update test record!");
return;
}
Console.WriteLine("Successfully updated the record.");
// Retrieve the sample record
// How to retrieve a single record if the id is known
Console.WriteLine("Retrieving the record by ID.");
account = await client.QueryByIdAsync <Account>(Account.SObjectTypeName, account.Id);
if (account == null)
{
Console.WriteLine("Failed to retrieve the record by ID!");
return;
}
Console.WriteLine("Retrieved the record by ID.");
// Query for record by name
Console.WriteLine("Querying the record by name.");
var accounts = await client.QueryAsync <Account>("SELECT ID, Name FROM Account WHERE Name = '" + account.Name + "'");
account = accounts.Records.FirstOrDefault();
if (account == null)
{
Console.WriteLine("Failed to retrieve account by query!");
return;
}
Console.WriteLine("Retrieved the record by name.");
// Delete account
Console.WriteLine("Deleting the record by ID.");
var deleted = await client.DeleteAsync(Account.SObjectTypeName, account.Id);
if (!deleted)
{
Console.WriteLine("Failed to delete the record by ID!");
return;
}
Console.WriteLine("Deleted the record by ID.");
// Selecting multiple accounts into a dynamic
Console.WriteLine("Querying multiple records.");
var dynamicAccounts = await client.QueryAsync <dynamic>("SELECT ID, Name FROM Account LIMIT 10");
foreach (dynamic acct in dynamicAccounts.Records)
{
Console.WriteLine("Account - " + acct.Name);
}
// Creating parent - child records using a Dynamic
Console.WriteLine("Creating a parent record (Account)");
dynamic a = new ExpandoObject();
a.Name = "Account from .Net Toolkit";
var createParentAccountResponse = await client.CreateAsync("Account", a);
a.Id = createParentAccountResponse.Id;
if (a.Id == null)
{
Console.WriteLine("Failed to create parent record.");
return;
}
Console.WriteLine("Creating a child record (Contact)");
dynamic c = new ExpandoObject();
c.FirstName = "Joe";
c.LastName = "Blow";
c.AccountId = a.Id;
var createContactResponse = await client.CreateAsync("Contact", c);
c.Id = createContactResponse.Id;
if (c.Id == null)
{
Console.WriteLine("Failed to create child record.");
return;
}
Console.WriteLine("Deleting parent and child");
// Delete account (also deletes contact)
Console.WriteLine("Deleting the Account by Id.");
deleted = await client.DeleteAsync(Account.SObjectTypeName, a.Id);
if (!deleted)
{
Console.WriteLine("Failed to delete the record by ID!");
return;
}
Console.WriteLine("Deleted the Account and Contact.");
}
private static async Task RunSample()
{
var auth = new AuthenticationClient();
// Authenticate with Salesforce
Console.WriteLine("Authenticating with Salesforce");
var url = IsSandboxUser.Equals("true", StringComparison.CurrentCultureIgnoreCase)
? "https://test.salesforce.com/services/oauth2/token"
: "https://login.salesforce.com/services/oauth2/token";
await auth.UsernamePasswordAsync(ConsumerKey, ConsumerSecret, Username, Password, url);
Console.WriteLine("Connected to Salesforce");
var client = new ForceClient(auth.InstanceUrl, auth.AccessToken, auth.ApiVersion);
// retrieve all accounts
Console.WriteLine("Get Accounts");
const string qry = "SELECT ID, Name FROM Account";
var accts = new List<Account>();
var results = await client.QueryAsync<Account>(qry);
var totalSize = results.TotalSize;
Console.WriteLine("Queried " + totalSize + " records.");
accts.AddRange(results.Records);
var nextRecordsUrl = results.NextRecordsUrl;
if (!string.IsNullOrEmpty(nextRecordsUrl))
{
Console.WriteLine("Found nextRecordsUrl.");
while (true)
{
var continuationResults = await client.QueryContinuationAsync<Account>(nextRecordsUrl);
totalSize = continuationResults.TotalSize;
Console.WriteLine("Queried an additional " + totalSize + " records.");
accts.AddRange(continuationResults.Records);
if (string.IsNullOrEmpty(continuationResults.NextRecordsUrl)) break;
//pass nextRecordsUrl back to client.QueryAsync to request next set of records
nextRecordsUrl = continuationResults.NextRecordsUrl;
}
}
Console.WriteLine("Retrieved accounts = " + accts.Count() + ", expected size = " + totalSize);
// Create a sample record
Console.WriteLine("Creating test record.");
var account = new Account { Name = "Test Account" };
var response = await client.CreateAsync(Account.SObjectTypeName, account);
if (!string.Equals(response.Success, "true", StringComparison.OrdinalIgnoreCase))
{
Console.WriteLine("Failed to create test record.");
return;
}
Console.WriteLine("Successfully created test record.");
// Update the sample record
// Shows that annonymous types can be used as well
Console.WriteLine("Updating test record.");
var success = await client.UpdateAsync(Account.SObjectTypeName, account.Id, new { Name = "Test Update" });
if (!string.IsNullOrEmpty(success.Errors.ToString()))
{
Console.WriteLine("Failed to update test record!");
return;
}
Console.WriteLine("Successfully updated the record.");
// Retrieve the sample record
// How to retrieve a single record if the id is known
Console.WriteLine("Retrieving the record by ID.");
account = await client.QueryByIdAsync<Account>(Account.SObjectTypeName, account.Id);
if (account == null)
{
Console.WriteLine("Failed to retrieve the record by ID!");
return;
}
Console.WriteLine("Retrieved the record by ID.");
// Query for record by name
Console.WriteLine("Querying the record by name.");
var accounts = await client.QueryAsync<Account>("SELECT ID, Name FROM Account WHERE Name = '" + account.Name + "'");
account = accounts.Records.FirstOrDefault();
if (account == null)
{
Console.WriteLine("Failed to retrieve account by query!");
return;
}
Console.WriteLine("Retrieved the record by name.");
// Delete account
Console.WriteLine("Deleting the record by ID.");
var deleted = await client.DeleteAsync(Account.SObjectTypeName, account.Id);
if (!deleted)
{
Console.WriteLine("Failed to delete the record by ID!");
return;
}
Console.WriteLine("Deleted the record by ID.");
// Selecting multiple accounts into a dynamic
Console.WriteLine("Querying multiple records.");
var dynamicAccounts = await client.QueryAsync<dynamic>("SELECT ID, Name FROM Account LIMIT 10");
foreach (dynamic acct in dynamicAccounts.Records)
{
Console.WriteLine("Account - " + acct.Name);
}
// Creating parent - child records using a Dynamic
Console.WriteLine("Creating a parent record (Account)");
dynamic a = new ExpandoObject();
a.Name = "Account from .Net Toolkit";
a.Id = await client.CreateAsync("Account", a);
if (a.Id == null)
{
Console.WriteLine("Failed to create parent record.");
return;
}
Console.WriteLine("Creating a child record (Contact)");
dynamic c = new ExpandoObject();
c.FirstName = "Joe";
c.LastName = "Blow";
c.AccountId = a.Id;
c.Id = await client.CreateAsync("Contact", c);
if (c.Id == null)
{
Console.WriteLine("Failed to create child record.");
return;
}
Console.WriteLine("Deleting parent and child");
// Delete account (also deletes contact)
Console.WriteLine("Deleting the Account by Id.");
deleted = await client.DeleteAsync(Account.SObjectTypeName, a.Id);
if (!deleted)
{
Console.WriteLine("Failed to delete the record by ID!");
return;
}
Console.WriteLine("Deleted the Account and Contact.");
}
private static async Task RunSample()
{
var auth = new AuthenticationClient();
// Authenticate with Salesforce
Console.WriteLine("Authenticating with Salesforce");
await auth.UsernamePasswordAsync(ConsumerKey, ConsumerSecret, Username, Password);
Console.WriteLine("Connected to Salesforce");
var client = new ForceClient(auth.InstanceUrl, auth.AccessToken, auth.ApiVersion);
// Create a sample record
Console.WriteLine("Creating test record.");
var account = new Account { Name = "Test Account" };
account.Id = await client.CreateAsync(Account.SObjectTypeName, account);
if (account.Id == null)
{
Console.WriteLine("Failed to create test record.");
return;
}
Console.WriteLine("Successfully created test record.");
// Update the sample record
// Shows that annonymous types can be used as well
Console.WriteLine("Updating test record.");
var success = await client.UpdateAsync(Account.SObjectTypeName, account.Id, new { Name = "Test Update" });
if (!success)
{
Console.WriteLine("Failed to update test record!");
return;
}
Console.WriteLine("Successfully updated the record.");
// Retrieve the sample record
// How to retrieve a single record if the id is known
Console.WriteLine("Retrieving the record by ID.");
account = await client.QueryByIdAsync<Account>(Account.SObjectTypeName, account.Id);
if (account == null)
{
Console.WriteLine("Failed to retrieve the record by ID!");
return;
}
Console.WriteLine("Retrieved the record by ID.");
// Query for record by name
Console.WriteLine("Querying the record by name.");
var accounts = await client.QueryAsync<Account>("SELECT ID, Name FROM Account WHERE Name = '" + account.Name + "'");
account = accounts.FirstOrDefault();
if (account == null)
{
Console.WriteLine("Failed to retrieve account by query!");
return;
}
Console.WriteLine("Retrieved the record by name.");
// Delete account
Console.WriteLine("Deleting the record by ID.");
success = await client.DeleteAsync(Account.SObjectTypeName, account.Id);
if (!success)
{
Console.WriteLine("Failed to delete the record by ID!");
return;
}
Console.WriteLine("Deleted the record by ID.");
}
private static async Task RunSample()
{
var auth = new AuthenticationClient();
// Authenticate with Salesforce
Console.WriteLine("Authenticating with Salesforce");
await auth.UsernamePasswordAsync(ConsumerKey, ConsumerSecret, Username, Password);
Console.WriteLine("Connected to Salesforce");
var client = new ForceClient(auth.InstanceUrl, auth.AccessToken, auth.ApiVersion);
// Create a sample record
Console.WriteLine("Creating test record.");
var account = new Account {
Name = "Test Account"
};
account.Id = await client.CreateAsync(Account.SObjectTypeName, account);
if (account.Id == null)
{
Console.WriteLine("Failed to create test record.");
return;
}
Console.WriteLine("Successfully created test record.");
// Update the sample record
// Shows that annonymous types can be used as well
Console.WriteLine("Updating test record.");
var success = await client.UpdateAsync(Account.SObjectTypeName, account.Id, new { Name = "Test Update" });
if (!success)
{
Console.WriteLine("Failed to update test record!");
return;
}
Console.WriteLine("Successfully updated the record.");
// Retrieve the sample record
// How to retrieve a single record if the id is known
Console.WriteLine("Retrieving the record by ID.");
account = await client.QueryByIdAsync <Account>(Account.SObjectTypeName, account.Id);
if (account == null)
{
Console.WriteLine("Failed to retrieve the record by ID!");
return;
}
Console.WriteLine("Retrieved the record by ID.");
// Query for record by name
Console.WriteLine("Querying the record by name.");
var accounts = await client.QueryAsync <Account>("SELECT ID, Name FROM Account WHERE Name = '" + account.Name + "'");
account = accounts.records.FirstOrDefault();
if (account == null)
{
Console.WriteLine("Failed to retrieve account by query!");
return;
}
Console.WriteLine("Retrieved the record by name.");
// Delete account
Console.WriteLine("Deleting the record by ID.");
success = await client.DeleteAsync(Account.SObjectTypeName, account.Id);
if (!success)
{
Console.WriteLine("Failed to delete the record by ID!");
return;
}
Console.WriteLine("Deleted the record by ID.");
// Selecting multiple accounts into a dynamic
Console.WriteLine("Querying multiple records.");
var dynamicAccounts = await client.QueryAsync <dynamic>("SELECT ID, Name FROM Account LIMIT 10");
foreach (dynamic acct in dynamicAccounts.records)
{
Console.WriteLine("Account - " + acct.Name);
}
// Creating parent - child records using a Dynamic
Console.WriteLine("Creating a parent record (Account)");
dynamic a = new ExpandoObject();
a.Name = "Account from .Net Toolkit";
a.Id = await client.CreateAsync("Account", a);
if (a.Id == null)
{
Console.WriteLine("Failed to create parent record.");
return;
}
Console.WriteLine("Creating a child record (Contact)");
dynamic c = new ExpandoObject();
c.FirstName = "Joe";
c.LastName = "Blow";
c.AccountId = a.Id;
c.Id = await client.CreateAsync("Contact", c);
if (c.Id == null)
{
Console.WriteLine("Failed to create child record.");
return;
}
Console.WriteLine("Press Enter to delete parent and child and continue");
Console.Read();
// Delete account (also deletes contact)
Console.WriteLine("Deleting the Account by Id.");
success = await client.DeleteAsync(Account.SObjectTypeName, a.Id);
if (!success)
{
Console.WriteLine("Failed to delete the record by ID!");
return;
}
Console.WriteLine("Deleted the Account and Contact.");
}
