using Oracle.ManagedDataAccess.Client;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
namespace cadre_mgmt_system.DataRepository
{
public class OracleDAL
{
//public static readonly string connectionString = ConfigurationManager.ConnectionStrings["OracleConn"].ConnectionString;
OracleConnection conn;
public OracleDAL()
{
conn = new OracleConnection("user id=readonly;password=readonly;data source=192.168.101.29:1522/PROD");
}
//public DataSet Read(string StoredProcedure, SqlParameter[] param)
//{
// OracleCommand cmd = new OracleCommand(StoredProcedure, conn);
// cmd.CommandType = CommandType.StoredProcedure;
// if (param != null)
// cmd.Parameters.AddRange(param.ToArray());
// OracleDataAdapter da = new OracleDataAdapter(cmd);
// DataSet ds = new DataSet();
// conn.Open();
// da.Fill(ds);
// conn.Close();
// return ds;
//}
public DataSet Read(string Query)
{
//Query = "select * from XXICAR_EMPLOYEE_BANK_DETAILS";
OracleCommand cmd = new OracleCommand(Query, conn);
OracleDataAdapter da = new OracleDataAdapter(cmd);
DataSet ds = new DataSet();
conn.Open();
da.Fill(ds);
conn.Close();
return ds;
}