public static void AddItemsIfEmpty()
{
using (var db = DbConnection) {
if (db.ExecuteScalar <int>("SELECT seq FROM sqlite_sequence WHERE name = 'Categories'") == 0)
{
CategoriesDal.AddCategory(new Category {
Name = "Inne", ColorKey = "14", IconKey = "FontIcon_2", LastModifed = "2017.01.01 00:00:00", VisibleInIncomes = true, VisibleInExpenses = true, CantDelete = true, GlobalId = "1"
});
CategoriesDal.AddCategory(new Category {
Name = "Jedzenie", ColorKey = "04", IconKey = "FontIcon_6", LastModifed = "2017.01.01 00:00:00", VisibleInExpenses = true, VisibleInIncomes = true, GlobalId = "2"
});
CategoriesDal.AddCategory(new Category {
Name = "Rozrywka", ColorKey = "12", IconKey = "FontIcon_20", LastModifed = "2017.01.01 00:00:00", VisibleInIncomes = false, VisibleInExpenses = true, GlobalId = "3"
});
CategoriesDal.AddCategory(new Category {
Name = "Rachunki", ColorKey = "08", IconKey = "FontIcon_21", LastModifed = "2017.01.01 00:00:00", VisibleInIncomes = false, VisibleInExpenses = true, GlobalId = "4"
});
CategoriesDal.AddCategory(new Category {
Name = "Prezenty", ColorKey = "05", IconKey = "FontIcon_13", LastModifed = "2017.01.01 00:00:00", VisibleInIncomes = true, VisibleInExpenses = true, GlobalId = "5"
});
CategoriesDal.AddCategory(new Category {
Name = "Praca", ColorKey = "14", IconKey = "FontIcon_9", LastModifed = "2017.01.01 00:00:00", VisibleInIncomes = true, VisibleInExpenses = false, GlobalId = "6"
});
CategoriesDal.AddCategory(new SubCategory {
Name = "Prąd", ColorKey = "07", IconKey = "FontIcon_19", LastModifed = "2017.01.01 00:00:00", BossCategoryId = "4", VisibleInIncomes = false, VisibleInExpenses = true, GlobalId = "7"
});
CategoriesDal.AddCategory(new SubCategory {
Name = "Imprezy", ColorKey = "11", IconKey = "FontIcon_17", LastModifed = "2017.01.01 00:00:00", BossCategoryId = "3", VisibleInIncomes = false, VisibleInExpenses = true, GlobalId = "8"
});
}
if (db.ExecuteScalar <int>("SELECT seq FROM sqlite_sequence WHERE name = 'MAccount'") == 0)
{
MAccountsDal.AddAccount(new MAccount {
Name = "Gotówka", ColorKey = "01", LastModifed = "2017.01.01 00:00:00", GlobalId = "1"
});
MAccountsDal.AddAccount(new MAccount {
Name = "Konto bankowe", ColorKey = "02", LastModifed = "2017.01.01 00:00:00", GlobalId = "2"
});
MAccountsDal.AddAccount(new SubMAccount {
Name = "Karta", ColorKey = "03", LastModifed = "2017.01.01 00:00:00", GlobalId = "3", BossAccountGlobalId = "2"
});
}
}
}
public static void AddInitialElements()
{
using (var db = DbConnection) {
db.TraceListener = new DebugTraceListener();
db.Execute("INSERT INTO sqlite_sequence (name, seq) SELECT 'Account', 0 WHERE NOT EXISTS(SELECT 1 FROM sqlite_sequence WHERE name = 'Account')");
// AddCategory(new Category { Id = 1, Name = "Inne", ColorKey = "14", IconKey = "FontIcon_2", VisibleInIncomes = true, VisibleInExpenses = true });
CategoriesDal.AddCategory(new Category {
Id = 2, Name = "Jedzenie", ColorKey = "04", IconKey = "FontIcon_6", VisibleInExpenses = true, VisibleInIncomes = true
});
CategoriesDal.AddCategory(new Category {
Id = 3, Name = "Rozrywka", ColorKey = "12", IconKey = "FontIcon_20", VisibleInIncomes = false, VisibleInExpenses = true
});
CategoriesDal.AddCategory(new Category {
Id = 4, Name = "Rachunki", ColorKey = "08", IconKey = "FontIcon_21", VisibleInIncomes = false, VisibleInExpenses = true
});
CategoriesDal.AddCategory(new Category {
Id = 5, Name = "Prezenty", ColorKey = "05", IconKey = "FontIcon_13", VisibleInIncomes = true, VisibleInExpenses = true
});
CategoriesDal.AddCategory(new Category {
Id = 6, Name = "Praca", ColorKey = "14", IconKey = "FontIcon_9", VisibleInIncomes = true, VisibleInExpenses = false
});
CategoriesDal.AddCategory(new SubCategory {
Id = 1, Name = "Prąd", ColorKey = "07", IconKey = "FontIcon_19", BossCategoryId = "4", VisibleInIncomes = false, VisibleInExpenses = true
});
CategoriesDal.AddCategory(new SubCategory {
Id = 2, Name = "Imprezy", ColorKey = "11", IconKey = "FontIcon_17", BossCategoryId = "3", VisibleInIncomes = false, VisibleInExpenses = true
});
MAccountsDal.AddAccount(new MAccount {
Name = "Gotówka", ColorKey = "01"
});
MAccountsDal.AddAccount(new MAccount {
Name = "Konto bankowe", ColorKey = "02",
});
MAccountsDal.AddAccount(new SubMAccount {
Name = "Karta", ColorKey = "03", BossAccountGlobalId = db.ExecuteScalar <string>("SELECT GlobalId FROM MAccount WHERE Id = 2 LIMIT 1")
});
}
}