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