public NetResponse GetUsers()
{
string query = @"?q=" + QueryStrings.Users_Select;
HTTPGetRequest client = new HTTPGetRequest(QueryURL + query);
return(client.Execute());
}
public NetResponse GetAccounts()
{
HTTPGetRequest client = new HTTPGetRequest(QueryURL + "?q=" + QueryStrings.Accounts_Select + "+WHERE+InActive__c=false");
NetResponse NR = client.Execute();
if (NR.HasError == false)
{
QueryResult <Account> qResult = new QueryResult <Account>();
qResult.HydrateFromJSon(NR.JSON);
List <Account> accounts = new List <Account>();
accounts.AddRange(qResult.records);
while (qResult.done == false)
{
client = new HTTPGetRequest(RESTDomainURL + qResult.nextRecordsUrl);
NR = client.Execute();
qResult = new QueryResult <Account>();
qResult.HydrateFromJSon(NR.JSON);
accounts.AddRange(qResult.records);
}
qResult.records.Clear();
qResult.records.AddRange(accounts);
MemoryStream ms = new MemoryStream();
DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(List <Account>));
ser.WriteObject(ms, qResult.records);
string json = Encoding.UTF8.GetString(ms.ToArray());
NR.JSON = json;
}
return(NR);
}
public NetResponse GetCasesByContact(string contactId)
{
string query = "?q=" + QueryStrings.Cases_Select + "+WHERE+Universal_Contact__c='" + contactId + "'";
HTTPGetRequest client = new HTTPGetRequest(QueryURL + query);
return(client.Execute());
}
public NetResponse GetUser(string username)
{
string query = @"?q=" + QueryStrings.Users_Select + "+WHERE+Username+LIKE+'%" + username + "%'";
HTTPGetRequest client = new HTTPGetRequest(QueryURL + query);
return(client.Execute());
}
public NetResponse GetCase(string Id)
{
string query = "Case/" + Id;
HTTPGetRequest client = new HTTPGetRequest(ObjectsURL + query);
return(client.Execute());
}
public NetResponse GetCasesByAccount(string acctId)
{
string query = "?q=" + QueryStrings.Cases_Select + "+WHERE+AccountId='" + acctId + "'";
HTTPGetRequest client = new HTTPGetRequest(QueryURL + query);
return(client.Execute());
}
public NetResponse ValidateContact(string email, string password)
{
string query = "?q=SELECT+Id,Name+from+Contact+WHERE+Email='" + email + "'+AND+Password__c='" + password + "'+LIMIT 1";
HTTPGetRequest client = new HTTPGetRequest(QueryURL + query);
return(client.Execute());
}
public NetResponse GetContactRoles(string contactid)
{
string query = "?q=" + QueryStrings.ContactRoles_Select + "+WHERE+Contact__c='" + contactid + "'";
HTTPGetRequest client = new HTTPGetRequest(QueryURL + query);
return(client.Execute());
}
public NetResponse GetContact(string id)
{
HTTPGetRequest client = new HTTPGetRequest(ObjectsURL + "Contact/" + id);
NetResponse NR = client.Execute();
return(NR);
}
public NetResponse GetAccountByName(string name)
{
HTTPGetRequest client = new HTTPGetRequest(QueryURL + "?q=" + QueryStrings.Accounts_Select + "+Where+Name='" + name + "'+And+InActive__c=false");
NetResponse NR = client.Execute();
return(NR);
}
private void GetAllAccounts()
{
(new Thread(() =>
{
HTTPGetRequest client = new HTTPGetRequest(QueryURL + @"?q=" + QueryStrings.Accounts_Select + "+WHERE+InActive__c=false");
NetResponse NR = client.Execute();
if (NR.HasError == false)
{
QueryResult <Account> qResult = new QueryResult <Account>();
qResult.HydrateFromJSon(NR.JSON);
List <Account> accounts = new List <Account>();
accounts.AddRange(qResult.records);
while (qResult.done == false)
{
client = new HTTPGetRequest(RESTDomainURL + qResult.nextRecordsUrl);
NR = client.Execute();
qResult = new QueryResult <Account>();
qResult.HydrateFromJSon(NR.JSON);
accounts.AddRange(qResult.records);
}
qResult.records.Clear();
qResult.records.AddRange(accounts);
_Accounts.AddRange(qResult.records.OrderBy(p => p.Name).ToList());
}
})).Start();
}
public NetResponse GetContactByEmail(string email)
{
string query = "?q=" + QueryStrings.Contacts_Select + "+Where+Email='" + email + "'+And+InActive__c=false";
HTTPGetRequest client = new HTTPGetRequest(QueryURL + query);
NetResponse NR = client.Execute();
return(NR);
}
private Field[] GetContactFields()
{
HTTPGetRequest client = new HTTPGetRequest(ObjectsURL + "Contact/describe");
NetResponse NR = client.Execute();
if (NR.HasError == false)
{
sOjbectDescribe details = new sOjbectDescribe(NR.JSON);
return(details.fields);
}
return(null);
}
public NetResponse GetContactDescribe()
{
HTTPGetRequest client = new HTTPGetRequest(ObjectsURL + "Contact/describe");
return(client.Execute());
}
