public ActionResult PublicarArticulo(int id) { DataClasses1DataContext db = new DataClasses1DataContext(); var pub = db.publicacions.Where(a => a.idPublicacion == id); publicacion p = new publicacion() { estado = true }; pub.ToArray()[0].estado = true; db.SubmitChanges(); //cambia el estado a 1 System.Guid idusu = db.publicacions.Where(v=>v.idPublicacion==id).Select(i=>i.UserId).ToArray()[0]; if (db.karmas.Where(d => d.UserId == idusu).ToList().Count == 0) { karma k = new karma() { UserId = idusu ,detalle = "puntaje de karma", total = 10, fecha = DateTime.Now }; db.karmas.InsertOnSubmit(k); db.SubmitChanges(); } else { List<karma> karma= db.karmas.Where(g => g.UserId == idusu).ToList(); //kar.Sum = kar(double) + 10; double j = 0; foreach (var u in karma) { double h = u.total ; j = h + 10; } var l=db.karmas.Where(ll=>ll.UserId == idusu); karma ka = new karma() { UserId=idusu,detalle="puntaje",total = j, fecha=DateTime.Now }; l.ToArray()[0].UserId = idusu; l.ToArray()[0].detalle ="puntaje"; l.ToArray()[0].total = j; l.ToArray()[0].fecha = DateTime.Now; db.SubmitChanges(); } //return View(); return RedirectToAction("Index","ModeracionContenido"); }
partial void Deletekarma(karma instance);
partial void Updatekarma(karma instance);
partial void Insertkarma(karma instance);
public ActionResult Comentar(Comentario model, int id) { DataClasses1DataContext db = new DataClasses1DataContext(); if (Session["ids"] != null) { if (db.comentarios.Where(ss => ss.UserId == (Guid)Session["ids"]).Where(tt => tt.infraccion == 1).ToList().Count <= 3) { System.Guid idusu = (Guid)Session["ids"]; string[] arraycomentario = model.Descripcion.ToLower().Split(' '); List<diccionario> malaspalabras = new List<diccionario>(); foreach (var items in arraycomentario) { string item = items.Trim(); if (db.diccionarios.Where(x => x.palabra == item).Count() != 0) { foreach (var ii in db.diccionarios) { if (ii.palabra == item) { malaspalabras.Add(new diccionario() { palabra = item }); } } } } if (malaspalabras.ToList().Count() > 0) { comentario a = new comentario() { UserId = idusu, idPublicacion = id, Descripcion = model.Descripcion, puntuacion = 0.5, fecha = DateTime.Now, infraccion = 1 }; db.comentarios.InsertOnSubmit(a); db.SubmitChanges(); } else { comentario a = new comentario() { UserId = idusu, idPublicacion = id, Descripcion = model.Descripcion, puntuacion = 0.5, fecha = DateTime.Now, infraccion = 0 }; db.comentarios.InsertOnSubmit(a); db.SubmitChanges(); } //actualiza su karma if (db.karmas.Where(d => d.UserId == idusu).ToList().Count == 0) { karma k = new karma() { UserId = idusu, detalle = "puntaje de karma", total = 0.5, fecha = DateTime.Now }; db.karmas.InsertOnSubmit(k); db.SubmitChanges(); } else { List<karma> karma = db.karmas.Where(g => g.UserId == idusu).ToList(); //kar.Sum = kar(double) + 10; double j = 0; foreach (var u in karma) { double h = u.total; j = h + 0.5; } var l = db.karmas.Where(ll => ll.UserId == idusu); karma ka = new karma() { UserId = idusu, detalle = "puntaje", total = j, fecha = DateTime.Now }; l.ToArray()[0].UserId = idusu; l.ToArray()[0].detalle = "puntaje"; l.ToArray()[0].total = j; l.ToArray()[0].fecha = DateTime.Now; db.SubmitChanges(); } int i = id; if (db.libros.Where(v => v.idPublicacion == i).ToList().Count != 0) { return RedirectToAction("Vlibro", "Home", new { id = id }); } if (db.cursos.Where(v => v.idPublicacion == i).ToList().Count != 0) { return RedirectToAction("Vcurso", "Home", new { id = id }); } if (db.articulos.Where(v => v.idPublicacion == i).ToList().Count != 0) { return RedirectToAction("Varticulo", "Home", new { id = id }); } if (db.tutorials.Where(v => v.idPublicacion == i).ToList().Count != 0) { return RedirectToAction("Vtutorial", "Home", new { id = id }); } return RedirectToAction("Index", "Home"); } else { System.Guid IdUs = db.aspnet_Users.Where(a => a.UserId == (Guid)Session["ids"]).Select(a => a.UserId).ToArray()[0]; System.Guid IdRol = db.aspnet_Roles.Where(a => a.RoleName == "vaneado").Select(a => a.RoleId).ToArray()[0]; //elimina la fila relacion aspnet_UsersInRole v = db.aspnet_UsersInRoles.Where(n => n.UserId == IdUs).ToArray()[0]; db.aspnet_UsersInRoles.DeleteOnSubmit(v); db.SubmitChanges(); //agrega la nueva relacion de usuario vaneado var vane = db.aspnet_UsersInRoles.Where(f => f.UserId == IdUs); aspnet_UsersInRole rel = new aspnet_UsersInRole() { RoleId = IdRol, UserId = IdUs }; db.aspnet_UsersInRoles.InsertOnSubmit(rel); db.SubmitChanges(); ViewBag.Message = "UD A SIDO BANEADO DEL SISTEMA POR REALIZAR COMENTARIOS ABUSIVOS"; return RedirectToAction("LogOn", "Account"); } } else { ViewBag.Message = "DEBE ESTAR REGISTRADO"; return RedirectToAction("LogOn", "Account"); } }
public ActionResult megusta(int id) { DataClasses1DataContext db = new DataClasses1DataContext(); if ((Guid)Session["ids"] != null) { if (db.karma2s.Where(g => g.UserId == (Guid)Session["ids"]).ToList().Count() == 0) { ViewBag.id = id; System.Guid idus = (Guid)Session["ids"]; if (db.karmas.Where(g => g.UserId == (Guid)Session["ids"]).ToList().Count() == 0) { karma kk = new karma() { UserId = idus, detalle = "puntajes de karma", total = 1, fecha = DateTime.Now }; db.karmas.InsertOnSubmit(kk); db.SubmitChanges(); ViewBag.estado = 1; karma2 k = new karma2() { UserId = idus, idPublicacion = id }; db.karma2s.InsertOnSubmit(k); db.SubmitChanges(); } else { List<karma> karma = db.karmas.Where(g => g.UserId == idus).ToList(); double j = 0; foreach (var u in karma) { double h = u.total; j = h + 1; } var l = db.karmas.Where(ll => ll.UserId == idus); karma ka = new karma() { UserId = idus, detalle = "puntaje", total = j, fecha = DateTime.Now }; l.ToArray()[0].UserId = idus; l.ToArray()[0].detalle = "puntaje"; l.ToArray()[0].total = j; l.ToArray()[0].fecha = DateTime.Now; db.SubmitChanges(); ViewBag.estado = 1; karma2 k = new karma2() { UserId = idus, idPublicacion = id }; db.karma2s.InsertOnSubmit(k); db.SubmitChanges(); } int i = id; if (db.libros.Where(v => v.idPublicacion == i).ToList().Count() != 0) { return RedirectToAction("Vlibro", "Home", new { id = id }); } if (db.cursos.Where(v => v.idPublicacion == i).ToList().Count() != 0) { return RedirectToAction("Vcurso", "Home", new { id = id }); } if (db.articulos.Where(v => v.idPublicacion == i).ToList().Count() != 0) { return RedirectToAction("Varticulo", "Home", new { id = id }); } if (db.tutorials.Where(v => v.idPublicacion == i).ToList().Count() != 0) { return RedirectToAction("Vtutorial", "Home", new { id = id }); } } else { ViewBag.estado = 0; ViewBag.id = id; System.Guid idus = (Guid)Session["ids"]; List<karma> karma = db.karmas.Where(g => g.UserId == idus).ToList(); double j = 0; foreach (var u in karma) { double h = u.total; j = h - 1; } var l = db.karmas.Where(ll => ll.UserId == idus); karma k = new karma() { UserId = idus, detalle = "puntaje", total = j, fecha = DateTime.Now }; l.ToArray()[0].UserId = idus; l.ToArray()[0].detalle = "puntaje"; l.ToArray()[0].total = j; l.ToArray()[0].fecha = DateTime.Now; db.SubmitChanges(); karma2 bk = db.karma2s.Where(r => r.UserId == idus).ToArray()[0]; db.karma2s.DeleteOnSubmit(bk); db.SubmitChanges(); int i = id; if (db.libros.Where(v => v.idPublicacion == i).ToList().Count() != 0) { return RedirectToAction("Vlibro", "Home", new { id = id }); } if (db.cursos.Where(v => v.idPublicacion == i).ToList().Count() != 0) { return RedirectToAction("Vcurso", "Home", new { id = id }); } if (db.articulos.Where(v => v.idPublicacion == i).ToList().Count() != 0) { return RedirectToAction("Varticulo", "Home", new { id = id }); } if (db.tutorials.Where(v => v.idPublicacion == i).ToList().Count() != 0) { return RedirectToAction("Vtutorial", "Home", new { id = id }); } } } else { return RedirectToAction("LogOn","Account"); } return RedirectToAction("Index","Home"); }