private void InsertOrders()
{
for (int i = 0; i < 100; i++)
{
insertIDAt++;
using (QuickData Query = new QuickData())
{
QDInserter ins = new QDInserter("WFInstances");
ins.insert("InstanceKey", "P" + insertIDAt.ToString(), Types.String);
ins.insert("Status", "pending", Types.String);
ins.insert("WFType", "P", Types.String);
Query.insert(ins);
}
}
Console.WriteLine("Orders Inserted");
}
public void insert(QDInserter ins)
{
string sql = "INSERT INTO " + ins.tableName + " ";
string fields = "(";
string values = "(";
foreach (DictionaryEntry d in ins.ht)
{
fields += d.Key + ",";
values += d.Value + ",";
}
fields = fields.TrimEnd(',') + ")";
values = values.TrimEnd(',') + ")";
sql += fields + " VALUES " + values;
ins.lastInsertID = insert(sql);
}
private void InsertOrders()
{
for (int i = 0; i < 100; i++)
{
insertIDAt++;
using (QuickData Query = new QuickData())
{
QDInserter ins = new QDInserter("WFInstances");
ins.insert("InstanceKey", "P" + insertIDAt.ToString(), Types.String);
ins.insert("Status", "pending", Types.String);
ins.insert("WFType", "P", Types.String);
Query.insert(ins);
}
}
Console.WriteLine("Orders Inserted");
}