public void TestDAOConnection()
{
FlightCenterConfig.DeleteDataBase();
AirLineDAOMSSQL al = new AirLineDAOMSSQL();
Assert.AreEqual(true, al.ExUserNameInCustomers("TALAR"));
}
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);
}
public void UpdateAirlineDetails(LoginToken <Administrator> token, AirlineCompany airline)
{
if (token != null)
{
_airlineDAO = new AirLineDAOMSSQL();
_airlineDAO.Update(airline);
}
}
public void RemoveAirline(LoginToken <Administrator> token, AirlineCompany airline)
{
if (token != null)
{
_airlineDAO = new AirLineDAOMSSQL();
_airlineDAO.Remove(airline);
}
}
public void MofidyAirlineDetails(LoginToken <AirlineCompany> token, AirlineCompany airline)
{
if (token != null)
{
_airlineDAO = new AirLineDAOMSSQL();
_airlineDAO.Update(airline);
}
}
public void CreateNewAirline(LoginToken <Administrator> token, AirlineCompany airline)
{
if (token != null)
{
_airlineDAO = new AirLineDAOMSSQL();
_airlineDAO.Add(airline);
}
}
{/// <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 AirlineCompany GetAirlineByUserName(LoginToken <AirlineCompany> token, string userName)
{
if (token != null)
{
_airlineDAO = new AirLineDAOMSSQL();
return(_airlineDAO.GetAirlineByUserame(userName));
}
return(null);
}
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 bool TryAirLineLogin(string password, string userName, out LoginToken <AirLineCompany> loginToken)
{
bool res = false;
loginToken = null;
AirLineCompany comp = null;
_airLineDAO = new AirLineDAOMSSQL();
comp = _airLineDAO.GetAirLineByUserName(userName);
if (!(comp is null))
{
if (comp.password != password)
{
throw new WrongPasswordException("entered password is not correct");
}
else
{
loginToken = new LoginToken <AirLineCompany>();
loginToken.User = comp;
res = true;
}
}
return(res);
}
public AirlineCompany GetAirlineByUserame(string name)
{
_airlineDAO = new AirLineDAOMSSQL();
return(_airlineDAO.GetAirlineByUserame(name));
}
public List <AirlineCompany> GetAllAirlineCompanies()
{
_airlineDAO = new AirLineDAOMSSQL();
return(_airlineDAO.GetAll());
}
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);
}
public long GetAirLineIdByUserName(string userName)
{
_airlineDAO = new AirLineDAOMSSQL();
return(_airlineDAO.GetAirlineCompanyId(userName));
}
public long GetRandomAirlineId()
{
_airlineDAO = new AirLineDAOMSSQL();
return(_airlineDAO.GetRandomAirlineId());
}
public long GetRandomFlightID()
{
_airlineDAO = new AirLineDAOMSSQL();
return(_airlineDAO.GetRandomFlightID());
}
public long GetFlightID(string flightName)
{
_airlineDAO = new AirLineDAOMSSQL();
return(_airlineDAO.GetFlightID(flightName));
}
public string GetAirlineNameByID(int id)
{
_airlineDAO = new AirLineDAOMSSQL();
return(_airlineDAO.GetAirlineNameByID(id));
}
