public System.Collections.Generic.IList <RetappGenNHibernate.EN.Retapp.RetoEN> ReadRetos(int concurso)
{
/*PROTECTED REGION ID(RetappGenNHibernate.CEN.Retapp_Concurso_ReadRetos) ENABLED START*/
// Write here your custom code...
NHibernate.Cfg.Configuration cfg = new NHibernate.Cfg.Configuration().Configure();
string ConnectionString = cfg.GetProperty(NHibernate.Cfg.Environment.ConnectionString);
List <RetoEN> lista = new List <RetoEN>();
try
{
SqlConnection c = new SqlConnection(ConnectionString);
c.Open();
SqlCommand com = new SqlCommand("Select id from Reto where FK_idConcurso_idConcurso = " + concurso + " ; ", c);
SqlDataReader dr = com.ExecuteReader();
RetoCEN retcen = new RetoCEN();
while (dr.Read())
{
RetoEN ret = retcen.ReadOID(dr.GetInt32(0));
lista.Add(ret);
}
dr.Close();
c.Close();
}
catch (Exception ex)
{
Console.WriteLine("Se ha producido una excepcion al leer los retos de un concurso: " + ex);
}
return(lista);
/*PROTECTED REGION END*/
}
public System.Collections.Generic.IList <RetappGenNHibernate.EN.Retapp.RetoEN> ReadRetos(int concurso)
{
/*PROTECTED REGION ID(RetappGenNHibernate.CEN.Retapp_Concurso_ReadRetos) ENABLED START*/
// Write here your custom code...
string ConnectionString = "Data Source=ARA65;Initial Catalog=RetappGenNHibernate;Persist Security Info=True;User ID=nhibernateUser;Password=nhibernatePass";
List <RetoEN> lista = new List <RetoEN>();
try
{
SqlConnection c = new SqlConnection(ConnectionString);
c.Open();
SqlCommand com = new SqlCommand("Select idConcurso from Reto where FK_idConcurso_idConcurso = " + concurso + " ; ", c);
SqlDataReader dr = com.ExecuteReader();
RetoCEN retcen = new RetoCEN();
while (dr.Read())
{
RetoEN ret = retcen.ReadOID(dr.GetInt32(0));
lista.Add(ret);
}
dr.Close();
c.Close();
}
catch (Exception ex)
{
Console.WriteLine("Se ha producido una excepcion al leer los retos de un concurso: " + ex);
}
return(lista);
/*PROTECTED REGION END*/
}
