private void accept_Click(object sender, RoutedEventArgs e) { if (lastname.Text == "" && firstname.Text == "" && middlename.Text == "" && phonenumber.Text == "" && orderday.Text == "" && numberorder.Text == "" && status.Text == "") { MessageBox.Show("Введите все данные"); } else { AirportSHIAEntities air = new AirportSHIAEntities(); int clients = air.Client. Where(w => w.LastName == lastname.Text && w.FirstName == firstname.Text && w.MiddleName == middlename.Text && w.PhoneNumber == phonenumber.Text). Select(s => s.idClient). FirstOrDefault(); OrderTIcket newuser = new OrderTIcket() { idClient = clients, idUserSystem = usersys.id, idFlightTicket = orderconnetctor.id, Dateorder = orderday.Text, StatusOrder = status.Text, NumberOrder = numberorder.Text, idcustomers = 1 }; air.OrderTIcket.Add(newuser); air.SaveChanges(); } }
private void registationup_Click(object sender, RoutedEventArgs e) { AirportSHIAEntities aor = new AirportSHIAEntities(); var test = aor.Client.Where(x => x.FirstName == familiyaе.Text && x.LastName == Otchestvoе.Text && x.MiddleName == nameе.Text).Select(u => u.idClient).FirstOrDefault(); if (test != -1 && test != 0) { MessageBoxResult result = System.Windows.MessageBox.Show("Удалить пользователя?", "Подтверждение", MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { var dlee = aor.Client.Where(w => w.idClient == test).FirstOrDefault(); aor.Client.Remove(dlee); aor.SaveChanges(); System.Windows.MessageBox.Show("Пользователь удален"); this.Close(); } else if (result == MessageBoxResult.No) { System.Windows.MessageBox.Show("Пользовтель не удален"); this.Close(); } else { } } }
private void search_Click(object sender, RoutedEventArgs e) { if (comboclass.Text == null && combodate.Text == null && combodepart.Text == null && comboland.Text == null) { MessageBox.Show("Нужно выбрать все элементы"); } else { var aero = new AirportSHIAEntities(); gridtable.ItemsSource = aero.FlightTicket.Include(x => x.Ticket).Include(u => u.Flight).Where(x => x.Ticket.ClassTicket == comboclass.Text && x.Flight.LandingPoint == comboland.Text && x.Flight.PointOfDeparture == combodepart.Text && x.Flight.DateFlight == combodate.Text).ToList(); } }
private void registationup_Click(object sender, RoutedEventArgs e) { AirportSHIAEntities airport = new AirportSHIAEntities(); var test = airport.Client.Where(x => x.FirstName == familiyaе.Text && x.LastName == Otchestvoе.Text && x.MiddleName == nameе.Text).Select(u => u.idClient).FirstOrDefault(); if (test != -1 && test != 0) { MessageBox.Show("Пользователь найден переходим к коректировки данных"); updatehelpeforwpfr.one = test; update a = new update(); this.Hide(); a.ShowDialog(); } }
private void gridtable_SelectionChanged(object sender, SelectionChangedEventArgs e) { FlightTicket fticket = gridtable.SelectedItem as FlightTicket; if (fticket != null) { var aero = new AirportSHIAEntities(); orderconnetctor.id = aero.FlightTicket.Include(x => x.Ticket).Include(u => u.Flight).Where(x => x.Ticket.ClassTicket == fticket.Ticket.ClassTicket && x.Flight.LandingPoint == fticket.Flight.LandingPoint && x.Flight.PointOfDeparture == fticket.Flight.PointOfDeparture && x.Flight.DateFlight == fticket.Flight.DateFlight).Select(x => x.idFlightTicket).FirstOrDefault(); } else { return; } }
private void registationup_Click(object sender, RoutedEventArgs e) { AirportSHIAEntities air = new AirportSHIAEntities(); if (updatehelpeforwpfr.one == -1 && updatehelpeforwpfr.one == 0) { MessageBox.Show("" + updatehelpeforwpfr.one); } else { var myupdate = air.Client.Where(w => w.idClient == updatehelpeforwpfr.one).FirstOrDefault(); MessageBox.Show("" + myupdate.LastName + myupdate.PhoneNumber); myupdate.FirstName = firstname.Text; myupdate.MiddleName = Middlename.Text; myupdate.LastName = lastname.Text; myupdate.PhoneNumber = Phonenumber.Text; myupdate.Email = Email.Text; air.SaveChanges(); } }
private void registationup_Click(object sender, RoutedEventArgs e) { AirportSHIAEntities a = new AirportSHIAEntities(); Document newuser = new Document() { TypeDocument = Typedocumentе.Text, NumberDocument = Numberdocе.Text, DateOfIssue = dateofendе.Text }; a.Document.Add(newuser); a.SaveChanges(); Class1.docend = dateofendе.Text; Class1.typedoc = Typedocumentе.Text; Class1.numberdoc = Numberdocе.Text; regisration abc = new regisration(); this.Hide(); abc.ShowDialog(); }
private void registationup_Click(object sender, RoutedEventArgs e) { /**/ AirportSHIAEntities a = new AirportSHIAEntities(); var me = a.Document.Where(er => er.DateOfIssue == Class1.docend && er.TypeDocument == Class1.typedoc).Select(x => x.idDocument).First(); int minimi = Convert.ToInt32(me); Client newuser = new Client() { FirstName = firstname.Text, MiddleName = Middlename.Text, LastName = lastname.Text, PhoneNumber = Phonenumber.Text, Email = Email.Text, idDocument = minimi }; a.Client.Add(newuser); a.SaveChanges(); this.Close(); //MessageBox.Show(""+ minimi); }
private void accept_Click(object sender, RoutedEventArgs e) { AirportSHIAEntities air = new AirportSHIAEntities(); int clients = air.Client. Where(w => w.LastName == lastname.Text && w.FirstName == firstname.Text && w.MiddleName == middlename.Text). Select(s => s.idClient). FirstOrDefault(); var ordtic = air.OrderTIcket.Where(x => x.idClient == clients && x.idUserSystem == usersys.id && x.NumberOrder == numberorder.Text).FirstOrDefault(); int abc = Convert.ToInt32(weight.Text); customs newuser = new customs() { Baggage = typebaggage.Text, Weight = abc, Cost = cost.Text }; air.customs.Add(newuser); air.SaveChanges(); int id = air.customs.Where(x => x.Weight == abc && x.Cost == cost.Text && x.Baggage == typebaggage.Text).Select(s => s.idcustoms).FirstOrDefault(); ordtic.idcustomers = id; air.SaveChanges(); }
private void thiload(object sender, RoutedEventArgs e) { var aero = new AirportSHIAEntities(); gridtable.ItemsSource = aero.FlightTicket.Include(x => x.Ticket).Include(u => u.Flight).ToList(); }