public List <directorEN> mostrarListaDirectores(directorEN director)
{
paisCAD pais = new paisCAD();
List <directorEN> lista = new List <directorEN>();
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["bbdd"].ToString());
cn.Open();
string comando = "";
if (director.Nombre == "%")
{
comando = "select * from Director" + " Order by Apellidos, Nombre";
}
else
{
comando = "select distinct * from Director where Nombre like '%" + director.Nombre + "%' or Apellidos like '%" + director.Nombre + "%'" + " Order by Apellidos, Nombre";
}
SqlCommand cmd = new SqlCommand(comando, cn);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
directorEN dir = new directorEN();
dir.IdD = (int)reader["Id_Director"];
dir.Nombre = reader["Nombre"].ToString();
dir.Apellidos = reader["Apellidos"].ToString();
dir.Nacionalidad = pais.mostrarPais((int)reader["Nacionalidad"]).Pais;
lista.Add(dir);
}
reader.Close();
cn.Close();
return(lista);
}
public actorEN mostrarActor(int id)
{
paisCAD pais = new paisCAD();
actorEN act = new actorEN();
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["bbdd"].ToString());
cn.Open();
string comando = "";
comando = "select * from Actores where Id_Actor = " + id + "Order by Apellidos, Nombre";
SqlCommand cmd = new SqlCommand(comando, cn);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
act.IdAc = (int)reader["Id_Actor"];
act.Nombre = reader["Nombre"].ToString();
act.Apellidos = reader["Apellidos"].ToString();
act.FechaNac = reader["Fecha_Nac"].ToString();
act.Pais = pais.mostrarPais((int)reader["Nacionalidad"]).Pais;
}
reader.Close();
cn.Close();
return(act);
}
public List <actorEN> mostrarListaActores(actorEN actor)
{
paisCAD pais = new paisCAD();
List <actorEN> lista = new List <actorEN>();
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["bbdd"].ToString());
cn.Open();
string comando = "";
if (actor.Nombre == "%")
{
comando = "select * from Actores Order by Apellidos, Nombre";
}
else
{
comando = "select distinct * from Actores where Nombre like '%" + actor.Nombre + "%' or Apellidos like '%" + actor.Nombre + "%' Order by Apellidos, Nombre";
}
SqlCommand cmd = new SqlCommand(comando, cn);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
actorEN act = new actorEN();
act.IdAc = (int)reader["Id_Actor"];
act.Nombre = reader["Nombre"].ToString();
act.Apellidos = reader["Apellidos"].ToString();
act.FechaNac = reader["Fecha_Nac"].ToString();
act.Pais = pais.mostrarPais((int)reader["Nacionalidad"]).Pais;
lista.Add(act);
}
reader.Close();
cn.Close();
return(lista);
}
public directorEN mostrarDirector(directorEN director)
{
directorEN dir = new directorEN();
try
{
paisCAD pais = new paisCAD();
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["bbdd"].ToString());
cn.Open();
string comando = "";
if (director.IdD != -1)
{
comando = "select distinct * from Director where Id_Director = " + director.IdD;
}
else
{
comando = "select distinct * from Director where Nombre like '" + director.Nombre + "' and Apellidos like '" + director.Apellidos + "'" + " Order by Apellidos, Nombre";
}
SqlCommand cmd = new SqlCommand(comando, cn);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
dir = new directorEN();
dir.IdD = (int)reader["Id_Director"];
dir.Nombre = reader["Nombre"].ToString();
dir.Apellidos = reader["Apellidos"].ToString();
dir.Nacionalidad = pais.mostrarPais((int)reader["Nacionalidad"]).Pais;
}
reader.Close();
cn.Close();
}
catch (Exception)
{
}
return(dir);
}