public ActionResult Delete(int id)
{
try
{
int id_usuario, id_PF = 0;
id_usuario = Convert.ToInt32(Session["id_usuario"]);
using (BD_NETLINKEntities1 bd = new BD_NETLINKEntities1())
{
var lista = from prg2 in bd.PeliculasPorVer
where prg2.Id_multimedia == id &&
prg2.Id_usuario == id_usuario
select prg2;
if (lista.Count() > 0)
{
PeliculasPorVer obj = lista.First();
id_PF = Convert.ToInt32(obj.Id_peliculaPorVer);
}
}
using (var data = new BD_NETLINKEntities1())
{
var oMovie = data.PeliculasPorVer.Find(id_PF);
data.PeliculasPorVer.Remove(oMovie);
data.SaveChanges();
}
return(Content("1"));
}
catch
{
return(Content("0"));
}
}
public int Compare(int id_multimedia)
{
try
{
using (BD_NETLINKEntities1 bd = new BD_NETLINKEntities1())
{
var lista = from prg2 in bd.PeliculasPorVer
where prg2.Id_multimedia == id_multimedia &&
prg2.Id_usuario == Convert.ToInt32(Session["id_usuario"])
select prg2;
if (lista.Count() > 0)
{
PeliculasPorVer obj = lista.First();
return(Convert.ToInt32(obj.Id_multimedia));
}
else
{
return(0);
}
}
}
catch (Exception x)
{
return(0);
}
}
public ActionResult ShowMovieInsert(int?idPelicula)
{
try
{
int id_usuario = 000;
id_usuario = Convert.ToInt32(Session["id_usuario"]);
using (BD_NETLINKEntities1 bd = new BD_NETLINKEntities1())
{
var lista = from prg2 in bd.PeliculasPorVer
where prg2.Id_usuario == id_usuario &&
prg2.Id_multimedia == idPelicula
select prg2;
if (lista.Count() > 0)
{
return(Content("1"));
}
}
using (var data = new BD_NETLINKEntities1())
{
PeliculasPorVer objSM = new PeliculasPorVer();
objSM.Id_multimedia = idPelicula;
objSM.Id_usuario = Convert.ToInt32(Session["id_usuario"]);
data.PeliculasPorVer.Add(objSM);
data.SaveChanges();
return(Content("True"));
}
}
catch (Exception x)
{
return(Content("Se genero un error! " + x.Message));
}
}