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