public async Task <IHttpActionResult> PostEventWithTicket(EventWithTicket eventWithTicket) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.EventsWithTickets.Add(eventWithTicket); await db.SaveChangesAsync(); // New code: // Load Evento db.Entry(eventWithTicket).Reference(x => x.City).Load(); var dto = new EventWithTicketDTO() { EventWithTicketID = eventWithTicket.EventWithTicketID, Name = eventWithTicket.Name, Description = eventWithTicket.Description, City = eventWithTicket.City.CityName, Transport = eventWithTicket.Transport.TransportType, EventDate = eventWithTicket.EventDate, Adress = eventWithTicket.Addres, Price = eventWithTicket.Price, MaxTickets = eventWithTicket.MaxTicket }; return(CreatedAtRoute("DefaultApi", new { id = eventWithTicket.EventWithTicketID }, eventWithTicket)); }
public IHttpActionResult PostTicket(Ticket ticket) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } EventWithTicket query = (from data in db.EventsWithTickets where (data.EventWithTicketID == ticket.EventWithTicketID) select data).SingleOrDefault(); if (query.MaxTicket > 0) { try { db.Tickets.Add(ticket); query.MaxTicket--; db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = ticket.TicketID }, ticket)); } catch {} } else if (query.MaxTicket == 0) { query.HasTickets = false; db.SaveChanges(); } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PutEventWithTicket(int id, EventWithTicket eventWithTicket) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != eventWithTicket.EventWithTicketID) { return(BadRequest()); } db.Entry(eventWithTicket).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!EventWithTicketExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult DeleteConfirmed(int id) { EventWithTicket eventWithTicket = db.EventsWithTickets.Find(id); db.EventsWithTickets.Remove(eventWithTicket); db.SaveChanges(); return(RedirectToAction("Index")); }
public IHttpActionResult GetEventWithTicket(int id) { EventWithTicket eventWithTicket = db.EventsWithTickets.Find(id); if (eventWithTicket == null) { return(NotFound()); } return(Ok(eventWithTicket)); }
public ActionResult Edit([Bind(Include = "EventWithTicketID,CityID,TransportID,EventDate,Description,Addres,HasTickets,MaxTicket")] EventWithTicket eventWithTicket) { if (ModelState.IsValid) { db.Entry(eventWithTicket).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CityID = new SelectList(db.Cities, "CityID", "CityName", eventWithTicket.CityID); ViewBag.TransportID = new SelectList(db.Transports, "TransportID", "TransportType", eventWithTicket.TransportID); return(View(eventWithTicket)); }
public IHttpActionResult PostEventWithTicket(EventWithTicket eventWithTicket) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.EventsWithTickets.Add(eventWithTicket); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = eventWithTicket.EventWithTicketID }, eventWithTicket)); }
// GET: EventWithTickets/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } EventWithTicket eventWithTicket = db.EventsWithTickets.Find(id); if (eventWithTicket == null) { return(HttpNotFound()); } return(View(eventWithTicket)); }
public async Task <IHttpActionResult> DeleteEventWithTicket(int id) { EventWithTicket eventWithTicket = await db.EventsWithTickets.FindAsync(id); if (eventWithTicket == null) { return(NotFound()); } db.EventsWithTickets.Remove(eventWithTicket); await db.SaveChangesAsync(); return(Ok(eventWithTicket)); }
public IHttpActionResult DeleteEventWithTicket(int id) { EventWithTicket eventWithTicket = db.EventsWithTickets.Find(id); if (eventWithTicket == null) { return(NotFound()); } db.EventsWithTickets.Remove(eventWithTicket); db.SaveChanges(); return(Ok(eventWithTicket)); }
// GET: EventWithTickets/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } EventWithTicket eventWithTicket = db.EventsWithTickets.Find(id); if (eventWithTicket == null) { return(HttpNotFound()); } ViewBag.CityID = new SelectList(db.Cities, "CityID", "CityName", eventWithTicket.CityID); ViewBag.TransportID = new SelectList(db.Transports, "TransportID", "TransportType", eventWithTicket.TransportID); return(View(eventWithTicket)); }
public ActionResult Create([Bind(Include = "EventWithTicketID,CityID,TransportID,EventDate,Description,Addres,HasTickets,MaxTicket")] EventWithTicket eventWithTicket) { if (ModelState.IsValid) { if (eventWithTicket.EventDate >= DateTime.Now) { db.EventsWithTickets.Add(eventWithTicket); db.SaveChanges(); return(RedirectToAction("Index")); } return(View("DateError")); } ViewBag.CityID = new SelectList(db.Cities, "CityID", "CityName", eventWithTicket.CityID); ViewBag.TransportID = new SelectList(db.Transports, "TransportID", "TransportType", eventWithTicket.TransportID); return(View(eventWithTicket)); }
public async Task <IHttpActionResult> PostTicket(Ticket ticket) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } EventWithTicket query = (from data in db.EventsWithTickets where (data.EventWithTicketID == ticket.EventWithTicketID) select data).SingleOrDefault(); if (query.MaxTicket > 0) { try { db.Tickets.Add(ticket); query.MaxTicket--; await db.SaveChangesAsync(); db.Entry(ticket).Reference(x => x.Person).Load(); var dto = new TicketDTO() { TicketID = ticket.TicketID, Price = ticket.Price, EventWithTicketID = ticket.EventWithTicketID, PersonID = ticket.DNI }; return(CreatedAtRoute("DefaultApi", new { id = ticket.TicketID }, ticket)); } catch {} } else if (query.MaxTicket == 0) { query.HasTickets = false; db.SaveChanges(); } return(StatusCode(HttpStatusCode.NoContent)); }