public static TypeOfStatusDTO MapTypeOfStatusDTO(TypeOfStatus typeOfStatus)
{
var config = new MapperConfiguration(cfg => cfg.CreateMap <TypeOfStatus, TypeOfStatusDTO>());
var mapper = new Mapper(config);
var typeOfStatusDto = mapper.Map <TypeOfStatusDTO>(typeOfStatus);
return(typeOfStatusDto);
}
//add db
protected override void Seed(TourAgencyContext db)
{
// add role
var adminRole = new IdentityRole()
{
Name = "admin"
};
var managerRole = new IdentityRole()
{
Name = "manager"
};
var customerRole = new IdentityRole()
{
Name = "customer"
};
db.Roles.Add(adminRole);
db.Roles.Add(managerRole);
db.Roles.Add(customerRole);
// add admin and manager
var adminUser = new IdentityUser
{
UserName = "******",
Email = "*****@*****.**",
PasswordHash = new PasswordHasher().HashPassword("qwe123"),
SecurityStamp = Guid.NewGuid().ToString(),
};
var managerUser = new IdentityUser
{
UserName = "******",
Email = "*****@*****.**",
PasswordHash = new PasswordHasher().HashPassword("asd123"),
SecurityStamp = Guid.NewGuid().ToString(),
};
var customerUser1 = new IdentityUser {
UserName = "******", Email = "*****@*****.**", PasswordHash = new PasswordHasher().HashPassword("zxc123"), SecurityStamp = Guid.NewGuid().ToString(),
};
var customerUser2 = new IdentityUser {
UserName = "******", Email = "*****@*****.**", PasswordHash = new PasswordHasher().HashPassword("zxc123"), SecurityStamp = Guid.NewGuid().ToString(),
};
var customerUser3 = new IdentityUser {
UserName = "******", Email = "*****@*****.**", PasswordHash = new PasswordHasher().HashPassword("zxc123"), SecurityStamp = Guid.NewGuid().ToString(),
};
var customerUser4 = new IdentityUser {
UserName = "******", Email = "*****@*****.**", PasswordHash = new PasswordHasher().HashPassword("zxc123"), SecurityStamp = Guid.NewGuid().ToString(),
};
var customerUser5 = new IdentityUser {
UserName = "******", Email = "*****@*****.**", PasswordHash = new PasswordHasher().HashPassword("zxc123"), SecurityStamp = Guid.NewGuid().ToString(),
};
var customerUser6 = new IdentityUser {
UserName = "******", Email = "*****@*****.**", PasswordHash = new PasswordHasher().HashPassword("zxc123"), SecurityStamp = Guid.NewGuid().ToString(),
};
var customerUser7 = new IdentityUser {
UserName = "******", Email = "*****@*****.**", PasswordHash = new PasswordHasher().HashPassword("zxc123"), SecurityStamp = Guid.NewGuid().ToString(),
};
var customerUser8 = new IdentityUser {
UserName = "******", Email = "*****@*****.**", PasswordHash = new PasswordHasher().HashPassword("zxc123"), SecurityStamp = Guid.NewGuid().ToString(),
};
var customerUser9 = new IdentityUser {
UserName = "******", Email = "*****@*****.**", PasswordHash = new PasswordHasher().HashPassword("zxc123"), SecurityStamp = Guid.NewGuid().ToString(),
};
db.Users.Add(adminUser);
db.Users.Add(managerUser);
db.Users.Add(customerUser1);
db.Users.Add(customerUser2);
db.Users.Add(customerUser3);
db.Users.Add(customerUser4);
db.Users.Add(customerUser5);
db.Users.Add(customerUser6);
db.Users.Add(customerUser7);
db.Users.Add(customerUser8);
db.Users.Add(customerUser9);
// add roles for staff
var adminUserRole = new IdentityUserRole
{
UserId = adminUser.Id,
RoleId = adminRole.Id,
};
var managerUserRole = new IdentityUserRole
{
UserId = managerUser.Id,
RoleId = managerRole.Id,
};
var customer1UserRole = new IdentityUserRole {
UserId = customerUser1.Id, RoleId = customerRole.Id,
};
var customer2UserRole = new IdentityUserRole {
UserId = customerUser2.Id, RoleId = customerRole.Id,
};
var customer3UserRole = new IdentityUserRole {
UserId = customerUser3.Id, RoleId = customerRole.Id,
};
var customer4UserRole = new IdentityUserRole {
UserId = customerUser4.Id, RoleId = customerRole.Id,
};
var customer5UserRole = new IdentityUserRole {
UserId = customerUser5.Id, RoleId = customerRole.Id,
};
var customer6UserRole = new IdentityUserRole {
UserId = customerUser6.Id, RoleId = customerRole.Id,
};
var customer7UserRole = new IdentityUserRole {
UserId = customerUser7.Id, RoleId = customerRole.Id,
};
var customer8UserRole = new IdentityUserRole {
UserId = customerUser8.Id, RoleId = customerRole.Id,
};
var customer9UserRole = new IdentityUserRole {
UserId = customerUser9.Id, RoleId = customerRole.Id,
};
db.SaveChanges();
db.Database.ExecuteSqlCommand($"INSERT INTO AspNetUserRoles (UserId,RoleId) VALUES ('{adminUserRole.UserId}','{adminUserRole.RoleId}')");
db.Database.ExecuteSqlCommand($"INSERT INTO AspNetUserRoles (UserId,RoleId) VALUES ('{managerUserRole.UserId}','{managerUserRole.RoleId}')");
db.Database.ExecuteSqlCommand($"INSERT INTO AspNetUserRoles (UserId,RoleId) VALUES ('{customer1UserRole.UserId}','{customer1UserRole.RoleId}')");
db.Database.ExecuteSqlCommand($"INSERT INTO AspNetUserRoles (UserId,RoleId) VALUES ('{customer2UserRole.UserId}','{customer2UserRole.RoleId}')");
db.Database.ExecuteSqlCommand($"INSERT INTO AspNetUserRoles (UserId,RoleId) VALUES ('{customer3UserRole.UserId}','{customer3UserRole.RoleId}')");
db.Database.ExecuteSqlCommand($"INSERT INTO AspNetUserRoles (UserId,RoleId) VALUES ('{customer4UserRole.UserId}','{customer4UserRole.RoleId}')");
db.Database.ExecuteSqlCommand($"INSERT INTO AspNetUserRoles (UserId,RoleId) VALUES ('{customer5UserRole.UserId}','{customer5UserRole.RoleId}')");
db.Database.ExecuteSqlCommand($"INSERT INTO AspNetUserRoles (UserId,RoleId) VALUES ('{customer6UserRole.UserId}','{customer6UserRole.RoleId}')");
db.Database.ExecuteSqlCommand($"INSERT INTO AspNetUserRoles (UserId,RoleId) VALUES ('{customer7UserRole.UserId}','{customer7UserRole.RoleId}')");
db.Database.ExecuteSqlCommand($"INSERT INTO AspNetUserRoles (UserId,RoleId) VALUES ('{customer8UserRole.UserId}','{customer8UserRole.RoleId}')");
db.Database.ExecuteSqlCommand($"INSERT INTO AspNetUserRoles (UserId,RoleId) VALUES ('{customer9UserRole.UserId}','{customer9UserRole.RoleId}')");
db.SaveChanges();
var admin = new Administrator()
{
Id = 1,
Name = "Pavel",
Surname = "Pirogov",
UserId = adminUser.Id,
User = adminUser,
};
db.Administrators.Add(admin);
var manager = new Manager()
{
Id = 1,
Name = "Maxim",
Surname = "Grinyk",
UserId = managerUser.Id,
User = managerUser,
IsBlock = false
};
db.Managers.Add(manager);
var customer1 = new Customer()
{
Id = 1, Name = "Tobias", Surname = "Rogers", UserId = customerUser1.Id, User = customerUser1, IsBlock = false, Discount = 14, MaxDiscount = 50, StepDiscount = 2,
};
var customer2 = new Customer()
{
Id = 1, Name = "Harris", Surname = "Young", UserId = customerUser2.Id, User = customerUser2, IsBlock = false, Discount = 0, MaxDiscount = 50, StepDiscount = 5,
};
var customer3 = new Customer()
{
Id = 1, Name = "Salem", Surname = "Diaz", UserId = customerUser3.Id, User = customerUser3, IsBlock = false, Discount = 0, MaxDiscount = 50, StepDiscount = 5,
};
var customer4 = new Customer()
{
Id = 1, Name = "Zahir", Surname = "Hayes", UserId = customerUser4.Id, User = customerUser4, IsBlock = false, Discount = 0, MaxDiscount = 50, StepDiscount = 5,
};
var customer5 = new Customer()
{
Id = 1, Name = "Wolfgang", Surname = "Turner", UserId = customerUser5.Id, User = customerUser5, IsBlock = false, Discount = 0, MaxDiscount = 50, StepDiscount = 5,
};
var customer6 = new Customer()
{
Id = 1, Name = "Roman", Surname = "Patterson", UserId = customerUser6.Id, User = customerUser6, IsBlock = false, Discount = 0, MaxDiscount = 50, StepDiscount = 5,
};
var customer7 = new Customer()
{
Id = 1, Name = "Neil", Surname = "Thomas", UserId = customerUser7.Id, User = customerUser7, IsBlock = false, Discount = 0, MaxDiscount = 50, StepDiscount = 5,
};
var customer8 = new Customer()
{
Id = 1, Name = "Graham", Surname = "Ward", UserId = customerUser8.Id, User = customerUser8, IsBlock = false, Discount = 0, MaxDiscount = 50, StepDiscount = 5,
};
var customer9 = new Customer()
{
Id = 1, Name = "Jameson", Surname = "Hayes", UserId = customerUser9.Id, User = customerUser9, IsBlock = false, Discount = 0, MaxDiscount = 50, StepDiscount = 5,
};
db.Customers.Add(customer1);
db.Customers.Add(customer2);
db.Customers.Add(customer3);
db.Customers.Add(customer4);
db.Customers.Add(customer5);
db.Customers.Add(customer6);
db.Customers.Add(customer7);
db.Customers.Add(customer8);
db.Customers.Add(customer9);
db.SaveChanges();
var cityKyiv = new City()
{
Id = 1, NameCity = "Kyiv",
};
var cityVienna = new City()
{
Id = 2, NameCity = "Vienna",
};
var cityLondon = new City()
{
Id = 3, NameCity = "London",
};
var cityBudapest = new City()
{
Id = 4, NameCity = "Budapest",
};
var cityBerlin = new City()
{
Id = 5, NameCity = "Berlin",
};
var cityRome = new City()
{
Id = 6, NameCity = "Rome",
};
var cityMoscow = new City()
{
Id = 7, NameCity = "Moscow",
};
var cityStockholm = new City()
{
Id = 8, NameCity = "Stockholm",
};
db.Cities.Add(cityKyiv);
db.Cities.Add(cityVienna);
db.Cities.Add(cityLondon);
db.Cities.Add(cityBudapest);
db.Cities.Add(cityBerlin);
db.Cities.Add(cityRome);
db.Cities.Add(cityMoscow);
db.Cities.Add(cityStockholm);
var typeOfHotelHostel = new TypeOfHotel
{
Id = 1,
NumberOfStars = 4,
Type = "Hostel",
IsDelete = false,
};
var typeOfHotelBusiness = new TypeOfHotel
{
Id = 2,
NumberOfStars = 5,
Type = "Business",
IsDelete = false
};
var typeOfHotelBedandBreakfast = new TypeOfHotel
{
Id = 3,
NumberOfStars = 3,
Type = "Bed and Breakfast",
IsDelete = false
};
var typeOfHotelLodge = new TypeOfHotel
{
Id = 4,
NumberOfStars = 2,
Type = "Lodge",
IsDelete = false
};
db.TypeOfHotels.Add(typeOfHotelHostel);
db.TypeOfHotels.Add(typeOfHotelBusiness);
db.TypeOfHotels.Add(typeOfHotelBedandBreakfast);
db.TypeOfHotels.Add(typeOfHotelLodge);
var typeOfTourRelax = new TypeOfTour {
Id = 1, Type = "Relax"
};
var typeOfTourExcursion = new TypeOfTour {
Id = 2, Type = "Excursion"
};
var typeOfTourShopping = new TypeOfTour {
Id = 3, Type = "Shopping"
};
var typeOfTourSport = new TypeOfTour {
Id = 4, Type = "Sport"
};
db.TypeOfTours.Add(typeOfTourRelax);
db.TypeOfTours.Add(typeOfTourExcursion);
db.TypeOfTours.Add(typeOfTourShopping);
db.TypeOfTours.Add(typeOfTourSport);
var typeOfStatusRegistered = new TypeOfStatus()
{
Id = 1, Type = "Registered"
};
var typeOfStatusPaid = new TypeOfStatus()
{
Id = 2, Type = "Paid"
};
var typeOfStatusCanceled = new TypeOfStatus()
{
Id = 3, Type = "Canceled"
};
db.TypeOfStatuses.Add(typeOfStatusRegistered);
db.TypeOfStatuses.Add(typeOfStatusPaid);
db.TypeOfStatuses.Add(typeOfStatusCanceled);
var tour1 = new Tour()
{
Id = 1,
City = cityKyiv,
CityId = cityKyiv.Id,
Price = 2000,
IsHot = false,
StartOfTour = Convert.ToDateTime("04/05/2020"),
EndOfTour = Convert.ToDateTime("04/06/2020"),
MaxNumberOfPeople = 10,
TypeOfHotel = typeOfHotelHostel,
TypeOfHotelId = typeOfHotelHostel.Id,
TypeOfTour = typeOfTourRelax,
TypeOfTourId = typeOfTourRelax.Id,
IsDelete = false,
NumberOfOrders = 3,
ImagePath = "Kyiv.jpg"
};
var tour2 = new Tour()
{
Id = 2,
City = cityRome,
CityId = cityRome.Id,
Price = 4400,
IsHot = true,
StartOfTour = Convert.ToDateTime("18/05/2020"),
EndOfTour = Convert.ToDateTime("18/06/2020"),
MaxNumberOfPeople = 3,
TypeOfHotel = typeOfHotelBedandBreakfast,
TypeOfHotelId = typeOfHotelBedandBreakfast.Id,
TypeOfTour = typeOfTourShopping,
TypeOfTourId = typeOfTourShopping.Id,
IsDelete = false,
NumberOfOrders = 2,
ImagePath = "Rome.jpg"
};
var tour3 = new Tour()
{
Id = 3,
City = cityLondon,
CityId = cityLondon.Id,
Price = 3800,
IsHot = false,
StartOfTour = Convert.ToDateTime("12/05/2020"),
EndOfTour = Convert.ToDateTime("12/06/2020"),
MaxNumberOfPeople = 5,
TypeOfHotel = typeOfHotelLodge,
TypeOfHotelId = typeOfHotelLodge.Id,
TypeOfTour = typeOfTourExcursion,
TypeOfTourId = typeOfTourExcursion.Id,
IsDelete = false,
NumberOfOrders = 3,
ImagePath = "London.jpg"
};
var tour4 = new Tour()
{
Id = 4,
City = cityBerlin,
CityId = cityBerlin.Id,
Price = 8500,
IsHot = false,
StartOfTour = Convert.ToDateTime("04/07/2020"),
EndOfTour = Convert.ToDateTime("04/08/2020"),
MaxNumberOfPeople = 10,
TypeOfHotel = typeOfHotelHostel,
TypeOfHotelId = typeOfHotelHostel.Id,
TypeOfTour = typeOfTourRelax,
TypeOfTourId = typeOfTourRelax.Id,
IsDelete = false,
NumberOfOrders = 5,
ImagePath = "Berlin.jpg"
};
var tour5 = new Tour()
{
Id = 5,
City = cityMoscow,
CityId = cityMoscow.Id,
Price = 7200,
IsHot = true,
StartOfTour = Convert.ToDateTime("09/06/2020"),
EndOfTour = Convert.ToDateTime("10/06/2020"),
MaxNumberOfPeople = 7,
TypeOfHotel = typeOfHotelHostel,
TypeOfHotelId = typeOfHotelHostel.Id,
TypeOfTour = typeOfTourRelax,
TypeOfTourId = typeOfTourRelax.Id,
IsDelete = false,
NumberOfOrders = 3,
ImagePath = "Moscow.jpeg"
};
var tour6 = new Tour()
{
Id = 6,
City = cityStockholm,
CityId = cityStockholm.Id,
Price = 6300,
IsHot = false,
StartOfTour = Convert.ToDateTime("19/07/2020"),
EndOfTour = Convert.ToDateTime("27/07/2020"),
MaxNumberOfPeople = 3,
TypeOfHotel = typeOfHotelLodge,
TypeOfHotelId = typeOfHotelLodge.Id,
TypeOfTour = typeOfTourShopping,
TypeOfTourId = typeOfTourShopping.Id,
IsDelete = false,
NumberOfOrders = 2,
ImagePath = "Stockholm.jpg"
};
db.Tours.Add(tour1);
db.Tours.Add(tour2);
db.Tours.Add(tour3);
db.Tours.Add(tour4);
db.Tours.Add(tour5);
db.Tours.Add(tour6);
var tourCustomer1 = new TourCustomer()
{
Id = 1,
Customer = customer1,
CustomerId = customer1.Id,
Tour = tour1,
TourId = tour1.Id,
TypeOfStatus = typeOfStatusRegistered,
TypeOfStatusId = typeOfStatusRegistered.Id,
RealNumberOfPeople = 2,
RealPrice = 1800,
};
var tourCustomer2 = new TourCustomer()
{
Id = 2,
Customer = customer1,
CustomerId = customer1.Id,
Tour = tour4,
TourId = tour4.Id,
TypeOfStatus = typeOfStatusRegistered,
TypeOfStatusId = typeOfStatusRegistered.Id,
RealNumberOfPeople = 3,
RealPrice = 8000
};
db.TourCustomers.Add(tourCustomer1);
db.TourCustomers.Add(tourCustomer2);
db.SaveChanges();
}
