protected void Btn_Añadir_Click(object sender, EventArgs e) { Err.Visible = false; Err0.Visible = false; ErrInsert.Visible = false; if (TextBox1.Text == "" && TextBox2.Text == "") { Err.Text = "*Campo vacío"; Err.ForeColor = Color.Red; Err.Visible = true; } else if (TextBox1.Text != "" && TextBox2.Text == "") { Err0.Text = "*Campo vacío"; Err0.ForeColor = Color.Red; Err0.Visible = true; } else if (TextBox1.Text == "" && TextBox2.Text != "") { Err.Text = "*Campo vacío"; Err.ForeColor = Color.Red; Err.Visible = true; Err0.Text = "*Campo vacío"; Err0.ForeColor = Color.Red; Err0.Visible = true; } else { try { sagaEN saga = new sagaEN(-1, TextBox1.Text, TextBox2.Text); saga.anyadirSaga(); ErrInsert.Text = "AÑADIDA CORRECTAMENTE"; ErrInsert.ForeColor = Color.Green; ErrInsert.Visible = true; } catch (Exception ex) { ErrInsert.Text = ex.Message; ErrInsert.ForeColor = Color.Red; ErrInsert.Visible = true; } } }
public void anyadirSaga(sagaEN saga) { try { int nextId = 1; SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["bbdd"].ToString()); cn.Open(); string comando = ""; SqlCommand cmd; comando = "insert into Saga values (" + nextId + ", '"; comando += saga.Descripcion + "', '" + saga.Nombre + "')"; cmd = new SqlCommand(comando, cn); cmd.ExecuteNonQuery(); cn.Close(); } catch (Exception) { try { int nextId = 1; SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["bbdd"].ToString()); cn.Open(); string comando = "select max(Id_Saga) max from Saga"; SqlCommand cmd = new SqlCommand(comando, cn); var reader = cmd.ExecuteReader(); while (reader.Read()) { nextId = (int)reader["max"] + 1; } reader.Close(); comando = "insert into Saga values (" + nextId + ", '"; comando += saga.Descripcion + "', '" + saga.Nombre + "')"; cmd = new SqlCommand(comando, cn); cmd.ExecuteNonQuery(); cn.Close(); } catch (Exception ex) { throw new Exception(ex.Message); } } }
protected void imagePelicula1_Init(object sender, EventArgs e) { try { int id; int.TryParse(Request.QueryString["id"], out id); //Recuperamos Id de la pelicula pelicula = new peliculaEN(id, ""); //Cargamos id de la pelicula pelicula = pelicula.mostrarPelicula(); //Cargamos datos de la pelicula directorEN d = new directorEN(pelicula.IdDir); distribuidoraEN dis = new distribuidoraEN(pelicula.IdDist, ""); Titulo.Text = pelicula.NombreP; Texto_Sinopsis.Text = pelicula.Sinopsis; Imagen.ImageUrl = pelicula.Imagen; float precio = pelicula.PrecioA / 100;//Conversion a euros precioAnumtext.Text = precio.ToString() + "€"; fechaEstrenotext.Text = pelicula.FechaE.Substring(0, 10); precio = pelicula.PrecioC / 100; precioCnumtext.Text = precio.ToString() + "€"; TrailerLink.NavigateUrl = pelicula.Trailer; duracionNumtext.Text = pelicula.Duracion.ToString() + " min"; mostrarDirText.Text = d.mostrarDirector().Nombre + " " + d.mostrarDirector().Apellidos; mostrarDirText.NavigateUrl = "Mostrar_Director.aspx?id=" + pelicula.IdDir; mostrarDistText.Text = dis.mostrarDistribuidora().Nombre; mostrarDistText.NavigateUrl = "Mostrar_Distribuidora.aspx?id=" + pelicula.IdDist; if (pelicula.IdSaga != -1) { sagaEN s = new sagaEN(pelicula.IdSaga, "", ""); mostrarSaga.Visible = true; SagaText.Visible = true; mostrarSaga.Text = s.mostrarSaga().Nombre; } Response.Charset = "utf-8"; usuarioEN user = (usuarioEN)Session["user_session_data"];//Cargamos el usuario si hay sesion iniciada if (user != null) { adquirirText.Visible = true; adquirirText.NavigateUrl = "../Transaccion.aspx?id=" + pelicula.IdP; } }catch (Exception ex) { Response.Redirect("../Pagina_Error.aspx?err=" + ex.Message); } }
public sagaEN mostrarSaga(int id) { sagaEN saga = new sagaEN(); string comando = "Select * from Saga where Id_Saga =" + id; SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["bbdd"].ToString()); cn.Open(); SqlCommand cmd = new SqlCommand(comando, cn); var reader = cmd.ExecuteReader(); while (reader.Read()) { saga.IDsaga = (int)reader["Id_Saga"]; saga.Descripcion = reader["Descripcion"].ToString(); saga.Nombre = reader["Nombre"].ToString(); } reader.Close(); cn.Close(); return(saga); }
public List <sagaEN> listaSagas() { List <sagaEN> dev = new List <sagaEN>(); sagaEN saga; string comando = "Select * from Saga order by Nombre"; SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["bbdd"].ToString()); cn.Open(); SqlCommand cmd = new SqlCommand(comando, cn); var reader = cmd.ExecuteReader(); while (reader.Read()) { saga = new sagaEN(); saga.IDsaga = (int)reader["Id_Saga"]; saga.Descripcion = reader["Descripcion"].ToString(); saga.Nombre = reader["Nombre"].ToString(); dev.Add(saga); } reader.Close(); cn.Close(); return(dev); }
public bool existe(sagaEN saga) { return(false); }
public void modificarSaga(sagaEN saga) { }
protected void DWdia_Init(object sender, EventArgs e) { int i; List <int> nums = new List <int>(); if (DWdir != null) { directorEN dir = new directorEN(); List <directorEN> dirlist = dir.listaDirectores(); listaIdDir.Clear(); nombres.Clear(); for (i = 0; i < dirlist.Count; i++) { nombres.Add(dirlist[i].Nombre + " " + dirlist[i].Apellidos); listaIdDir.Add(dirlist[i].IdD); } DWdir.DataSource = nombres; DWdir.DataBind(); DWdir.Items.Insert(0, new ListItem("[Seleccionar]", "0")); } if (DWdist != null) { distribuidoraEN dist = new distribuidoraEN(); nombres.Clear(); listaIdDist.Clear(); List <distribuidoraEN> dlist = dist.listaDistribuidoras(); for (i = 0; i < dlist.Count; i++) { nombres.Add(dlist[i].Nombre); listaIdDist.Add(dlist[i].IdDis); } DWdist.DataSource = nombres; DWdist.DataBind(); DWdist.Items.Insert(0, new ListItem("[Seleccionar]", "0")); } if (DWsaga != null) { sagaEN s = new sagaEN(); nombres.Clear(); listaIdSag.Clear(); List <sagaEN> slist = s.listaSagas(); listaIdSag.Add(-1); for (i = 0; i < slist.Count; i++) { nombres.Add(slist[i].Nombre); listaIdSag.Add(slist[i].IDsaga); } DWsaga.DataSource = nombres; DWsaga.DataBind(); DWsaga.Items.Insert(0, new ListItem("NINGUNA", "0")); } if (DWdia != null) { nums.Clear(); for (i = 1; i < 32; i++) { nums.Add(i); } DWdia.DataSource = nums; DWdia.DataBind(); } if (DWmes != null) { nums.Clear(); for (i = 1; i < 13; i++) { nums.Add(i); } DWmes.DataSource = nums; DWmes.DataBind(); } if (DWaño != null) { nums.Clear(); for (i = 1900; i < 2019; i++) { nums.Add(i); } DWaño.DataSource = nums; DWaño.DataBind(); } }