Compare commits

...

13 Commits

Author SHA1 Message Date
72cffa664e Add kontaktverwaltung Bestellübersicht 2023-06-25 17:16:22 +02:00
8d4d8338aa Add complete vorbestellungsfunktion 2023-06-25 16:42:33 +02:00
9add5ac628 Add vorbestllungsdata into Table BestellungspositionHasMenuitem 2023-06-25 16:10:33 +02:00
32bedc209c Add vorbestllungsdata into Table Bestellungsposition 2023-06-25 16:05:54 +02:00
c9f10887ee Add Bestellabschluss link 2023-06-24 16:43:52 +02:00
5b21244ee5 Datenbankintegrität speisekarte fix2 (#46) 2023-06-24 16:28:30 +02:00
8dcccae14a Merge branch 'dev' into Datenbankintegrität-Speisekarte_fix2 2023-06-24 16:23:51 +02:00
b242ea8c64 Fix shoppingcart Abholzeit 2023-06-24 14:40:39 +02:00
075d2a4838 Update shoppingcart 2023-06-23 20:04:29 +02:00
04a221f20b Update speisekarte2 details 2023-06-23 20:04:11 +02:00
a51fe08db8 Add db integration show menuitems 2023-06-23 14:52:39 +02:00
9cd1376cfd Frontend "Speisekarte2"
Frontend according to figma design "Speisekarte2"
2023-05-26 21:58:56 +02:00
70541c1b4d DB integration
The categories are taken from the api and output according to the design template.
2023-05-26 21:57:31 +02:00
23 changed files with 2969 additions and 513 deletions

2
.gitignore vendored
View File

@ -136,3 +136,5 @@ $RECYCLE.BIN/
.DS_Store .DS_Store
_NCrunch* _NCrunch*
/src/WebApi/appsettings.json
/src/WebApi/appsettings.json

View File

@ -0,0 +1,138 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using WebApi.Data;
using WebApi.Models;
namespace WebApi.Controllers
{
[Route("api/[controller]")]
[ApiController]
public class BestellungspositionHasMenuitemsController : ControllerBase
{
private readonly WebApiContext _context;
public BestellungspositionHasMenuitemsController(WebApiContext context)
{
_context = context;
}
// GET: api/BestellungspositionHasMenuitems
[HttpGet]
public async Task<ActionResult<IEnumerable<BestellungspositionHasMenuitem>>> GetBestellungspositionHasMenuitem()
{
if (_context.BestellungspositionHasMenuitem == null)
{
return NotFound();
}
return await _context.BestellungspositionHasMenuitem.ToListAsync();
}
// GET: api/BestellungspositionHasMenuitems/5
[HttpGet("{id}")]
public async Task<ActionResult<BestellungspositionHasMenuitem>> GetBestellungspositionHasMenuitem(int? id)
{
if (_context.BestellungspositionHasMenuitem == null)
{
return NotFound();
}
var bestellungspositionHasMenuitem = await _context.BestellungspositionHasMenuitem.FindAsync(id);
if (bestellungspositionHasMenuitem == null)
{
return NotFound();
}
return bestellungspositionHasMenuitem;
}
// PUT: api/BestellungspositionHasMenuitems/5
// To protect from overposting attacks, see https://go.microsoft.com/fwlink/?linkid=2123754
[HttpPut("{id}")]
public async Task<IActionResult> PutBestellungspositionHasMenuitem(int? id, BestellungspositionHasMenuitem bestellungspositionHasMenuitem)
{
if (id != bestellungspositionHasMenuitem.Bestellungsposition_IDBestellung)
{
return BadRequest();
}
_context.Entry(bestellungspositionHasMenuitem).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!BestellungspositionHasMenuitemExists(id))
{
return NotFound();
}
else
{
throw;
}
}
return NoContent();
}
// POST: api/BestellungspositionHasMenuitems
// To protect from overposting attacks, see https://go.microsoft.com/fwlink/?linkid=2123754
[HttpPost]
public async Task<ActionResult<BestellungspositionHasMenuitem>> PostBestellungspositionHasMenuitem(BestellungspositionHasMenuitem bestellungspositionHasMenuitem)
{
if (_context.BestellungspositionHasMenuitem == null)
{
return Problem("Entity set 'WebApiContext.BestellungspositionHasMenuitem' is null.");
}
_context.BestellungspositionHasMenuitem.Add(bestellungspositionHasMenuitem);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (BestellungspositionHasMenuitemExists(bestellungspositionHasMenuitem.Bestellungsposition_IDBestellung))
{
return Conflict();
}
else
{
throw;
}
}
return CreatedAtAction("GetBestellungspositionHasMenuitem", new { id = bestellungspositionHasMenuitem.Bestellungsposition_IDBestellung }, bestellungspositionHasMenuitem);
}
// DELETE: api/BestellungspositionHasMenuitems/5
[HttpDelete("{id}")]
public async Task<IActionResult> DeleteBestellungspositionHasMenuitem(int? id)
{
if (_context.BestellungspositionHasMenuitem == null)
{
return NotFound();
}
var bestellungspositionHasMenuitem = await _context.BestellungspositionHasMenuitem.FindAsync(id);
if (bestellungspositionHasMenuitem == null)
{
return NotFound();
}
_context.BestellungspositionHasMenuitem.Remove(bestellungspositionHasMenuitem);
await _context.SaveChangesAsync();
return NoContent();
}
private bool BestellungspositionHasMenuitemExists(int? id)
{
return (_context.BestellungspositionHasMenuitem?.Any(e => e.Bestellungsposition_IDBestellung == id)).GetValueOrDefault();
}
}
}

View File

@ -0,0 +1,138 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using WebApi.Data;
using WebApi.Models;
namespace WebApi.Controllers
{
[Route("api/[controller]")]
[ApiController]
public class MenuitemHasAllergiesController : ControllerBase
{
private readonly WebApiContext _context;
public MenuitemHasAllergiesController(WebApiContext context)
{
_context = context;
}
// GET: api/MenuitemHasAllergies
[HttpGet]
public async Task<ActionResult<IEnumerable<MenuitemHasAllergie>>> GetMenuitemHasAllergie()
{
if (_context.MenuitemHasAllergie == null)
{
return NotFound();
}
return await _context.MenuitemHasAllergie.ToListAsync();
}
// GET: api/MenuitemHasAllergies/5
[HttpGet("{id}")]
public async Task<ActionResult<MenuitemHasAllergie>> GetMenuitemHasAllergie(int? id)
{
if (_context.MenuitemHasAllergie == null)
{
return NotFound();
}
var menuitemHasAllergie = await _context.MenuitemHasAllergie.FindAsync(id);
if (menuitemHasAllergie == null)
{
return NotFound();
}
return menuitemHasAllergie;
}
// PUT: api/MenuitemHasAllergies/5
// To protect from overposting attacks, see https://go.microsoft.com/fwlink/?linkid=2123754
[HttpPut("{id}")]
public async Task<IActionResult> PutMenuitemHasAllergie(int? id, MenuitemHasAllergie menuitemHasAllergie)
{
if (id != menuitemHasAllergie.MenuItem_IDMenuItem)
{
return BadRequest();
}
_context.Entry(menuitemHasAllergie).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MenuitemHasAllergieExists(id))
{
return NotFound();
}
else
{
throw;
}
}
return NoContent();
}
// POST: api/MenuitemHasAllergies
// To protect from overposting attacks, see https://go.microsoft.com/fwlink/?linkid=2123754
[HttpPost]
public async Task<ActionResult<MenuitemHasAllergie>> PostMenuitemHasAllergie(MenuitemHasAllergie menuitemHasAllergie)
{
if (_context.MenuitemHasAllergie == null)
{
return Problem("Entity set 'WebApiContext.MenuitemHasAllergie' is null.");
}
_context.MenuitemHasAllergie.Add(menuitemHasAllergie);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (MenuitemHasAllergieExists(menuitemHasAllergie.MenuItem_IDMenuItem))
{
return Conflict();
}
else
{
throw;
}
}
return CreatedAtAction("GetMenuitemHasAllergie", new { id = menuitemHasAllergie.MenuItem_IDMenuItem }, menuitemHasAllergie);
}
// DELETE: api/MenuitemHasAllergies/5
[HttpDelete("{id}")]
public async Task<IActionResult> DeleteMenuitemHasAllergie(int? id)
{
if (_context.MenuitemHasAllergie == null)
{
return NotFound();
}
var menuitemHasAllergie = await _context.MenuitemHasAllergie.FindAsync(id);
if (menuitemHasAllergie == null)
{
return NotFound();
}
_context.MenuitemHasAllergie.Remove(menuitemHasAllergie);
await _context.SaveChangesAsync();
return NoContent();
}
private bool MenuitemHasAllergieExists(int? id)
{
return (_context.MenuitemHasAllergie?.Any(e => e.MenuItem_IDMenuItem == id)).GetValueOrDefault();
}
}
}

View File

