public ActionResult TicketReport() //this simply gives the overall report(total tickets sold and total revenue for all orders confirmed)
{
List <Ticket> allTickets = db.Tickets.Where(t => t.Order.Orderstatus == OrderStatus.Completed).ToList();
List <Order> allOrders = db.Orders.Where(o => o.Orderstatus == OrderStatus.Completed).ToList();
MovieReportVM tivm = new MovieReportVM();
Decimal tax = 0.0825m;
foreach (Ticket td in allTickets)
{
tivm.NumberOfPurchase += 1;
tivm.Revenue += (td.TicketPrice + (td.TicketPrice * tax));
}
return(View(tivm));
}
public ActionResult DisplaySearchResults(DateTime?FirstDate, DateTime?SecondDate, int[] SearchShowingMovies,
MPAArating SelectedMPAARating /*, DateTime? FirsTime, DateTime? SecondTime*/)
{
var query = from t in db.Tickets
where t.Order.Orderstatus == OrderStatus.Completed
select t;
if (SearchShowingMovies != null)
{
foreach (int MovieID in SearchShowingMovies)
{
Movie MovieToFind = db.Movies.Find(MovieID);
query = query.Where(t => t.Showing.SponsoringMovie.MovieID == MovieToFind.MovieID);
}
}
switch (SelectedMPAARating)
{
case MPAArating.G:
query = query.Where(t => t.Movie.MPAAratings == MPAArating.G);
break;
case MPAArating.PG:
query = query.Where(t => t.Movie.MPAAratings == MPAArating.PG);
break;
case MPAArating.PG13:
query = query.Where(t => t.Movie.MPAAratings == MPAArating.PG13);
break;
case MPAArating.R:
query = query.Where(t => t.Movie.MPAAratings == MPAArating.R);
break;
case MPAArating.Unrated:
query = query.Where(t => t.Movie.MPAAratings == MPAArating.Unrated);
break;
case MPAArating.All:
break;
}
if (FirstDate != null && SecondDate != null)
{
query = query.Where(t => DbFunctions.TruncateTime(t.Showing.ShowDate) >= FirstDate && DbFunctions.TruncateTime(t.Showing.ShowDate) <= SecondDate);
}
List <Ticket> SelectedTickets = query.ToList();
//List<Ticket> allTickets = db.Tickets.Where(t => t.Order.Orderstatus == OrderStatus.Completed).ToList();
List <Order> allOrders = db.Orders.Where(o => o.Orderstatus == OrderStatus.Completed).ToList();
MovieReportVM tivm = new MovieReportVM();
Decimal tax = 0.0825m;
foreach (Ticket td in SelectedTickets)
{
tivm.NumberOfPurchase += 1;
tivm.Revenue += (td.TicketPrice + (td.TicketPrice * tax));
}
//return View(tivm);
return(View("DisplaySearchResults", tivm));
}
