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));
        }