public ActionResult Scheduling(string TargetDate, string TargetTheatre, string CopiedDate)
{
// create variables of appropriate datatype variables
DateTime copieddate = DateTime.Now;
DateTime targetdate = DateTime.Now;
Theatre targettheatre = Theatre.TheatreOne;
//Filter through Try and Catch
try
{
copieddate = DateTime.Parse(CopiedDate);
targetdate = DateTime.Parse(TargetDate);
targettheatre = (Theatre)Theatre.Parse(typeof(Theatre), TargetTheatre);
}
catch
{
return(RedirectToAction("Scheduling"));
}
if (copieddate > targetdate)
{
return(RedirectToAction("Scheduling"));
}
//Create to a list to get all movies
var query = from r in db.Showings select r;
query = query.Where(sh => sh.StartTime.Day == copieddate.Day);
List <Showing> CopyShowings = query.ToList();
//Get TimeBetween the date they want to copy and the date they want populate
TimeSpan TimeBetween = (targetdate - copieddate);
//Create new showing and populate the correct Showing Starttime and Endtime
int limit = CopyShowings.Count;
var query2 = from t in db.Showings select t;
query2 = query2.Where(sh => sh.StartTime.Day == targetdate.Day);
List <Showing> TestShowings = query2.ToList();
if (TestShowings.Count == 0)
{
//Change Date of every copied showing date before adding to database
for (int i = 0; i < limit; i++)
{
if ((CopyShowings[i].StartTime.Day != targetdate.Day) || ((CopyShowings[i].StartTime.Month != targetdate.Month)))
{
Showing show = new Showing();
Showing copyshow = db.Showings.Find(CopyShowings[i].ShowingID);
show.SpecialEventStatus = copyshow.SpecialEventStatus;
show.Movie = db.Movies.Find(copyshow.Movie.MovieID);
show.StartTime = copyshow.StartTime + TimeBetween;
show.EndTime = copyshow.EndTime + TimeBetween;
show.TheatreNum = targettheatre;
db.Showings.Add(show);
//db.Entry(show).State = EntityState.Modified;
db.SaveChanges();
}
}
//Create a list for all the movies in date
ViewBag.Confirm = "Dates have been successfully copied!";
return(View("Confirmation"));
}
ViewBag.ErrorMessage = "Movies are already scheduled for this day";
return(View("Scheduling"));
}