@ -7,231 +7,239 @@ namespace WebApi.Data;
public partial class WebApiContext : DbContext public partial class WebApiContext : DbContext
{ {
public WebApiContext(DbContextOptions<WebApiContext> options) public WebApiContext(DbContextOptions<WebApiContext> options)
: base(options) : base(options)
{ {
} }
public virtual DbSet<Allergie> Allergies { get; set; } public virtual DbSet<Allergie> Allergies { get; set; }
public virtual DbSet<Bestellungsposition> Bestellungspositions { get; set; } public virtual DbSet<Bestellungsposition> Bestellungspositions { get; set; }
public virtual DbSet<Kunde> Kundes { get; set; } public virtual DbSet<Kunde> Kundes { get; set; }
public virtual DbSet<Menuitem> Menuitems { get; set; } public virtual DbSet<Menuitem> Menuitems { get; set; }
public virtual DbSet<Menuitemkategorie> Menuitemkategories { get; set; } public virtual DbSet<Menuitemkategorie> Menuitemkategories { get; set; }
public virtual DbSet<Menuitemueberkategorie> Menuitemueberkategories { get; set; } public virtual DbSet<Menuitemueberkategorie> Menuitemueberkategories { get; set; }
public virtual DbSet<Rabatt> Rabatts { get; set; } public virtual DbSet<Rabatt> Rabatts { get; set; }
public virtual DbSet<Admin> Admins{ get; set; } public virtual DbSet<MenuitemHasAllergie> MenuitemHasAllergie { get; set; }
public virtual DbSet<Admin> Admins { get; set; }
public virtual DbSet<BestellungspositionHasMenuitem> BestellungspositionHasMenuitem { get; set; }
protected override void OnModelCreating(ModelBuilder modelBuilder) protected override void OnModelCreating(ModelBuilder modelBuilder)
{ {
modelBuilder modelBuilder
.UseCollation("utf8_general_ci") .UseCollation("utf8_general_ci")
.HasCharSet("utf8"); .HasCharSet("utf8");
modelBuilder.Entity<Allergie>(entity => modelBuilder.Entity<Allergie>(entity =>
{ {
entity.HasKey(e => e.Idallergie).HasName("PRIMARY"); entity.HasKey(e => e.Idallergie).HasName("PRIMARY");
entity.ToTable("allergie"); entity.ToTable("allergie");
entity.Property(e => e.Idallergie) entity.Property(e => e.Idallergie)
.ValueGeneratedNever() .ValueGeneratedNever()
.HasColumnType("int(11)") .HasColumnType("int(11)")
.HasColumnName("IDAllergie"); .HasColumnName("IDAllergie");
entity.Property(e => e.Beschreibung).HasMaxLength(45); entity.Property(e => e.Beschreibung).HasMaxLength(45);
}); });
modelBuilder.Entity<Bestellungsposition>(entity => modelBuilder.Entity<Bestellungsposition>(entity =>
{ {
entity.HasKey(e => e.Idbestellung).HasName("PRIMARY"); entity.HasKey(e => e.Idbestellung).HasName("PRIMARY");
entity.ToTable("bestellungsposition"); entity.ToTable("bestellungsposition");
entity.HasIndex(e => e.KundeIdkunde, "fk_Bestellung_Kunde"); entity.HasIndex(e => e.KundeIdkunde, "fk_Bestellung_Kunde");
entity.HasIndex(e => e.RabattIdrabatt, "fk_Bestellungsposition_Rabatt1"); entity.HasIndex(e => e.RabattIdrabatt, "fk_Bestellungsposition_Rabatt1");
entity.Property(e => e.Idbestellung) entity.Property(e => e.Idbestellung)
.ValueGeneratedNever() .ValueGeneratedNever()
.HasColumnType("int(11)") .HasColumnType("int(11)")
.HasColumnName("IDBestellung"); .HasColumnName("IDBestellung");
entity.Property(e => e.Datum).HasColumnType("datetime"); entity.Property(e => e.Datum).HasColumnType("datetime");
entity.Property(e => e.KundeIdkunde) entity.Property(e => e.KundeIdkunde)
.HasColumnType("int(11)") .HasColumnType("int(11)")
.HasColumnName("Kunde_IDKunde"); .HasColumnName("Kunde_IDKunde");
entity.Property(e => e.Menge).HasColumnType("int(11)"); entity.Property(e => e.Menge).HasColumnType("int(11)");
entity.Property(e => e.RabattIdrabatt) entity.Property(e => e.RabattIdrabatt)
.HasColumnType("int(11)") .HasColumnType("int(11)")
.HasColumnName("Rabatt_IDRabatt"); .HasColumnName("Rabatt_IDRabatt");
entity.HasOne(d => d.KundeIdkundeNavigation).WithMany(p => p.Bestellungspositions) entity.HasOne(d => d.KundeIdkundeNavigation).WithMany(p => p.Bestellungspositions)
.HasForeignKey(d => d.KundeIdkunde) .HasForeignKey(d => d.KundeIdkunde)
.OnDelete(DeleteBehavior.ClientSetNull) .OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("fk_Bestellung_Kunde"); .HasConstraintName("fk_Bestellung_Kunde");
entity.HasOne(d => d.RabattIdrabattNavigation).WithMany(p => p.Bestellungspositions) entity.HasOne(d => d.RabattIdrabattNavigation).WithMany(p => p.Bestellungspositions)
.HasForeignKey(d => d.RabattIdrabatt) .HasForeignKey(d => d.RabattIdrabatt)
.OnDelete(DeleteBehavior.ClientSetNull) .OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("fk_Bestellungsposition_Rabatt1"); .HasConstraintName("fk_Bestellungsposition_Rabatt1");
entity.HasMany(d => d.MenuItemIdmenuItems).WithMany(p => p.BestellungspositionIdbestellungs) //entity.HasMany(d => d.MenuItemIdmenuItems).WithMany(p => p.BestellungspositionIdbestellungs)
.UsingEntity<Dictionary<string, object>>( // .UsingEntity<Dictionary<string, object>>(
"BestellungspositionHasMenuitem", // "BestellungspositionHasMenuitem",
r => r.HasOne<Menuitem>().WithMany() // r => r.HasOne<Menuitem>().WithMany()
.HasForeignKey("MenuItemIdmenuItem") // .HasForeignKey("MenuItemIdmenuItem")
.OnDelete(DeleteBehavior.ClientSetNull) // .OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("fk_Bestellungsposition_has_MenuItem_MenuItem1"), // .HasConstraintName("fk_Bestellungsposition_has_MenuItem_MenuItem1"),
l => l.HasOne<Bestellungsposition>().WithMany() // l => l.HasOne<Bestellungsposition>().WithMany()
.HasForeignKey("BestellungspositionIdbestellung") // .HasForeignKey("BestellungspositionIdbestellung")
.OnDelete(DeleteBehavior.ClientSetNull) // .OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("fk_Bestellungsposition_has_MenuItem_Bestellungsposition1"), // .HasConstraintName("fk_Bestellungsposition_has_MenuItem_Bestellungsposition1"),
j => // j =>
{ // {
j.HasKey("BestellungspositionIdbestellung", "MenuItemIdmenuItem") // j.HasKey("BestellungspositionIdbestellung", "MenuItemIdmenuItem")
.HasName("PRIMARY") // .HasName("PRIMARY")
.HasAnnotation("MySql:IndexPrefixLength", new[] { 0, 0 }); // .HasAnnotation("MySql:IndexPrefixLength", new[] { 0, 0 });
j.ToTable("bestellungsposition_has_menuitem"); // j.ToTable("bestellungsposition_has_menuitem");
j.HasIndex(new[] { "MenuItemIdmenuItem" }, "fk_Bestellungsposition_has_MenuItem_MenuItem1"); // j.HasIndex(new[] { "MenuItemIdmenuItem" }, "fk_Bestellungsposition_has_MenuItem_MenuItem1");
j.IndexerProperty<int>("BestellungspositionIdbestellung") // j.IndexerProperty<int>("BestellungspositionIdbestellung")
.HasColumnType("int(11)") // .HasColumnType("int(11)")
.HasColumnName("Bestellungsposition_IDBestellung"); // .HasColumnName("Bestellungsposition_IDBestellung");
j.IndexerProperty<int>("MenuItemIdmenuItem") // j.IndexerProperty<int>("MenuItemIdmenuItem")
.HasColumnType("int(11)") // .HasColumnType("int(11)")
.HasColumnName("MenuItem_IDMenuItem"); // .HasColumnName("MenuItem_IDMenuItem");
}); // });
}); });
modelBuilder.Entity<Kunde>(entity => modelBuilder.Entity<Kunde>(entity =>
{ {
entity.HasKey(e => e.Idkunde).HasName("PRIMARY"); entity.HasKey(e => e.Idkunde).HasName("PRIMARY");
entity.ToTable("kunde"); entity.ToTable("kunde");
entity.Property(e => e.Idkunde) entity.Property(e => e.Idkunde)
.ValueGeneratedNever() .ValueGeneratedNever()
.HasColumnType("int(11)") .HasColumnType("int(11)")
.HasColumnName("IDKunde"); .HasColumnName("IDKunde");
entity.Property(e => e.Code) entity.Property(e => e.Code)
.HasMaxLength(45) .HasMaxLength(45)
.HasColumnName("code"); .HasColumnName("code");
entity.Property(e => e.Treuepunkte).HasColumnType("int(11)"); entity.Property(e => e.Treuepunkte).HasColumnType("int(11)");
}); });
modelBuilder.Entity<Menuitem>(entity => modelBuilder.Entity<Menuitem>(entity =>
{ {
entity.HasKey(e => e.IdmenuItem).HasName("PRIMARY"); entity.HasKey(e => e.IdmenuItem).HasName("PRIMARY");
entity.ToTable("menuitem"); entity.ToTable("menuitem");
entity.HasIndex(e => e.MenuItemKategorieIdmenuItemKategorie, "fk_MenuItem_MenuItemKategorie1"); entity.HasIndex(e => e.MenuItemKategorieIdmenuItemKategorie, "fk_MenuItem_MenuItemKategorie1");
entity.Property(e => e.IdmenuItem) entity.Property(e => e.IdmenuItem)
.ValueGeneratedNever() .ValueGeneratedNever()
.HasColumnType("int(11)") .HasColumnType("int(11)")
.HasColumnName("IDMenuItem"); .HasColumnName("IDMenuItem");
entity.Property(e => e.Bezeichnung).HasMaxLength(45); entity.Property(e => e.Bezeichnung).HasMaxLength(45);
entity.Property(e => e.MenuItemKategorieIdmenuItemKategorie) entity.Property(e => e.MenuItemKategorieIdmenuItemKategorie)
.HasColumnType("int(11)") .HasColumnType("int(11)")
.HasColumnName("MenuItemKategorie_IDMenuItemKategorie"); .HasColumnName("MenuItemKategorie_IDMenuItemKategorie");
entity.Property(e => e.Preis).HasPrecision(8, 2); entity.Property(e => e.Preis).HasPrecision(8, 2);
entity.Property(e => e.Zusatzinformation).HasMaxLength(45); entity.Property(e => e.Zusatzinformation).HasMaxLength(45);
entity.HasOne(d => d.MenuItemKategorieIdmenuItemKategorieNavigation).WithMany(p => p.Menuitems) entity.HasOne(d => d.MenuItemKategorieIdmenuItemKategorieNavigation).WithMany(p => p.Menuitems)
.HasForeignKey(d => d.MenuItemKategorieIdmenuItemKategorie) .HasForeignKey(d => d.MenuItemKategorieIdmenuItemKategorie)
.OnDelete(DeleteBehavior.ClientSetNull) .OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("fk_MenuItem_MenuItemKategorie1"); .HasConstraintName("fk_MenuItem_MenuItemKategorie1");
});
entity.HasMany(d => d.AllergieIdallergies).WithMany(p => p.MenuItemIdmenuItems) modelBuilder.Entity<Menuitemkategorie>(entity =>
.UsingEntity<Dictionary<string, object>>( {
"MenuitemHasAllergie", entity.HasKey(e => e.IdmenuItemKategorie).HasName("PRIMARY");
r => r.HasOne<Allergie>().WithMany()
.HasForeignKey("AllergieIdallergie")
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("fk_MenuItem_has_Allergie_Allergie1"),
l => l.HasOne<Menuitem>().WithMany()
.HasForeignKey("MenuItemIdmenuItem")
.OnDelete(DeleteBehavior.ClientSetNull)
.HasConstraintName("fk_MenuItem_has_Allergie_MenuItem1"),
j =>
{
j.HasKey("MenuItemIdmenuItem", "AllergieIdallergie")
.HasName("PRIMARY")
.HasAnnotation("MySql:IndexPrefixLength", new[] { 0, 0 });
j.ToTable("menuitem_has_allergie");
j.HasIndex(new[] { "AllergieIdallergie" }, "fk_MenuItem_has_Allergie_Allergie1");
j.IndexerProperty<int>("MenuItemIdmenuItem")
.HasColumnType("int(11)")
.HasColumnName("MenuItem_IDMenuItem");
j.IndexerProperty<int>("AllergieIdallergie")
.HasColumnType("int(11)")
.HasColumnName("Allergie_IDAllergie");
});
});
modelBuilder.Entity<Menuitemkategorie>(entity => entity.ToTable("menuitemkategorie");
{
entity.HasKey(e => e.IdmenuItemKategorie).HasName("PRIMARY");
entity.ToTable("menuitemkategorie"); entity.HasIndex(e => e.MenuItemUeberkategorieIdmenuItemUeberkategorie, "fk_MenuItemKategorie_MenuItemUeberkategorie1");
entity.HasIndex(e => e.MenuItemUeberkategorieIdmenuItemUeberkategorie, "fk_MenuItemKategorie_MenuItemUeberkategorie1"); entity.Property(e => e.IdmenuItemKategorie)
.ValueGeneratedNever()
.HasColumnType("int(11)")
.HasColumnName("IDMenuItemKategorie");
entity.Property(e => e.Bezeichnung).HasMaxLength(45);
entity.Property(e => e.MenuItemUeberkategorieIdmenuItemUeberkategorie)
.HasColumnType("int(11)")
.HasColumnName("MenuItemUeberkategorie_IDMenuItemUeberkategorie");
entity.Property(e => e.IdmenuItemKategorie) entity.HasOne(d => d.MenuItemUeberkategorieIdmenuItemUeberkategorieNavigation).WithMany(p => p.Menuitemkategories)
.ValueGeneratedNever() .HasForeignKey(d => d.MenuItemUeberkategorieIdmenuItemUeberkategorie)
.HasColumnType("int(11)") .OnDelete(DeleteBehavior.ClientSetNull)
.HasColumnName("IDMenuItemKategorie"); .HasConstraintName("fk_MenuItemKategorie_MenuItemUeberkategorie1");
entity.Property(e => e.Bezeichnung).HasMaxLength(45); });
entity.Property(e => e.MenuItemUeberkategorieIdmenuItemUeberkategorie)
.HasColumnType("int(11)")
.HasColumnName("MenuItemUeberkategorie_IDMenuItemUeberkategorie");
entity.HasOne(d => d.MenuItemUeberkategorieIdmenuItemUeberkategorieNavigation).WithMany(p => p.Menuitemkategories) modelBuilder.Entity<Menuitemueberkategorie>(entity =>
.HasForeignKey(d => d.MenuItemUeberkategorieIdmenuItemUeberkategorie) {
.OnDelete(DeleteBehavior.ClientSetNull) entity.HasKey(e => e.IdmenuItemUeberkategorie).HasName("PRIMARY");
.HasConstraintName("fk_MenuItemKategorie_MenuItemUeberkategorie1");
});
modelBuilder.Entity<Menuitemueberkategorie>(entity => entity.ToTable("menuitemueberkategorie");
{
entity.HasKey(e => e.IdmenuItemUeberkategorie).HasName("PRIMARY");
entity.ToTable("menuitemueberkategorie"); entity.Property(e => e.IdmenuItemUeberkategorie)
.ValueGeneratedNever()
.HasColumnType("int(11)")
.HasColumnName("IDMenuItemUeberkategorie");
entity.Property(e => e.Bezeichnung).HasMaxLength(45);
});
entity.Property(e => e.IdmenuItemUeberkategorie) modelBuilder.Entity<Rabatt>(entity =>
.ValueGeneratedNever() {
.HasColumnType("int(11)") entity.HasKey(e => e.Idrabatt).HasName("PRIMARY");
.HasColumnName("IDMenuItemUeberkategorie");
entity.Property(e => e.Bezeichnung).HasMaxLength(45);
});
modelBuilder.Entity<Rabatt>(entity => entity.ToTable("rabatt");
{
entity.HasKey(e => e.Idrabatt).HasName("PRIMARY");
entity.ToTable("rabatt"); entity.Property(e => e.Idrabatt)
.ValueGeneratedNever()
.HasColumnType("int(11)")
.HasColumnName("IDRabatt");
entity.Property(e => e.GueltigkeitBis).HasColumnType("datetime");
entity.Property(e => e.GueltigkeitVon).HasColumnType("datetime");
entity.Property(e => e.Prozent).HasPrecision(8, 2);
});
entity.Property(e => e.Idrabatt) modelBuilder.Entity<Admin>(entity =>
.ValueGeneratedNever() {
.HasColumnType("int(11)") entity.HasKey(e => e.Id).HasName("PRIMARY");
.HasColumnName("IDRabatt"); entity.ToTable("admin");
entity.Property(e => e.GueltigkeitBis).HasColumnType("datetime"); entity.Property(e => e.Id)
entity.Property(e => e.GueltigkeitVon).HasColumnType("datetime"); .ValueGeneratedNever()
entity.Property(e => e.Prozent).HasPrecision(8, 2); .HasColumnType("int(11)")
}); .HasColumnName("Id");
entity.Property(e => e.Username).HasMaxLength(100);
entity.Property(e => e.Password).HasMaxLength(100);
});
modelBuilder.Entity<Admin>(entity => modelBuilder.Entity<BestellungspositionHasMenuitem>(entity =>
{ {
entity.HasKey(e => e.Id).HasName("PRIMARY"); entity.HasKey(e => new { e.Bestellungsposition_IDBestellung, e.MenuItem_IDMenuItem })
entity.ToTable("admin"); .HasName("PRIMARY");
});
OnModelCreatingPartial(modelBuilder); entity.ToTable("bestellungsposition_has_menuitem");
}
entity.Property(e => e.Bestellungsposition_IDBestellung).HasColumnType("int(11)").HasColumnName("Bestellungsposition_IDBestellung");
entity.Property(e => e.MenuItem_IDMenuItem).HasColumnType("int(11)").HasColumnName("MenuItem_IDMenuItem");
});
modelBuilder.Entity<MenuitemHasAllergie>(entity =>
{
entity.HasKey(e => new { e.MenuItem_IDMenuItem, e.Allergie_IDAllergie })
.HasName("PRIMARY");
entity.ToTable("menuitem_has_allergie");
entity.Property(e => e.MenuItem_IDMenuItem).HasColumnType("int(11)");
entity.Property(e => e.Allergie_IDAllergie).HasColumnType("int(11)");
});
OnModelCreatingPartial(modelBuilder);
}
partial void OnModelCreatingPartial(ModelBuilder modelBuilder);
partial void OnModelCreatingPartial(ModelBuilder modelBuilder);
} }

View File

@ -1,23 +1,23 @@
using System; using System;
using System.Collections.Generic; using System.Collections.Generic;
namespace WebApi.Models; namespace WebApi.Models;
public partial class Bestellungsposition public partial class Bestellungsposition
{ {
public int Idbestellung { get; set; } public int Idbestellung { get; set; }
public int? Menge { get; set; } public int? Menge { get; set; }
public DateTime? Datum { get; set; } public DateTime? Datum { get; set; }
public int KundeIdkunde { get; set; } public int KundeIdkunde { get; set; }
public int RabattIdrabatt { get; set; } public int? RabattIdrabatt { get; set; }
public virtual Kunde KundeIdkundeNavigation { get; set; } = null!; public virtual Kunde? KundeIdkundeNavigation { get; set; } = null!;
public virtual Rabatt RabattIdrabattNavigation { get; set; } = null!; public virtual Rabatt? RabattIdrabattNavigation { get; set; } = null!;
public virtual ICollection<Menuitem> MenuItemIdmenuItems { get; set; } = new List<Menuitem>(); public virtual ICollection<Menuitem>? MenuItemIdmenuItems { get; set; } = new List<Menuitem>();
} }

View File

@ -0,0 +1,11 @@
using System;
using System.Collections.Generic;
namespace WebApi.Models;
public partial class BestellungspositionHasMenuitem
{
public int? Bestellungsposition_IDBestellung { get; set; }
public int? MenuItem_IDMenuItem { get; set; }
}

View File

@ -0,0 +1,11 @@
namespace WebApi.Models
{
public class MenuitemHasAllergie
{
// navigation references Menuitem
public int? MenuItem_IDMenuItem { get; set; }
// navigation references Allergie
public int? Allergie_IDAllergie { get; set; }
}
}

View File

@ -1,12 +0,0 @@
{
"Logging": {
"LogLevel": {
"Default": "Information",
"Microsoft.AspNetCore": "Warning"
}
},
"AllowedHosts": "*",
"ConnectionStrings": {
"Y4FDB": "Server=localhost;Database=y4f;Uid=user;Pwd=user"
}
}

View File

@ -1,129 +1,323 @@
@page "/shopping_cart" @page "/shopping_cart"
@inject HttpClient Http
@inject Blazored.LocalStorage.ISyncLocalStorageService localStorage
@inject NavigationManager _navigationManager
<PageTitle>Warenkorb</PageTitle> <PageTitle>Warenkorb</PageTitle>
<h1>Warenkorb</h1> <h1>Warenkorb</h1>
<div class="container"> <div class="container">
<div class="row"> <div class="row">
</div> </div>
</div> </div>
<div class="container"> <div class="container">
<div class="row"> <div class="row">
<div class="col-sm-12 col-lg-6"> <div class="col-sm-12 col-lg-6">
@*Tabelle Ihre Bestellung*@ @*Tabelle Ihre Bestellung*@
<div class="tbl-container"> <div class="tbl-container">
<table class="table bdr"> <table class="table bdr">
<thead class="bg_green"> <thead class="bg_green">
<tr> <tr>
<td>Ihre Bestellung</td> <td>Ihre Bestellung</td>
<th></th> <th></th>
</tr> </tr>
</thead> </thead>
<tbody class="bg_lightgreen"> <tbody class="bg_lightgreen">
<tr> @if (menuitemIds.Count == 0)
<td class="br" style="padding-top:20px; padding-bottom:0px; border-bottom-width: 0px;"> {
1 Nudel mit Hühnerfleisch (groß) <div class="card-body">
<div style="font-size:0.7rem;padding-left:15px;">mit Knoblauchsoße</div> <h5 class="card-title" style="font-size:10pt; margin-bottom:0px;">Warenkorb ist leer</h5>
</td> </div>
<td class="d-flex justify-content-center align-items-center" style="padding-top:20px; padding-bottom:0px;">9,10€</td> }
</tr> else
<tr> {
<td class="br" style=" padding-top:0px; border-bottom-width: 0px;">1 Coca Cola</td> @foreach (var item in menuitemIds)
<td class="d-flex justify-content-center align-items-center" style="padding-top:0px;">2,50€</td> {
</tr> @foreach (var item2 in menuitems)
<tr> {
<td class="br" style=" padding-top:0px; border-bottom-width: 0px;"></td> @if (item.Key == item2.IdmenuItem)
<td class="d-flex justify-content-center align-items-center"></td> {
</tr> <tr>
<tr>
<td class="br" style=" padding-top:0px; border-bottom-width: 0px;"></td>
<td class="d-flex justify-content-center align-items-center"></td>
</tr>
<tr>
<td class="br" style=" padding-top:0px; border-bottom-width: 0px;"></td>
<td class="d-flex justify-content-center align-items-center"></td>
</tr>
<tr>
<td class="br" style=" padding-top:0px; border-bottom-width: 0px;"></td>
<td class="d-flex justify-content-center align-items-center"></td>
</tr>
<tr>
<td class="br" style=" padding-top:0px; border-bottom-width: 0px;"></td>
<td class="d-flex justify-content-center align-items-center"></td>
</tr>
<tr>
<td class="br" style=" padding-top:0px; border-bottom-width: 0px;"></td>
<td class="d-flex justify-content-center align-items-center"></td>
</tr>
<tr>
<td class="br" style=" padding-top:0px; border-bottom-width: 0px;"></td>
<td class="d-flex justify-content-center align-items-center"></td>
</tr>
<tr>
<td class="br" style=" padding-top:0px; border-bottom-width: 0px;"></td>
<td class="d-flex justify-content-center align-items-center" style="border-bottom-width: 0px;"></td>
</tr>
</tbody>
<tfoot class="bg_lightgreen">
<tr style="border-top:solid 1px black;">
<th class="" style="text-align:right;">Summe</th>
<td class="d-flex justify-content-center align-items-center">11,60€</td>
</tr>
</tfoot>
</table>
</div> <td class="br" style="padding-top:20px; padding-bottom:0px; border-bottom-width: 0px;">
@item.Value x
@item2.Bezeichnung
<button @onclick="@(() => DelMenuItemId(item.Key))" class="btn btn-danger">del</button>
</div>
<div class="col-sm-12 col-lg-6">
<div class="h-100">
@*Essen Abholen?*@
<div class="row h-25 w-100">
<div class="col">
<div class="d-flex flex-column align-items-center ">
<div class="tbl-container bdr w-100">
<!-- <== overflow: hidden applied to parent -->
<table class="table bdr" cellspacing="0" cellpadding="0">
<thead class="bg_green">
<tr>
<td class="d-flex justify-content-center align-items-center" style="border-bottom:0px;">
Wann wollen Sie Ihr Essen abholen?
</td>
</tr>
</thead>
<tbody class="bg_lightgreen">
<tr>
<td class="d-flex justify-content-center align-items-center" style="padding-top:0px;">
<div style="margin:20px;">
<div class="d-flex justify-content-center align-items-center">
<input type="number" style="width:80px" min="10" max="20" />
<input type="number" style="width:80px" min="0" max="59" />
&nbsp;
Uhr
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
@*Buttons*@ <div style="font-size:0.7rem;padding-left:15px;">@item2.Zusatzinformation</div>
<div class="row h-75 w-100"> </td>
<div class="col mt-auto"> <td class="d-flex justify-content-center align-items-center" style="padding-top:20px; border-bottom-width:0px;">@(item2.Preis * item.Value)€</td>
<div class="d-flex flex-column align-items-center "> </tr>
<button class="btn_back w-75">Zurück</button> }
<button class="btn_forward w-75">Weiter</button> }
</div>
</div> }
</div> }
</div> </tbody>
</div> <tfoot class="bg_lightgreen">
</div> <tr style="border-top:solid 1px black;">
<th class="" style="text-align:right;">Summe</th>
<td class="d-flex justify-content-center align-items-center">
@summe€
</td>
</tr>
</tfoot>
</table>
</div>
</div>
<div class="col-sm-12 col-lg-6">
<div class="h-100">
@*Essen Abholen?*@
<div class="row h-25 w-100 ">
<div class="col">
<div class="d-flex flex-column align-items-center ">
<div class="tbl-container bdr w-100">
<!-- <== overflow: hidden applied to parent -->
<table class="table bdr" cellspacing="0" cellpadding="0">
<thead class="bg_green">
<tr>
<td class="d-flex justify-content-center align-items-center" style="border-bottom:0px;">
Wann wollen Sie Ihr Essen abholen?
</td>
</tr>
</thead>
<tbody class="bg_lightgreen">
<tr>
<td class="d-flex justify-content-center align-items-center" style="padding-top:0px;">
<div style="margin:20px;">
<div class="d-flex justify-content-center align-items-center">
<input type="number" style="width:80px" min="10" max="19" @bind-value="@hour" @onclick="@(()=>UpdateTime())" />
<input type="number" style="width:80px" min="0" max="59" @bind-value="@minute" @onclick="@(()=>UpdateTime())" />
&nbsp;
Uhr
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
@*Buttons*@
<div class="row h-75 w-100">
<div class="col mt-auto ">
<div class="d-flex flex-column align-items-center ">
<a href="/speisekarte" class="btn_bg w-75 btn text-center">Zurück</a>
<a class="btn_forward btn w-75 " @onclick="@(() => SetBestllung())">Weiter</a>
</div>
</div>
</div>
</div>
</div>
</div>
</div> </div>
@code {
public int hour;
public int minute;
private void UpdateTime()
{
localStorage.SetItem<int>("Hour", hour);
localStorage.SetItem<int>("Minute", minute);
}
private void SetBestllung()
{
if (menuitemIds.Count == 0)
{
return;
}
UpdateTime();
localStorage.SetItem<Dictionary<int, int>>("MenuItemIds", menuitemIds);
_navigationManager.NavigateTo("/Bestellabschluss");
}
public decimal summe;
public Dictionary<int, int> menuitemIds = new Dictionary<int, int>();
private void SetMenuItemId(int id)
{
if (menuitemIds.ContainsKey(id))
{
menuitemIds[id]++;
}
else
{
menuitemIds.Add(id, 1);
}
localStorage.SetItem<Dictionary<int, int>>("MenuItemIds", menuitemIds);
}
private void DelMenuItemId(int id)
{
if (menuitemIds.ContainsKey(id))
{
if (menuitemIds[id] > 1)
{
menuitemIds[id]--;
}
else
{
menuitemIds.Remove(id);
}
}
localStorage.SetItem<Dictionary<int, int>>("MenuItemIds", menuitemIds);
_navigationManager.NavigateTo(_navigationManager.Uri, forceLoad: true);
}
// allergien, bestellungsposition, kunde, menuitem, menuitemkategorie, menuitemueberkategorie, rabatt
private List<Allergie> allergien = new List<Allergie>();
private List<Bestellungsposition> bestellungspositions = new List<Bestellungsposition>();
private List<Kunde> kunden = new List<Kunde>();
private List<Menuitem> menuitems = new List<Menuitem>();
private List<Menuitemkategorie> menuitemkategories = new List<Menuitemkategorie>();
private List<Menuitemueberkategorie> menuitemueberkategories = new List<Menuitemueberkategorie>();
private List<Rabatt> rabatte = new List<Rabatt>();
protected override async Task OnInitializedAsync()
{
// get data from localstorage
if (localStorage.GetItem<Dictionary<int, int>>("MenuItemIds") != null)
{
menuitemIds = localStorage.GetItem<Dictionary<int, int>>("MenuItemIds");
}
// get data from api
allergien = await Http.GetFromJsonAsync<List<Allergie>>("https://localhost:7076/api/allergien");
bestellungspositions = await Http.GetFromJsonAsync<List<Bestellungsposition>>("https://localhost:7076/api/bestellungspositionen");
kunden = await Http.GetFromJsonAsync<List<Kunde>>("https://localhost:7076/api/kunden");
menuitems = await Http.GetFromJsonAsync<List<Menuitem>>("https://localhost:7076/api/Menuitems");
menuitemkategories = await Http.GetFromJsonAsync<List<Menuitemkategorie>>("https://localhost:7076/api/Menuitemkategories");
menuitemueberkategories = await Http.GetFromJsonAsync<List<Menuitemueberkategorie>>("https://localhost:7076/api/Menuitemueberkategories");
rabatte = await Http.GetFromJsonAsync<List<Rabatt>>("https://localhost:7076/api/Rabatte");
// calculate the sum of all menuitems
summe = 0;
foreach (var item in menuitemIds)
{
foreach (var item2 in menuitems)
{
if (item.Key == item2.IdmenuItem)
{
summe += item2.Preis * item.Value;
}
}
}
localStorage.SetItem<decimal>("Summe", summe);
// if hour/minute is set, set the values
if (localStorage.GetItem<int>("Hour") != 0)
{
hour = localStorage.GetItem<int>("Hour");
}
if (localStorage.GetItem<int>("Minute") != 0)
{
minute = localStorage.GetItem<int>("Minute");
}
}
public class Allergie
{
public int Idallergie { get; set; }
public string? Beschreibung { get; set; }
public virtual ICollection<Menuitem> MenuItemIdmenuItems { get; set; } = new List<Menuitem>();
}
public class Bestellungsposition
{
public int Idbestellung { get; set; }
public int? Menge { get; set; }
public DateTime? Datum { get; set; }
public int KundeIdkunde { get; set; }
public int? RabattIdrabatt { get; set; }
public virtual Kunde KundeIdkundeNavigation { get; set; } = null!;
public virtual Rabatt RabattIdrabattNavigation { get; set; } = null!;
public virtual ICollection<Menuitem> MenuItemIdmenuItems { get; set; } = new List<Menuitem>();
}
public class Kunde
{
public int Idkunde { get; set; }
public string? Code { get; set; }
public int? Treuepunkte { get; set; }
public virtual ICollection<Bestellungsposition> Bestellungspositions { get; set; } = new List<Bestellungsposition>();
}
public class Menuitem
{
public int IdmenuItem { get; set; }
public string? Bezeichnung { get; set; }
public string? Zusatzinformation { get; set; }
public decimal Preis { get; set; }
public int MenuItemKategorieIdmenuItemKategorie { get; set; }
public virtual Menuitemkategorie MenuItemKategorieIdmenuItemKategorieNavigation { get; set; } = null!;
public virtual ICollection<Allergie> AllergieIdallergies { get; set; } = new List<Allergie>();
public virtual ICollection<Bestellungsposition> BestellungspositionIdbestellungs { get; set; } = new List<Bestellungsposition>();
}
public class Menuitemkategorie
{
public int IdmenuItemKategorie { get; set; }
public string? Bezeichnung { get; set; }
public int MenuItemUeberkategorieIdmenuItemUeberkategorie { get; set; }
public virtual Menuitemueberkategorie MenuItemUeberkategorieIdmenuItemUeberkategorieNavigation { get; set; } = null!;
public virtual ICollection<Menuitem> Menuitems { get; set; } = new List<Menuitem>();
}
public class Menuitemueberkategorie
{
public int IdmenuItemUeberkategorie { get; set; }
public string? Bezeichnung { get; set; }
public virtual ICollection<Menuitemkategorie> Menuitemkategories { get; set; } = new List<Menuitemkategorie>();
}
public class Rabatt
{
public int Idrabatt { get; set; }
public decimal? Prozent { get; set; }
public DateTime? GueltigkeitVon { get; set; }
public DateTime? GueltigkeitBis { get; set; }
public virtual ICollection<Bestellungsposition> Bestellungspositions { get; set; } = new List<Bestellungsposition>();
}
}

