//Command Buy-Ticket <Customer ID> <Trip ID> <Price> <Seat> public static string Execute(string[] data) { var customerId = int.Parse(data[1]); var tripId = int.Parse(data[2]); var price = decimal.Parse(data[3]); var seat = int.Parse(data[4]); using (var db = new BusTicketsDbContext()) { Customer customer = db.Customers .Where(c => c.CustomerId == customerId) .Include(c => c.Ticket) .ThenInclude(t => t.Trip) .SingleOrDefault(); if (customer == null) { throw new ArgumentException("Invalid Customer Number!"); } Trip trip = db.Trips .Include(t => t.DestinationBusStation) .Include(t => t.OriginBusStation) .Include(t => t.BusCompany) .SingleOrDefault(t => t.TripId == tripId); if (trip == null) { throw new ArgumentException("Invalid Trip Number!"); } if (trip.Status == TripStatus.Cancelled) { throw new ArgumentException($"We apologize for this inconvenience but the trip " + Environment.NewLine + $"from {trip.OriginBusStation.BusStationName} " + Environment.NewLine + $"to {trip.DestinationBusStation.BusStationName} is cancelled"); } if (db.Tickets.Any(t => t.TripId == trip.TripId && t.Seat == seat)) { throw new ArgumentException("The requested seat is already reserved, please pick another one."); } Ticket ticket = new Ticket() { Trip = trip, Customer = customer, Price = price, Seat = seat, }; db.Tickets.Add(ticket); db.BankAccounts.SingleOrDefault(ba => ba.CustomerId == customer.CustomerId).Balance -= price; db.SaveChanges(); return($"Customer {customer.FirstName + " " + customer.LastName} bought ticket for trip {tripId} for {price} on seat {seat}"); } }
private static void ResetDatabase() { using (var db = new BusTicketsDbContext()) { db.Database.EnsureDeleted(); db.Database.EnsureCreated(); Seed(db); } }
//Command: Print-Info <Bus Station ID> public static string Execute(string[] data) { var busStationId = int.Parse(data[1]); using (var db = new BusTicketsDbContext()) { var busStation = db.BusStations.SingleOrDefault(bs => bs.BusStationId == busStationId); if (busStation == null) { throw new ArgumentException("There is no Bus Station with that Identification Number"); } var builder = new StringBuilder(); builder.AppendLine($"{busStation.BusStationName}, {busStation.Town}"); var tripsArriving = db.Trips.Where(t => t.DestinationBusStationId == busStationId).ToArray(); if (tripsArriving.Length > 0) { builder.AppendLine("Arrivals:"); foreach (var trip in tripsArriving) { builder.AppendLine($"From: {db.BusStations.SingleOrDefault(bs => bs.BusStationId == trip.OriginBusStationId).BusStationName} | Arrive at: {trip.ArrivalTime.Hour}:{trip.ArrivalTime.Minute} | Status: {trip.Status.ToString()}"); } } else { builder.AppendLine("There is no Arriving buses today!"); } var tripsDeparturing = db.Trips.Where(t => t.OriginBusStationId == busStationId).ToArray(); if (tripsDeparturing.Length > 0) { builder.AppendLine("Depatures:"); foreach (var trip in tripsDeparturing) { builder.AppendLine($"To: {db.BusStations.SingleOrDefault(bs => bs.BusStationId == trip.DestinationBusStationId).BusStationName} | Depart at: {trip.DepartureTime.Hour}:{trip.DepartureTime.Hour} | Status: {trip.Status.ToString()}"); } } else { builder.AppendLine("There is no Departuring buses today!"); } return(builder.ToString().Trim()); } }
//Command: Print-Reviews <Bus Company ID> public static string Execute(string[] data) { var companyId = int.Parse(data[1]); using (var db = new BusTicketsDbContext()) { var company = db.BusCompanies.SingleOrDefault(c => c.BusCompanyId == companyId); var reviews = db.Reviews.Where(r => r.BusCompanyId == company.BusCompanyId).ToArray(); var builder = new StringBuilder(); foreach (var r in reviews) { builder.AppendLine($"{r.ReviewId} {r.Grade} {r.DateAndTimeOfPublishing.Date} " + $"{db.Customers.SingleOrDefault(c => c.CustomerId == r.CustomerId).FirstName + " " + db.Customers.SingleOrDefault(c => c.CustomerId == r.CustomerId).LastName} {r.Content}"); } return(builder.ToString().Trim()); } }
//Command: Publish-Review <Customer ID> <Grade> <Bus Company Name> <Content> public static string Execute(string[] data) { var customerId = int.Parse(data[1]); var grade = double.Parse(data[2]); var companyName = data[3]; var content = string.Join(' ', data.Skip(4)); using (var db = new BusTicketsDbContext()) { var customer = db.Customers.SingleOrDefault(c => c.CustomerId == customerId); if (customer == null) { throw new ArgumentException("Invalid Customer Number!"); } var company = db.BusCompanies.SingleOrDefault(bc => bc.BusCompanyName == companyName); if (company == null) { throw new ArgumentException("Invalid Company Name"); } var review = new Review() { CustomerId = customer.CustomerId, BusCompanyId = company.BusCompanyId, Grade = grade, Content = content }; db.Reviews.Add(review); db.SaveChanges(); return($"Customer {customer.FirstName + " " + customer.LastName} published review for company {company.BusCompanyName}"); } }
//Command: change-trip-status <Trip Id> <New Status> public static string Execute(string[] data) { var tripId = int.Parse(data[1]); var newStatus = data[2].ToLower(); using (var db = new BusTicketsDbContext()) { var newTripStatus = new TripStatus(); //change-trip-status 2 delayed switch (newStatus) { case "departed": newTripStatus = TripStatus.Departed; break; case "arrived": newTripStatus = TripStatus.Arrived; break; case "delayed": newTripStatus = TripStatus.Delayed; break; case "cancalled": newTripStatus = TripStatus.Cancelled; break; default: throw new ArgumentException("Wrong status input."); } var trip = db.Trips .Where(t => t.TripId == tripId) .Include(t => t.DestinationBusStation) .ThenInclude(dbs => dbs.Town) .Include(t => t.OriginBusStation) .ThenInclude(obs => obs.Town) .SingleOrDefault(); string oldTripStatus = trip.Status.ToString(); if (trip == null) { throw new ArgumentException("Invalid Trip Number!"); } if (trip.Status == newTripStatus) { throw new ArgumentException($"The status of this trip is already {newTripStatus.ToString()}"); } var builder = new StringBuilder(); db.Trips.SingleOrDefault(t => t.TripId == trip.TripId).Status = newTripStatus; db.SaveChanges(); builder.AppendLine($"Trip from {trip.OriginBusStation.Town.TownName} to {trip.DestinationBusStation.Town.TownName} on {trip.DepartureTime} Status changed from { oldTripStatus } to { newTripStatus.ToString() }"); if (newTripStatus == TripStatus.Arrived) { var passengersCount = db.Tickets.Where(t => t.TripId == trip.TripId).Count(); var arrivedTrip = new ArrivedTrip() { DateTimeArrived = trip.ArrivalTime, OriginArrivedId = trip.OriginBusStation.BusStationId, OriginArrived = trip.OriginBusStation, DestinationArrivedId = trip.DestinationBusStation.BusStationId, DestinationArrived = trip.DestinationBusStation, PassangersCounted = passengersCount }; db.ArrivedTrips.Add(arrivedTrip); db.SaveChanges(); builder.AppendLine($"On {arrivedTrip.DateTimeArrived.Date} - {arrivedTrip.PassangersCounted} passengers arrived at {arrivedTrip.DestinationArrived.BusStationName} " + $"from {arrivedTrip.OriginArrived.BusStationName}"); } return(builder.ToString().Trim()); } }
private static void Seed(BusTicketsDbContext db) { using (db) { var towns = new List <Town>() { new Town { TownName = "Бургас", Country = "Bulgaria" }, new Town { TownName = "София", Country = "Bulgaria" }, new Town { TownName = "Варна", Country = "Bulgaria" }, new Town { TownName = "Плодив", Country = "Bulgaria" }, new Town { TownName = "Стара Загора", Country = "Bulgaria" }, new Town { TownName = "Русе", Country = "Bulgaria" }, new Town { TownName = "Каспичан", Country = "Bulgaria" }, }; db.Towns.AddRange(towns); db.SaveChanges(); var busStations = new List <BusStation>() { new BusStation { BusStationName = "Автогара Север Бургас", TownId = 1 }, //1 new BusStation { BusStationName = "Автогара Юг Бургас", TownId = 1 }, //2 new BusStation { BusStationName = "Централна автобусна спирка Бургас", TownId = 1 }, //3 new BusStation { BusStationName = "Частна автогара София", TownId = 2 }, //4 new BusStation { BusStationName = "Частна автогара Пловдив", TownId = 4 }, //5 new BusStation { BusStationName = "Централна автогара София", TownId = 2 }, //6 new BusStation { BusStationName = "Автогара Подуяне", TownId = 2 }, //7 new BusStation { BusStationName = "Частна автогара Варна", TownId = 3 }, //8 new BusStation { BusStationName = "Централна автогара Варна", TownId = 3 }, //9 new BusStation { BusStationName = "Централна автогара Пловдив", TownId = 4 }, //10 new BusStation { BusStationName = "Централна автогара Стара Загора", TownId = 5 }, //11 new BusStation { BusStationName = "Централна автогара Русе", TownId = 6 }, //12 new BusStation { BusStationName = "Централна автогара Каспичан", TownId = 7 }, //13 }; db.BusStations.AddRange(busStations); db.SaveChanges(); var busCompanies = new List <BusCompany>() { new BusCompany { BusCompanyName = "TransTriumph", Nationality = "Bulgaria", Rating = 1.10 }, new BusCompany { BusCompanyName = "Group", Nationality = "Bulgaria", Rating = 1.10 }, new BusCompany { BusCompanyName = "ArdaKor", Nationality = "Bulgraria", Rating = 1.10 }, new BusCompany { BusCompanyName = "Autotrance 99 LTD", Nationality = "Bulgaria", Rating = 1.10 }, new BusCompany { BusCompanyName = "Dary Travel", Nationality = "Bulgaria", Rating = 1.10 }, new BusCompany { BusCompanyName = "Racic Eurobus BG", Nationality = "Bulgaria", Rating = 1.10 }, new BusCompany { BusCompanyName = "Agi 99", Nationality = "Bulgaria", Rating = 1.10 }, }; db.BusCompanies.AddRange(busCompanies); db.SaveChanges(); var customers = new List <Customer>() { new Customer { FirstName = "Иларион", LastName = "Макариополски", DateOfBirth = DateTime.Parse("2012/09/06"), Gender = Gender.Male, HomeTownId = 1 }, new Customer { FirstName = "Петко", LastName = "Страшника", DateOfBirth = DateTime.Parse("1948/01/06"), Gender = Gender.Male, HomeTownId = 2 }, new Customer { FirstName = "Jhon", LastName = "Lennon", DateOfBirth = DateTime.Parse("1980/12/08"), Gender = Gender.Male, HomeTownId = 5 }, new Customer { FirstName = "Георги", LastName = "Георгиев", DateOfBirth = DateTime.Parse("1988/03/18"), Gender = Gender.Male, HomeTownId = 1 }, new Customer { FirstName = "Иван", LastName = "Георгиев", DateOfBirth = DateTime.Parse("1988/12/06"), Gender = Gender.Male, HomeTownId = 3 }, new Customer { FirstName = "Митко", LastName = "Бомбата", DateOfBirth = DateTime.Parse("1990/04/22"), Gender = Gender.Male, HomeTownId = 6 }, new Customer { FirstName = "Коста", LastName = "Лазаров", DateOfBirth = DateTime.Parse("1984/05/03"), Gender = Gender.Male, HomeTownId = 1 }, new Customer { FirstName = "Росен", LastName = "Плевнелиев", DateOfBirth = DateTime.Parse("1964/05/14"), Gender = Gender.Male, HomeTownId = 2 }, new Customer { FirstName = "Светлин", LastName = "Насков", DateOfBirth = DateTime.Parse("1980/01/07"), Gender = Gender.Male, HomeTownId = 2 }, new Customer { FirstName = "Георги", LastName = "Иванов", DateOfBirth = DateTime.Parse("1940/07/02"), Gender = Gender.Male, HomeTownId = 2 }, new Customer { FirstName = "Богдана", LastName = "Карадочева", DateOfBirth = DateTime.Parse("1949/07/19"), Gender = Gender.Female, HomeTownId = 2 }, new Customer { FirstName = "Деси", LastName = "Банова", DateOfBirth = DateTime.Parse("1980/02/15"), Gender = Gender.Female, HomeTownId = 2 }, new Customer { FirstName = "Nithiwan", LastName = "Mason", DateOfBirth = DateTime.Parse("1985/10/29"), Gender = Gender.Female, HomeTownId = 3 }, new Customer { FirstName = "Сашка", LastName = "Васева", DateOfBirth = DateTime.Parse("1966/10/12"), Gender = Gender.Notspecified, HomeTownId = 7 }, new Customer { FirstName = "Мила", LastName = "Ризванович", DateOfBirth = DateTime.Parse("1985/04/13"), Gender = Gender.Female, HomeTownId = 1 }, new Customer { FirstName = "Мила", LastName = "Кунис", DateOfBirth = DateTime.Parse("1983/08/14"), Gender = Gender.Female, HomeTownId = 5 }, new Customer { FirstName = "Jagermeister", LastName = "Nightfury", DateOfBirth = DateTime.Parse("2016/09/23"), Gender = Gender.Female, HomeTownId = 1 }, new Customer { FirstName = "Вин", LastName = "Дизел", DateOfBirth = DateTime.Parse("1967/07/18"), Gender = Gender.Male, HomeTownId = 6 }, new Customer { FirstName = "Юри", LastName = "Гагарин", DateOfBirth = DateTime.Parse("1934/03/09"), Gender = Gender.Male, HomeTownId = 1 }, new Customer { FirstName = "Баба", LastName = "Вихронрав", DateOfBirth = DateTime.Parse("1944/02/16"), Gender = Gender.Female, HomeTownId = 1 }, new Customer { FirstName = "Николай", LastName = "Райков", DateOfBirth = DateTime.Parse("1983/06/12"), Gender = Gender.Male, HomeTownId = 2 }, new Customer { FirstName = "Наско", LastName = "Ментата", DateOfBirth = DateTime.Parse("1947/01/17"), Gender = Gender.Notspecified, HomeTownId = 7 }, new Customer { FirstName = "Ники", LastName = "Пънчев", DateOfBirth = DateTime.Parse("1972/12/18"), Gender = Gender.Male, HomeTownId = 2 }, new Customer { FirstName = "Дейвид", LastName = "Душевни", DateOfBirth = DateTime.Parse("1971/11/19"), Gender = Gender.Male, HomeTownId = 4 }, new Customer { FirstName = "Милена", LastName = "Николова", DateOfBirth = DateTime.Parse("1986/10/20"), Gender = Gender.Female, HomeTownId = 1 }, new Customer { FirstName = "Светла", LastName = "Петкова", DateOfBirth = DateTime.Parse("1988/09/21"), Gender = Gender.Female, HomeTownId = 3 }, new Customer { FirstName = "Нина", LastName = "Йолкина", DateOfBirth = DateTime.Parse("1987/08/22"), Gender = Gender.Female, HomeTownId = 6 }, new Customer { FirstName = "Мария", LastName = "Витанова", DateOfBirth = DateTime.Parse("1987/07/23"), Gender = Gender.Female, HomeTownId = 2 }, new Customer { FirstName = "Силвия", LastName = "Димитрова", DateOfBirth = DateTime.Parse("1986/06/24"), Gender = Gender.Female, HomeTownId = 5 }, new Customer { FirstName = "Елена", LastName = "Петрова", DateOfBirth = DateTime.Parse("1975/05/25"), Gender = Gender.Female, HomeTownId = 2 }, new Customer { FirstName = "Милена", LastName = "Анчева", DateOfBirth = DateTime.Parse("1978/04/26"), Gender = Gender.Female, HomeTownId = 3 }, new Customer { FirstName = "Калина", LastName = "Атанасова", DateOfBirth = DateTime.Parse("1997/03/27"), Gender = Gender.Female, HomeTownId = 2 }, new Customer { FirstName = "Роза", LastName = "Тодорова", DateOfBirth = DateTime.Parse("1987/02/28"), Gender = Gender.Female, HomeTownId = 1 }, new Customer { FirstName = "Carolina", LastName = "Torres", DateOfBirth = DateTime.Parse("1990/01/31"), Gender = Gender.Female, HomeTownId = 4 }, }; db.Customers.AddRange(customers); db.SaveChanges(); var bankAccounts = new List <BankAccount>() { new BankAccount { CustomerId = 1, Balance = 345.67m }, new BankAccount { CustomerId = 2, Balance = 3045.63m }, new BankAccount { CustomerId = 3, Balance = 3405.61m }, new BankAccount { CustomerId = 4, Balance = 3450.77m }, new BankAccount { CustomerId = 5, Balance = 960.21m }, new BankAccount { CustomerId = 6, Balance = 489.15m }, new BankAccount { CustomerId = 7, Balance = 189.65m }, new BankAccount { CustomerId = 8, Balance = 72.70m }, new BankAccount { CustomerId = 9, Balance = 83.90m }, new BankAccount { CustomerId = 10, Balance = 80.32m }, new BankAccount { CustomerId = 11, Balance = 901.46m }, new BankAccount { CustomerId = 12, Balance = 483.84m }, new BankAccount { CustomerId = 13, Balance = 76.38m }, new BankAccount { CustomerId = 14, Balance = 51.91m }, new BankAccount { CustomerId = 15, Balance = 423.53m }, new BankAccount { CustomerId = 16, Balance = 489.80m }, new BankAccount { CustomerId = 17, Balance = 6586.27m }, new BankAccount { CustomerId = 18, Balance = 354.72m }, new BankAccount { CustomerId = 19, Balance = 186.61m }, new BankAccount { CustomerId = 20, Balance = 48.34m }, new BankAccount { CustomerId = 21, Balance = 68.92m }, new BankAccount { CustomerId = 22, Balance = 489.46m }, new BankAccount { CustomerId = 23, Balance = 13.46m }, new BankAccount { CustomerId = 24, Balance = 105.64m }, new BankAccount { CustomerId = 25, Balance = 489.37m }, new BankAccount { CustomerId = 26, Balance = 156.73m }, new BankAccount { CustomerId = 27, Balance = 48.79m }, new BankAccount { CustomerId = 28, Balance = 1.69m }, new BankAccount { CustomerId = 29, Balance = 48.96m }, new BankAccount { CustomerId = 30, Balance = 489.07m }, new BankAccount { CustomerId = 31, Balance = 1001.09m }, new BankAccount { CustomerId = 32, Balance = 153.64m }, new BankAccount { CustomerId = 33, Balance = 345.08m }, new BankAccount { CustomerId = 34, Balance = 4658.24m } }; db.BankAccounts.AddRange(bankAccounts); db.SaveChanges(); var reviews = new List <Review>() { new Review { BusCompanyId = 1, CustomerId = 1, Content = "Lorem Ipsum е елементарен примерен текст, " + "използван в печатарската и типографската индустрия. " + "в наши дни във софтуер за печатни издания като Aldus PageMaker, " + "който включва различни версии на Lorem Ipsum.", Grade = 5.5 }, new Review { BusCompanyId = 2, CustomerId = 2, Content = "Lorem Ipsum е елементарен примерен текст, " + "използван в печатарската и типографската индустрия. ", Grade = 4.5 }, new Review { BusCompanyId = 3, CustomerId = 3, Content = "Lorem Ipsum е елементарен примерен текст, " + "на 20ти век със издаването на Letraset листи, съдържащи Lorem Ipsum пасажи, популярен е и " + "който включва различни версии на Lorem Ipsum.", Grade = 5.3 }, new Review { BusCompanyId = 4, CustomerId = 4, Content = "Lorem Ipsum е елементарен примерен текст, " + "използван в печатарската и типографската индустрия. ", Grade = 9.5 }, new Review { BusCompanyId = 5, CustomerId = 5, Content = "Lorem Ipsum е елементарен примерен текст, " + "на 20ти век със издаването на Letraset листи, съдържащи Lorem Ipsum пасажи, популярен е и " + "в наши дни във софтуер за печатни издания като Aldus PageMaker, " + "който включва различни версии на Lorem Ipsum.", Grade = 5.1 }, new Review { BusCompanyId = 6, CustomerId = 6, Content = "Lorem Ipsum е елементарен примерен текст, " + "в наши дни във софтуер за печатни издания като Aldus PageMaker, " + "който включва различни версии на Lorem Ipsum.", Grade = 10 }, new Review { BusCompanyId = 7, CustomerId = 7, Content = "Lorem Ipsum е елементарен примерен текст, " + "използван в печатарската и типографската индустрия. " + "който включва различни версии на Lorem Ipsum.", Grade = 1 }, }; db.Reviews.AddRange(reviews); db.SaveChanges(); var trips = new List <Trip>() { new Trip { BusCompanyId = 1, OriginBusStationId = 1, DestinationBusStationId = 6, Status = TripStatus.Delayed, DepartureTime = DateTime.Parse("2017/11/25 11:40"), ArrivalTime = DateTime.Parse("2017/11/25 15:10") }, new Trip { BusCompanyId = 2, OriginBusStationId = 12, DestinationBusStationId = 7, Status = TripStatus.Cancelled, DepartureTime = DateTime.Parse("2017/11/24 08:35"), ArrivalTime = DateTime.Parse("2017/11/24 13:05") }, new Trip { BusCompanyId = 3, OriginBusStationId = 11, DestinationBusStationId = 10, Status = TripStatus.Cancelled, DepartureTime = DateTime.Parse("2017/11/25 18:10"), ArrivalTime = DateTime.Parse("2017/11/25 20:05") }, new Trip { BusCompanyId = 4, OriginBusStationId = 13, DestinationBusStationId = 4, Status = TripStatus.Arrived, DepartureTime = DateTime.Parse("2017/11/25 11:40"), ArrivalTime = DateTime.Parse("2017/11/25 15:10") }, new Trip { BusCompanyId = 5, OriginBusStationId = 8, DestinationBusStationId = 2, Status = TripStatus.Arrived, DepartureTime = DateTime.Parse("2017/11/21 12:00"), ArrivalTime = DateTime.Parse("2017/11/21 14:20") }, }; db.Trips.AddRange(trips); db.SaveChanges(); var tickets = new List <Ticket>() { new Ticket { TripId = 1, CustomerId = 1, Price = 27.60m, Seat = 1 }, new Ticket { TripId = 1, CustomerId = 2, Price = 27.60m, Seat = 1 }, new Ticket { TripId = 1, CustomerId = 3, Price = 27.60m, Seat = 1 }, new Ticket { TripId = 1, CustomerId = 4, Price = 27.60m, Seat = 1 }, new Ticket { TripId = 1, CustomerId = 5, Price = 27.60m, Seat = 1 }, new Ticket { TripId = 2, CustomerId = 6, Price = 34.12m, Seat = 1 }, new Ticket { TripId = 2, CustomerId = 7, Price = 34.12m, Seat = 1 }, new Ticket { TripId = 2, CustomerId = 8, Price = 34.12m, Seat = 1 }, new Ticket { TripId = 2, CustomerId = 9, Price = 34.12m, Seat = 1 }, new Ticket { TripId = 3, CustomerId = 10, Price = 16.50m, Seat = 1 }, new Ticket { TripId = 3, CustomerId = 11, Price = 16.50m, Seat = 1 }, new Ticket { TripId = 3, CustomerId = 12, Price = 16.50m, Seat = 1 }, new Ticket { TripId = 3, CustomerId = 13, Price = 16.50m, Seat = 1 }, new Ticket { TripId = 4, CustomerId = 14, Price = 12.65m, Seat = 1 }, new Ticket { TripId = 4, CustomerId = 15, Price = 12.65m, Seat = 1 }, new Ticket { TripId = 4, CustomerId = 16, Price = 12.65m, Seat = 1 }, new Ticket { TripId = 4, CustomerId = 17, Price = 12.65m, Seat = 1 }, new Ticket { TripId = 5, CustomerId = 18, Price = 14.00m, Seat = 1 }, new Ticket { TripId = 5, CustomerId = 19, Price = 14.00m, Seat = 1 }, new Ticket { TripId = 5, CustomerId = 20, Price = 14.00m, Seat = 1 }, new Ticket { TripId = 5, CustomerId = 21, Price = 14.00m, Seat = 1 }, new Ticket { TripId = 1, CustomerId = 22, Price = 27.60m, Seat = 1 }, new Ticket { TripId = 2, CustomerId = 23, Price = 34.12m, Seat = 1 }, new Ticket { TripId = 3, CustomerId = 24, Price = 16.50m, Seat = 1 }, new Ticket { TripId = 4, CustomerId = 25, Price = 12.65m, Seat = 1 }, new Ticket { TripId = 5, CustomerId = 26, Price = 14.00m, Seat = 1 }, new Ticket { TripId = 5, CustomerId = 27, Price = 14.00m, Seat = 1 }, }; db.Tickets.AddRange(tickets); db.SaveChanges(); } }