public void CustomerFacadeTest()
{
FlightCenterConfig.DeleteDataBase();
long countryId2 = 0;
AirLineDAOMSSQL adao = new AirLineDAOMSSQL();
CountryDAOMSSQL cydao = new CountryDAOMSSQL();
cydao.Add(new Country {
COUNTRY_NAME = "Israel"
});
long countryId1 = cydao.GetCountryId("Israel");
cydao.Add(new Country {
COUNTRY_NAME = "Germany"
});
countryId2 = cydao.GetCountryId("Germany");
long airlineCompanyId1 = adao.GetAirlineCompanyId("ISR91");
adao.Add(new AirlineCompany {
AIRLINE_NAME = "British Airlines", USER_NAME = "British555", PASSWORD = "******", COUNTRY_CODE = countryId2
});
long airlineCompanyId2 = adao.GetAirlineCompanyId("British555");
Flight flight = new Flight(airlineCompanyId1, airlineCompanyId2, countryId1, new DateTime(2019, 05, 10, 10, 30, 00), new DateTime(2019, 05, 10, 15, 05, 00), 15, "HajajaOnile", "555");
LoginToken <Customer> customerLogin = new LoginToken <Customer>();
customerLogin.User = new Customer();
customerLogin.User.USER_NAME = "talGever";
customerLogin.User.PASSWORD = "******";
LoggedInCustomerFacade customerFacade = new LoggedInCustomerFacade();
customerFacade.PurchaseTicket(customerLogin, flight);
}
internal AnonymousUserFacade()
{
LoginToken = null;
_airlineDAO = new AirlineDAOMSSQL();
_flightDAO = new FlightDAOMSSQL();
_countryDAO = new CountryDAOMSSQL();
}
public void GetCountryByNameTest()
{
CountryDAOMSSQL c = new CountryDAOMSSQL();
Country country = c.Get(TestCenter.AirlineToken.User.CountryCode);
Assert.AreEqual(country, TestCenter.AdminFacade.GetCountryByName(TestCenter.AdminToken, country.CountryName));
}
public void DeleteCountryExceptionTest()
{
CountryDAOMSSQL c = new CountryDAOMSSQL();
Country country = c.Get(TestCenter.AirlineToken.User.CountryCode);
TestCenter.AdminFacade.DeleteCountry(TestCenter.AdminToken, country);
}
public void CountryFuncsTest()
{
FlightDAOMSSQL flight = new FlightDAOMSSQL();
flight.RemoveAll();
CountryDAOMSSQL c = new CountryDAOMSSQL();
c.RemoveAll();
AirlineDAOMSSQL airline = new AirlineDAOMSSQL();
airline.RemoveAll();
Country c1, c2;
c1 = new Country("UAE"); c2 = new Country("England");
CountryDAOMSSQL country = new CountryDAOMSSQL();
country.RemoveAll();
country.Add(c1);
country.Add(c2);
country.Remove(c2);
IList <Country> countries = country.GetAll();
Country updatedCountry = country.Get(c1.Id); updatedCountry.CountryName = "Spain";
country.Update((updatedCountry));
Assert.AreEqual(updatedCountry, countries[0]);
}
public void CustomersFuncsTest()
{
FlightDAOMSSQL flight = new FlightDAOMSSQL();
flight.RemoveAll();
CountryDAOMSSQL c = new CountryDAOMSSQL();
c.RemoveAll();
AirlineDAOMSSQL airline = new AirlineDAOMSSQL();
airline.RemoveAll();
Customer cust1 = new Customer("gal", "mazana", "userrr", "123", "afula", "0526614430", "4580982574849111");
Customer cust2 = new Customer("hamody", "zoubi", "hahaaaaa", "321", "ein harod", "0954542323521", "6528429299292");
CustomerDAOMSSQL customer = new CustomerDAOMSSQL();
customer.RemoveAll();
customer.Add(cust1);
customer.Add(cust2);
customer.Remove(cust2);
Customer upddatedCust = customer.Get(cust1.Id); upddatedCust.UserName = "******";
customer.Update(upddatedCust);
IList <Customer> customers = customer.GetAll();
Assert.AreEqual(customers[0], customer.Get(cust1.Id));
}
public void AirlineFuncsTest()
{
FlightDAOMSSQL flight = new FlightDAOMSSQL();
flight.RemoveAll();
CountryDAOMSSQL c = new CountryDAOMSSQL();
c.RemoveAll();
AirlineDAOMSSQL airline = new AirlineDAOMSSQL();
airline.RemoveAll();
AirlineCompany company1 = new AirlineCompany("elal", "elel", "123", 4);
AirlineCompany company2 = new AirlineCompany("turkishairline", "ttt", "123", 3);
AirlineDAOMSSQL aIrLine = new AirlineDAOMSSQL();
aIrLine.RemoveAll();
aIrLine.Add(company1);
aIrLine.Add(company2);
aIrLine.Remove(company1);
AirlineCompany updatedAirlineCompany = aIrLine.Get(company2.Id);
updatedAirlineCompany.Username = "******";
aIrLine.Update(updatedAirlineCompany);
IList <AirlineCompany> companies = aIrLine.GetAll();
Assert.AreEqual(updatedAirlineCompany, aIrLine.GetAirlineByUserName(updatedAirlineCompany.Username));
}
public void CreateNewCountry(LoginToken <Administrator> token, Country country)
{
if (token != null)
{
_countryDAO = new CountryDAOMSSQL();
_countryDAO.Add(country);
}
}
{/// <summary>
/// This class handle connecttion to Dao Anonymous functions
/// </summary>
public AnonymousUserFacade()
{
_flightDAO = new FlightDAOMSSQL();
_airlineDAO = new AirLineDAOMSSQL();
_administratorDAO = new AdministratorDAOMSSQL();
_ticketDAO = new TicketDAOMSSQL();
_customerDAO = new CustomerDAOMMSQL();
_countryDAO = new CountryDAOMSSQL();
}
public void CreateNewCountryTest()
{
CountryDAOMSSQL c = new CountryDAOMSSQL();
Country country = new Country("Las-Vegas");
Assert.AreEqual(c.GetAll().Count, 1);
TestCenter.AdminFacade.CreateNewCountry(TestCenter.AdminToken, country);
Assert.AreEqual(c.GetAll().Count, 2);
}
public bool DataBaseStatus()
{
AirLineDAOMSSQL alDAO = new AirLineDAOMSSQL();
CountryDAOMSSQL cDAO = new CountryDAOMSSQL();
CustomerDAOMSSQL custDAO = new CustomerDAOMSSQL();
if (alDAO.GetAll().Count() == 0 && cDAO.GetAll().Count() == 0 && custDAO.GetAll().Count() == 0)
{
return(true);
}
return(false);
}
public RandomDataGenerator()
{
_random = new Random();
_countryDAO = new CountryDAOMSSQL();
_customerDAO = new CustomerDAOMSSQL();
_airlineDAO = new AirlineDAOMSSQL();
_flightDAO = new FlightDAOMSSQL();
_ticketDAO = new TicketDAOMSSQL();
_countries = new List <Country>();
_customers = new List <Customer>();
_airlineCompanies = new List <AirlineCompany>();
_flights = new List <Flight>();
_tickets = new List <Ticket>();
}
public void AirlineFacadeTest()
{
FlightCenterConfig.DeleteDataBase();
CountryDAOMSSQL cydao = new CountryDAOMSSQL();
cydao.Add(new Country {
COUNTRY_NAME = "Israel"
});
long countryId1 = cydao.GetCountryId("Israel");
cydao.Add(new Country {
COUNTRY_NAME = "Germany"
});
long countryId2 = cydao.GetCountryId("Germany");
AirLineDAOMSSQL adao = new AirLineDAOMSSQL();
adao.Add(new AirlineCompany {
AIRLINE_NAME = "IsrLines", USER_NAME = "ISR91", PASSWORD = "******", COUNTRY_CODE = countryId1
});
long airlineCompanyId1 = adao.GetAirlineCompanyId("ISR91");
adao.Add(new AirlineCompany {
AIRLINE_NAME = "British Airlines", USER_NAME = "British555", PASSWORD = "******", COUNTRY_CODE = countryId2
});
long airlineCompanyId2 = adao.GetAirlineCompanyId("British555");
LoginToken <AirlineCompany> airlineLogin = new LoginToken <AirlineCompany>();
airlineLogin.User = new AirlineCompany();
airlineLogin.User.USER_NAME = "airline4life";
airlineLogin.User.PASSWORD = "******";
LoggedInAirlineFacade airlineFacade = new LoggedInAirlineFacade();
Flight flight = new Flight(airlineCompanyId1, airlineCompanyId2, countryId1, new DateTime(2019, 05, 10, 10, 30, 00), new DateTime(2019, 05, 10, 15, 05, 00), 15, "HajajaOnile", "555");
airlineFacade.CreateFlight(airlineLogin, flight);
FlightDAOMSSQL fdao = new FlightDAOMSSQL();
long flightid = fdao.GetFlightId("555");
Assert.AreEqual(flight, airlineFacade.GetFlightById((int)flightid));
airlineFacade.CancelFlight(airlineLogin, flight);
Assert.IsNotNull(airlineFacade.GetFlightById((int)flightid));
airlineFacade.ChangeMyPassword(airlineLogin, "Na123456", "Aa100200");
Assert.AreEqual("Aa100200", airlineLogin.User.PASSWORD);
}
public void TicketFuncsTest()
{
FlightDAOMSSQL flight = new FlightDAOMSSQL();
flight.RemoveAll();
CountryDAOMSSQL c = new CountryDAOMSSQL();
c.RemoveAll();
AirlineDAOMSSQL airline = new AirlineDAOMSSQL();
airline.RemoveAll();
Ticket t1 = new Ticket(2, 3);
Ticket t2 = new Ticket(4, 1);
TicketDAOMSSQL ticket = new TicketDAOMSSQL();
//ticket.RemoveAll();
//ticket.Add(t1);
//ticket.Add(t2);
}
public void AnonymousrFacadeTest()
{
FlightDAOMSSQL flightsHandler = new FlightDAOMSSQL();
flightsHandler.RemoveAll();
#region filling the flights table
CountryDAOMSSQL c = new CountryDAOMSSQL();
c.RemoveAll();
AirlineDAOMSSQL airline = new AirlineDAOMSSQL();
airline.RemoveAll();
Country c1 = new Country("israel");
c.Add(c1);
AirlineCompany airline1 = new AirlineCompany("eldal", "maher", "123", c1.Id);
airline.Add(airline1);
DateTime t = new DateTime(2019, 05, 05, 21, 22, 44);
DateTime t1 = new DateTime(2019, 08, 29, 22, 33, 22);
Debug.WriteLine(t1.ToString("MM/dd/yy H:mm:ss"));
Flight f1 = new Flight(airline1.Id, c1.Id, c1.Id, t, t1, 22);
flightsHandler.Add(f1);
#endregion
FlyingCenterSystem centerSystem = new FlyingCenterSystem();
AnonymouseUserFacade anonymusefacade = centerSystem.OpenLogInSystem();
Assert.IsNotNull(anonymusefacade);
IList <AirlineCompany> listcomapny = anonymusefacade.GetAllAirlineCompanies();
IList <Flight> flightsList = anonymusefacade.GetAllFlights();
Assert.AreEqual(f1, flightsList[0]);
Dictionary <Flight, int> valuePairs = anonymusefacade.GetAllFlightsVacancy();
Assert.AreEqual(f1.RemainingTickets, valuePairs[f1]);
Flight flightsById = anonymusefacade.GetFlightById(f1.Id);
Assert.AreEqual(f1, flightsById);
IList <Flight> FlightsByDtime = anonymusefacade.GetFlightsByDepartureDate(f1.DepartureTime);
Assert.AreEqual(f1, FlightsByDtime[0]);
IList <Flight> flighsByDesCountryList = anonymusefacade.GetFlightsByDestionationCountry(f1.DistinationCountryCode);
Assert.AreEqual(f1, flighsByDesCountryList[0]);
IList <Flight> FlightsByLandingTimeList = anonymusefacade.GetFlightsByLandingeDate(f1.LandingTime);
Assert.AreEqual(f1, FlightsByLandingTimeList[0]);
IList <Flight> FlightsByOriginCountry = anonymusefacade.GetFlightsByOriginCountry(f1.OriginCountryCode);
Assert.AreEqual(f1, FlightsByOriginCountry[0]);
}
public void TestInitialize()
{
airlineDAO = new AirlineDAOMSSQL();
AirlineDAOMSSQL._connectionString = MyConfig._replicaConnectionString;
ticketDAO = new TicketDAOMSSQL();
TicketDAOMSSQL._connectionString = MyConfig._replicaConnectionString;
flightDAO = new FlightDAOMSSQL();
FlightDAOMSSQL._connectionString = MyConfig._replicaConnectionString;
administratorDAO = new AdministratorDAOMSSQL();
AdministratorDAOMSSQL._connectionString = MyConfig._replicaConnectionString;
customerDAO = new CustomerDAOMSSQL();
CustomerDAOMSSQL._connectionString = MyConfig._replicaConnectionString;
countryDAO = new CountryDAOMSSQL();
CountryDAOMSSQL._connectionString = MyConfig._replicaConnectionString;
centerSystem = FlightCenterSystem.GetInstance();
airlineDAO.RemoveAllReplica();
ticketDAO.RemoveAllReplica();
countryDAO.RemoveAllReplica();
flightDAO.RemoveAllReplica();
customerDAO.RemoveAllReplica();
administratorDAO.RemoveAllReplica();
}
public void TestInitialize()
{
airlineDAO = new AirlineDAOMSSQL();
AirlineDAOMSSQL._connectionString = MyConfig._replicaConnectionString;
ticketDAO = new TicketDAOMSSQL();
TicketDAOMSSQL._connectionString = MyConfig._replicaConnectionString;
flightDAO = new FlightDAOMSSQL();
FlightDAOMSSQL._connectionString = MyConfig._replicaConnectionString;
administratorDAO = new AdministratorDAOMSSQL();
AdministratorDAOMSSQL._connectionString = MyConfig._replicaConnectionString;
customerDAO = new CustomerDAOMSSQL();
CustomerDAOMSSQL._connectionString = MyConfig._replicaConnectionString;
countryDAO = new CountryDAOMSSQL();
CountryDAOMSSQL._connectionString = MyConfig._replicaConnectionString;
airlineDAO.RemoveAllReplica();
ticketDAO.RemoveAllReplica();
countryDAO.RemoveAllReplica();
flightDAO.RemoveAllReplica();
customerDAO.RemoveAllReplica();
administratorDAO.RemoveAllReplica();
facade = new AnnonymousUserFacadeMSSQL();
}
public void FlightFuncsTest()
{
FlightDAOMSSQL flight = new FlightDAOMSSQL();
flight.RemoveAll();
CountryDAOMSSQL c = new CountryDAOMSSQL();
c.RemoveAll();
AirlineDAOMSSQL airline = new AirlineDAOMSSQL();
airline.RemoveAll();
Country c1 = new Country("israel");
c.Add(c1);
AirlineCompany airline1 = new AirlineCompany("eldal", "maher", "123", c1.Id);
airline.Add(airline1);
DateTime t = DateTime.Now;
DateTime t1 = new DateTime(2019, 8, 20, 22, 33, 22);
Flight f1 = new Flight(airline1.Id, c1.Id, c1.Id, t, t1, 22);
flight.Add(f1);
Assert.AreEqual(f1, flight.GetFlighstByOriginCountry(f1.OriginCountryCode)[0]);
}
public long GetCountryId(string countryName)
{
_countryDAO = new CountryDAOMSSQL();
return(_countryDAO.GetCountryId(countryName));
}
public void AirlineComapnyFacadeTest()
{
string username = "******";
string password = "******";
FlightDAOMSSQL flight = new FlightDAOMSSQL();
CountryDAOMSSQL c = new CountryDAOMSSQL();
AirlineDAOMSSQL airline = new AirlineDAOMSSQL();
flight.RemoveAll();
airline.RemoveAll();
c.RemoveAll();
Country c1 = new Country("israel");
c.Add(c1);
DateTime t = DateTime.Now;
DateTime t1 = new DateTime(2019, 08, 29, 22, 33, 22);
AirlineCompany company1 = new AirlineCompany("elal", "elel", "123", c1.Id);
airline.Add(company1);
Flight f1 = new Flight(company1.Id, c1.Id, c1.Id, t, t1, 22);
flight.Add(f1);
FlyingCenterSystem centerSystem = new FlyingCenterSystem();
LoggedInAirlinefacade airlinefacade;
bool filled = false;
centerSystem.OpenLogInSystem(username, password, out airlinefacade, ref filled);
if (filled)
{
IList <AirlineCompany> airlineCompaniesList = airlinefacade.GetAllAirlineCompanies();
Assert.AreEqual(company1, airlineCompaniesList[0]);
IList <Flight> flightsList = airlinefacade.GetAllFlights();
Assert.AreEqual(f1, flightsList[0]);
Dictionary <Flight, int> reaminingTicketMapFlights = airlinefacade.GetAllFlightsVacancy();
Assert.AreEqual(f1.RemainingTickets, reaminingTicketMapFlights[f1]);
IList <Ticket> ticketsOfAirlineCompanyList = airlinefacade.GetAllTickets(airlinefacade.AirlineToken);
Flight flightById = airlinefacade.GetFlightById(f1.Id);
Assert.AreEqual(f1, flightById);
IList <Flight> fflightsByDeparyreTimeList = airlinefacade.GetFlightsByDepartureDate(f1.DepartureTime);
Assert.AreEqual(f1, fflightsByDeparyreTimeList[0]);
IList <Flight> flightsBydestinationCountryList = airlinefacade.GetFlightsByDestionationCountry(c1.Id);
Assert.AreEqual(f1, flightsBydestinationCountryList[0]);
IList <Flight> flightsByLandingTimeList = airlinefacade.GetFlightsByLandingeDate(f1.LandingTime);
Assert.AreEqual(f1, flightsByLandingTimeList[0]);
IList <Flight> flightsByOriginCountryList = airlinefacade.GetFlightsByOriginCountry(c1.Id);
Assert.AreEqual(f1, flightsByOriginCountryList[0]);
f1.RemainingTickets = f1.RemainingTickets - 3;
airlinefacade.UpdateFlight(airlinefacade.AirlineToken, f1);
Dictionary <Flight, int> updatedVanacyMapFligh = airlinefacade.GetAllFlightsVacancy();
Assert.AreEqual(f1.RemainingTickets, updatedVanacyMapFligh[f1]);
//Assert.AreSame(f1, airlinefacade.GetFlightById(f1.Id));
////airlinefacade.CancelFlight(airlinefacade.AirlineToken, f1);
////airlinefacade.ChangeMyPassword(airlinefacade.AirlineToken, "", "");
}
else
{
Assert.AreEqual(2, 3);
}
}
public void AdminFacadeTest()
{
// Deleting database
FlightCenterConfig.DeleteDataBase();
//Creating DAO'S samples to test
long airlineCompanyId1 = 0, airlineCompanyId2 = 0, countryId1 = 0, countryId2 = 0, flightId1 = 0, customerId1 = 0;
AirLineDAOMSSQL adao = new AirLineDAOMSSQL();
FlightDAOMSSQL fdao = new FlightDAOMSSQL();
CustomerDAOMSSQL cdao = new CustomerDAOMSSQL();
CountryDAOMSSQL cydao = new CountryDAOMSSQL();
TicketDAOMSSQL tdao = new TicketDAOMSSQL();
// Adding new countries
cydao.Add(new Country {
COUNTRY_NAME = "Israel"
});
countryId1 = cydao.GetCountryId("Israel");
cydao.Add(new Country {
COUNTRY_NAME = "Germany"
});
countryId2 = cydao.GetCountryId("Germany");
// Adding new Airline companies
adao.Add(new AirlineCompany {
AIRLINE_NAME = "IsrLines", USER_NAME = "ISR91", PASSWORD = "******", COUNTRY_CODE = countryId1
});
airlineCompanyId1 = adao.GetAirlineCompanyId("ISR91");
adao.Add(new AirlineCompany {
AIRLINE_NAME = "British Airlines", USER_NAME = "British555", PASSWORD = "******", COUNTRY_CODE = countryId2
});
airlineCompanyId2 = adao.GetAirlineCompanyId("British555");
// Adding new Flight
fdao.Add(new Flight {
AIRLINECOMPANY_ID = airlineCompanyId1, ORIGIN_COUNTRY_CODE = countryId1, DESTINATION_COUNTRY_CODE = countryId2, DEPARTURE_TIME = new DateTime(2019, 05, 10, 10, 30, 00), LANDING_TIME = new DateTime(2019, 05, 10, 15, 05, 00), REMAINING_TICKETS = 15, AIRLINECOMPANY_NAME = "IsrLines", FLIGHT_NAME = "555"
});
flightId1 = fdao.GetFlightId("555");
// Adding new Customer
cdao.Add(new Customer {
FIRST_NAME = "Efrat", LAST_NAME = "Patihi", USER_NAME = "Efrat_kapara", PASSWORD = "******", ADDRESS = "Netanya , Raziel 40", PHONE_NO = "05011554875", CREDIT_CARD_NUMBER = "123456789"
});
customerId1 = cdao.GetCustomerId("Efrat_kapara");
// Adding new Ticket
tdao.Add(new Tickets {
CUSTOMER_ID = customerId1, FLIGHT_ID = flightId1
});
// Testing
FlyingCenterSystem fcs = FlyingCenterSystem.GetInstance();
LoginToken <Administrator> adminLogin = new LoginToken <Administrator>();
adminLogin.User = new Administrator();
adminLogin.User.AdminUserName = "******";
adminLogin.User.Password = "******";
// Trying to login
fcs.login.TryAdminLogin(adminLogin.User.AdminUserName, adminLogin.User.Password, out LoginToken <Administrator> adminToken);
fcs.login.TryAirlineLogin("ISR91", "Is789", out LoginToken <AirlineCompany> airlineToken);
fcs.login.TryCustomerLogin("Efrat_kapara", "Efi93", out LoginToken <Customer> customerToken);
// Testing admin facade fucntions
LoggedInAdministratorFacade adminFacadae = fcs.GetFacade(adminLogin) as LoggedInAdministratorFacade;
adminFacadae.CreateNewCountry(adminLogin, new Country {
COUNTRY_NAME = "Israel"
});
AirlineCompany airline = new AirlineCompany()
{
AIRLINE_NAME = "Nassa",
USER_NAME = "Nassa28",
PASSWORD = "******",
COUNTRY_CODE = adminFacadae.GetCountryId("Israel")
};
adminFacadae.CreateNewAirline(adminLogin, airline);
Assert.AreEqual(adminFacadae.GetAirlineByUserame("Nassa28"), airline);
Customer cust = new Customer()
{
FIRST_NAME = "Tal",
LAST_NAME = "Rdt",
USER_NAME = "TalGever",
PASSWORD = "******",
ADDRESS = "Hazfira 20, Pardes hanna",
PHONE_NO = "0505001245",
CREDIT_CARD_NUMBER = "456123456789"
};
adminFacadae.CreateNewCustomer(adminLogin, cust);
Assert.AreEqual(cust, adminFacadae.GetCustomerByUserName("TalGever")); // works
adminFacadae.UpdateAirlineDetails(adminLogin, new AirlineCompany {
AIRLINE_NAME = "Nasa4Life", USER_NAME = "Nassa28", PASSWORD = "******", COUNTRY_CODE = adminFacadae.GetCountryId("Israel")
});
adminFacadae.UpdateCustomerDetails(adminLogin, new Customer {
FIRST_NAME = "Tal", LAST_NAME = "Rdt", USER_NAME = "TalGever", PASSWORD = "******", ADDRESS = "Raziel 50 , Netanya", PHONE_NO = "0505001245", CREDIT_CARD_NUMBER = "456123456789"
});
AirlineCompany airl = new AirlineCompany()
{
AIRLINE_NAME = "Nasa4Life",
USER_NAME = "Nassa28",
PASSWORD = "******",
COUNTRY_CODE = adminFacadae.GetCountryId("Israel")
};
adminFacadae.RemoveAirline(adminLogin, airl);
}