View File

@ -1,124 +1,100 @@
@page "/Speisekarte" @page "/Speisekarte"
@inject HttpClient Http
<h1>Speisekarte</h1>
<div class="row justify-content-center"> <div class="row justify-content-center">
<div class="col-lg-2 col-md-4 col-sm-12 tablecolumn"> @foreach (var item in menuitemueberkategories)
<table class="table table-light overflow-hidden"> {
<thead> <div class="col-lg-2 col-md-4 col-sm-12 tablecolumn">
<tr> <table class="table table-light overflow-hidden">
<th scope="col">Chinesisch</th> <thead>
</tr> <tr>
</thead> <th scope="col">@item.Bezeichnung</th>
<tbody> </tr>
<tr> </thead>
<td><a href="">Nudeln</a></td> <tbody>
</tr> @foreach (var item2 in menuitemkategories)
<tr> {
<td><a href="">Reis</a></td> if (item.IdmenuItemUeberkategorie == item2.MenuItemUeberkategorieIdmenuItemUeberkategorie)
</tr> {
<tr> if (@item.Bezeichnung == "Chinesisch")
<td class="lowest"><a href="">Nachspeisen</a></td> {
</tr> <tr>
<tr> <td><a href="/SpeisekarteChinesich">@item2.Bezeichnung</a></td>
<td class="lowest"><br></td> </tr>
</tr> }
<tr> else if (@item.Bezeichnung == "Japanisch")
<td class="lowest"><br></td> {
</tr> <tr>
<tr> <td><a href="/SpeisekarteJapanisch">@item2.Bezeichnung</a></td>
<td class="lowest"><br></td> </tr>
</tr> }
</tbody> else if (@item.Bezeichnung == "Getränke")
</table> {
</div> <tr>
<div class="col-lg-2 col-md-4 col-sm-12 tablecolumn"> <td><a href="/SpeisekarteGetraenke">@item2.Bezeichnung</a></td>
<table class="table table-light overflow-hidden"> </tr>
<thead> }
<tr> else if (@item.Bezeichnung == "Sonstiges")
<th scope="col">Japanisch</th> {
</tr> <tr>
</thead> <td><a href="/SpeisekarteSonstiges">@item2.Bezeichnung</a></td>
<tbody> </tr>
<tr> }
<td><a href="">Sushi & Maki</a></td> else
</tr> {
<tr> <tr>
<td><a href="">Bento</a></td> <td><a href="/">@item2.Bezeichnung</a></td>
</tr> </tr>
<tr> }
<td class="lowest"><a href="">Nachspeisen</a></td> }
</tr> }
<tr> <tr>
<td class="lowest"><br></td> <td class="lowest"><br></td>
</tr> </tr>
<tr> <tr>
<td class="lowest"><br></td> <td class="lowest"><br></td>
</tr>
<tr> </tr>
<td class="lowest"><br></td> <tr>
</tr> <td class="lowest"><br></td>
</tbody> </tr>
</table> </tbody>
</div> </table>
<div class="col-lg-2 col-md-4 col-sm-12 tablecolumn"> </div>
<table class="table table-light overflow-hidden"> }
<thead>
<tr>
<th scope="col">Getränke</th>
</tr>
</thead>
<tbody>
<tr>
<td><a href="">Alkoholfrei</a></td>
</tr>
<tr>
<td class="lowest"><a href="">Alkoholisch</a></td>
</tr>
<tr>
<td class="lowest"><br></td>
</tr>
<tr>
<td class="lowest"><br></td>
</tr>
<tr>
<td class="lowest"><br></td>
</tr>
<tr>
<td class="lowest"><br></td>
</tr>
</tbody>
</table>
</div>
<div class="col-lg-2 col-md-4 col-sm-12 tablecolumn">
<table class="table table-light overflow-hidden">
<thead>
<tr>
<th scope="col">Sonstiges</th>
</tr>
</thead>
<tbody>
<tr>
<td><a href="">Schnitzel</a></td>
</tr>
<tr>
<td><a href="">Pommes</a></td>
</tr>
<tr>
<td class="lowest"><a href="">Bowl</a></td>
</tr>
<tr>
<td class="lowest"><br></td>
</tr>
<tr>
<td class="lowest"><br></td>
</tr>
<tr>
<td class="lowest"><br></td>
</tr>
</tbody>
</table>
</div>
</div> </div>
@code {
}
@code {
private List<Menuitemkategorie> menuitemkategories = new List<Menuitemkategorie>();
private List<Menuitemueberkategorie> menuitemueberkategories = new List<Menuitemueberkategorie>();
protected override async Task OnInitializedAsync()
{
menuitemkategories = await Http.GetFromJsonAsync<List<Menuitemkategorie>>("https://localhost:7076/api/MenuItemKategories");
menuitemueberkategories = await Http.GetFromJsonAsync<List<Menuitemueberkategorie>>("https://localhost:7076/api/MenuItemUeberkategories");
}
public class Menuitemkategorie
{
public int IdmenuItemKategorie { get; set; }
public string Bezeichnung { get; set; }
public int MenuItemUeberkategorieIdmenuItemUeberkategorie { get; set; }
public object MenuItemUeberkategorieIdmenuItemUeberkategorieNavigation { get; set; }
public List<object> MenuItemIdmenuItems { get; set; }
}
public class Menuitemueberkategorie
{
public int IdmenuItemUeberkategorie { get; set; }
public string Bezeichnung { get; set; }
public List<object> MenuItemKategorieIdmenuItemKategories { get; set; }
public List<object> MenuItemIdmenuItems { get; set; }
}
}

View File

@ -0,0 +1,229 @@
@page "/SpeisekarteChinesich"
@inject HttpClient Http
@inject Blazored.LocalStorage.ISyncLocalStorageService localStorage
<h1>Speisekarte Chinesisch</h1>
<div class="container">
<div class="row">
<div class="col-8">
<div class="btn-group d-flex" role="group">
<button type="button" class="btn">Chinesisch</button>
<button type="button" class="btn">Nudel</button>
<button type="button" class="btn">Reis</button>
<button type="button" class="btn">Nachspeise</button>
</div>
@foreach (var item in menuitemueberkategories)
{
@if (item.Bezeichnung == "Chinesisch")
{
@foreach (var item2 in menuitemkategories)
{
if (item2.MenuItemUeberkategorieIdmenuItemUeberkategorie == item.IdmenuItemUeberkategorie)
{
@foreach (var item3 in menuitems)
{
if (item2.IdmenuItemKategorie == item3.MenuItemKategorieIdmenuItemKategorie)
{
<div class="card mt-3 " @onclick="@(() => SetMenuItemId(item3.IdmenuItem))">
<div class="card-body">
@*create two divs columns*@
<div class="row">
<div class="col-8">
<h5 class="card-title">@item3.Bezeichnung</h5>
<p class="card-text">@item3.Zusatzinformation</p>
</div>
@*div text center*@
<div class="col-4 d-flex justify-content-center align-items-center">
<div style="font-size:15pt;">@item3.Preis</div>
</div>
</div>
</div>
</div>
}
}
}
}
}
}
</div>
<div class="col-4">
@* warenkorb anzeige als bootstrap card*@
<div class="card">
<div class="card-header">
Warenkorb
</div>
@if (menuitemIds.Count == 0)
{
<div class="card-body">
<h5 class="card-title" style="font-size:10pt; margin-bottom:0px;">Warenkorb ist leer</h5>
</div>
}
else
{
@foreach (var item in menuitemIds)
{
@foreach (var item2 in menuitems)
{
@if (item.Key == item2.IdmenuItem)
{
<div class="card-body">
<p>@item.Value</p>
<h5 class="card-title" style="font-size:10pt; margin-bottom:0px;">@item2.Bezeichnung</h5>
<p class="card-text" style="font-size:8pt;margin-bottom:0px;">@item2.Zusatzinformation</p>
<p class="card-text" id="preis" style="text-align:right; "><span style="background-color:#c7ffd5; border-radius:20px; font-size:10pt; padding:5px">@item2.Preis</span></p>
</div>
}
}
}
}
</div>
<div class="d-flex flex-column mb-5">
<a href="/speisekarte" class="btn btn-primary mx-2 mt-5">Zurück</a>
<a href="/shopping_cart" class="btn btn-primary mx-2 mt-1 mb-5">Weiter</a>
</div>
</div>
</div>
</div>
@code {
public Dictionary<int, int> menuitemIds = new Dictionary<int, int>();
private void SetMenuItemId(int id)
{
if (menuitemIds.ContainsKey(id))
{
menuitemIds[id]++;
}
else
{
menuitemIds.Add(id, 1);
}
localStorage.SetItem<Dictionary<int, int>>("MenuItemIds", menuitemIds);
}
// allergien, bestellungsposition, kunde, menuitem, menuitemkategorie, menuitemueberkategorie, rabatt
private List<Allergie> allergien = new List<Allergie>();
private List<Bestellungsposition> bestellungspositions = new List<Bestellungsposition>();
private List<Kunde> kunden = new List<Kunde>();
private List<Menuitem> menuitems = new List<Menuitem>();
private List<Menuitemkategorie> menuitemkategories = new List<Menuitemkategorie>();
private List<Menuitemueberkategorie> menuitemueberkategories = new List<Menuitemueberkategorie>();
private List<Rabatt> rabatte = new List<Rabatt>();
protected override async Task OnInitializedAsync()
{
if (localStorage.GetItem<Dictionary<int, int>>("MenuItemIds") != null)
{
menuitemIds = localStorage.GetItem<Dictionary<int, int>>("MenuItemIds");
}
allergien = await Http.GetFromJsonAsync<List<Allergie>>("https://localhost:7076/api/allergien");
bestellungspositions = await Http.GetFromJsonAsync<List<Bestellungsposition>>("https://localhost:7076/api/bestellungspositionen");
kunden = await Http.GetFromJsonAsync<List<Kunde>>("https://localhost:7076/api/kunden");
menuitems = await Http.GetFromJsonAsync<List<Menuitem>>("https://localhost:7076/api/Menuitems");
menuitemkategories = await Http.GetFromJsonAsync<List<Menuitemkategorie>>("https://localhost:7076/api/Menuitemkategories");
menuitemueberkategories = await Http.GetFromJsonAsync<List<Menuitemueberkategorie>>("https://localhost:7076/api/Menuitemueberkategories");
rabatte = await Http.GetFromJsonAsync<List<Rabatt>>("https://localhost:7076/api/Rabatte");
}
public class Allergie
{
public int Idallergie { get; set; }
public string? Beschreibung { get; set; }
public virtual ICollection<Menuitem> MenuItemIdmenuItems { get; set; } = new List<Menuitem>();
}
public class Bestellungsposition
{
public int Idbestellung { get; set; }
public int? Menge { get; set; }
public DateTime? Datum { get; set; }
public int KundeIdkunde { get; set; }
public int? RabattIdrabatt { get; set; }
public virtual Kunde KundeIdkundeNavigation { get; set; } = null!;
public virtual Rabatt RabattIdrabattNavigation { get; set; } = null!;
public virtual ICollection<Menuitem> MenuItemIdmenuItems { get; set; } = new List<Menuitem>();
}
public class Kunde
{
public int Idkunde { get; set; }
public string? Code { get; set; }
public int? Treuepunkte { get; set; }
public virtual ICollection<Bestellungsposition> Bestellungspositions { get; set; } = new List<Bestellungsposition>();
}
public class Menuitem
{
public int IdmenuItem { get; set; }
public string? Bezeichnung { get; set; }
public string? Zusatzinformation { get; set; }
public decimal? Preis { get; set; }
public int MenuItemKategorieIdmenuItemKategorie { get; set; }
public virtual Menuitemkategorie MenuItemKategorieIdmenuItemKategorieNavigation { get; set; } = null!;
public virtual ICollection<Allergie> AllergieIdallergies { get; set; } = new List<Allergie>();
public virtual ICollection<Bestellungsposition> BestellungspositionIdbestellungs { get; set; } = new List<Bestellungsposition>();
}
public class Menuitemkategorie
{
public int IdmenuItemKategorie { get; set; }
public string? Bezeichnung { get; set; }
public int MenuItemUeberkategorieIdmenuItemUeberkategorie { get; set; }
public virtual Menuitemueberkategorie MenuItemUeberkategorieIdmenuItemUeberkategorieNavigation { get; set; } = null!;
public virtual ICollection<Menuitem> Menuitems { get; set; } = new List<Menuitem>();
}
public class Menuitemueberkategorie
{
public int IdmenuItemUeberkategorie { get; set; }
public string? Bezeichnung { get; set; }
public virtual ICollection<Menuitemkategorie> Menuitemkategories { get; set; } = new List<Menuitemkategorie>();
}
public class Rabatt
{
public int Idrabatt { get; set; }
public decimal? Prozent { get; set; }
public DateTime? GueltigkeitVon { get; set; }
public DateTime? GueltigkeitBis { get; set; }
public virtual ICollection<Bestellungsposition> Bestellungspositions { get; set; } = new List<Bestellungsposition>();
}
}

View File

@ -0,0 +1,81 @@
/**{
background-color: red;
}*/
/*navigation*/
button.btn:first-child {
background-color: #8bfaa4;
/*not click able*/
pointer-events: none;
cursor: default;
border-width: 0px;
}
button.btn {
/* Verwirrung: Figma-Design: background-color: #c7ffd5;
wurde jetzt aber fuer den Hintergrund verwendet*/
background-color: #8dffb5;
border-right: 1px solid black;
border-left: 1px solid black;
border-radius:20px;
}
button.btn:nth-child(2) {
/*border-right: 2px solid black;*/
border-left-width: 0px;
}
button.btn:last-child {
border-right-width: 0px;
}
/*menuitems*/
.card.mt-3 {
/* background-color: rebeccapurple; */
border-radius: 30px;
border: 1px solid black;
}
/*warenkorb*/
.card-header {
font-size:16pt;
text-align: center;
padding-bottom: 15px;
/* background-color: white; */
border-top-right-radius: 20px;
}
.card-header {
background-color:transparent;
border-bottom-width:0px;
}
.card {
border-radius: 32px;
border: 1px solid black;
}
p.card-text {
margin-left: 20px;
}
/*buttons*/
a.btn.btn-primary.mx-2.mt-5 {
background-color: #facca3;
color: black;
border: none;
border-radius: 20px;
}
a.btn.btn-primary.mx-2.mt-1 {
background-color: #89f9a5;
color: black;
border: none;
border-radius: 20px;
}

