GoodTimes

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Threading.Tasks;

namespace GoodTimes.Models
{
    public class BonRegel
    {
        public int Id { get; set; }
        public DateTime Tijd { get; set; }

        [DataType(DataType.MultilineText)]
        public string Omschrijving { get; set; }
        public int Aantal { get; set; }
        public double Prijs { get; set; }
        public double Btw { get; set; }
        public double Subtotaal { get; set; }

        public int BonId { get; set; }
        public Bon Bon { get; set; }

        public int BestellingId { get; set; }
        public Bestelling Bestelling { get; set; }
    }
}
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Threading.Tasks;

namespace GoodTimes.Models
{
    public class Reserveren
    {
        public int Id { get; set; }

        [Required]
        public string Klant { get; set; }

        [DataType(DataType.EmailAddress)]
        public string Email { get; set; }

        [DataType(DataType.PhoneNumber)]
        public string Telefoonnummer { get; set; }

        [Required]
        public int Aantalpersonen { get; set; }

        [Required]
        [DataType(DataType.Date)]
        public DateTime Datum { get; set; }

        [Required]
        [DataType(DataType.Time)]
        public DateTime Begintijd { get; set; }

        [Required]
        [DataType(DataType.Time)]
        public DateTime Eindtijd { get; set; }

        [DataType(DataType.MultilineText)]
        public string Opmerkingen { get; set; }
        public string Medewerker { get; set; }
        public DateTime AanmaakDatum { get; set; }
    }
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace GoodTimes.Models
{
    public class Bon
    {
        public int Id { get; set; }
        public int Tafelnr { get; set; }
        public DateTime Bezoek { get; set; }
        public string Medewerker { get; set; }
        public int Bonnummer { get; set; }

        public List<BonRegel> BonRegels { get; set; }

        public List<Bestelling> Bestellings { get; set; }
    }
}
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.AspNetCore.Identity.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore;
using GoodTimes.Models;

namespace GoodTimes.Data
{
    public class ApplicationDbContext : IdentityDbContext
    {
        public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options)
            : base(options)
        {
        }
        public DbSet<GoodTimes.Models.Reserveren> Reserveren { get; set; }
        public DbSet<GoodTimes.Models.Menukaart> Menukaart { get; set; }
        public DbSet<GoodTimes.Models.Categorie> Categorie { get; set; }
        public DbSet<GoodTimes.Models.Product> Product { get; set; }

        protected override void OnModelCreating(ModelBuilder builder)
        {
            base.OnModelCreating(builder);
            builder.Entity<Menukaart>().HasData(
                new Menukaart
                {
                    Id = 1,
                    Naam = "Lunchkaart"
                },
                new Menukaart
                {
                    Id = 2,
                    Naam = "Dinerkaart"
                },
                new Menukaart
                {
                    Id = 3,
                    Naam = "Drankenkaart"
                }
            );
        }

        public DbSet<GoodTimes.Models.Bestelling> Bestelling { get; set; }

        //public DbSet<GoodTimes.Models.Bon> Bon { get; set; }

        //public DbSet<GoodTimes.Models.BonRegel> BonRegel { get; set; }
    }
}
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Threading.Tasks;

namespace GoodTimes.Models
{
    public class Bestelling
    {
        public int Id { get; set; }
        public int Tafelnummer { get; set; }
        public int Aantal { get; set; }
        [DataType(DataType.MultilineText)]
        public string Opmerkingen { get; set; }
        public string Medewerker { get; set; }
        public DateTime Plaatsing { get; set; }
        public bool IsGereed { get; set; }

        //public List<BonRegel> BonRegels { get; set; }

        //public int BonId { get; set; }
        //public Bon Bon { get; set; }
    }
}
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Threading.Tasks;

namespace GoodTimes.Models
{
    public class Categorie
    {
        public int Id { get; set; }
        [Required]
        public string Naam { get; set; }
        public int Volgorde { get; set; }

        public int MenukaartId { get; set; }
        public Menukaart Menukaart { get; set; }

        public List<Product> products { get; set; }
    }
}
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Data.Common;
using System.Linq;
using System.Threading.Tasks;

namespace GoodTimes.Models
{
    public class Menukaart
    {
        public int Id { get; set; }
        [Required]
        public string Naam { get; set; }

        public List<Categorie> Categories { get; set; }
    }
}
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Threading.Tasks;

namespace GoodTimes.Models
{
    public class Product
    {
        public int Id { get; set; }
        [Required]
        public string Naam { get; set; }
        [Required]
        [DataType(DataType.MultilineText)]
        public string Omschrijving { get; set; }
        [Required]
        public double Prijs { get; set; }
        public int Volgorde { get; set; }

        public int CategorieId { get; set; }
        public Categorie categorie { get; set; }
    }
}

Similiar Collections

Python strftime reference pandas.Period.strftime python - Formatting Quarter time in pandas columns - Stack Overflow python - Pandas: Change day - Stack Overflow python - Check if multiple columns exist in a df - Stack Overflow Pandas DataFrame apply() - sending arguments examples python - How to filter a dataframe of dates by a particular month/day? - Stack Overflow python - replace a value in the entire pandas data frame - Stack Overflow python - Replacing blank values (white space) with NaN in pandas - Stack Overflow python - get list from pandas dataframe column - Stack Overflow python - How to drop rows of Pandas DataFrame whose value in a certain column is NaN - Stack Overflow python - How to drop rows of Pandas DataFrame whose value in a certain column is NaN - Stack Overflow python - How to lowercase a pandas dataframe string column if it has missing values? - Stack Overflow How to Convert Integers to Strings in Pandas DataFrame - Data to Fish How to Convert Integers to Strings in Pandas DataFrame - Data to Fish create a dictionary of two pandas Dataframe columns? - Stack Overflow python - ValueError: No axis named node2 for object type <class 'pandas.core.frame.DataFrame'> - Stack Overflow Python Pandas iterate over rows and access column names - Stack Overflow python - Creating dataframe from a dictionary where entries have different lengths - Stack Overflow python - Deleting DataFrame row in Pandas based on column value - Stack Overflow python - How to check if a column exists in Pandas - Stack Overflow python - Import pandas dataframe column as string not int - Stack Overflow