public static void Initialize(HotelContext context)
{
context.Database.EnsureCreated();
// Look for any customers.
if (context.Customers.Any())
{
return; // DB has been seeded
}
//Customers
var customers = new Customer[]
{
new Customer {
CustomerTitle = "Ing.", CustomerForenames = "Alejandro", CustomerSurnames = "Garcia Cortes",
CustomerDOB = DateTime.Parse("1995-03-11"), CustomerAddressStreet = "Monterrey 24", CustomerAddressTown = "Zacatecas",
CustomerAddressCounty = "Guadalupe", CustomerAddressPostalCode = "98615", CustomerHomePhone = "492 926 5614",
CustomerWorkPhone = null, CustomerMobilePhone = "492 650 8190", CustomerEmail = "*****@*****.**"
},
new Customer {
CustomerTitle = "Lic.", CustomerForenames = "Diana", CustomerSurnames = "Escareño Luna",
CustomerDOB = DateTime.Parse("1993-11-20"), CustomerAddressStreet = "Fuentes 51", CustomerAddressTown = "Aguascalientes",
CustomerAddressCounty = "Aguascalientes", CustomerAddressPostalCode = "97995", CustomerHomePhone = "449 443 8096",
CustomerWorkPhone = "449 162 9831", CustomerMobilePhone = "449 210 8716", CustomerEmail = "*****@*****.**"
},
new Customer {
CustomerTitle = "Ing.", CustomerForenames = "Carlos", CustomerSurnames = "Gonzalez Beltran",
CustomerDOB = DateTime.Parse("1980-01-10"), CustomerAddressStreet = "Gardenias 14", CustomerAddressTown = "Zacatecas",
CustomerAddressCounty = "Fresnillo", CustomerAddressPostalCode = "96005", CustomerHomePhone = "493 102 6176",
CustomerWorkPhone = null, CustomerMobilePhone = "493 110 7685", CustomerEmail = "*****@*****.**"
},
new Customer {
CustomerTitle = "Dr.", CustomerForenames = "Celina", CustomerSurnames = "Reyes Delgado",
CustomerDOB = DateTime.Parse("1987-08-12"), CustomerAddressStreet = "12Octubre 56", CustomerAddressTown = "Zacatecas",
CustomerAddressCounty = "Guadalupe", CustomerAddressPostalCode = "98618", CustomerHomePhone = "492 187 7726",
CustomerWorkPhone = "492 901 7165", CustomerMobilePhone = "492 173 7862", CustomerEmail = null
}
};
foreach (Customer ia in customers)
{
context.Customers.Add(ia);
}
context.SaveChanges();
//Guest
var guests = new Guest[]
{
new Guest {
GuestTitle = "Ing.", GuestForenames = "Alejandro", GuestSurnames = "Garcia Cortes", GuestDOB = DateTime.Parse("1995-03-11"),
GuestAddressStreet = "Monterrey 24", GuestAddressTown = "Zacatecas", GuestAddressCounty = "Guadalupe", GuestAddressPostalCode = "98615",
GuestContactPhone = "492 650 8190"
},
new Guest {
GuestTitle = "Sra.", GuestForenames = "Martha", GuestSurnames = "Escareño Perez", GuestDOB = DateTime.Parse("1991-06-01"),
GuestAddressStreet = "Gonzales Ortega 113", GuestAddressTown = "Zacatecas", GuestAddressCounty = "Guadalupe", GuestAddressPostalCode = "98256",
GuestContactPhone = "492 662 5410"
},
new Guest {
GuestTitle = "Sr.", GuestForenames = "Ernesto", GuestSurnames = "Baez Beltran", GuestDOB = DateTime.Parse("1979-12-28"),
GuestAddressStreet = "Condesa 23", GuestAddressTown = "Zacatecas", GuestAddressCounty = "Fresnillo", GuestAddressPostalCode = "96700",
GuestContactPhone = "493 675 1273"
},
new Guest {
GuestTitle = "Dr.", GuestForenames = "Celina", GuestSurnames = "Reyes Delgado", GuestDOB = DateTime.Parse("1987-08-12"),
GuestAddressStreet = "12Octubre 56", GuestAddressTown = "Zacatecas", GuestAddressCounty = "Guadalupe", GuestAddressPostalCode = "98618",
GuestContactPhone = "492 173 7862"
}
};
foreach (Guest ib in guests)
{
context.Guests.Add(ib);
}
context.SaveChanges();
//Booking
var bookings = new Booking[]
{
new Booking {
DateBookingMade = DateTime.Parse("2019-10-01"), TimeBookingMade = DateTime.Parse("11:02:13"),
BookedStartDate = DateTime.Parse("2019-10-11"), BookedEndDate = DateTime.Parse("2019-10-21"), TotalPaymentDueDate = DateTime.Parse("2019-11-11"),
TotalPaymentDueAmount = 300, TotalPaymentMadeOn = DateTime.Parse("2019-10-30"), BookingComments = null,
CustomerID = customers.Single(c => c.CustomerForenames == "Alejandro").CustomerID
},
new Booking {
DateBookingMade = DateTime.Parse("2019-12-22"), TimeBookingMade = DateTime.Parse("09:12:43"),
BookedStartDate = DateTime.Parse("2019-12-25"), BookedEndDate = DateTime.Parse("2020-01-07"), TotalPaymentDueDate = DateTime.Parse("2020-01-25"),
TotalPaymentDueAmount = 0, TotalPaymentMadeOn = DateTime.Parse("2019-12-22"), BookingComments = "La reservacion se pago el dia que fue realizada",
CustomerID = customers.Single(c => c.CustomerForenames == "Diana").CustomerID
},
new Booking {
DateBookingMade = DateTime.Parse("2020-02-14"), TimeBookingMade = DateTime.Parse("08:32:13"),
BookedStartDate = DateTime.Parse("2020-03-03"), BookedEndDate = DateTime.Parse("2020-03-15"), TotalPaymentDueDate = DateTime.Parse("2020-04-03"),
TotalPaymentDueAmount = 700, TotalPaymentMadeOn = DateTime.Parse("2020-03-03"), BookingComments = "La reservacion se pago el dia que finalizo",
CustomerID = customers.Single(c => c.CustomerForenames == "Carlos").CustomerID
},
new Booking {
DateBookingMade = DateTime.Parse("2020-04-23"), TimeBookingMade = DateTime.Parse("12:47:53"),
BookedStartDate = DateTime.Parse("2020-04-30"), BookedEndDate = DateTime.Parse("2020-05-08"), TotalPaymentDueDate = DateTime.Parse("2020-05-30"),
TotalPaymentDueAmount = 500, TotalPaymentMadeOn = DateTime.Parse("2020-05-13"), BookingComments = null,
CustomerID = customers.Single(c => c.CustomerForenames == "Celina").CustomerID
}
};
foreach (Booking ic in bookings)
{
context.Bookings.Add(ic);
}
context.SaveChanges();
//RoomType
var roomtypes = new RoomType[]
{
new RoomType {
roomType = roomType.Individual
},
new RoomType {
roomType = roomType.Doble
},
new RoomType {
roomType = roomType.Cuadruple
},
new RoomType {
roomType = roomType.JuniorSuite
},
new RoomType {
roomType = roomType.Suite
},
new RoomType {
roomType = roomType.GranSuite
}
};
foreach (RoomType id in roomtypes)
{
context.RoomTypes.Add(id);
}
context.SaveChanges();
//RoomBand
var roombands = new RoomBand[]
{
new RoomBand {
BandDesc = "A"
},
new RoomBand {
BandDesc = "AA"
},
new RoomBand {
BandDesc = "AAA"
},
new RoomBand {
BandDesc = "AAAA"
},
new RoomBand {
BandDesc = "AAAAA"
}
};
foreach (RoomBand ie in roombands)
{
context.RoomBands.Add(ie);
}
context.SaveChanges();
//RoomPrice
var roomprices = new RoomPrice[]
{
new RoomPrice {
roomPrice = 500
},
new RoomPrice {
roomPrice = 1000
},
new RoomPrice {
roomPrice = 1800
},
new RoomPrice {
roomPrice = 2000
},
new RoomPrice {
roomPrice = 2400
}
};
foreach (RoomPrice ig in roomprices)
{
context.RoomPrices.Add(ig);
}
context.SaveChanges();
//Room
var rooms = new Room[]
{
new Room {
Floor = "2", AdditionalNotes = "Habitacion: Individual - Precio: $500 por dia",
RoomTypeID = roomtypes.Single(c => c.roomType == roomType.Individual).RoomTypeID,
RoomBandID = roombands.Single(i => i.BandDesc == "A").RoomBandID,
RoomPriceID = roomprices.Single(s => s.roomPrice == 500).RoomPriceID
},
new Room {
Floor = "3", AdditionalNotes = "Habitacion: Doble - Precio: $1000 por dia",
RoomTypeID = roomtypes.Single(c => c.roomType == roomType.Doble).RoomTypeID,
RoomBandID = roombands.Single(i => i.BandDesc == "AA").RoomBandID,
RoomPriceID = roomprices.Single(s => s.roomPrice == 1000).RoomPriceID
},
new Room {
Floor = "4", AdditionalNotes = "Habitacion: Cuadruple - Precio: $1800 por dia",
RoomTypeID = roomtypes.Single(c => c.roomType == roomType.Cuadruple).RoomTypeID,
RoomBandID = roombands.Single(i => i.BandDesc == "AAAA").RoomBandID,
RoomPriceID = roomprices.Single(s => s.roomPrice == 1800).RoomPriceID
},
new Room {
Floor = "6", AdditionalNotes = "Habitacion: Suite - Precio: $2400 por dia",
RoomTypeID = roomtypes.Single(c => c.roomType == roomType.Suite).RoomTypeID,
RoomBandID = roombands.Single(i => i.BandDesc == "AAAAA").RoomBandID,
RoomPriceID = roomprices.Single(s => s.roomPrice == 2400).RoomPriceID
}
};
foreach (Room ih in rooms)
{
context.Rooms.Add(ih);
}
context.SaveChanges();
//BookingRoom
var bookingsrooms = new BookingRoom[]
{
new BookingRoom {
BookingID = bookings.Single(c => c.DateBookingMade == DateTime.Parse("2019-10-01")).BookingID,
RoomID = rooms.Single(i => i.Floor == "2").RoomID,
GuestID = guests.Single(s => s.GuestForenames == "Alejandro").GuestID
},
new BookingRoom {
BookingID = bookings.Single(c => c.DateBookingMade == DateTime.Parse("2019-12-22")).BookingID,
RoomID = rooms.Single(i => i.Floor == "3").RoomID,
GuestID = guests.Single(s => s.GuestForenames == "Martha").GuestID
},
new BookingRoom {
BookingID = bookings.Single(c => c.DateBookingMade == DateTime.Parse("2020-02-14")).BookingID,
RoomID = rooms.Single(i => i.Floor == "4").RoomID,
GuestID = guests.Single(s => s.GuestForenames == "Ernesto").GuestID
},
new BookingRoom {
BookingID = bookings.Single(c => c.DateBookingMade == DateTime.Parse("2020-04-23")).BookingID,
RoomID = rooms.Single(i => i.Floor == "6").RoomID,
GuestID = guests.Single(s => s.GuestForenames == "Celina").GuestID
}
};
foreach (BookingRoom i in bookingsrooms)
{
context.BookingsRooms.Add(i);
}
context.SaveChanges();
foreach (BookingRoom ix in bookingsrooms)
{
var bookingroomInDataBase = context.BookingsRooms.Where(
z =>
z.Booking.BookingID == ix.BookingID &&
z.Room.RoomID == ix.RoomID &&
z.Guest.GuestID == ix.GuestID).SingleOrDefault();
if (bookingroomInDataBase == null)
{
context.BookingsRooms.Add(ix);
}
}
context.SaveChanges();
//PaymentMethod
var paymentmethods = new PaymentMethod[]
{
new PaymentMethod {
paymentMethod = "Efectivo"
},
new PaymentMethod {
paymentMethod = "Tarjeta de Credito o Debito"
},
new PaymentMethod {
paymentMethod = "Transferencia Bancaria"
},
new PaymentMethod {
paymentMethod = "Paypal"
}
};
foreach (PaymentMethod ip in paymentmethods)
{
context.PaymentMethods.Add(ip);
}
context.SaveChanges();
//Payment
var payments = new Payment[]
{
new Payment {
PaymentAmount = 6000, PaymentComments = "Pago saldado totalmente",
BookingID = bookings.Single(c => c.DateBookingMade == DateTime.Parse("2019-10-01")).BookingID,
CustomerID = customers.Single(i => i.CustomerForenames == "Alejandro").CustomerID,
PaymentMethodID = paymentmethods.Single(s => s.paymentMethod == "Efectivo").PaymentMethodID
},
new Payment {
PaymentAmount = 5000, PaymentComments = "Pago saldado totalmente",
BookingID = bookings.Single(c => c.DateBookingMade == DateTime.Parse("2019-12-22")).BookingID,
CustomerID = customers.Single(i => i.CustomerForenames == "Diana").CustomerID,
PaymentMethodID = paymentmethods.Single(s => s.paymentMethod == "Transferencia Bancaria").PaymentMethodID
},
new Payment {
PaymentAmount = 10000, PaymentComments = "Pago saldado parcialmente",
BookingID = bookings.Single(c => c.DateBookingMade == DateTime.Parse("2020-02-14")).BookingID,
CustomerID = customers.Single(i => i.CustomerForenames == "Carlos").CustomerID,
PaymentMethodID = paymentmethods.Single(s => s.paymentMethod == "Efectivo").PaymentMethodID
},
new Payment {
PaymentAmount = 6000, PaymentComments = "Pago saldado totalmente",
BookingID = bookings.Single(c => c.DateBookingMade == DateTime.Parse("2020-04-23")).BookingID,
CustomerID = customers.Single(i => i.CustomerForenames == "Celina").CustomerID,
PaymentMethodID = paymentmethods.Single(s => s.paymentMethod == "Paypal").PaymentMethodID
}
};
foreach (Payment iq in payments)
{
context.Payments.Add(iq);
}
context.SaveChanges();
//FacilitieList
var facilitielists = new FacilitieList[]
{
new FacilitieList {
FacilityDesc = "(1)Cama individual - (1)TV - Telefono - Refrigerador - Microondas - Internet - Cafetera - Otros muebles"
},
new FacilitieList {
FacilityDesc = "(2)Cama individual - (1)TV - Telefono - Refrigerador - Microondas - Internet - Cafetera - Plancha - Otros muebles"
},
new FacilitieList {
FacilityDesc = "(4)Cama individual - (2)TV - Telefono - Refrigerador - Microondas - Internet - Cafetera - Plancha - Otros muebles"
},
new FacilitieList {
FacilityDesc = "(2)Cama matrimonial - (2)TV - Telefono - (1)Computadora - Refrigerador - Microondas - Internet - Cafetera - Plancha - Jacuzzi - Otros muebles"
},
new FacilitieList {
FacilityDesc = "(2)Cama matrimonial - (1)TV - Telefono - (1)Computadora- Refrigerador - Microondas - Internet - Cafetera - Plancha - Otros muebles"
},
new FacilitieList {
FacilityDesc = "(2)Cama king-size - (2)TV - Telefono - (2)Computadora - Refrigerador - Microondas - Internet - Cafetera - Plancha, Jacuzzi - Alberca - Otros muebles"
}
};
foreach (FacilitieList io in facilitielists)
{
context.FacilitieLists.Add(io);
}
context.SaveChanges();
//RoomFacilities
var roomsfacilities = new RoomFacilities[]
{
new RoomFacilities {
FacilityDetails = "Incluye servicios basicos",
RoomID = rooms.Single(c => c.Floor == "2").RoomID,
FacilityID = facilitielists.Single(s => s.FacilityDesc == "(1)Cama individual - (1)TV - Telefono - Refrigerador - Microondas - Internet - Cafetera - Otros muebles").FacilityID,
},
new RoomFacilities {
FacilityDetails = "Incluye servicios basicos",
RoomID = rooms.Single(c => c.Floor == "3").RoomID,
FacilityID = facilitielists.Single(s => s.FacilityDesc == "(2)Cama individual - (1)TV - Telefono - Refrigerador - Microondas - Internet - Cafetera - Plancha - Otros muebles").FacilityID,
},
new RoomFacilities {
FacilityDetails = "Incluye servicios basicos + extra",
RoomID = rooms.Single(c => c.Floor == "4").RoomID,
FacilityID = facilitielists.Single(s => s.FacilityDesc == "(4)Cama individual - (2)TV - Telefono - Refrigerador - Microondas - Internet - Cafetera - Plancha - Otros muebles").FacilityID,
},
new RoomFacilities {
FacilityDetails = "Incluye servicios basicos + extra",
RoomID = rooms.Single(c => c.Floor == "6").RoomID,
FacilityID = facilitielists.Single(s => s.FacilityDesc == "(2)Cama matrimonial - (2)TV - Telefono - (1)Computadora - Refrigerador - Microondas - Internet - Cafetera - Plancha - Jacuzzi - Otros muebles").FacilityID
}
};
foreach (RoomFacilities im in roomsfacilities)
{
context.RoomsFacilities.Add(im);
}
context.SaveChanges();
foreach (RoomFacilities ir in roomsfacilities)
{
var roomfacilitiesInDataBase = context.RoomsFacilities.Where(
w =>
w.Room.RoomID == ir.RoomID &&
w.FacilitieList.FacilityID == ir.FacilityID).SingleOrDefault();
if (roomfacilitiesInDataBase == null)
{
context.RoomsFacilities.Add(ir);
}
}
context.SaveChanges();
}
public static void Initialize(Context context)
{
context.Database.EnsureCreated();
// Look for any Customers.
if (context.Customers.Any())
{
return; // DB has been seeded
}
// Customers
var customers = new Customer[]
{
new Customer {
CustomerID = 100,
CustomerTitle = "Standard",
CustomerForenames = "Hernandez",
CustomerSurnames = "Pedro",
CustomerDOB = DateTime.Parse("1992-09-01"),
CustomerAddressStreet = "Calle 1",
CustomerAddressTown = "Zacatecas",
CustomerAddressCountry = "Mexico",
CustomerAddressPostalCode = "98000",
CustomerHomePhone = "4928896558",
CustomerWorkPhone = "4927796251",
CustomerMobilPhone = "4988898521",
CustomerEmail = "*****@*****.**"
}
};
foreach (Customer s in customers)
{
context.Customers.Add(s);
}
context.SaveChanges();
// Booking *
var bookings = new Booking[]
{
new Booking {
BookingID = 10,
CustomerID = customers.Single(c => c.CustomerSurnames == "Pedro").CustomerID,
DateBookingMade = DateTime.Parse("2020-09-01"),
TimeBookingMade = DateTime.Parse("2020-09-01"),
BookedStartDate = DateTime.Parse("2020-09-02"),
BookedEndDate = DateTime.Parse("2020-09-06"),
TotalPaymentDueDate = DateTime.Parse("2020-09-06"),
TotalPaymentDueAmount = 2500,
TotalPaymentMadeOn = DateTime.Parse("2020-09-06"),
BookingComments = "Reservación correcta"
}
};
foreach (Booking i in bookings)
{
context.Bookings.Add(i);
}
context.SaveChanges();
// FacilitieList
var facilitieLists = new FacilitieList[]
{
new FacilitieList {
FacilityID = 1,
FacilityDesc = "Jacuzzi"
}
};
foreach (FacilitieList i in facilitieLists)
{
context.FacilitieLists.Add(i);
}
context.SaveChanges();
// PaymentMethod
var paymentMethods = new PaymentMethod[]
{
new PaymentMethod {
PaymentMethodID = 1,
PaymentMethodDesc = "Debit Card"
}
};
foreach (PaymentMethod i in paymentMethods)
{
context.PaymentMethods.Add(i);
}
context.SaveChanges();
// Payment
var payments = new Payment[]
{
new Payment {
PaymentID = 1,
BookingID = bookings.Single(c => c.BookingID == 10).BookingID,
CustomerID = customers.Single(c => c.CustomerID == 100).CustomerID, //PEdro
PaymentMethodID = paymentMethods.Single(p => p.PaymentMethodID == 1).PaymentMethodID,
PaymentAmount = 5000,
PaymentComments = "Todo en orden"
}
};
foreach (Payment i in payments)
{
context.Payments.Add(i);
}
context.SaveChanges();
// Guests
var guests = new Guest[]
{
new Guest {
GuestID = 123,
GuestTitle = "Teacher",
GuestForenames = "Perez",
GuestSurnames = "Pancho",
GuestDOB = DateTime.Parse("1996-09-01"),
GuestAddressStreet = "Calle primavera 5",
GuestAddressTown = "Zacatecas",
GuestAddressCountry = "Mexico",
GuestAddressPostalCode = "98600",
GuestContactPhone = "1651254305"
}
};
foreach (Guest i in guests)
{
context.Guests.Add(i);
}
context.SaveChanges();
// RoomType
var roomtypes = new RoomType[]
{
new RoomType {
RoomTypeID = 1,
RoomTypeDesc = "Suite 5 stars"
}
};
foreach (RoomType i in roomtypes)
{
context.RoomTypes.Add(i);
}
context.SaveChanges();
// RoomBand
var roomBands = new RoomBand[]
{
new RoomBand {
RoombandID = 1,
BandDesc = "5 beds"
}
};
foreach (RoomBand i in roomBands)
{
context.RoomBands.Add(i);
}
context.SaveChanges();
// RoomPrice
var roomPrices = new RoomPrice[]
{
new RoomPrice {
RoomPriceID = 1,
RoomPriceDesc = 5000
},
new RoomPrice {
RoomPriceID = 2,
RoomPriceDesc = 2500
}
};
foreach (RoomPrice i in roomPrices)
{
context.RoomPrices.Add(i);
}
context.SaveChanges();
// Rooms *
var rooms = new Room[]
{
new Room {
RoomID = 502,
RoomTypeID = roomtypes.Single(c => c.RoomTypeID == 1).RoomTypeID,
RoomBandID = roomBands.Single(i => i.RoombandID == 1).RoombandID,
RoomPriceID = roomPrices.Single(r => r.RoomPriceID == 2).RoomPriceID,
Floor = "5th Floor",
AdditionalNotes = "Excellent View"
}
};
foreach (Room i in rooms)
{
context.Rooms.Add(i);
}
context.SaveChanges();
// RoomFacility
var roomFacilities = new RoomFacility[]
{
new RoomFacility {
RoomID = rooms.Single(c => c.RoomID == 502).RoomID,
FacilityID = facilitieLists.Single(c => c.FacilityID == 1).FacilityID,
FacilityDetails = "Realizado con exito",
}
};
foreach (RoomFacility i in roomFacilities)
{
context.RoomFacilities.Add(i);
}
context.SaveChanges();
//BookingRoom
var bookingRooms = new BookingRoom[]
{
new BookingRoom {
BookingID = bookings.Single(c => c.BookingID == 10).BookingID,
RoomID = rooms.Single(c => c.RoomID == 502).RoomID,
GuestID = guests.Single(c => c.GuestID == 123).GuestID
}
};
foreach (BookingRoom i in bookingRooms)
{
context.BookingRooms.Add(i);
}
context.SaveChanges();
}