// GET: Assistance // GET: Contacts // Note: the SOQL Field list, and Binding Property list have subtle differences as custom properties may be mapped with the JsonProperty attribute to remove __c //const string _ContactsPostBinding = "Id,Salutation,FirstName,LastName,MailingStreet,MailingCity,MailingState,MailingPostalCode,MailingCountry,Phone,Email"; // GET: Contacts public async Task <ActionResult> Index() { IEnumerable <Assistance__c> selectedContacts = Enumerable.Empty <Assistance__c>(); try { selectedContacts = await SalesforceService.MakeAuthenticatedClientRequestAsync( async (client) => { QueryResult <Assistance__c> contacts = await client.QueryAsync <Assistance__c>("SELECT Owner ID, Assistance Name, Contact, Date, Description, Provider, Status From Assistance__c"); return(contacts.Records); } ); } catch (Exception e) { this.ViewBag.OperationName = "query Salesforce Contacts"; this.ViewBag.AuthorizationUrl = SalesforceOAuthRedirectHandler.GetAuthorizationUrl(this.Request.Url.ToString()); this.ViewBag.ErrorMessage = e.Message; } if (this.ViewBag.ErrorMessage == "AuthorizationRequired") { return(Redirect(this.ViewBag.AuthorizationUrl)); } return(View(selectedContacts)); }
public async Task <ActionResult> Edit(string id) { IEnumerable <Contact> selectedContacts = Enumerable.Empty <Contact>(); try { selectedContacts = await SalesforceService.MakeAuthenticatedClientRequestAsync( async (client) => { QueryResult <Contact> contacts = await client.QueryAsync <Contact>("SELECT Id, FirstName, LastName, MailingStreet, MailingCity, MailingState, MailingPostalCode, MailingCountry, Phone, Email From Contact Where Id= '" + id + "'"); return(contacts.Records); } ); } catch (Exception e) { this.ViewBag.OperationName = "Edit Salesforce Contacts"; this.ViewBag.AuthorizationUrl = SalesforceOAuthRedirectHandler.GetAuthorizationUrl(this.Request.Url.ToString()); this.ViewBag.ErrorMessage = e.Message; } if (this.ViewBag.ErrorMessage == "AuthorizationRequired") { return(Redirect(this.ViewBag.AuthorizationUrl)); } return(View(selectedContacts.FirstOrDefault())); }
public async Task <ActionResult> Create([Bind(Include = _ContactsPostBinding)] Contact contact) { String id = String.Empty; try { id = (await SalesforceService.MakeAuthenticatedClientRequestAsync( async(client) => { return(await client.CreateAsync("Contact", contact)); } )).ToString(); } catch (Exception e) { this.ViewBag.OperationName = "Create Salesforce Contact"; this.ViewBag.AuthorizationUrl = SalesforceOAuthRedirectHandler.GetAuthorizationUrl(this.Request.Url.ToString()); this.ViewBag.ErrorMessage = e.Message; } if (this.ViewBag.ErrorMessage == "AuthorizationRequired") { return(Redirect(this.ViewBag.AuthorizationUrl)); } if (this.ViewBag.ErrorMessage == null) { return(RedirectToAction("Index")); } else { return(View(contact)); } }
public async Task <ActionResult> Edit(string id) { IEnumerable <LeadViewModel> selectedLeads = Enumerable.Empty <LeadViewModel>(); try { selectedLeads = await SalesforceService.MakeAuthenticatedClientRequestAsync( async (client) => { QueryResult <LeadViewModel> leads = await client.QueryAsync <LeadViewModel>("SELECT Id, Salutation, FirstName, LastName, Company, Street, City, State, PostalCode, Phone, MobilePhone, Fax, Email, Status, Description From Lead Where Id = '" + id + "'"); return(leads.Records); } ); } catch (Exception e) { this.ViewBag.OperationName = "Edit Salesforce Leads"; this.ViewBag.AuthorizationUrl = SalesforceOAuthRedirectHandler.GetAuthorizationUrl(this.Request.Url.ToString()); this.ViewBag.ErrorMessage = e.Message; } if (this.ViewBag.ErrorMessage == "AuthorizationRequired") { return(Redirect(this.ViewBag.AuthorizationUrl)); } return(View(selectedLeads.FirstOrDefault())); }
public async Task <ActionResult> Edit(string id) { IEnumerable <Product2> selectedProduct2s = Enumerable.Empty <Product2>(); try { selectedProduct2s = await SalesforceService.MakeAuthenticatedClientRequestAsync( async (client) => { QueryResult <Product2> Product2s = await client.QueryAsync <Product2>("SELECT Id, Name, ProductCode, Description, CreatedDate, Family From Product2 Where Id= '" + id + "'"); return(Product2s.Records); } ); } catch (Exception e) { this.ViewBag.OperationName = "Edit Salesforce Product2s"; this.ViewBag.AuthorizationUrl = SalesforceOAuthRedirectHandler.GetAuthorizationUrl(this.Request.Url.ToString()); this.ViewBag.ErrorMessage = e.Message; } if (this.ViewBag.ErrorMessage == "AuthorizationRequired") { return(Redirect(this.ViewBag.AuthorizationUrl)); } return(View(selectedProduct2s.FirstOrDefault())); }
public async Task <ActionResult> DeleteConfirmed(string id) { bool success = false; try { success = await SalesforceService.MakeAuthenticatedClientRequestAsync( async (client) => { success = await client.DeleteAsync("Contact", id); return(success); } ); } catch (Exception e) { this.ViewBag.OperationName = "Delete Salesforce Contacts"; this.ViewBag.AuthorizationUrl = SalesforceOAuthRedirectHandler.GetAuthorizationUrl(this.Request.Url.ToString()); this.ViewBag.ErrorMessage = e.Message; } if (this.ViewBag.ErrorMessage == "AuthorizationRequired") { return(Redirect(this.ViewBag.AuthorizationUrl)); } if (success) { return(RedirectToAction("Index")); } else { return(View()); } }
public async Task <ActionResult> Edit([Bind(Include = _ContactsPostBinding)] Contact contact) { SuccessResponse success = new SuccessResponse(); try { success = await SalesforceService.MakeAuthenticatedClientRequestAsync( async (client) => { success = await client.UpdateAsync("Contact", contact.Id, contact); return(success); } ); } catch (Exception e) { this.ViewBag.OperationName = "Edit Salesforce Contact"; this.ViewBag.AuthorizationUrl = SalesforceOAuthRedirectHandler.GetAuthorizationUrl(this.Request.Url.ToString()); this.ViewBag.ErrorMessage = e.Message; } if (this.ViewBag.ErrorMessage == "AuthorizationRequired") { return(Redirect(this.ViewBag.AuthorizationUrl)); } if (success.Success == true) { return(RedirectToAction("Index")); } else { return(View(contact)); } }
// GET: Contacts public async Task <ActionResult> Index() { IEnumerable <Contact> selectedContacts = Enumerable.Empty <Contact>(); try { selectedContacts = await SalesforceService.MakeAuthenticatedClientRequestAsync( async (client) => { QueryResult <Contact> contacts = await client.QueryAsync <Contact>("SELECT Id, Salutation, FirstName, LastName, MailingCity, MailingState, MailingCountry From Contact"); return(contacts.Records); } ); } catch (Exception e) { this.ViewBag.OperationName = "query Salesforce Contacts"; this.ViewBag.AuthorizationUrl = SalesforceOAuthRedirectHandler.GetAuthorizationUrl(this.Request.Url.ToString()); this.ViewBag.ErrorMessage = e.Message; } if (this.ViewBag.ErrorMessage == "AuthorizationRequired") { return(Redirect(this.ViewBag.AuthorizationUrl)); } return(View(selectedContacts)); }
public async Task <ActionResult> Edit(string id) { IEnumerable <Event> selectedEvents = Enumerable.Empty <Event>(); try { selectedEvents = await SalesforceService .MakeAuthenticatedClientRequestAsync( async (client) => { QueryResult <Event> Events = await client .QueryAsync <Event>( _SelectAll + $" Where Id= '{id}'"); return(Events.Records); } ); } catch (Exception e) { ViewBag.OperationName = "Edit Salesforce Events"; ViewBag.AuthorizationUrl = SalesforceOAuthRedirectHandler .GetAuthorizationUrl(Request.Url.ToString()); ViewBag.ErrorMessage = e.Message; } if (ViewBag.ErrorMessage == "AuthorizationRequired") { return(Redirect(ViewBag.AuthorizationUrl)); } return(View(selectedEvents.FirstOrDefault())); }
public async Task <ActionResult> Create([Bind(Include = _EventsPostBinding)] Event Event) { SuccessResponse success = new SuccessResponse(); String id = String.Empty; try { success = await SalesforceService.MakeAuthenticatedClientRequestAsync( async (client) => { return(await client.CreateAsync("Event", Event)); } ); id = success.Id; } catch (Exception e) { this.ViewBag.OperationName = "Create Salesforce Event"; this.ViewBag.AuthorizationUrl = SalesforceOAuthRedirectHandler.GetAuthorizationUrl(this.Request.Url.ToString()); this.ViewBag.ErrorMessage = e.Message; } if (this.ViewBag.ErrorMessage == "AuthorizationRequired") { return(Redirect(this.ViewBag.AuthorizationUrl)); } if (this.ViewBag.ErrorMessage == null) { return(RedirectToAction("Index")); } else { return(View(Event)); } }
// GET: Events public async Task <ActionResult> Index() { IEnumerable <Event> selectedEvents = Enumerable.Empty <Event>(); try { selectedEvents = await SalesforceService .MakeAuthenticatedClientRequestAsync( async (client) => { QueryResult <Event> events = await client .QueryAsync <Event>(_SelectAll); return(events.Records); } ); } catch (Exception e) { ViewBag.OperationName = "query Salesforce Events"; ViewBag.AuthorizationUrl = SalesforceOAuthRedirectHandler .GetAuthorizationUrl(Request.Url.ToString()); ViewBag.ErrorMessage = e.Message; } if (ViewBag.ErrorMessage == "AuthorizationRequired") { return(Redirect(ViewBag.AuthorizationUrl)); } IEnumerable <EventIndexViewModel> viewEvents = EventHelper.GetEventIndexViewModel(selectedEvents); return(View(viewEvents)); }
// GET: Leads public async Task <ActionResult> Index() { ApplicationUser user = await UserManager.FindByIdAsync(User.Identity.GetUserId()); IEnumerable <LeadViewModel> selectedLeads = Enumerable.Empty <LeadViewModel>(); if (User.Identity.IsAuthenticated) { if (User.IsInRole("admin")) { try { selectedLeads = await SalesforceService.MakeAuthenticatedClientRequestAsync( async (client) => { QueryResult <LeadViewModel> leads = await client.QueryAsync <LeadViewModel>( "SELECT Id, LastName, Salutation, FirstName, Phone, MobilePhone, Email, UserEmail__c From Lead"); return(leads.Records); } ); } catch (Exception e) { this.ViewBag.OperationName = "query Salesforce Leads"; this.ViewBag.AuthorizationUrl = SalesforceOAuthRedirectHandler.GetAuthorizationUrl(this.Request.Url.ToString()); this.ViewBag.ErrorMessage = e.Message; } } else { try { selectedLeads = await SalesforceService.MakeAuthenticatedClientRequestAsync( async (client) => { QueryResult <LeadViewModel> leads = await client.QueryAsync <LeadViewModel>("SELECT Id, LastName, Salutation, FirstName, Phone, MobilePhone, Email, UserEmail__c From Lead Where UserEmail__c = '" + user.UserName + "'"); return(leads.Records); } ); } catch (Exception e) { this.ViewBag.OperationName = "query Salesforce Leads"; this.ViewBag.AuthorizationUrl = SalesforceOAuthRedirectHandler.GetAuthorizationUrl(this.Request.Url.ToString()); this.ViewBag.ErrorMessage = e.Message; } } } if (this.ViewBag.ErrorMessage == "AuthorizationRequired") { return(Redirect(this.ViewBag.AuthorizationUrl)); } return(View(selectedLeads)); }
public async Task <ActionResult> Create(LeadViewModel lead) { ApplicationUser user = await UserManager.FindByIdAsync(User.Identity.GetUserId()); var Lead = new LeadViewModel { Id = lead.Id, Salutation = lead.Salutation, FirstName = lead.FirstName, LastName = lead.LastName, Company = lead.Company, Street = lead.Street, City = lead.City, State = lead.State, PostalCode = lead.PostalCode, Phone = lead.Phone, MobilePhone = lead.MobilePhone, Fax = lead.Fax, Email = lead.Email, Status = lead.Status, CreatedDate = lead.CreatedDate, Description = lead.Description, UserEmail__c = user.Email }; String id = String.Empty; try { id = (await SalesforceService.MakeAuthenticatedClientRequestAsync( async(client) => { return(await client.CreateAsync("Lead", Lead)); } )).ToString(); } catch (Exception e) { this.ViewBag.OperationName = "Create Salesforce Lead"; this.ViewBag.AuthorizationUrl = SalesforceOAuthRedirectHandler.GetAuthorizationUrl(this.Request.Url.ToString()); this.ViewBag.ErrorMessage = e.Message; } if (this.ViewBag.ErrorMessage == "AuthorizationRequired") { return(Redirect(this.ViewBag.AuthorizationUrl)); } if (this.ViewBag.ErrorMessage == null) { return(RedirectToAction("Index")); } else { return(View(lead)); } }
public Task <List <T> > SalesforceRequest <T>(string soqlQuery) { var requestTask = SalesforceService .MakeAuthenticatedClientRequestAsync( async(client) => { QueryResult <T> entities = await client .QueryAsync <T>(soqlQuery); return(entities.Records); } ); return(requestTask); }
public async Task <ActionResult> Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } IEnumerable <Event> selectedEvents = Enumerable.Empty <Event>(); try { selectedEvents = await SalesforceService .MakeAuthenticatedClientRequestAsync( async (client) => { // Query the properties you'll display for the user to confirm they wish to delete this Event QueryResult <Event> Events = await client .QueryAsync <Event>( _SelectAll + $" Where Id='{id}'"); return(Events.Records); } ); } catch (Exception e) { ViewBag.OperationName = "query Salesforce Events"; ViewBag.AuthorizationUrl = SalesforceOAuthRedirectHandler .GetAuthorizationUrl(Request.Url.ToString()); ViewBag.ErrorMessage = e.Message; } if (ViewBag.ErrorMessage == "AuthorizationRequired") { return(Redirect(ViewBag.AuthorizationUrl)); } if (selectedEvents.Count() == 0) { return(View()); } else { return(View(selectedEvents.FirstOrDefault())); } }
public async Task <ActionResult> Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } IEnumerable <Contact> selectedContacts = Enumerable.Empty <Contact>(); try { selectedContacts = await SalesforceService.MakeAuthenticatedClientRequestAsync( async (client) => { // Query the properties you'll display for the user to confirm they wish to delete this Contact QueryResult <Contact> contacts = await client.QueryAsync <Contact>(string.Format("SELECT Id, FirstName, LastName, MailingCity, MailingState, MailingCountry From Contact Where Id='{0}'", id)); return(contacts.Records); } ); } catch (Exception e) { this.ViewBag.OperationName = "query Salesforce Contacts"; this.ViewBag.AuthorizationUrl = SalesforceOAuthRedirectHandler.GetAuthorizationUrl(this.Request.Url.ToString()); this.ViewBag.ErrorMessage = e.Message; } if (this.ViewBag.ErrorMessage == "AuthorizationRequired") { return(Redirect(this.ViewBag.AuthorizationUrl)); } if (selectedContacts.Count() == 0) { return(View()); } else { return(View(selectedContacts.FirstOrDefault())); } }
public async Task <ActionResult> Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } IEnumerable <LeadViewModel> selectedLeads = Enumerable.Empty <LeadViewModel>(); try { selectedLeads = await SalesforceService.MakeAuthenticatedClientRequestAsync( async (client) => { // Query the properties you'll display for the user to confirm they wish to delete this Contact QueryResult <LeadViewModel> leads = await client.QueryAsync <LeadViewModel>(string.Format("SELECT Id, Salutation, FirstName, LastName, Company, Street, City, State, PostalCode, Phone, MobilePhone, Fax, Email, Status, CreatedDate, Description, UserEmail__c From Lead Where Id='{0}'", id)); return(leads.Records); } ); } catch (Exception e) { this.ViewBag.OperationName = "query Salesforce Leads"; this.ViewBag.AuthorizationUrl = SalesforceOAuthRedirectHandler.GetAuthorizationUrl(this.Request.Url.ToString()); this.ViewBag.ErrorMessage = e.Message; } if (this.ViewBag.ErrorMessage == "AuthorizationRequired") { return(Redirect(this.ViewBag.AuthorizationUrl)); } if (selectedLeads.Count() == 0) { return(View()); } else { return(View(selectedLeads.FirstOrDefault())); } }