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();
}