View File

@ -0,0 +1,235 @@
@page "/SpeisekarteGetraenke"
@inject HttpClient Http
@inject Blazored.LocalStorage.ISyncLocalStorageService localStorage
<h1>Speisekarte Getränke</h1>
@* create an container bootstrap 5*@
<div class="container">
<div class="row">
<div class="col-8">
@* Navigation button group, stretch on the width size of the col-8 *@
<div class="btn-group d-flex" role="group">
<button type="button" class="btn">Getränke</button>
<button type="button" class="btn">Alkoholfreie Getränke</button>
<button type="button" class="btn">Bier</button>
</div>
@foreach (var item in menuitemueberkategories)
{
@if (item.Bezeichnung == "Getränke")
{
@foreach (var item2 in menuitemkategories)
{
if (item2.MenuItemUeberkategorieIdmenuItemUeberkategorie == item.IdmenuItemUeberkategorie)
{
@foreach (var item3 in menuitems)
{
if (item2.IdmenuItemKategorie == item3.MenuItemKategorieIdmenuItemKategorie)
{
<div class="card mt-3 " @onclick="@(() => SetMenuItemId(item3.IdmenuItem))">
<div class="card-body">
@*create two divs columns*@
<div class="row">
<div class="col-8">
<h5 class="card-title">@item3.Bezeichnung</h5>
<p class="card-text">@item3.Zusatzinformation</p>
</div>
@*div text center*@
<div class="col-4 d-flex justify-content-center align-items-center">
<div style="font-size:15pt;">@item3.Preis</div>
</div>
</div>
</div>
</div>
}
}
}
}
}
}
</div>
<div class="col-4">
@* warenkorb anzeige als bootstrap card*@
<div class="card">
<div class="card-header">
Warenkorb
</div>
@if (menuitemIds.Count == 0)
{
<div class="card-body">
<h5 class="card-title" style="font-size:10pt; margin-bottom:0px;">Warenkorb ist leer</h5>
</div>
}
else
{
@foreach (var item in menuitemIds)
{
@foreach (var item2 in menuitems)
{
@if (item.Key == item2.IdmenuItem)
{
<div class="card-body">
<p>@item.Value</p>
<h5 class="card-title" style="font-size:10pt; margin-bottom:0px;">@item2.Bezeichnung</h5>
<p class="card-text" style="font-size:8pt;margin-bottom:0px;">@item2.Zusatzinformation</p>
<p class="card-text" id="preis" style="text-align:right; "><span style="background-color:#c7ffd5; border-radius:20px; font-size:10pt; padding:5px">@item2.Preis</span></p>
</div>
}
}
}
}
</div>
<div class="d-flex flex-column mb-5">
<a href="/speisekarte" class="btn btn-primary mx-2 mt-5">Zurück</a>
<a href="/shopping_cart" class="btn btn-primary mx-2 mt-1 mb-5">Weiter</a>
</div>
</div>
</div>
</div>
@code {
public Dictionary<int, int> menuitemIds = new Dictionary<int, int>();
private void SetMenuItemId(int id)
{
if (menuitemIds.ContainsKey(id))
{
menuitemIds[id]++;
}
else
{
menuitemIds.Add(id, 1);
}
localStorage.SetItem<Dictionary<int, int>>("MenuItemIds", menuitemIds);
}
// allergien, bestellungsposition, kunde, menuitem, menuitemkategorie, menuitemueberkategorie, rabatt
private List<Allergie> allergien = new List<Allergie>();
private List<Bestellungsposition> bestellungspositions = new List<Bestellungsposition>();
private List<Kunde> kunden = new List<Kunde>();
private List<Menuitem> menuitems = new List<Menuitem>();
private List<Menuitemkategorie> menuitemkategories = new List<Menuitemkategorie>();
private List<Menuitemueberkategorie> menuitemueberkategories = new List<Menuitemueberkategorie>();
private List<Rabatt> rabatte = new List<Rabatt>();
protected override async Task OnInitializedAsync()
{
if (localStorage.GetItem<Dictionary<int, int>>("MenuItemIds") != null)
{
menuitemIds = localStorage.GetItem<Dictionary<int, int>>("MenuItemIds");
}
allergien = await Http.GetFromJsonAsync<List<Allergie>>("https://localhost:7076/api/allergien");
bestellungspositions = await Http.GetFromJsonAsync<List<Bestellungsposition>>("https://localhost:7076/api/bestellungspositionen");
kunden = await Http.GetFromJsonAsync<List<Kunde>>("https://localhost:7076/api/kunden");
menuitems = await Http.GetFromJsonAsync<List<Menuitem>>("https://localhost:7076/api/Menuitems");
menuitemkategories = await Http.GetFromJsonAsync<List<Menuitemkategorie>>("https://localhost:7076/api/Menuitemkategories");
menuitemueberkategories = await Http.GetFromJsonAsync<List<Menuitemueberkategorie>>("https://localhost:7076/api/Menuitemueberkategories");
rabatte = await Http.GetFromJsonAsync<List<Rabatt>>("https://localhost:7076/api/Rabatte");
}
public class Allergie
{
public int Idallergie { get; set; }
public string? Beschreibung { get; set; }
public virtual ICollection<Menuitem> MenuItemIdmenuItems { get; set; } = new List<Menuitem>();
}
public class Bestellungsposition
{
public int Idbestellung { get; set; }
public int? Menge { get; set; }
public DateTime? Datum { get; set; }
public int KundeIdkunde { get; set; }
public int? RabattIdrabatt { get; set; }
public virtual Kunde KundeIdkundeNavigation { get; set; } = null!;
public virtual Rabatt RabattIdrabattNavigation { get; set; } = null!;
public virtual ICollection<Menuitem> MenuItemIdmenuItems { get; set; } = new List<Menuitem>();
}
public class Kunde
{
public int Idkunde { get; set; }
public string? Code { get; set; }
public int? Treuepunkte { get; set; }
public virtual ICollection<Bestellungsposition> Bestellungspositions { get; set; } = new List<Bestellungsposition>();
}
public class Menuitem
{
public int IdmenuItem { get; set; }
public string? Bezeichnung { get; set; }
public string? Zusatzinformation { get; set; }
public decimal? Preis { get; set; }
public int MenuItemKategorieIdmenuItemKategorie { get; set; }
public virtual Menuitemkategorie MenuItemKategorieIdmenuItemKategorieNavigation { get; set; } = null!;
public virtual ICollection<Allergie> AllergieIdallergies { get; set; } = new List<Allergie>();
public virtual ICollection<Bestellungsposition> BestellungspositionIdbestellungs { get; set; } = new List<Bestellungsposition>();
}
public class Menuitemkategorie
{
public int IdmenuItemKategorie { get; set; }
public string? Bezeichnung { get; set; }
public int MenuItemUeberkategorieIdmenuItemUeberkategorie { get; set; }
public virtual Menuitemueberkategorie MenuItemUeberkategorieIdmenuItemUeberkategorieNavigation { get; set; } = null!;
public virtual ICollection<Menuitem> Menuitems { get; set; } = new List<Menuitem>();
}
public class Menuitemueberkategorie
{
public int IdmenuItemUeberkategorie { get; set; }
public string? Bezeichnung { get; set; }
public virtual ICollection<Menuitemkategorie> Menuitemkategories { get; set; } = new List<Menuitemkategorie>();
}
public class Rabatt
{
public int Idrabatt { get; set; }
public decimal? Prozent { get; set; }
public DateTime? GueltigkeitVon { get; set; }
public DateTime? GueltigkeitBis { get; set; }
public virtual ICollection<Bestellungsposition> Bestellungspositions { get; set; } = new List<Bestellungsposition>();
}
}

View File

@ -0,0 +1,81 @@
/**{
background-color: red;
}*/
/*navigation*/
button.btn:first-child {
background-color: #8bfaa4;
/*not click able*/
pointer-events: none;
cursor: default;
border-width: 0px;
}
button.btn {
/* Verwirrung: Figma-Design: background-color: #c7ffd5;
wurde jetzt aber fuer den Hintergrund verwendet*/
background-color: #8dffb5;
border-right: 1px solid black;
border-left: 1px solid black;
border-radius: 20px;
}
button.btn:nth-child(2) {
/*border-right: 2px solid black;*/
border-left-width: 0px;
}
button.btn:last-child {
border-right-width: 0px;
}
/*menuitems*/
.card.mt-3 {
/* background-color: rebeccapurple; */
border-radius: 30px;
border: 1px solid black;
}
/*warenkorb*/
.card-header {
font-size: 16pt;
text-align: center;
padding-bottom: 15px;
/* background-color: white; */
border-top-right-radius: 20px;
}
.card-header {
background-color: transparent;
border-bottom-width: 0px;
}
.card {
border-radius: 32px;
border: 1px solid black;
}
p.card-text {
margin-left: 20px;
}
/*buttons*/
a.btn.btn-primary.mx-2.mt-5 {
background-color: #facca3;
color: black;
border: none;
border-radius: 20px;
}
a.btn.btn-primary.mx-2.mt-1 {
background-color: #89f9a5;
color: black;
border: none;
border-radius: 20px;
}

View File

@ -0,0 +1,230 @@
@page "/SpeisekarteSonstiges"
@inject HttpClient Http
@inject Blazored.LocalStorage.ISyncLocalStorageService localStorage
<h1>Speisekarte Sonstiges</h1>
@* create an container bootstrap 5*@
<div class="container">
<div class="row">
<div class="col-8">
@* Navigation button group, stretch on the width size of the col-8 *@
<div class="btn-group d-flex" role="group">
<button type="button" class="btn">Sonstiges</button>
<button type="button" class="btn">Schnitzel</button>
<button type="button" class="btn">Pommes</button>
<button type="button" class="btn">Bowl</button>
<button type="button" class="btn">Vorspeisen</button>
</div>
@foreach (var item in menuitemueberkategories)
{
@if (item.Bezeichnung == "Sonstiges")
{
@foreach (var item2 in menuitemkategories)
{
if (item2.MenuItemUeberkategorieIdmenuItemUeberkategorie == item.IdmenuItemUeberkategorie)
{
@foreach (var item3 in menuitems)
{
if (item2.IdmenuItemKategorie == item3.MenuItemKategorieIdmenuItemKategorie)
{
<div class="card mt-3 " @onclick="@(() => SetMenuItemId(item3.IdmenuItem))">
<div class="card-body">
@*create two divs columns*@
<div class="row">
<div class="col-8">
<h5 class="card-title">@item3.Bezeichnung</h5>
<p class="card-text">@item3.Zusatzinformation</p>
</div>
@*div text center*@
<div class="col-4 d-flex justify-content-center align-items-center">
<div style="font-size:15pt;">@item3.Preis</div>
</div>
</div>
</div>
</div>
}
}
}
}
}
}
</div>
<div class="col-4">
@* warenkorb anzeige als bootstrap card*@
<div class="card">
<div class="card-header">
Warenkorb
</div>
@if (menuitemIds.Count == 0)
{
<div class="card-body">
<h5 class="card-title" style="font-size:10pt; margin-bottom:0px;">Warenkorb ist leer</h5>
</div>
}
else
{
@foreach (var item in menuitemIds)
{
@foreach (var item2 in menuitems)
{
@if (item.Key == item2.IdmenuItem)
{
<div class="card-body">
<p>@item.Value</p>
<h5 class="card-title" style="font-size:10pt; margin-bottom:0px;">@item2.Bezeichnung</h5>
<p class="card-text" style="font-size:8pt;margin-bottom:0px;">@item2.Zusatzinformation</p>
<p class="card-text" id="preis" style="text-align:right; "><span style="background-color:#c7ffd5; border-radius:20px; font-size:10pt; padding:5px">@item2.Preis</span></p>
</div>
}
}
}
}
</div>
<div class="d-flex flex-column mb-5">
<a href="/speisekarte" class="btn btn-primary mx-2 mt-5">Zurück</a>
<a href="/shopping_cart" class="btn btn-primary mx-2 mt-1 mb-5">Weiter</a>
</div>
</div>
</div>
</div>
@code {
public Dictionary<int, int> menuitemIds = new Dictionary<int, int>();
private void SetMenuItemId(int id)
{
if (menuitemIds.ContainsKey(id))
{
menuitemIds[id]++;
}
else
{
menuitemIds.Add(id, 1);
}
localStorage.SetItem<Dictionary<int, int>>("MenuItemIds", menuitemIds);
}
// allergien, bestellungsposition, kunde, menuitem, menuitemkategorie, menuitemueberkategorie, rabatt
private List<Allergie> allergien = new List<Allergie>();
private List<Bestellungsposition> bestellungspositions = new List<Bestellungsposition>();
private List<Kunde> kunden = new List<Kunde>();
private List<Menuitem> menuitems = new List<Menuitem>();
private List<Menuitemkategorie> menuitemkategories = new List<Menuitemkategorie>();
private List<Menuitemueberkategorie> menuitemueberkategories = new List<Menuitemueberkategorie>();
private List<Rabatt> rabatte = new List<Rabatt>();
protected override async Task OnInitializedAsync()
{
if (localStorage.GetItem<Dictionary<int, int>>("MenuItemIds") != null)
{
menuitemIds = localStorage.GetItem<Dictionary<int, int>>("MenuItemIds");
}
allergien = await Http.GetFromJsonAsync<List<Allergie>>("https://localhost:7076/api/allergien");
bestellungspositions = await Http.GetFromJsonAsync<List<Bestellungsposition>>("https://localhost:7076/api/bestellungspositionen");
kunden = await Http.GetFromJsonAsync<List<Kunde>>("https://localhost:7076/api/kunden");
menuitems = await Http.GetFromJsonAsync<List<Menuitem>>("https://localhost:7076/api/Menuitems");
menuitemkategories = await Http.GetFromJsonAsync<List<Menuitemkategorie>>("https://localhost:7076/api/Menuitemkategories");
menuitemueberkategories = await Http.GetFromJsonAsync<List<Menuitemueberkategorie>>("https://localhost:7076/api/Menuitemueberkategories");
rabatte = await Http.GetFromJsonAsync<List<Rabatt>>("https://localhost:7076/api/Rabatte");
}
public class Allergie
{
public int Idallergie { get; set; }
public string? Beschreibung { get; set; }
public virtual ICollection<Menuitem> MenuItemIdmenuItems { get; set; } = new List<Menuitem>();
}
public class Bestellungsposition
{
public int Idbestellung { get; set; }
public int? Menge { get; set; }
public DateTime? Datum { get; set; }
public int KundeIdkunde { get; set; }
public int? RabattIdrabatt { get; set; }
public virtual Kunde KundeIdkundeNavigation { get; set; } = null!;
public virtual Rabatt RabattIdrabattNavigation { get; set; } = null!;
public virtual ICollection<Menuitem> MenuItemIdmenuItems { get; set; } = new List<Menuitem>();
}
public class Kunde
{
public int Idkunde { get; set; }
public string? Code { get; set; }
public int? Treuepunkte { get; set; }
public virtual ICollection<Bestellungsposition> Bestellungspositions { get; set; } = new List<Bestellungsposition>();
}
public class Menuitem
{
public int IdmenuItem { get; set; }
public string? Bezeichnung { get; set; }
public string? Zusatzinformation { get; set; }
public decimal? Preis { get; set; }
public int MenuItemKategorieIdmenuItemKategorie { get; set; }
public virtual Menuitemkategorie MenuItemKategorieIdmenuItemKategorieNavigation { get; set; } = null!;
public virtual ICollection<Allergie> AllergieIdallergies { get; set; } = new List<Allergie>();
public virtual ICollection<Bestellungsposition> BestellungspositionIdbestellungs { get; set; } = new List<Bestellungsposition>();
}
public class Menuitemkategorie
{
public int IdmenuItemKategorie { get; set; }
public string? Bezeichnung { get; set; }
public int MenuItemUeberkategorieIdmenuItemUeberkategorie { get; set; }
public virtual Menuitemueberkategorie MenuItemUeberkategorieIdmenuItemUeberkategorieNavigation { get; set; } = null!;
public virtual ICollection<Menuitem> Menuitems { get; set; } = new List<Menuitem>();
}
public class Menuitemueberkategorie
{
public int IdmenuItemUeberkategorie { get; set; }
public string? Bezeichnung { get; set; }
public virtual ICollection<Menuitemkategorie> Menuitemkategories { get; set; } = new List<Menuitemkategorie>();
}
public class Rabatt
{
public int Idrabatt { get; set; }
public decimal? Prozent { get; set; }
public DateTime? GueltigkeitVon { get; set; }
public DateTime? GueltigkeitBis { get; set; }
public virtual ICollection<Bestellungsposition> Bestellungspositions { get; set; } = new List<Bestellungsposition>();
}
}

