public void AddOrderToTable(Table table, string name, double price)
{
PendingOrder po = new PendingOrder()
{
Table = table, Name = name, RealPrice = price
};
barContext.PendingOrders.Add(po);
barContext.SaveChanges();
}
public ActionResult EdytujKlienta([Bind(Include = "Id,Imie,Nazwisko,Telefon,Email")] Klient klient)
{
if (ModelState.IsValid)
{
db.Entry(klient).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Szczegoly", new { id = klient.Id }));
}
return(View(klient));
}
public ZamowienieViewModel UtworzZamowienie(ZamowienieViewModel zamowienie)
{
var koszyk = PobierzKoszyk();
var zamowienieDoDodania = new Zamowienie();
zamowienieDoDodania.WypelnijZamowienie(zamowienie);
zamowienieDoDodania.DodajPozycjeKoszyka(koszyk);
db.Zamowienia.Add(zamowienieDoDodania);
db.SaveChanges();
zamowienieDoDodania.PlatnoscId = zamowienieDoDodania.Platnosc.Id;
db.SaveChanges();
zamowienie.UzupelnijZamowienieViewModel(zamowienieDoDodania);
zamowienie.PozycjeKoszyka = koszyk;
MailPrzyjeteZamowienie(zamowienie);
return(zamowienie);
}
public ActionResult PotwierdzUsun(string id)
{
try
{
var user = db.Users.Find(id);
db.Users.Remove(user);
db.SaveChanges();
}
catch (Exception)
{
return(RedirectToAction("Konta"));
}
return(RedirectToAction("Konta"));
}
public ActionResult Edytuj(Produkt prod)
{
if (ModelState.IsValid)
{
var produkt = db.Produkty.Find(prod.ProduktId);
produkt.NazwaProduktu = prod.NazwaProduktu;
produkt.CzasPrzygotowania = prod.CzasPrzygotowania;
produkt.Cena = prod.Cena;
produkt.Opisy.Opis = prod.Opisy.Opis;
produkt.Opisy.OpisKrotki = prod.Opisy.OpisKrotki;
produkt.KategoriaId = prod.KategoriaId;
db.SaveChanges();
}
return(RedirectToAction("Edytuj", new { id = prod.ProduktId }));
}
static void Main(string[] args)
{
//Liquors
Liqour limeJuice = new Liqour("LIME JUICE", Color.Green);
Liqour tripleSec = new Liqour("TRIPLE SEC", Color.White);
Liqour tequila = new Liqour("TEQUILA", Color.Yellow);
Liqour darkRum = new Liqour("DARK RUM", Color.Orange);
Liqour orangeCuracao = new Liqour("ORANGE CURACAO", Color.Orange);
Liqour almondSyrup = new Liqour("ALMOND SYRUP", Color.Green);
//Accessories
Accessory saltRim = new Accessory("salt rim");
Accessory crushedIce = new Accessory("crushed ice");
Accessory limeSegment = new Accessory("lime segment");
Accessory limeSection = new Accessory("lime section");
Accessory marachinoCherry = new Accessory("marachino cherry");
//Drinks
Drink margarita = new Drink("MARGARITA", new List <Item>()
{
new Item(60, Measurement.ml, limeJuice),
new Item(30, Measurement.ml, tripleSec),
new Item(60, Measurement.ml, tequila),
new Item(saltRim),
new Item(crushedIce),
new Item(limeSegment),
});
Drink maiTai = new Drink("MAI TAI", new List <Item>()
{
new Item(50, Measurement.ml, darkRum),
new Item(15, Measurement.ml, orangeCuracao),
new Item(10, Measurement.ml, limeJuice),
new Item(60, Measurement.ml, almondSyrup),
new Item(limeSection),
new Item(marachinoCherry),
new Item(limeSegment),
});
List <Drink> availableDrinks = new List <Drink>()
{
margarita,
maiTai
};
using (var db = new BarContext())
{
db.Configuration.LazyLoadingEnabled = true;
foreach (Drink drinkToAdd in availableDrinks)
{
db.Drinks.Add(drinkToAdd);
}
db.SaveChanges();
var query = db.Drinks.Include(x => x.Items.Select(xx => xx.ingridient));
Console.WriteLine("All Drinks in the database:");
Console.WriteLine();
foreach (var item in query)
{
Console.WriteLine(item.Name);
Console.WriteLine("---Ingridients");
if (item.AllLiqours.Any())
{
Console.WriteLine("-------Liqours:");
foreach (Item liqourItem in item.AllLiqours)
{
Liqour liqour = (Liqour)liqourItem.ingridient;
Console.WriteLine($"----------{liqourItem.Amount}{liqourItem.MeasureType} {liqourItem.ingridient.Name} with color: {liqour.LiqourColor}");
}
}
if (item.AllAccessories.Any())
{
Console.WriteLine("-------Accesories:");
foreach (Item accessory in item.AllAccessories)
{
Console.WriteLine($"----------{accessory.ingridient.Name}");
}
}
//db.RemoveDrink(item);
Console.WriteLine();
}
}
Console.WriteLine("Press any key to exit...");
Console.ReadKey();
}
public void Salvar()
{
_context.SaveChanges();
}
private void InitData(BarContext bc)
{
bc.Tables.Add(new Table()
{
Name = "Table 1"
});
bc.Tables.Add(new Table()
{
Name = "Table 2"
});
bc.Tables.Add(new Table()
{
Name = "Table 3"
});
bc.Tables.Add(new Table()
{
Name = "Table 4"
});
Ingredient rum = bc.Ingredients.Add(new Ingredient()
{
Name = "Rum"
});
Ingredient coke = bc.Ingredients.Add(new Ingredient()
{
Name = "Coke"
});
Ingredient beer = bc.Ingredients.Add(new Ingredient()
{
Name = "Beer"
});
Ingredient wine = bc.Ingredients.Add(new Ingredient()
{
Name = "Wine"
});
Ingredient soda = bc.Ingredients.Add(new Ingredient()
{
Name = "Soda"
});
bc.Drinks.Add(new Drink()
{
Name = "Cuba Libre", RecommendedPrice = 20, Ingredients = new List <Ingredient>(new Ingredient[] { rum, coke })
});
bc.Drinks.Add(new Drink()
{
Name = "Aperol Spritz", RecommendedPrice = 20, Ingredients = new List <Ingredient>(new Ingredient[] { wine, soda })
});
bc.Drinks.Add(new Drink()
{
Name = "Beer", RecommendedPrice = 15, Ingredients = new List <Ingredient>(new Ingredient[] { beer })
});
bc.Drinks.Add(new Drink()
{
Name = "Wine", RecommendedPrice = 10, Ingredients = new List <Ingredient>(new Ingredient[] { wine })
});
bc.Drinks.Add(new Drink()
{
Name = "Soda", RecommendedPrice = 5, Ingredients = new List <Ingredient>(new Ingredient[] { soda })
});
bc.SaveChanges();
}