foreach (int issueId in bugs.Keys)
{
DataExtensionObject row = new DataExtensionObject();
row.CustomerKey = "cr";
row.Properties = new APIProperty[10];
row.Properties[0] = new APIProperty();
row.Properties[0].Name = "ID";
row.Properties[0].Value = bugs[issueId].ID.ToString();
row.Properties[1] = new APIProperty();
row.Properties[1].Name = "Project";
row.Properties[1].Value = Request.QueryString["BG_USER_01"].Replace("'", "");
row.Properties[2] = new APIProperty();
row.Properties[2].Name = "Summary";
row.Properties[2].Value = bugs[issueId].Summary;
row.Properties[3] = new APIProperty();
row.Properties[3].Name = "Priority";
row.Properties[3].Value = bugs[issueId].Priority;
row.Properties[4] = new APIProperty();
row.Properties[4].Name = "Status";
row.Properties[4].Value = bugs[issueId].Status;
row.Properties[5] = new APIProperty();
row.Properties[5].Name = "AssignedTo";
row.Properties[5].Value = bugs[issueId].AssignedTo;
row.Properties[6] = new APIProperty();
row.Properties[6].Name = "DetectedBy";
row.Properties[6].Value = bugs[issueId].DetectedBy;
// Comments
if (bugs[issueId].Comments != null)
{
row.Properties[7] = new APIProperty();
row.Properties[7].Name = "Comments";
row.Properties[7].Value = bugs[issueId].Comments;
}
else
{
row.Properties[7] = new NullAPIProperty();
row.Properties[7].Name = "Comments";
}
// Description
if (bugs[issueId].Description != null)
{
row.Properties[8] = new APIProperty();
row.Properties[8].Name = "Description";
row.Properties[8].Value = bugs[issueId].Description;
}
else
{
row.Properties[8] = new NullAPIProperty();
row.Properties[8].Name = "Description";
}
// SalesforceID
if (bugs[issueId].SalesforceID != null)
{
row.Properties[9] = new APIProperty();
row.Properties[9].Name = "SalesforceID";
row.Properties[9].Value = bugs[issueId].SalesforceID.ToString();
}
else
{
row.Properties[9] = new NullAPIProperty();
row.Properties[9].Name = "SalesforceID";
}
objects.Add(row);
}
APIObject[] apiObjects = new APIObject[objects.Count];
for(int i = 0; i<objects.Count; i++)
{
apiObjects[i] = (APIObject)objects[i];
}
UpdateOptions uo = new UpdateOptions();
uo.SaveOptions = new SaveOption[1];
uo.SaveOptions[0] = new SaveOption();
uo.SaveOptions[0].PropertyName = "DataExtensionObject";
uo.SaveOptions[0].SaveAction = SaveAction.UpdateAdd;
UpdateResult[] updateResults = et.Update(uo, apiObjects, out requestID, out status);
Page.Controls.Add(new LiteralControl(String.Format("Update:{0}<br>",status)));
objects = new ArrayList();
foreach(UpdateResult uResult in updateResults)
{
DataExtensionUpdateResult deur = (DataExtensionUpdateResult)uResult;
Page.Controls.Add(new LiteralControl(String.Format("Result[{0}]: {1} ({3}) - {2}<br>",deur.OrdinalID, deur.StatusCode, deur.StatusMessage, deur.ErrorCode)));
if (deur.KeyErrors != null)
{
foreach (DataExtensionError dee in deur.KeyErrors)
{
Page.Controls.Add(new LiteralControl(String.Format("Errors[{0}]: {1}: {2}<br>", dee.Name, dee.ErrorCode, dee.ErrorMessage)));
}
}
if (deur.ValueErrors != null)
{
foreach (DataExtensionError dee in deur.ValueErrors)
{
Page.Controls.Add(new LiteralControl(String.Format("Errors[{0}]: {1}: {2}<br>", dee.Name, dee.ErrorCode, dee.ErrorMessage)));
}
}
}
j