public void LogAsync(InternalQualifier qualifier) { lock(_tmpQualifiers) _tmpQualifiers.Add(new TemporaryQualifier(qualifier, DateTime.Now)); }
public bool Equals(InternalQualifier other) { if (ReferenceEquals(null, other)) return false; if (ReferenceEquals(this, other)) return true; return other.PartId == PartId && other.LocaleId == LocaleId && Equals(_lowerKey, other._lowerKey); }
public DBValue(long partId, int localeId, String key, String content) { Qualifier = new InternalQualifier(partId, localeId, key); Content = content; }
public void Update(InternalQualifier qualifier, string value, Connector connector) { var connection = connector.Connection; if (connection.State != ConnectionState.Open) connection.Open(); if (_valuesByQualifier[qualifier].Content.Equals(value)) return; _valuesByQualifier[qualifier].Content = value; var command = new SqlCommand(String.Format( "update {0} set {1} = @content where {2} = @part and {3} = @locale and {4} = @key", _table, ContentColumn, PartIdColumn, LocaleIdColumn, KeyColumn ), connection ); command.Parameters.Add(new SqlParameter("content", SqlDbType.VarChar) {Value = value}); command.Parameters.Add(new SqlParameter("part", SqlDbType.BigInt) {Value = qualifier.PartId}); command.Parameters.Add(new SqlParameter("locale", SqlDbType.Int) { Value = qualifier.LocaleId }); command.Parameters.Add(new SqlParameter("key", SqlDbType.VarChar) { Value = qualifier.Key }); command.ExecuteNonQuery(); }
public void Delete(InternalQualifier qualifier, Connector connector) { var connection = connector.Connection; if (connection.State != ConnectionState.Open) connection.Open(); var command = new SqlCommand(String.Format( "delete from {0} where {1} = @part and {2} = @locale and {3} = @key", _table, PartIdColumn, LocaleIdColumn, KeyColumn ), connection ); command.Parameters.Add(new SqlParameter("part", SqlDbType.BigInt) { Value = qualifier.PartId }); command.Parameters.Add(new SqlParameter("locale", SqlDbType.Int) { Value = qualifier.LocaleId }); command.Parameters.Add(new SqlParameter("key", SqlDbType.VarChar) { Value = qualifier.Key }); command.ExecuteNonQuery(); if (_valuesByQualifier.ContainsKey(qualifier)) _valuesByQualifier.Remove(qualifier); }
public TemporaryQualifier(InternalQualifier qualifer, DateTime time) { Qualifer = qualifer; Time = time; }