public List <MovieTableViewModel> Resultado(int?id_multimedia)
{
try
{
List <MovieTableViewModel> lst = null;
using (BD_NETLINKEntities1 bd = new BD_NETLINKEntities1())
{
lst = (from data in bd.multimedia
where data.Id_multimedia == Convert.ToInt32(id_multimedia)
orderby data.Id_multimedia
select new MovieTableViewModel
{
enlace = data.enlace,
descripcion = data.descripcion,
titulo = data.Titulo,
id = data.Id_multimedia
}
).ToList();
}
return(lst);
}
catch (Exception x)
{
return(null);
}
}
public List <MovieTableViewModel> ShowMovieFilter(int?id_multimedia)
{
List <MovieTableViewModel> lst = null;
try
{
using (BD_NETLINKEntities1 bd = new BD_NETLINKEntities1())
{
lst = (from data in bd.multimedia
where
data.Id_multimedia == id_multimedia
orderby data.Id_multimedia
select new MovieTableViewModel
{
enlace = data.enlace,
descripcion = data.descripcion,
titulo = data.Titulo,
id = data.Id_multimedia
}
).ToList();
}
return(lst);
}
catch
{
return(lst);
}
}
public ActionResult Delete(int id)
{
try {
using (var data = new BD_NETLINKEntities1())
{
var oUser = data.usuario.Find(id);
/*data.Entry(oUser).State = System.Data.Entity.EntityState.Modified;
*
* data.(oUser);
* data.SaveChanges();
* data.SaveChanges();
*
* var query = (from p in data.Categoria
* where p.Id_Categoria == id
* select p).Single();*/
data.usuario.Remove(oUser);
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 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 ActionResult Insert(UserTableViewModel model)
{
try
{
if (model.password != model.confPassword)
{
Session["insert"] = "failedPassword";
return(View());
}
using (var data = new BD_NETLINKEntities1())
{
usuario objUser = new usuario();
objUser.id_rol = 2;
objUser.email = model.email;
objUser.password = Encriptar.EncriptarClave(model.password);
objUser.nombre = model.nombre;
objUser.apellido = model.apellido;
objUser.telefono = model.telefono;
objUser.nombreUsuario = model.nombreUsuario;
data.usuario.Add(objUser);
data.SaveChanges();
}
Session["insert"] = "success";
return(View());
}
catch
{
Session["insert"] = "failed";
return(View());
}
}
public ActionResult Update(string titulo, string descripcion, string enlace, int?director, int?gender, int?category, int?country, int?languaje, int?multimediaType, int?id)
{
try
{
using (var data = new BD_NETLINKEntities1())
{
var objMovie = data.multimedia.Find(id);
objMovie.Titulo = titulo;
objMovie.descripcion = descripcion;
objMovie.enlace = enlace;
objMovie.Id_genero = gender;
objMovie.Id_Categoria = category;
objMovie.Id_director = director;
objMovie.Id_idioma = languaje;
objMovie.Id_pais = country;
objMovie.id_tipo_multimedia = multimediaType;
data.Entry(objMovie).State = System.Data.Entity.EntityState.Modified;
data.SaveChanges();
return(Content("True"));
}
}
catch (Exception x)
{
return(Content("Error" + x.Message));
}
}
public ActionResult Validar(string user, string pass)
{
try
{
pass = Encriptar.EncriptarClave(pass);
using (BD_NETLINKEntities1 bd = new BD_NETLINKEntities1())
{
var lista = from prg2 in bd.usuario
where prg2.email == user &&
prg2.password == pass
select prg2;
if (lista.Count() > 0)
{
usuario obj = lista.First();
Session["Usuario"] = obj;
Session["Validate"] = true;
Session["rol"] = obj.id_rol;
Session["usuario"] = obj.nombreUsuario;
Session["id_usuario"] = obj.Id_usuario;
return(Content("1"));
}
else
{
return(Content("Usuario y contraseña invalido"));
}
}
}
catch (Exception x)
{
return(Content("Se genero un error! " + x.Message));
}
}
public ActionResult Update(int id)
{
EditGenderViewModel objModelGen = new EditGenderViewModel();
using (var data = new BD_NETLINKEntities1())
{
var oGen = data.genero.Find(id);
objModelGen.genero = oGen.nombre;
}
return(View(objModelGen));
}
public List <DirectorTableViewModel> Director()
{
List <DirectorTableViewModel> lst = null;
using (BD_NETLINKEntities1 bd = new BD_NETLINKEntities1())
{
lst = (from data in bd.director
orderby data.nombre
select new DirectorTableViewModel
{
id = data.Id_director,
director = data.nombre
}
).ToList();
}
return(lst);
}
public ActionResult Delete(int id)
{
try
{
using (var data = new BD_NETLINKEntities1())
{
var oGen = data.genero.Find(id);
data.genero.Remove(oGen);
data.SaveChanges();
}
return(Content("1"));
}
catch {
return(Content("0"));
}
}
public List <MultimediaTypeTableViewModel> MultimediaType()
{
List <MultimediaTypeTableViewModel> lst = null;
using (BD_NETLINKEntities1 bd = new BD_NETLINKEntities1())
{
lst = (from data in bd.tipo_multimedia
orderby data.nombre
select new MultimediaTypeTableViewModel
{
id = data.id_tipo_multimedia,
tipo_multimedia = data.nombre
}
).ToList();
}
return(lst);
}
public ActionResult Delete(int id)
{
try
{
using (var data = new BD_NETLINKEntities1())
{
var oCat = data.Categoria.Find(id);
data.Categoria.Remove(oCat);
data.SaveChanges();
}
return(Content("1"));
}
catch {
return(Content("0"));
}
}
public List <LanguajeTableViewModel> Languaje()
{
List <LanguajeTableViewModel> lst = null;
using (BD_NETLINKEntities1 bd = new BD_NETLINKEntities1())
{
lst = (from data in bd.Idioma
orderby data.nombre
select new LanguajeTableViewModel
{
id = data.Id_idioma,
idioma = data.nombre
}
).ToList();
}
return(lst);
}
// GET: Gender
public ActionResult Index()
{
List <GenderTableViewModel> lst = null;
using (BD_NETLINKEntities1 bd = new BD_NETLINKEntities1())
{
lst = (from data in bd.genero
orderby data.Id_genero
select new GenderTableViewModel
{
id = data.Id_genero,
genero = data.nombre
}
).ToList();
}
return(View(lst));
}
public List <CategoryTableViewModel> Category()
{
List <CategoryTableViewModel> lst = null;
using (BD_NETLINKEntities1 bd = new BD_NETLINKEntities1())
{
lst = (from data in bd.Categoria
orderby data.nombre
select new CategoryTableViewModel
{
id = data.Id_Categoria,
categoria = data.nombre
}
).ToList();
}
return(lst);
}
public List <CountryTableViewModel> Country()
{
List <CountryTableViewModel> lst = null;
using (BD_NETLINKEntities1 bd = new BD_NETLINKEntities1())
{
lst = (from data in bd.pais
orderby data.nombre
select new CountryTableViewModel
{
id = data.Id_pais,
pais = data.nombre
}
).ToList();
}
return(lst);
}
//agregar vista
public ActionResult Update(int id)
{
EditUserViewModel objModelUser = new EditUserViewModel();
using (var data = new BD_NETLINKEntities1())
{
var oUser = data.usuario.Find(id);
objModelUser.email = oUser.email;
//objModelUser.password = oUser.password;
objModelUser.id = oUser.Id_usuario;
objModelUser.nombre = oUser.nombre;
objModelUser.apellido = oUser.apellido;
objModelUser.telefono = oUser.telefono;
objModelUser.nombreUsuario = oUser.nombreUsuario;
}
return(View(objModelUser));
}
public ActionResult Update(int id)
{
try
{
EditCategoryViewModel objModelCat = new EditCategoryViewModel();
using (var data = new BD_NETLINKEntities1())
{
var oCat = data.Categoria.Find(id);
objModelCat.categoria = oCat.nombre;
}
return(View(objModelCat));
}
catch (Exception x)
{
return(Content("Ocurrio un error" + x));
}
}
public ActionResult Insert(GenderTableViewModel model)
{
try
{
using (var data = new BD_NETLINKEntities1())
{
genero objGender = new genero();
objGender.nombre = model.genero;
data.genero.Add(objGender);
data.SaveChanges();
}
Session["insert"] = "success";
return(View());
}
catch {
Session["insert"] = "failed";
return(View());
}
}
public ActionResult Insert(string title, string description, string link, int?director, int?gender, int?category, int?country, int?languaje, int?multimediaType, string titleCap)
{
using (var data = new BD_NETLINKEntities1())
{
try {
multimedia objMovie = new multimedia();
objMovie.Titulo = title;
objMovie.descripcion = description;
objMovie.enlace = link;
objMovie.Id_genero = gender;
objMovie.Id_Categoria = category;
objMovie.Id_director = director;
objMovie.Id_idioma = languaje;
objMovie.Id_pais = country;
objMovie.id_tipo_multimedia = 1;
data.multimedia.Add(objMovie);
data.SaveChanges();
//enviamos la consulta a otro datos
if (titleCap != "")
{
serie objSerie = new serie();
objSerie.capitulo = 1;
objSerie.id_multimedia = objMovie.Id_multimedia;
objSerie.titulo = titleCap;
data.serie.Add(objSerie);
data.SaveChanges();
}
Session["alert"] = "success";
return(Content("true"));
}
catch (Exception x) {
return(Content("Se genero un error! " + x.Message));
}
}
}
public ActionResult Insert(CategoryTableViewModel model)
{
try
{
using (var data = new BD_NETLINKEntities1())
{
Categoria objUser = new Categoria();
objUser.nombre = model.categoria;
data.Categoria.Add(objUser);
data.SaveChanges();
Session["insert"] = "success";
return(View());
}
}
catch {
Session["insert"] = "failed";
return(View());
}
}
public ActionResult ManagerMovie()
{
List <MovieTableViewModel> lst = null;
using (BD_NETLINKEntities1 bd = new BD_NETLINKEntities1())
{
lst = (from data in bd.multimedia
orderby data.Id_multimedia
select new MovieTableViewModel
{
enlace = data.enlace,
descripcion = data.descripcion,
titulo = data.Titulo,
id = data.Id_multimedia
}
).ToList();
}
return(View(lst));
}
public ActionResult Update(int id)
{
EditMovieViewModel objModelMov = new EditMovieViewModel();
using (var data = new BD_NETLINKEntities1())
{
var oMov = data.multimedia.Find(id);
objModelMov.descripcion = oMov.descripcion;
objModelMov.enlace = oMov.enlace;
objModelMov.id_categoria = Convert.ToInt32(oMov.Id_Categoria);
objModelMov.id_director = Convert.ToInt32(oMov.Id_director);
objModelMov.id_genero = Convert.ToInt32(oMov.Id_genero);
objModelMov.id_idioma = Convert.ToInt32(oMov.Id_idioma);
objModelMov.id_pais = Convert.ToInt32(oMov.Id_pais);
objModelMov.id_tipo_multimedia = Convert.ToInt32(oMov.id_tipo_multimedia);
objModelMov.titulo = oMov.Titulo;
objModelMov.id = oMov.Id_multimedia;
}
return(View(objModelMov));
}
public ActionResult Update(string nombreUsuario, int telefono, string nombre, string apellido, string email, string password, string confPassword, int id)
{
try
{
if (Convert.ToInt32(Session["id_usuario"]) != id && Convert.ToInt32(Session["rol"]) != 1)
{
return(Content("Failed"));
}
if (password != confPassword)
{
return(Content("Failed"));
}
using (var data = new BD_NETLINKEntities1())
{
var oUser = data.usuario.Find(id);
oUser.email = email;
//oUser.password = Encriptar.EncriptarClave(password);
oUser.nombre = nombre;
oUser.apellido = apellido;
oUser.telefono = telefono;
oUser.nombreUsuario = nombreUsuario;
if (password != null && password.Trim() != "")
{
oUser.password = Encriptar.EncriptarClave(password);
}
data.Entry(oUser).State = System.Data.Entity.EntityState.Modified;
data.SaveChanges();
}
return(Content("True"));
}
catch {
return(Content("Failed"));
}
}
// GET: Category
public ActionResult Index()
{
try {
List <CategoryTableViewModel> lst = null;
using (BD_NETLINKEntities1 bd = new BD_NETLINKEntities1())
{
lst = (from data in bd.Categoria
orderby data.Id_Categoria
select new CategoryTableViewModel
{
id = data.Id_Categoria,
categoria = data.nombre
}
).ToList();
}
return(View(lst));
}
catch (Exception x) {
return(Content("Ocurrio un error" + x));
}
}
//MarkaDaataEntities context
// GET: User
public ActionResult Index()
{
List <UserTableViewModel> lst = null;
using (BD_NETLINKEntities1 bd = new BD_NETLINKEntities1())
{
lst = (from data in bd.usuario
where data.id_rol == 2
orderby data.email
select new UserTableViewModel
{
id = data.Id_usuario,
email = data.email,
password = data.password,
nombreUsuario = data.nombreUsuario,
nombre = data.nombre,
apellido = data.apellido
}
).ToList();
}
return(View(lst));
}
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));
}
}
public ActionResult Update(EditCategoryViewModel model)
{
try
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (var data = new BD_NETLINKEntities1())
{
var oCat = data.Categoria.Find(model.id);
oCat.nombre = model.categoria;
data.Entry(oCat).State = System.Data.Entity.EntityState.Modified;
data.SaveChanges();
}
Session["update"] = "success";
return(View());
}
catch {
Session["update"] = "failed";
return(View());
}
}
public ActionResult Update(EditGenderViewModel model)
{
try
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (var data = new BD_NETLINKEntities1())
{
var oGen = data.genero.Find(model.id);
oGen.nombre = model.genero;
data.Entry(oGen).State = System.Data.Entity.EntityState.Modified;
data.SaveChanges();
}
Session["update"] = "success";
return(View());
}
catch {
Session["update"] = "failed";
return(View());
}
}