public void CancelFlight() { countryDAO.Add(new Country("Israel")); airlineDAO.Add(new AirlineCompany("ELAL", "ELALUSERNAME", "ELALPASSEORD", countryDAO.GetCountryByName("Israel").ID)); airlineDAO.Add(new AirlineCompany("ARKIA", "ARKIAYSERNAME", "ARKIAPASSWORD", countryDAO.GetCountryByName("Israel").ID)); flightDAO.Add(new Flight(airlineDAO.GetAirlineByName("ELAL").ID, countryDAO.GetCountryByName("Israel").ID, countryDAO.GetCountryByName("Israel").ID, new DateTime(DateTime.Now.Year + 1, 12, 2), new DateTime(DateTime.Now.Year + 1, 12, 3), 30, FlightStatus.NotDeparted)); flightDAO.Add(new Flight(airlineDAO.GetAirlineByName("ARKIA").ID, countryDAO.GetCountryByName("Israel").ID, countryDAO.GetCountryByName("Israel").ID, new DateTime(DateTime.Now.Year + 1, 12, 2), new DateTime(DateTime.Now.Year + 1, 12, 3), 30, FlightStatus.NotDeparted)); customerDAO.Add(new Customer("FIRSTNAME", "LASTNAME", "USERNAME", "PASSWORD", "ADDRESS", "PNUMBER", "CNUMBER")); ticketDAO.Add(new Ticket(flightDAO.GetAll()[0].ID, customerDAO.GetCustomerByUsername("USERNAME").ID)); ticketDAO.Add(new Ticket(flightDAO.GetAll()[1].ID, customerDAO.GetCustomerByUsername("USERNAME").ID)); Assert.AreEqual(2, flightDAO.GetAll().Count); Assert.AreEqual(2, ticketDAO.GetAll().Count); LoginToken <AirlineCompany> airlineLoggenIn = new LoginToken <AirlineCompany>(); airlineLoggenIn.user = airlineDAO.GetAirlineByName("ELAL"); facade.CancelFlight(airlineLoggenIn, flightDAO.GetAll()[0]); Assert.AreEqual(1, flightDAO.GetAll().Count); Assert.AreEqual(1, ticketDAO.GetAll().Count); }
internal void AddRandomTickets(int number) { int counter = 0; try { for (int i = 0; i < _customers.Count; i++) { Customer c = _customerDAO.GetCustomerByUserName(_customers[i].UserName); for (int j = 0; j < number; j++) { Ticket t = new Ticket(); t.CustomerID = c.Id; _randomNum = _random.Next(0, _flights.Count); t.FlightID = _flights[_randomNum].ID; if (!_tickets.Any(ticket => ticket.FlightID == t.FlightID && ticket.CustomerID == t.CustomerID)) { _ticketDAO.Add(t); _tickets.Add(t); counter++; } } ProgressValue += Convert.ToInt32(1.0 / Total * 100); } Message += $"Created Airline Tickets {counter}/ {number} per customer\n"; } catch (Exception e) { Message += $"{e.ToString()}\n"; } }
public void AddTicketsToCustomer(LoginToken <Administrator> token, long customerId, long flightId) { _ticketDAO = new TicketDAOMSSQL(); Tickets ticket = new Tickets(customerId, flightId); _ticketDAO.Add(ticket); }
public void GetAllTicketsTest() { t.ClearTables(); t.FillDBForTest(); AirlineCompany a = new AirlineCompany("airfrance", "airfrance", "134567", t.adminFacade.GetCountryByName(t.adminToken, "Israel").ID); t.adminFacade.CreateNewAirline(t.adminToken, a); t.airLineToken.User = a; Customer c = new Customer("Einat", "Mor", "Einat123", "191919", "Katzenelson", "0545552809", "000004400"); t.customerToken.User = c; t.adminFacade.CreateNewCustomer(t.adminToken, c); Flight flight = new Flight(a.ID, a.CountryCode, a.CountryCode, new DateTime(2019, 10, 10), new DateTime(2019, 10, 10), 1); t.airLineToken.User = a; t.airlineFacade.CreateFlight(t.airLineToken, flight); Ticket ticket = new Ticket(flight.ID, c.ID); TicketDAOMSSQL ticketDAOMSSQL = new TicketDAOMSSQL(); ticketDAOMSSQL.Add(ticket); Assert.AreEqual(t.airlineFacade.GetAllTickets(t.airLineToken).Count, 1); }
public void CancelTicket() { countryDAO.Add(new Country("Israel")); airlineDAO.Add(new AirlineCompany("ELAL", "ELALUSERNAME", "ELALPASSEORD", countryDAO.GetCountryByName("Israel").ID)); flightDAO.Add(new Flight(airlineDAO.GetAirlineByName("ELAL").ID, countryDAO.GetCountryByName("Israel").ID, countryDAO.GetCountryByName("Israel").ID, new DateTime(DateTime.Now.Year + 1, 12, 2), new DateTime(DateTime.Now.Year + 1, 12, 3), 30, FlightStatus.NotDeparted)); Flight flightOne = flightDAO.GetAll()[0]; customerDAO.Add(new Customer("FIRSTNAME", "LASTNAME", "USERNAME", "PASSWORD", "ADDRESS", "PNUMBER", "CNUMBER")); customerDAO.Add(new Customer("FIRSTNAME2", "LASTNAME2", "USERNAME2", "PASSWORD2", "ADDRESS2", "PNUMBER2", "CNUMBER2")); Customer customerOne = customerDAO.GetAll()[0]; Customer customerTwo = customerDAO.GetAll()[1]; LoginToken <Customer> customerLoggedIn = new LoginToken <Customer>(); customerLoggedIn.user = customerOne; ticketDAO.Add(new Ticket(flightOne.ID, customerOne.ID)); ticketDAO.Add(new Ticket(flightOne.ID, customerTwo.ID)); Ticket ticketOne = ticketDAO.GetAll()[0]; flightOne = flightDAO.GetAll()[0]; Assert.AreEqual(28, flightOne.RemainingTickets); facade.CancelTicket(customerLoggedIn, ticketOne); flightOne = flightDAO.GetAll()[0]; Assert.AreEqual(29, flightOne.RemainingTickets); Assert.AreEqual(1, ticketDAO.GetAll().Count); }
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); }
private void Add_Click(object sender, RoutedEventArgs e) { // Creating new customer. Customer newCustomer = new Customer { FIRST_NAME = "Iliya", LAST_NAME = "Tsvibel", USER_NAME = "Iliya", PASSWORD = "******", ADDRESS = "Rishon", PHONE_NO = "0546800559", CREDIT_CARD_NUMBER = "12345" }; adminFacade.CreateNewCustomer(defaultToken, newCustomer); // Creating new country. Country country = null; country = new Country(); for (int i = 0; i < ListOfCountries.CountryNames.Length; i++) { country = countryDAO.GetByName(ListOfCountries.CountryNames[i]); if (country == null) { Country newCountry = new Country { COUNTRY_NAME = ListOfCountries.CountryNames[i] }; adminFacade.CreateNewCountry(defaultToken, newCountry); } } // Creating new administrator. Administrator newAdmin = new Administrator { FIRST_NAME = "Iliya", LAST_NAME = "Tsvibel", USER_NAME = "Admin", PASSWORD = "******" }; adminFacade.CreateNewAdmin(defaultToken, newAdmin); //Creating new airline. //AirlineCompany newAirline = new AirlineCompany //{ // AIRLINE_NAME = "Aeroflot", // USER_NAME = "Vladimir", // COUNTRY_CODE = adminFacade.GetCountryByName("Germany").ID, // PASSWORD = "******" //}; //adminFacade.CreateNewAirline(defaultToken, newAirline); AirlineCompany airline = null; airline = new AirlineCompany(); long countryStartID = 0; countryStartID = countryDAO.GetByName(ListOfCountries.CountryNames[0]).ID; for (int i = 0; i < ListOfAirlinesCompanies.AirlineNames.Length; i++) { airline = airlineDAO.GetAirlineByName(ListOfAirlinesCompanies.AirlineNames[i]); if (airline == null) { AirlineCompany newAirline = new AirlineCompany { AIRLINE_NAME = ListOfAirlinesCompanies.AirlineNames[i], USER_NAME = "UserName-" + ListOfAirlinesCompanies.AirlineNames[i], PASSWORD = random.Next(1000, 10000).ToString(), COUNTRY_CODE = random.Next(Convert.ToInt32(countryStartID), (Convert.ToInt32(countryStartID) + ListOfCountries.CountryNames.Length)) }; adminFacade.CreateNewAirline(defaultToken, newAirline); } } // Creating new flight. Flight flight = new Flight { AIRLINECOMPANY_ID = adminFacade.GetAirlineByName(adminToken, "SOLAR CARGO, C.A.").ID, DEPARTURE_TIME = DateTime.Now, LANDING_TIME = DateTime.Now + TimeSpan.FromHours(1), ORIGIN_COUNTRY_CODE = adminFacade.GetCountryByName("Germany").ID, DESTINATION_COUNTRY_CODE = adminFacade.GetCountryByName("Germany").ID, REMAINING_TICKETS = 250 }; //airlineFacade.CreateFlight(defaultAirlioneToken, flight); flightDAO.Add(flight); // Creating new ticket. Ticket tickets = new Ticket { FLIGHT_ID = anonFacade.GetFlightsByDestinationCountryForTest(adminFacade.GetCountryByName("Germany").ID).ID, CUSTOMER_ID = adminFacade.GetCustomerByUserName(adminToken, "Iliya").ID }; //customerFacade.PurchaseTicket(defaultCustomerToken, tickets); ticketDAO.Add(tickets); MessageBox.Show($"All data successfully added"); }
public void AddTicket(Tickets ticket) { _ticketDAO = new TicketDAOMSSQL(); _ticketDAO.Add(ticket); }