1foreach (int issueId in bugs.Keys)
2 {
3 DataExtensionObject row = new DataExtensionObject();
4 row.CustomerKey = "cr";
5 row.Properties = new APIProperty[10];
6 row.Properties[0] = new APIProperty();
7 row.Properties[0].Name = "ID";
8 row.Properties[0].Value = bugs[issueId].ID.ToString();
9 row.Properties[1] = new APIProperty();
10 row.Properties[1].Name = "Project";
11 row.Properties[1].Value = Request.QueryString["BG_USER_01"].Replace("'", "");
12 row.Properties[2] = new APIProperty();
13 row.Properties[2].Name = "Summary";
14 row.Properties[2].Value = bugs[issueId].Summary;
15 row.Properties[3] = new APIProperty();
16 row.Properties[3].Name = "Priority";
17 row.Properties[3].Value = bugs[issueId].Priority;
18 row.Properties[4] = new APIProperty();
19 row.Properties[4].Name = "Status";
20 row.Properties[4].Value = bugs[issueId].Status;
21 row.Properties[5] = new APIProperty();
22 row.Properties[5].Name = "AssignedTo";
23 row.Properties[5].Value = bugs[issueId].AssignedTo;
24 row.Properties[6] = new APIProperty();
25 row.Properties[6].Name = "DetectedBy";
26 row.Properties[6].Value = bugs[issueId].DetectedBy;
27 // Comments
28 if (bugs[issueId].Comments != null)
29 {
30 row.Properties[7] = new APIProperty();
31 row.Properties[7].Name = "Comments";
32 row.Properties[7].Value = bugs[issueId].Comments;
33 }
34 else
35 {
36 row.Properties[7] = new NullAPIProperty();
37 row.Properties[7].Name = "Comments";
38 }
39 // Description
40 if (bugs[issueId].Description != null)
41 {
42 row.Properties[8] = new APIProperty();
43 row.Properties[8].Name = "Description";
44 row.Properties[8].Value = bugs[issueId].Description;
45 }
46 else
47 {
48 row.Properties[8] = new NullAPIProperty();
49 row.Properties[8].Name = "Description";
50 }
51 // SalesforceID
52 if (bugs[issueId].SalesforceID != null)
53 {
54 row.Properties[9] = new APIProperty();
55 row.Properties[9].Name = "SalesforceID";
56 row.Properties[9].Value = bugs[issueId].SalesforceID.ToString();
57 }
58 else
59 {
60 row.Properties[9] = new NullAPIProperty();
61 row.Properties[9].Name = "SalesforceID";
62 }
63
64 objects.Add(row);
65
66 }
67
68 APIObject[] apiObjects = new APIObject[objects.Count];
69 for(int i = 0; i<objects.Count; i++)
70 {
71 apiObjects[i] = (APIObject)objects[i];
72 }
73
74 UpdateOptions uo = new UpdateOptions();
75 uo.SaveOptions = new SaveOption[1];
76 uo.SaveOptions[0] = new SaveOption();
77 uo.SaveOptions[0].PropertyName = "DataExtensionObject";
78 uo.SaveOptions[0].SaveAction = SaveAction.UpdateAdd;
79
80 UpdateResult[] updateResults = et.Update(uo, apiObjects, out requestID, out status);
81 Page.Controls.Add(new LiteralControl(String.Format("Update:{0}<br>",status)));
82
83 objects = new ArrayList();
84 foreach(UpdateResult uResult in updateResults)
85 {
86 DataExtensionUpdateResult deur = (DataExtensionUpdateResult)uResult;
87 Page.Controls.Add(new LiteralControl(String.Format("Result[{0}]: {1} ({3}) - {2}<br>",deur.OrdinalID, deur.StatusCode, deur.StatusMessage, deur.ErrorCode)));
88 if (deur.KeyErrors != null)
89 {
90 foreach (DataExtensionError dee in deur.KeyErrors)
91 {
92 Page.Controls.Add(new LiteralControl(String.Format("Errors[{0}]: {1}: {2}<br>", dee.Name, dee.ErrorCode, dee.ErrorMessage)));
93 }
94 }
95 if (deur.ValueErrors != null)
96 {
97 foreach (DataExtensionError dee in deur.ValueErrors)
98 {
99 Page.Controls.Add(new LiteralControl(String.Format("Errors[{0}]: {1}: {2}<br>", dee.Name, dee.ErrorCode, dee.ErrorMessage)));
100 }
101 }
102 }
j