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