public ArtistEvent UpdateArtistEvent(int id, int idEvent, ArtistEvent artistEventRequest) { var artistEventExist = _context.ArtistEvent.Where(e => e.IdEvent == idEvent && e.IdArtist == id).Any(); if (!artistEventExist) { throw new Exception($"Nie ma eventu w ktorym wystepuje artysta z id = {id} oraz eventu z id = {idEvent}"); } else { var artistEvent = _context.Event.Where(e => e.IdEvent == idEvent).Single(); if (artistEvent.StartDate < artistEventRequest.PerformanceDate && artistEvent.EndDate > artistEventRequest.PerformanceDate) { var e1 = new ArtistEvent { IdArtist = id, IdEvent = idEvent, PerformanceDate = artistEventRequest.PerformanceDate }; _context.Attach(e1); _context.Entry(e1).Property("PerformanceDate").IsModified = true; _context.SaveChanges(); } else { throw new Exception($"Nieprawidlowa data, lub data nie miesci sie pomiedzy rozpoczeciem eventu a jego zakonczeniem."); } } return(artistEventRequest); }
protected void btnSubmit_Click(object sender, EventArgs e) { ArtistEvent atd = new ArtistEvent(); atd.EventID = Convert.ToInt32( ddlTourDate.SelectedValue ); Artist art = new Artist(); if (ddlArtist1.SelectedValue != unknownValue && !string.IsNullOrEmpty( ddlArtist1.SelectedValue )) { art = new Artist(ddlArtist1.SelectedValue); atd.ArtistID = art.ArtistID; atd.RankOrder = 1; atd.Create(); if (ddlArtist2.SelectedValue != unknownValue && !string.IsNullOrEmpty(ddlArtist2.SelectedValue)) { art = new Artist(ddlArtist2.SelectedValue); atd.ArtistID = art.ArtistID; atd.RankOrder = 2; atd.Create(); if (ddlArtist3.SelectedValue != unknownValue && !string.IsNullOrEmpty(ddlArtist3.SelectedValue)) { art = new Artist(ddlArtist3.SelectedValue); atd.ArtistID = art.ArtistID; atd.ArtistID = Convert.ToInt32(ddlArtist3.SelectedValue); atd.RankOrder = 3; atd.Create(); } } } }
public IActionResult UpdateArtistEvent(ArtistEventRequest request) { var artistEvent = _context.ArtistEvent .Where(ae => ae.IdArtist == request.IdEvent && ae.IdEvent == request.IdEvent) .FirstOrDefault(); if (artistEvent == null) { return BadRequest("There's no such Event"); } var foundEvent = _context.Event .Where(e => e.IdEvent == artistEvent.IdEvent).FirstOrDefault(); if (!(request.PerformanceDate > foundEvent.StartDate && request.PerformanceDate < foundEvent.EndDate)) return BadRequest("This Event has already started"); var newArtistEvent = new ArtistEvent { IdArtist = artistEvent.IdArtist, IdEvent = artistEvent.IdEvent, PerformanceDate = request.PerformanceDate }; _context.Attach(newArtistEvent); _context.Entry(newArtistEvent).State = EntityState.Modified; return Ok(201); }
public ActionResult DeleteConfirmed(int id) { ArtistEvent artistEvent = db.ArtistEvents.Find(id); db.ArtistEvents.Remove(artistEvent); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "id,artistId,eventId")] ArtistEvent artistEvent) { if (ModelState.IsValid) { db.Entry(artistEvent).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(artistEvent)); }
public ActionResult AddArtist(int eventId) { var @eventArtist = new ArtistEvent() { eventId = eventId }; ViewBag.ArtistId = new SelectList(db.Artists, "id", "name"); return(View(@eventArtist)); }
public ActionResult Create([Bind(Include = "id,artistId,eventId")] ArtistEvent artistEvent) { if (ModelState.IsValid) { db.ArtistEvents.Add(artistEvent); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(artistEvent)); }
public XElement GetXElement(ArtistEvent ev) { var xml = new XElement(PropertyNames.Event); xml.AddAttribute(PropertyNames.EventDate, ev.Date.ToString(StandardDateFormat)); xml.AddAttribute(PropertyNames.EventVenue, ev.Venue); xml.AddAttribute(PropertyNames.EventCity, ev.City); xml.AddAttribute(PropertyNames.EventCountry, ev.Country); xml.AddAttribute(PropertyNames.EventArtistList, ev.ArtistList); return(xml); }
// GET: ArtistEvents/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ArtistEvent artistEvent = db.ArtistEvents.Find(id); if (artistEvent == null) { return(HttpNotFound()); } return(View(artistEvent)); }
public IActionResult UpdateArtist(int id, int idEvent, ArtistEvent artistEvent) { IActionResult res; try { res = Ok(dBService.UpdateArtistEvent(id, idEvent, artistEvent)); } catch (Exception e) { res = NotFound($"Nie ma eventu w ktorym wystepuje artysta z id = {id} oraz eventu z id = {idEvent}, lub data nie miesci sie pomiedzy rozpoczeciem eventu a jego zakonczeniem."); } return(res); }
public List <Artist> SaveArtistInEvent(List <Artist> items, int eventId) { if (items.Count < 1) { return(null); } foreach (var item in items) { var newRecord = new ArtistEvent { ArtistId = item.ArtistId, EventId = eventId, }; db.ArtistEvents.Add(newRecord); db.SaveChanges(); } return(items); }
public bool UpdatePerformance(PerformanceRequest request) { //ifexists //ifexists //ifbierzeudział if (!(_context.ArtistEvents.Any(x => x.idArtist == request.idArtist && x.idEvent == request.idEvent))) { //return new Exception("dfgh"); } if (DateTime.Now > request.performanceDate) { //blad } ///.... /// ArtistEvent ae = _context.ArtistEvents.Where(x => x.idArtist == request.idArtist && x.idEvent == request.idEvent) .FirstOrDefault(); //..if null; return(false); }
public IActionResult UpdateArtistEvent([FromRoute] int idArtist, [FromRoute] int idEvent, [FromBody] ArtistEvent request) { var artistEvent = _context.ArtistEvent .Where(ae => ae.IdArtist == idArtist) .Where(ae => ae.IdEvent == idEvent) .Include(ae => ae.Event) .FirstOrDefault(); if (artistEvent == null) { return(NotFound()); } if (artistEvent.Event.StartDate > DateTime.Now) { return(BadRequest($"event (id: {idEvent}) already started ")); } if (request.PerformanceDate > artistEvent.Event.EndDate || request.PerformanceDate < artistEvent.Event.StartDate) { // TODO detailed error msg return(BadRequest("new performanceDate must be set within event startTime and endTime limits")); } artistEvent.PerformanceDate = request.PerformanceDate; _context.Update(artistEvent); _context.SaveChanges(); return(Ok(artistEvent)); }
private static bool ValidateScheduledTimeUpdate(ArtistEvent oldEntry, DateTime newTime) { return(oldEntry != null && oldEntry.Event.StartDate < newTime && oldEntry.Event.EndTime > newTime); }