protected override void OnData()
{
base.OnData();
if (BreadcrumbTestData.Exists())
{
Db.Transact(() => { BreadcrumbTestData.DeleteAll(); });
}
BreadcrumbTestData.Create();
var treeItem = Db.SQL <TreeItem>("SELECT i FROM TreeItem i WHERE Name = ?", "Milk").First;
SetActiveItem(treeItem);
}
public static void Create()
{
Db.Transact(() =>
{
// For Dropdown page
if (Db.SQL("SELECT p FROM KitchenSink.SoftwareProduct p").First == null)
{
new SoftwareProduct {
Name = "Starcounter Database"
};
new SoftwareProduct {
Name = "Polymer JavaScript library"
};
}
// For Pagination page
if (Db.SQL <Book>("SELECT b FROM KitchenSink.Book b").First == null)
{
// change the number of element with adjusting elementsInTotal
int elementsInTotal = 100;
for (int i = 0; i < elementsInTotal; i++)
{
var book = new Book
{
Author = "Arbitrary Author",
Title = "Arbitrary Book " + (i + 1),
Position = i + 1
};
}
}
// For Breadcrumb page
if (BreadcrumbTestData.Exists())
{
BreadcrumbTestData.DeleteAll();
}
BreadcrumbTestData.Create();
// For Sortable Person
if (!PersonTestData.Exists())
{
PersonTestData.Create();
}
// For Autocomplete page
if (Db.SQL("SELECT p FROM KitchenSink.GroceryProduct p").First == null)
{
new GroceryProduct {
Name = "Bread", Price = 1
};
new GroceryProduct {
Name = "Butter", Price = 3
};
new GroceryProduct {
Name = "Scotch Whisky", Price = 4
};
new GroceryProduct {
Name = "Irish Whiskey", Price = 2
};
new GroceryProduct {
Name = "Milk", Price = 5
};
new GroceryProduct {
Name = "Boiled Mutton", Price = 7
};
}
});
}
public static void Create()
{
Db.Transact(() =>
{
// For Sortable list page
if (Db.SQL("SELECT p FROM KitchenSink.Person p").First == null)
{
new Person {
Name = "Bilbo Baggins", OrdNumber = 1
};
new Person {
Name = "Luke Skywalker", OrdNumber = 2
};
new Person {
Name = "Harvey Specter", OrdNumber = 3
};
new Person {
Name = "Sheldon Cooper", OrdNumber = 4
};
new Person {
Name = "James Howlett", OrdNumber = 5
};
new Person {
Name = "Kegan Rodhe", OrdNumber = 6
};
new Person {
Name = "Illidan Stormrage", OrdNumber = 7
};
new Person {
Name = "Ragnar Lothbrok", OrdNumber = 8
};
}
// For Dropdown page
if (Db.SQL("SELECT p FROM KitchenSink.SoftwareProduct p").First == null)
{
new SoftwareProduct {
Name = "Starcounter Database"
};
new SoftwareProduct {
Name = "Polymer JavaScript library"
};
}
// For Pagination page
if (Db.SQL <Book>("SELECT b FROM KitchenSink.Book b").First == null)
{
// change the number of element with adjusting elementsInTotal
int elementsInTotal = 100;
for (int i = 0; i < elementsInTotal; i++)
{
var book = new Book
{
Author = "Arbitrary Author",
Title = "Arbitrary Book " + (i + 1),
Position = i + 1
};
}
}
// For Breadcrumb page
if (BreadcrumbTestData.Exists())
{
BreadcrumbTestData.DeleteAll();
}
BreadcrumbTestData.Create();
// For Autocomplete page
if (Db.SQL("SELECT p FROM KitchenSink.GroceryProduct p").First == null)
{
new GroceryProduct {
Name = "Bread", Price = 1
};
new GroceryProduct {
Name = "Butter", Price = 3
};
new GroceryProduct {
Name = "Scotch Whisky", Price = 4
};
new GroceryProduct {
Name = "Irish Whiskey", Price = 2
};
new GroceryProduct {
Name = "Milk", Price = 5
};
new GroceryProduct {
Name = "Boiled Mutton", Price = 7
};
}
});
}