public async Task <SalesForceModels.OpportunitiesViewModel> GetOpportunities(ForceClient client) { var allOpportunities = new SalesForceModels.OpportunitiesViewModel(); var opportunities = await client.QueryAsync <SalesForceModels.OpportunityModel>("SELECT ID, Name, CloseDate, StageName, Type, Amount, LeadSource,Probability From Opportunity ORDER BY Name ASC"); if (opportunities.Records.Any()) { foreach (var opportunity in opportunities.Records) { allOpportunities.Opportunities.Add(new SalesForceModels.OpportunityModel { Id = opportunity.Id, Name = opportunity.Name, CloseDate = opportunity.CloseDate, StageName = opportunity.StageName, Type = opportunity.Type, Amount = opportunity.Amount, LeadSource = opportunity.LeadSource, Probability = opportunity.Probability, //Account = opportunity.Account }); } } return(allOpportunities); }
public async Task <ActionResult> Index() { var allOpportunities = new SalesForceModels.OpportunitiesViewModel(); try { var client = await _salesForceService.CreateForceClient(); allOpportunities = await _dbConnector.GetOpportunities(client); } catch (Exception ex) { throw new Exception(ex.Message); } return(View("Index", allOpportunities)); }