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