protected bool Update(PersistedCredential cred, DateTime validFrom, DateTime validTo)
{
if (cred != null)
{
return(Update(cred, validFrom, validTo, cred.IsLocked));
}
return(false);
}
protected bool Update(PersistedCredential cred, bool isLocked)
{
if (cred != null)
{
cred.IsLocked = isLocked;
return(true);
}
return(false);
}
protected bool Expire(PersistedCredential cred)
{
if (cred != null)
{
cred.ValidTo = DateTime.Now;
return(true);
}
return(false);
}
protected bool Lock(PersistedCredential cred)
{
if (cred != null)
{
cred.IsLocked = true;
return(true);
}
return(false);
}
//\"Id\", \"OwnerType\", \"Payload\", \"Token\", \"IsLocked\", \"ValidFrom\", \"ValidTo\"
internal PersistedCredential Create(NpgsqlDataReader rdr)
{
Guid id = DbReaderUtils.GetGuid(rdr, 0);
if (!Guid.Empty.Equals(id))
{
PersistedCredential cred = this.Create(id, DbReaderUtils.GetString(rdr, 2), DbReaderUtils.GetString(rdr, 3), DbReaderUtils.GetDate(rdr, 5), DbReaderUtils.GetDate(rdr, 6));
this.Update(cred, DbReaderUtils.GetBoolean(rdr, 4));
return(cred);
}
return(null);
}
protected PersistedCredential Create(Guid userId, byte[] payload, byte[] token, DateTime validFrom, DateTime validTo)
{
PersistedCredential cred = new PersistedCredential(userId, payload, token);
cred.ValidFrom = validFrom;
if (validTo >= validFrom)
{
cred.ValidTo = validTo;
}
else
{
cred.ValidTo = validFrom;
}
return(cred);
}
protected bool Update(PersistedCredential cred, DateTime validFrom, DateTime validTo, bool isLocked)
{
if (cred != null)
{
cred.IsLocked = isLocked;
cred.ValidFrom = validFrom;
if (validTo >= validFrom)
{
cred.ValidTo = validTo;
}
else
{
cred.ValidTo = validFrom;
}
return(true);
}
return(false);
}
public bool Lock(IAuthenticationProvider provider, PersistedCredential credential)
{
if (provider != null && credential != null)
{
try
{
NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
cmd.CommandText = Db.Lock + "AND \"OwnerType\"=:oType AND \"Token\"=:token";
cmd.Parameters.AddWithValue("id", credential.UserId);
cmd.Parameters.AddWithValue("oType", TypeNameReference.Create(provider).ToString());
cmd.Parameters.AddWithValue("token", credential.TextToken);
Db.ExecuteNonQuery(cmd);
return(true);
}
catch
{ }
}
return(false);
}
public bool UpdateCredential(IAuthenticationProvider provider, PersistedCredential credential, DateTime validFrom, DateTime validTo, bool isLocked)
{
if (provider != null && credential != null)
{
try
{
NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
cmd.CommandText = Db.Update;
cmd.Parameters.AddWithValue("id", credential.UserId);
cmd.Parameters.AddWithValue("oType", TypeNameReference.Create(provider).ToString());
cmd.Parameters.AddWithValue("token", credential.TextToken);
cmd.Parameters.AddWithValue("dateFrom", validFrom);
cmd.Parameters.AddWithValue("dateTo", validTo);
cmd.Parameters.AddWithValue("locked", isLocked);
Db.ExecuteNonQuery(cmd);
return(true);
}
catch
{ }
}
return(false);
}
public bool UpdateCredential(IAuthenticationProvider provider, PersistedCredential credential, DateTime validFrom, DateTime validTo)
{
return(UpdateCredential(provider, credential, validFrom, validTo, credential.IsLocked));
}
public bool UpdateCredential(IAuthenticationProvider provider, PersistedCredential credential, bool isLocked)
{
return(UpdateCredential(provider, credential, credential.ValidFrom, credential.ValidTo, isLocked));
}
