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());
}
