public override bool ValidateUser(string username, string password) { using (var db = new TS_Entities()) { return((from u in db.usuarios where (u.pass_usu == password && u.Nom_cor_usu == username && u.estado == true) select true).Any()); } }
public static void addToCacheUSER(string actualUser, string newUser) { try { using (var db = new TS_Entities()) { var user = (from u in db.usuarios where (u.estado == true) && (u.Nom_cor_usu == newUser) select u).FirstOrDefault(); var roles = db.perfil_usuario.Where(o => o.id_usuario == user.id_usu).ToList(); var n = USERS.FirstOrDefault(p => p.user.Nom_cor_usu == actualUser); n.user2 = user; n.roles2 = roles; } } catch (Exception ex) { } }
public override MembershipUser GetUser(string username, bool userIsOnline) { USERS.RemoveAll(p => p.SessionExpires.AddHours(2) < DateTime.Now); var _user = USERS.FirstOrDefault(p => p.user.Nom_cor_usu == username); if (_user != null && _user.SessionExpires >= DateTime.Now) { var u = _user; return(_user.user2 == null? new UsuarioMembership(u.user, u.roles): new UsuarioMembership(u.user2, u.roles2)); } using (var db = new TS_Entities()) { usuarios user; usuarios user2 = null; List <perfil_usuario> roles; List <perfil_usuario> roles2 = null; user = (from u in db.usuarios where (u.estado == true) && (u.Nom_cor_usu == username) select u).FirstOrDefault(); roles = db.perfil_usuario.Where(o => o.id_usuario == user.id_usu).ToList(); if (_user?.user2?.Nom_cor_usu != null) { user2 = (from u in db.usuarios where (u.estado == true) && (u.Nom_cor_usu == _user.user2.Nom_cor_usu) select u).FirstOrDefault(); roles2 = db.perfil_usuario.Where(o => o.id_usuario == _user.user2.id_usu).ToList(); } SessionUser sessionUser = new SessionUser() { user = user, user2 = user2, roles = roles, roles2 = roles2, SessionExpires = DateTime.Now.AddMinutes(5) }; deleteFromCacheUSER(sessionUser.user.id_usu); USERS.Add(sessionUser); return(sessionUser.user2 == null? (sessionUser.user == null ? null : new UsuarioMembership(sessionUser.user, sessionUser.roles)): new UsuarioMembership(sessionUser.user2, sessionUser.roles2)); } }
public MasterController() { _db = new TS_Entities(); CustomHelper = new CustomHelper(_db); }
public CustomHelper(TS_Entities _db) { this._db = _db; }