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