public bool SaveCustomerDetails(Customer customer) // calling SaveStudentMethod for insert a new record
{
bool result = false;
using (CustomerEntities _entity = new CustomerEntities())
{
_entity.Customer.Add(customer);
_entity.SaveChanges();
result = true;
}
return(result);
}
public bool DeleteFlightDetails(Flight flight) // DeleteStudentDetails method to delete record from table
{
bool result = false;
using (CustomerEntities _entity = new CustomerEntities())
{
//Flight book = (Flight)_entity.Flight.Where(b => b.flightId == flight.flightId).First();
//_entity.DeleteObject(book);
Flight _flight = _entity.Flight.Where(x => x.flightId == flight.flightId).Select(x => x).FirstOrDefault();
_entity.Flight.Remove(_flight);
_entity.SaveChanges();
result = true;
}
return(result);
}
public void Display() // Display Method is a common method to bind the Student details in datagridview after save,update and delete operation perform.
{
using (CustomerEntities _entity = new CustomerEntities())
{
List <FlightClass> _flightList = new List <FlightClass>();
_flightList = _entity.Flight.Select(x => new FlightClass
{
flightId = x.flightId,
airlineCompany = x.airlineCompany,
origin = x.origin,
destination = x.destination,
date = x.date
}).ToList();
FlightDataGridView.DataSource = _flightList;
}
}
public bool UpdateFlightDetails(Flight flight) // UpdateStudentDetails method for update a existing Record
{
bool result = false;
using (CustomerEntities _entity = new CustomerEntities())
{
Flight _flight = _entity.Flight.Where(x => x.flightId == flight.flightId).Select(x => x).FirstOrDefault();
_flight.airlineCompany = flight.airlineCompany;
_flight.origin = flight.origin;
_flight.destination = flight.destination;
_flight.date = flight.date;
_entity.SaveChanges();
result = true;
}
return(result);
}
private void FlightForm_Load(object sender, EventArgs e)
{
_customerEntities = new CustomerEntities();
Display();
}
