public UsersController(IConfiguration configuration, TripPlannerDBContext context, IMapper mapper) { _context = context; _configuration = configuration; _mapper = mapper; _users = context.Users.Include(x => x.UserRoles).Include(x => x.Trips); }
public TripsController(TripPlannerDBContext context, IMapper mapper) { _context = context; _mapper = mapper; }
public static void Initialize(TripPlannerDBContext context) { context.Database.EnsureCreated(); var defaultRole = new Role { Name = "AppUser", Description = "Application Users" }; if (!context.Roles.Any()) { context.Roles.Add(defaultRole); context.SaveChanges(); } if (!context.Users.Any()) { var defaultUser = new User { Email = "*****@*****.**", Fname = "Nitin", Lname = "Rastogi", IsActive = true, Pwd = "Test123" }; context.Users.Add(defaultUser); context.SaveChanges(); context.UserRoles.Add(new UserRole { UserId = defaultUser.Id, RoleId = defaultRole.Id }); context.SaveChanges(); } if (!context.Trips.Any()) { Trip defaultTrip = new Trip { Name = "Road Trip to East Coast", Detail = "Road trip covering Charlotte to Orlando", StartDate = DateTime.Now.AddMonths(1), CreatedById = 1 }; context.Trips.Add(defaultTrip); context.SaveChanges(); Stay defaultStay = new Stay { Name = "Stay in Country Inn", Detail = "Country Inn in Charlotte" }; context.Stays.Add(defaultStay); context.SaveChanges(); defaultTrip.StayId = defaultStay.Id; context.SaveChanges(); Address address1 = new Address { Name = "Hotel Address", Address1 = "2012 San Jones Rd", Address2 = "", City = "Charlotte", State = "NC", Zip = "125487", TripId = defaultTrip.Id }; context.Addresses.Add(address1); context.SaveChanges(); Address address2 = new Address { Name = "Second Hotel Address", Address1 = "2014 San Jones Rd", Address2 = "", City = "Charlotte", State = "NC", Zip = "125487", TripId = defaultTrip.Id }; context.Addresses.Add(address2); context.SaveChanges(); WebLink link1 = new WebLink { Name = "Hotel Address", Link = "WWW.Hotel_name1.com", TripId = defaultTrip.Id }; context.WebLinks.Add(link1); context.SaveChanges(); WebLink link2 = new WebLink { Name = "Hotel Address", Link = "WWW.Hotel_name2.com", TripId = defaultTrip.Id }; context.WebLinks.Add(link2); context.SaveChanges(); } }