public passengersList() { InitializeComponent(); ATRSDataContext DC = new ATRSDataContext(); var result = from P in DC.Passengers select P; this.dataList.ItemsSource = result.ToList(); }
public ReserveTicket() { InitializeComponent(); ATRSDataContext DC = new ATRSDataContext(); var result = from P in DC.Flight_Details join R in DC.Reserve_Tickets on P.flight_id equals R.filght_id select new { P.from_airport, P.to_airport, P.flight_id, R.ticket_type, P.first_class_fare, P.economy_fare }; foreach (var item in result) { flightID = item.flight_id; T_Type.Items.Add(item.ticket_type); fromAirport.Items.Add(item.from_airport); toAirport.Items.Add(item.to_airport); if (T_Type.Items.Equals("First Class")) { //MessageBox.Show("Here you Go"); //var result1 = (from FL in DC.Flight_Details // where FL.flight_id == flightID // select FL).FirstOrDefault(); T_Fare.Text = item.first_class_fare.ToString(); } else { //var result1 = (from FL in DC.Flight_Details // where FL.flight_id == flightID // select FL).FirstOrDefault(); T_Fare.Text = item.economy_fare.ToString(); } } }
public FlightDetail() { InitializeComponent(); ATRSDataContext DC = new ATRSDataContext(); var result = from P in DC.Flight_Details select new { Flight_ID = P.flight_id, From = P.from_airport, To = P.to_airport, Departure_Time = P.departure_time, Departure_Date = P.departure_date.ToShortDateString(), Arrival_Time = P.arrival_time, Arrival_Date = P.arrival_date.ToShortDateString(), Economy_Class_Fare = P.economy_fare, First_CLass_Fare = P.first_class_fare }; this.gridFlights.ItemsSource = result.ToList(); }
private void resetPass_Click(object sender, RoutedEventArgs e) { ATRSDataContext DC_Obj = new ATRSDataContext(); var query = from psng in DC_Obj.Passengers where psng.passenger_id == PassengerID select psng; foreach (Passenger item in query) { if (newPass.Password.ToString() == re_entNewPass.Password.ToString()) { item.password = newPass.Password.ToString(); } } // Submit the changes to the database. if (newPass.Password.ToString() == re_entNewPass.Password.ToString()) { try { DC_Obj.SubmitChanges(); MessageBox.Show("Password Changed"); this.Hide(); MainWindow reback = new MainWindow(); reback.Show(); } catch (Exception exp) { MessageBox.Show(exp.ToString()); // Provide for exceptions. } } else { MessageBox.Show("Password Didnot Match"); } }
private void loginClick(object sender, RoutedEventArgs e) { ATRSDataContext DC = new ATRSDataContext(); var result = from P in DC.Passengers select P; foreach (var item in result) { if ((userName.Text.Equals(item.first_name)) && (passWord.Password.Equals(item.password))) { this.Hide(); UserActivity User_A = new UserActivity(); User_A.Show(); } else if ((userName.Text.Equals(item.first_name)) && (!passWord.Password.Equals(item.password))) { passengID = item.passenger_id; } } }