How to return data from a SmartObject

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
public void ReturnSmartObjectDataUsingID() {

 // in this sample we define a string representing the ID of the SmartObject to use later
 string _id = "1";

 // TODO: Use the SCConnectionStringBuilder Class to construct a connection string
 string _connectionstring = "[K2environmentConnectionString]";

 // open a K2 Server connection
 SourceCode.SmartObjects.Client.SmartObjectClientServer serverName = new SmartObjectClientServer();
 serverName.CreateConnection();
 serverName.Connection.Open(_connectionstring.ToString());

 try {
  // get an object representing the SmartObject definition so we can set properties or interrogate the SmartObject definition
  SmartObject smartObject = serverName.GetSmartObject("Employee");

  // specify which method will be called. Here we're calling the load method.
  smartObject.MethodToExecute = "Load";

  // Here we set the value of the input parameter for the method. We're using the SmartObjects ID property and setting it to our defined string, _id.
  smartObject.Properties["ID"].Value = _id;

  /* use the ExecuteScalar method to use an execute type SmartObject method, Load in this case.
Set the input properties as shown above, and then use the ExecuteScalar() method to perform the SmartObject method. */
  serverName.ExecuteScalar(smartObject);

  // read the return properties of the SmartObject and write them to the console for example
  Console.WriteLine("First Name: " + smartObject.Properties["FirstName"].Value);
  Console.WriteLine("Last Name: " + smartObject.Properties["LastName"].Value);
  Console.WriteLine("Email: " + smartObject.Properties["Email"].Value);
  Console.ReadLine();
 } catch (Exception ex) {
  // write error to console
  Console.WriteLine("Error: " + ex.Message);
  Console.ReadLine();
 } finally {
  // finally, close the connection
  serverName.Connection.Close();
 }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
public void ReturnAllSmartObjectData() {
 // TODO: Use the SCConnectionStringBuilder Class to construct a connection string
 string _connectionstring = "[K2environmentConnectionString]";

 // open a K2 Server connection
 SourceCode.SmartObjects.Client.SmartObjectClientServer serverName = new SmartObjectClientServer();
 serverName.CreateConnection();
 serverName.Connection.Open(_connectionstring.ToString());

 try {
  // get an object representing the SmartObject definition so we can set properties or interrogate the SmartObject definition
  SmartObject smo = serverName.GetSmartObject("Employee");

  // specify which method will be called. Here we're calling the GetList method
  smo.MethodToExecute = "GetList";

  // execute the method and iterate over the resulting records reading the return properties of the SmartObject
  SmartObjectList smoList = serverName.ExecuteList(smo);
  foreach(SmartObject resultingSmO in smoList.SmartObjectsList) {
   Console.WriteLine("First Name: " + resultingSmO.Properties["FirstName"].Value);
   Console.WriteLine("Last Name: " + resultingSmO.Properties["LastName"].Value);
   Console.WriteLine("Email: " + resultingSmO.Properties["Email"].Value);
  }

  Console.ReadLine();
 } catch (Exception ex) {
  // write error to console
  Console.WriteLine("Error: " + ex.Message);
  Console.ReadLine();
 } finally {
  // close the connection
  serverName.Connection.Close();
 }
}