GES_PAC

using GES_PAC.Model;

using GES_PAC.ViewModel;

using Microsoft.EntityFrameworkCore;

        public static AppDbContext Db { get; private set; }

            //var dbPath = Path.Combine(FileSystem.AppDataDirectory, "GES_PAC.db3");

            //if (File.Exists(dbPath))

            //    File.Delete(dbPath);

            Db = new AppDbContext();

            Db.Database.EnsureCreated();

            _ = InitSmartEnumsAsync();

            //_ = InitDb();

        public static async Task InitSmartEnumsAsync()

        {

            foreach (var phase in PhaseCalibration.All)

            {

                if (!await Db.PhaseCalibration.AnyAsync(p => p.Value == phase.Value))

                    Db.PhaseCalibration.Add(phase);

            }

            foreach (var type in TypeCalibration.All)

            {

                if (!await Db.TypeCalibration.AnyAsync(t => t.Value == type.Value))

                    Db.TypeCalibration.Add(type);

            }

            foreach (var comportement in TypeComportement.All)

            {

                if (!await Db.TypeComportement.AnyAsync(c => c.Value == comportement.Value))

                    Db.TypeComportement.Add(comportement);

            }

            await Db.SaveChangesAsync();

        }

        private async Task InitDb()

        {

            //ONLY FOR TESTS

            var place = new Lieu("Elevage Langlade", "INRAE", "Mouton");

            var person = new Personne("Bond", "James", "jamesbond@inrae.fr");

            await Db.Personne.AddAsync(person);

            await Db.Lieu.AddAsync(place);

            await Db.SaveChangesAsync();

            //ONLY FOR TESTS

        }