Advertisement
Guest User

Untitled

a guest
Feb 7th, 2016
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.74 KB | None | 0 0
  1. INodeAppService.cs
  2.  
  3. namespace MyAppService
  4. {
  5.  
  6. public class Nodes
  7. {
  8. [DataMember]
  9. public int NodeID { get; set; }
  10.  
  11. [DataMember]
  12. public string Item { get; set; }
  13. }
  14.  
  15. [ServiceContract]
  16. public interface INodeAppService
  17. {
  18. [OperationContract]
  19. [WebGet(ResponseFormat = WebMessageFormat.Json)]
  20. List<Nodes> GetNodes(); //changed
  21. }
  22. }
  23.  
  24.  
  25. NodeAppService.svc.cs
  26.  
  27. namespace MyAppService
  28. {
  29. [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]
  30. public class NodeAppService: INodeAppService
  31. {
  32.  
  33. public List<Nodes> GetNodes()
  34. {
  35. List<Nodes> nodeList = new List<Nodes>(); //changed
  36. SqlCommand sqlCommand = new SqlCommand("myquery", conn);
  37. SqlDataAdapter da = new SqlDataAdapter(sqlCommand);
  38. DataTable dt = new DataTable();
  39. try
  40. {
  41. da.Fill(dt);
  42. foreach (DataRow row in dt.Rows)
  43. {
  44. Nodes node= new Nodes();
  45. node.NodeID = Convert.ToInt32(row["NodeID"]);
  46. node.Item = row["Item"].ToString();
  47. nodeList.Add(node); //changed
  48.  
  49. }
  50. return nodeList;
  51. }
  52. catch (Exception e)
  53. {
  54. throw e;
  55. }
  56. finally
  57. {
  58. conn.Close();
  59. }
  60. }
  61.  
  62. INodeAppService.cs
  63.  
  64. namespace MyAppService
  65. {
  66.  
  67. public class Nodes
  68. {
  69. [DataMember]
  70. public int NodeID { get; set; }
  71.  
  72. [DataMember]
  73. public string Item { get; set; }
  74. }
  75.  
  76. [ServiceContract]
  77. public interface INodeAppService
  78. {
  79. [OperationContract]
  80. [WebGet(ResponseFormat = WebMessageFormat.Json)]
  81. IList<Nodes> GetNodes(); // List changed to IList
  82. }
  83. }
  84.  
  85.  
  86. NodeAppService.svc.cs
  87.  
  88. namespace MyAppService
  89. {
  90. [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]
  91. public class NodeAppService: INodeAppService
  92. {
  93. private IList<Nodes> _nodeList;
  94. public NodeAppService(IList<Nodes> nodeList)
  95. {
  96. _nodeList= nodeList;
  97. }
  98. public IList<Nodes> GetNodes()
  99. {
  100. SqlCommand sqlCommand = new SqlCommand("myquery", conn);
  101. SqlDataAdapter da = new SqlDataAdapter(sqlCommand);
  102. DataTable dt = new DataTable();
  103. try
  104. {
  105. da.Fill(dt);
  106. foreach (DataRow row in dt.Rows)
  107. {
  108. Nodes node= new Nodes(); // How can I remove this dependency?
  109. node.NodeID = Convert.ToInt32(row["NodeID"]);
  110. node.Item = row["Item"].ToString();
  111. _nodeList.Add(node);
  112.  
  113. }
  114. return _nodeList;
  115. }
  116. catch (Exception e)
  117. {
  118. throw e;
  119. }
  120. finally
  121. {
  122. conn.Close();
  123. }
  124. }
  125.  
  126. List<Nodes> nodeList = new List<Nodes>();
  127.  
  128. SqlCommand sqlCommand = new SqlCommand("myquery", conn);
  129. SqlDataAdapter da = new SqlDataAdapter(sqlCommand);
  130. DataTable dt = new DataTable();
  131. try
  132. {
  133. da.Fill(dt);
  134. foreach (DataRow row in dt.Rows)
  135. {
  136. Nodes node= new Nodes(); // How can I remove this dependency?
  137. node.NodeID = Convert.ToInt32(row["NodeID"]);
  138. node.Item = row["Item"].ToString();
  139. _nodeList.Add(node);
  140.  
  141. }
  142. return _nodeList;
  143. }
  144. catch (Exception e)
  145. {
  146. throw e;
  147. }
  148. finally
  149. {
  150. conn.Close();
  151. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement