protected void Query_Test()
{
DatabaseDotComContext context = (DatabaseDotComContext)Session["context"];
DatabaseDotComClient client = new DatabaseDotComClient(context);
// BEGIN Query Example
DatabaseDotCom.DatabaseDotComClient.QueryResult qr = client.Query("Select Id, Name, FirstName, LastName, Phone, Account.Id, Account.Name From Contact");
System.Diagnostics.Debug.WriteLine("Records: " + qr.size);
foreach (DatabaseDotComClient.DBCObject obj in qr.records)
{
System.Diagnostics.Debug.WriteLine("Id: " + obj.GetStringField("Id"));
System.Diagnostics.Debug.WriteLine("Name: " + obj.GetStringField("Name"));
if (obj.getFields().ContainsKey("Contacts"))
{
try
{
DatabaseDotComClient.QueryResult cons = (DatabaseDotComClient.QueryResult)obj.getFields()["Contacts"];
foreach (DatabaseDotComClient.DBCObject con in cons.records)
{
System.Diagnostics.Debug.WriteLine("Contact name: " + con.GetStringField("Name"));
}
}
catch (Exception ex)
{
}
}
else if (obj.getFields().ContainsKey("Account"))
{
try
{
DatabaseDotComClient.DBCObject account = (DatabaseDotComClient.DBCObject)obj.getFields()["Account"];
System.Diagnostics.Debug.WriteLine("Account name: " + account.GetStringField("Name"));
System.Diagnostics.Debug.WriteLine("Account industry: " + account.GetStringField("Industry"));
System.Diagnostics.Debug.WriteLine("Account id: " + account.GetStringField("Id"));
}
catch (Exception ex)
{
}
}
GridView1.DataSource = qr.GetDataSet();
GridView1.DataBind();
// END Query Example
}
}
protected void DeleteByQueryResult_Click(object sender, EventArgs e)
{
outputbox.Text += "Starting delete using query result sample..." + Environment.NewLine;
DatabaseDotComContext context = (DatabaseDotComContext)Session["context"];
DatabaseDotComClient client = new DatabaseDotComClient(context);
DatabaseDotComClient.QueryResult contactQuery = client.Query("Select Id From Contact Where FirstName = 'Joe'");
DatabaseDotCom.DBDCReference.DeleteResult[] results = client.DeleteByQueryResult(contactQuery);
outputbox.Text += "Delete success result is: " + results[0].success + Environment.NewLine + Environment.NewLine;
Query_Test();
}
/*
protected void Update_Click(object sender, EventArgs e)
{
// BEGIN Update Example
DatabaseDotComContext context = (DatabaseDotComContext)Session["context"];
DatabaseDotComClient client = new DatabaseDotComClient(context);
outputbox.Text += "Starting update sample..." + Environment.NewLine;
DatabaseDotComClient.QueryResult accountQuery = client.Query("Select Id From Account Where Name = 'Azure Test Account'");
DatabaseDotComClient.DBCObject newAccount = accountQuery.records[0];
newAccount.SetStringField("Industry", "Agriculture");
DatabaseDotCom.DBDCReference.SaveResult sr;
newAccount = client.Update(newAccount, out sr);
outputbox.Text += "Update success result is: " + sr.success + Environment.NewLine + Environment.NewLine;
//END Update Example
}
*/
protected void DeleteByIds_Click(object sender, EventArgs e)
{
// BEGIN Delete Example
DatabaseDotComContext context = (DatabaseDotComContext)Session["context"];
DatabaseDotComClient client = new DatabaseDotComClient(context);
outputbox.Text += "Starting delete using ids sample..." + Environment.NewLine;
DatabaseDotComClient.QueryResult contactQuery = client.Query("Select Id From Contact Where FirstName = 'Joe'");
string[] ids = new string[contactQuery.records.Length];
for (int i = 0; i < ids.Length; i++)
{
ids[i] = contactQuery.records[i].Id;
}
DatabaseDotCom.DBDCReference.DeleteResult[] results = client.DeleteByIds(ids);
outputbox.Text += "Delete success result is: " + results[0].success + Environment.NewLine + Environment.NewLine;
Query_Test();
}
