public Passenger SavePassenger(Passenger passenger) { var existingPassenger = context.Passengers.FirstOrDefault(x => x.FirstName == passenger.FirstName && x.LastName == passenger.LastName && x.IdentificationTypeId == passenger.IdentificationTypeId && x.IdentificationNumber == passenger.IdentificationNumber && x.UserId == passenger.UserId); if (existingPassenger == null) { context.Passengers.Add(passenger); context.SaveChanges(); return(passenger); // после сохранения заполнится PassengerId } return(existingPassenger); }
static void Main(string[] args) { List <Train> trains = new List <Train>() { new Train() { Departure = City.Aktau, DepartureTime = new DateTime(2019, 05, 17, 17, 15, 0), Airrival = City.Astana, ArrivalTime = new DateTime(2019, 05, 18, 12, 15, 0), FreePlaces = 10 }, new Train() { Departure = City.Astana, DepartureTime = new DateTime(2019, 06, 18, 12, 15, 0), Airrival = City.Karaganda, ArrivalTime = new DateTime(2019, 06, 18, 14, 15, 0), FreePlaces = 10 }, new Train() { Departure = City.Astana, DepartureTime = new DateTime(2019, 06, 18, 17, 15, 0), Airrival = City.Karaganda, ArrivalTime = new DateTime(2019, 06, 18, 20, 15, 0), FreePlaces = 10 }, new Train() { Departure = City.Aktau, DepartureTime = new DateTime(2019, 10, 25, 17, 15, 0), Airrival = City.Karaganda, ArrivalTime = new DateTime(2019, 10, 26, 12, 15, 0), FreePlaces = 10 }, new Train() { Departure = City.Kokshetau, DepartureTime = new DateTime(2019, 05, 17, 17, 15, 0), Airrival = City.Almaty, ArrivalTime = new DateTime(2019, 05, 18, 12, 15, 0), FreePlaces = 10 }, new Train() { Departure = City.Aktau, DepartureTime = new DateTime(2019, 05, 17, 17, 15, 0), Airrival = City.Karaganda, ArrivalTime = new DateTime(2019, 05, 20, 13, 15, 0), FreePlaces = 10 }, new Train() { Departure = City.Karaganda, DepartureTime = new DateTime(2019, 05, 17, 20, 15, 0), Airrival = City.Almaty, ArrivalTime = new DateTime(2019, 05, 20, 16, 15, 0), FreePlaces = 10 }, new Train() { Departure = City.Aktau, DepartureTime = new DateTime(2019, 05, 17, 17, 15, 0), Airrival = City.Astana, ArrivalTime = new DateTime(2019, 05, 18, 12, 15, 0), FreePlaces = 10 }, new Train() { Departure = City.Almaty, DepartureTime = new DateTime(2019, 05, 17, 19, 15, 0), Airrival = City.Astana, ArrivalTime = new DateTime(2019, 05, 18, 12, 15, 0), FreePlaces = 10 }, }; using (var context = new RailwayContext()) { context.Trains.AddRange(trains); context.SaveChanges(); } }
public void SavePassenger(PassengerDto dto) { var passenger = _railwayContext.Passengers.FirstOrDefault(x => x.Id == dto.Id); if (passenger != null) { Mapper.Map(dto, passenger); } else { passenger = Mapper.Map <Passenger>(dto); _railwayContext.Passengers.Add(passenger); } _railwayContext.SaveChanges(); }
private void btnSubmit_Click(object sender, EventArgs e) { var train = possibleTrains[lstTickets.SelectedIndex]; var passenger = new Passenger(); Ticket ticket; if (txtPassengerName.Text.Length != 0) { passenger.FullName = txtPassengerName.Text; } else { MessageBox.Show("You have to enter your name"); } if (lstTickets.SelectedIndex >= 0) { ticket = new Ticket { //Train = train, TrainId = train.Id, //Passenger = passenger, PassengerId = passenger.Id, }; try { passenger.Tickets.Add(ticket); } catch { passenger.Tickets = new List <Ticket>(); passenger.Tickets.Add(ticket); } using (var context = new RailwayContext()) { context.Tickets.Add(ticket); context.Passengers.Add(passenger); var result = context.Trains.SingleOrDefault(t => t.Id == train.Id); context.SaveChanges(); MessageBox.Show("Your order has been admitted"); } } else { MessageBox.Show("You have to choose a ticket"); } }
public async Task Register([FromBody] RegisterModel model) { var email = model.Email; var password = model.Password; var confirmPassword = model.ConfirmPassword; if (!EmailValidator.IsValid(email)) { Response.StatusCode = 400; await Response.WriteAsync("Email is in invalid format"); return; } if (db.Users.SingleOrDefault(u => u.Email == email) != null) { Response.StatusCode = 400; await Response.WriteAsync("Email is already in database"); return; } if (password != confirmPassword) { Response.StatusCode = 400; await Response.WriteAsync("Confirm password is wrong"); return; } db.Users.Add(new User() { Email = email, Password = password }); db.SaveChanges(); Response.StatusCode = 200; await Response.WriteAsync("Register succeded!"); }