public ActionResult DetallePublicacion(int id)
{
ViewBag.con = id;
Guid ID;
if (Session["userid"] == null)
ID = Guid.Empty;
else
ID = (Guid)Session["userid"];
BibliotecaDataContext db = new BibliotecaDataContext();
ViewBag.tipo = (from p in db.Contenidos where p.IdContenido == id select p).ToArray()[0].Tipo;
ViewBag.titulo = (from p in db.Contenidos where p.IdContenido == id select p).ToArray()[0].Titulo;
ViewBag.contenido = (from p in db.Publicacions where p.IdPublicacion == id select new { tema = p.Tema }).ToArray()[0].tema;
ViewBag.comentario = (from p in db.Comentarios where p.Id_Cont == id select p).ToList();
ViewBag.cosa = (from p in db.Gustas where p.Id_Us == ID && p.IdPub == id select p).Count().ToString();
Guid IDD = (Guid)(from p in db.Contenidos where p.IdContenido==id select p).ToArray()[0].Id_User;
var y = (from i in db.Perfil_Usuarios where i.Id_User == IDD select i).ToArray()[0];
ViewBag.avatar = y.Avatar;
ViewBag.karma = y.Karma;
ViewBag.userid = IDD;
ViewBag.comcont = (from p in db.Comentarios where p.Id_Cont == id select p).Count();
ViewBag.listas = (from i in db.Contenidos where i.Id_User == IDD select i).ToList();
ViewBag.listauser = (from p in db.Perfil_Usuarios select p).ToList();
ViewBag.gustas=(from i in db.Gustas where i.IdPub==id select i).Count();
return View();
}
public ActionResult Actualizar_categoria(FormCollection f)
{
int id = Convert.ToInt32( f["id"]);
BibliotecaDataContext db= new BibliotecaDataContext();
int con = (from i in db.Categorias where i.Nombre == f["nuevo"].ToLower().Trim() select i).Count();
if (con == 0)
{
Categoria c = db.Categorias.Single(u => u.Id_cat == id);
c.Nombre = f["nuevo"].ToLower().Trim();
db.SubmitChanges();
}
else {
var relaciones = (from i in db.Rel_Categoria_Contenidos where i.Id_cat==id select i).ToList();
foreach (var v in relaciones) {
db.Rel_Categoria_Contenidos.DeleteOnSubmit(v);
db.SubmitChanges();
}
var catego=(from i in db.Categorias where i.Id_cat==id select i).ToList();
foreach (var v in catego) {
db.Categorias.DeleteOnSubmit(v);
db.SubmitChanges();
}
int ID = (from i in db.Categorias where i.Nombre == f["nuevo"].ToLower().Trim() select i).ToArray()[0].Id_cat;
foreach (var v in relaciones) {
if((from i in db.Rel_Categoria_Contenidos where i.Id_cat==ID && i.IdContenido==v.IdContenido select i).Count()==0){
Rel_Categoria_Contenido r = new Rel_Categoria_Contenido() { Id_cat = ID, IdContenido = v.IdContenido };
db.Rel_Categoria_Contenidos.InsertOnSubmit(r);
db.SubmitChanges();
}
}
}
return RedirectToAction("Categorias");
}
public ActionResult DetallePublicacion(FormCollection f)
{
Guid ID;
if (Session["userid"] == null)
ID = Guid.Empty;
else
ID = (Guid)Session["userid"];
int id = Convert.ToInt32(f["id"]);
BibliotecaDataContext db = new BibliotecaDataContext();
ViewBag.tipo = (from p in db.Contenidos where p.IdContenido == id select p).ToArray()[0].Tipo;
ViewBag.con=id;
ViewBag.contenido = (from p in db.Publicacions where p.IdPublicacion == id select new { tema = p.Tema }).ToArray()[0].tema;
if (f["coment"] != null && f["coment"] != "")
{
Comentario c = new Comentario() { Id_Cont = id, Id_Us = ID, Fecha = DateTime.Now, Texto = f["coment"] };
db.Comentarios.InsertOnSubmit(c);
db.SubmitChanges();
}
ViewBag.comentario=(from p in db.Comentarios where p.Id_Cont==id select p).ToList();
ViewBag.cosa = (from p in db.Gustas where p.Id_Us==ID && p.IdPub==id select p).Count().ToString();
Guid IDD = (Guid)(from p in db.Contenidos where p.IdContenido == id select p).ToArray()[0].Id_User;
var y = (from i in db.Perfil_Usuarios where i.Id_User == IDD select i).ToArray()[0];
ViewBag.avatar = y.Avatar;
ViewBag.karma = y.Karma;
ViewBag.userid = IDD;
ViewBag.comcont = (from p in db.Comentarios where p.Id_Cont == id select p).Count();
ViewBag.listas = (from i in db.Contenidos where i.Id_User == IDD select i).ToList();
ViewBag.listauser = (from p in db.Perfil_Usuarios select p).ToList();
ViewBag.gustas = (from i in db.Gustas where i.IdPub == id select i).Count();
return View();
}
public ActionResult Index(int id)
{
BibliotecaDataContext db = new BibliotecaDataContext();
var lista = (from f in db.Categorias
select f).ToList();
ViewBag.catego = lista;
ViewBag.miscat = (from t in db.ListaCategos select t).ToList();
ViewBag.Gusta = (from t in db.Cant_Gustas select t).ToList();
ViewBag.contenido = (from t in db.Contenidos select t).ToList();
if (id == 0)
{
ViewBag.con = (from f in db.VistaGeneralLibros where f.estado==1 orderby f.IdContenido descending select f).ToList();
ViewBag.art = (from f in db.VistaGeneralPublicacions where f.estado == 1 && f.Tipo == "Articulo" orderby f.IdContenido descending select f).ToList();
ViewBag.tuto = (from f in db.VistaGeneralPublicacions where f.estado == 1 && f.Tipo == "Tutorial" orderby f.IdContenido descending select f).ToList();
ViewBag.curso = (from f in db.VistaGeneralPublicacions where f.estado == 1 && f.Tipo == "Curso" orderby f.IdContenido descending select f).ToList();
}
else
{
ViewBag.con = (from f in db.VistaGeneralLibros join g in db.Rel_Categoria_Contenidos on f.IdContenido equals g.IdContenido where f.estado==1 && g.Id_cat == id orderby f.IdContenido descending select f).ToList();
ViewBag.art = (from f in db.VistaGeneralPublicacions join g in db.Rel_Categoria_Contenidos on f.IdContenido equals g.IdContenido where f.estado==1 && g.Id_cat==id && f.Tipo=="Articulo" orderby f.IdContenido descending select f).ToList();
ViewBag.tuto = (from f in db.VistaGeneralPublicacions join g in db.Rel_Categoria_Contenidos on f.IdContenido equals g.IdContenido where f.estado==1 && g.Id_cat == id && f.Tipo == "Tutorial" orderby f.IdContenido descending select f).ToList();
ViewBag.curso = (from f in db.VistaGeneralPublicacions join g in db.Rel_Categoria_Contenidos on f.IdContenido equals g.IdContenido where f.estado==1 && g.Id_cat == id && f.Tipo == "Curso" orderby f.IdContenido descending select f).ToList();
}
return View();
}
public ActionResult Bannear(Guid id)
{
BibliotecaDataContext db = new BibliotecaDataContext();
Perfil_Usuario pu = db.Perfil_Usuarios.Single(u => u.Id_User == id);
pu.estado = 0;
db.SubmitChanges();
return Redirect("/Account/Perfil/" + id);
}
public ActionResult Bueno(int id)
{
BibliotecaDataContext db= new BibliotecaDataContext();
Contenido c = db.Contenidos.Single(u => u.IdContenido == id);
c.estado = 1;
db.SubmitChanges();
return RedirectToAction("Contenidos", "Admin");
}
public ActionResult Bannear(Guid id)
{
BibliotecaDataContext db= new BibliotecaDataContext();
Perfil_Usuario pu = db.Perfil_Usuarios.Single(u => u.Id_User == id);
pu.estado = 0;
db.SubmitChanges();
string x = (from i in db.aspnet_Users where i.UserId == id select i).ToArray()[0].UserName;
Roles.RemoveUserFromRole(x,"Miembro");
return RedirectToAction("Usuarios");
}
public ActionResult Comentar(FormCollection f)
{
Guid ID;
if (Session["userid"] == null)
ID = Guid.Empty;
else
ID = (Guid)Session["userid"];
int id = Convert.ToInt32(f["id"]);
BibliotecaDataContext db = new BibliotecaDataContext();
if (f["coment"] != null && f["coment"] != "")
{
Comentario c = new Comentario() { Id_Cont = id, Id_Us = ID, Fecha = DateTime.Now, Texto = f["coment"] };
db.Comentarios.InsertOnSubmit(c);
db.SubmitChanges();
}
return Redirect("/Contenido/VistaLibro/" + id);
}
public ActionResult Comentarios(string id)
{
BibliotecaDataContext db = new BibliotecaDataContext();
if (id == null || id=="" || id=="0")
{
ViewBag.lista = (from i in db.vista_comentarios select i).ToList();
ViewBag.palabra = "*";
}
else
{
ViewBag.lista = (from i in db.vista_comentarios where i.Texto.Contains(id) select i).ToList();
ViewBag.palabra = id;
}
ViewBag.cantidad = (from i in db.Comentarios select i).ToList();
ViewBag.ofensivo = (from i in db.diccionarios select i).ToList();
return View();
}
public ActionResult Busqueda(FormCollection f)
{
string criterio = f["criterio"];
string filtro = f["porque"];
ViewBag.dato = criterio;
BibliotecaDataContext db = new BibliotecaDataContext();
if (filtro == "*")
{
ViewBag.lista = (from p in db.VistaGeneralLibros where p.Descripcion.Contains(criterio) select p).ToList();
ViewBag.lista2 = (from p in db.VistaGeneralPublicacions join q in db.Publicacions on p.IdContenido equals q.IdPublicacion where p.Descripcion.Contains(criterio) || q.Tema.Contains(criterio) select p).ToList();
ViewBag.con = (from p in db.Contenidos where (p.Descripcion.Contains(criterio) || p.Publicacion.Tema.Contains(criterio)) select p).Count();
}
else
{
if(filtro=="Libro")
ViewBag.lista = (from p in db.VistaGeneralLibros where p.Descripcion.Contains(criterio) select p).ToList();
ViewBag.lista2 = (from p in db.VistaGeneralPublicacions join q in db.Publicacions on p.IdContenido equals q.IdPublicacion where (p.Descripcion.Contains(criterio)||q.Tema.Contains(criterio)) && p.Tipo==filtro select p).ToList();
ViewBag.con = (from p in db.Contenidos where (p.Descripcion.Contains(criterio)||p.Publicacion.Tema.Contains(criterio)) && p.Tipo == filtro select p).Count();
}
return View();
}
public ActionResult NoGusta(int id)
{
BibliotecaDataContext db = new BibliotecaDataContext();
var det = from p in db.Gustas where p.Id_Us == (Guid)(Session["userid"]) && p.IdPub == id select p;
foreach (var x in det) {
db.Gustas.DeleteOnSubmit(x);
}
db.SubmitChanges();
string tipo = (from t in db.Contenidos where t.IdContenido == id select t).ToArray()[0].Tipo;
if (tipo == "Libro")
return Redirect("/Contenido/VistaLibro/" + id);
return Redirect("/Contenido/DetallePublicacion/" + id);
}
public ActionResult Insertar_palabra(FormCollection f)
{
string pal="";
BibliotecaDataContext db= new BibliotecaDataContext();
if(f["palabra"]!=null && f["palabra"]!=""){
pal = f["palabra"];
if ((from i in db.diccionarios where i.palabra == pal select i).Count() == 0) {
diccionario d = new diccionario() { palabra = pal };
db.diccionarios.InsertOnSubmit(d);
db.SubmitChanges();
}
}
return RedirectToAction("Comentarios");
}
public ActionResult VistaLibro(int id)
{
BibliotecaDataContext db = new BibliotecaDataContext();
var x = from i in db.Contenidos
join j in db.Libros on i.IdContenido equals j.IdPublicacion
where i.IdContenido == id
select new
{
titulo=i.Titulo,
descripcion=i.Descripcion,
tema=j.Tema,
autor=j.Autor,
fecha=j.AnoPublicacion,
id=i.Id_User
};
ViewBag.id = id;
ViewBag.titulo = x.ToArray()[0].titulo;
ViewBag.desc = x.ToArray()[0].descripcion;
ViewBag.tema = x.ToArray()[0].tema;
ViewBag.autor = x.ToArray()[0].autor;
ViewBag.fecha = x.ToArray()[0].fecha;
Guid ID = (Guid)x.ToArray()[0].id;
var y = (from i in db.Perfil_Usuarios where i.Id_User == ID select i).ToArray()[0];
ViewBag.avatar = y.Avatar;
ViewBag.karma = y.Karma;
ViewBag.listas = (from i in db.Contenidos where i.Id_User == ID select i).ToList();
ViewBag.comcont = (from p in db.Comentarios where p.Id_Cont == id select p).Count();
ViewBag.comentario = (from p in db.Comentarios where p.Id_Cont == id select p).ToList();
ViewBag.cosa = (from p in db.Gustas where p.Id_Us == ID && p.IdPub == id select p).Count().ToString();
ViewBag.userid = ID;
ViewBag.listauser = (from p in db.Perfil_Usuarios select p).ToList();
ViewBag.gustas = (from i in db.Gustas where i.IdPub == id select i).Count();
return View();
}
public ActionResult SubirLibro(Libros lib,HttpPostedFileBase portada,HttpPostedFileBase contenido)
{
BibliotecaDataContext db = new BibliotecaDataContext();
Guid id = (Guid)Session["userid"];
ViewBag.lista = db.Categorias;
int ID;
if (ModelState.IsValid) {
Contenido con = new Contenido()
{
Id_User=id,
Titulo=lib.titulo,
Descripcion=lib.descripcion,
Tipo="Libro",
observaciones="",
estado=0,
Fecha_publicacion=DateTime.Now
};
db.Contenidos.InsertOnSubmit(con);
db.SubmitChanges();
ID = db.Contenidos.OrderByDescending(ax => con.IdContenido).Select(a => con.IdContenido).ToArray()[0];
DateTime dt = new DateTime();
dt.AddYears(lib.aniopublicacion);
var data = new byte[portada.ContentLength];
var data2 = new byte[contenido.ContentLength];
portada.InputStream.Read(data, 0, portada.ContentLength);
contenido.InputStream.Read(data2, 0, contenido.ContentLength);
var path = ControllerContext.HttpContext.Server.MapPath("../contenidos");
var path2 = ControllerContext.HttpContext.Server.MapPath("../contenidos");
var filename = Path.Combine(path, Path.GetFileName(portada.FileName));
var filename2 = Path.Combine(path2, Path.GetFileName(contenido.FileName));
System.IO.File.WriteAllBytes(Path.Combine(path, filename), data);
System.IO.File.WriteAllBytes(Path.Combine(path2, filename2), data2);
Libro l = new Libro()
{
IdPublicacion=ID,
Autor=lib.autor,
AnoPublicacion=dt,
Portada="/contenidos/"+portada.FileName,
Tema="/contenidos/"+contenido.FileName
};
db.Libros.InsertOnSubmit(l);
db.SubmitChanges();
string[] miarray = lib.categoria.ToLower().Split(',');
List<Categoria> lcat = new List<Categoria>();
foreach (var x in miarray)
{
string aux = x.Trim();
if (db.Categorias.Where(a => a.Nombre == aux).Count() == 0)
{
Categoria c = new Categoria() { Nombre = aux };
db.Categorias.InsertOnSubmit(c);
db.SubmitChanges();
}
int idcat = db.Categorias.Where(a => a.Nombre == aux).Select(a => a.Id_cat).ToArray()[0];
Rel_Categoria_Contenido r = new Rel_Categoria_Contenido() { Id_cat=idcat,IdContenido=ID};
db.Rel_Categoria_Contenidos.InsertOnSubmit(r);
db.SubmitChanges();
}
return Redirect("VistaLibro/"+ID);
}
return View();
}
public ActionResult RevisionPublicacion(int id)
{
ViewBag.con = id;
BibliotecaDataContext db = new BibliotecaDataContext();
ViewBag.tipo = (from p in db.Contenidos where p.IdContenido == id select p).ToArray()[0].Tipo;
ViewBag.titulo = (from p in db.Contenidos where p.IdContenido == id select p).ToArray()[0].Titulo;
ViewBag.contenido = (from p in db.Publicacions where p.IdPublicacion == id select new { tema = p.Tema }).ToArray()[0].tema;
return View();
}
public ActionResult EdicionLibro(int id)
{
BibliotecaDataContext db = new BibliotecaDataContext();
var x = (from i in db.Contenidos
join j in db.Libros on i.IdContenido equals j.IdPublicacion
where i.IdContenido == id
select new Libros() {
titulo=i.Titulo,
descripcion=i.Descripcion,
autor=j.Autor
}
);
ViewBag.observaciones = (from i in db.Contenidos where i.IdContenido == id select i).ToArray()[0].observaciones;
ViewBag.id = id;
ViewBag.titulo = x.ToArray()[0].titulo;
ViewBag.descripcion = x.ToArray()[0].descripcion;
ViewBag.autor = x.ToArray()[0].autor;
return View();
}
public ActionResult Categorias()
{
BibliotecaDataContext db= new BibliotecaDataContext();
ViewBag.categos = (from i in db.Categorias select i).ToList();
return View();
}
public ActionResult Eliminar_comentario(int id,string clave)
{
BibliotecaDataContext db = new BibliotecaDataContext();
var v = (from i in db.Comentarios where i.Id_Com == id select i);
if(clave=="*")
v = (from i in db.Comentarios where i.Id_Com == id select i);
else
v = (from i in db.Comentarios where i.Texto.Contains(clave) select i);
foreach (var item in v) {
db.Comentarios.DeleteOnSubmit(item);
db.SubmitChanges();
}
return RedirectToAction("Comentarios");
}
public ActionResult Usuarios()
{
BibliotecaDataContext db = new BibliotecaDataContext();
ViewBag.userlist = (from i in db.Perfil_Usuarios
join j in db.aspnet_Memberships
on i.Id_User equals j.UserId
select new detalle_perfil(){
Id_user=(Guid)i.Id_User,
avatar=i.Avatar,
nickname=i.Nickname,
username=i.aspnet_User.UserName,
mail=j.Email ,
karma=Convert.ToInt32(i.Karma),
estado=Convert.ToInt32( i.estado)
});
return View();
}
public ActionResult Observar(FormCollection f)
{
BibliotecaDataContext db = new BibliotecaDataContext();
int id =Convert.ToInt32( f["idcont"]);
Contenido c = db.Contenidos.Single(u => u.IdContenido == id);
c.observaciones = f["observacion"];
c.estado = 2;
db.SubmitChanges();
return RedirectToAction("Contenidos", "Admin");
}
public ActionResult Publicar(ContenidoVista c,FormCollection f)
{
BibliotecaDataContext db = new BibliotecaDataContext();
int ID = 0;
Guid id = (Guid)Session["userid"];
if (ModelState.IsValid)
{
Contenido con = new Contenido()
{
Id_User = id,
Titulo = c.titulo,
Descripcion = c.descripcion,
Tipo = f["tipo"],
observaciones="",
estado=0,
Fecha_publicacion=DateTime.Now
};
db.Contenidos.InsertOnSubmit(con);
db.SubmitChanges();
ID = db.Contenidos.OrderByDescending(ax => con.IdContenido).Select(a => con.IdContenido).ToArray()[0];
Publicacion p = new Publicacion()
{
IdPublicacion = ID,
Tema = f["ckeditor"]
};
db.Publicacions.InsertOnSubmit(p);
db.SubmitChanges();
string[] miarray = c.categoria.ToLower().Split(',');
List<Categoria> lcat = new List<Categoria>();
foreach (var x in miarray)
{
string aux = x.Trim();
if (db.Categorias.Where(a => a.Nombre == aux).Count() == 0)
{
Categoria cc = new Categoria() { Nombre = aux };
db.Categorias.InsertOnSubmit(cc);
db.SubmitChanges();
}
int idcat = db.Categorias.Where(a => a.Nombre == aux).Select(a => a.Id_cat).ToArray()[0];
Rel_Categoria_Contenido r = new Rel_Categoria_Contenido() { Id_cat = idcat, IdContenido = ID };
db.Rel_Categoria_Contenidos.InsertOnSubmit(r);
db.SubmitChanges();
}
return Redirect("../DetallePublicacion/" + ID);
}
return View();
}
public ActionResult EdicionLibro(FormCollection f, HttpPostedFileBase portada, HttpPostedFileBase contenido)
{
BibliotecaDataContext db = new BibliotecaDataContext();
Guid id = (Guid)Session["userid"];
ViewBag.lista = db.Categorias;
int ID= Convert.ToInt32( f["ID"]);
Contenido c = db.Contenidos.Single(u => u.IdContenido == ID);
Libro l = db.Libros.Single(u => u.IdPublicacion == ID);
if (f["autor"] != null && f["autor"] != "")
l.Autor = f["Autor"];
if (f["titulo"] != null && f["titulo"] != "")
c.Titulo = f["titulo"];
if (f["descripcion"] != null && f["descripcion"] != "")
c.Descripcion = f["descripcion"];
if (f["anio"] != null && f["anio"] != "")
l.AnoPublicacion = DateTime.Now;
if (portada!=null)
{
var data = new byte[portada.ContentLength];
portada.InputStream.Read(data, 0, portada.ContentLength);
var path = ControllerContext.HttpContext.Server.MapPath("../contenidos");
var filename = Path.Combine(path, Path.GetFileName(portada.FileName));
System.IO.File.WriteAllBytes(Path.Combine(path, filename), data);
l.Portada = "/contenidos/"+portada.FileName;
}
if (contenido != null)
{
var data2 = new byte[contenido.ContentLength];
contenido.InputStream.Read(data2, 0, contenido.ContentLength);
var path2 = ControllerContext.HttpContext.Server.MapPath("../contenidos");
var filename2 = Path.Combine(path2, Path.GetFileName(contenido.FileName));
System.IO.File.WriteAllBytes(Path.Combine(path2, filename2), data2);
l.Tema = "/contenidos/"+contenido.FileName;
}
c.estado = 0;
db.SubmitChanges();
if (f["categoria"] != null && f["categoria"] != "")
{
string[] miarray = f["categoria"].ToLower().Split(',');
List<Categoria> lcat = new List<Categoria>();
foreach (var x in miarray)
{
string aux = x.Trim();
if (db.Categorias.Where(a => a.Nombre == aux).Count() == 0)
{
Categoria cat = new Categoria() { Nombre = aux };
db.Categorias.InsertOnSubmit(cat);
db.SubmitChanges();
}
int idcat = db.Categorias.Where(a => a.Nombre == aux).Select(a => a.Id_cat).ToArray()[0];
if ((from i in db.Rel_Categoria_Contenidos where i.Id_cat == idcat && i.IdContenido == ID select i).Count() == 0)
{
Rel_Categoria_Contenido r = new Rel_Categoria_Contenido() { Id_cat = idcat, IdContenido = ID };
db.Rel_Categoria_Contenidos.InsertOnSubmit(r);
db.SubmitChanges();
}
}
}
return Redirect("/Contenido/VistaLibro/" + ID);
}
public ActionResult SubirLibro()
{
BibliotecaDataContext db = new BibliotecaDataContext();
ViewBag.lista = db.Categorias;
return View();
}
public ActionResult Contenidos()
{
BibliotecaDataContext db = new BibliotecaDataContext();
ViewBag.lista = (from i in db.Contenidos where i.estado==0 select i).ToList();
return View();
}
public ActionResult Eliminar_categorias(int id)
{
BibliotecaDataContext db = new BibliotecaDataContext();
var x=(from i in db.Categorias where i.Id_cat==id select i).ToList();
foreach (var n in x) {
var rel = (from j in db.Rel_Categoria_Contenidos where j.Id_cat == n.Id_cat select j).ToList();
foreach (var m in rel)
db.Rel_Categoria_Contenidos.DeleteOnSubmit(m);
db.SubmitChanges();
db.Categorias.DeleteOnSubmit(n);
db.SubmitChanges();
}
return RedirectToAction("Categorias");
}
public ActionResult EdicionPublicacion(FormCollection f)
{
int ID = Convert.ToInt32(f["id"]);
BibliotecaDataContext db = new BibliotecaDataContext();
Contenido c = db.Contenidos.Single(u => u.IdContenido == ID);
Publicacion p = db.Publicacions.Single(u => u.IdPublicacion == ID);
if (f["titulo"] != null && f["titulo"] != "")
c.Titulo = f["titulo"];
if (f["descripcion"] != null && f["descripcion"] != "")
c.Descripcion = f["descripcion"];
if (f["ckeditor"] != null && f["ckeditor"] != "")
p.Tema = f["ckeditor"];
c.estado = 0;
db.SubmitChanges();
if (f["categoria"] != null && f["categoria"] != "")
{
string[] miarray = f["categoria"].ToLower().Split(',');
List<Categoria> lcat = new List<Categoria>();
foreach (var x in miarray)
{
string aux = x.Trim();
if (db.Categorias.Where(a => a.Nombre == aux).Count() == 0)
{
Categoria cat = new Categoria() { Nombre = aux };
db.Categorias.InsertOnSubmit(cat);
db.SubmitChanges();
}
int idcat = db.Categorias.Where(a => a.Nombre == aux).Select(a => a.Id_cat).ToArray()[0];
if ((from i in db.Rel_Categoria_Contenidos where i.Id_cat == idcat && i.IdContenido == ID select i).Count() == 0)
{
Rel_Categoria_Contenido r = new Rel_Categoria_Contenido() { Id_cat = idcat, IdContenido = ID };
db.Rel_Categoria_Contenidos.InsertOnSubmit(r);
db.SubmitChanges();
}
}
}
return Redirect("/Contenido/DetallePublicacion/" + ID);
}
public ActionResult Disminuir_karma(FormCollection f)
{
Guid id =new Guid( f["userid"]);
int i=0;
if (f["cantidad"] != null && f["cantidad"] != "")
i =Convert.ToInt32( f["cantidad"]);
BibliotecaDataContext db = new BibliotecaDataContext();
Perfil_Usuario pu = db.Perfil_Usuarios.Single(u => u.Id_User == id);
pu.Karma = pu.Karma - i;
db.SubmitChanges();
return RedirectToAction("Usuarios");
}
public ActionResult Gusta(int id)
{
BibliotecaDataContext db = new BibliotecaDataContext();
Gusta h = new Gusta() { Id_Us=(Guid)(Session["userid"]),IdPub=id};
db.Gustas.InsertOnSubmit(h);
db.SubmitChanges();
string tipo = (from t in db.Contenidos where t.IdContenido == id select t).ToArray()[0].Tipo;
if(tipo=="Libro")
return Redirect("/Contenido/VistaLibro/" + id);
return Redirect("/Contenido/DetallePublicacion/"+id);
}
public ActionResult EdicionPublicacion(int id)
{
BibliotecaDataContext db = new BibliotecaDataContext();
ViewBag.id = id;
ViewBag.lista=(from i in db.Contenidos
join j in db.Publicacions on i.IdContenido equals j.IdPublicacion
where i.IdContenido==id select new ContenidoVista(){
titulo=i.Titulo,
descripcion=i.Descripcion,
Tipo=i.Tipo,
text=j.Tema
} ).ToArray()[0];
ViewBag.observaciones = (from i in db.Contenidos where i.IdContenido == id select i).ToArray()[0].observaciones;
return View();
}
public ActionResult Eliminar_varios(string id)
{
BibliotecaDataContext db = new BibliotecaDataContext();
var v = (from i in db.Comentarios where i.Texto.Contains(id) select i);
foreach (var i in v) {
db.Comentarios.DeleteOnSubmit(i);
}
db.SubmitChanges();
return RedirectToAction("Comentarios");
}
