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(); }