public void FillWarehouse(int w)
{
util u1 = new util(6, 10);
util u2 = new util(10, 20);
Console.WriteLine("Starting warehouse " + w + " " + DateTime.Now);
conn.ExecuteNonQuery("insert WAREHOUSE(W_ID,W_NAME,W_STREET_1,W_STREET_2," +
"W_CITY,W_STATE,W_ZIP,W_TAX,W_YTD) values(" +
w + "," + GetString(u1.NextAString()) + "," +
GetString(u2.NextAString()) + "," +
GetString(u2.NextAString()) + "," +
GetString(u2.NextAString()) + ",'" +
(char)util.random(65, 90) + (char)util.random(65, 90) + "'," +
GetString(util.NZip()) + "," +
util.NextNString(0, 2000, 4) + ",300000.00)");
FillStock(w);
}
public void FillDistrict(int wid, int did)
{
Console.WriteLine("Filling District " + did + " " + DateTime.Now);
util us = new util(10, 20);
util un = new util(6, 10);
conn.ExecuteNonQuery("insert DISTRICT(D_ID,D_W_ID,D_NAME,D_STREET_1,D_STREET_2," +
"D_CITY,D_STATE,D_ZIP,D_TAX,D_YTD,D_NEXT_O_ID) values(" +
did + "," + wid + "," + GetString(un.NextAString()) + "," +
GetString(un.NextAString()) + "," +
GetString(un.NextAString()) + "," +
GetString(un.NextAString()) + ",'" +
(char)util.random(65, 90) + (char)util.random(65, 90) + "'," +
GetString(util.NZip()) + "," + util.NextNString(0, 2000, 4) + "," +
"3000.00,3001)");
FillCustomer(wid, did);
FillOrder(wid, did);
Console.WriteLine("Done Filling District " + DateTime.Now);
}
public void FillItems()
{
Console.WriteLine("Adding Items: " + DateTime.Now);
util ut = new util(14, 24);
#if TRY
for (int j = 1; j <= 10; j++)
#else
for (int j = 1; j <= 100000; j++)
#endif
{ conn.ExecuteNonQuery("insert ITEM(I_ID,I_IM_ID,I_NAME,I_PRICE,I_DATA)" +
" values(" +
#if TRY
j + "," + util.random(1, 10) +
#else
j + "," + util.random(1, 10000) +
#endif
"," + GetString(ut.NextAString()) + "," +
util.NextNString(100, 10000, 2) + "," + NextData() + ")"); }
Console.WriteLine("Items done: Fill stock?" + DateTime.Now);
}