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