public IHttpActionResult PostJOURNEY(JOURNEY jOURNEY) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.JOURNEYs.Add(jOURNEY); try { db.SaveChanges(); } catch (DbUpdateException) { if (JOURNEYExists(jOURNEY.JOURNEY_ID)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = jOURNEY.JOURNEY_ID }, jOURNEY)); }
public IHttpActionResult PutJOURNEY(decimal id, JOURNEY jOURNEY) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != jOURNEY.JOURNEY_ID) { return(BadRequest()); } db.Entry(jOURNEY).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!JOURNEYExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult DeleteConfirmed(decimal id) { JOURNEY jOURNEY = db.JOURNEYs.Find(id); db.JOURNEYs.Remove(jOURNEY); db.SaveChanges(); return(RedirectToAction("Index")); }
public IHttpActionResult GetJOURNEY(decimal id) { JOURNEY jOURNEY = db.JOURNEYs.Find(id); if (jOURNEY == null) { return(NotFound()); } return(Ok(jOURNEY)); }
public ActionResult Edit([Bind(Include = "JOURNEYID,DEPARTURE,ARRIVAL,DEPARTURETIME,ARRIVALTIME")] JOURNEY jOURNEY) { if (ModelState.IsValid) { db.Entry(jOURNEY).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ARRIVAL = new SelectList(db.STATIONs, "STATIONID", "STATIONNAME", jOURNEY.ARRIVAL); ViewBag.DEPARTURE = new SelectList(db.STATIONs, "STATIONID", "STATIONNAME", jOURNEY.DEPARTURE); return(View(jOURNEY)); }
// GET: Journeys/Details/5 public ActionResult Details(decimal id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } JOURNEY jOURNEY = db.JOURNEYs.Find(id); if (jOURNEY == null) { return(HttpNotFound()); } return(View(jOURNEY)); }
public IHttpActionResult DeleteJOURNEY(decimal id) { JOURNEY jOURNEY = db.JOURNEYs.Find(id); if (jOURNEY == null) { return(NotFound()); } db.JOURNEYs.Remove(jOURNEY); db.SaveChanges(); return(Ok(jOURNEY)); }
// GET: Journeys/Edit/5 public ActionResult Edit(decimal id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } JOURNEY jOURNEY = db.JOURNEYs.Find(id); if (jOURNEY == null) { return(HttpNotFound()); } ViewBag.ARRIVAL = new SelectList(db.STATIONs, "STATIONID", "STATIONNAME", jOURNEY.ARRIVAL); ViewBag.DEPARTURE = new SelectList(db.STATIONs, "STATIONID", "STATIONNAME", jOURNEY.DEPARTURE); return(View(jOURNEY)); }
// GET: Journeys/Create public ActionResult Create() { ViewBag.ARRIVAL = new SelectList(db.STATIONs, "STATIONID", "STATIONNAME"); ViewBag.DEPARTURE = new SelectList(db.STATIONs, "STATIONID", "STATIONNAME"); JOURNEY newJourney = new JOURNEY(); var lastJourney = db.JOURNEYs.OrderByDescending(x => x.JOURNEYID).FirstOrDefault(); if (lastJourney == null) { newJourney.JOURNEYID = 6001; } else if (lastJourney.JOURNEYID != 0) { newJourney.JOURNEYID = lastJourney.JOURNEYID + 1; } return(View(newJourney)); }