Advertisement
Guest User

Untitled

a guest
Jul 20th, 2016
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.53 KB | None | 0 0
  1. using Oracle.ManagedDataAccess.Client;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.Linq;
  5. using System.Net;
  6. using System.Net.Http;
  7. using System.Web.Http;
  8. using System.Data;
  9. using Newtonsoft.Json;
  10.  
  11. namespace TestAPI.Controllers
  12. {
  13. public class TestOraConnController : ApiController
  14. {
  15. public string Get(int id)
  16. {
  17. var strQuery = @"Select PRIO_CATEGORY_ID as PRIO,LANG_ID as LANG, REC_DATE as REC, REC_USER as RECUSER, RFCH_ID as RFCH,DESCR,COL_DESCR AS COL,ROW_DESCR as DROW,ABBR from STCD_PRIO_CATEGORY_DESCR where REC_USER =" +id;
  18. OracleConnection dbConn = new OracleConnection("DATA SOURCE=ABC;PASSWORD=ABCD;PERSIST SECURITY INFO=True;USER ID=ABC");
  19. dbConn.Open();
  20. OracleCommand selectCommand = new OracleCommand(strQuery, dbConn);
  21. OracleDataAdapter adapter = new OracleDataAdapter(selectCommand);
  22. DataTable selectResults = new DataTable();
  23. adapter.Fill(selectResults);
  24. dbConn.Close();
  25. return JsonConvert.SerializeObject(selectResults);
  26.  
  27. }
  28. }
  29. }
  30.  
  31. "[{"PRIO":1,"LANG":1,"REC":"2011-10-23T20:32:18","RECUSER":1,"RFCH":null,"DESCR":"Internal Study","COL":"Internal Study","DROW":"Internal Study","ABBR":"Intern"},{"PRIO":1,"LANG":2,"REC":"2011-10-23T20:32:18","RECUSER":1,"RFCH":null,"DESCR":"Internal Study","COL":"Internal Study","DROW":"Internal Study","ABBR":"Intern"},{"PRIO":2,"LANG":1,"REC":"2011-10-23T20:32:31","RECUSER":1,"RFCH":null,"DESCR":"Client Study","COL":"Client Study","DROW":"Client Study","ABBR":"Client"}]"
  32.  
  33. public string get( int []d)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement