Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using Oracle.ManagedDataAccess.Client;
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Net;
- using System.Net.Http;
- using System.Web.Http;
- using System.Data;
- using Newtonsoft.Json;
- namespace TestAPI.Controllers
- {
- public class TestOraConnController : ApiController
- {
- public string Get(int id)
- {
- 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;
- OracleConnection dbConn = new OracleConnection("DATA SOURCE=ABC;PASSWORD=ABCD;PERSIST SECURITY INFO=True;USER ID=ABC");
- dbConn.Open();
- OracleCommand selectCommand = new OracleCommand(strQuery, dbConn);
- OracleDataAdapter adapter = new OracleDataAdapter(selectCommand);
- DataTable selectResults = new DataTable();
- adapter.Fill(selectResults);
- dbConn.Close();
- return JsonConvert.SerializeObject(selectResults);
- }
- }
- }
- "[{"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"}]"
- public string get( int []d)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement