public void SetAvailableFlightCities() { try { ARS_AIRLINESEntities1 db = new ARS_AIRLINESEntities1(); var availableFlightCities = db.AVAILABLE_FLIGHT_CITIES.Where(f => f.Active).ToList(); if (availableFlightCities?.Count() > 0) { AvailableFlightCitiesSelectList.Add(new Value() { Id = 0, Text = "--Select City--" }); foreach (var item in availableFlightCities) { AvailableFlightCitiesSelectList.Add(new Value() { Id = item.Id, Text = item.Name }); } } } catch (Exception ex) { throw ex; } }
public void SetTripTypes() { try { ARS_AIRLINESEntities1 db = new ARS_AIRLINESEntities1(); var tripTypes = db.TRIP_TYPE.Where(t => t.Active).ToList(); if (tripTypes?.Count() > 0) { TripTypesSelectList.Add(new Value() { Id = 0, Text = "--Select Trip Type--" }); foreach (var item in tripTypes) { TripTypesSelectList.Add(new Value() { Id = item.Id, Text = item.Name }); } } } catch (Exception ex) { throw ex; } }
public void SetFlightClasses() { try { ARS_AIRLINESEntities1 db = new ARS_AIRLINESEntities1(); var flightClasses = db.FLIGHT_CLASS.Where(f => f.Active).ToList(); if (flightClasses?.Count() > 0) { FlightClassesSelectList.Add(new Value() { Id = 0, Text = "--Select Flight Class--" }); foreach (var item in flightClasses) { FlightClassesSelectList.Add(new Value() { Id = item.Id, Text = item.Name }); } } } catch (Exception ex) { throw ex; } }
public BaseController() { db = new ARS_AIRLINESEntities1(); }