public ActionResult Create([Bind(Include = "tblFechaCronograma_ID,tblCronogramaProy_ID,cro_Actividad,cro_FechaInicio,cro_FechaFin,cro_Indicador")] tblFechaCronograma tblFechaCronograma) { if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Maestro", User.Identity.Name))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } if (ModelState.IsValid) { db.tblFechaCronograma.Add(tblFechaCronograma); db.SaveChanges(); return(RedirectToAction("Edit", new { id = tblFechaCronograma.tblCronogramaProy_ID })); } ViewBag.tblCronogramaProy_ID = new SelectList(db.tblCronogramaProy, "tblCronogramaProy_ID", "tblCronogramaProy_ID", tblFechaCronograma.tblCronogramaProy_ID); return(View(tblFechaCronograma)); }
public ActionResult CreatePresupuesto([Bind(Include = "tblRubroPresupuesto_ID,tblPresupuestoProy_ID,tblRubro_ID,rubPre_valor,rubPre_fuente,rubPre_justificacion")] tblRubroPresupuesto tblRubroPresupuesto) { if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Maestro", User.Identity.Name))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } if (ModelState.IsValid) { var miProyecto = db.tblProyectosInvestigacion.Where(t => t.tblPresupuestoProy_ID == tblRubroPresupuesto.tblPresupuestoProy_ID); if (miProyecto == null) { return(HttpNotFound()); } else { if (!(tblRubroPresupuesto.rubPre_fuente == null || tblRubroPresupuesto.rubPre_justificacion == null || tblRubroPresupuesto.rubPre_valor.Equals("0"))) { db.tblRubroPresupuesto.Add(tblRubroPresupuesto); db.SaveChanges(); return(RedirectToAction("EditarProyecto", "ProyectosInvestigacion", new { id = miProyecto.FirstOrDefault().tblProyectosInvestigacion_ID })); } else { return(RedirectToAction("EditarProyecto", "ProyectosInvestigacion", new { id = miProyecto.FirstOrDefault().tblProyectosInvestigacion_ID })); } } } ViewBag.tblRubro_ID = new SelectList(db.tblRubro, "tblRubro_ID", "rub_nombre", tblRubroPresupuesto.tblRubro_ID); return(View(tblRubroPresupuesto)); }
public ActionResult InformeProyecto(long?id) //Recibe el id del proyecto para presentar el informe final { if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Maestro", User.Identity.Name))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblProyectosInvestigacion miProyecto = db.tblProyectosInvestigacion.Find(id); if (miProyecto == null) { return(HttpNotFound()); } return(View(miProyecto)); }
public ActionResult Edit([Bind(Include = "id,name,description")] tbNetVirtualGroup tbNetVirtualGroup) { if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Maestro", User.Identity.Name))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ViewBag.ControllerName = "tbNetVirtualGroups"; if (ModelState.IsValid) { var q = (from m in db.tbNetVirtualGroup where m.id == tbNetVirtualGroup.id select new { m.createDate, m.photo, m.JsonMetadata }).FirstOrDefault(); if (q != null) { tbNetVirtualGroup.createDate = q.createDate; tbNetVirtualGroup.photo = q.photo; tbNetVirtualGroup.JsonMetadata = q.JsonMetadata; } List <FileMetaData> mdfiles = JsonConvert.DeserializeObject <List <FileMetaData> >(tbNetVirtualGroup.JsonMetadata); DateTime dn = System.DateTime.Now; foreach (string item in Request.Files) { HttpPostedFileBase file = Request.Files[item] as HttpPostedFileBase; int length = file.ContentLength; if (length > 0 && file != null) { byte[] buffer = new byte[length]; file.InputStream.Read(buffer, 0, length); PropertyInfo propInfo = typeof(tbNetVirtualGroup).GetProperty(item); propInfo.SetValue(tbNetVirtualGroup, buffer); FileMetaData fmd = mdfiles.Find(m => m.FileId == item); fmd.ModifiedOn = System.DateTime.Now; fmd.ContentType = file.ContentType; fmd.Size = length / 1024; } } tbNetVirtualGroup.JsonMetadata = JsonConvert.SerializeObject(mdfiles); db.Entry(tbNetVirtualGroup).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tbNetVirtualGroup)); }
public ActionResult DeleteConfirmed(int id) { if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Maestro", User.Identity.Name))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ViewBag.ControllerName = "tbNetVirtualGroups"; tbNetVirtualGroup tbNetVirtualGroup = db.tbNetVirtualGroup.Find(id); db.tbNetVirtualGroup.Remove(tbNetVirtualGroup); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Seleccionar() { if (AspNetUsersRoles.IsUserInRole("Administrador", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Coordinador", User.Identity.Name)) { var currentUser = User.Identity.GetUserId(); int equipo = (from e in db.tblEquiposTrabajo where e.Id_Coordinador.Equals(currentUser) select e.Id_Equipo).SingleOrDefault(); string idequipo = equipo.ToString(); List <AspNetUsers> usuarios = db.AspNetUsers.Where(x => x.Equipo.Equals(idequipo)).ToList(); ViewBag.Id_Contratista = new SelectList(usuarios, "Id", "LastName"); return(View()); } else { return(RedirectToAction("IniciarSesion", "Usuario")); } }
public ActionResult Create([Bind(Include = "id,name,description")] tbNetVirtualGroup tbNetVirtualGroup) { if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Maestro", User.Identity.Name))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ViewBag.ControllerName = "tbNetVirtualGroups"; if (ModelState.IsValid) { List <FileMetaData> mdfiles = new List <FileMetaData>(); DateTime dn = System.DateTime.Now; foreach (string item in Request.Files) { HttpPostedFileBase file = Request.Files[item] as HttpPostedFileBase; int length = file.ContentLength; if (length > 0 && file != null) { byte[] buffer = new byte[length]; file.InputStream.Read(buffer, 0, length); PropertyInfo propInfo = typeof(tbNetVirtualGroup).GetProperty(item); propInfo.SetValue(tbNetVirtualGroup, buffer); FileMetaData fmd = new FileMetaData() { FileId = item, CreatedOn = dn, ModifiedOn = dn, ContentType = file.ContentType, Size = length / 1024 }; mdfiles.Add(fmd); } } tbNetVirtualGroup.state = false; tbNetVirtualGroup.JsonMetadata = JsonConvert.SerializeObject(mdfiles); tbNetVirtualGroup.createDate = System.DateTime.Now; db.tbNetVirtualGroup.Add(tbNetVirtualGroup); //--------------------------------- Guid userid = new Guid(AspNetUsers.GetUserId(User.Identity.Name)); tbNetVirtualUserGroup nvug = new tbNetVirtualUserGroup(); nvug.idNetVirtualGroup = tbNetVirtualGroup.id; nvug.idNetVirtualUser = userid; nvug.isOwner = true; nvug.StateUserAceptGroup = 0; db.tbNetVirtualUserGroup.Add(nvug); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tbNetVirtualGroup)); }
//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)); } }
// 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 CrearGrupoInv() { if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Maestro", User.Identity.Name))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } //UserID var idUsuario = AspNetUsers.GetUserId(User.Identity.Name); AspNetUsers usuario = db.AspNetUsers.Find(idUsuario); ViewBag.tblUsuarioPlataforma_ID = idUsuario; return(View(usuario)); }
public ActionResult CrearGrupoInv([Bind(Include = "tblGruposInvestigacion_ID,tblUsuarioPlataforma_ID,gruInv_nombreGrupo,gruInv_emblema,tblEstado_ID")] tblGruposInvestigacion tblGruposInvestigacion) { if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Maestro", User.Identity.Name))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } if (ModelState.IsValid) { tblGruposInvestigacion.tblEstado_ID = 1; tblGruposInvestigacion.gruInv_fechaCreacion = DateTime.Now; try { //var idUsuario = AspNetUsers.GetUserId(User.Identity.Name); var idUsuario = tblGruposInvestigacion.tblUsuarioPlataforma_ID; string fileName = "imagen-no-disponible.jpg"; foreach (string file in Request.Files) { HttpPostedFileBase hpf = Request.Files[file] as HttpPostedFileBase; if (hpf.ContentLength == 0) { continue; } string folderPath = Server.MapPath("~/images/logo_Grupo/"); Directory.CreateDirectory(folderPath); string ext = Path.GetExtension(hpf.FileName); fileName = string.Format("img-{0}-{1}{2}", idUsuario, DateTime.Now.ToString("ddMMyyyyHHmmss"), ext); string savedFileName = folderPath + fileName; hpf.SaveAs(savedFileName); //tblGruposInvestigacion.gruInv_emblema = fileName; } tblGruposInvestigacion.gruInv_emblema = fileName; db.tblGruposInvestigacion.Add(tblGruposInvestigacion); db.SaveChanges(); return(RedirectToAction("MisGrupos", new { id = tblGruposInvestigacion.tblUsuarioPlataforma_ID })); } catch (Exception) { return(RedirectToAction("MisGrupos", new { id = tblGruposInvestigacion.tblUsuarioPlataforma_ID })); } } AspNetUsers usuario = db.AspNetUsers.Find(tblGruposInvestigacion.tblUsuarioPlataforma_ID); ViewBag.tblUsuarioPlataforma_ID = tblGruposInvestigacion.tblUsuarioPlataforma_ID; return(View(usuario)); }
// GET: GruposInvestigacions public ActionResult MisGrupos() { if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Maestro", User.Identity.Name))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } //UserID var idUsuario = AspNetUsers.GetUserId(User.Identity.Name); var misGrupos = (from t in db.tblGruposInvestigacion where t.tblUsuarioPlataforma_ID == idUsuario && t.tblEstado_ID == 1 select t).ToList(); ViewBag.tblUsuarioPlataforma_ID = idUsuario; return(View(misGrupos)); }
public ActionResult DetallesGrupo(long?id) //Id del grupo de investigacion { if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Maestro", User.Identity.Name))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblGruposInvestigacion grupo = db.tblGruposInvestigacion.Find(id); if (grupo == null) { return(HttpNotFound()); } //List<tblUsuarioPlataforma> futurosIntegrantes = new List<tblUsuarioPlataforma>(); //foreach (var item in db.tblUsuarioPlataforma) //{ // bool esIntegrante = false; // foreach (var item2 in grupo.tblIntegrantesGrupoInv) // { // if (item2.tblUsuarioPlataforma_ID == item.tblUsuarioPlataforma_ID) // { // esIntegrante = true; // break; // } // } // if (!esIntegrante) futurosIntegrantes.Add(item); //} ViewBag.tblUsuarioPlataforma_ID = grupo.tblUsuarioPlataforma_ID; //futurosIntegrantes.Remove(db.tblUsuarioPlataforma.Find(grupo.tblUsuarioPlataforma_ID)); //ViewBag.tblUsuarioPlataforma_ID = new SelectList(futurosIntegrantes, "tblUsuarioPlataforma_ID", "usuPla_identificacion"); //ViewBag.tblUsuarioPlataforma = db.tblUsuarioPlataforma.ToList(); return(View(grupo)); }
// GET: tblFechaCronogramas/Delete/5 public ActionResult Delete(long?id) { if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Maestro", User.Identity.Name))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblFechaCronograma tblFechaCronograma = db.tblFechaCronograma.Find(id); if (tblFechaCronograma == null) { return(HttpNotFound()); } return(View(tblFechaCronograma)); }
// GET: tbNetVirtualResources/Create public ActionResult Create() { if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Maestro", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Estudiante", User.Identity.Name))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ViewBag.ControllerName = "tbNetVirtualResources"; ViewBag.idCategory = new SelectList(db.tbNetVirtualCategoryResource, "id", "name"); return(View()); }
public ActionResult ChangeStateAplicant(int id = 0) { investicEntities db = new investicEntities(); Guid userid = new Guid(AspNetUsers.GetUserId(User.Identity.Name)); Guid idOwner = db.tbNetVirtualUserGroup.Where(m => m.idNetVirtualGroup == id && m.isOwner == true).Select(m => m.idNetVirtualUser).FirstOrDefault(); if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || (AspNetUsersRoles.IsUserInRole("Maestro", User.Identity.Name) && idOwner == userid))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } 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 = 2; 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 ActionResult Create([Bind(Include = "name,description,idCategory")] tbNetVirtualResource tbNetVirtualResource) { if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Maestro", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Estudiante", User.Identity.Name))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ViewBag.ControllerName = "tbNetVirtualResources"; Guid userid = new Guid(AspNetUsers.GetUserId(User.Identity.Name)); if (ModelState.IsValid) { List <FileMetaData> mdfiles = new List <FileMetaData>(); DateTime dn = System.DateTime.Now; foreach (string item in Request.Files) { HttpPostedFileBase file = Request.Files[item] as HttpPostedFileBase; int length = file.ContentLength; if (length > 0 && file != null) { byte[] buffer = new byte[length]; file.InputStream.Read(buffer, 0, length); PropertyInfo propInfo = typeof(tbNetVirtualResource).GetProperty(item); propInfo.SetValue(tbNetVirtualResource, buffer); FileMetaData fmd = new FileMetaData() { FileId = item, CreatedOn = dn, ModifiedOn = dn, ContentType = file.ContentType, Size = length / 1024 }; mdfiles.Add(fmd); } } tbNetVirtualResource.JsonMetadata = JsonConvert.SerializeObject(mdfiles); tbNetVirtualResource.idNetVirtualUser = userid; db.tbNetVirtualResource.Add(tbNetVirtualResource); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.idCategory = new SelectList(db.tbNetVirtualCategoryResource, "id", "name", tbNetVirtualResource.idCategory); return(View(tbNetVirtualResource)); }
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")); }
// GET: tbNetVirtualGroups/Create public ActionResult Create() { if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Maestro", User.Identity.Name))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ViewBag.ControllerName = "tbNetVirtualGroups"; return(View()); }
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)); }
// GET: tbNetVirtualGroups 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)); } ViewBag.ControllerName = "tbNetVirtualGroups"; Guid userid = new Guid(AspNetUsers.GetUserId(User.Identity.Name)); //StateUserAceptGroup 0 desactivado 1 mis redes 2 miembro de grupo 3 invitaciones 4 solicitantes //1 Mis redes var Misrvc = from q in db.tbNetVirtualUserGroup where q.idNetVirtualUser == userid && q.isOwner == true select new RedVirtualGrupoOtherUser { id = q.idNetVirtualGroup, Name = q.tbNetVirtualGroup.name, idUser = q.idNetVirtualUser, State = q.tbNetVirtualGroup.state, StateUserAceptGroup = q.StateUserAceptGroup, IsOwner = q.isOwner, CreateDate = q.tbNetVirtualGroup.createDate.Value }; //2 Redes a las que colaboras var rvcMiembro = (from q in db.tbNetVirtualUserGroup where q.idNetVirtualUser == userid && q.isOwner == false && q.tbNetVirtualGroup.state == true && q.StateUserAceptGroup == 2 select new RedVirtualGrupoOtherUser { id = q.idNetVirtualGroup, Name = q.tbNetVirtualGroup.name, State = q.tbNetVirtualGroup.state, StateUserAceptGroup = q.StateUserAceptGroup, IsOwner = q.isOwner, CreateDate = q.tbNetVirtualGroup.createDate.Value }).ToList(); foreach (var item in rvcMiembro) { item.idUser = db.tbNetVirtualUserGroup.Where(m => m.idNetVirtualGroup == item.id && m.isOwner == true).Select(m => m.idNetVirtualUser).FirstOrDefault(); } //3 Invitaciones var rvcInvitaciones = (from q in db.tbNetVirtualUserGroup where q.idNetVirtualUser == userid && q.isOwner == false && q.tbNetVirtualGroup.state == true && q.StateUserAceptGroup == 3 select new RedVirtualGrupoOtherUser { id = q.idNetVirtualGroup, Name = q.tbNetVirtualGroup.name, idUser = q.idNetVirtualUser, State = q.tbNetVirtualGroup.state, StateUserAceptGroup = q.StateUserAceptGroup, IsOwner = q.isOwner, CreateDate = q.tbNetVirtualGroup.createDate.Value }).ToList(); foreach (var item in rvcInvitaciones) { item.idUser = db.tbNetVirtualUserGroup.Where(m => m.idNetVirtualGroup == item.id && m.isOwner == true).Select(m => m.idNetVirtualUser).FirstOrDefault(); } //4 mis solicitudes var rvcRequesting = (from q in db.tbNetVirtualUserGroup where q.idNetVirtualUser == userid && q.isOwner == false && q.tbNetVirtualGroup.state == true && q.StateUserAceptGroup == 4 select new RedVirtualGrupoOtherUser { id = q.idNetVirtualGroup, Name = q.tbNetVirtualGroup.name, idUser = q.idNetVirtualUser, State = q.tbNetVirtualGroup.state, StateUserAceptGroup = q.StateUserAceptGroup, IsOwner = q.isOwner, CreateDate = q.tbNetVirtualGroup.createDate.Value }).ToList(); foreach (var item in rvcRequesting) { item.idUser = db.tbNetVirtualUserGroup.Where(m => m.idNetVirtualGroup == item.id && m.isOwner == true).Select(m => m.idNetVirtualUser).FirstOrDefault(); } //---------------- var lstcodemiem = rvcMiembro.Select(m => m.id).ToList(); var lstcodeinvs = rvcInvitaciones.Select(m => m.id).ToList(); var lstcodereq = rvcRequesting.Select(m => m.id).ToList(); var rvcOtros = from q in db.tbNetVirtualUserGroup where q.idNetVirtualUser != userid && q.isOwner == true && q.tbNetVirtualGroup.state == true && !lstcodeinvs.Contains(q.id) && !lstcodereq.Contains(q.id) && !lstcodemiem.Contains(q.id) select new RedVirtualGrupoOtherUser { id = q.idNetVirtualGroup, Name = q.tbNetVirtualGroup.name, idUser = q.idNetVirtualUser, State = q.tbNetVirtualGroup.state, StateUserAceptGroup = q.StateUserAceptGroup, IsOwner = q.isOwner, CreateDate = q.tbNetVirtualGroup.createDate.Value }; RVCTotal rvcTotal = new RVCTotal(); rvcTotal.Misrvc = Misrvc.ToList(); rvcTotal.rvcMiembro = rvcMiembro; rvcTotal.rvcInvitaciones = rvcInvitaciones; rvcTotal.rvcSolicitudes = rvcRequesting; rvcTotal.rvcOtros = rvcOtros.ToList(); //rvcTotal.redVirtualGrupoOtherUser = otrosgrupos.ToList(); return(View(rvcTotal)); }
//JSON REQUEST //User acept your Request to RVK(id) for invitation (id is the group) public ActionResult AceptRequest(int id) { if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Maestro", User.Identity.Name))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Guid userid = new Guid(AspNetUsers.GetUserId(User.Identity.Name)); investicEntities db = new investicEntities(); try { var rvc = db.tbNetVirtualUserGroup.Where(m => m.idNetVirtualUser == userid && m.idNetVirtualGroup == id).FirstOrDefault(); rvc.StateUserAceptGroup = 2; db.Entry(rvc).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(Json(new { rta = "Ahora perteneces a la RVC" }, JsonRequestBehavior.AllowGet)); } catch (Exception) { return(Json(new { rta = "Ha ocurrido un error inesperado" }, JsonRequestBehavior.AllowGet)); } }
// GET: tbNetVirtualGroups/Delete/5 public ActionResult Delete(int?id) { if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Maestro", User.Identity.Name))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ViewBag.ControllerName = "tbNetVirtualGroups"; if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbNetVirtualGroup tbNetVirtualGroup = db.tbNetVirtualGroup.Find(id); if (tbNetVirtualGroup == null) { return(HttpNotFound()); } return(View(tbNetVirtualGroup)); }
// GET: tbNetVirtualResources/Edit/5 public ActionResult Edit(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)); } ViewBag.ControllerName = "tbNetVirtualResources"; if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbNetVirtualResource tbNetVirtualResource = db.tbNetVirtualResource.Find(id); if (tbNetVirtualResource == null) { return(HttpNotFound()); } tbNetVirtualResource.resource = null; ViewBag.idCategory = new SelectList(db.tbNetVirtualCategoryResource, "id", "name", tbNetVirtualResource.idCategory); return(View(tbNetVirtualResource)); }
// GET: RubrosPresupuesto/Create public ActionResult CreatePresupuesto(long?id) { if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Maestro", User.Identity.Name))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblPresupuestoProy miPresupuesto = db.tblPresupuestoProy.Find(id); tblRubroPresupuesto nuevoRubro = new tblRubroPresupuesto(); nuevoRubro.tblPresupuestoProy = miPresupuesto; ViewBag.tblRubro_ID = new SelectList(db.tblRubro, "tblRubro_ID", "rub_nombre"); return(View(nuevoRubro)); }
// GET: tbNetVirtualResources 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)); } ViewBag.ControllerName = "tbNetVirtualResources"; Guid userid = new Guid(AspNetUsers.GetUserId(User.Identity.Name)); var tbNetVirtualResource = db.tbNetVirtualResource.Where(m => m.idNetVirtualUser == userid); return(View(tbNetVirtualResource.ToList())); }
public ActionResult Index()//recibe el id del grupo de investigacion { if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Maestro", User.Identity.Name))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var idUsuario = AspNetUsers.GetUserId(User.Identity.Name); tblGruposInvestigacion miGrupo = (from q in db.tblGruposInvestigacion where q.tblUsuarioPlataforma_ID == idUsuario select q).FirstOrDefault(); if (miGrupo == null) { return(RedirectToAction("CrearGrupoInv", "GruposInvestigacion")); } return(View(miGrupo)); }
// GET: tbNetVirtualResources/Details/5 public ActionResult Details(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)); } ViewBag.ControllerName = "tbNetVirtualResources"; if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbNetVirtualResource tbNetVirtualResource = db.tbNetVirtualResource.Find(id); if (tbNetVirtualResource == null) { return(HttpNotFound()); } return(View(tbNetVirtualResource)); }
public ActionResult InformeProyecto([Bind(Include = "tblProyectoInvestigacion_ID")] tblProyectosInvestigacion tblProyectosInvestigacion) { if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Maestro", User.Identity.Name))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } if (ModelState.IsValid) { tblProyectosInvestigacion.tblEstado_ID = 7; //Finalizado, Listo para revision db.Entry(tblProyectosInvestigacion).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Proyectos", "ProyectosInvestigacion", new { id = tblProyectosInvestigacion.tblGruposInvestigacion_ID })); } return(RedirectToAction("Proyectos", "ProyectosInvestigacion", new { id = tblProyectosInvestigacion.tblGruposInvestigacion_ID })); }
// GET: tblFechaCronogramas/Create public ActionResult Create() { if (!(AspNetUsersRoles.IsUserInRole("Administrator", User.Identity.Name) || AspNetUsersRoles.IsUserInRole("Maestro", User.Identity.Name))) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ViewBag.tblCronogramaProy_ID = new SelectList(db.tblCronogramaProy, "tblCronogramaProy_ID", "tblCronogramaProy_ID"); return(View()); }