public ActionResult Index(MenuModel tempModel) { List<Matratt> matratts; List<MatrattTyp> matrattTyps; using (PizzaConnection db = new PizzaConnection()) { matratts = db.Matratts.Select(p => p).Include(p => p.Produkts).ToList(); matratts = matratts.Where(p => p.MatrattTyp1.MatrattTyp1 == tempModel.MatrattTyp.MatrattTyp1).ToList(); matrattTyps = db.MatrattTyps.ToList(); } Matratt matratt = new Matratt(); MenuModel model = new MenuModel() { categories = matrattTyps.Select(x => new SelectListItem() { Value = x.MatrattTyp1.ToString(), Text = x.Beskrivning }), Matratts = matratts, Matratt = matratt }; return View(model); }
// GET: Menu public ActionResult Index() { List<Matratt> matratts; List<MatrattTyp> matrattTyps; MatrattTyp matrattTyp = new MatrattTyp(); using(PizzaConnection db = new PizzaConnection()) { matratts = db.Matratts.Select(p => p).Include(p => p.Produkts).ToList(); matrattTyps = db.MatrattTyps.ToList(); } Matratt matratt = new Matratt(); MenuModel model = new MenuModel() { categories = matrattTyps.Select(x => new SelectListItem() { Value = x.MatrattTyp1.ToString(), Text = x.Beskrivning }), Matratts = matratts, Matratt = matratt, MatrattTyp = matrattTyp }; //@Html.DropDownListFor(x => x.article.CategoryId, Model.categories) return View(model); }
// GET: Profile public ActionResult ShowProfile() { int id = (int) Session["CustomerId"]; Kund kund; using (PizzaConnection db = new PizzaConnection()) { kund = db.Kunds.SingleOrDefault(p => p.KundID == id); } return View(kund); }
//Test na elegancje public ActionResult AddToOrder(int id) { int matId = id; Matratt matratt; using (PizzaConnection db = new PizzaConnection()) { matratt = db.Matratts.SingleOrDefault(p => p.MatrattID == matId); } OrderSingleModel orderSingleModel = new OrderSingleModel(); orderSingleModel.Matratt = matratt; return View(orderSingleModel); }
public ActionResult Update(Kund k) { Kund kund; using (PizzaConnection db = new PizzaConnection()) { kund = db.Kunds.SingleOrDefault(p => p.KundID == k.KundID); kund.Namn = k.Namn; kund.Gatuadress = k.Gatuadress; kund.Postnr = k.Postnr; kund.Postort = k.Postort; kund.Email = k.Email; kund.Telefon = k.Telefon; db.SaveChanges(); } return View(); }
public ActionResult Register(Kund k) { if (ModelState.IsValid == true) { using (PizzaConnection db = new PizzaConnection()) { db.Kunds.Add(k); db.SaveChanges(); } @ViewBag.ErrorMessage = null; return View(k); } else { @ViewBag.ErrorMessage = "wrong"; return View(k); } }
public ActionResult Start(string something) { string u = Request["username"]; string p = Request["password"]; Kund kund; using (PizzaConnection db = new PizzaConnection()) { kund = db.Kunds.SingleOrDefault(x => x.AnvandarNamn == u && x.Losenord == p); } if (kund != null) { Session["Logged"] = 1; Session["Customer"] = kund.Namn; Session["CustomerId"] = kund.KundID; } else { ViewBag.ErrorMessage = "Login invalid"; } return View(); }
// GET: Order public ActionResult AddToOrderro(int id) { int matId = id; Matratt matratt; List<Matratt> matratts; if (Session["Order"] == null) { Session["Order"] = new List<Matratt>(); } matratts = (List<Matratt>) Session["Order"]; using (PizzaConnection db = new PizzaConnection()) { matratt = db.Matratts.SingleOrDefault(p => p.MatrattID == matId); } matratts.Add(matratt); Session["Order"] = matratts; return RedirectToAction("Index", "Menu"); }
public ActionResult ShowOrder() { Dictionary<int, int> currentOrder = new Dictionary<int, int>(); OrderModel orderModel = new OrderModel(); List<string> matratNamn = new List<string>(); List<int> matratCount = new List<int>(); List<int> prices = new List<int>(); if (Session["Order"] != null) { currentOrder = (Dictionary<int, int>)Session["Order"]; } if (currentOrder.Count > 0) { foreach (KeyValuePair<int, int> entry in currentOrder) { using (PizzaConnection db = new PizzaConnection()) { string name = db.Matratts.SingleOrDefault(p => p.MatrattID == entry.Key).MatrattNamn; int price = db.Matratts.SingleOrDefault(p => p.MatrattID == entry.Key).Pris; matratNamn.Add(name); prices.Add(price); } matratCount.Add(entry.Value); } orderModel.IdsOccurances = currentOrder; orderModel.Names = matratNamn; orderModel.Occurances = matratCount; orderModel.Prices = prices; orderModel.isEmpty = false; } else { orderModel.isEmpty = true; } return View(orderModel); }
public ActionResult PlaceOrder(OrderModel model) { int orderId; int totalValue = model.TotalValue; int customerId = model.KundId; //Dictionary<int, int> itemsInOrder = model.IdsOccurances; CZEMU NIE DZIALA ODKRYC LUB SPYTAC Dictionary<int, int> itemsInOrder = (Dictionary<int, int>) Session["Order"]; Bestallning bestallning = new Bestallning(); bestallning.KundID = customerId; bestallning.BestallningDatum = DateTime.Now; bestallning.Totalbelopp = totalValue; bestallning.Levererad = false; using (PizzaConnection db = new PizzaConnection()) { db.Bestallnings.Add(bestallning); db.SaveChanges(); orderId = bestallning.BestallningID; foreach (var itemAmount in itemsInOrder) { BestallningMatratt bm = new BestallningMatratt(); bm.MatrattID = itemAmount.Key; bm.Antal = itemAmount.Value; bm.BestallningID = orderId; db.BestallningMatratts.Add(bm); } db.SaveChanges(); } Session["Order"] = null; return View(); //TODO: Wreszcie, validering, css i done!!! }