public IEnumerable <Car> Get() { using (BookCarDBEntities entities = new BookCarDBEntities()) { return(entities.Cars.ToList()); } }
public HttpResponseMessage Put(int id, [FromBody] Car car) { using (BookCarDBEntities entities = new BookCarDBEntities()) { try { var entity = entities.Cars.FirstOrDefault(e => e.Id == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Car with id =" + id.ToString() + "was not found!")); } else { entity.model = car.model; entity.make = car.make; entity.location = car.location; entity.avaStart = car.avaStart; entity.avaEnd = car.avaEnd; entity.price = car.price; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } } }
public ActionResult Pay(int id, Car car) { try { using (BookCarDBEntities db = new BookCarDBEntities()) { var carToDelete = db.Cars.FirstOrDefault(c => c.Id == id); var book = CreateNewBooking(carToDelete); db.Bookings.Add(book); db.Cars.Remove(carToDelete); db.SaveChanges(); return(RedirectToAction("ListBookings", "Home")); } } catch (Exception ex) { return(View(ex + "error")); } }
public ActionResult ListBookings() { string username = User.Identity.Name; var bookings = new List <CarDataAccess.Booking>(); using (var db = new BookCarDBEntities()) { bookings = db.Bookings.ToList(); } return(View(bookings)); }
public ActionResult ListCars() { string username = User.Identity.Name; var cars = new List <CarDataAccess.Car>(); using (var db = new BookCarDBEntities()) { cars = db.Cars.ToList(); } return(View(cars)); }
public HttpResponseMessage GetbyId(int id) { using (BookCarDBEntities entities = new BookCarDBEntities()) { var entity = entities.Cars.FirstOrDefault(c => c.Id == id); if (entities != null) { return(Request.CreateResponse(HttpStatusCode.OK, entity)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Car with id = " + id.ToString() + "was not found")); } } }
public ActionResult Payment(int id) { using (BookCarDBEntities entities = new BookCarDBEntities()) { var entity = entities.Cars.FirstOrDefault(c => c.Id == id); if (entity != null) { return(View(entity)); } else { return(View("Not Found")); } } }
public HttpResponseMessage Post([FromBody] Car car) { try { using (BookCarDBEntities entities = new BookCarDBEntities()) { entities.Cars.Add(car); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, car); message.Headers.Location = new Uri(Request.RequestUri + car.Id.ToString()); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Delete(int id) { try { using (BookCarDBEntities entities = new BookCarDBEntities()) { var entity = entities.Cars.FirstOrDefault(e => e.Id == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Car with id = " + id.ToString() + "doesnt exists")); } else { entities.Cars.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "Car with id" + id + "has been deleted succesfully")); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }