public override void AddCodon(IGEPCodon codon)
{
var functionPairRow = new FunctionPairRow();
var result = Qry.SelectAllFrom(functionPairRow)
.InnerJoinOn(functionPairRow.PrimaryFunctionRowColumn)
.InnerJoinOn(functionPairRow.ParameterlessFunctionRowColumn)
.Where(functionPairRow.PrimaryFunctionRow.FunctionIdentifierColumn, codon.Functions.PrimaryFunction.ToString())
.Where(functionPairRow.ParameterlessFunctionRow.FunctionIdentifierColumn, codon.Functions.ParameterlessFunction.ToString())
.Go();
if(result.IsEmpty)
this.InsertFunctionPairIfNecessary(ref functionPairRow, codon: codon);
else
result.ExtractStrongRow(ref functionPairRow);
var codonRow = new CodonRow(name: codon.CodonIdentifier.ToString(), geneticCode: this.GeneticCodePrimaryKey.Value,
functionPair: functionPairRow.PrimaryKey, codonType: codon.CodonType.ToCodonType());
codonRow.InsertIntoDatabase();
/*
var nucleotideRow = new NucleotideRow();
var nucleotideRows = Qry.SelectAllFrom(nucleotideRow)
.Where(nucleotideRow.GeneticCodeColumn, this.GeneticCodePrimaryKey.Value)
.GoAndExtractMultiple<NucleotideRow>();
foreach(var nucleotide in codon)
{
var codonNucleotideRow =
nucleotide.ToCodonNucleotideRow(
nucleotidePrimaryKey:
nucleotideRows.First(n => n.Name == nucleotide.Identifier.ToString()).PrimaryKey,
codonPrimaryKey: codonRow.PrimaryKey,
geneticCodePrimaryKey: this.GeneticCodePrimaryKey.Value);
codonNucleotideRow.InsertOnlyIfNecessary();
}
*/
}
