public static bool esEncargado() { int IdUsuario = SessionHelper.GetIdUser(); var _responsable = new responsable(); try { using (var ctx = new inventarioContext()) { _responsable = ctx.responsable .Where(x => x.IdUsuario == IdUsuario) .Where(x => x.Encargado == 1) .SingleOrDefault(); } if (_responsable != null) { return(true); } else { return(false); } } catch (Exception) { throw; } }
public static int ObtenerArea(int IdUsuario) { int area; var modelResponsable = new responsable(); try { using (var ctx = new inventarioContext()) { modelResponsable = ctx.responsable .Where(x => x.IdUsuario == IdUsuario) .SingleOrDefault(); } if (modelResponsable != null) { area = (int)modelResponsable.IdArea; } else { area = -100; } } catch (Exception) { throw; } return(area); }
public static int ObtenerIdResponsableUsuario(int IdUsuario) { int _IdUsuario; var modelResponsable = new responsable(); try { using (var ctx = new inventarioContext()) { modelResponsable = ctx.responsable .Where(x => x.IdUsuario == IdUsuario) //.Where(x => x.Encargado == 1) .FirstOrDefault(); } if (modelResponsable != null) { _IdUsuario = (int)modelResponsable.IdResponsable; } else { _IdUsuario = -1; } } catch (Exception) { throw; } return(_IdUsuario); }
public static bool esAutorizador() { var responsable = new responsable(); int idResponsable = responsable.obtenerResponsableporIdusuario(SessionHelper.GetIdUser()).IdResponsable; AutorizadorTarea autorizador = new AutorizadorTarea(); try { using (var ctx = new inventarioContext()) { autorizador = ctx.AutorizadorTarea.Where(x => x.estado == 1) .Where(x => x.IdResponsable == idResponsable) .Include(x => x.responsable.usuariosSistema) .FirstOrDefault(); } if (autorizador != null) { return(true); } else { return(false); } } catch (Exception e) { throw; } }
public void EliminarResponsablesArea() //eliminar reponsables de area excepto el encargado { var responsable = new responsable(); //int idResponsable = responsable.ObtenerIdResponsable(this.idarea); string sql; try { using (var ctx = new inventarioContext()) { sql = "DELETE FROM dbo.TareaResponsable WHERE idTarea = " + this.idtarea; ctx.Database.ExecuteSqlCommand(sql); } } catch (Exception e) { throw; } //return rm; }
public responsable obtenerResponsableporIdusuario(int IdUsuario) { var modelResponsable = new responsable(); try { using (var ctx = new inventarioContext()) { modelResponsable = ctx.responsable .Include(x => x.areas) .Where(x => x.IdUsuario == IdUsuario) .FirstOrDefault(); } } catch (Exception) { throw; } return(modelResponsable); }
public List <responsable> obtenerResposables(int IdArea) { List <responsable> _responsables; var modelResponsable = new responsable(); try { using (var ctx = new inventarioContext()) { _responsables = ctx.responsable .Where(x => x.IdArea == IdArea) .Where(x => x.Encargado == 1) .OrderByDescending(x => x.IdUsuario) .ToList(); } } catch (Exception) { throw; } return(_responsables); }
public int ObtenerIdResponsable(int IdArea) { int IdResponsable; var modelResponsable = new responsable(); try { using (var ctx = new inventarioContext()) { modelResponsable = ctx.responsable .Where(x => x.IdArea == IdArea) .Where(x => x.Encargado == 1) .OrderByDescending(x => x.IdUsuario) .FirstOrDefault(); } IdResponsable = (int)modelResponsable.IdResponsable; } catch (Exception) { throw; } return(IdResponsable); }