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!!!
}