View File

@ -0,0 +1,81 @@
/**{
background-color: red;
}*/
/*navigation*/
button.btn:first-child {
background-color: #8bfaa4;
/*not click able*/
pointer-events: none;
cursor: default;
border-width: 0px;
}
button.btn {
/* Verwirrung: Figma-Design: background-color: #c7ffd5;
wurde jetzt aber fuer den Hintergrund verwendet*/
background-color: #8dffb5;
border-right: 1px solid black;
border-left: 1px solid black;
border-radius: 20px;
}
button.btn:nth-child(2) {
/*border-right: 2px solid black;*/
border-left-width: 0px;
}
button.btn:last-child {
border-right-width: 0px;
}
/*menuitems*/
.card.mt-3 {
/* background-color: rebeccapurple; */
border-radius: 30px;
border: 1px solid black;
}
/*warenkorb*/
.card-header {
font-size: 16pt;
text-align: center;
padding-bottom: 15px;
/* background-color: white; */
border-top-right-radius: 20px;
}
.card-header {
background-color: transparent;
border-bottom-width: 0px;
}
.card {
border-radius: 32px;
border: 1px solid black;
}
p.card-text {
margin-left: 20px;
}
/*buttons*/
a.btn.btn-primary.mx-2.mt-5 {
background-color: #facca3;
color: black;
border: none;
border-radius: 20px;
}
a.btn.btn-primary.mx-2.mt-1 {
background-color: #89f9a5;
color: black;
border: none;
border-radius: 20px;
}

View File

@ -0,0 +1,231 @@
@page "/SpeisekarteJapanisch"
@inject HttpClient Http
@inject Blazored.LocalStorage.ISyncLocalStorageService localStorage
<h1>Speisekarte Japanisch</h1>
@* create an container bootstrap 5*@
<div class="container">
<div class="row">
<div class="col-8">
@* Navigation button group, stretch on the width size of the col-8 *@
<div class="btn-group d-flex" role="group">
<button type="button" class="btn">Japanisch</button>
<button type="button" class="btn">SushiMaki</button>
<button type="button" class="btn">Bento</button>
<button type="button" class="btn">Nachspeise</button>
</div>
@foreach (var item in menuitemueberkategories)
{
@if (item.Bezeichnung == "Japanisch")
{
@foreach (var item2 in menuitemkategories)
{
if (item2.MenuItemUeberkategorieIdmenuItemUeberkategorie == item.IdmenuItemUeberkategorie)
{
@foreach (var item3 in menuitems)
{
if (item2.IdmenuItemKategorie == item3.MenuItemKategorieIdmenuItemKategorie)
{
<div class="card mt-3" @onclick="@(() => SetMenuItemId(item3.IdmenuItem))">
<div class="card-body">
@*create two divs columns*@
<div class="row">
<div class="col-8">
<h5 class="card-title">@item3.Bezeichnung</h5>
<p class="card-text">@item3.Zusatzinformation</p>
</div>
@*div text center*@
<div class="col-4 d-flex justify-content-center align-items-center">
<div style="font-size:15pt;">@item3.Preis</div>
</div>
</div>
</div>
</div>
}
}
}
}
}
}
</div>
<div class="col-4">
@* warenkorb anzeige als bootstrap card*@
<div class="card">
<div class="card-header">
Warenkorb
</div>
@if (menuitemIds.Count == 0)
{
<div class="card-body">
<h5 class="card-title" style="font-size:10pt; margin-bottom:0px;">Warenkorb ist leer</h5>
</div>
}
else
{
@foreach (var item in menuitemIds)
{
@foreach (var item2 in menuitems)
{
@if (item.Key == item2.IdmenuItem)
{
<div class="card-body">
<p>@item.Value</p>
<h5 class="card-title" style="font-size:10pt; margin-bottom:0px;">@item2.Bezeichnung</h5>
<p class="card-text" style="font-size:8pt;margin-bottom:0px;">@item2.Zusatzinformation</p>
<p class="card-text" id="preis" style="text-align:right; "><span style="background-color:#c7ffd5; border-radius:20px; font-size:10pt; padding:5px">@item2.Preis</span></p>
</div>
}
}
}
}
</div>
<div class="d-flex flex-column mb-5">
<a href="/speisekarte" class="btn btn-primary mx-2 mt-5">Zurück</a>
<a href="/shopping_cart" class="btn btn-primary mx-2 mt-1 mb-5">Weiter</a>
</div>
</div>
</div>
</div>
@code {
public Dictionary<int, int> menuitemIds = new Dictionary<int, int>();
private void SetMenuItemId(int id)
{
if (menuitemIds.ContainsKey(id))
{
menuitemIds[id]++;
}
else
{
menuitemIds.Add(id, 1);
}
localStorage.SetItem<Dictionary<int, int>>("MenuItemIds", menuitemIds);
}
// allergien, bestellungsposition, kunde, menuitem, menuitemkategorie, menuitemueberkategorie, rabatt
private List<Allergie> allergien = new List<Allergie>();
private List<Bestellungsposition> bestellungspositions = new List<Bestellungsposition>();
private List<Kunde> kunden = new List<Kunde>();
private List<Menuitem> menuitems = new List<Menuitem>();
private List<Menuitemkategorie> menuitemkategories = new List<Menuitemkategorie>();
private List<Menuitemueberkategorie> menuitemueberkategories = new List<Menuitemueberkategorie>();
private List<Rabatt> rabatte = new List<Rabatt>();
protected override async Task OnInitializedAsync()
{
if (localStorage.GetItem<Dictionary<int, int>>("MenuItemIds") != null)
{
menuitemIds = localStorage.GetItem<Dictionary<int, int>>("MenuItemIds");
}
allergien = await Http.GetFromJsonAsync<List<Allergie>>("https://localhost:7076/api/allergien");
bestellungspositions = await Http.GetFromJsonAsync<List<Bestellungsposition>>("https://localhost:7076/api/bestellungspositionen");
kunden = await Http.GetFromJsonAsync<List<Kunde>>("https://localhost:7076/api/kunden");
menuitems = await Http.GetFromJsonAsync<List<Menuitem>>("https://localhost:7076/api/Menuitems");
menuitemkategories = await Http.GetFromJsonAsync<List<Menuitemkategorie>>("https://localhost:7076/api/Menuitemkategories");
menuitemueberkategories = await Http.GetFromJsonAsync<List<Menuitemueberkategorie>>("https://localhost:7076/api/Menuitemueberkategories");
rabatte = await Http.GetFromJsonAsync<List<Rabatt>>("https://localhost:7076/api/Rabatte");
}
public class Allergie
{
public int Idallergie { get; set; }
public string? Beschreibung { get; set; }
public virtual ICollection<Menuitem> MenuItemIdmenuItems { get; set; } = new List<Menuitem>();
}
public class Bestellungsposition
{
public int Idbestellung { get; set; }
public int? Menge { get; set; }
public DateTime? Datum { get; set; }
public int KundeIdkunde { get; set; }
public int? RabattIdrabatt { get; set; }
public virtual Kunde KundeIdkundeNavigation { get; set; } = null!;
public virtual Rabatt RabattIdrabattNavigation { get; set; } = null!;
public virtual ICollection<Menuitem> MenuItemIdmenuItems { get; set; } = new List<Menuitem>();
}
public class Kunde
{
public int Idkunde { get; set; }
public string? Code { get; set; }
public int? Treuepunkte { get; set; }
public virtual ICollection<Bestellungsposition> Bestellungspositions { get; set; } = new List<Bestellungsposition>();
}
public class Menuitem
{
public int IdmenuItem { get; set; }
public string? Bezeichnung { get; set; }
public string? Zusatzinformation { get; set; }
public decimal? Preis { get; set; }
public int MenuItemKategorieIdmenuItemKategorie { get; set; }
public virtual Menuitemkategorie MenuItemKategorieIdmenuItemKategorieNavigation { get; set; } = null!;
public virtual ICollection<Allergie> AllergieIdallergies { get; set; } = new List<Allergie>();
public virtual ICollection<Bestellungsposition> BestellungspositionIdbestellungs { get; set; } = new List<Bestellungsposition>();
}
public class Menuitemkategorie
{
public int IdmenuItemKategorie { get; set; }
public string? Bezeichnung { get; set; }
public int MenuItemUeberkategorieIdmenuItemUeberkategorie { get; set; }
public virtual Menuitemueberkategorie MenuItemUeberkategorieIdmenuItemUeberkategorieNavigation { get; set; } = null!;
public virtual ICollection<Menuitem> Menuitems { get; set; } = new List<Menuitem>();
}
public class Menuitemueberkategorie
{
public int IdmenuItemUeberkategorie { get; set; }
public string? Bezeichnung { get; set; }
public virtual ICollection<Menuitemkategorie> Menuitemkategories { get; set; } = new List<Menuitemkategorie>();
}
public class Rabatt
{
public int Idrabatt { get; set; }
public decimal? Prozent { get; set; }
public DateTime? GueltigkeitVon { get; set; }
public DateTime? GueltigkeitBis { get; set; }
public virtual ICollection<Bestellungsposition> Bestellungspositions { get; set; } = new List<Bestellungsposition>();
}
}

View File

@ -0,0 +1,81 @@
/**{
background-color: red;
}*/
/*navigation*/
button.btn:first-child {
background-color: #8bfaa4;
/*not click able*/
pointer-events: none;
cursor: default;
border-width: 0px;
}
button.btn {
/* Verwirrung: Figma-Design: background-color: #c7ffd5;
wurde jetzt aber fuer den Hintergrund verwendet*/
background-color: #8dffb5;
border-right: 1px solid black;
border-left: 1px solid black;
border-radius: 20px;
}
button.btn:nth-child(2) {
/*border-right: 2px solid black;*/
border-left-width: 0px;
}
button.btn:last-child {
border-right-width: 0px;
}
/*menuitems*/
.card.mt-3 {
/* background-color: rebeccapurple; */
border-radius: 30px;
border: 1px solid black;
}
/*warenkorb*/
.card-header {
font-size: 16pt;
text-align: center;
padding-bottom: 15px;
/* background-color: white; */
border-top-right-radius: 20px;
}
.card-header {
background-color: transparent;
border-bottom-width: 0px;
}
.card {
border-radius: 32px;
border: 1px solid black;
}
p.card-text {
margin-left: 20px;
}
/*buttons*/
a.btn.btn-primary.mx-2.mt-5 {
background-color: #facca3;
color: black;
border: none;
border-radius: 20px;
}
a.btn.btn-primary.mx-2.mt-1 {
background-color: #89f9a5;
color: black;
border: none;
border-radius: 20px;
}

View File

