protected void DWPeliculas_Init(object sender, EventArgs e) { try { int id; int.TryParse(Request.QueryString["id"], out id); //Recuperamos id del actor actor = new actorEN(id, ""); //Cargamos id del actor en el EN actor = actor.mostrarActor(); //Cargamos los datos del actor NombreText.Text = actor.Nombre; ApellidosText.Text = actor.Apellidos; fechaNac.Text = actor.FechaNac.Substring(0, 10); paisEN p = new paisEN(actor.Pais); nombrePais.Text = p.mostrarIdPais().Pais; List <peliculaEN> peliculas = actor.mostrarPeliculasActor(); List <string> nombres = new List <string>(); for (int i = 0; i < peliculas.Count; i++)//Guardamos nombres en la lista desplegable { nombres.Add(peliculas[i].NombreP); listaID.Add(peliculas[i].IdP);//Asociamos id a cada nombre de la lista } DWPeliculas.DataSource = nombres; DWPeliculas.DataBind(); DWPeliculas.Items.Insert(0, new ListItem("[Seleccionar]", "0")); }catch (Exception ex) { Response.Redirect("../Pagina_Error.aspx?err=" + ex.Message); } }
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); }
protected void Btn_Modificar_Click(object sender, EventArgs e) { if (DWActor.Items.Count == 1) { Btn_Modificar1.Visible = false; ErrM.ForeColor = Color.Red; ErrM.Visible = true; ErrM.Text = "No quedan actores"; } else { if (DWActor.SelectedItem.ToString() != "[Seleccionar]" && DWPais.SelectedItem.ToString() != "[Seleccionar]") { if (TextBox1.Text != "" && TextBox2.Text != "") { try { string fecha = DWdia.SelectedItem.ToString() + "-" + DWmes.SelectedItem.ToString() + "-" + DWaño.SelectedItem.ToString(); actor = new actorEN(-1, TextBox1.Text, TextBox2.Text, fecha, DWPais.SelectedItem.ToString()); bool stop = false; for (int i = 0; i < listaA.Count && !stop; i++) { if (listaA[i].Nombre + " " + listaA[i].Apellidos == DWActor.SelectedItem.ToString()) { actor.IdAc = listaA[i].IdAc; stop = true; } } actor.modificarActor(); ErrM.ForeColor = Color.Green; ErrM.Visible = true; ErrM.Text = "MODIFICADO CORRECTAMENTE"; DWActor_Init(sender, e); } catch (Exception ex) { ErrM.ForeColor = Color.Red; ErrM.Visible = true; ErrM.Text = ex.Message; } } else { ErrM.ForeColor = Color.Red; ErrM.Visible = true; ErrM.Text = "*Quedan campos vacíos"; } } } }
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); } } }
protected void Button_Actor(object sender, EventArgs e) { if (ActorBox.Text != "") { listaID.Clear(); actorEN actor = new actorEN(-1, ActorBox.Text); List <string> ListaNombres = new List <string>(); DWActor.Visible = true; Btn_Actor2.Visible = true; List <actorEN> d = actor.listaActores(); for (int i = 0; i < d.Count; i++) { ListaNombres.Add(d[i].Nombre + " " + d[i].Apellidos); listaID.Add(d[i].IdAc); } DWActor.DataSource = ListaNombres; DWActor.DataBind(); DWActor.Items.Insert(0, new ListItem("[Seleccionar]", "0")); if (DWActor.Items.Count == 1) { ErrActor.Visible = true; ErrActor.Text = "*Búsqueda vacía. Introduzca el carácter '%' para ver todos los actores"; DWActor.Visible = false; Btn_Actor2.Visible = false; } else { ErrActor.Visible = false; } } else { ErrActor.Visible = true; ErrActor.Text = "*Campo vacío"; } ErrSerie.Visible = false; ErrPelicula.Visible = false; ErrDistribuidora.Visible = false; ErrDirector.Visible = false; DWDistribuidora.Visible = false; DWPeliculas.Visible = false; DWSeries.Visible = false; DWDirector.Visible = false; Btn_Distribuidora2.Visible = false; Btn_Pelicula2.Visible = false; Btn_Serie2.Visible = false; Btn_Director2.Visible = false; }
protected void Btn_Añadir_Click(object sender, EventArgs e) { if (TextBox1.Text != "" && TextBox2.Text != "") { if (DWPais.SelectedItem.ToString() != "[Seleccionar]") { try { string fecha = DWdia.SelectedItem.ToString() + "-" + DWmes.SelectedItem.ToString() + "-" + DWaño.SelectedItem.ToString(); actorEN actor = new actorEN(-1, TextBox1.Text, TextBox2.Text, fecha, DWPais.SelectedItem.ToString()); actor.anyadirActor(); Err1.Text = "AÑADIDO CORRECTAMENTE"; Err1.Visible = true; Err1.ForeColor = Color.Green; } catch (Exception ex) { Err1.ForeColor = Color.Red; Err1.Text = ex.Message; Err1.Visible = true; } } } else if (TextBox1.Text == "" && TextBox2.Text != "") { Err.Visible = true; Err.ForeColor = Color.Red; Err.Text = "*Campo vacío"; } else if (TextBox1.Text != "" && TextBox2.Text == "") { Err0.Visible = true; Err0.ForeColor = Color.Red; Err0.Text = "*Campo vacío"; } else { Err.Visible = true; Err.ForeColor = Color.Red; Err.Text = "*Campo vacío"; Err0.Visible = true; Err0.ForeColor = Color.Red; Err0.Text = "*Campo vacío"; } }
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 bool existe(actorEN actor) { return(false); }