public BusinessObject ConsultarProcedimientoObj(string NombreProcedimiento, string nombreConexion, CommandType tipoEjecucion, Persistent parameter, MapperManager <Persistent, BusinessObject> mapper)
{
try
{
DataSet dt = new DataSet();
BusinessObject salida = Activator.CreateInstance <BusinessObject>();
using (SqlConnection unit = new SqlConnection(ConfigurationManager.ConnectionStrings[nombreConexion].ConnectionString))
{
IConsultantReader <DataTable, DataTable> consultor = (IConsultantReader <DataTable, DataTable>)ConsultantFactory.Create <DataTable, DataTable>(EnumConsultantType.Ado);
SqlCommand command = new SqlCommand(NombreProcedimiento, unit);
command.CommandType = tipoEjecucion;
if (parameter != null)
{
SqlHelper helper = new SqlHelper(nombreConexion);
command.Parameters.AddRange(helper.GetListParameters <Persistent>(NombreProcedimiento, parameter));
}
SqlDataAdapter adapter = new SqlDataAdapter(command);
unit.Open();
adapter.Fill(dt);
salida = mapper.MappearReader2BO(dt);
dt.CreateDataReader().Close();
unit.Close();
}
return(salida);
}
catch (Exception)
{
throw;
}
}
public DataSet ConsultarDatos(string NombreProcedimiento, string nombreConexion, CommandType tipoEjecucion, object[] parameter)
{
try
{
DataSet dt = new DataSet();
using (SqlConnection unit = new SqlConnection(ConfigurationManager.ConnectionStrings[nombreConexion].ConnectionString))
{
IConsultantReader <DataTable, DataTable> consultor = (IConsultantReader <DataTable, DataTable>)ConsultantFactory.Create <DataTable, DataTable>();
SqlCommand command = new SqlCommand(NombreProcedimiento, unit);
command.CommandType = tipoEjecucion;
if (parameter != null)
{
SqlHelper helper = new SqlHelper(nombreConexion);
command.Parameters.AddRange(helper.GetListParameters(NombreProcedimiento, parameter));
}
SqlDataAdapter adapter = new SqlDataAdapter(command);
unit.Open();
adapter.Fill(dt);
dt.CreateDataReader().Close();
unit.Close();
}
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
