Index: Farmatiko.sln
===================================================================
--- Farmatiko.sln (revision 96108d8e3d49648b847951dc630301b0ad7b08d8)
+++ Farmatiko.sln (revision a8ccc2ce1b8967d686fa572262dafedd4afc1ba4)
@@ -6,5 +6,7 @@
Project("{9A19103F-16F7-4668-BE54-9A1E7A4F7556}") = "Farmatiko", "Farmatiko\Farmatiko.csproj", "{36086D69-E8B8-4F14-8F25-D262410306EB}"
EndProject
-Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "FarmatikoData", "FarmatikoData\FarmatikoData.csproj", "{5BC55BDD-A064-4CE7-8606-D2FF42699EBF}"
+Project("{9A19103F-16F7-4668-BE54-9A1E7A4F7556}") = "FarmatikoData", "FarmatikoData\FarmatikoData.csproj", "{5BC55BDD-A064-4CE7-8606-D2FF42699EBF}"
+EndProject
+Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "FarmatikoServices", "FarmatikoServices\FarmatikoServices.csproj", "{D207CD1B-4C31-4414-9EF4-DC18F219CBF6}"
EndProject
Global
@@ -22,4 +24,8 @@
{5BC55BDD-A064-4CE7-8606-D2FF42699EBF}.Release|Any CPU.ActiveCfg = Release|Any CPU
{5BC55BDD-A064-4CE7-8606-D2FF42699EBF}.Release|Any CPU.Build.0 = Release|Any CPU
+ {D207CD1B-4C31-4414-9EF4-DC18F219CBF6}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
+ {D207CD1B-4C31-4414-9EF4-DC18F219CBF6}.Debug|Any CPU.Build.0 = Debug|Any CPU
+ {D207CD1B-4C31-4414-9EF4-DC18F219CBF6}.Release|Any CPU.ActiveCfg = Release|Any CPU
+ {D207CD1B-4C31-4414-9EF4-DC18F219CBF6}.Release|Any CPU.Build.0 = Release|Any CPU
EndGlobalSection
GlobalSection(SolutionProperties) = preSolution
Index: Farmatiko/ClientApp/src/app/korona/korona.component.css
===================================================================
--- Farmatiko/ClientApp/src/app/korona/korona.component.css (revision 96108d8e3d49648b847951dc630301b0ad7b08d8)
+++ Farmatiko/ClientApp/src/app/korona/korona.component.css (revision a8ccc2ce1b8967d686fa572262dafedd4afc1ba4)
@@ -1,28 +1,28 @@
.counter {
- background-color:#f5f5f5;
- padding: 20px 0;
- border-radius: 5px;
+ background-color: #f5f5f5;
+ padding: 20px 0;
+ border-radius: 5px;
}
.count-title {
- font-size: 40px;
- font-weight: normal;
- margin-top: 10px;
- margin-bottom: 0;
- text-align: center;
+ font-size: 40px;
+ font-weight: normal;
+ margin-top: 10px;
+ margin-bottom: 0;
+ text-align: center;
}
.count-text {
- font-size: 13px;
- font-weight: normal;
- margin-top: 10px;
- margin-bottom: 0;
- text-align: center;
+ font-size: 13px;
+ font-weight: normal;
+ margin-top: 10px;
+ margin-bottom: 0;
+ text-align: center;
}
.fa-2x {
- margin: 0 auto;
- float: none;
- display: table;
- color: #4ad1e5;
+ margin: 0 auto;
+ float: none;
+ display: table;
+ color: #4ad1e5;
}
Index: Farmatiko/ClientApp/src/app/korona/korona.component.spec.ts
===================================================================
--- Farmatiko/ClientApp/src/app/korona/korona.component.spec.ts (revision 96108d8e3d49648b847951dc630301b0ad7b08d8)
+++ Farmatiko/ClientApp/src/app/korona/korona.component.spec.ts (revision a8ccc2ce1b8967d686fa572262dafedd4afc1ba4)
@@ -9,7 +9,7 @@
beforeEach(async(() => {
TestBed.configureTestingModule({
- declarations: [ KoronaComponent ]
+ declarations: [KoronaComponent]
})
- .compileComponents();
+ .compileComponents();
}));
Index: Farmatiko/ClientApp/src/app/models/Medicine.ts
===================================================================
--- Farmatiko/ClientApp/src/app/models/Medicine.ts (revision 96108d8e3d49648b847951dc630301b0ad7b08d8)
+++ Farmatiko/ClientApp/src/app/models/Medicine.ts (revision a8ccc2ce1b8967d686fa572262dafedd4afc1ba4)
@@ -1,9 +1,9 @@
export class Medicine {
- Name: string;
- Strength: string;
- Form: string;
- WayOfIssuing: string;
- Manufacturer: string;
- Price: Float32Array;
- Packaging: string;
+ Name: string;
+ Strength: string;
+ Form: string;
+ WayOfIssuing: string;
+ Manufacturer: string;
+ Price: Float32Array;
+ Packaging: string;
}
Index: Farmatiko/Farmatiko.csproj
===================================================================
--- Farmatiko/Farmatiko.csproj (revision 96108d8e3d49648b847951dc630301b0ad7b08d8)
+++ Farmatiko/Farmatiko.csproj (revision a8ccc2ce1b8967d686fa572262dafedd4afc1ba4)
@@ -38,8 +38,4 @@
-
-
-
-
Index: Farmatiko/appsettings.json
===================================================================
--- Farmatiko/appsettings.json (revision 96108d8e3d49648b847951dc630301b0ad7b08d8)
+++ Farmatiko/appsettings.json (revision a8ccc2ce1b8967d686fa572262dafedd4afc1ba4)
@@ -1,5 +1,5 @@
{
"ConnectionStrings": {
- "FarmatikoConnection": "User ID=postgres;Password=@@Farmatiko@@.;database=FarmatikoDb;Integrated Security=true; Pooling=true;"
+ "FarmatikoConnection": "Host=localhost;User ID=postgres;Password=@@Postgres@@.;database=FarmatikoDb;Integrated Security=true; Pooling=true;"
},
"Logging": {
Index: FarmatikoData/Base/BaseEntity.cs
===================================================================
--- FarmatikoData/Base/BaseEntity.cs (revision a8ccc2ce1b8967d686fa572262dafedd4afc1ba4)
+++ FarmatikoData/Base/BaseEntity.cs (revision a8ccc2ce1b8967d686fa572262dafedd4afc1ba4)
@@ -0,0 +1,13 @@
+using System;
+using System.Collections.Generic;
+using System.Text;
+
+namespace FarmatikoData.Base
+{
+ public class BaseEntity
+ {
+ public int Id { get; set; }
+ public DateTime CreatedOn { get; set; }
+ public DateTime DeletedOn { get; set; }
+ }
+}
Index: FarmatikoData/Migrations/20200722131856_Initial migration.Designer.cs
===================================================================
--- FarmatikoData/Migrations/20200722131856_Initial migration.Designer.cs (revision a8ccc2ce1b8967d686fa572262dafedd4afc1ba4)
+++ FarmatikoData/Migrations/20200722131856_Initial migration.Designer.cs (revision a8ccc2ce1b8967d686fa572262dafedd4afc1ba4)
@@ -0,0 +1,334 @@
+//
+using System;
+using FarmatikoData;
+using Microsoft.EntityFrameworkCore;
+using Microsoft.EntityFrameworkCore.Infrastructure;
+using Microsoft.EntityFrameworkCore.Migrations;
+using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
+using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
+
+namespace FarmatikoData.Migrations
+{
+ [DbContext(typeof(FarmatikoDataContext))]
+ [Migration("20200722131856_Initial migration")]
+ partial class Initialmigration
+ {
+ protected override void BuildTargetModel(ModelBuilder modelBuilder)
+ {
+#pragma warning disable 612, 618
+ modelBuilder
+ .HasAnnotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn)
+ .HasAnnotation("ProductVersion", "3.1.6")
+ .HasAnnotation("Relational:MaxIdentifierLength", 63);
+
+ modelBuilder.Entity("FarmatikoData.Models.HealthFacilities", b =>
+ {
+ b.Property("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("integer")
+ .HasAnnotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn);
+
+ b.Property("Address")
+ .IsRequired()
+ .HasColumnType("text");
+
+ b.Property("CreatedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("DeletedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("Email")
+ .HasColumnType("text");
+
+ b.Property("Municipality")
+ .IsRequired()
+ .HasColumnType("text");
+
+ b.Property("Name")
+ .IsRequired()
+ .HasColumnType("text");
+
+ b.Property("Phone")
+ .HasColumnType("text");
+
+ b.Property("Type")
+ .IsRequired()
+ .HasColumnType("text");
+
+ b.HasKey("Id");
+
+ b.ToTable("HealthFacilities");
+ });
+
+ modelBuilder.Entity("FarmatikoData.Models.HealthcareWorkers", b =>
+ {
+ b.Property("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("integer")
+ .HasAnnotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn);
+
+ b.Property("Branch")
+ .IsRequired()
+ .HasColumnType("text");
+
+ b.Property("CreatedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("DeletedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("FacilityId")
+ .HasColumnType("integer");
+
+ b.Property("Name")
+ .IsRequired()
+ .HasColumnType("text");
+
+ b.Property("Title")
+ .HasColumnType("text");
+
+ b.HasKey("Id");
+
+ b.HasIndex("FacilityId");
+
+ b.ToTable("HealthcareWorkers");
+ });
+
+ modelBuilder.Entity("FarmatikoData.Models.Medicine", b =>
+ {
+ b.Property("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("integer")
+ .HasAnnotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn);
+
+ b.Property("CreatedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("DeletedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("Form")
+ .HasColumnType("text");
+
+ b.Property("Manufacturer")
+ .HasColumnType("text");
+
+ b.Property("MedicineListId")
+ .HasColumnType("integer");
+
+ b.Property("Name")
+ .HasColumnType("text");
+
+ b.Property("Packaging")
+ .HasColumnType("text");
+
+ b.Property("Price")
+ .HasColumnType("real");
+
+ b.Property("Strength")
+ .HasColumnType("text");
+
+ b.Property("WayOfIssuing")
+ .HasColumnType("text");
+
+ b.HasKey("Id");
+
+ b.HasIndex("MedicineListId");
+
+ b.ToTable("Medicines");
+ });
+
+ modelBuilder.Entity("FarmatikoData.Models.MedicineList", b =>
+ {
+ b.Property("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("integer")
+ .HasAnnotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn);
+
+ b.Property("CreatedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("DeletedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("HasMedicine")
+ .HasColumnType("boolean");
+
+ b.Property("MedicinesId")
+ .HasColumnType("integer");
+
+ b.Property("PharmacyHeadId")
+ .HasColumnType("integer");
+
+ b.HasKey("Id");
+
+ b.HasIndex("MedicinesId");
+
+ b.HasIndex("PharmacyHeadId");
+
+ b.ToTable("MedicineLists");
+ });
+
+ modelBuilder.Entity("FarmatikoData.Models.Pandemic", b =>
+ {
+ b.Property("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("integer")
+ .HasAnnotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn);
+
+ b.Property("ActiveGlobal")
+ .HasColumnType("integer");
+
+ b.Property("ActiveMK")
+ .HasColumnType("integer");
+
+ b.Property("CreatedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("DeathsGlobal")
+ .HasColumnType("integer");
+
+ b.Property("DeathsMK")
+ .HasColumnType("integer");
+
+ b.Property("DeletedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("Name")
+ .HasColumnType("text");
+
+ b.Property("NewMK")
+ .HasColumnType("integer");
+
+ b.Property("TotalGlobal")
+ .HasColumnType("integer");
+
+ b.Property("TotalMK")
+ .HasColumnType("integer");
+
+ b.HasKey("Id");
+
+ b.ToTable("Pandemics");
+ });
+
+ modelBuilder.Entity("FarmatikoData.Models.Pharmacy", b =>
+ {
+ b.Property("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("integer")
+ .HasAnnotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn);
+
+ b.Property("Address")
+ .HasColumnType("text");
+
+ b.Property("CreatedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("DeletedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("Location")
+ .HasColumnType("text");
+
+ b.Property("Name")
+ .HasColumnType("text");
+
+ b.Property("PharmacyHeadId")
+ .HasColumnType("integer");
+
+ b.Property("WorkAllTime")
+ .HasColumnType("boolean");
+
+ b.HasKey("Id");
+
+ b.HasIndex("PharmacyHeadId");
+
+ b.ToTable("Pharmacies");
+ });
+
+ modelBuilder.Entity("FarmatikoData.Models.PharmacyHead", b =>
+ {
+ b.Property("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("integer")
+ .HasAnnotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn);
+
+ b.Property("CreatedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("DeletedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("Email")
+ .HasColumnType("text");
+
+ b.Property("Name")
+ .HasColumnType("text");
+
+ b.Property("Password")
+ .HasColumnType("text");
+
+ b.Property("PharmacyId")
+ .HasColumnType("integer");
+
+ b.Property("PharmacyMedicinesId")
+ .HasColumnType("integer");
+
+ b.HasKey("Id");
+
+ b.HasIndex("PharmacyId");
+
+ b.HasIndex("PharmacyMedicinesId");
+
+ b.ToTable("PharmacyHeads");
+ });
+
+ modelBuilder.Entity("FarmatikoData.Models.HealthcareWorkers", b =>
+ {
+ b.HasOne("FarmatikoData.Models.HealthFacilities", "Facility")
+ .WithMany()
+ .HasForeignKey("FacilityId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+ });
+
+ modelBuilder.Entity("FarmatikoData.Models.Medicine", b =>
+ {
+ b.HasOne("FarmatikoData.Models.MedicineList", null)
+ .WithMany("MedicinesList")
+ .HasForeignKey("MedicineListId");
+ });
+
+ modelBuilder.Entity("FarmatikoData.Models.MedicineList", b =>
+ {
+ b.HasOne("FarmatikoData.Models.Medicine", "Medicines")
+ .WithMany()
+ .HasForeignKey("MedicinesId");
+
+ b.HasOne("FarmatikoData.Models.PharmacyHead", null)
+ .WithMany("MedicineLists")
+ .HasForeignKey("PharmacyHeadId");
+ });
+
+ modelBuilder.Entity("FarmatikoData.Models.Pharmacy", b =>
+ {
+ b.HasOne("FarmatikoData.Models.PharmacyHead", null)
+ .WithMany("PharmaciesList")
+ .HasForeignKey("PharmacyHeadId");
+ });
+
+ modelBuilder.Entity("FarmatikoData.Models.PharmacyHead", b =>
+ {
+ b.HasOne("FarmatikoData.Models.Pharmacy", "Pharmacy")
+ .WithMany()
+ .HasForeignKey("PharmacyId");
+
+ b.HasOne("FarmatikoData.Models.MedicineList", "PharmacyMedicines")
+ .WithMany()
+ .HasForeignKey("PharmacyMedicinesId");
+ });
+#pragma warning restore 612, 618
+ }
+ }
+}
Index: FarmatikoData/Migrations/20200722131856_Initial migration.cs
===================================================================
--- FarmatikoData/Migrations/20200722131856_Initial migration.cs (revision a8ccc2ce1b8967d686fa572262dafedd4afc1ba4)
+++ FarmatikoData/Migrations/20200722131856_Initial migration.cs (revision a8ccc2ce1b8967d686fa572262dafedd4afc1ba4)
@@ -0,0 +1,268 @@
+using System;
+using Microsoft.EntityFrameworkCore.Migrations;
+using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
+
+namespace FarmatikoData.Migrations
+{
+ public partial class Initialmigration : Migration
+ {
+ protected override void Up(MigrationBuilder migrationBuilder)
+ {
+ migrationBuilder.CreateTable(
+ name: "HealthFacilities",
+ columns: table => new
+ {
+ Id = table.Column(nullable: false)
+ .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
+ CreatedOn = table.Column(nullable: false),
+ DeletedOn = table.Column(nullable: false),
+ Name = table.Column(nullable: false),
+ Municipality = table.Column(nullable: false),
+ Address = table.Column(nullable: false),
+ Type = table.Column(nullable: false),
+ Email = table.Column(nullable: true),
+ Phone = table.Column(nullable: true)
+ },
+ constraints: table =>
+ {
+ table.PrimaryKey("PK_HealthFacilities", x => x.Id);
+ });
+
+ migrationBuilder.CreateTable(
+ name: "Pandemics",
+ columns: table => new
+ {
+ Id = table.Column(nullable: false)
+ .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
+ CreatedOn = table.Column(nullable: false),
+ DeletedOn = table.Column(nullable: false),
+ Name = table.Column(nullable: true),
+ TotalMK = table.Column(nullable: false),
+ ActiveMK = table.Column(nullable: false),
+ DeathsMK = table.Column(nullable: false),
+ NewMK = table.Column(nullable: false),
+ TotalGlobal = table.Column(nullable: false),
+ DeathsGlobal = table.Column(nullable: false),
+ ActiveGlobal = table.Column(nullable: false)
+ },
+ constraints: table =>
+ {
+ table.PrimaryKey("PK_Pandemics", x => x.Id);
+ });
+
+ migrationBuilder.CreateTable(
+ name: "HealthcareWorkers",
+ columns: table => new
+ {
+ Id = table.Column(nullable: false)
+ .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
+ CreatedOn = table.Column(nullable: false),
+ DeletedOn = table.Column(nullable: false),
+ Name = table.Column(nullable: false),
+ Branch = table.Column(nullable: false),
+ FacilityId = table.Column(nullable: false),
+ Title = table.Column(nullable: true)
+ },
+ constraints: table =>
+ {
+ table.PrimaryKey("PK_HealthcareWorkers", x => x.Id);
+ table.ForeignKey(
+ name: "FK_HealthcareWorkers_HealthFacilities_FacilityId",
+ column: x => x.FacilityId,
+ principalTable: "HealthFacilities",
+ principalColumn: "Id",
+ onDelete: ReferentialAction.Cascade);
+ });
+
+ migrationBuilder.CreateTable(
+ name: "Medicines",
+ columns: table => new
+ {
+ Id = table.Column(nullable: false)
+ .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
+ CreatedOn = table.Column(nullable: false),
+ DeletedOn = table.Column(nullable: false),
+ Name = table.Column(nullable: true),
+ Strength = table.Column(nullable: true),
+ Form = table.Column(nullable: true),
+ WayOfIssuing = table.Column(nullable: true),
+ Manufacturer = table.Column(nullable: true),
+ Price = table.Column(nullable: false),
+ Packaging = table.Column(nullable: true),
+ MedicineListId = table.Column(nullable: true)
+ },
+ constraints: table =>
+ {
+ table.PrimaryKey("PK_Medicines", x => x.Id);
+ });
+
+ migrationBuilder.CreateTable(
+ name: "PharmacyHeads",
+ columns: table => new
+ {
+ Id = table.Column(nullable: false)
+ .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
+ CreatedOn = table.Column(nullable: false),
+ DeletedOn = table.Column(nullable: false),
+ PharmacyMedicinesId = table.Column(nullable: true),
+ PharmacyId = table.Column(nullable: true),
+ Email = table.Column(nullable: true),
+ Name = table.Column(nullable: true),
+ Password = table.Column(nullable: true)
+ },
+ constraints: table =>
+ {
+ table.PrimaryKey("PK_PharmacyHeads", x => x.Id);
+ });
+
+ migrationBuilder.CreateTable(
+ name: "MedicineLists",
+ columns: table => new
+ {
+ Id = table.Column(nullable: false)
+ .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
+ CreatedOn = table.Column(nullable: false),
+ DeletedOn = table.Column(nullable: false),
+ MedicinesId = table.Column(nullable: true),
+ HasMedicine = table.Column(nullable: false),
+ PharmacyHeadId = table.Column(nullable: true)
+ },
+ constraints: table =>
+ {
+ table.PrimaryKey("PK_MedicineLists", x => x.Id);
+ table.ForeignKey(
+ name: "FK_MedicineLists_Medicines_MedicinesId",
+ column: x => x.MedicinesId,
+ principalTable: "Medicines",
+ principalColumn: "Id",
+ onDelete: ReferentialAction.Restrict);
+ table.ForeignKey(
+ name: "FK_MedicineLists_PharmacyHeads_PharmacyHeadId",
+ column: x => x.PharmacyHeadId,
+ principalTable: "PharmacyHeads",
+ principalColumn: "Id",
+ onDelete: ReferentialAction.Restrict);
+ });
+
+ migrationBuilder.CreateTable(
+ name: "Pharmacies",
+ columns: table => new
+ {
+ Id = table.Column(nullable: false)
+ .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn),
+ CreatedOn = table.Column(nullable: false),
+ DeletedOn = table.Column(nullable: false),
+ Name = table.Column(nullable: true),
+ Location = table.Column(nullable: true),
+ Address = table.Column(nullable: true),
+ WorkAllTime = table.Column(nullable: false),
+ PharmacyHeadId = table.Column(nullable: true)
+ },
+ constraints: table =>
+ {
+ table.PrimaryKey("PK_Pharmacies", x => x.Id);
+ table.ForeignKey(
+ name: "FK_Pharmacies_PharmacyHeads_PharmacyHeadId",
+ column: x => x.PharmacyHeadId,
+ principalTable: "PharmacyHeads",
+ principalColumn: "Id",
+ onDelete: ReferentialAction.Restrict);
+ });
+
+ migrationBuilder.CreateIndex(
+ name: "IX_HealthcareWorkers_FacilityId",
+ table: "HealthcareWorkers",
+ column: "FacilityId");
+
+ migrationBuilder.CreateIndex(
+ name: "IX_MedicineLists_MedicinesId",
+ table: "MedicineLists",
+ column: "MedicinesId");
+
+ migrationBuilder.CreateIndex(
+ name: "IX_MedicineLists_PharmacyHeadId",
+ table: "MedicineLists",
+ column: "PharmacyHeadId");
+
+ migrationBuilder.CreateIndex(
+ name: "IX_Medicines_MedicineListId",
+ table: "Medicines",
+ column: "MedicineListId");
+
+ migrationBuilder.CreateIndex(
+ name: "IX_Pharmacies_PharmacyHeadId",
+ table: "Pharmacies",
+ column: "PharmacyHeadId");
+
+ migrationBuilder.CreateIndex(
+ name: "IX_PharmacyHeads_PharmacyId",
+ table: "PharmacyHeads",
+ column: "PharmacyId");
+
+ migrationBuilder.CreateIndex(
+ name: "IX_PharmacyHeads_PharmacyMedicinesId",
+ table: "PharmacyHeads",
+ column: "PharmacyMedicinesId");
+
+ migrationBuilder.AddForeignKey(
+ name: "FK_Medicines_MedicineLists_MedicineListId",
+ table: "Medicines",
+ column: "MedicineListId",
+ principalTable: "MedicineLists",
+ principalColumn: "Id",
+ onDelete: ReferentialAction.Restrict);
+
+ migrationBuilder.AddForeignKey(
+ name: "FK_PharmacyHeads_MedicineLists_PharmacyMedicinesId",
+ table: "PharmacyHeads",
+ column: "PharmacyMedicinesId",
+ principalTable: "MedicineLists",
+ principalColumn: "Id",
+ onDelete: ReferentialAction.Restrict);
+
+ migrationBuilder.AddForeignKey(
+ name: "FK_PharmacyHeads_Pharmacies_PharmacyId",
+ table: "PharmacyHeads",
+ column: "PharmacyId",
+ principalTable: "Pharmacies",
+ principalColumn: "Id",
+ onDelete: ReferentialAction.Restrict);
+ }
+
+ protected override void Down(MigrationBuilder migrationBuilder)
+ {
+ migrationBuilder.DropForeignKey(
+ name: "FK_MedicineLists_Medicines_MedicinesId",
+ table: "MedicineLists");
+
+ migrationBuilder.DropForeignKey(
+ name: "FK_MedicineLists_PharmacyHeads_PharmacyHeadId",
+ table: "MedicineLists");
+
+ migrationBuilder.DropForeignKey(
+ name: "FK_Pharmacies_PharmacyHeads_PharmacyHeadId",
+ table: "Pharmacies");
+
+ migrationBuilder.DropTable(
+ name: "HealthcareWorkers");
+
+ migrationBuilder.DropTable(
+ name: "Pandemics");
+
+ migrationBuilder.DropTable(
+ name: "HealthFacilities");
+
+ migrationBuilder.DropTable(
+ name: "Medicines");
+
+ migrationBuilder.DropTable(
+ name: "PharmacyHeads");
+
+ migrationBuilder.DropTable(
+ name: "Pharmacies");
+
+ migrationBuilder.DropTable(
+ name: "MedicineLists");
+ }
+ }
+}
Index: FarmatikoData/Migrations/FarmatikoDataContextModelSnapshot.cs
===================================================================
--- FarmatikoData/Migrations/FarmatikoDataContextModelSnapshot.cs (revision a8ccc2ce1b8967d686fa572262dafedd4afc1ba4)
+++ FarmatikoData/Migrations/FarmatikoDataContextModelSnapshot.cs (revision a8ccc2ce1b8967d686fa572262dafedd4afc1ba4)
@@ -0,0 +1,332 @@
+//
+using System;
+using FarmatikoData;
+using Microsoft.EntityFrameworkCore;
+using Microsoft.EntityFrameworkCore.Infrastructure;
+using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
+using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
+
+namespace FarmatikoData.Migrations
+{
+ [DbContext(typeof(FarmatikoDataContext))]
+ partial class FarmatikoDataContextModelSnapshot : ModelSnapshot
+ {
+ protected override void BuildModel(ModelBuilder modelBuilder)
+ {
+#pragma warning disable 612, 618
+ modelBuilder
+ .HasAnnotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn)
+ .HasAnnotation("ProductVersion", "3.1.6")
+ .HasAnnotation("Relational:MaxIdentifierLength", 63);
+
+ modelBuilder.Entity("FarmatikoData.Models.HealthFacilities", b =>
+ {
+ b.Property("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("integer")
+ .HasAnnotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn);
+
+ b.Property("Address")
+ .IsRequired()
+ .HasColumnType("text");
+
+ b.Property("CreatedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("DeletedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("Email")
+ .HasColumnType("text");
+
+ b.Property("Municipality")
+ .IsRequired()
+ .HasColumnType("text");
+
+ b.Property("Name")
+ .IsRequired()
+ .HasColumnType("text");
+
+ b.Property("Phone")
+ .HasColumnType("text");
+
+ b.Property("Type")
+ .IsRequired()
+ .HasColumnType("text");
+
+ b.HasKey("Id");
+
+ b.ToTable("HealthFacilities");
+ });
+
+ modelBuilder.Entity("FarmatikoData.Models.HealthcareWorkers", b =>
+ {
+ b.Property("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("integer")
+ .HasAnnotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn);
+
+ b.Property("Branch")
+ .IsRequired()
+ .HasColumnType("text");
+
+ b.Property("CreatedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("DeletedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("FacilityId")
+ .HasColumnType("integer");
+
+ b.Property("Name")
+ .IsRequired()
+ .HasColumnType("text");
+
+ b.Property("Title")
+ .HasColumnType("text");
+
+ b.HasKey("Id");
+
+ b.HasIndex("FacilityId");
+
+ b.ToTable("HealthcareWorkers");
+ });
+
+ modelBuilder.Entity("FarmatikoData.Models.Medicine", b =>
+ {
+ b.Property("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("integer")
+ .HasAnnotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn);
+
+ b.Property("CreatedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("DeletedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("Form")
+ .HasColumnType("text");
+
+ b.Property("Manufacturer")
+ .HasColumnType("text");
+
+ b.Property("MedicineListId")
+ .HasColumnType("integer");
+
+ b.Property("Name")
+ .HasColumnType("text");
+
+ b.Property("Packaging")
+ .HasColumnType("text");
+
+ b.Property("Price")
+ .HasColumnType("real");
+
+ b.Property("Strength")
+ .HasColumnType("text");
+
+ b.Property("WayOfIssuing")
+ .HasColumnType("text");
+
+ b.HasKey("Id");
+
+ b.HasIndex("MedicineListId");
+
+ b.ToTable("Medicines");
+ });
+
+ modelBuilder.Entity("FarmatikoData.Models.MedicineList", b =>
+ {
+ b.Property("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("integer")
+ .HasAnnotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn);
+
+ b.Property("CreatedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("DeletedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("HasMedicine")
+ .HasColumnType("boolean");
+
+ b.Property("MedicinesId")
+ .HasColumnType("integer");
+
+ b.Property("PharmacyHeadId")
+ .HasColumnType("integer");
+
+ b.HasKey("Id");
+
+ b.HasIndex("MedicinesId");
+
+ b.HasIndex("PharmacyHeadId");
+
+ b.ToTable("MedicineLists");
+ });
+
+ modelBuilder.Entity("FarmatikoData.Models.Pandemic", b =>
+ {
+ b.Property("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("integer")
+ .HasAnnotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn);
+
+ b.Property("ActiveGlobal")
+ .HasColumnType("integer");
+
+ b.Property("ActiveMK")
+ .HasColumnType("integer");
+
+ b.Property("CreatedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("DeathsGlobal")
+ .HasColumnType("integer");
+
+ b.Property("DeathsMK")
+ .HasColumnType("integer");
+
+ b.Property("DeletedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("Name")
+ .HasColumnType("text");
+
+ b.Property("NewMK")
+ .HasColumnType("integer");
+
+ b.Property("TotalGlobal")
+ .HasColumnType("integer");
+
+ b.Property("TotalMK")
+ .HasColumnType("integer");
+
+ b.HasKey("Id");
+
+ b.ToTable("Pandemics");
+ });
+
+ modelBuilder.Entity("FarmatikoData.Models.Pharmacy", b =>
+ {
+ b.Property("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("integer")
+ .HasAnnotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn);
+
+ b.Property("Address")
+ .HasColumnType("text");
+
+ b.Property("CreatedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("DeletedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("Location")
+ .HasColumnType("text");
+
+ b.Property("Name")
+ .HasColumnType("text");
+
+ b.Property("PharmacyHeadId")
+ .HasColumnType("integer");
+
+ b.Property("WorkAllTime")
+ .HasColumnType("boolean");
+
+ b.HasKey("Id");
+
+ b.HasIndex("PharmacyHeadId");
+
+ b.ToTable("Pharmacies");
+ });
+
+ modelBuilder.Entity("FarmatikoData.Models.PharmacyHead", b =>
+ {
+ b.Property("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("integer")
+ .HasAnnotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn);
+
+ b.Property("CreatedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("DeletedOn")
+ .HasColumnType("timestamp without time zone");
+
+ b.Property("Email")
+ .HasColumnType("text");
+
+ b.Property("Name")
+ .HasColumnType("text");
+
+ b.Property("Password")
+ .HasColumnType("text");
+
+ b.Property("PharmacyId")
+ .HasColumnType("integer");
+
+ b.Property("PharmacyMedicinesId")
+ .HasColumnType("integer");
+
+ b.HasKey("Id");
+
+ b.HasIndex("PharmacyId");
+
+ b.HasIndex("PharmacyMedicinesId");
+
+ b.ToTable("PharmacyHeads");
+ });
+
+ modelBuilder.Entity("FarmatikoData.Models.HealthcareWorkers", b =>
+ {
+ b.HasOne("FarmatikoData.Models.HealthFacilities", "Facility")
+ .WithMany()
+ .HasForeignKey("FacilityId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+ });
+
+ modelBuilder.Entity("FarmatikoData.Models.Medicine", b =>
+ {
+ b.HasOne("FarmatikoData.Models.MedicineList", null)
+ .WithMany("MedicinesList")
+ .HasForeignKey("MedicineListId");
+ });
+
+ modelBuilder.Entity("FarmatikoData.Models.MedicineList", b =>
+ {
+ b.HasOne("FarmatikoData.Models.Medicine", "Medicines")
+ .WithMany()
+ .HasForeignKey("MedicinesId");
+
+ b.HasOne("FarmatikoData.Models.PharmacyHead", null)
+ .WithMany("MedicineLists")
+ .HasForeignKey("PharmacyHeadId");
+ });
+
+ modelBuilder.Entity("FarmatikoData.Models.Pharmacy", b =>
+ {
+ b.HasOne("FarmatikoData.Models.PharmacyHead", null)
+ .WithMany("PharmaciesList")
+ .HasForeignKey("PharmacyHeadId");
+ });
+
+ modelBuilder.Entity("FarmatikoData.Models.PharmacyHead", b =>
+ {
+ b.HasOne("FarmatikoData.Models.Pharmacy", "Pharmacy")
+ .WithMany()
+ .HasForeignKey("PharmacyId");
+
+ b.HasOne("FarmatikoData.Models.MedicineList", "PharmacyMedicines")
+ .WithMany()
+ .HasForeignKey("PharmacyMedicinesId");
+ });
+#pragma warning restore 612, 618
+ }
+ }
+}
Index: FarmatikoData/Models/HealthFacilities.cs
===================================================================
--- FarmatikoData/Models/HealthFacilities.cs (revision 96108d8e3d49648b847951dc630301b0ad7b08d8)
+++ FarmatikoData/Models/HealthFacilities.cs (revision a8ccc2ce1b8967d686fa572262dafedd4afc1ba4)
@@ -3,9 +3,10 @@
using System.ComponentModel.DataAnnotations;
using System.Text;
+using FarmatikoData.Base;
using Microsoft.EntityFrameworkCore;
namespace FarmatikoData.Models
{
- public class HealthFacilities
+ public class HealthFacilities : BaseEntity
{
public HealthFacilities() { }
Index: FarmatikoData/Models/HealthcareWorkers.cs
===================================================================
--- FarmatikoData/Models/HealthcareWorkers.cs (revision 96108d8e3d49648b847951dc630301b0ad7b08d8)
+++ FarmatikoData/Models/HealthcareWorkers.cs (revision a8ccc2ce1b8967d686fa572262dafedd4afc1ba4)
@@ -3,9 +3,10 @@
using System.ComponentModel.DataAnnotations;
using System.Text;
+using FarmatikoData.Base;
using Microsoft.EntityFrameworkCore;
namespace FarmatikoData.Models
{
- public class HealthcareWorkers
+ public class HealthcareWorkers : BaseEntity
{
public HealthcareWorkers() { }
Index: FarmatikoData/Models/Medicine.cs
===================================================================
--- FarmatikoData/Models/Medicine.cs (revision 96108d8e3d49648b847951dc630301b0ad7b08d8)
+++ FarmatikoData/Models/Medicine.cs (revision a8ccc2ce1b8967d686fa572262dafedd4afc1ba4)
@@ -2,9 +2,10 @@
using System.Collections.Generic;
using System.Text;
+using FarmatikoData.Base;
using Microsoft.EntityFrameworkCore;
namespace FarmatikoData.Models
{
- public class Medicine
+ public class Medicine : BaseEntity
{
public Medicine() { }
Index: FarmatikoData/Models/MedicineList.cs
===================================================================
--- FarmatikoData/Models/MedicineList.cs (revision 96108d8e3d49648b847951dc630301b0ad7b08d8)
+++ FarmatikoData/Models/MedicineList.cs (revision a8ccc2ce1b8967d686fa572262dafedd4afc1ba4)
@@ -1,3 +1,4 @@
using System.Collections.Generic;
+using FarmatikoData.Base;
using FarmatikoData.Models;
using Microsoft.EntityFrameworkCore;
@@ -5,5 +6,5 @@
namespace FarmatikoData.Models
{
- public class MedicineList
+ public class MedicineList : BaseEntity
{
public Medicine Medicines { get; set; }
Index: FarmatikoData/Models/Pandemic.cs
===================================================================
--- FarmatikoData/Models/Pandemic.cs (revision 96108d8e3d49648b847951dc630301b0ad7b08d8)
+++ FarmatikoData/Models/Pandemic.cs (revision a8ccc2ce1b8967d686fa572262dafedd4afc1ba4)
@@ -2,9 +2,10 @@
using System.Collections.Generic;
using System.Text;
+using FarmatikoData.Base;
using Microsoft.EntityFrameworkCore;
namespace FarmatikoData.Models
{
- public class Pandemic
+ public class Pandemic : BaseEntity
{
public Pandemic() { }
Index: FarmatikoData/Models/Pharmacy.cs
===================================================================
--- FarmatikoData/Models/Pharmacy.cs (revision 96108d8e3d49648b847951dc630301b0ad7b08d8)
+++ FarmatikoData/Models/Pharmacy.cs (revision a8ccc2ce1b8967d686fa572262dafedd4afc1ba4)
@@ -2,9 +2,10 @@
using System.Collections.Generic;
using System.Text;
+using FarmatikoData.Base;
using Microsoft.EntityFrameworkCore;
namespace FarmatikoData.Models
{
- public class Pharmacy
+ public class Pharmacy : BaseEntity
{
public Pharmacy() { }
Index: FarmatikoData/Models/PharmacyHead.cs
===================================================================
--- FarmatikoData/Models/PharmacyHead.cs (revision 96108d8e3d49648b847951dc630301b0ad7b08d8)
+++ FarmatikoData/Models/PharmacyHead.cs (revision a8ccc2ce1b8967d686fa572262dafedd4afc1ba4)
@@ -2,9 +2,10 @@
using System.Collections.Generic;
using System.Text;
+using FarmatikoData.Base;
using Microsoft.EntityFrameworkCore;
namespace FarmatikoData.Models
{
- public class PharmacyHead
+ public class PharmacyHead : BaseEntity
{
public MedicineList PharmacyMedicines { get; set; }
Index: FarmatikoServices/Class1.cs
===================================================================
--- FarmatikoServices/Class1.cs (revision a8ccc2ce1b8967d686fa572262dafedd4afc1ba4)
+++ FarmatikoServices/Class1.cs (revision a8ccc2ce1b8967d686fa572262dafedd4afc1ba4)
@@ -0,0 +1,8 @@
+using System;
+
+namespace FarmatikoServices
+{
+ public class Class1
+ {
+ }
+}
Index: FarmatikoServices/FarmatikoServices.csproj
===================================================================
--- FarmatikoServices/FarmatikoServices.csproj (revision a8ccc2ce1b8967d686fa572262dafedd4afc1ba4)
+++ FarmatikoServices/FarmatikoServices.csproj (revision a8ccc2ce1b8967d686fa572262dafedd4afc1ba4)
@@ -0,0 +1,7 @@
+
+
+
+ netcoreapp3.1
+
+
+