public ParticipacionStats(user user) { var db = new edayRoomEntities(); int conteo = user.admin ? db.Participacions.Where(p => p.active).Sum(p => p.conteo) : (from p in db.Participacions from ap in db.AsignacionParticipacions where p.active && p.id_mesa == ap.id_mesa && ap.id_user == user.id select p).Sum(p => p.conteo); /* _centros = user.admin? db.Centroes.Count(): (from m in db.Mesas from ap in db.AsignacionParticipacions where m.id == ap.id_mesa select m.id_centro).Distinct().Count(); _mesas = user.admin ? db.Mesas.Count() : (from m in db.Mesas from ap in db.AsignacionParticipacions where m.id == ap.id_mesa select m).Count();*/ _participacion = conteo; //_movilizacion = db.Movilizacions.Where(p => p.active).Sum(p => p.conteo); }
public MovilizacionStats(user user) { var db = new edayRoomEntities(); _centros = db.AsignacionMovilizacions.Count(am=>am.id_user == user.id); _mesas = (from m in db.Mesas from c in db.Centroes from am in db.AsignacionMovilizacions where m.id_centro == c.id && am.id_centro == c.id && am.id_user == user.id select m ).Count(); _movilizacion = db.AsignacionMovilizacions.Where(m => m.id_user == user.id).Sum(c => c.Centro.Movilizacions.Max(m=>m.conteo)); }
/// <summary> /// Create a new user object. /// </summary> /// <param name="id">Initial value of the id property.</param> /// <param name="username">Initial value of the username property.</param> /// <param name="nombre">Initial value of the nombre property.</param> /// <param name="apellido">Initial value of the apellido property.</param> /// <param name="salt">Initial value of the salt property.</param> /// <param name="hash">Initial value of the hash property.</param> /// <param name="admin">Initial value of the admin property.</param> /// <param name="leader">Initial value of the leader property.</param> /// <param name="participacion">Initial value of the participacion property.</param> /// <param name="movilizacion">Initial value of the movilizacion property.</param> /// <param name="exitpolls">Initial value of the exitpolls property.</param> /// <param name="quickcount">Initial value of the quickcount property.</param> /// <param name="totalizacion">Initial value of the totalizacion property.</param> /// <param name="dashboard">Initial value of the dashboard property.</param> /// <param name="paused">Initial value of the paused property.</param> /// <param name="alertas">Initial value of the alertas property.</param> /// <param name="supervisor">Initial value of the supervisor property.</param> public static user Createuser(global::System.Int32 id, global::System.String username, global::System.String nombre, global::System.String apellido, global::System.String salt, global::System.String hash, global::System.Boolean admin, global::System.Boolean leader, global::System.Boolean participacion, global::System.Boolean movilizacion, global::System.Boolean exitpolls, global::System.Boolean quickcount, global::System.Boolean totalizacion, global::System.Boolean dashboard, global::System.Boolean paused, global::System.Boolean alertas, global::System.Boolean supervisor) { user user = new user(); user.id = id; user.username = username; user.nombre = nombre; user.apellido = apellido; user.salt = salt; user.hash = hash; user.admin = admin; user.leader = leader; user.participacion = participacion; user.movilizacion = movilizacion; user.exitpolls = exitpolls; user.quickcount = quickcount; user.totalizacion = totalizacion; user.dashboard = dashboard; user.paused = paused; user.alertas = alertas; user.supervisor = supervisor; return user; }
/// <summary> /// Deprecated Method for adding a new object to the users EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddTousers(user user) { base.AddObject("users", user); }
private void InitializeFromEntity(user u) { Nombre = u.nombre; Apellido = u.apellido; }
public Usuario(user u) { InitializeFromEntity(u); }