@ -1,36 +1,312 @@
@page "/Bestellabschluss" @page "/Bestellabschluss"
@inject HttpClient Http
@inject Blazored.LocalStorage.ISyncLocalStorageService localStorage
@inject NavigationManager _navigationManager
<body> <body>
<div class="container col-lg-5 col-md-9 col-sm-12 d-flex flex-column " id="content"> <div class="container col-lg-5 col-md-9 col-sm-12 d-flex flex-column " id="content">
<p>Sie haben derzeit <b>1 Yummy-Punkt(e)</b></p> <p>Sie haben derzeit <b>@kunde.Treuepunkte Yummy-Punkt(e)</b></p>
<p class="text">Bei einem Mindestbestellwert von 8€ erhalten Sie ein Yummy-Punkt. <p class="text">
Ab der 10ten Bestellung gibt es einen Rabatt zu Ihrer nächsten Bestellung.</p> Bei einem Mindestbestellwert von 8€ erhalten Sie ein Yummy-Punkt.
Ab der 10ten Bestellung gibt es einen Rabatt (@rabatt.Prozent%) zu Ihrer nächsten Bestellung.
<div class="img" > </p>
@for(int i = 0; i < 10; i++)
{
<img src="assets/White-Circle.png ">
}
<br>
</div>
<p class="text">Achtung: Bitte beachten Sie, dass keine online Bezahlung zur Verfügung steht.
Diese dient nur zur Vorbestellung und muss selbst abgeholt werden.</p>
<div class="button">
<form id="button1" action="Warenkorb">
<input type="submit" value="Zurück" class="btn">
</form>
<form id="button2" action="Confirm"> <div class="img">
<input type="submit" value="Vorbestellen" class="btn"> @for (int i = 0; i < 10; i++)
</form> {
</div> @*if kunde hat treuepunkte*@
@if (kunde.Treuepunkte > i)
{
<img src="assets/Point-Circle.png ">
}
else
{
<img src="assets/White-Circle.png ">
}
}
<br>
</div>
<p class="text">
Achtung: Bitte beachten Sie, dass keine online Bezahlung zur Verfügung steht.
Diese dient nur zur Vorbestellung und muss selbst abgeholt werden.
</p>
<p>
Ihr gesamt bestellter Betrag beträgt: <strong>@summe €</strong>
</p>
@*if treuepunkte 10 dann angebot bieten*@
@if (kunde.Treuepunkte == 10)
{
<p class=""><strong>Sie haben 10 Yummy-Punkte erreicht</strong>. Sie können diese jetzt einlösen und erhalten einen Rabatt von <strong>@rabatt.Prozent%</strong>.</p>
<p><strong>Wollen Sie diese einlösen?</strong> <InputCheckbox @bind-Value="rabattEinloesen" /></p>
</div> @if (rabattEinloesen == true)
{
<p>Betrag beträgt abzüglich des Rabattes: <strong>@Math.Round(summe - (summe * rabatt.Prozent / 100), 2) €</strong></p>
}
}
<div class="button">
<form id="button1" action="Warenkorb">
<a href="/shopping_cart" class="btn">Zurück</a>
</form>
<form id="button2" action="Confirm">
<input value="Vorbestellen" class="btn" @onclick="Vorbestellen" />
</form>
</div>
</div>
</body> </body>
@code {
} @code {
private List<Kunde> kunden = new List<Kunde>();
private Kunde kunde = new Kunde();
private List<Rabatt> rabatte = new List<Rabatt>();
private Rabatt rabatt = new Rabatt();
private bool rabattEinloesen;
public Dictionary<int, int> menuitemIds = new Dictionary<int, int>();
public List<Bestellungsposition> bestellungspositionen = new List<Bestellungsposition>();
public int hour;
public int minute;
public decimal summe;
public void Vorbestellen()
{
// set rabattEinloesen
if (rabattEinloesen)
{
kunde.Treuepunkte = 0;
// delete treuepunkte API
Http.PutAsJsonAsync("https://localhost:7076/api/kunden/" + kunde.Idkunde, kunde);
summe = Math.Round(summe - (summe * rabatt.Prozent / 100), 2);
localStorage.SetItem("Summe", summe);
}
else
{
localStorage.SetItem("RabattEinloesen", false);
}
// add bestellung to API
// add all bestellungspositionen to API
// get latest bestellungsposition id wenn nix da dann 0
int bestellungspositionId = 0;
if (bestellungspositions != null)
{
// get the highest id from bestellungspositions
int highestId;
foreach (var item in bestellungspositions)
{
highestId = item.Idbestellung;
if (highestId > bestellungspositionId)
{
bestellungspositionId = highestId;
}
}
}
foreach (var item in menuitemIds)
{
bestellungspositionId++;
Bestellungsposition bestellungsposition = new Bestellungsposition();
bestellungsposition.Idbestellung = bestellungspositionId;
bestellungsposition.Menge = item.Value;
// make a new date with hour and minute
DateTime abholzeit = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, hour, minute, 0);
bestellungsposition.Datum = abholzeit;
// latest possible rabatt
if (rabattEinloesen)
{
bestellungsposition.RabattIdrabatt = rabatt.Idrabatt;
}
else
{
bestellungsposition.RabattIdrabatt = null;
}
bestellungsposition.KundeIdkunde = kunde.Idkunde;
Http.PostAsJsonAsync("https://localhost:7076/api/bestellungspositionen", bestellungsposition);
//Add menuitems to bestellungspositionHasMenuItem
BestellungspositionHasMenuitem bestellungspositionHasMenuItem = new BestellungspositionHasMenuitem();
bestellungspositionHasMenuItem.Bestellungsposition_IDBestellung = bestellungsposition.Idbestellung;
bestellungspositionHasMenuItem.MenuItem_IDMenuItem = item.Key;
Http.PostAsJsonAsync("https://localhost:7076/api/bestellungspositionhasmenuitems", bestellungspositionHasMenuItem);
}
// delete all localStorage
localStorage.SetItem("MenuItemIds", new Dictionary<int, int>());
//localStorage.SetItem("Hour", 0);
//localStorage.SetItem("Minute", 0);
localStorage.SetItem("Summe", 0);
localStorage.SetItem("RabattEinloesen", false);
_navigationManager.NavigateTo("/Bestellbestätigung");
}
// allergien, bestellungsposition, kunde, menuitem, menuitemkategorie, menuitemueberkategorie, rabatt
private List<Allergie> allergien = new List<Allergie>();
private List<Bestellungsposition> bestellungspositions = new List<Bestellungsposition>();
private List<Menuitem> menuitems = new List<Menuitem>();
private List<Menuitemkategorie> menuitemkategories = new List<Menuitemkategorie>();
private List<Menuitemueberkategorie> menuitemueberkategories = new List<Menuitemueberkategorie>();
private List<BestellungspositionHasMenuitem> bestellungspositionHasMenuitems = new List<BestellungspositionHasMenuitem>();
protected override async Task OnInitializedAsync()
{
// get data from api
allergien = await Http.GetFromJsonAsync<List<Allergie>>("https://localhost:7076/api/allergien");
bestellungspositions = await Http.GetFromJsonAsync<List<Bestellungsposition>>("https://localhost:7076/api/bestellungspositionen");
kunden = await Http.GetFromJsonAsync<List<Kunde>>("https://localhost:7076/api/kunden");
menuitems = await Http.GetFromJsonAsync<List<Menuitem>>("https://localhost:7076/api/Menuitems");
menuitemkategories = await Http.GetFromJsonAsync<List<Menuitemkategorie>>("https://localhost:7076/api/Menuitemkategories");
menuitemueberkategories = await Http.GetFromJsonAsync<List<Menuitemueberkategorie>>("https://localhost:7076/api/Menuitemueberkategories");
rabatte = await Http.GetFromJsonAsync<List<Rabatt>>("https://localhost:7076/api/Rabatte");
bestellungspositionHasMenuitems = await Http.GetFromJsonAsync<List<BestellungspositionHasMenuitem>>("https://localhost:7076/api/BestellungspositionHasMenuitems");
// test use the first kunde
kunde = kunden[0];
// get the most recent rabatt, that are still valid (GueltigkeitBis)
// if there is no rabatt, set the rabatt to null
if (rabatte.Count == 0)
{
rabatt = null;
}
else
{
for (int i = 0; i < rabatte.Count; i++)
{
if (rabatte[i].GueltigkeitBis > DateTime.Now)
{
rabatt = rabatte[i];
}
}
}
// get data from localstorage
if (localStorage.GetItem<Dictionary<int, int>>("MenuItemIds") != null)
{
menuitemIds = localStorage.GetItem<Dictionary<int, int>>("MenuItemIds");
}
// calculate the sum of all menuitems
summe = 0;
foreach (var item in menuitemIds)
{
foreach (var item2 in menuitems)
{
if (item.Key == item2.IdmenuItem)
{
summe += item2.Preis * item.Value;
}
}
}
// if hour/minute is set, set the values
if (localStorage.GetItem<int>("Hour") != 0)
{
hour = localStorage.GetItem<int>("Hour");
}
if (localStorage.GetItem<int>("Minute") != 0)
{
minute = localStorage.GetItem<int>("Minute");
}
}
public class Allergie
{
public int Idallergie { get; set; }
public string? Beschreibung { get; set; }
public virtual ICollection<Menuitem> MenuItemIdmenuItems { get; set; } = new List<Menuitem>();
}
public class Bestellungsposition
{
public int Idbestellung { get; set; }
public int? Menge { get; set; }
public DateTime? Datum { get; set; }
public int KundeIdkunde { get; set; }
public int? RabattIdrabatt { get; set; }
}
public class Kunde
{
public int Idkunde { get; set; }
public string? Code { get; set; }
public int? Treuepunkte { get; set; }
public virtual ICollection<Bestellungsposition> Bestellungspositions { get; set; } = new List<Bestellungsposition>();
}
public class Menuitem
{
public int IdmenuItem { get; set; }
public string? Bezeichnung { get; set; }
public string? Zusatzinformation { get; set; }
public decimal Preis { get; set; }
public int MenuItemKategorieIdmenuItemKategorie { get; set; }
public virtual Menuitemkategorie MenuItemKategorieIdmenuItemKategorieNavigation { get; set; } = null!;
public virtual ICollection<Allergie> AllergieIdallergies { get; set; } = new List<Allergie>();
public virtual ICollection<Bestellungsposition> BestellungspositionIdbestellungs { get; set; } = new List<Bestellungsposition>();
}
public class Menuitemkategorie
{
public int IdmenuItemKategorie { get; set; }
public string? Bezeichnung { get; set; }
public int MenuItemUeberkategorieIdmenuItemUeberkategorie { get; set; }
public virtual Menuitemueberkategorie MenuItemUeberkategorieIdmenuItemUeberkategorieNavigation { get; set; } = null!;
public virtual ICollection<Menuitem> Menuitems { get; set; } = new List<Menuitem>();
}
public class Menuitemueberkategorie
{
public int IdmenuItemUeberkategorie { get; set; }
public string? Bezeichnung { get; set; }
public virtual ICollection<Menuitemkategorie> Menuitemkategories { get; set; } = new List<Menuitemkategorie>();
}
public class Rabatt
{
public int Idrabatt { get; set; }
public decimal Prozent { get; set; }
public DateTime? GueltigkeitVon { get; set; }
public DateTime? GueltigkeitBis { get; set; }
public bool Einloesen { get; set; }
public virtual ICollection<Bestellungsposition> Bestellungspositions { get; set; } = new List<Bestellungsposition>();
}
public class BestellungspositionHasMenuitem
{
public int? Bestellungsposition_IDBestellung { get; set; }
public int? MenuItem_IDMenuItem { get; set; }
}
}

View File

@ -1,38 +1,229 @@
@page "/Bestellbestätigung" @page "/Bestellbestätigung"
@inject HttpClient Http
@inject Blazored.LocalStorage.ISyncLocalStorageService localStorage
@inject NavigationManager _navigationManager
<body> <body>
<div class="container col-lg-5 col-md-9 col-sm-12 d-flex flex-column " id="content"> <div class="container col-lg-5 col-md-9 col-sm-12 d-flex flex-column " id="content">
<h5>Vielen Dank für Ihre Bestellung</h5><br> <h5>Vielen Dank für Ihre Bestellung</h5><br>
<p class="text"> <p class="text">
Ihr Essen ist in <b>30 Minuten</b> abholbereit. <strong>Ihr Essen ist heute um @hour:@minute abholbereit.</strong>
Sie erhalten eine Benachrichtigung sobald das Essen fertig ist. Wir würden uns freuen, wenn Sie uns ein <a href="Feedback">Feedback</a> geben. Sie erhalten eine Benachrichtigung sobald das Essen fertig ist. Wir würden uns freuen, wenn Sie uns ein <a href="Feedback">Feedback</a> geben.
<br><br><br><br> <br><br><br><br>
</p> </p>
<div class="progress"> <div class="progress">
<div class="progress-bar bg-warning progress-bar-striped progress-bar-animated" style="width:50%"></div> <div class="progress-bar bg-warning progress-bar-striped progress-bar-animated" style="width:10%"></div>
</div> </div>
<table> <table>
<tr class="loadtext"> <tr class="loadtext">
<td>Bestellung eingegangen</td> <td>Bestellung eingegangen</td>
<td class="load2">Bestellung wird zubereitet</td> <td class="load2">Bestellung wird zubereitet</td>
<td class="load3">Essen abholbereit</td> <td class="load3">Essen abholbereit</td>
</tr> </tr>
</table> </table>
<div class="button">
<br><br><br><br>
<form id="button1" action="/">
<input type="submit" value="Zur Startseite" class="btn">
</form>
</div>
</div> <div class="button">
<br><br><br><br>
<form id="button1" action="/">
<input type="submit" value="Bestellungsübersicht" class="btn" @onclick="BestellungsUuebersicht"/>
</form>
</div>
</div>
</body> </body>
@code {
@code {
private List<Kunde> kunden = new List<Kunde>();
private Kunde kunde = new Kunde();
private List<Rabatt> rabatte = new List<Rabatt>();
private Rabatt rabatt = new Rabatt();
private bool rabattEinloesen;
public Dictionary<int, int> menuitemIds = new Dictionary<int, int>();
public int hour;
public int minute;
public decimal summe;
public void BestellungsUuebersicht()
{
_navigationManager.NavigateTo("/Kontoverwaltung");
}
// allergien, bestellungsposition, kunde, menuitem, menuitemkategorie, menuitemueberkategorie, rabatt
private List<Allergie> allergien = new List<Allergie>();
private List<Bestellungsposition> bestellungspositions = new List<Bestellungsposition>();
private List<Menuitem> menuitems = new List<Menuitem>();
private List<Menuitemkategorie> menuitemkategories = new List<Menuitemkategorie>();
private List<Menuitemueberkategorie> menuitemueberkategories = new List<Menuitemueberkategorie>();
protected override async Task OnInitializedAsync()
{
// get data from api
allergien = await Http.GetFromJsonAsync<List<Allergie>>("https://localhost:7076/api/allergien");
bestellungspositions = await Http.GetFromJsonAsync<List<Bestellungsposition>>("https://localhost:7076/api/bestellungspositionen");
kunden = await Http.GetFromJsonAsync<List<Kunde>>("https://localhost:7076/api/kunden");
menuitems = await Http.GetFromJsonAsync<List<Menuitem>>("https://localhost:7076/api/Menuitems");
menuitemkategories = await Http.GetFromJsonAsync<List<Menuitemkategorie>>("https://localhost:7076/api/Menuitemkategories");
menuitemueberkategories = await Http.GetFromJsonAsync<List<Menuitemueberkategorie>>("https://localhost:7076/api/Menuitemueberkategories");
rabatte = await Http.GetFromJsonAsync<List<Rabatt>>("https://localhost:7076/api/Rabatte");
// test use the first kunde
kunde = kunden[0];
// get the most recent rabatt, that are still valid (GueltigkeitBis)
// if there is no rabatt, set the rabatt to null
if (rabatte.Count == 0)
{
rabatt = null;
}
else
{
for (int i = 0; i < rabatte.Count; i++)
{
if (rabatte[i].GueltigkeitBis > DateTime.Now)
{
rabatt = rabatte[i];
}
}
}
// get data from localstorage
if (localStorage.GetItem<Dictionary<int, int>>("MenuItemIds") != null)
{
menuitemIds = localStorage.GetItem<Dictionary<int, int>>("MenuItemIds");
}
// calculate the sum of all menuitems
summe = 0;
foreach (var item in menuitemIds)
{
foreach (var item2 in menuitems)
{
if (item.Key == item2.IdmenuItem)
{
summe += item2.Preis * item.Value;
}
}
}
// if hour/minute is set, set the values
if (localStorage.GetItem<int>("Hour") != 0)
{
hour = localStorage.GetItem<int>("Hour");
}
if (localStorage.GetItem<int>("Minute") != 0)
{
minute = localStorage.GetItem<int>("Minute");
}
//
}
public class Allergie
{
public int Idallergie { get; set; }
public string? Beschreibung { get; set; }
public virtual ICollection<Menuitem> MenuItemIdmenuItems { get; set; } = new List<Menuitem>();
}
public class Bestellungsposition
{
public int Idbestellung { get; set; }
public int? Menge { get; set; }
public DateTime? Datum { get; set; }
public int KundeIdkunde { get; set; }
public int? RabattIdrabatt { get; set; }
public virtual Kunde KundeIdkundeNavigation { get; set; } = null!;
public virtual Rabatt RabattIdrabattNavigation { get; set; } = null!;
public virtual ICollection<Menuitem> MenuItemIdmenuItems { get; set; } = new List<Menuitem>();
}
public class Kunde
{
public int Idkunde { get; set; }
public string? Code { get; set; }
public int? Treuepunkte { get; set; }
public virtual ICollection<Bestellungsposition> Bestellungspositions { get; set; } = new List<Bestellungsposition>();
}
public class Menuitem
{
public int IdmenuItem { get; set; }
public string? Bezeichnung { get; set; }
public string? Zusatzinformation { get; set; }
public decimal Preis { get; set; }
public int MenuItemKategorieIdmenuItemKategorie { get; set; }
public virtual Menuitemkategorie MenuItemKategorieIdmenuItemKategorieNavigation { get; set; } = null!;
public virtual ICollection<Allergie> AllergieIdallergies { get; set; } = new List<Allergie>();
public virtual ICollection<Bestellungsposition> BestellungspositionIdbestellungs { get; set; } = new List<Bestellungsposition>();
}
public class Menuitemkategorie
{
public int IdmenuItemKategorie { get; set; }
public string? Bezeichnung { get; set; }
public int MenuItemUeberkategorieIdmenuItemUeberkategorie { get; set; }
public virtual Menuitemueberkategorie MenuItemUeberkategorieIdmenuItemUeberkategorieNavigation { get; set; } = null!;
public virtual ICollection<Menuitem> Menuitems { get; set; } = new List<Menuitem>();
}
public class Menuitemueberkategorie
{
public int IdmenuItemUeberkategorie { get; set; }
public string? Bezeichnung { get; set; }
public virtual ICollection<Menuitemkategorie> Menuitemkategories { get; set; } = new List<Menuitemkategorie>();
}
public class Rabatt
{
public int Idrabatt { get; set; }
public decimal? Prozent { get; set; }
public DateTime? GueltigkeitVon { get; set; }
public DateTime? GueltigkeitBis { get; set; }
public bool Einloesen { get; set; }
public virtual ICollection<Bestellungsposition> Bestellungspositions { get; set; } = new List<Bestellungsposition>();
}
} }

