//public IActionResult Test()
//{
// LoadLinesFromFile("AppData", "ConcertsIHaveSeen.txt");
// //MakeConcertsFromLines(Lines);
// return RedirectToAction("Index");
//}
private void MakeConcertsFromLines(Dictionary <int, string[]> lines)
{
// line = Era, Date, Notes, Band ... Band5, Arena, City, St, Tour, With ... With5
for (var i = 0; i < Lines.Count; i++)
{
var line = Lines[i];
// make concert
var concert = MakeConcert(line[0], line[1], line[8], line[11], line[2]);
_ctx.Cc_Concerts.Add(concert);
_ctx.SaveChanges();
// make concertartists
for (var j = 3; j < 8; j++)
{
if (!string.IsNullOrEmpty(line[j]))
{
var artist = _ctx.Cc_Artists.First(a => a.Name == line[j]);
_ctx.Cc_ConcertArtists.Add(new ConcertArtist(concert, artist, j - 2));
}
}
// make concertpeople
for (var j = 12; j < 17; j++)
{
if (!string.IsNullOrEmpty(line[j]))
{
var person = _ctx.Cc_People.First(a => a.Name == line[j]);
_ctx.Cc_ConcertPeople.Add(new ConcertPerson(concert, person, j - 11));
}
}
_ctx.SaveChanges();
}
}
public IActionResult UpdateEvent(Zad2 z)
{
var e = _context.Event.Where(h => h.IdEventr == z.idEvent).FirstOrDefault();
if (e == null)
{
return(NotFound("Brak danego eventu"));
}
var r = _context.Artist.Where(h => h.IdArtist == z.idArtist).FirstOrDefault();
if (r == null)
{
return(NotFound("Brak danego artysty"));
}
var a = _context.Artist_Event.Where(h => h.IdArtist == z.idArtist && h.IdEvent == z.idEvent).FirstOrDefault();
if (a == null)
{
return(NotFound("Artysta nie wystepuje na podanym evencie"));
}
if (e.StartDate < DateTime.Now)
{
return(NotFound("Event sie juz zaczal"));
}
if (z.performaceDate < e.StartDate || z.performaceDate > e.EndDate)
{
return(NotFound("Nowy czas jest poza eventem"));
}
a.PerformanceDate = z.performaceDate;
_context.SaveChanges();
return(Ok("Zmieniono date wystepu"));
}