private MapeoParametrosTableroQuery GetObjectMapeo(SqlDataReader dr) { MapeoParametrosTableroQuery mt = new MapeoParametrosTableroQuery(); mt.idTableroParametro = SqlConvert.Convert <Int32>(dr["idTableroParametro"]); mt.idParametro = SqlConvert.Convert <Int32>(dr["idParametro"]); return(mt); }
public List <MapeoParametrosTableroQuery> ObtenerMapeoDeParametros(Int32 idTablero) { List <MapeoParametrosTableroQuery> lstMapeo = new List <MapeoParametrosTableroQuery>(); string comando = "ObtenerMapeoDeParametros"; SqlConnection oCnn = Conexion.ObtenerConnexionSQL(); SqlCommand cmd = new SqlCommand(comando, oCnn); cmd.Parameters.AddWithValue("@idTablero", idTablero); cmd.CommandType = System.Data.CommandType.StoredProcedure; try { oCnn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { MapeoParametrosTableroQuery map = GetObjectMapeo(dr); lstMapeo.Add(map); } } } catch (Exception err) { throw err; } finally { if (oCnn.State != ConnectionState.Closed) { oCnn.Close(); } oCnn.Dispose(); cmd.Dispose(); } return(lstMapeo); }