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