private void InsertIntoTable(DbConnection con, ITupleSchema tupleSchema, ITuple tuple, string insertCommand)
{
OplElementDefinition elementDefinition = this.Model.ModelDefinition.getElementDefinition(tupleSchema.Name);
OplTupleSchemaDefinition tupleDef = elementDefinition.asTupleSchema();
using (DbCommand insert = con.CreateCommand())
{
insert.CommandText = insertCommand;
for (int i = 0; i < tupleSchema.Size; i++)
{
OplElementDefinitionType.Type oplType = tupleDef.getComponent(i).getElementDefinitionType();
object oplValue = null;
if (oplType == OplElementDefinitionType.Type.INTEGER)
{
oplValue = tuple.GetIntValue(i);
}
else if (oplType == OplElementDefinitionType.Type.FLOAT)
{
oplValue = tuple.GetNumValue(i);
}
else if (oplType == OplElementDefinitionType.Type.STRING)
{
oplValue = tuple.GetStringValue(i);
}
DbUtils.AddParameterWithValue(insert, "@value" + i, oplValue);
}
insert.ExecuteNonQuery();
}
}
