internal static FlightPlanSummary GetFlightPlanSummary(Models.FlightPlan plan) { var flightPlan = new FlightCompanionEntities().FlightPlans.FirstOrDefault(x => x.Departure == plan.DepartureIcao && x.Destination == plan.DestinationIcao); var metar = "123455555 9999KT RBK 21/23 DP 23/43"; return(new FlightPlanSummary { DepartureAirport = flightPlan.DepartureAirport.AirportName, DestinationAirport = flightPlan.DestinationAirport.AirportName, Distance = flightPlan.Distance, Metar = metar, WayPoints = flightPlan.Waypoints.Replace("|", " => "), }); }
internal static void UploadFlightPlan(Models.FlightPlan plan) { using (var entities = new FlightCompanionEntities()) { entities.FlightPlans.Add(new FlightPlan { Departure = plan.DepartureIcao, Destination = plan.DestinationIcao, Distance = plan.Distance, Waypoints = plan.Waypoints }); entities.SaveChanges(); } }
internal static List <SelectListItem> GetCharts(int chartType) { var charts = new FlightCompanionEntities() .Charts.Where(x => x.ChartType == chartType) .Select(x => new SelectListItem { Value = x.Id.ToString(), Text = x.Name }).ToList(); charts.Insert(0, new SelectListItem { Value = "-1", Text = "-Select-" }); charts.Reverse(); return(charts); }
internal static bool UploadChart(int chartType, HttpPostedFileBase[] files) { var chartTypes = DataConnector.GetChartTypes(); foreach (var file in files) { var bytes = new byte[file.InputStream.Length]; var postedFile = file.InputStream.Read(bytes, 0, bytes.Length); using (var entities = new FlightCompanionEntities()) { entities.Charts.Add(new Chart { ChartType = chartType, Name = Path.GetFileName(file.FileName), ChartData = bytes }); entities.SaveChanges(); } } return(true); }
internal static byte[] GetFlightPlan(int chart, HttpContextBase httpContext) { var selectedChart = new FlightCompanionEntities().Charts.Find(chart); return(selectedChart.ChartData); }