示例#1
0
        //***********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
0
        //***********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;
        }