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