//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 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
{
}
}