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