/// <summary> /// Delete all the database. /// </summary> public void DeleteFromDB() { FlightCenterProject.CustomerDAOMSSQL customerDAOMSSQL = new FlightCenterProject.CustomerDAOMSSQL(); customerDAOMSSQL.RemoveAll(); FlightCenterProject.FlightDAOMSSQL flightDAOMSSQL = new FlightCenterProject.FlightDAOMSSQL(); flightDAOMSSQL.RemoveAll(); FlightCenterProject.AirlineCompanyDAOMSSQL airlineCompanyDAOMSSQL = new FlightCenterProject.AirlineCompanyDAOMSSQL(); airlineCompanyDAOMSSQL.RemoveAll(); FlightCenterProject.CountryDAOMSSQL countryDAOMSSQL = new FlightCenterProject.CountryDAOMSSQL(); countryDAOMSSQL.RemoveAll(); Message = "The entire database has been deleted"; }
/// <summary> /// Add random number of tickets for every customer that exist in the database. /// </summary> /// <param name="ticket"></param> /// <param name="customers"></param> public void AddTicketsToDB(int ticket, int customers) { FlightCenterProject.FlightDAOMSSQL flightDAOMSSQL = new FlightCenterProject.FlightDAOMSSQL(); IList <FlightCenterProject.Flight> flights = flightDAOMSSQL.GetAll(); FlightCenterProject.CustomerDAOMSSQL customerDAOMSSQL = new FlightCenterProject.CustomerDAOMSSQL(); IList <FlightCenterProject.Customer> customers2 = customerDAOMSSQL.GetAll(); try { if (ticket > 0 && (flights.Count == 0 || customers2.Count == 0)) { throw new YouNeedToHaveFlightsAndCustomersToGetTicketsException("You can not get tickets if you dont have flights or customrs"); } for (int i = 0; i < (ticket * customers); i++) { List <FlightCenterProject.Ticket> tickets = new List <FlightCenterProject.Ticket>(); long flightId = flights[rnd.Next(flights.Count)].Id; long customerId = customers2[rnd.Next(customers2.Count)].Id; bool ThereIsAlreadyATicket = false; foreach (var ticket1 in tickets) { if (ticket1.FlightId == flightId) { if (ticket1.CustomerId == customerId) { ThereIsAlreadyATicket = true; break; } } } if (ThereIsAlreadyATicket == false) { FlightCenterProject.TicketDAOMSSQL ticketDAOMSSQL = new FlightCenterProject.TicketDAOMSSQL(); FlightCenterProject.Ticket ticket1 = new FlightCenterProject.Ticket(flightId, customerId); ticketDAOMSSQL.Add(ticket1); } Percent += Convert.ToInt32(1.0 / Total * 100); Message = $"{i + 1}/{ticket * customers} Tickets created"; } }catch (YouNeedToHaveFlightsAndCustomersToGetTicketsException e) { Message = e.Message; } }
/// <summary> /// Add random customers to the database. /// </summary> /// <param name="customers"></param> public void AddCustomersToDB(int customers) { for (int i = 0; i < customers; i++) { HttpClient client = new HttpClient(); client.BaseAddress = new Uri(URL1); client.DefaultRequestHeaders.Accept.Add( new MediaTypeWithQualityHeaderValue("application/json")); HttpResponseMessage response = client.GetAsync("").Result; if (response.IsSuccessStatusCode) { FlightCenterProject.CustomerDAOMSSQL customerDAOMSSQL = new FlightCenterProject.CustomerDAOMSSQL(); WebResult dataObjects = response.Content.ReadAsAsync <WebResult>().Result; string phoneNum = dataObjects.results[0].phone; string creditCard = dataObjects.results[0].cell;//replace the credit card number. string userName = dataObjects.results[0].login.username; string pass = dataObjects.results[0].login.password; string address = dataObjects.results[0].location.city; string firstName = dataObjects.results[0].name.first; string lastName = dataObjects.results[0].name.last; FlightCenterProject.Customer customer = new FlightCenterProject.Customer(firstName, lastName, userName, pass, address, phoneNum, creditCard); customerDAOMSSQL.Add(customer); } else { Debug.Write((int)response.StatusCode, response.ReasonPhrase); } client.Dispose(); Percent += Convert.ToInt32(1.0 / Total * 100); Message = $"{i + 1}/{customers} Customers created"; } }