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