public void modificarPelicula(peliculaEN pelicula)
{
try
{
DateTime fecha = DateTime.Parse(pelicula.FechaE);
paisCAD p = new paisCAD();
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["bbdd"].ToString());
cn.Open();
string comando = "";
SqlCommand cmd;
comando = "update Peliculas set Id_Pelicula = " + pelicula.IdP + ", Nombre = '";
comando += pelicula.NombreP + "', Duracion = " + pelicula.Duracion + ", Fecha_Estreno = '";
comando += fecha + "', Sinopsis = '";
comando += pelicula.Sinopsis + "', Precio_C = " + pelicula.PrecioC + ", Precio_A = " + pelicula.PrecioA + ", Id_Distribuidora = " + pelicula.IdDist + ", Id_Director = ";
comando += pelicula.IdDir + ", Imagen = '../images/peliculas_img/" + pelicula.Imagen + "', Id_Saga = ";
if (pelicula.IdSaga == -1)
{
comando += "null" + ", Trailer = '" + pelicula.Trailer + "'where Id_Pelicula = " + pelicula.IdP;
}
else
{
comando += pelicula.IdSaga + ", Trailer = '" + pelicula.Trailer + "' where Id_Pelicula = " + pelicula.IdP;
}
cmd = new SqlCommand(comando, cn);
cmd.ExecuteNonQuery();
cn.Close();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
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 void anyadirActor(actorEN actor)
{
DateTime fecha = DateTime.Parse(actor.FechaNac);
try
{
paisCAD p = new paisCAD();
int nextId = 1;
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["bbdd"].ToString());
cn.Open();
string comando = "";
SqlCommand cmd;
comando = "insert into Actores values (" + nextId + ", '";
comando += actor.Nombre + "', '" + actor.Apellidos + "', '";
comando += fecha + "', ";
comando += p.mostrarIdPais(actor.Pais).IdPais + ")";
cmd = new SqlCommand(comando, cn);
cmd.ExecuteNonQuery();
cn.Close();
}
catch (Exception)
{
try
{
paisCAD p = new paisCAD();
int nextId = 1;
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["bbdd"].ToString());
cn.Open();
string comando = "select max(Id_Actor) max from Actores";
SqlCommand cmd = new SqlCommand(comando, cn);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
nextId = (int)reader["max"] + 1;
}
reader.Close();
comando = "insert into Actores values (" + nextId + ", '";
comando += actor.Nombre + "', '" + actor.Apellidos + "', '";
comando += fecha + "', ";
comando += p.mostrarIdPais(actor.Pais).IdPais + ")";
cmd = new SqlCommand(comando, cn);
cmd.ExecuteNonQuery();
cn.Close();
}catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
public void anyadirDirector(directorEN director)
{
try
{
paisCAD p = new paisCAD();
int nextId = 1;
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["bbdd"].ToString());
cn.Open();
string comando = "";
SqlCommand cmd;
comando = "insert into Director values (" + nextId + ", '";
comando += director.Nombre + "', '" + director.Apellidos + "', ";
comando += p.mostrarIdPais(director.Nacionalidad).IdPais + ")";
cmd = new SqlCommand(comando, cn);
cmd.ExecuteNonQuery();
cn.Close();
}
catch (Exception)
{
try
{
paisCAD p = new paisCAD();
int nextId = 1;
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["bbdd"].ToString());
cn.Open();
string comando = "select max(Id_Director) max from Director";
SqlCommand cmd = new SqlCommand(comando, cn);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
nextId = (int)reader["max"] + 1;
}
reader.Close();
comando = "insert into Director values (" + nextId + ", '";
comando += director.Nombre + "', '" + director.Apellidos + "', ";
comando += p.mostrarIdPais(director.Nacionalidad).IdPais + ")";
cmd = new SqlCommand(comando, cn);
cmd.ExecuteNonQuery();
cn.Close();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
public void modificarDirector(directorEN director)
{
try
{
paisCAD p = new paisCAD();
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["bbdd"].ToString());
cn.Open();
string comando = "update Director set Nombre = '" + director.Nombre + "', ";
comando += "Apellidos = '" + director.Apellidos + "', ";
comando += "Nacionalidad= " + p.mostrarIdPais(director.Nacionalidad).IdPais + " where Id_Director = " + director.IdD;
SqlCommand cmd = new SqlCommand(comando, cn);
cmd = new SqlCommand(comando, cn);
cmd.ExecuteNonQuery();
cn.Close();
}catch (Exception ex) {
throw new Exception(ex.Message);
}
}
public void modificarActor(actorEN actor)
{
paisCAD p = new paisCAD();
DateTime fecha = DateTime.Parse(actor.FechaNac);
try
{
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["bbdd"].ToString());
cn.Open();
string comando = "update Actores set Nombre = '" + actor.Nombre + "', ";
comando += "Apellidos = '" + actor.Apellidos + "', Fecha_Nac = '" + fecha + "', ";
comando += "Nacionalidad= " + p.mostrarIdPais(actor.Pais).IdPais + " where Id_Actor = " + actor.IdAc;
SqlCommand cmd = new SqlCommand(comando, cn);
cmd = new SqlCommand(comando, cn);
cmd.ExecuteNonQuery();
cn.Close();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
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);
}
public void anyadirPelicula(peliculaEN pelicula)
{
try
{
DateTime fecha = DateTime.Parse(pelicula.FechaE);
paisCAD p = new paisCAD();
int nextId = 1;
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["bbdd"].ToString());
cn.Open();
string comando = "";
SqlCommand cmd;
comando = "insert into Peliculas values (" + nextId + ", '";
comando += pelicula.NombreP + "', " + pelicula.Duracion + ", '";
comando += fecha + "', '";
comando += pelicula.Sinopsis + "', " + pelicula.PrecioC + ", " + pelicula.PrecioA + ", " + pelicula.IdDist + ", ";
comando += pelicula.IdDir + ", '../images/peliculas_img/" + pelicula.Imagen + "', ";
if (pelicula.IdSaga == -1)
{
comando += "null" + ", '" + pelicula.Trailer + "')";
}
else
{
comando += pelicula.IdSaga + ", '" + pelicula.Trailer + "')";
}
cmd = new SqlCommand(comando, cn);
cmd.ExecuteNonQuery();
cn.Close();
}
catch (Exception)
{
try
{
DateTime fecha = DateTime.Parse(pelicula.FechaE);
paisCAD p = new paisCAD();
int nextId = 1;
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["bbdd"].ToString());
cn.Open();
string comando = "select max(Id_Pelicula) max from Peliculas";
SqlCommand cmd = new SqlCommand(comando, cn);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
nextId = (int)reader["max"] + 1;
}
reader.Close();
comando = "insert into Peliculas values (" + nextId + ", '";
comando += pelicula.NombreP + "', " + pelicula.Duracion + ", '";
comando += fecha + "', '";
comando += pelicula.Sinopsis + "', '" + pelicula.PrecioC.ToString() + "', '" + pelicula.PrecioA.ToString() + "', " + pelicula.IdDist + ", ";
comando += pelicula.IdDir + ", '../images/peliculas_img/" + pelicula.Imagen + "', ";
if (pelicula.IdSaga == -1)
{
comando += "null" + ", '" + pelicula.Trailer + "')";
}
else
{
comando += pelicula.IdSaga + ", '" + pelicula.Trailer + "')";
}
cmd = new SqlCommand(comando, cn);
cmd.ExecuteNonQuery();
cn.Close();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
