using dentapp.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace dentapp.Data
{
    public class DbDentistData : IDentistData
    {
        public DbDentistData()
        {
            using (var context = new DentistDbContext())
            {
                context.Database.EnsureCreated();
            }
        }

        public IEnumerable<User> GetAll()
        {
            using (var context = new DentistDbContext())
            {
                //context.Database.EnsureCreated();

                return context.DentistUsers.ToList();
            }
        }

        public void SaveDentistUser(User user)
        {
            using (var context = new DentistDbContext())
            {
                //context.Database.EnsureCreated();
                context.DentistUsers.Add(user);

                context.SaveChanges();
            }
        }
        public IEnumerable<Surgery> GetSurgeries(User user)
        {
            using (var context = new DentistDbContext())
            {
                //context.Database.EnsureCreated();

                return context.DentistSurgeries.Where(pt => pt.UserSurgery.Any(t => t.UserID == user.Id)).ToList();
                //return context.AlaInstagramTags.Include(x => x.PostTag).ThenInclude(x => x.Post);
            }
        }

        public Surgery GetSurgeryByName(string name)
        {
            using (var context = new DentistDbContext())
            {
                //context.Database.EnsureCreated();

                return context.DentistSurgeries.Where(t => t.Name == name).FirstOrDefault();
            }
        }
    }
}


using dentapp.Models;
using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace dentapp.Data
{
    public class DentistDbContext : DbContext
    {
        public DbSet<User> DentistUsers { get; set; }
        public DbSet<Surgery> DentistSurgeries { get; set; }
        public DbSet<UserSurgery> DentistUserSurgeries { get; set; }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            var connStr = @"Data Source=(localdb)\MSSQLLocalDB;Database=Dentist;Integrated Security=True";

            optionsBuilder.UseSqlServer(connStr);
        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<UserSurgery>().HasKey(sc => new { sc.UserID, sc.SurgeryID });
        }
    }
}

using dentapp.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace dentapp.Data
{
    interface IDentistData
    {
        void SaveDentistUser(User user);
        IEnumerable<User> GetAll();
        IEnumerable<Surgery> GetSurgeries(User DentistUser);
        Surgery GetSurgeryByName(string name);
    }
}