/// <summary> /// Gets the security token. /// </summary> /// <param name="userId">The user id.</param> /// <returns>Security Token</returns> public XareuServices.Model.SecurityToken.SecurityToken GetSecurityToken(long userId) { try { data.Connection.Open(); var query = from tokens in data.tokens where tokens.user_id == userId select tokens; return(this.getSecurityToken(query.First <token>())); } catch { data = new XareuDataClassesDataContext(Util.Configuration.GetConnectionString()); return(null); } finally { data.Connection.Close(); } }
/// <summary> /// Invalidates the security token. /// </summary> /// <param name="userId">The user id.</param> /// <returns>True if it was OK, false otherwise</returns> public bool InvalidateSecurityToken(long userId) { try { data.Connection.Open(); var query = from tokens in data.tokens where tokens.user_id == userId select tokens; query.First <token>().token_was_used = true; data.SubmitChanges(); return(true); } catch { data = new XareuDataClassesDataContext(Util.Configuration.GetConnectionString()); return(false); } finally { data.Connection.Close(); } }
/// <summary> /// Gets the new security token. /// </summary> /// <param name="userId">The user id.</param> /// <returns>Guid</returns> public Guid GetNewSecurityToken(long userId) { try { data.Connection.Open(); var query = from tokens in data.tokens where tokens.user_id == userId select tokens; Guid newGuid = Guid.NewGuid(); token newToken = query.First <token>(); newToken.token1 = newGuid; newToken.token_was_used = false; data.SubmitChanges(); return(newGuid); } catch { try { token newToken = new token(); newToken.user_id = userId; newToken.token_was_used = false; newToken.token1 = Guid.NewGuid(); data.tokens.InsertOnSubmit(newToken); data.SubmitChanges(); return(newToken.token1); } catch { data = new XareuDataClassesDataContext(Util.Configuration.GetConnectionString()); return(Guid.Empty); } } finally { data.Connection.Close(); } }
/// <summary> /// Añade un nuevo usuario a la base de datos /// </summary> /// <param name="user">Datos del usuario a añadir</param> /// <param name="userID"></param> /// <returns> /// True si se pudo añadir, false en caso contrario /// </returns> public bool AddNewUser(XareuServices.Model.User.User user, out long userID) { userID = 0; try { data.Connection.Open(); Linq.user newUser = this.convertToUser(user); data.users.InsertOnSubmit(newUser); data.SubmitChanges(); userID = this.getLastInsertedUserID(); return(true); } catch { data = new XareuDataClassesDataContext(Util.Configuration.GetConnectionString()); return(false); } finally { data.Connection.Close(); } }
/// <summary> /// Initializes a new instance of the <see cref="UserDAO"/> class. /// </summary> public UserDAO() { data = new XareuDataClassesDataContext(Util.Configuration.GetConnectionString()); }
/// <summary> /// Initializes a new instance of the <see cref="TagsUsersSubscriptionsDAO"/> class. /// </summary> public TagsUsersSubscriptionsDAO() { data = new XareuDataClassesDataContext(Util.Configuration.GetConnectionString()); }
/// <summary> /// Initializes a new instance of the <see cref="GroupUserSubscriptionDAO"/> class. /// </summary> public GroupUserSubscriptionDAO() { data = new XareuDataClassesDataContext(Util.Configuration.GetConnectionString()); }
/// <summary> /// Initializes a new instance of the <see cref="PlaceTagInPublicationDAO"/> class. /// </summary> public PlaceTagInPublicationDAO() { data = new XareuDataClassesDataContext(Util.Configuration.GetConnectionString()); }
/// <summary> /// Initializes a new instance of the <see cref="GroupJoinRequestDAO"/> class. /// </summary> public GroupJoinRequestDAO() { data = new XareuDataClassesDataContext(Util.Configuration.GetConnectionString()); }