// GET: Bestillling public ActionResult ListAlleBestillinger() {//gjort /*///////var db = new Models.BestillingContext();////////*/ //*******1****** /*var bestillinger = db.Bestillinger.ToList(); * var bes = new List<int>(); * foreach(var b in bestillinger) * { * if (!bes.Contains(b.ordreID)) * { * bes.Add(b.ordreID); * } * return View(bes); * }*/ //********************* /*///////// * List<Models.Bestilling> listeAvBrukere = db.Bestillinger.ToList(); * //ViewData.Model = listeAvBrukere; * ViewData["Melding"] = "Velg noe her: "; * //return View(); * //List<Models.Vare> listeAvBestillinger = db.Varer.ToList(); * List<Models.Bestilling> listeAvBestillinger = db.Bestillinger.ToList(); * return View(listeAvBestillinger); * /////////*/ var BLL = new BLL.BestillingBLL(); List <Bestilling> listeAvBestillinger = BLL.ListAlleBestillinger(); return(View(listeAvBestillinger)); }
//***********2********* public String hentBestillinger(int kundeid) {//gjort /*using(var db = new Models.BestillingContext()) * { * List<Models.Bestilling> bestillinger = db.Bestillinger.Where(s => s.kundeID.kundeID == kundeid).ToList(); * * //JsonResult json = Json(bestillinger, JsonRequestBehavior.AllowGet); * * String ut = ""; * foreach(var b in bestillinger) * { * ut += "<table>" + * "<tr><td>OrdreID: </td><td>" + b.ordreID.ToString() + "</td></tr>" + * "<tr><td>KundeID: </td><td>" + b.kundeID.kundeID + "</td></tr>" + * "<tr><td>Navn: </td><td>" + b.kundeID.fornavn + " " + b.kundeID.etterNavn + "</td></tr>" + * "<tr><td>VareID: </td><td>" + b.vareID.vareID + "</td></tr>" + * "<tr><td>Vare: </td><td>" + b.vareID.navn + "</td></tr>" + * "<tr><td>Dato: </td><td>" + b.tid.ToString() + "</td></tr>" + * "</table><hr/>"; * } * //return json; //hvis dere skal bruke JSON-metoden * return ut; * }*/ var BLL = new BLL.BestillingBLL(); List <Bestilling> bestillinger = BLL.hentBestillinger(kundeid); String ut = ""; foreach (var b in bestillinger) { ut += "<table>" + "<tr><td>OrdreID: </td><td>" + b.ordreID.ToString() + "</td></tr>" + "<tr><td>KundeID: </td><td>" + b.kundeID.kundeID + "</td></tr>" + "<tr><td>Navn: </td><td>" + b.kundeID.fornavn + " " + b.kundeID.etterNavn + "</td></tr>" + "<tr><td>VareID: </td><td>" + b.vareID.vareID + "</td></tr>" + "<tr><td>Vare: </td><td>" + b.vareID.navn + "</td></tr>" + "<tr><td>Dato: </td><td>" + b.tid.ToString() + "</td></tr>" + "</table><hr/>"; } return(ut); }
public ActionResult BestillVare(FormCollection innListe) { var BLL = new BLL.BestillingBLL(); int ordreid = BLL.bestillVare(Int32.Parse(innListe["kundeID"]), Int32.Parse(innListe["vareID"])); /*using (var db = new BestillingContext()) { int vareID = Int32.Parse(innListe["vareID"]); int kundeID = Int32.Parse(innListe["kundeID"]); Bestilling nyBestilling = new Bestilling(); nyBestilling.tid = DateTime.Now; Kunde k = db.Kunder.FirstOrDefault(kunde => kunde.kundeID == kundeID); nyBestilling.kundeID = k;//koble til kunde Vare v = db.Varer.FirstOrDefault(vare => vare.vareID == vareID); nyBestilling.vareID = v;//koble til vare db.Bestillinger.Add(nyBestilling); db.SaveChanges(); ordreid = nyBestilling.ordreID; }*/ return RedirectToAction("visKvitering", new { ordreid }); //return View(); }
public ActionResult BestillVare(FormCollection innListe) { var BLL = new BLL.BestillingBLL(); int ordreid = BLL.bestillVare(Int32.Parse(innListe["kundeID"]), Int32.Parse(innListe["vareID"])); /*using (var db = new BestillingContext()) * { * int vareID = Int32.Parse(innListe["vareID"]); * int kundeID = Int32.Parse(innListe["kundeID"]); * Bestilling nyBestilling = new Bestilling(); * nyBestilling.tid = DateTime.Now; * Kunde k = db.Kunder.FirstOrDefault(kunde => kunde.kundeID == kundeID); * nyBestilling.kundeID = k;//koble til kunde * Vare v = db.Varer.FirstOrDefault(vare => vare.vareID == vareID); * nyBestilling.vareID = v;//koble til vare * db.Bestillinger.Add(nyBestilling); * db.SaveChanges(); * * ordreid = nyBestilling.ordreID; * }*/ return(RedirectToAction("visKvitering", new { ordreid })); //return View(); } //trykket på Bestill
public ActionResult visKvitering(int ordreID = 0) { /*var db = new Models.BestillingContext(); Models.Bestilling bestilling = db.Bestillinger.Find(ordreID); if(bestilling==null) { return HttpNotFound(); } return View(bestilling); */ var BLL = new BestillingBLL(); Bestilling bestilling = BLL.visKvitering(ordreID); if (bestilling == null) { return HttpNotFound(); } return View(bestilling); }
// GET: Bestillling public ActionResult ListAlleBestillinger() { //gjort /*///////var db = new Models.BestillingContext();////////*/ //*******1****** /*var bestillinger = db.Bestillinger.ToList(); var bes = new List<int>(); foreach(var b in bestillinger) { if (!bes.Contains(b.ordreID)) { bes.Add(b.ordreID); } return View(bes); }*/ //********************* /*///////// List<Models.Bestilling> listeAvBrukere = db.Bestillinger.ToList(); //ViewData.Model = listeAvBrukere; ViewData["Melding"] = "Velg noe her: "; //return View(); //List<Models.Vare> listeAvBestillinger = db.Varer.ToList(); List<Models.Bestilling> listeAvBestillinger = db.Bestillinger.ToList(); return View(listeAvBestillinger); /////////*/ var BLL = new BLL.BestillingBLL(); List<Bestilling> listeAvBestillinger = BLL.ListAlleBestillinger(); return View(listeAvBestillinger); }
//***********2********* public String hentBestillinger(int kundeid) { //gjort /*using(var db = new Models.BestillingContext()) { List<Models.Bestilling> bestillinger = db.Bestillinger.Where(s => s.kundeID.kundeID == kundeid).ToList(); //JsonResult json = Json(bestillinger, JsonRequestBehavior.AllowGet); String ut = ""; foreach(var b in bestillinger) { ut += "<table>" + "<tr><td>OrdreID: </td><td>" + b.ordreID.ToString() + "</td></tr>" + "<tr><td>KundeID: </td><td>" + b.kundeID.kundeID + "</td></tr>" + "<tr><td>Navn: </td><td>" + b.kundeID.fornavn + " " + b.kundeID.etterNavn + "</td></tr>" + "<tr><td>VareID: </td><td>" + b.vareID.vareID + "</td></tr>" + "<tr><td>Vare: </td><td>" + b.vareID.navn + "</td></tr>" + "<tr><td>Dato: </td><td>" + b.tid.ToString() + "</td></tr>" + "</table><hr/>"; } //return json; //hvis dere skal bruke JSON-metoden return ut; }*/ var BLL = new BLL.BestillingBLL(); List<Bestilling> bestillinger = BLL.hentBestillinger(kundeid); String ut = ""; foreach (var b in bestillinger) { ut += "<table>" + "<tr><td>OrdreID: </td><td>" + b.ordreID.ToString() + "</td></tr>" + "<tr><td>KundeID: </td><td>" + b.kundeID.kundeID + "</td></tr>" + "<tr><td>Navn: </td><td>" + b.kundeID.fornavn + " " + b.kundeID.etterNavn + "</td></tr>" + "<tr><td>VareID: </td><td>" + b.vareID.vareID + "</td></tr>" + "<tr><td>Vare: </td><td>" + b.vareID.navn + "</td></tr>" + "<tr><td>Dato: </td><td>" + b.tid.ToString() + "</td></tr>" + "</table><hr/>"; } return ut; }