//User like to be in your RVK (id) public ActionResult RequestBelong(int id) { if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Maestro", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Estudiante", User.Identity.Name))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } try { Guid userid = new Guid(AspNetUsers.GetUserId(User.Identity.Name)); investicEntities db = new investicEntities(); tbNetVirtualUserGroup tbnetVirtualUserGroup = new tbNetVirtualUserGroup(); tbnetVirtualUserGroup.idNetVirtualUser = userid; tbnetVirtualUserGroup.idNetVirtualGroup = id; tbnetVirtualUserGroup.isOwner = false; tbnetVirtualUserGroup.StateUserAceptGroup = 4; db.tbNetVirtualUserGroup.Add(tbnetVirtualUserGroup); db.SaveChanges(); return(Json(new { rta = "Su solicitud ha sido enviada al creador de esta red." }, JsonRequestBehavior.AllowGet)); } catch (Exception) { return(Json(new { rta = "Wrong" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult ResetPassword(string code) { investicEntities db = new investicEntities(); var user = (from q in db.AspNetUsers where q.Id == code select new { q.Id }).FirstOrDefault(); return(user == null?View("Error") : View()); }
public ActionResult Datos(string Id_Contratista) { var usuario = AspNetUsers.Find(Id_Contratista); investicEntities db = new investicEntities(); var currentUser = User.Identity.GetUserId(); var equip = db.tblEquiposTrabajo.Where(x => x.Id_Coordinador.Equals(currentUser)); var carge = db.tblCargos.ToList(); var usuarios = db.AspNetUsers.ToList(); ViewBag.Equipo = new SelectList(equip, "Id_Equipo", "Nombre_Equipo"); ViewBag.Cargo = new SelectList(carge, "Id_Cargo", "Nombre_Cargo"); if (AspNetUsersRoles.IsUserInRole("Coordinador", User.Identity.Name)) { investicEntities db2 = new investicEntities(); var currentUser2 = User.Identity.GetUserId(); var algo = db2.tblEquiposTrabajo.Where(x => x.Id_Coordinador.Equals(currentUser2)); var carg = db2.tblCargos.ToList(); var usuarios2 = db2.AspNetUsers.ToList(); ViewBag.Equipo = new SelectList(algo, "Id_Equipo", "Nombre_Equipo"); ViewBag.Cargo = new SelectList(carg, "Id_Cargo", "Nombre_Cargo"); } return(View(usuario)); }
public async Task <ActionResult> ResetPassword(ResetPasswordViewModel model) { if (!ModelState.IsValid) { return(View(model)); } investicEntities db = new investicEntities(); var user = (from q in db.AspNetUsers where q.PersonalID == model.PersonalID select new { q.Email, q.Id }).FirstOrDefault(); if (user == null) { // Don't reveal that the user does not exist return(RedirectToAction("ResetPasswordConfirmation", "Usuario")); } var result = await UserManager.RemovePasswordAsync(user.Id); if (result.Succeeded) { UserManager.AddPassword(user.Id, model.Password); return(RedirectToAction("ResetPasswordConfirmation", "Usuario")); } else { return(View()); } }
//Editor aprove your RVK(id) request public ActionResult ChangeState(int id = 0) { if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Editor", User.Identity.Name))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } investicEntities db = new investicEntities(); try { var rvc = db.tbNetVirtualGroup.Find(id); if (rvc == null) { return(Json(new { rta = "Ocurrio un error inesperado" }, JsonRequestBehavior.AllowGet)); } rvc.state = true; var rvcug = rvc.tbNetVirtualUserGroup.Where(m => m.isOwner = true).FirstOrDefault(); if (rvcug == null) { return(Json(new { rta = "Ocurrio un error inesperado" }, JsonRequestBehavior.AllowGet)); } rvcug.StateUserAceptGroup = 1; db.Entry(rvc).State = System.Data.Entity.EntityState.Modified; db.Entry(rvcug).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(Json(new { rta = "La red ha sido aprobada." }, JsonRequestBehavior.AllowGet)); } catch (Exception) { return(Json(new { rta = "Ocurrio un error inesperado" }, JsonRequestBehavior.AllowGet)); } }
public static int GetRoleMiembro(string userId) { investicEntities db = new investicEntities(); var q = (from u in db.tblMiembroGrupo where u.idUsuario.Equals(userId) select u).First(); return(q.idRol); }
public static int GetIdInstitucion(string userId) { investicEntities db = new investicEntities(); var q = (from u in db.tblMaestroCoInvestigador where u.idUsuario.Equals(userId) select u).FirstOrDefault(); return(q.idInstitucion); }
public static bool Exist(string userId) { investicEntities db = new investicEntities(); var q = (from u in db.tblMaestroCoInvestigador where u.idUsuario.Equals(userId) select u).FirstOrDefault(); return(q != null); }
public static int ResearchGroupIdByUser(string UserId) { investicEntities cxt = new investicEntities(); var q = (from m in cxt.tblGrupoInvestigacion where m.idUsuario == UserId select m.id).SingleOrDefault(); return(q); }
public static bool ExistGroup(string UserId) { investicEntities cxt = new investicEntities(); var q = (from m in cxt.tblGrupoInvestigacion where m.idUsuario == UserId select m).SingleOrDefault(); return(q != null); }
public static tblGrupoInvestigacion FindByUserId(string userId) { investicEntities cxt = new investicEntities(); var q = (from m in cxt.tblGrupoInvestigacion where m.idUsuario.Equals(userId) select m).SingleOrDefault(); return(q); }
public static tblGrupoInvestigacion Find(int id) { investicEntities cxt = new investicEntities(); var q = (from m in cxt.tblGrupoInvestigacion where m.id == id select m).SingleOrDefault(); return(q); }
public static string GetMunicipalityInstitucion(string userId) { investicEntities db = new investicEntities(); var q = (from u in db.tblMaestroCoInvestigador where u.AspNetUsers.Id.Equals(userId) select u).FirstOrDefault(); return(q.tblInstitucion.tblMunicipios.NombreMunicipio); }
public static string GetRoleId(string roleName) { investicEntities db = new investicEntities(); var q = (from r in db.AspNetRoles where r.Name.Equals(roleName) select r).FirstOrDefault(); return(q.Id); }
public static bool IsUserInRole(string roleName, string userName) { investicEntities db = new investicEntities(); var userId = AspNetUsers.GetUserId(userName); var roleId = AspNetRoles.GetRoleId(roleName); var r = (from l in db.AspNetUserRoles where l.UserId.Equals(userId) && l.RoleId.Equals(roleId) select l).FirstOrDefault(); return(r != null); }
public ActionResult OffLine(int code = 0) { investicEntities db = new investicEntities(); var cadenaxml = db.GeneradorConsultaSQLAXML("16306").ToList(); string rutaXML = @"D:\SQLAXML.xml"; System.IO.File.WriteAllText(rutaXML, (cadenaxml[0] != null && cadenaxml[0].ToString() != string.Empty) ? cadenaxml[0].ToString() : "No tiene Registro XML"); ViewBag.Mensaje = dl.ErrorCodes.ErrorCodeToString(code); return(View()); }
public static AspNetUsers Find(string UserId) { investicEntities db = new investicEntities(); var q = (from u in db.AspNetUsers where u.Id.Equals(UserId) select u).FirstOrDefault(); if (q != null) { return(q); } return(null); }
public static int GetRoleMiembro(string userId, int idGrupo) { investicEntities db = new investicEntities(); var q = (from u in db.tblMiembroGrupo where u.idUsuario.Equals(userId) && u.idGrupoInvestigacion.Equals(idGrupo) select u).First(); //var q = (from u in db.tblMiembroGrupo // where u.idUsuario.Equals(userId) && u.idGrupoInvestigacion.Equals(idGrupo) // select u).First(); return(q.idRol); }
public static string GetName(string userName) { investicEntities db = new investicEntities(); var q = (from u in db.AspNetUsers where u.UserName.Equals(userName) select u).FirstOrDefault(); if (q != null) { return(string.Format("{0} {1}", q.Name, q.SureName)); } return(""); }
public static string GetUserId(string userName) { investicEntities db = new investicEntities(); var q = (from u in db.AspNetUsers where u.UserName.Equals(userName) select new { u.Id }).FirstOrDefault(); if (q != null) { return(q.Id); } return(""); }
public static string GetNameById(Guid id) { investicEntities db = new investicEntities(); string ids = id.ToString(); var q = (from u in db.AspNetUsers where u.Id == ids select new { u.Name, u.SureName }).FirstOrDefault(); if (q != null) { return(string.Format("{0} {1}", q.Name, q.SureName)); } return(""); }
public static List <AspNetUsers> GetUsersInRole(string rol) { investicEntities db = new investicEntities(); List <AspNetUsers> users = new List <AspNetUsers>(); var idRol = AspNetRoles.GetRoleId(rol); var usuarios = db.AspNetUserRoles.Where(m => m.RoleId.Equals(idRol)).Select(m => m.UserId).Take(10); foreach (string item in usuarios) { users.Add(AspNetUsers.Find(item)); } return(users); }
public static List <string> GetRoles(string Iduser) { investicEntities db = new investicEntities(); var r = (from l in db.AspNetUserRoles where l.UserId.Equals(Iduser) select l.AspNetRoles.Name); return(r.ToList()); //var q = (from u in db.AspNetUsers // where u.UserName.Equals(userName) // select u).First(); //return q.Id; }
public ActionResult Salir() { investicEntities db = new investicEntities(); var idUser = User.Identity.Name; tblLogAcceso tbllogAcceso = (from m in db.tblLogAcceso where m.Usuario == idUser orderby m.FechaInicioSesion descending select m).Take(1).FirstOrDefault(); tbllogAcceso.FechaCierreSesion = System.DateTime.Now; db.Entry(tbllogAcceso).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); AuthenticationManager.SignOut(); return(Redirect("http://investic.udenar.edu.co/chamilolms/closessn.php?logout=logout&uid=0")); }
public static List <AspNetUsers> UserNotInGroup(long id) { investicEntities cxt = new investicEntities(); var UsuariosEnGrupo = cxt.tblIntegrantesGrupoInv.Where(m => m.tblGruposInvestigacion_ID == id); var UsuariosMaestros = AspNetUsers.GetUsersInRole("Maestro"); var Usuarios = from u in UsuariosMaestros where !(from ug in UsuariosEnGrupo select ug.tblUsuarioPlataforma_ID).Contains(u.Id) select u; return(Usuarios.ToList()); }
public static List <AspNetUsers> UserStudentNotInGroup(int id) { investicEntities cxt = new investicEntities(); //List<AspNetUsers> Usuarios = new List<AspNetUsers>(); var UsuariosEnGrupo = cxt.tblMiembroGrupo.Where(m => m.idGrupoInvestigacion == id); var UsuariosMaestros = AspNetUsers.GetUsersInRole("Estudiante"); var Usuarios = from u in UsuariosMaestros where !(from ug in UsuariosEnGrupo select ug.idUsuario).Contains(u.Id) select u; return(Usuarios.ToList()); }
// GET: RVC public ActionResult Index() { if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Maestro", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Estudiante", User.Identity.Name))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } investicEntities db = new investicEntities(); Guid userid = new Guid(AspNetUsers.GetUserId(User.Identity.Name)); int n = db.tbNetVirtualUserGroup.Where(m => m.idNetVirtualUser == userid && (m.StateUserAceptGroup == 1 || m.StateUserAceptGroup == 2)).Count(); if (n == 0) { return(View()); } else { return(RedirectToAction("Index", "tbNetVirtualGroups")); } }
public ActionResult Aprobar() { if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Editor", User.Identity.Name))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } investicEntities db = new investicEntities(); var Peticionrvc = from q in db.tbNetVirtualUserGroup where q.isOwner == true && q.tbNetVirtualGroup.state == false select new RedVirtualGrupoOwner { id = q.idNetVirtualGroup, Name = q.tbNetVirtualGroup.name, State = q.tbNetVirtualGroup.state, IsOwner = q.isOwner, CreateDate = q.tbNetVirtualGroup.createDate.Value }; return(View(Peticionrvc)); }
public ActionResult AttachmentUser() { if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Maestro", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Estudiante", User.Identity.Name))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } investicEntities db = new investicEntities(); Guid userid = new Guid(AspNetUsers.GetUserId(User.Identity.Name)); int nu = db.tbNetVirtualUser.Where(m => m.id == userid).Count(); if (nu == 0) { db.tbNetVirtualUser.Add(new tbNetVirtualUser() { id = userid, state = true }); db.SaveChanges(); } return(RedirectToAction("Index", "tbNetVirtualGroups")); }
public async Task <ActionResult> ForgotPassword(ForgotPasswordViewModel model) { if (ModelState.IsValid) { //var user = await UserManager.FindByEmailAsync(model.Email); investicEntities db = new investicEntities(); var user = (from q in db.AspNetUsers where q.PersonalID == model.PersonalID select new { q.Email, q.Id }).FirstOrDefault(); if (user == null) { // Don't reveal that the user does not exist or is not confirmed return(View("IniciarSesion")); } // For more information on how to enable account confirmation and password reset please visit http://go.microsoft.com/fwlink/?LinkID=320771 // Send an email with this link var callbackUrl = Url.Action("ResetPassword", "Usuario", new { code = user.Id }, protocol: Request.Url.Scheme); var m = new MailMessage( new MailAddress("*****@*****.**", "Registro Plataforma Investic"), new MailAddress(user.Email)); m.Subject = "Plataforma Investic - Cambiar contraseña"; m.Body = string.Format("Para cambiar contraseña haga click <a href='{0}'>aquí!</a>", callbackUrl); m.IsBodyHtml = true; var smtp = new SmtpClient("smtp.gmail.com"); smtp.Credentials = new NetworkCredential("*****@*****.**", "Investic666"); smtp.EnableSsl = true; smtp.Send(m); return(RedirectToAction("ForgotPasswordConfirmation", "Usuario")); } // If we got this far, something failed, redisplay form return(View(model)); }