public ActionResult Create(Venue venue)
{
if (ModelState.IsValid)
{
db.Venues.Add(venue);
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.Venue_CountryId = new SelectList(db.CountryRegions.OrderBy(c => c.CountryRegion_Name), "CountryRegion_Id", "CountryRegion_Code", venue.Venue_CountryId);
ViewBag.Venue_StateProvinceId = new SelectList(db.StateProvinces.OrderBy(s => s.StateProvince_Name), "StateProvince_Id", "StateProvince_Code", venue.Venue_StateProvinceId);
return View(venue);
}
public ActionResult EditEvent(Event Xevent, string VenueName)
{
if (ModelState.IsValid)
{
Venue venue = db.Venues.FirstOrDefault(a => a.Venue_Name == VenueName);
if (venue != null)
{
//attach the artist
Xevent.Event_VenueId = venue.Venue_Id;
}
else
{
//create a new piece
// remove any unnecessary spaces
VenueName.Replace(" ", " ").Trim();
Venue newVenue = new Venue();
newVenue.Venue_Name = VenueName;
db.Venues.Add(newVenue);
Xevent.Event_VenueId = newVenue.Venue_Id;
}
db.Entry(Xevent).State = EntityState.Modified;
db.SaveChanges();
ViewBag.Venue = db.Venues.FirstOrDefault(v => v.Venue_Id == Xevent.Event_VenueId);
// data for the genre
ViewBag.Genre = db.Genres.FirstOrDefault(g => g.Genre_Id == Xevent.Event_GenreId);
return PartialView("DetailsEvent", Xevent);
}
else
{
return Content("Please review your form");
}
}
public ActionResult CreateEvent(Event eventX, string Event_VenueName)
{
if (ModelState.IsValid)
{
Venue venue = db.Venues.FirstOrDefault(v => v.Venue_Name.Equals(Event_VenueName));
if (venue != null)
{
//attach the venue
eventX.Event_VenueId = venue.Venue_Id;
}
else
{
//create a new venue
Venue newVenue = new Venue();
// remove any unnecessary spaces
Event_VenueName.Replace(" ", " ").Trim();
newVenue.Venue_Name = Event_VenueName;
db.Venues.Add(newVenue);
eventX.Event_VenueId = newVenue.Venue_Id;
}
// set the creation details
eventX.Event_CreatedBy = (int)Session["UserID"];
eventX.Event_CreatedDate = DateTime.Now;
db.Events.Add(eventX);
db.SaveChanges();
// data for the performances
ViewBag.performances = db.Performances
.Where(p => p.Performance_EventId == eventX.Event_Id)
.OrderBy(p => p.Performance_Order)
.Take(PageSize+1);
// data for the venue
ViewBag.Venue = db.Venues.FirstOrDefault(v => v.Venue_Id == eventX.Event_VenueId);
// data for the genre
ViewBag.Genre = db.Genres.FirstOrDefault(g => g.Genre_Id == eventX.Event_GenreId);
// data for the MyStatus dropdown
if (eventX.Event_Date < DateTime.Today)
{
var query = db.EventUserStatus.OrderBy(c => c.EventUserStatus_Id)
.Select(c => new
{
c.EventUserStatus_Id,
c.EventUserStatus_Past
});
ViewBag.MyStatus = new SelectList(query.AsEnumerable(), "EventUserStatus_Id", "EventUserStatus_Past", ViewBag.EventUser_StatusId);
}
else
{
var query = db.EventUserStatus.OrderBy(c => c.EventUserStatus_Id)
.Select(c => new
{
c.EventUserStatus_Id,
c.EventUserStatus_Future
});
ViewBag.MyStatus = new SelectList(query.AsEnumerable(), "EventUserStatus_Id", "EventUserStatus_Future", ViewBag.EventUser_StatusId);
}
// Can the current user edit this event?
ViewBag.UserCanEditEvent = true;
// sort out the paging
ViewBag.page = 0;
ViewBag.PageSize = PageSize;
return View("Details", eventX);
}
else
{
return Content("Please review your form");
}
}
public ActionResult CopyEvent(Event xEvent, int oldEventId, string VenueName)
{
if (ModelState.IsValid)
{
// Sort out the venue
Venue venue = db.Venues.FirstOrDefault(a => a.Venue_Name == VenueName);
if (venue != null)
{
//attach the artist
xEvent.Event_VenueId = venue.Venue_Id;
}
else
{
//create a new piece
// remove any unnecessary spaces
VenueName.Replace(" ", " ").Trim();
Venue newVenue = new Venue();
newVenue.Venue_Name = VenueName;
db.Venues.Add(newVenue);
xEvent.Event_VenueId = newVenue.Venue_Id;
}
db.Events.Add(xEvent);
db.Entry(xEvent).State = EntityState.Added;
db.SaveChanges();
// copy over all the child objects
Event oldEvent = db.Events.Single(e => e.Event_Id == oldEventId);
foreach (PerfV400.Models.Performance performance in oldEvent.Performances)
{
Performance newPerformance = new Performance();
newPerformance.Performance_EventId = xEvent.Event_Id;
newPerformance.Performance_Order = performance.Performance_Order;
newPerformance.Performance_Photo = performance.Performance_Photo;
newPerformance.Performance_PhotoFileName = performance.Performance_PhotoFileName;
newPerformance.Performance_PhotoMimeType = performance.Performance_PhotoMimeType;
newPerformance.Performance_PieceId = performance.Performance_PieceId;
newPerformance.Performance_ProductionId = performance.Performance_ProductionId;
db.Performances.Add(newPerformance);
db.Entry(newPerformance).State = EntityState.Added;
db.SaveChanges();
foreach (PerfV400.Models.PerformanceArtist performanceArtist in performance.PerformanceArtists)
{
PerformanceArtist newPerformanceArtist = new PerformanceArtist();
newPerformanceArtist.PerformanceArtist_ArtistId = performanceArtist.PerformanceArtist_ArtistId;
newPerformanceArtist.PerformanceArtist_Comments = performanceArtist.PerformanceArtist_Comments;
newPerformanceArtist.PerformanceArtist_PerformanceId = newPerformance.Performance_Id;
newPerformanceArtist.PerformanceArtist_Photo = performanceArtist.PerformanceArtist_Photo;
newPerformanceArtist.PerformanceArtist_RoleId = performanceArtist.PerformanceArtist_RoleId;
db.PerformanceArtists.Add(newPerformanceArtist);
db.Entry(newPerformanceArtist).State = EntityState.Added;
}
}
db.SaveChanges();
// Retrieve the data for the view
// data for the performances
ViewBag.performances = db.Performances
.Where(p => p.Performance_EventId == xEvent.Event_Id)
.OrderBy(p => p.Performance_Order)
.Take(60)
.Include(p => p.Piece.Genre)
.Include(p => p.PerformanceArtists.Select(pa => pa.Role))
.Include(p => p.PerformanceArtists.Select(pa => pa.Artist))
;
// data for the venue
ViewBag.Venue = db.Venues.FirstOrDefault(v => v.Venue_Id == xEvent.Event_VenueId);
// data for the genre
ViewBag.Genre = db.Genres.FirstOrDefault(g => g.Genre_Id == xEvent.Event_GenreId);
// Can the current user edit this event?
ViewBag.UserCanEditEvent = true;
// data for the MyStatus dropdown
if (xEvent.Event_Date < DateTime.Today)
{
var query = db.EventUserStatus.OrderBy(c => c.EventUserStatus_Id)
.Select(c => new
{
c.EventUserStatus_Id,
c.EventUserStatus_Past
});
ViewBag.MyStatus = new SelectList(query.AsEnumerable(), "EventUserStatus_Id", "EventUserStatus_Past", ViewBag.EventUser_StatusId);
}
else
{
var query = db.EventUserStatus.OrderBy(c => c.EventUserStatus_Id)
.Select(c => new
{
c.EventUserStatus_Id,
c.EventUserStatus_Future
});
ViewBag.MyStatus = new SelectList(query.AsEnumerable(), "EventUserStatus_Id", "EventUserStatus_Future", ViewBag.EventUser_StatusId);
}
// sort out the paging
ViewBag.page = 0;
ViewBag.PageSize = PageSize;
return PartialView("Details", xEvent);
}
else
{
return Content("Please review your form");
}
}
public ActionResult EditVenue(Venue venue)
{
if (ModelState.IsValid)
{
db.Venues.Attach(venue);
db.Entry(venue).State = EntityState.Modified;
db.SaveChanges();
return PartialView("DetailsVenue", venue);
}
else
{
return Content("Please review your form");
}
}