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; } }