public Code SearchCode(string stringValue, CodeConverter convertCode)
{
var code = new Code();
var seedValue = convertCode.ConvertFromCode(stringValue);
code.SeedValue = seedValue;
code.StringValue = stringValue;
Connection.Open();
using (var command = Connection.CreateCommand())
{
command.CommandText = @"SELECT [State] FROM Code
WHERE SeedValue = @seedValue";
command.Parameters.AddWithValue("@seedValue", seedValue);
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
code.State = States.ConvertToString((byte)reader["State"]);
}
}
}
Connection.Close();
return(code.State == null ? null : code);
}
public Code GetCode(string stringValue, CodeConverter codeConverter)
{
var seedValue = codeConverter.ConvertFromCode(stringValue);
var code = new Code();
Connection.Open();
using (var command = Connection.CreateCommand())
{
command.CommandText = @"SELECT * FROM Codes WHERE SeedValue = @seedValue";
command.Parameters.AddWithValue("@seedValue", seedValue);
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var seed = (int)reader["SeedValue"];
code.State = State.ConvertToString((byte)reader["State"]);
code.StringValue = codeConverter.ConvertToCode(seed);
}
}
}
Connection.Close();
return(code);
}
public void DeactivateCode(string alphabet, string stringValue)
{
var convertCode = new CodeConverter(alphabet);
var seedValue = convertCode.ConvertFromCode(stringValue);
Connection.Open();
using (var command = Connection.CreateCommand())
{
command.CommandText = @"Update Code SET [State] = @inactive WHERE [SeedValue] = @seedValue";
command.Parameters.AddWithValue("@seedValue", seedValue);
command.Parameters.AddWithValue("@inactive", States.Inactive);
command.Parameters.AddWithValue("@active", States.Active);
command.ExecuteNonQuery();
}
}
public void DeactivateCode(string alphabet, string code)
{
var codeConverter = new CodeConverter(alphabet);
var seedValue = codeConverter.ConvertFromCode(code);
Connection.Open();
using (var command = Connection.CreateCommand())
{
command.CommandText = @"UPDATE Codes SET [State] = @inactive
WHERE SeedValue = @seedvalue AND [State] = @active";
command.Parameters.AddWithValue("@inactive", State.Inactive);
command.Parameters.AddWithValue("@active", State.Active);
command.Parameters.AddWithValue("@seedvalue", seedValue);
command.ExecuteNonQuery();
}
Connection.Close();
}
