public List <KeyValueOption <int> > GetTheatre(int locationID, int theatreID, DateTime schedulingdate) { using (var context = new OMSTContext()) { var scheduled = (from row in context.ShowTimes where row.Theatre.LocationID == locationID && row.TheatreID == theatreID && schedulingdate.Year == row.StartDate.Year && schedulingdate.Month == row.StartDate.Month && schedulingdate.Day == row.StartDate.Day select row).FirstOrDefault(); if (scheduled == null) { var result = from row in context.Theatres where row.LocationID == locationID && row.TheatreID == theatreID select new KeyValueOption <int> { DisplayText = row.TheatreNumber.ToString(), Key = row.TheatreID }; return(result.ToList()); } else { return(new List <KeyValueOption <int> >()); } } }
public decimal Movies_GetTicketPrices(int movieid) { using (var context = new OMSTContext()) { var premiuminfo = (from x in context.Movies where x.MovieID == movieid select x.ScreenType).FirstOrDefault(); decimal premiumticket = 0.00m; if (premiuminfo == null) { throw new Exception("Movie screentype info missing"); } if (premiuminfo.Premium) { if (premiuminfo.ScreenTypeID == 2) { premiumticket = 3.00m; } else { premiumticket = 5.00m; } } return(premiumticket); } }
public List <Category> TicketCategory_List() { using (var context = new OMSTContext()) { return(context.TicketCategories.Select(x => new Category { Description = x.Description, TicketPrice = x.TicketPrice }).ToList()); } }
public List <KeyValueOption <int> > Locations_List() { using (var context = new OMSTContext()) { return(context.Locations.Select(x => new KeyValueOption <int> { Key = x.LocationID, DisplayText = x.Description }).ToList()); } }
public List <KeyValueOption <int> > ListAllLocations() { using (var context = new OMSTContext()) { var result = from row in context.Locations select new KeyValueOption <int> { DisplayText = row.Description, Key = row.LocationID }; return(result.ToList()); } }
public List <KeyValueOption <int> > ListMovies() { using (var context = new OMSTContext()) { var result = from row in context.Movies orderby row.Title select new KeyValueOption <int> { DisplayText = row.Title + " (" + row.Length.ToString() + ")", Key = row.MovieID }; return(result.ToList()); } }
public List <KeyValueOption <int> > ListTheatres(int locationID) { using (var context = new OMSTContext()) { var result = from row in context.Theatres where row.LocationID == locationID select new KeyValueOption <int> { DisplayText = row.TheatreNumber.ToString(), Key = row.TheatreID }; return(result.ToList()); } }
public List <RecentTickets> Tickets_NewlyAddedTickets() { using (var context = new OMSTContext()) { return(context.Tickets .Where(x => x.TicketID > (context.Tickets.Max(y => y.TicketID) - 25)) .OrderByDescending(x => x.TicketID) .Select(x => new RecentTickets { TicketID = x.TicketID, ShowTimeID = x.ShowTimeID, TicketCategoryID = x.TicketCategoryID, TicketPrice = x.TicketPrice, TicketPremium = x.TicketPremium }) .ToList()); } }
public List <ShowTimesAssessment> ShowTimes_ListByStartTimes() { using (var context = new OMSTContext()) { var results = (from x in context.ShowTimes orderby x.StartDate descending select new ShowTimesAssessment { ShowTimeID = x.ShowTimeID, MovieIDTitle = x.MovieID.ToString() + " (" + x.Movie.Title + ")", StartDate = x.StartDate, TheatreIDTheatreNumber = x.TheatreID.ToString() + " (Number:" + x.Theatre.TheatreNumber + ")" }).Take(30); return(results.ToList()); } }
public List <KeyValueOption <int> > ShowTimes_MoviesByLocations(int locationid) { DateTime fakeDate = DateTime.Parse("2017-12-28"); using (var context = new OMSTContext()) { var results = (from x in context.ShowTimes where x.StartDate.Year == 2017 && x.StartDate.Month == 12 && x.StartDate.Day == 28 && x.Theatre.LocationID == locationid select new KeyValueOption <int> { Key = x.MovieID, DisplayText = x.Movie.Title }).Distinct().OrderBy(x => x.DisplayText); return(results.ToList()); } }
public List <MovieShowTimes> ShowTimes_ShowTimesByMoviesByLocations(int locationid, int movieid) { DateTime fakeDate = DateTime.Parse("2017-12-28"); using (var context = new OMSTContext()) { var results = (from x in context.ShowTimes where x.StartDate.Year == 2017 && x.StartDate.Month == 12 && x.StartDate.Day == 28 && x.Theatre.LocationID == locationid && x.MovieID == movieid select new MovieShowTimes { TheatreNumber = x.Theatre.TheatreNumber, ShowTimeID = x.ShowTimeID, Times = x.StartDate }).Distinct().OrderBy(x => x.Times); return(results.ToList()); } }