Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INodeAppService.cs
- namespace MyAppService
- {
- public class Nodes
- {
- [DataMember]
- public int NodeID { get; set; }
- [DataMember]
- public string Item { get; set; }
- }
- [ServiceContract]
- public interface INodeAppService
- {
- [OperationContract]
- [WebGet(ResponseFormat = WebMessageFormat.Json)]
- List<Nodes> GetNodes(); //changed
- }
- }
- NodeAppService.svc.cs
- namespace MyAppService
- {
- [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]
- public class NodeAppService: INodeAppService
- {
- public List<Nodes> GetNodes()
- {
- List<Nodes> nodeList = new List<Nodes>(); //changed
- SqlCommand sqlCommand = new SqlCommand("myquery", conn);
- SqlDataAdapter da = new SqlDataAdapter(sqlCommand);
- DataTable dt = new DataTable();
- try
- {
- da.Fill(dt);
- foreach (DataRow row in dt.Rows)
- {
- Nodes node= new Nodes();
- node.NodeID = Convert.ToInt32(row["NodeID"]);
- node.Item = row["Item"].ToString();
- nodeList.Add(node); //changed
- }
- return nodeList;
- }
- catch (Exception e)
- {
- throw e;
- }
- finally
- {
- conn.Close();
- }
- }
- INodeAppService.cs
- namespace MyAppService
- {
- public class Nodes
- {
- [DataMember]
- public int NodeID { get; set; }
- [DataMember]
- public string Item { get; set; }
- }
- [ServiceContract]
- public interface INodeAppService
- {
- [OperationContract]
- [WebGet(ResponseFormat = WebMessageFormat.Json)]
- IList<Nodes> GetNodes(); // List changed to IList
- }
- }
- NodeAppService.svc.cs
- namespace MyAppService
- {
- [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]
- public class NodeAppService: INodeAppService
- {
- private IList<Nodes> _nodeList;
- public NodeAppService(IList<Nodes> nodeList)
- {
- _nodeList= nodeList;
- }
- public IList<Nodes> GetNodes()
- {
- SqlCommand sqlCommand = new SqlCommand("myquery", conn);
- SqlDataAdapter da = new SqlDataAdapter(sqlCommand);
- DataTable dt = new DataTable();
- try
- {
- da.Fill(dt);
- foreach (DataRow row in dt.Rows)
- {
- Nodes node= new Nodes(); // How can I remove this dependency?
- node.NodeID = Convert.ToInt32(row["NodeID"]);
- node.Item = row["Item"].ToString();
- _nodeList.Add(node);
- }
- return _nodeList;
- }
- catch (Exception e)
- {
- throw e;
- }
- finally
- {
- conn.Close();
- }
- }
- List<Nodes> nodeList = new List<Nodes>();
- SqlCommand sqlCommand = new SqlCommand("myquery", conn);
- SqlDataAdapter da = new SqlDataAdapter(sqlCommand);
- DataTable dt = new DataTable();
- try
- {
- da.Fill(dt);
- foreach (DataRow row in dt.Rows)
- {
- Nodes node= new Nodes(); // How can I remove this dependency?
- node.NodeID = Convert.ToInt32(row["NodeID"]);
- node.Item = row["Item"].ToString();
- _nodeList.Add(node);
- }
- return _nodeList;
- }
- catch (Exception e)
- {
- throw e;
- }
- finally
- {
- conn.Close();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement