protected void EditPhone(object sender, GridViewEditEventArgs e)
{
outputbox.Text += "Starting update sample..." + Environment.NewLine;
// BEGIN Update Example
DatabaseDotComContext context = (DatabaseDotComContext)Session["context"];
DatabaseDotComClient client = new DatabaseDotComClient(context);
outputbox.Text += "Starting update sample..." + Environment.NewLine;
DatabaseDotComClient.DBCObject contact = new DatabaseDotComClient.DBCObject("Contact");
HiddenField idField = (HiddenField)GridView1.Rows[e.NewEditIndex].FindControl("IdField");
TextBox phoneText = (TextBox)GridView1.Rows[e.NewEditIndex].FindControl("newPhone");
contact.Id = idField.Value;
contact.SetStringField("Phone", phoneText.Text);
outputbox.Text += "New Phone is:"+contact.GetStringField("Phone")+Environment.NewLine;
DatabaseDotCom.DBDCReference.SaveResult sr;
contact = client.Update(contact, out sr);
outputbox.Text += "Update success result is: " + sr.success + Environment.NewLine + Environment.NewLine;
System.Diagnostics.Debug.WriteLine("Row Updated");
Query_Test();
}
public DBDCReference.DeleteResult[] DeleteObjects(DatabaseDotComClient.DBCObject[] objects)
{
string[] ids = new string[objects.Length];
for (int i = 0; i < ids.Length; i++)
{
ids[i] = objects[i].Id;
}
return DeleteByIds(ids);
}
protected void Page_Load(object sender, EventArgs e)
{
// BEGIN Login Example
DatabaseDotComClient client = new DatabaseDotComClient(DatabaseDotComContext.FromConfigurationSetting("DbDotComConnectionString"));
// END Login Example
// DatabaseDotComClient client = new DatabaseDotComClient();
// client.context = client.Login("", "", "");
Session.Add("context", client.context);
if (IsPostBack == false) { Query_Test(); }
}
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();
}
protected void CreateMultiple_Click(object sender, EventArgs e)
{
DatabaseDotComContext context = (DatabaseDotComContext)Session["context"];
DatabaseDotComClient client = new DatabaseDotComClient(context);
outputbox.Text += "Starting Create with batch..." + Environment.NewLine;
DatabaseDotComClient.DBCObject[] contacts = new DatabaseDotComClient.DBCObject[1];
DatabaseDotComClient.DBCObject newContact1 = new DatabaseDotComClient.DBCObject("Contact");
newContact1.SetStringField("FirstName", "Joe");
newContact1.SetStringField("LastName", "Test1");
DatabaseDotComClient.DBCObject newContact2 = new DatabaseDotComClient.DBCObject("Contact");
newContact2.SetStringField("FirstName", "Joe");
newContact2.SetStringField("LastName", "Test2");
DatabaseDotCom.DBDCReference.SaveResult[] srs;
contacts = client.Create(new DatabaseDotComClient.DBCObject[] { newContact1, newContact2 }, out srs);
outputbox.Text += "Create was successful, new id is: " + contacts[0].Id + Environment.NewLine + Environment.NewLine;
// END Create Example
Query_Test();
}
protected void CreateSingle_Click(object sender, EventArgs e)
{
DatabaseDotComContext context = (DatabaseDotComContext)Session["context"];
DatabaseDotComClient client = new DatabaseDotComClient(context);
// BEGIN Create Example
outputbox.Text += "Starting Create Sample..." + Environment.NewLine;
DatabaseDotComClient.DBCObject newContact = new DatabaseDotComClient.DBCObject("Contact");
newContact.SetStringField("FirstName", "Joe");
newContact.SetStringField("LastName", "Test");
DatabaseDotCom.DBDCReference.SaveResult sr;
newContact = client.Create(newContact, out sr);
outputbox.Text += "Create was successful, new id is: " + newContact.Id + Environment.NewLine + Environment.NewLine;
Query_Test();
}
public DBDCReference.DeleteResult[] DeleteByQueryResult(DatabaseDotComClient.QueryResult queryresult)
{
return DeleteObjects(queryresult.records);
}
public DatabaseDotComContext(string configConnectionString)
{
this.configConnectionString = configConnectionString;
parseConnectionString(this.configConnectionString);
DatabaseDotComClient c = new DatabaseDotComClient();
DatabaseDotComContext ct = c.Login(this.username, _password, token);
this.sessionHeader = ct.sessionHeader;
this.allOrNoneHeader = ct.allOrNoneHeader;
this.allowFieldTruncationHeader = ct.allowFieldTruncationHeader;
this.assignmentRuleHeader = ct.assignmentRuleHeader;
this.callOptions = ct.callOptions;
this.debuggingHeader = ct.debuggingHeader;
this.disableFeedTrackingHeader = ct.disableFeedTrackingHeader;
this.emailHeader = ct.emailHeader;
this.loginEnpoint = ct.loginEnpoint;
this.loginResult = ct.loginResult;
this.loginScopeHeader = ct.loginScopeHeader;
this.mruHeader = ct.mruHeader;
this.packageVersionHeader = ct.packageVersionHeader;
this.token = ct.token;
this.password = ct.password;
this.queryOptions = ct.queryOptions;
this.username = ct.username;
this.userTerritoryDeleteHeader = ct.userTerritoryDeleteHeader;
}
