//add some random rows to table2 public void PopulateTable2(string clientCode) { using (var context = new MigrationDbEntities()) { var table = new Table2(); table.ACN = RandomString(8); table.AddressLine1 = RandomString(50); table.AddressLine2 = RandomString(50); table.City = "Sydney"; table.ManagedBy = 5; table.Name = "Name " + clientCode; table.Phone = "1234567"; table.Postcode = 2031; table.Reserves = 1000; table.State = "NSW"; table.Type = "c"; table.Website = "www.myob.com"; context.AddToTable2(table); context.SaveChanges(); } }
//add some random rows to table1 public void PopulateTable1(string clientCode) { using (var context = new MigrationDbEntities()) { var table = new Table1(); table.col2 = RandomString(20) + clientCode; table.col2 = RandomString(20) + clientCode; table.col3 = RandomString(20) + clientCode; table.col4 = RandomString(20); table.col5 = RandomString(20); table.col6 = RandomString(20); table.col7 = RandomString(20); table.col8 = RandomString(20); table.col9 = RandomString(20); table.col10 = RandomString(20); table.col11 = RandomString(20); table.col12 = DateTime.Now; context.AddToTable1(table); context.SaveChanges(); } }
//add some random rows to table3 public void PopulateTable3(string clientCode) { using (var context = new MigrationDbEntities()) { Random rnd = new Random(); var table = new Table3(); table.Desc = "Row for client " + clientCode; table.Col1 = rnd.Next(1, 100000); table.Col2 = rnd.Next(1, 100000); table.Col3 = rnd.Next(1, 100000); table.Col4 = rnd.Next(1, 100000); table.Col5 = rnd.Next(1, 100000); table.Col6 = rnd.Next(1, 100000); table.Col7 = rnd.Next(1, 100000); table.Col8 = rnd.Next(1, 100000); table.Col9 = rnd.Next(1, 100000); table.Col10 = rnd.Next(1, 100000); table.Col11 = rnd.Next(1, 100000); table.Col12 = rnd.Next(1, 100000); table.Col13 = rnd.Next(1, 100000); table.Col14 = rnd.Next(1, 100000); table.Col15 = DateTime.Now; context.AddToTable3(table); context.SaveChanges(); } }