public void AddSchedule(tFlightSchedule flightSchedule) { //var existingSchedule = (from fs in _context.tFlightSchedule where fs.FlightNo == flightSchedule.FlightNo && fs.RouteID == flightSchedule.RouteID && fs.Bound == flightSchedule.Bound && fs.EquipmentType == flightSchedule.EquipmentType select fs).FirstOrDefault(); var existingSchedule = new tFlightSchedule(); //if (existingSchedule != null) //{ existingSchedule.FlightNo = flightSchedule.FlightNo; existingSchedule.ArrivalTime = flightSchedule.ArrivalTime; existingSchedule.DepartureTime = flightSchedule.DepartureTime; existingSchedule.RouteID = flightSchedule.RouteID; existingSchedule.Effective = flightSchedule.Effective; existingSchedule.Discontinued = flightSchedule.Discontinued; existingSchedule.Bound = flightSchedule.Bound; existingSchedule.EquipmentType = flightSchedule.EquipmentType; existingSchedule.Monday = flightSchedule.Monday; existingSchedule.Tuesday = flightSchedule.Tuesday; existingSchedule.Wednesday = flightSchedule.Wednesday; existingSchedule.Thursday = flightSchedule.Thursday; existingSchedule.Friday = flightSchedule.Friday; existingSchedule.Saturday = flightSchedule.Saturday; existingSchedule.Sunday = flightSchedule.Sunday; //_context.SaveChanges(); //} //else //{ _context.tFlightSchedule.Add(flightSchedule); _context.SaveChanges(); //} }
public void AddSchedule(tFlightSchedule flightSchedule) { var existingSchedule = new tFlightSchedule(); existingSchedule.FlightNo = flightSchedule.FlightNo; existingSchedule.ArrivalTime = flightSchedule.ArrivalTime; existingSchedule.DepartureTime = flightSchedule.DepartureTime; existingSchedule.RouteID = flightSchedule.RouteID; existingSchedule.Effective = flightSchedule.Effective; existingSchedule.Discontinued = flightSchedule.Discontinued; existingSchedule.Bound = flightSchedule.Bound; existingSchedule.EquipmentType = flightSchedule.EquipmentType; existingSchedule.Monday = flightSchedule.Monday; existingSchedule.Tuesday = flightSchedule.Tuesday; existingSchedule.Wednesday = flightSchedule.Wednesday; existingSchedule.Thursday = flightSchedule.Thursday; existingSchedule.Friday = flightSchedule.Friday; existingSchedule.Saturday = flightSchedule.Saturday; existingSchedule.Sunday = flightSchedule.Sunday; _context.tFlightSchedule.Add(flightSchedule); _context.SaveChanges(); }
/// <summary> /// Import FLight Schedule /// </summary> /// <param name="data"></param> public void ImportFlightSchedule(Dictionary <string, string> data) { try { var FltNo = data["flt no"]; if (string.IsNullOrEmpty(FltNo)) { return; } if (FltNo.ToLower().EndsWith("p")) { return; } if (FltNo.ToLower().EndsWith("t")) { return; } var flightnumber = "VS" + FltNo.ToString().PadLeft(3, '0'); var origin = data["origin"]; var dest = data["dest"]; var departure = data["dept"]; var arrival = data["arrival"]; if (string.IsNullOrEmpty(origin) || string.IsNullOrEmpty(dest)) { return; } departure = CleanTime(departure); arrival = CleanTime(arrival); var equipmentype = data["equipment type"]; var effective = data["effective"]; var discontinue = data["discontinue"]; var bound = ""; if (!(origin.Contains("MAN") || origin.Contains("BFS") || origin.Contains("GLA") || origin.Contains("LGW") || origin.Contains("LHR") || dest.Contains("MAN") || dest.Contains("BFS") || dest.Contains("GLA") || dest.Contains("LGW") || dest.Contains("LHR"))) { return; } if (origin.Contains("MAN") || origin.Contains("BFS") || origin.Contains("GLA") || origin.Contains("LGW") || origin.Contains("LHR")) { bound = "Outbound"; } if (dest.Contains("MAN") || dest.Contains("BFS") || dest.Contains("GLA") || dest.Contains("LGW") || dest.Contains("LHR")) { bound = "Inbound"; } if (string.IsNullOrEmpty(bound)) { return; } //if (_routeManagement.IsDomesticRoute(origin, dest)) // return; var routeId = _routeManagement.GetRouteId(origin, dest); tFlightSchedule flightSchedule = new tFlightSchedule { FlightNo = flightnumber, ArrivalTime = arrival, DepartureTime = departure, RouteID = routeId, Effective = Convert.ToDateTime(effective), Discontinued = Convert.ToDateTime(discontinue), Bound = bound, EquipmentType = equipmentype, Monday = !string.IsNullOrEmpty(data["m"].Trim()), Tuesday = !string.IsNullOrEmpty(data["tu"].Trim()), Wednesday = !string.IsNullOrEmpty(data["w"].Trim()), Thursday = !string.IsNullOrEmpty(data["th"].Trim()), Friday = !string.IsNullOrEmpty(data["f"].Trim()), Saturday = !string.IsNullOrEmpty(data["sa"].Trim()), Sunday = !string.IsNullOrEmpty(data["su"].Trim()) }; _routeManagement.AddSchedule(flightSchedule); } catch (Exception e) { //write to Elma ErrorSignal.FromCurrentContext().Raise(e); } }