public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
{
using (IServiceScope serviceScope = app.ApplicationServices.GetService <IServiceScopeFactory>().CreateScope())
{
TourAgencyDbContext context = serviceScope.ServiceProvider.GetRequiredService <TourAgencyDbContext>();
context.Database.Migrate();
if (context.Countries.ToList().Count == 0)
{
FillDatabaseTables(context);
}
}
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
app.UseHsts();
}
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseCookiePolicy();
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=Home}/{action=Index}");
});
}
public List <Type> getAll()
{
List <Type> types;
using (var dbContext = new TourAgencyDbContext()) {
types = dbContext.types.ToList();
}
return(types);
}
public List <Role> getAll()
{
List <Role> roles;
using (var dbContext = new TourAgencyDbContext()) {
roles = dbContext.roles.ToList();
}
return(roles);
}
public User delete(User user)
{
EntityEntry <User> removedUser;
using (var dbContext = new TourAgencyDbContext()) {
removedUser = dbContext.users.Remove(user);
dbContext.SaveChanges();
}
return(removedUser.Entity);
}
public Role update(Role role)
{
EntityEntry <Role> updatedRole;
using (var dbContext = new TourAgencyDbContext()) {
updatedRole = dbContext.roles.Update(role);
dbContext.SaveChanges();
}
return(updatedRole.Entity);
}
public Role create(Role newRole)
{
EntityEntry <Role> role;
using (var dbContext = new TourAgencyDbContext()) {
role = dbContext.roles.Add(newRole);
dbContext.SaveChanges();
}
return(role.Entity);
}
public Type delete(Type type)
{
EntityEntry <Type> removedType;
using (var dbContext = new TourAgencyDbContext()) {
removedType = dbContext.types.Remove(type);
dbContext.SaveChanges();
}
return(removedType.Entity);
}
public Type update(Type type)
{
EntityEntry <Type> updatedType;
using (var dbContext = new TourAgencyDbContext()) {
updatedType = dbContext.types.Update(type);
dbContext.SaveChanges();
}
return(updatedType.Entity);
}
public Type create(Type newType)
{
EntityEntry <Type> type;
using (var dbContext = new TourAgencyDbContext()) {
type = dbContext.types.Add(newType);
dbContext.SaveChanges();
}
return(type.Entity);
}
public Role delete(Role role)
{
EntityEntry <Role> removedRole;
using (var dbContext = new TourAgencyDbContext()) {
removedRole = dbContext.roles.Remove(role);
dbContext.SaveChanges();
}
return(removedRole.Entity);
}
public Role findByName(string name)
{
Role role;
using (var dbContext = new TourAgencyDbContext()) {
role = dbContext.roles
.ToList()
.Find(r => r.name.Equals(name));
}
return(role);
}
public Role findById(long id)
{
Role role;
using (var dbContext = new TourAgencyDbContext()) {
role = dbContext.roles
.ToList()
.Find(r => r.roleId == id);
}
return(role);
}
public User update(User user)
{
EntityEntry <User> updatedUser;
using (var dbContext = new TourAgencyDbContext()) {
dbContext.roles.Attach(user.role);
updatedUser = dbContext.users.Update(user);
dbContext.SaveChanges();
}
return(updatedUser.Entity);
}
public Type findByName(string name)
{
Type Type;
using (var dbContext = new TourAgencyDbContext()) {
Type = dbContext.types
.ToList()
.Find(t => t.name.Equals(name));
}
return(Type);
}
public User create(User newUser)
{
EntityEntry <User> user;
using (var dbContext = new TourAgencyDbContext()) {
dbContext.roles.Attach(newUser.role);
user = dbContext.users.Add(newUser);
dbContext.SaveChanges();
}
return(user.Entity);
}
public List <User> getAll()
{
List <User> users;
using (var dbContext = new TourAgencyDbContext()) {
users = dbContext.users
.Include(u => u.role)
.ToList();
}
return(users);
}
public Type findById(long id)
{
Type type;
using (var dbContext = new TourAgencyDbContext()) {
type = dbContext.types
.ToList()
.Find(t => t.typeId == id);
}
return(type);
}
public User findById(long id)
{
User user;
using (var dbContext = new TourAgencyDbContext()) {
user = dbContext.users
.Include(u => u.role)
.ToList()
.Find(u => u.userId == id);
}
return(user);
}
public List <Tour> getAll()
{
List <Tour> tours;
using (var dbContext = new TourAgencyDbContext()) {
tours = dbContext.tours
.Include(t => t.type)
.Include(t => t.user)
.ToList();
}
return(tours);
}
public Tour delete(Tour tour)
{
EntityEntry <Tour> removedTour;
using (var dbContext = new TourAgencyDbContext()) {
dbContext.types.Attach(tour.type);
dbContext.users.Attach(tour.user);
removedTour = dbContext.tours.Remove(tour);
dbContext.SaveChanges();
}
return(removedTour.Entity);
}
public Tour update(Tour tour)
{
EntityEntry <Tour> updatedTour;
using (var dbContext = new TourAgencyDbContext()) {
dbContext.types.Attach(tour.type);
dbContext.users.Attach(tour.user);
updatedTour = dbContext.tours.Update(tour);
dbContext.SaveChanges();
}
return(updatedTour.Entity);
}
public Tour create(Tour newTour)
{
EntityEntry <Tour> tour;
using (var dbContext = new TourAgencyDbContext()) {
dbContext.types.Attach(newTour.type);
dbContext.users.Attach(newTour.user);
tour = dbContext.tours.Add(newTour);
dbContext.SaveChanges();
}
return(tour.Entity);
}
public Order delete(Order order)
{
EntityEntry <Order> removedOrder;
using (var dbContext = new TourAgencyDbContext()) {
dbContext.users.Attach(order.user);
dbContext.tours.Attach(order.tour);
removedOrder = dbContext.orders.Remove(order);
dbContext.SaveChanges();
}
return(removedOrder.Entity);
}
public Order update(Order order)
{
EntityEntry <Order> updatedOrder;
using (var dbContext = new TourAgencyDbContext()) {
dbContext.users.Attach(order.user);
dbContext.tours.Attach(order.tour);
updatedOrder = dbContext.orders.Update(order);
dbContext.SaveChanges();
}
return(updatedOrder.Entity);
}
public Order create(Order newOrder)
{
EntityEntry <Order> order;
using (var dbContext = new TourAgencyDbContext()) {
dbContext.users.Attach(newOrder.user);
dbContext.tours.Attach(newOrder.tour);
order = dbContext.orders.Add(newOrder);
dbContext.SaveChanges();
}
return(order.Entity);
}
public List <Order> getAll()
{
List <Order> orders;
using (var dbContext = new TourAgencyDbContext()) {
orders = dbContext.orders
.Include(o => o.user)
.Include(o => o.tour)
.ToList();
}
return(orders);
}
public User findByEmail(string email)
{
User user;
using (var dbContext = new TourAgencyDbContext()) {
user = dbContext.users
.Include(u => u.role)
.ToList()
.Find(u => u.email.Equals(email));
}
return(user);
}
public List <Tour> findByUser(User user)
{
List <Tour> tours;
using (var dbContext = new TourAgencyDbContext()) {
tours = dbContext.tours
.Include(t => t.type)
.Include(t => t.user)
.ToList()
.FindAll(t => t.user.userId.Equals(user.userId));
}
return(tours);
}
public List <Tour> findByHot(bool isHot)
{
List <Tour> tours;
using (var dbContext = new TourAgencyDbContext()) {
tours = dbContext.tours
.Include(t => t.type)
.Include(t => t.user)
.ToList()
.FindAll(t => t.isHot.Equals(isHot));
}
return(tours);
}
public Tour findById(long id)
{
Tour tour;
using (var dbContext = new TourAgencyDbContext()) {
tour = dbContext.tours
.Include(t => t.type)
.Include(t => t.user)
.ToList()
.Find(t => t.tourId == id);
}
return(tour);
}
