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