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