public static List <FlightHistory> GetFlightHistory() { using (var dbContext = new FlightCompanionEntities()) { return(dbContext.FlightHistories.ToList()); } }
public static List <Aircraft> GetAircraft() { using (var dbContext = new FlightCompanionEntities()) { return(dbContext.Aircraft.ToList()); } }
internal static void DeleteChart(int chartId) { using (var entities = new FlightCompanionEntities()) { var chart = entities.Charts.Find(chartId); entities.Charts.Remove(chart); } }
public static List <SelectListItem> GetICAOCodes() { using (var dbContext = new FlightCompanionEntities()) { return(dbContext.IcaoCodes.Select(x => new SelectListItem { Value = x.Id.ToString(), Text = x.Code }).ToList()); } }
internal static List <SelectListItem> GetChartTypes() { using (var dbContext = new FlightCompanionEntities()) { return(dbContext.ChartTypes.Select(x => new SelectListItem { Value = x.Id.ToString(), Text = x.Value }).ToList()); } }