// TrasactionDetail
public void BindGridView()
{
AirlineEntities1 db = new AirlineEntities1();
var result = from S in db.TrasactionDetails
select new { S.TransactionId, S.Userid, S.BookingDate, S.FlightNo, S.DepartureDate, S.TotalNoOfPassengers, S.TotalPrice };
GridView1.DataSource = result.ToList();
GridView1.DataBind();
// GridView1.Tolist(result);
}
public void BindGridView()
{
AirlineEntities1 db = new AirlineEntities1();
var result = from S in db.FlightDetails
select new { S.FlightNo, S.FromCity, S.ToCity, S.DateofDeparture, S.DepartureTime, S.ArrivalTime, S.Seats, S.Status, S.price };
GridView1.DataSource = result.ToList();
GridView1.DataBind();
// GridView1.Tolist(result);
}
// TrasactionDetail
public void BindGridView()
{
AirlineEntities1 db = new AirlineEntities1();
var result = from S in db.TrasactionDetails
select new {S.TransactionId,S.Userid,S.BookingDate,S.FlightNo,S.DepartureDate,S.TotalNoOfPassengers,S.TotalPrice};
GridView1.DataSource = result.ToList();
GridView1.DataBind();
// GridView1.Tolist(result);
}
//protected void Button1_Click(object sender, EventArgs e)
//{
// using (AirlineEntities1 cntx = new AirlineEntities1())
// {
// var flight = cntx.FlightDetails.FirstOrDefault(m => m.FlightNo == FlightNOTextbox.Text);
// if(flight !=null)
// {
// //FromTextbox.Text = flight.FromCity;
// //ToTextbox.Text = flight.ToCity;
// DepartureDateTextbox.Text = flight.DateofDeparture.ToString();
// DepartureTimeTextbox.Text = flight.DepartureTime.ToString();
// SeatTextbox.Text = flight.Seats.ToString();
// FlightNOTextbox.Text = flight.FlightNo;
// //StatusTextbox.Text = flight.Seats.ToString();
// PriceTextbox.Text = flight.price.ToString();
// }
// }
//}
protected void Update_Click(object sender, EventArgs e)
{
try
{
using (AirlineEntities1 cntx = new AirlineEntities1())
{
var flight = cntx.FlightDetails.FirstOrDefault(m => m.FlightNo == FlightNOTextbox.Text);
if (flight != null)
{
//flight.FromCity = FromTextbox.Text;
//flight.ToCity =ToTextbox.Text ;
flight.DateofDeparture = Convert.ToDateTime(DepartureDateTextbox.Text);
flight.ArrivalTime = TimeSpan.Parse(ArrivalTimeTextbox.Text);
flight.DepartureTime = TimeSpan.Parse(DepartureTimeTextbox.Text);
flight.Seats = Convert.ToInt32(SeatTextbox.Text);
// flight.Status = StatusTextbox.Text;
flight.price = Convert.ToDecimal(PriceTextbox.Text);
FlightNOTextbox.Text = flight.FlightNo;
flight.FromCity = UpdateFromCity.Text;
flight.ToCity = UpdateToCityDropDown.Text;
flight.Status = UpdateStatusDrop.Text;
cntx.SaveChanges();
UpdateFlightLabel.Visible = true;
ClientScript.RegisterStartupScript(this.GetType(), "alert", "HideLabel2();", true);
UpdateFlightLabel.Text = "Form has been submitted successfully.";
ClearFields();
}
}
}
catch (Exception ex)
{
// Log the exception
UpdateFlightError.Visible = true;
ClientScript.RegisterStartupScript(this.GetType(), "alert", "HideLabel4();", true);
UpdateFlightError.Text = "Invalid Input Field Please Check your input field";
}
finally
{
}
}
protected void UpdateDelete_Click(object sender, EventArgs e)
{
using (AirlineEntities1 cntx = new AirlineEntities1())
{
var flight = cntx.FlightDetails.FirstOrDefault(m => m.FlightNo == FlightNOTextbox.Text);
if (flight != null)
{
// cntx.Delete(data);
cntx.FlightDetails.Remove(flight);
cntx.SaveChanges();
ClearFields();
}
}
}
//protected void Button1_Click(object sender, EventArgs e)
//{
// using (AirlineEntities1 cntx = new AirlineEntities1())
// {
// var flight = cntx.FlightDetails.FirstOrDefault(m => m.FlightNo == FlightNOTextbox.Text);
// if(flight !=null)
// {
// //FromTextbox.Text = flight.FromCity;
// //ToTextbox.Text = flight.ToCity;
// DepartureDateTextbox.Text = flight.DateofDeparture.ToString();
// DepartureTimeTextbox.Text = flight.DepartureTime.ToString();
// SeatTextbox.Text = flight.Seats.ToString();
// FlightNOTextbox.Text = flight.FlightNo;
// //StatusTextbox.Text = flight.Seats.ToString();
// PriceTextbox.Text = flight.price.ToString();
// }
// }
//}
protected void Update_Click(object sender, EventArgs e)
{
try
{
using (AirlineEntities1 cntx = new AirlineEntities1())
{
var flight = cntx.FlightDetails.FirstOrDefault(m => m.FlightNo == FlightNOTextbox.Text);
if (flight != null)
{
//flight.FromCity = FromTextbox.Text;
//flight.ToCity =ToTextbox.Text ;
flight.DateofDeparture = Convert.ToDateTime(DepartureDateTextbox.Text);
flight.ArrivalTime = TimeSpan.Parse(ArrivalTimeTextbox.Text);
flight.DepartureTime = TimeSpan.Parse(DepartureTimeTextbox.Text);
flight.Seats = Convert.ToInt32(SeatTextbox.Text);
// flight.Status = StatusTextbox.Text;
flight.price = Convert.ToDecimal(PriceTextbox.Text);
FlightNOTextbox.Text = flight.FlightNo;
flight.FromCity = UpdateFromCity.Text;
flight.ToCity = UpdateToCityDropDown.Text;
flight.Status = UpdateStatusDrop.Text;
cntx.SaveChanges();
UpdateFlightLabel.Visible = true;
ClientScript.RegisterStartupScript(this.GetType(), "alert", "HideLabel2();", true);
UpdateFlightLabel.Text = "Form has been submitted successfully.";
ClearFields();
}
}
}
catch (Exception ex)
{
// Log the exception
UpdateFlightError.Visible = true;
ClientScript.RegisterStartupScript(this.GetType(), "alert", "HideLabel4();", true);
UpdateFlightError.Text = "Invalid Input Field Please Check your input field";
}
finally
{
}
}
protected void BtnCreateFlight1_Click(object sender, EventArgs e)
{
try
{
using (AirlineEntities1 cntx = new AirlineEntities1())
{
FlightDetail addFlight = new FlightDetail();
addFlight.FlightNo = FlightNumber1TextBox.Text;
addFlight.FromCity = FromCity1DropDown.Text;
addFlight.ToCity = ToCity1DropDown.Text;
if (DateOfDeparture1Textbox.Text != string.Empty)
{
addFlight.DateofDeparture = Convert.ToDateTime(DateOfDeparture1Textbox.Text);
}
if (DepartureTime1TextBox.Text != string.Empty)
{
addFlight.DepartureTime = TimeSpan.Parse(DepartureTime1TextBox.Text);
}
if (ArrivalTime1Texbox.Text != string.Empty)
{
addFlight.ArrivalTime = TimeSpan.Parse(ArrivalTime1Texbox.Text);
}
if (Seats1TextBox.Text != string.Empty)
{
addFlight.Seats = Convert.ToInt32(Seats1TextBox.Text);
}
if (StatusDropdown1.Text != string.Empty)
{
addFlight.Status = StatusDropdown1.Text;
}
if (Price1TextBox.Text != string.Empty)
{
addFlight.price = Convert.ToDecimal(Price1TextBox.Text);
}
//cntx.FlightDetail.AddObject(addFlight);
cntx.FlightDetails.Add(addFlight);
// cntx.AddToFlightDetails(addFlight);
cntx.SaveChanges();
ClearFields2();
// NewFlight.Text = "New Flight Added";
NewFlight.Visible = true;
ClientScript.RegisterStartupScript(this.GetType(), "alert", "HideLabel();", true);
NewFlight.Text = "Form has been submitted successfully.";
// flight.DateofDeparture = Convert.ToDateTime(DepartureDateTextbox.Text);
// flight.DepartureTime = TimeSpan.Parse(DepartureTimeTextbox.Text);
}
}
catch (Exception ex)
{
// Log the exception
ForInputError.Visible = true;
ClientScript.RegisterStartupScript(this.GetType(), "alert", "HideLabel3();", true);
ForInputError.Text = "Invalid Input Field Please Check your input field";
}
finally
{
}
}
protected void Button2_Click(object sender, EventArgs e)
{
AirlineEntities1 db = new AirlineEntities1();
FlightDetail Flight = new FlightDetail();
UpdateFlightLabel.Text = "";
Flight.FlightNo = TextBox1.Text;
// Flight.FromCity = TextBox4.Text;
// Flight.ToCity = TextBox5.Text;
// Flight.Status = TextBox9.Text;
Flight.FromCity = FromCityDropDown.Text;
Flight.ToCity = SearchToCityDropDown.Text;
Flight.Status = SearchStatusDropdown.Text;
if (!string.IsNullOrEmpty(TextBox2.Text))
{
Flight.DateofDeparture = DateTime.Parse(TextBox2.Text);
}
if (!string.IsNullOrEmpty(TextBox3.Text))
{
Flight.DepartureTime = TimeSpan.Parse(TextBox3.Text);
}
if (!string.IsNullOrEmpty(TextBox6.Text))
{
Flight.ArrivalTime = TimeSpan.Parse(TextBox6.Text);
}
if (!string.IsNullOrEmpty(TextBox7.Text))
{
Flight.Seats = Int32.Parse(TextBox7.Text);
}
if (!string.IsNullOrEmpty(TextBox8.Text))
{
Flight.price = Decimal.Parse(TextBox8.Text);
}
var result = from S in db.FlightDetails
where (S.FlightNo == Flight.FlightNo || S.FromCity == Flight.FromCity || S.DateofDeparture == Flight.DateofDeparture || S.DepartureTime == Flight.DepartureTime || S.ToCity == Flight.ToCity || S.ArrivalTime == Flight.ArrivalTime || S.Seats == Flight.Seats || S.Status == Flight.Status || S.price == Flight.price)
select new { S.FlightNo, S.FromCity, S.ToCity, S.DateofDeparture, S.DepartureTime, S.ArrivalTime, S.Seats, S.Status, S.price };
//Flight.FromCity = TextBox1.Text;
//var result1 = from S in db.FlightDetails
// where S.FromCity == Flight.FromCity
// select new { S.FlightNo, S.FromCity, S.ToCity, S.DateofDeparture, S.DepartureTime };
//Flight.DateofDeparture = DateTime.Parse(TextBox1.Text);
//var result2 = from S in db.FlightDetails
// where S.DateofDeparture == Flight.DateofDeparture
// select new { S.FlightNo, S.FromCity, S.ToCity, S.DateofDeparture, S.DepartureTime };
GridView1.DataSource = result.ToList();
//GridView1.DataSource = result1.ToList();
// GridView1.DataSource = result2.ToList();
GridView1.DataBind();
}
protected void UpdateDelete_Click(object sender, EventArgs e)
{
using (AirlineEntities1 cntx = new AirlineEntities1())
{
var flight = cntx.FlightDetails.FirstOrDefault(m => m.FlightNo == FlightNOTextbox.Text);
if (flight != null)
{
// cntx.Delete(data);
cntx.FlightDetails.Remove(flight);
cntx.SaveChanges();
ClearFields();
}
}
}
protected void BtnCreateFlight1_Click(object sender, EventArgs e)
{
try
{
using (AirlineEntities1 cntx = new AirlineEntities1())
{
FlightDetail addFlight = new FlightDetail();
addFlight.FlightNo = FlightNumber1TextBox.Text;
addFlight.FromCity = FromCity1DropDown.Text;
addFlight.ToCity = ToCity1DropDown.Text;
if (DateOfDeparture1Textbox.Text != string.Empty)
{
addFlight.DateofDeparture = Convert.ToDateTime(DateOfDeparture1Textbox.Text);
}
if (DepartureTime1TextBox.Text != string.Empty)
{
addFlight.DepartureTime = TimeSpan.Parse(DepartureTime1TextBox.Text);
}
if (ArrivalTime1Texbox.Text != string.Empty)
{
addFlight.ArrivalTime = TimeSpan.Parse(ArrivalTime1Texbox.Text);
}
if (Seats1TextBox.Text != string.Empty)
{
addFlight.Seats = Convert.ToInt32(Seats1TextBox.Text);
}
if (StatusDropdown1.Text != string.Empty)
{
addFlight.Status = StatusDropdown1.Text;
}
if (Price1TextBox.Text != string.Empty)
{
addFlight.price = Convert.ToDecimal(Price1TextBox.Text);
}
//cntx.FlightDetail.AddObject(addFlight);
cntx.FlightDetails.Add(addFlight);
// cntx.AddToFlightDetails(addFlight);
cntx.SaveChanges();
ClearFields2();
// NewFlight.Text = "New Flight Added";
NewFlight.Visible = true;
ClientScript.RegisterStartupScript(this.GetType(), "alert", "HideLabel();", true);
NewFlight.Text = "Form has been submitted successfully.";
// flight.DateofDeparture = Convert.ToDateTime(DepartureDateTextbox.Text);
// flight.DepartureTime = TimeSpan.Parse(DepartureTimeTextbox.Text);
}
}
catch (Exception ex)
{
// Log the exception
ForInputError.Visible = true;
ClientScript.RegisterStartupScript(this.GetType(), "alert", "HideLabel3();", true);
ForInputError.Text = "Invalid Input Field Please Check your input field";
}
finally
{
}
}
public void BindGridView()
{
AirlineEntities1 db = new AirlineEntities1();
var result = from S in db.FlightDetails
select new { S.FlightNo, S.FromCity, S.ToCity, S.DateofDeparture, S.DepartureTime ,S.ArrivalTime,S.Seats,S.Status,S.price};
GridView1.DataSource = result.ToList();
GridView1.DataBind();
// GridView1.Tolist(result);
}
protected void Button2_Click(object sender, EventArgs e)
{
AirlineEntities1 db = new AirlineEntities1();
FlightDetail Flight = new FlightDetail();
UpdateFlightLabel.Text = "";
Flight.FlightNo =TextBox1.Text;
// Flight.FromCity = TextBox4.Text;
// Flight.ToCity = TextBox5.Text;
// Flight.Status = TextBox9.Text;
Flight.FromCity = FromCityDropDown.Text;
Flight.ToCity = SearchToCityDropDown.Text;
Flight.Status = SearchStatusDropdown.Text;
if (!string.IsNullOrEmpty(TextBox2.Text))
{
Flight.DateofDeparture = DateTime.Parse(TextBox2.Text);
}
if (!string.IsNullOrEmpty(TextBox3.Text))
{
Flight.DepartureTime = TimeSpan.Parse(TextBox3.Text);
}
if (!string.IsNullOrEmpty(TextBox6.Text))
{
Flight.ArrivalTime = TimeSpan.Parse(TextBox6.Text);
}
if (!string.IsNullOrEmpty(TextBox7.Text))
{
Flight.Seats = Int32.Parse(TextBox7.Text);
}
if (!string.IsNullOrEmpty(TextBox8.Text))
{
Flight.price = Decimal.Parse(TextBox8.Text);
}
var result = from S in db.FlightDetails
where (S.FlightNo == Flight.FlightNo || S.FromCity == Flight.FromCity || S.DateofDeparture == Flight.DateofDeparture || S.DepartureTime==Flight.DepartureTime || S.ToCity==Flight.ToCity || S.ArrivalTime==Flight.ArrivalTime || S.Seats==Flight.Seats || S.Status==Flight.Status || S.price==Flight.price )
select new { S.FlightNo, S.FromCity, S.ToCity, S.DateofDeparture, S.DepartureTime,S.ArrivalTime,S.Seats,S.Status,S.price};
//Flight.FromCity = TextBox1.Text;
//var result1 = from S in db.FlightDetails
// where S.FromCity == Flight.FromCity
// select new { S.FlightNo, S.FromCity, S.ToCity, S.DateofDeparture, S.DepartureTime };
//Flight.DateofDeparture = DateTime.Parse(TextBox1.Text);
//var result2 = from S in db.FlightDetails
// where S.DateofDeparture == Flight.DateofDeparture
// select new { S.FlightNo, S.FromCity, S.ToCity, S.DateofDeparture, S.DepartureTime };
GridView1.DataSource = result.ToList();
//GridView1.DataSource = result1.ToList();
// GridView1.DataSource = result2.ToList();
GridView1.DataBind();
}
