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