//helper method: generate mock data
public List <Lot> CreateMockLotData()
{
List <Lot> mockLotData = new List <Lot>();
Lot lot = new Lot("100", "Test Lot 1", "Test Address 1", 100);
lot.LotID = 1;
lot.CurrentOccupancy = 50;
mockLotData.Add(lot);
DateTime startDateTime = DateTime.Parse("12:00 AM");
DateTime endDateTime = DateTime.Parse("5:00 AM");
LotStatus lotStatus = new LotStatus("Weekday", startDateTime, endDateTime, 0, 1, 1);
lot.LotStatuses.Add(lotStatus);
lot = new Lot("200", "Test Lot 2", "Test Address 2", 200);
lot.LotID = 2;
lot.CurrentOccupancy = 100;
lotStatus = new LotStatus("Weekend", startDateTime, endDateTime, 0, 1, 1);
lot.LotStatuses.Add(lotStatus);
mockLotData.Add(lot);
lot = new Lot("300", "Test Lot 3", "Test Address 3", 300);
lot.LotID = 3;
lot.CurrentOccupancy = 100;
lotStatus = new LotStatus("Weekday", startDateTime, endDateTime, 0, 1, 1);
lot.LotStatuses.Add(lotStatus);
lotStatus = new LotStatus("Weekend", startDateTime, endDateTime, 0, 1, 1);
lot.LotStatuses.Add(lotStatus);
mockLotData.Add(lot);
lot = new Lot("400", "Test Lot 4", "Test Address 4", 400);
lot.LotID = 4;
lot.CurrentOccupancy = 300;
lotStatus = new LotStatus("Weekday", startDateTime, endDateTime, 0, 1, 1);
lot.LotStatuses.Add(lotStatus);
mockLotData.Add(lot);
return(mockLotData);
}
public static async Task InitializeAsync(IServiceProvider services)
{
ApplicationDbContext database
= services.GetRequiredService <ApplicationDbContext>();
//To add roles we need to create a RoleManager
RoleManager <IdentityRole> roleManager
= services.GetRequiredService <RoleManager <IdentityRole> >();
//To add app users, we need to create a UserManager object
UserManager <ApplicationUser> userManager = services.GetRequiredService <UserManager <ApplicationUser> >();
if (!database.Roles.Any())
{
IdentityRole role = new IdentityRole("WVUEmployee");
await roleManager.CreateAsync(role);
role = new IdentityRole("ParkingEmployee");
await roleManager.CreateAsync(role);
role = new IdentityRole("Visitor");
await roleManager.CreateAsync(role);
}
if (!database.Departments.Any())
{
Department department = new Department("MIS", "1601 University Ave, Morgantown, WV 26506");
database.Departments.Add(department);
database.SaveChanges();
department = new Department("Mechanical Engineering", "1306 Evansdale Dr, Morgantown, WV 26506");
database.Departments.Add(department);
database.SaveChanges();
department = new Department("Pediatrics", "1 Medical Center Dr, Morgantown, WV 26506");
database.Departments.Add(department);
database.SaveChanges();
department = new Department("WVU Parking Office", "Maiden Ln, Morgantown, WV 26506");
database.Departments.Add(department);
database.SaveChanges();
}
//Populate all the appusers together
if (!database.ApplicationUsers.Any())
{
Visitor visitor = new Visitor("Test", "Visitor1", "*****@*****.**", "3040000001", "TestVisitor1", "Mylan");
visitor.EmailConfirmed = true;
await userManager.CreateAsync(visitor);
await userManager.AddToRoleAsync(visitor, "Visitor");
WVUEmployee employee = new WVUEmployee("Test", "WVUEmployee1", "*****@*****.**", "3040000002", "TestWVUEmployee1", 1);
employee.EmailConfirmed = true;
await userManager.CreateAsync(employee);
await userManager.AddToRoleAsync(employee, "WVUEmployee");
employee = new WVUEmployee("Test", "WVUEmployee2", "*****@*****.**", "3040000003", "TestWVUEmployee2", 2);
employee.EmailConfirmed = true;
await userManager.CreateAsync(employee);
await userManager.AddToRoleAsync(employee, "WVUEmployee");
employee = new WVUEmployee("Test", "WVUEmployee3", "*****@*****.**", "3040000004", "TestWVUEmployee3", 3);
employee.EmailConfirmed = true;
await userManager.CreateAsync(employee);
await userManager.AddToRoleAsync(employee, "WVUEmployee");
WVUEmployee parkingEmployee = new WVUEmployee("Test", "ParkingEmployee1", "*****@*****.**", "3040000003", "TestParkingEmployee1", 4);
employee.EmailConfirmed = true;
await userManager.CreateAsync(parkingEmployee);
await userManager.AddToRoleAsync(parkingEmployee, "WVUEmployee");
await userManager.AddToRoleAsync(parkingEmployee, "ParkingEmployee");
}
//If you are populating each AppUser sub class seperately
if (database.WVUEmployees.Any())
{
}
if (!database.Lots.Any()) // only if no data or rows are in lots table
{
Lot lot = new Lot("1", "Art Museum Education Center",
"2 Fine Arts Dr, Morgantown, WV 26506", 140);
lot.CurrentOccupancy = 140;
database.Lots.Add(lot);
database.SaveChanges();
lot = new Lot("4", "Student Rec Center",
"2001 Rec Center Dr, Morgantown, WV 26506", 225);
database.Lots.Add(lot);
database.SaveChanges();
lot = new Lot("7", "College of B&E",
"600 University Ave, Morgantown, WV 26506", 150);
database.Lots.Add(lot);
database.SaveChanges();
lot = new Lot("10", "WVU Hospital",
"1 Medical Center Dr, Morgantown, WV 26506", 300);
database.Lots.Add(lot);
database.SaveChanges();
lot = new Lot("12", "WVU Urgent Care", "301 Suncrest Towne Centre Drive, Morgantown, WV 26505", 200);
database.Lots.Add(lot);
database.SaveChanges();
lot = new Lot("15", "WVU Medicine", "6040 University Town Centre Dr, Morgantown, WV 26501",
300);
lot.CurrentOccupancy = 250;
database.Lots.Add(lot);
database.SaveChanges();
}
if (!database.LotTypes.Any())
{
LotType lotType = new LotType("Short Term Paid Lot");
database.LotTypes.Add(lotType);
database.SaveChanges();
lotType = new LotType("Free");
database.LotTypes.Add(lotType);
database.SaveChanges();
lotType = new LotType("Permit");
database.LotTypes.Add(lotType);
database.SaveChanges();
}
if (!database.LotStatuses.Any())
{
CultureInfo cultureInfo = new CultureInfo("en-US");
DateTime startTime = DateTime.Parse("8:00 AM", cultureInfo, DateTimeStyles.NoCurrentDateDefault);
DateTime endTime = DateTime.Parse("4:00 PM", cultureInfo, DateTimeStyles.NoCurrentDateDefault);
//First object/row (weekday short term)
LotStatus lotStatus = new LotStatus("Weekday", startTime, endTime, 0.50, 1, 1);
database.LotStatuses.Add(lotStatus);
database.SaveChanges();
lotStatus = new LotStatus("Weekday", startTime, endTime, 0.50, 2, 1);
database.LotStatuses.Add(lotStatus);
database.SaveChanges();
lotStatus = new LotStatus("Weekend", startTime, endTime, 0.00, 2, 2);
database.LotStatuses.Add(lotStatus);
database.SaveChanges();
lotStatus = new LotStatus("Weekday", startTime, endTime, 0.00, 3, 3);
database.LotStatuses.Add(lotStatus);
database.SaveChanges();
startTime = DateTime.Parse("4:01 PM", cultureInfo, DateTimeStyles.NoCurrentDateDefault);
endTime = DateTime.Parse("7:59 AM", cultureInfo, DateTimeStyles.NoCurrentDateDefault);
//Second object/row (weekday free)
lotStatus = new LotStatus("Weekday", startTime, endTime, 0.00, 1, 2);
database.LotStatuses.Add(lotStatus);
database.SaveChanges();
lotStatus = new LotStatus("Weekday", startTime, endTime, 0.00, 2, 2);
database.LotStatuses.Add(lotStatus);
database.SaveChanges();
lotStatus = new LotStatus("Weekday", startTime, endTime, 0.00, 3, 2);
database.LotStatuses.Add(lotStatus);
database.SaveChanges();
}
if (!database.Permits.Any())
{
DateTime permitStartDate = new DateTime(2020, 1, 1);
DateTime permitEndDate = new DateTime(2020, 12, 31);
WVUEmployee parkingEmployee = database.WVUEmployees.Where(e => e.Email == "*****@*****.**").FirstOrDefault();
string parkingEmployeeID = parkingEmployee.Id;
WVUEmployee user = database.WVUEmployees.Where(e => e.Email == "*****@*****.**").FirstOrDefault();
string userID = user.Id;
Permit permit = new Permit(500.00, permitStartDate, permitEndDate, userID, parkingEmployeeID);
database.Permits.Add(permit);
database.SaveChanges();
user.PermitID = permit.PermitID;
database.WVUEmployees.Update(user);
database.SaveChanges();
//user = database.WVUEmployees.Where(e => e.Email == "*****@*****.**").FirstOrDefault();
//userID = user.Id;
//permit = new Permit(500.00, permitStartDate, permitEndDate, userID);
//database.Permits.Add(permit);
//database.SaveChanges();
//user.PermitID = permit.PermitID;
//database.WVUEmployees.Update(user);
//database.SaveChanges();
user = database.WVUEmployees.Where(e => e.Email == "*****@*****.**").FirstOrDefault();
userID = user.Id;
permit = new Permit(500.00, permitStartDate, permitEndDate, userID, parkingEmployeeID);
database.Permits.Add(permit);
database.SaveChanges();
user.PermitID = permit.PermitID;
database.WVUEmployees.Update(user);
database.SaveChanges();
//user = database.WVUEmployees.Where(e => e.Email == "*****@*****.**").FirstOrDefault();
//userID = user.Id;
//permit = new Permit(500.00, permitStartDate, permitEndDate, userID);
//database.Permits.Add(permit);
//database.SaveChanges();
//user.PermitID = permit.PermitID;
//database.WVUEmployees.Update(user);
//database.SaveChanges();
}
} //end method
public async Task <ICollection <Lot> > GetByStatus(LotStatus status)
{
return(await Entities.Where(l => l.Status.Equals(status)).ToListAsync());
}
public Task <ICollection <Lot> > GetByStatus(LotStatus status)
{
return(Repository.GetByStatus(status));
}