public async Task <ActionResult> Index() { var allLeads = new SalesForceModels.LeadsViewModel(); try { var client = await _salesForceService.CreateForceClient(); allLeads = await _dbConnector.GetLeads(client); } catch (Exception ex) { throw new Exception(ex.Message); } return(View("Index", allLeads)); }
public async Task <SalesForceModels.LeadsViewModel> GetLeads(ForceClient client) { var allLeads = new SalesForceModels.LeadsViewModel(); var leads = await client.QueryAsync <SalesForceModels.LeadModel>("SELECT ID, FirstName, LastName, Company, Email, Status, Phone From Lead ORDER BY LastName ASC"); if (leads.Records.Any()) { foreach (var lead in leads.Records) { allLeads.Leads.Add(new SalesForceModels.LeadModel { Id = lead.Id, FirstName = lead.FirstName, LastName = lead.LastName, Company = lead.Company, Email = lead.Email, Status = lead.Status, Phone = lead.Phone }); } } return(allLeads); }