View File

@ -1,30 +1,289 @@
@page "/Kontoverwaltung" @page "/Kontoverwaltung"
<h3>Wichtige Informationen</h3> <br> @inject HttpClient Http
@inject Blazored.LocalStorage.ISyncLocalStorageService localStorage
@inject NavigationManager _navigationManager
<h3>Wichtige Informationen</h3>
<br>
<div class="container mt-auto"> <div class="container mt-auto">
<h4>AccountID: @RegistrierungA.userName</h4> <h4>AccountID: @kunde.Code</h4>
<h4>Ihr QR-Code: </h4> <h4>Ihr QR-Code: </h4>
<img src="assets/K-QR.png" class="img" title="logo image"> <img src="assets/K-QR.png" class="img" title="logo image">
<p><br>Ihr Konto wird 30 Tage nach der Deaktivierung unwiderruflich gelöscht.</p>
<button class="btn" type="button" onclick="@ChangeButton" id="button1">@button1</button>
<p><br>Ihr Konto wird 30 Tage nach der Deaktivierung unwiderruflich gelöscht.</p>
<button class="btn" type="button" onclick="@ChangeButton" id="button1">@button1</button>
</div> </div>
<br><br> <div class="container mt-auto">
<h1>Bestellübersicht</h1>
</div>
<br>
<br>
<div class="container">
<div class="row">
<div class="col-sm-12 col-lg-6">
@*Tabelle Ihre Bestellung*@
<div class="tbl-container">
<table class="table bdr">
<thead class="bg_green">
<tr>
<td>Ihre Bestellung (@day.@month.@year)</td>
<th></th>
</tr>
</thead>
<tbody class="bg_lightgreen" style="background-color:white;">
@if (menuitemIds.Count == 0)
{
<div class="card-body">
<h5 class="card-title" style="font-size:10pt; margin-bottom:0px;">Warenkorb ist leer</h5>
</div>
}
else
{
@foreach (var item in menuitemIds)
{
@foreach (var item2 in menuitems)
{
@if (item.Key == item2.IdmenuItem)
{
<tr>
<td class="br" style="padding-top:20px; padding-bottom:0px; border-bottom-width: 0px;">
@item.Value x
@item2.Bezeichnung
<div style="font-size:0.7rem;padding-left:15px;">@item2.Zusatzinformation</div>
</td>
<td class="d-flex justify-content-center align-items-center" style="padding-top:20px; border-bottom-width:0px;">@(item2.Preis * item.Value)€</td>
</tr>
}
}
}
}
</tbody>
<tfoot class="bg_lightgreen">
<tr style="border-top:solid 1px black; background-color:white;">
<th class="" style="text-align:right;">Summe</th>
<td class="d-flex justify-content-center align-items-center">
@summe€ &nbsp;
@if (rabattEinloesen)
{
<span style="color:green;">(- @rabatt.Prozent%)</span>
}
</td>
</tr>
</tfoot>
</table>
</div>
</div>
<div class="col-sm-12 col-lg-6">
<div class="d-flex flex-column align-items-center ">
<div class="tbl-container w-100">
<!-- <== overflow: hidden applied to parent -->
<table class="table table-bordered bdr " style=" border-radius: 50px; margin-left: 50px;">
<thead class="bg_green">
<tr>
<td class="d-flex justify-content-center align-items-center" style="border-bottom:0px;">
<p>Abholzeit</p>
</td>
</tr>
</thead>
<tbody>
<tr>
<td class="d-flex justify-content-center align-items-center" style="padding-top:0px; background-color:white;">
<div style="margin:20px;">
<div class="d-flex justify-content-center align-items-center">
<p>@hour:@minute Uhr (@day.@month.@year)</p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
<div class="d-flex flex-column" style="align-items: center; margin-left: 100px;">
@*<button class="btn_back w-75">Zurück</button>*@
@*<button class="btn btn-danger w-75" style="border-radius: 50px; padding-top:12px; padding-bottom:12px; color:black;">Bestellung auflösen</button>*@
@*<button class="btn_forward w-75">Bestellung abschließen</button>*@
</div>
</div>
</div>
</div>
</div>
</div>
@code { @code {
bool changeButtonBool { get; set; } = true; bool changeButtonBool { get; set; } = true;
string button1 => changeButtonBool ? "Konto deaktivieren" : "Konto aktivieren"; string button1 => changeButtonBool ? "Konto deaktivieren" : "Konto aktivieren";
void ChangeButton()
{
//TODO Datenbankaktualisierung
changeButtonBool = !changeButtonBool;
}
void ChangeButton() }
{
//TODO Datenbankaktualisierung
changeButtonBool = !changeButtonBool;
} @code {
public int hour;
public int minute;
public int day;
public int month;
public int year;
public decimal summe;
public Dictionary<int, int> menuitemIds = new Dictionary<int, int>();
private Rabatt rabatt = new Rabatt();
private bool rabattEinloesen;
public decimal rabattGutschrift;
private List<Bestellungsposition> bestellungspositions = new List<Bestellungsposition>();
private List<Kunde> kunden = new List<Kunde>();
private Kunde kunde = new Kunde();
private List<Menuitem> menuitems = new List<Menuitem>();
private List<Rabatt> rabatte = new List<Rabatt>();
private List<BestellungspositionHasMenuitem> bestellungspositionHasMenuitems = new List<BestellungspositionHasMenuitem>();
protected override async Task OnInitializedAsync()
{
// get data from api
bestellungspositions = await Http.GetFromJsonAsync<List<Bestellungsposition>>("https://localhost:7076/api/bestellungspositionen");
kunden = await Http.GetFromJsonAsync<List<Kunde>>("https://localhost:7076/api/kunden");
menuitems = await Http.GetFromJsonAsync<List<Menuitem>>("https://localhost:7076/api/Menuitems");
rabatte = await Http.GetFromJsonAsync<List<Rabatt>>("https://localhost:7076/api/Rabatte");
bestellungspositionHasMenuitems = await Http.GetFromJsonAsync<List<BestellungspositionHasMenuitem>>("https://localhost:7076/api/BestellungspositionHasMenuitems");
// use kudnde with id 1
kunde = kunden[0];
// get all menuitemIds from bestellungspositions with the last date
foreach (var bestellungsposition in bestellungspositions)
{
if (bestellungsposition.KundeIdkunde == kunde.Idkunde)
{
if (bestellungsposition.Datum == bestellungspositions.Max(x => x.Datum))
{
// get hour and minute from datetime of last bestellungsposition
hour = bestellungsposition.Datum.Hour;
minute = bestellungsposition.Datum.Minute;
day = bestellungsposition.Datum.Day;
month = bestellungsposition.Datum.Month;
year = bestellungsposition.Datum.Year;
//if rabatt is used
if (bestellungsposition.RabattIdrabatt != null)
{
rabattEinloesen = true;
foreach (var rabatt in rabatte)
{
if (rabatt.Idrabatt == bestellungsposition.RabattIdrabatt)
{
this.rabatt = rabatt;
}
}
}
foreach (var bestellungspositionHasMenuitem in bestellungspositionHasMenuitems)
{
if (bestellungspositionHasMenuitem.Bestellungsposition_IDBestellung == bestellungsposition.Idbestellung)
{
menuitemIds.Add(bestellungspositionHasMenuitem.MenuItem_IDMenuItem, bestellungsposition.Menge);
}
}
}
}
}
// get summe
foreach (var menuitem in menuitems)
{
foreach (var menuitemId in menuitemIds)
{
if (menuitem.IdmenuItem == menuitemId.Key)
{
summe += menuitem.Preis * menuitemId.Value;
}
}
}
//if rabatt is used calculate new summe
if (rabattEinloesen)
{
rabattGutschrift = (summe * rabatt.Prozent / 100);
summe = summe - rabattGutschrift;
summe = Math.Round(summe, 2);
}
}
public class Bestellungsposition
{
public int Idbestellung { get; set; }
public int Menge { get; set; }
public DateTime Datum { get; set; }
public int KundeIdkunde { get; set; }
public int? RabattIdrabatt { get; set; }
}
public class Kunde
{
public int Idkunde { get; set; }
public string? Code { get; set; }
public int? Treuepunkte { get; set; }
}
public class Menuitem
{
public int IdmenuItem { get; set; }
public string? Bezeichnung { get; set; }
public string? Zusatzinformation { get; set; }
public decimal Preis { get; set; }
}
public class Rabatt
{
public int Idrabatt { get; set; }
public decimal Prozent { get; set; }
public DateTime? GueltigkeitVon { get; set; }
public DateTime? GueltigkeitBis { get; set; }
}
public class BestellungspositionHasMenuitem
{
public int Bestellungsposition_IDBestellung { get; set; }
public int MenuItem_IDMenuItem { get; set; }
}
} }

View File

@ -11,6 +11,7 @@
border-radius: 17px; border-radius: 17px;
overflow: hidden; overflow: hidden;
border-color: #C7FFD5; border-color: #C7FFD5;
border-width: 0px;
} }
.bg_lightgreen { .bg_lightgreen {
@ -23,19 +24,19 @@
border-bottom-width: 0; border-bottom-width: 0;
} }
.btn_back { .btn_bg {
background-color: #F9BE89; background-color: #F9BE89;
/*width: 60%;*/ /*width: 60%;*/
margin-bottom: 13px; margin-bottom: 13px;
border-radius: 30px; border-radius: 30px;
height: 50px; /*height: 50px;*/
border: 0px; /*border: 0px;*/
} }
.btn_forward { .btn_forward {
background-color: #89F9A5; background-color: #89F9A5;
/*width: 60%;*/ /*width: 60%;*/
border-radius: 30px; border-radius: 30px;
height: 50px; /*height: 50px;*/
border: 0px; /*border: 0px;*/
} }

View File

@ -7,6 +7,20 @@
<ServiceWorkerAssetsManifest>service-worker-assets.js</ServiceWorkerAssetsManifest> <ServiceWorkerAssetsManifest>service-worker-assets.js</ServiceWorkerAssetsManifest>
</PropertyGroup> </PropertyGroup>
<ItemGroup>
<None Remove="Pages\SpeisekarteCnDetails.razor.css" />
<None Remove="Pages\SpeisekarteDrDetails.razor.css" />
<None Remove="Pages\SpeisekarteEtcDetails.razor.css" />
<None Remove="Pages\SpeisekarteJpDetails.razor.css" />
</ItemGroup>
<ItemGroup>
<Content Include="Pages\SpeisekarteCnDetails.razor.css" />
<Content Include="Pages\SpeisekarteDrDetails.razor.css" />
<Content Include="Pages\SpeisekarteEtcDetails.razor.css" />
<Content Include="Pages\SpeisekarteJpDetails.razor.css" />
</ItemGroup>
<ItemGroup> <ItemGroup>
<None Include="wwwroot\css\Site.css" /> <None Include="wwwroot\css\Site.css" />
</ItemGroup> </ItemGroup>