private void PopulateEmployeeList() {
_employeesInternal.Clear();
var sqlDb = new SqlLiteDatabase();
foreach (var employeeViewModel in sqlDb.SelectEmployees()) {
_employeesInternal.Add(employeeViewModel);
}
}
private void startUpDoWork(object sender, DoWorkEventArgs e) {
SqlLiteDatabase dbManager = new SqlLiteDatabase();
var dbPath = new Uri(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "database.db"));
if (!dbManager.CheckIfExists(dbPath)) {
dbManager.CreateDatabase(dbPath);
var columnDictionary = new Dictionary<string, string>() {
{"name", "varchar(20)"},
{"email", "varchar(20)"},
{"completed", "int"},
{"currentassignment", "varchar(30)"}
};
dbManager.CreateTable(dbPath, "employee", columnDictionary);
}
}