public FlightClassDetail GetFlightClassDetail(int flightClassDetailId)
{
using (OnlineFlightTicketBookingDBContext FlightDBContext = new OnlineFlightTicketBookingDBContext())
{
return(FlightDBContext.FlightClassDetails.Where(flight => flight.FlightClassDetailId == flightClassDetailId).FirstOrDefault());
}
}
public IEnumerable <FlightClass> GetFlightClass()
{
using (OnlineFlightTicketBookingDBContext FlightDBContext = new OnlineFlightTicketBookingDBContext())
{
return(FlightDBContext.FlightClass.ToList());
}
}
public IEnumerable <FlightClassDetail> FlightClassDetails()
{
using (OnlineFlightTicketBookingDBContext FlightDBContext = new OnlineFlightTicketBookingDBContext())
{
return(FlightDBContext.FlightClassDetails.Include("Flight").Include("FlightClass").ToList());
}
}
public void UpdateFlightClassDetail(FlightClassDetail flightClassDetail)
{
using (OnlineFlightTicketBookingDBContext FlightDBContext = new OnlineFlightTicketBookingDBContext())
{
FlightDBContext.Entry(flightClassDetail).State = EntityState.Modified;
FlightDBContext.SaveChanges();
}
}
public void AddFlightClassDetail(FlightClassDetail flightClassDetail)
{
using (OnlineFlightTicketBookingDBContext FlightDBContext = new OnlineFlightTicketBookingDBContext())
{
FlightDBContext.FlightClassDetails.Add(flightClassDetail);
FlightDBContext.SaveChanges();
}
}
public void UpdateProfile(Account account)
{
using (OnlineFlightTicketBookingDBContext DBContext = new OnlineFlightTicketBookingDBContext())
{
DBContext.Entry(account).State = EntityState.Modified;
DBContext.SaveChanges();
}
}
public Account ValidateUser(Account account)
{
using (OnlineFlightTicketBookingDBContext accountDBContext = new OnlineFlightTicketBookingDBContext())
{
var result = accountDBContext.Accounts.Where(user => user.EmailId == account.EmailId && user.Password == account.Password).FirstOrDefault();
return(result);
}
}
public void AddUser(Account user)
{
using (OnlineFlightTicketBookingDBContext accountDBContext = new OnlineFlightTicketBookingDBContext())
{
accountDBContext.Accounts.Add(user);
accountDBContext.SaveChanges();
}
}
public List <FlightClass> GetFlightClasses()
{
using (OnlineFlightTicketBookingDBContext FlightDBContext = new OnlineFlightTicketBookingDBContext())
{
List <FlightClass> flightclass = FlightDBContext.FlightClass.ToList();
//List<FlightClass> flightClasses = FlightDBContext.FlightClassDetails.SqlQuery("select * from FlightClass where ");
return(flightclass);
}
}
public void DeleteFlightClass(int id)
{
using (OnlineFlightTicketBookingDBContext FlightDBContext = new OnlineFlightTicketBookingDBContext())
{
FlightClass flightClass = FlightDBContext.FlightClass.Find(id);
FlightDBContext.FlightClass.Remove(flightClass);
FlightDBContext.SaveChanges();
}
}
public Account GetUser(int id)
{
using (OnlineFlightTicketBookingDBContext DBContext = new OnlineFlightTicketBookingDBContext())
{
return(DBContext.Accounts.Where(user => user.Id == id).FirstOrDefault());
string str = "Comit";
char c = str.
}
}
public void DeleteFlightClassDetail(int id)
{
using (OnlineFlightTicketBookingDBContext FlightDBContext = new OnlineFlightTicketBookingDBContext())
{
//Flight flight = GetFlight(id);
FlightClassDetail flightClassDetail = FlightDBContext.FlightClassDetails.Find(id);
FlightDBContext.FlightClassDetails.Remove(flightClassDetail);
// FlightDBContext.Entry(flight).State = EntityState.Deleted;
FlightDBContext.SaveChanges();
}
}
