public void BuildTestFlights30()
{
var fda = new FlightDataAccess();
var air1 = fda.GetAirportById(798);
var air2 = fda.GetAirportById(1052);
var flight = new Flight()
{
SourceAirport = air1,
DestinationAirport = air2,
SourceAirportId = air1.Id,
DestinationAirportId = air2.Id,
Price = 1135,
Status = true,
DepartureTime = DateTime.Now.AddDays(3),
ArrivalTime = DateTime.Now.AddDays(3).AddHours(16),
Name = "1173-3824"
};
fda.AddOrUpdateFlight(flight);
}
public ActionResult Flight(int id)
{
FlightDataAccess fda = new FlightDataAccess();
var flight = fda.GetFlight(id);
return(View(flight));
}
public ActionResult Flights(List <Flight> flights)
{
FlightDataAccess fda = new FlightDataAccess();
var model = fda.GetAllFlights();
return(View(flights));
}
public void BuildTestFlights4()
{
var fda = new FlightDataAccess();
var air1 = fda.GetAirportById(6751);
var air2 = fda.GetAirportById(3530);
var flight = new Flight()
{
SourceAirport = air1,
DestinationAirport = air2,
SourceAirportId = air1.Id,
DestinationAirportId = air2.Id,
Price = 224,
Status = true,
DepartureTime = DateTime.Now.AddDays(3),
ArrivalTime = DateTime.Now.AddDays(3).AddHours(5),
Name = "6751-2530"
};
fda.AddOrUpdateFlight(flight);
}
public ActionResult AddFlights(AddFlightForm form)
{
FlightDataAccess fda = new FlightDataAccess();
fda.addFlight(form.startingIdNumber, form.endingIdNumber, form.time, form.price);
return(RedirectToAction("Index", "Home"));
}
public void BuildTestFlights8()
{
var fda = new FlightDataAccess();
var air1 = fda.GetAirportById(5106);
var air2 = fda.GetAirportById(6575);
var flight = new Flight()
{
SourceAirport = air1,
DestinationAirport = air2,
SourceAirportId = air1.Id,
DestinationAirportId = air2.Id,
Price = 517,
Status = true,
DepartureTime = DateTime.Now.AddDays(3),
ArrivalTime = DateTime.Now.AddDays(3).AddHours(3),
Name = "3674-6906"
};
fda.AddOrUpdateFlight(flight);
}
public void BuildTestFlights5()
{
var fda = new FlightDataAccess();
var air1 = fda.GetAirportById(4136);
var air2 = fda.GetAirportById(3461);
var flight = new Flight()
{
SourceAirport = air1,
DestinationAirport = air2,
SourceAirportId = air1.Id,
DestinationAirportId = air2.Id,
Price = 480,
Status = true,
DepartureTime = DateTime.Now.AddDays(3),
ArrivalTime = DateTime.Now.AddDays(3).AddHours(6),
Name = "4136-3461"
};
fda.AddOrUpdateFlight(flight);
}
public void BuildTestFlights17()
{
var fda = new FlightDataAccess();
var air1 = fda.GetAirportById(3182);
var air2 = fda.GetAirportById(3674);
var flight = new Flight()
{
SourceAirport = air1,
DestinationAirport = air2,
SourceAirportId = air1.Id,
DestinationAirportId = air2.Id,
Price = 1958,
Status = true,
DepartureTime = DateTime.Now.AddDays(3),
ArrivalTime = DateTime.Now.AddDays(3).AddHours(23),
Name = "3182-3674"
};
fda.AddOrUpdateFlight(flight);
}
public void BuildTestFlights22()
{
var fda = new FlightDataAccess();
var air1 = fda.GetAirportById(3563);
var air2 = fda.GetAirportById(337);
var flight = new Flight()
{
SourceAirport = air1,
DestinationAirport = air2,
SourceAirportId = air1.Id,
DestinationAirportId = air2.Id,
Price = 871,
Status = true,
DepartureTime = DateTime.Now.AddDays(3),
ArrivalTime = DateTime.Now.AddDays(3).AddHours(10),
Name = "3563-337"
};
fda.AddOrUpdateFlight(flight);
}
public void BuildTestFlights24()
{
var fda = new FlightDataAccess();
var air1 = fda.GetAirportById(593);
var air2 = fda.GetAirportById(1162);
var flight = new Flight()
{
SourceAirport = air1,
DestinationAirport = air2,
SourceAirportId = air1.Id,
DestinationAirportId = air2.Id,
Price = 214,
Status = true,
DepartureTime = DateTime.Now.AddDays(3),
ArrivalTime = DateTime.Now.AddDays(3).AddHours(4),
Name = "593-1162"
};
fda.AddOrUpdateFlight(flight);
}
public ActionResult SearchFlights(SearchPageForm form)
{
FlightDataAccess fda = new FlightDataAccess();
var flights = fda.SearchFlights(form.StartCity, form.DestinationCity, form.Country);
return(PartialView("_Partial/Flights", flights));
}
public BookingController()
{
flightDAL = new FlightDataAccess();
passengerDAL = new PassengerDataAccess();
contactsDAL = new ContactsDataAccess();
ticketsDAL = new TicketDataAccess();
seatsDAL = new SeatDataAccess();
historyDAL = new HistoryDataAccess();
userDAL = new UserDataAccess();
}
public ActionResult GetFlightViewer(int flightId)
{
FlightDataAccess fda = new FlightDataAccess();
var flight = fda.GetFlight(flightId);
if (flight != null)
{
return(PartialView("_Partial/FlightViewer", flight));
}
return(null);
}
public ActionResult GetFlightViewer(int flightId)
{
FlightDataAccess fda = new FlightDataAccess();
var flight = fda.GetFlight(flightId);
if (flight != null)
{
var pageForm = new FlightUserPageForm()
{
Flight = flight,
IsAdmin = User.IsInRole("Admin")
};
return(PartialView("_Partial/FlightViewer", pageForm));
}
return(null);
}
public void BuildTestFlights12()
{
var fda = new FlightDataAccess();
var air1 = fda.GetAirportById(3694);
var air2 = fda.GetAirportById(7540);
var flight = new Flight()
{
SourceAirport = air1,
DestinationAirport = air2,
SourceAirportId = air1.Id,
DestinationAirportId = air2.Id,
Price = 1035,
Status = true,
DepartureTime = DateTime.Now,
ArrivalTime = DateTime.Now.AddHours(8),
Name = "3694-7540"
};
fda.AddOrUpdateFlight(flight);
}
public void BuildTestFlights18()
{
var fda = new FlightDataAccess();
var air1 = fda.GetAirportById(3566);
var air2 = fda.GetAirportById(7436);
var flight = new Flight()
{
SourceAirport = air1,
DestinationAirport = air2,
SourceAirportId = air1.Id,
DestinationAirportId = air2.Id,
Price = 387,
Status = true,
DepartureTime = DateTime.Now,
ArrivalTime = DateTime.Now.AddHours(5),
Name = "3566-7436"
};
fda.AddOrUpdateFlight(flight);
}
public void BuildTestFlights15()
{
var fda = new FlightDataAccess();
var air1 = fda.GetAirportById(6981);
var air2 = fda.GetAirportById(7592);
var flight = new Flight()
{
SourceAirport = air1,
DestinationAirport = air2,
SourceAirportId = air1.Id,
DestinationAirportId = air2.Id,
Price = 263,
Status = true,
DepartureTime = DateTime.Now,
ArrivalTime = DateTime.Now.AddHours(4),
Name = "6981-7592"
};
fda.AddOrUpdateFlight(flight);
}
public void BuildTestFlights11()
{
var fda = new FlightDataAccess();
var air1 = fda.GetAirportById(1716);
var air2 = fda.GetAirportById(5534);
var flight = new Flight()
{
SourceAirport = air1,
DestinationAirport = air2,
SourceAirportId = air1.Id,
DestinationAirportId = air2.Id,
Price = 527,
Status = true,
DepartureTime = DateTime.Now,
ArrivalTime = DateTime.Now.AddHours(4),
Name = "1716-5534"
};
fda.AddOrUpdateFlight(flight);
}
public void BuildTestFlights()
{
var fda = new FlightDataAccess();
var air1 = fda.GetAirportById(103);
var air2 = fda.GetAirportById(104);
var flight = new Flight()
{
SourceAirport = air1,
DestinationAirport = air2,
SourceAirportId = air1.Id,
DestinationAirportId = air2.Id,
Price = 250,
Status = true,
DepartureTime = DateTime.Now,
ArrivalTime = DateTime.Now.AddHours(3),
Name = "Random Flight"
};
fda.AddOrUpdateFlight(flight);
}
public void TestMethod1()
{
// Change this string the location of the data files for your systems.
// There is a copy of the file in TestingAndScript -> DataFiles
string DataFilesDirectory = @"D:\Student Data\Downloads\";
string[] lines = System.IO.File.ReadAllLines(DataFilesDirectory + "airports.dat.txt");
List <Airport> airports = new List <Airport>();
List <string> errorEntries = new List <string>();
foreach (string line in lines)
{
string[] airportString = line.Replace("\"", "").Split(',');
try
{
var airport = new Airport
{
Id = Int32.Parse(airportString[0]),
Name = airportString[1],
City = airportString[2],
Country = airportString[3],
Latitude = Double.Parse(airportString[6]),
Longitude = Double.Parse(airportString[7]),
Altitude = Double.Parse(airportString[8]),
TimezoneOffset = Double.Parse(airportString[9]),
DST = airportString[10],
Timezone = airportString[11]
};
airports.Add(airport);
} catch (Exception e)
{
errorEntries.Add(line);
}
}
FlightDataAccess fda = new FlightDataAccess();
fda.LoadAirports(airports);
}
public ProfileController()
{
userDAL = new UserDataAccess();
historyDAL = new HistoryDataAccess();
flightDAL = new FlightDataAccess();
}
public ResultController()
{
flightDAL = new FlightDataAccess();
}
public void EditFlight(Flight flight)
{
FlightDataAccess fda = new FlightDataAccess();
fda.AddOrUpdateFlight(flight);
}
//[Authorize(Roles = "Admin")]
public void DeleteFlights(int flightID)
{
FlightDataAccess fda = new FlightDataAccess();
fda.DeleteFlights(flightID);
}
public void TestingDatabase()
{
FlightDataAccess fda = new FlightDataAccess();
fda.GetAllAirports();
}
public ActionResult AllFlights()
{
FlightDataAccess fda = new FlightDataAccess();
return(View(fda.GetAllFlights()));
}
