//***********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); }
//***********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; }