public VendorsQuery(ThemeParkDatabaseContext context, ReportQuery query)
{
ReportQuery = query;
Vendors = context.Vendor
.Include(v => v.Location)
.Include(v => v.VendorSalesReport)
.Include(v => v.VendorType)
.ToList();
}
public AttractionsQuery(ThemeParkDatabaseContext context, ReportQuery query)
{
ReportQuery = query;
Attractions = context.Attraction
.Include(a => a.AttractionVisit)
.Include(a => a.AttractionType)
.Include(a => a.MaintenanceRequest)
.Include(a => a.Location)
.ToList();
}
public static async Task Initialize
(IServiceProvider serviceProvider,
string testUserPW)
{
using (var context_a = new ApplicationDbContext
(serviceProvider.GetRequiredService <DbContextOptions
<ApplicationDbContext> >()))
{
var adminId = await EnsureUser(serviceProvider, testUserPW, "*****@*****.**");
await EnsureRole(serviceProvider, adminId, Constants.AdministratorsRole);
using (var context = new ThemeParkDatabaseContext(serviceProvider.GetRequiredService <DbContextOptions <ThemeParkDatabaseContext> >()))
{
InitializeDb(context, context_a, adminId);
}
}
}
public static void InitializeDb(ThemeParkDatabaseContext context, ApplicationDbContext context_t, string adminId)
{
/*
*
* if (context.Location.Any()) { return; }
*
* var pinfo = new ParkInfomation[]
* {
* new ParkInfomation
* {
* Name = "Houston Theme Park",
* Country = "USA",
* State = "TX",
* City = "Houston",
* PostalCode = "77042",
* Address = "11223 Grant Rd"
* },
* };
* foreach (ParkInfomation pi in pinfo) { context.ParkInfomation.Add(pi); }
* context.SaveChanges();
*
* var weather = new WeatherAudit[]
* {
* new WeatherAudit
* {
* Date = DateTime.Parse("2009-10-03") ,
* Rainout = false,
* Temperature = 70.0,
* InchesPercipitation = 0.0
* }
* };
* foreach (WeatherAudit w in weather) { context.WeatherAudit.Add(w); }
* context.SaveChanges();
*
*
* var locations = new Location[]
* {
* new Location {Name = "North"},
* new Location {Name = "East"},
* new Location {Name = "West"},
* new Location {Name = "South"},
* new Location {Name = "Center"}
*
* };
* foreach (Location l in locations) { context.Location.Add(l); }
* context.SaveChanges();
*
* var atypes = new AttractionType[]
* {
* new AttractionType {Name = "Roller Coaster"},
* new AttractionType {Name = "Merry go Round"},
* new AttractionType {Name = "Farris Wheel"},
* new AttractionType {Name = "Haunted House"},
* new AttractionType {Name = "Water Slide"}
*
* };
* foreach (AttractionType at in atypes) { context.AttractionType.Add(at); }
* context.SaveChanges();
*
* var attractions = new Attraction[]
* {
* new Attraction
* {
* AttractionTypeId = atypes.Single( s => s.Name == "Haunted House").Id,
* LocationId = locations.Single( s => s.Name == "North").Id,
* Name = "Spooky House",
* Description = "Boo!",
* },
* new Attraction
* {
* AttractionTypeId = atypes.Single( s => s.Name == "Roller Coaster").Id,
* LocationId = locations.Single( s => s.Name == "East").Id,
* Name = "Wild Ride",
* Description = "Wee!",
* },
* new Attraction
* {
* AttractionTypeId = atypes.Single( s => s.Name == "Water Slide").Id,
* LocationId = locations.Single( s => s.Name == "West").Id,
* Name = "Water Snake",
* Description = "Hiss!",
* },
* new Attraction
* {
* AttractionTypeId = atypes.Single( s => s.Name == "Farris Wheel").Id,
* LocationId = locations.Single( s => s.Name == "South").Id,
* Name = "Great View",
* Description = "Ooh!",
* },
* new Attraction
* {
* AttractionTypeId = atypes.Single( s => s.Name == "Merry go Round").Id,
* LocationId = locations.Single( s => s.Name == "Center").Id,
* Name = "Spinner",
* Description = "Woha!",
* }
*
* };
* foreach (Attraction a in attractions) { context.Attraction.Add(a); }
*
* var avisits = new AttractionVisit[]
* {
* new AttractionVisit {Time = DateTime.Parse("2008-01-20"), AttractionId = attractions.Single(s => s.Name == "Spinner").Id },
* new AttractionVisit {Time = DateTime.Parse("2008-01-21"), AttractionId = attractions.Single(s => s.Name == "Great View").Id},
* new AttractionVisit {Time = DateTime.Parse("2008-01-22"), AttractionId = attractions.Single(s => s.Name == "Water Snake").Id},
* new AttractionVisit {Time = DateTime.Parse("2008-01-23"), AttractionId = attractions.Single(s => s.Name == "Wild Ride").Id},
* new AttractionVisit {Time = DateTime.Parse("2008-01-24"), AttractionId = attractions.Single(s => s.Name == "Spooky House").Id}
*
* };
* foreach (AttractionVisit av in avisits)
* {
* //var attractionVisitsInDatabase = context.AttractionVisit.Where
* // (s => s.Attraction.Id == av.AttractionId);
*
* var attractionVisitsInDatabase = context.AttractionVisit.Where(s => s.Attraction.Id == av.AttractionId).SingleOrDefault();
* if (attractionVisitsInDatabase == null)
* {
* context.AttractionVisit.Add(av);
* }
*
* }
* context.SaveChanges();
*
* var mrequest = new MaintenanceRequest[]
* {
* new MaintenanceRequest
* {
* AttractionId = 1,
* Description = "Spooky House as a leeky pipe",
* DateRequested = DateTime.Parse("2009-10-03"),
* DateResolved = DateTime.Parse("2009-10-03"),
* CurrentStatus = "Still leaky",
* EstimatedCost = 53.96m,
*
*
* }
* };
*
* foreach (MaintenanceRequest m in mrequest)
* {
* var maintenanceInDatabase = context.MaintenanceRequest.Where
* (s => s.Attraction.Id == m.AttractionId).SingleOrDefault();
* if (maintenanceInDatabase == null)
* {
* context.MaintenanceRequest.Add(m);
* }
*
* }
* context.SaveChanges();
*
* var departments = new Department[]
* {
* new Department
* {
*
* LocationId = locations.Single( s => s.Name == "Center").Id,
* Name = "Management"
* },
* new Department
* {
*
* LocationId = locations.Single( s => s.Name == "West").Id,
* Name = "Maintenance"
* },
* new Department
* {
*
* LocationId = locations.Single( s => s.Name == "Center").Id,
* Name = "Ride Attendants"
* },
* new Department
* {
*
* LocationId = locations.Single( s => s.Name == "South").Id,
* Name = "Vendor Employee"
* }
*
* };
* foreach (Department d in departments) { context.Department.Add(d); }
* context.SaveChanges();
*
*
* var employees = new Employee[]
* {
* new Employee
* {
* FirstName = "Juan",
* LastName = "Garcia",
* Title = "Ride Attendant",
* DepartmentId = departments.Single(s => s.Name == "Ride Attendants").Id,
* HireDate = DateTime.Parse("2008-04-15"),
* Salary = 10.25m
* },
* new Employee
* {
* FirstName = "John",
* MiddleInitial = "H",
* LastName = "Smith",
* Title = "Ride Attendant",
* DepartmentId = departments.Single(s => s.Name == "Ride Attendants").Id,
* HireDate = DateTime.Parse("2008-06-16"),
* Salary = 8.25m
* },
* new Employee
* {
* FirstName = "Sally",
* LastName = "Red",
* Title = "Ride Attendant",
* DepartmentId = departments.Single(s => s.Name == "Ride Attendants").Id,
* HireDate = DateTime.Parse("2008-05-21"),
* Salary = 8.25m
* },
* new Employee
* {
* FirstName = "Nick",
* LastName = "Rodger",
* Title = "Maintenance Crew",
* DepartmentId = departments.Single(s => s.Name == "Maintenance").Id,
* HireDate = DateTime.Parse("2007-09-25"),
* Salary = 18.75m
* },
* new Employee
* {
* FirstName = "David",
* LastName = "Valentino",
* Title = "Maintenance Crew",
* DepartmentId = departments.Single(s => s.Name == "Maintenance").Id,
* HireDate = DateTime.Parse("2007-09-15"),
* Salary = 18.75m
* },
* new Employee
* {
* FirstName = "Leon",
* LastName = "Nobody",
* Title = "Vendor Cashier",
* DepartmentId = departments.Single(s => s.Name == "Vendor Employee").Id,
* HireDate = DateTime.Parse("2008-02-07"),
* Salary = 10.25m
* },
* new Employee
* {
* FirstName = "Ashely",
* LastName = "Frutiz",
* Title = "Manager",
* DepartmentId = departments.Single(s => s.Name == "Management").Id,
* HireDate = DateTime.Parse("2006-07-09"),
* Salary = 27.85m
* },
*
*
* };
* foreach (Employee e in employees)
* {
* var employeeInDatabase = context.Employee.Where
* (s => s.Department.Id == e.DepartmentId).SingleOrDefault();
* if (employeeInDatabase == null)
* context.Employee.Add(e);
* }
* context.SaveChanges();
*
*
* var ttypes = new TicketType[]
* {
* new TicketType
* {
* Name = "Basic",
* Description = "Basic, one time use ticket",
* Price = 5.00m,
*
* },
* new TicketType
* {
* Name = "30-Day",
* Description = "30 day ticket, good for 30 uses",
* Price = 50.00m,
*
* },
* new TicketType
* {
* Name = "Premium",
* Description = "Premium ticket, good for 180 uses",
* Price = 100.00m,
*
* }
* };
* foreach (TicketType tt in ttypes) { context.TicketType.Add(tt); }
* context.SaveChanges();
*
* var visitors = new Visitor[]
* {
* new Visitor
* {
* FirstName = "John",
* LastName = "Hop",
* Email = "*****@*****.**",
* PhoneNumber = "1234567890",
* DateOfBirth = DateTime.Parse("1988-04-15"),
* },
* new Visitor
* {
* FirstName = "John",
* LastName = "Hope",
* Email = "*****@*****.**",
* PhoneNumber = "1234567890",
* DateOfBirth = DateTime.Parse("1988-04-15"),
* },
* new Visitor
* {
* FirstName = "John",
* LastName = "Hopee",
* Email = "*****@*****.**",
* PhoneNumber = "1234567890",
* DateOfBirth = DateTime.Parse("1988-04-15"),
* },
* new Visitor
* {
* FirstName = "John",
* LastName = "Hopeee",
* Email = "*****@*****.**",
* PhoneNumber = "1234567890",
* DateOfBirth = DateTime.Parse("1988-04-15"),
* },
* new Visitor
* {
* FirstName = "Jeff",
* LastName = "Croft",
* Email = "*****@*****.**",
* PhoneNumber = "1234567891",
* DateOfBirth = DateTime.Parse("1989-04-15"),
* },
* new Visitor
* {
* FirstName = "Joe",
* LastName = "Person",
* Email = "*****@*****.**",
* PhoneNumber = "1234567892",
* DateOfBirth = DateTime.Parse("1990-04-15"),
* },
* new Visitor
* {
* FirstName = "Jane",
* LastName = "Mot",
* Email = "*****@*****.**",
* PhoneNumber = "1234567893",
* DateOfBirth = DateTime.Parse("1991-04-15"),
* },
* new Visitor
* {
* FirstName = "Jo",
* LastName = "Zi",
* Email = "*****@*****.**",
* PhoneNumber = "1234567894",
* DateOfBirth = DateTime.Parse("1992-04-15"),
* },
* new Visitor
* {
* FirstName = "Jello",
* LastName = "Yee",
* Email = "*****@*****.**",
* PhoneNumber = "1234567895",
* DateOfBirth = DateTime.Parse("1993-04-15"),
* },
* new Visitor
* {
* FirstName = "Jesus",
* LastName = "Xo",
* Email = "*****@*****.**",
* PhoneNumber = "1234567896",
* DateOfBirth = DateTime.Parse("1994-04-15"),
* }
* };
* foreach (Visitor vi in visitors)
* {
* context.Visitor.Add(vi);
* }
* context.SaveChanges();
*
* var tickets = new Ticket[]
* {
* new Ticket
* {
* PurchaseDate = DateTime.Parse("2009-10-03"),
* TicketTypeId = ttypes.Single(s => s.Name == "Basic").Id,
* VisitorId = visitors.Single(s => s.LastName == "Hop").Id,
* RedeemedDate = DateTime.Parse("2009-10-03")
*
* },
* new Ticket
* {
* PurchaseDate = DateTime.Parse("2009-10-03"),
* TicketTypeId = ttypes.Single(s => s.Name == "Basic").Id,
* VisitorId = visitors.Single(s => s.LastName == "Hope").Id,
* RedeemedDate = DateTime.Parse("2009-10-03")
* },
* new Ticket
* {
* PurchaseDate = DateTime.Parse("2009-10-03"),
* TicketTypeId = ttypes.Single(s => s.Name == "Basic").Id,
* VisitorId = visitors.Single(s => s.LastName == "Hopee").Id,
* RedeemedDate = DateTime.Parse("2009-10-03")
* },
* new Ticket
* {
* PurchaseDate = DateTime.Parse("2009-10-03"),
* TicketTypeId = ttypes.Single(s => s.Name == "Basic").Id,
* VisitorId = visitors.Single(s => s.LastName == "Hopeee").Id,
* RedeemedDate = DateTime.Parse("2009-10-03")
* },
* new Ticket
* {
* PurchaseDate = DateTime.Parse("2009-10-03"),
* TicketTypeId = ttypes.Single(s => s.Name == "Basic").Id,
* VisitorId = visitors.Single(s => s.LastName == "Croft").Id,
* RedeemedDate = DateTime.Parse("2009-10-03")
* },
* new Ticket
* {
* PurchaseDate = DateTime.Parse("2009-10-03"),
* TicketTypeId = ttypes.Single(s => s.Name == "Basic").Id,
* VisitorId = visitors.Single(s => s.LastName == "Person").Id,
* RedeemedDate = DateTime.Parse("2009-10-03")
* },
*
* new Ticket
* {
* PurchaseDate = DateTime.Parse("2009-10-03"),
* TicketTypeId = ttypes.Single(s => s.Name == "Basic").Id,
* VisitorId = visitors.Single(s => s.LastName == "Mot").Id,
* RedeemedDate = DateTime.Parse("2009-10-03")
* },
* new Ticket
* {
* PurchaseDate = DateTime.Parse("2009-10-03"),
* TicketTypeId = ttypes.Single(s => s.Name == "30-Day").Id,
* VisitorId = visitors.Single(s => s.LastName == "Zi").Id,
* RedeemedDate = DateTime.Parse("2009-10-03")
* },
* new Ticket
* {
* PurchaseDate = DateTime.Parse("2009-10-03"),
* TicketTypeId = ttypes.Single(s => s.Name == "30-Day").Id,
* VisitorId = visitors.Single(s => s.LastName == "Yee").Id,
* RedeemedDate = DateTime.Parse("2009-10-03")
* },
* new Ticket
* {
* PurchaseDate = DateTime.Parse("2009-10-03"),
* TicketTypeId = ttypes.Single(s => s.Name == "Premium").Id,
* VisitorId = visitors.Single(s => s.LastName == "Xo").Id,
* RedeemedDate = DateTime.Parse("2009-10-03")
* }
*
* };
* foreach (Ticket t in tickets) { context.Ticket.Add(t); }
* context.SaveChanges();
*
*
* var vtypes = new VendorType[]
* {
* new VendorType { Name = "Stand" },
* new VendorType { Name = "Store" },
* new VendorType { Name = "Game" },
* };
* foreach (VendorType vt in vtypes) { context.VendorType.Add(vt); }
* context.SaveChanges();
*
*
* var vendors = new Vendor[]
* {
* new Vendor
* {
* Name = "Tacos to Go",
* Description = "Sells tacos to people on the go",
* LocationId = locations.Single(s => s.Name == "West").Id,
* VendorTypeId = vtypes.Single(s => s.Name == "Stand").Id,
* },
* new Vendor
* {
* Name = "Shoot Them All",
* Description = "Shoot down all the targets win prizes",
* LocationId = locations.Single(s => s.Name == "East").Id,
* VendorTypeId = vtypes.Single(s => s.Name == "Game").Id,
* },
* new Vendor
* {
* Name = "Park Gifts",
* Description = "Gifts for your friends who couldn't be here",
* LocationId = locations.Single(s => s.Name == "Center").Id,
* VendorTypeId = vtypes.Single(s => s.Name == "Store").Id,
* }
* };
* foreach (Vendor ve in vendors) { context.Vendor.Add(ve); }
* context.SaveChanges();
*
* var vsales = new VendorSalesReport[]
* {
* new VendorSalesReport
* {
* Date = DateTime.Parse("2009-10-03") ,
* TotalSales = 73.85m,
* SalesGoal = 100.00m,
* VendorId = vendors.Single(s => s.Name == "Park Gifts").Id,
* },
* new VendorSalesReport
* {
* Date = DateTime.Parse("2009-10-03") ,
* TotalSales = 150.00m,
* SalesGoal = 75.00m,
* VendorId = vendors.Single(s => s.Name == "Shoot Them All").Id,
* },
* new VendorSalesReport
* {
* Date = DateTime.Parse("2009-10-03") ,
* TotalSales = 100.00m,
* SalesGoal = 50.00m ,
* VendorId = vendors.Single(s => s.Name == "Tacos to Go").Id,
* }
* };
* foreach (VendorSalesReport ve in vsales)
* {
* var VendorSalesReportsInDatabase = context.VendorSalesReport.Where
* (s => s.Vendor.Id == ve.VendorId).SingleOrDefault();
* if (VendorSalesReportsInDatabase == null)
* context.VendorSalesReport.Add(ve);
*
* }
* context.SaveChanges();
*
*
*
*/
}
public ReportQueriesController(ThemeParkDatabaseContext context)
{
_context = context;
}
public IndexModel(ThemeParkDatabaseContext context)
{
_context = context;
}
public VisitorsQuery(ThemeParkDatabaseContext context, ReportQuery query)
{
ReportQuery = query;
DailyParkReports = context.DailyParkReport.ToList();
}
