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