Changeset 1db5673 for FarmatikoData/FarmatikoDataContext.cs

Timestamp:

11/14/20 12:27:30 (3 years ago)

Author:

DimitarSlezenkovski <dslezenkovski@…>

Branches:

master

Children:

68454c6

Parents:

ad60966

Message:

Fix bugs, add some more

File:

• FarmatikoData/FarmatikoDataContext.cs (modified) (1 diff)

FarmatikoData/FarmatikoDataContext.cs

@@ -15 +15 @@
         public virtual DbSet<Pandemic> Pandemics { get; set; }
         public virtual DbSet<Medicine> Medicines { get; set; }
-        //public virtual DbSet<MedicineList> MedicineLists { get; set; }
         public virtual DbSet<RequestPharmacyHead> PHRequests { get; set; }
         public virtual DbSet<User> Users { get; set; }
+        public virtual DbSet<PharmacyHeadMedicine> PharmacyHeadMedicines { get; set; }
+        
+        protected override void OnModelCreating(ModelBuilder modelBuilder)
+        {
+            modelBuilder.Entity<PharmacyHead>()
+                .ToTable("PharmacyHeads");
+
+            modelBuilder.Entity<Medicine>()
+                .ToTable("Medicines");
+
+            modelBuilder.Entity<PharmacyHeadMedicine>()
+                .HasKey(phm => new { phm.PheadId, phm.MedicineId });
+            modelBuilder.Entity<PharmacyHeadMedicine>()
+                .HasOne(ph => ph.Head)
+                .WithMany(m => m.PHMedicineList)
+                .HasForeignKey(k => k.PheadId);
+
+            modelBuilder.Entity<PharmacyHeadMedicine>()
+                .HasOne(m => m.Medicine)
+                .WithMany(ml => ml.MedicineList)
+                .HasForeignKey(k => k.MedicineId);
+
+            modelBuilder.Entity<PharmacyHead>()
+                .HasMany(p => p.PharmaciesList)
+                .WithOne(h => h.PHead)
+                .HasForeignKey(k => k.PheadId);
+
+            base.OnModelCreating(modelBuilder);
+        }
     }
 }