53 lines
1.6 KiB
C#
53 lines
1.6 KiB
C#
using Oracle.DataAccess.Client;
|
|
using Oracle.DataAccess;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.Configuration;
|
|
using System.Data;
|
|
using System.Linq;
|
|
using System.Text;
|
|
|
|
namespace Gestion.DAL
|
|
{
|
|
public class Conexion
|
|
{
|
|
public static OracleConnection conexion
|
|
{
|
|
get
|
|
{
|
|
return new OracleConnection(ConfigurationManager.ConnectionStrings["MTX"].ConnectionString);
|
|
}
|
|
}
|
|
|
|
public DataSet getDataSet(string spName, List<OracleParameter> parameters)
|
|
{
|
|
try
|
|
{
|
|
using (conexion)
|
|
{
|
|
conexion.Open();
|
|
using (Oracle.DataAccess.Client.OracleCommand Command = new Oracle.DataAccess.Client.OracleCommand(spName, conexion))
|
|
{
|
|
if (parameters != null && parameters.Count > 0)
|
|
{
|
|
Command.CommandType = CommandType.StoredProcedure;
|
|
|
|
foreach (var p in parameters)
|
|
{
|
|
Command.Parameters.Add(p);
|
|
}
|
|
}
|
|
OracleDataAdapter da = new OracleDataAdapter(Command);
|
|
DataSet ds = new DataSet();
|
|
da.Fill(ds);
|
|
return ds;
|
|
}
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw new Exception("No hay conexion");
|
|
}
|
|
}
|
|
}
|
|
}
|