Exemple #1
0
        public Database(string dbPath)
        {
            database = new SQLiteConnection(dbPath);

            database.CreateTable <EventsDB>();
            database.CreateTable <AnnouncementDB>();
            database.CreateTable <AssesmentDB>();
            database.CreateTable <ClassDB>();
            database.CreateTable <ResourcesDB>();
            database.CreateTable <UnitDB>();

            if (database.Table <UnitDB>().ToList().Count == 0)
            {
                ObservableCollection <Unit> units = Datastore.GenerateAllUnits();
                foreach (Unit unit in units)
                {
                    SaveUnit(unit);
                }
            }

            database.CreateTable <SemesterDB>();
            database.CreateTable <StudentDB>();

            if (database.Table <StudentDB>().ToList().Count == 0)
            {
                List <Unit> units   = GetUnits();
                Student     student = Datastore.GetStudent();
                SaveStudent(student);
            }
        }