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 PurchaseTicketException() { TicketDAOMSSQL t = new TicketDAOMSSQL(); Flight Flight = new Flight(TestCenter.AirlineToken.User.Id, TestCenter.AirlineToken.User.CountryCode, TestCenter.AirlineToken.User.CountryCode, new DateTime(2020, 10, 10, 10, 00, 00), new DateTime(2020, 10, 11, 10, 00, 00), 0); TestCenter.AirlineFacade.CreateFlight(TestCenter.AirlineToken, Flight); TestCenter.CustomerFacade.PurchaseTicket(TestCenter.CustomerToken, Flight); }
{/// <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 List <Tickets> GetAllTickets(LoginToken <AirlineCompany> token) { List <Tickets> tickets = new List <Tickets>(); if (token != null) { _ticketDAO = new TicketDAOMSSQL(); tickets = _ticketDAO.GetAll(); } return(tickets); }
public void PurchaseTicketTest() { TicketDAOMSSQL t = new TicketDAOMSSQL(); Assert.AreEqual(t.GetAll().Count, 0); Flight Flight = new Flight(TestCenter.AirlineToken.User.Id, TestCenter.AirlineToken.User.CountryCode, TestCenter.AirlineToken.User.CountryCode, new DateTime(2020, 10, 10, 10, 00, 00), new DateTime(2020, 10, 11, 10, 00, 00), 100); TestCenter.AirlineFacade.CreateFlight(TestCenter.AirlineToken, Flight); Assert.AreEqual(TestCenter.AdminFacade.GetFlightById(Flight.Id).RemainingTickets, Flight.RemainingTickets); TestCenter.CustomerFacade.PurchaseTicket(TestCenter.CustomerToken, Flight); Assert.AreEqual(t.GetAll().Count, 1); Assert.AreEqual(TestCenter.AdminFacade.GetFlightById(Flight.Id).RemainingTickets, Flight.RemainingTickets - 1); }
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>(); }
private void timer_Elapsed(object sender) { string time = ConfigurationManager.AppSettings["ClearHistoryTime"].ToString(); int hour = Convert.ToInt32(time); int now = DateTime.Now.Hour; if (now >= hour) { TicketDAOMSSQL t = new TicketDAOMSSQL(); FlightDAOMSSQL f = new FlightDAOMSSQL(); t.MoveToTicketsHistory(); f.MoveToFlightsHistory(); } }
public void TestGetFlightByID() { test = new TestInfo(); Country testCountry = new Country("usa"); testCountry.ID = test.adminF.CreateNewCountry(test.adminT, testCountry); Flight flight = new Flight(test.airlineT.User.ID, testCountry.ID, testCountry.ID, DateTime.ParseExact("2019-07-08 12:00:00", "yyyy-MM-dd HH:mm:ss", null), DateTime.ParseExact("2019-07-18 12:00:00", "yyyy-MM-dd HH:mm:ss", null), 5); FlightDAOMSSQL Fdao = new FlightDAOMSSQL(); flight.ID = Fdao.ADD(flight); TicketDAOMSSQL tDAO = new TicketDAOMSSQL(); Assert.AreEqual(flight.RemaniningTickets, test.airlineF.GetFlightById(flight.ID).RemaniningTickets); }
public void TestCancelTicket() { test = new TestInfo(); Country testCountry = new Country("usa"); testCountry.ID = test.adminF.CreateNewCountry(test.adminT, testCountry); Flight flight = new Flight(test.airlineT.User.ID, testCountry.ID, testCountry.ID, DateTime.ParseExact("2019-07-08 12:00:00", "yyyy-MM-dd HH:mm:ss", null), DateTime.ParseExact("2019-07-18 12:00:00", "yyyy-MM-dd HH:mm:ss", null), 5); FlightDAOMSSQL Fdao = new FlightDAOMSSQL(); flight.ID = Fdao.ADD(flight); Ticket t = test.customerF.PurchaseTicket(test.customerT, flight); TicketDAOMSSQL tDAO = new TicketDAOMSSQL(); test.customerF.CancelTicket(test.customerT, t); Assert.AreEqual(0, tDAO.Get(t.ID).ID); }
public void CancleTicketTest() { Flight Flight = new Flight(TestCenter.AirlineToken.User.Id, TestCenter.AirlineToken.User.CountryCode, TestCenter.AirlineToken.User.CountryCode, new DateTime(2020, 10, 10, 10, 00, 00), new DateTime(2020, 10, 11, 10, 00, 00), 100); TestCenter.AirlineFacade.CreateFlight(TestCenter.AirlineToken, Flight); Ticket ticket = new Ticket(Flight.Id, TestCenter.CustomerToken.User.Id); ticket.Id = TestCenter.CustomerFacade.PurchaseTicket(TestCenter.CustomerToken, Flight).Id; TicketDAOMSSQL t = new TicketDAOMSSQL(); Assert.AreEqual(t.GetAll().Count, 1); Assert.AreEqual(Flight.RemainingTickets - 1, TestCenter.CustomerFacade.GetFlightById(Flight.Id).RemainingTickets); TestCenter.CustomerFacade.CancelTicket(TestCenter.CustomerToken, ticket); Assert.AreEqual(TestCenter.CustomerFacade.GetAllMyFlights(TestCenter.CustomerToken).Count, 0); Assert.AreEqual(Flight.RemainingTickets, TestCenter.CustomerFacade.GetFlightById(Flight.Id).RemainingTickets); }
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 CancelFlight(LoginToken <AirlineCompany> token, Flight flight) { if (token != null) { if (flight.REMAINING_TICKETS > 0) { _ticketDAO = new TicketDAOMSSQL(); Tickets t = new Tickets(); t = _ticketDAO.GetTicketByFlightId((int)flight.ID); _ticketDAO.Remove(t); } if (flight.REMAINING_TICKETS == 0) { _flightDAO = new FlightDAOMSSQL(); _flightDAO.Remove(flight); } } }
public IHttpActionResult CancelTicket([FromUri] int ticketid) { LoginToken <Customer> customerToken = (LoginToken <Customer>)Request.Properties["customerToken"]; LoggedInCustomerFacade custFacade = (LoggedInCustomerFacade)Request.Properties["customerFacade"]; TicketDAOMSSQL ticketDAO = new TicketDAOMSSQL(); Ticket ticket = ticketDAO.Get(ticketid); if (ticket == null || ticket.ID <= 0) { return(NotFound()); } try { custFacade.CancelTicket(customerToken, ticket); return(Ok()); } catch (Exception e) { return(Content(HttpStatusCode.NotAcceptable, e.Message)); } }
public void PurchaseTicket_OutOfTickets_Test() { 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; Flight flight = new Flight(a.ID, a.CountryCode, a.CountryCode, new DateTime(2019, 10, 10), new DateTime(2019, 10, 10), 0); t.airlineFacade.CreateFlight(t.airLineToken, flight); Customer c = new Customer("Einat", "Mor", "Einat123", "191919", "Katzenelson", "0545552809", "000004400"); t.adminFacade.CreateNewCustomer(t.adminToken, c); t.customerToken.User = c; t.customerFacade.PurchaseTicket(t.customerToken, flight); TicketDAOMSSQL ticketDAOMSSQL = new TicketDAOMSSQL(); }
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 TestCustomerFacade() { ResetWhatIsNeeded(); FlyingCenterSystem flyingCenterSystem = FlyingCenterSystem.GetFlyingCenterSystem(); //sign in as a airline company LoginToken <AirlineCompany> companyLoginToken = flyingCenterSystem.AttemptLoginAirlineCompany("company", "company"); LoggedInAirlineFacade loggedInAirlineFacade = (LoggedInAirlineFacade)flyingCenterSystem.GetFacade(companyLoginToken); //create 4 flights DateTime now = DateTime.Now; loggedInAirlineFacade.CreateFlight(companyLoginToken, new Flight(-1, companyLoginToken.User.ID, 1, 3, now.AddHours(1), now.AddHours(2), 10, 10)); loggedInAirlineFacade.CreateFlight(companyLoginToken, new Flight(-1, companyLoginToken.User.ID, 1, 3, now.AddHours(2), now.AddHours(3), 10, 10)); loggedInAirlineFacade.CreateFlight(companyLoginToken, new Flight(-1, companyLoginToken.User.ID, 1, 3, now.AddHours(3), now.AddHours(4), 10, 10)); loggedInAirlineFacade.CreateFlight(companyLoginToken, new Flight(-1, companyLoginToken.User.ID, 1, 3, now.AddHours(4), now.AddHours(5), 10, 10)); IList <Flight> flights = loggedInAirlineFacade.GetFlightsByDestinationCountry(3); //login as the customer LoginToken <Customer> customer = flyingCenterSystem.AttemptLoginCustomer("customer", "customer"); LoggedInCustomerFacade loggedInCustomerFacade = (LoggedInCustomerFacade)flyingCenterSystem.GetFacade(customer); //buy a ticket for 4 flights loggedInCustomerFacade.PurchaseTicket(customer, flights[0]); loggedInCustomerFacade.PurchaseTicket(customer, flights[1]); loggedInCustomerFacade.PurchaseTicket(customer, flights[2]); loggedInCustomerFacade.PurchaseTicket(customer, flights[3]); TicketDAOMSSQL _ticketDAO = new TicketDAOMSSQL(); IList <Ticket> tickets = _ticketDAO.GetAll(); Assert.IsTrue(LookForTicket(tickets, customer.User.ID, flights[0].ID)); Assert.IsTrue(LookForTicket(tickets, customer.User.ID, flights[1].ID)); Assert.IsTrue(LookForTicket(tickets, customer.User.ID, flights[2].ID)); Assert.IsTrue(LookForTicket(tickets, customer.User.ID, flights[3].ID)); Assert.AreEqual(4, loggedInCustomerFacade.GetAllMyFlights(customer).Count); loggedInCustomerFacade.CancelTicket(customer, tickets[0]); loggedInCustomerFacade.CancelTicket(customer, tickets[1]); loggedInCustomerFacade.CancelTicket(customer, tickets[2]); loggedInCustomerFacade.CancelTicket(customer, tickets[3]); tickets = _ticketDAO.GetAll(); Assert.IsTrue(tickets.Count == 0); flights = loggedInAirlineFacade.GetFlightsByDestinationCountry(3); Assert.IsTrue(flights[0].RemainingTickets == 10); Assert.IsTrue(flights[1].RemainingTickets == 10); Assert.IsTrue(flights[2].RemainingTickets == 10); Assert.IsTrue(flights[3].RemainingTickets == 10); }
public Tickets GetTicketByFlightId(int id) { _ticketDAO = new TicketDAOMSSQL(); return(_ticketDAO.GetTicketByFlightId(id)); }
public void AddTicket(Tickets ticket) { _ticketDAO = new TicketDAOMSSQL(); _ticketDAO.Add(ticket); }
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); }