public void AddingCountries(string countryTB)
{
Flights_project.CountryDAOMSSQL countryDAOMSSQL = new Flights_project.CountryDAOMSSQL();
CountryList.AddRange(countryDAOMSSQL.GetAll());
HttpWebRequest WebReq = (HttpWebRequest)WebRequest.Create(string.Format("https://restcountries.eu/rest/v2"));
WebReq.Method = "GET";
HttpWebResponse WebResp = (HttpWebResponse)WebReq.GetResponse();
string jsonString;
using (Stream stream = WebResp.GetResponseStream())
{
StreamReader reader = new StreamReader(stream, System.Text.Encoding.UTF8);
jsonString = reader.ReadToEnd();
}
List <RootCountryObject> items = JsonConvert.DeserializeObject <List <RootCountryObject> >(jsonString);
int counter = 0;
foreach (var a in items)
{
int CountryRecordeAmount = Int32.Parse(countryTB);
Flights_project.Country c = new Flights_project.Country(a.name);
countryDAOMSSQL.Add(c);
c = countryDAOMSSQL.GetCountryByName(c.CountryName);
CountryList.Add(c);
_vm.Current += 1;
_vm.Status = (_vm.Current / Total) * 100;
// ProgressBarWork();
if (++counter > CountryRecordeAmount)
{
break;
}
}
}
static void Main(string[] args)
{
//************************************* CUSTOMER CLASS ***************************************
// ******* Add ********
//Flights_project.Customer cust = new Flights_project.Customer("Roy", "Mor", "roy", "5656", "Hata'as 10 Givatayim", "0545556329", "334466778891");
Flights_project.CustomerDAOMSSQL customerDAOMSSQL = new Flights_project.CustomerDAOMSSQL();
//customerDAOMSSQL.Add(cust);
// ******* Get ********
Flights_project.Customer c = customerDAOMSSQL.Get(4);
// Console.WriteLine(c.FirstName, c.LastName, c.ID, c.Password, c.Address, c.CreditCardNumber,c);
// ******* GetALL ********
//IList<Flights_project.Customer> Allcust = customerDAOMSSQL.GetAll();
//for (int i = 0; i < Allcust.Count; i++)
//{
// Console.WriteLine(Allcust[i].ToString());
//}
//****** GET_CUSTOMER_BY_USER_NAME ******
//Flights_project.Customer cust = customerDAOMSSQL.GetCustomerByUserName("roy");
//cust.LastName = "levy";
//Console.WriteLine(cust);
//****** [REMOVE_CUSTOMER] ******
//customerDAOMSSQL.Remove(cust);
//****** [UPDATE_CUSTOMER] ******
//customerDAOMSSQL.Update(cust);
//******************************************************************************************************
//******************************************************************************************************
//******************************************************************************************************
//************************************* COUNTRY CLASS ***************************************
Flights_project.CountryDAOMSSQL countryDAOMSSQL = new Flights_project.CountryDAOMSSQL();
Flights_project.Country Italy = new Flights_project.Country("Italy");
Flights_project.Country Spain = new Flights_project.Country("Spain");
// ******* Add ********
//countryDAOMSSQL.Add(Italy);
//countryDAOMSSQL.Add(Spain);
// ******* Get ********
//Flights_project.Country c = countryDAOMSSQL.Get(8);
//Console.WriteLine(c);
//******* GetALL ********
//IList <Flights_project.Country> list = countryDAOMSSQL.GetAll();
//for (int i = 0; i < list.Count; i++)
//{
// Console.WriteLine(list[i]);
//}
//******* remove ********
//countryDAOMSSQL.Remove(c);
//******* Update ********
//c.CountryName = "German";
//countryDAOMSSQL.Update(c);
//******************************************************************************************************
//******************************************************************************************************
//******************************************************************************************************
//************************************* AIRLINE CLASS ***************************************
Flights_project.AirLineDAOMSSQL airLineDAOMSSQL = new Flights_project.AirLineDAOMSSQL();
Flights_project.AirlineCompany Iberia = new Flights_project.AirlineCompany("Iberia", "Iberia", "2323", 16);
// ******* Add ********
//airLineDAOMSSQL.Add(Iberia);
// ******* Get ********
Flights_project.AirlineCompany a = airLineDAOMSSQL.Get(6);
//Console.WriteLine(a);
//******* GetALL ********
//IList<Flights_project.AirlineCompany> list = airLineDAOMSSQL.GetAll();
//for (int i = 0; i < list.Count; i++)
//{
// Console.WriteLine(list[i]);
//}
//******* GetAirLineByCountry ********
//List< Flights_project.AirlineCompany> a = airLineDAOMSSQL.GetAirLineByCountry(16);
//for (int i = 0; i < a.Count; i++)
//{
// Console.WriteLine(a[i]);
//}
//******* [GET_AIR_LINE_BY_USER_NAME] ********
//Flights_project.AirlineCompany a = airLineDAOMSSQL.GetAirLineByUserName("AIR_FRANCE");
//Console.WriteLine(a);
//******* remove ********
//airLineDAOMSSQL.Remove(a);
//******* Update ********
//a.AirlineName = "IBERIA";
//a.UserName = "******";
//airLineDAOMSSQL.Update(a);
//countryDAOMSSQL.Update(c);
//******************************************************************************************************
//******************************************************************************************************
//******************************************************************************************************
//************************************* FLIGHT CLASS ***************************************
Flights_project.FlightDAOMSSQL flightDAOMSSQL = new Flights_project.FlightDAOMSSQL();
DateTime D = new DateTime(2019, 7, 3, 23, 00, 00);
DateTime L = new DateTime(2019, 7, 4, 07, 00, 00);
Flights_project.Flight T5325 = new Flights_project.Flight(6, 16, 8, D, L, 543);
// ******* Add ********
//flightDAOMSSQL.Add(T5325);
// ******* Get ********
Flights_project.Flight f = flightDAOMSSQL.GetFlightById(7);
//Console.WriteLine(f);
//******* GetALL ********
//IList<Flights_project.Flight> list = flightDAOMSSQL.GetAll();
//for (int i = 0; i < list.Count; i++)
//{
// Console.WriteLine(list[i]);
//}
//******* [GET_ALL_FLIGHT_VACANCY] ********
//Dictionary<Flights_project.Flight, int> list = flightDAOMSSQL.GetAllFlightsVacancy();
//foreach (KeyValuePair<Flights_project.Flight, int> fly in list)
//{
// Console.WriteLine($"key:{fly.Key}, value:{fly.Value}");
//}
//******* GetFlightById ********
//Flights_project.Flight f = flightDAOMSSQL.GetFlightById(6);
//Console.WriteLine(f);
//******* GetFlightsByCustomer ********
//List<Flights_project.Flight> cust_flights = flightDAOMSSQL.GetFlightsByCustomer(c);
//for (int i = 0; i < cust_flights.Count; i++)
//{
// Console.WriteLine(cust_flights[i]);
//}
//******* GetFlightsByDepatureDate ********
//List<Flights_project.Flight> cust_flights = flightDAOMSSQL.GetFlightsByDepatureDate(D);
//for (int i = 0; i < cust_flights.Count; i++)
//{
// Console.WriteLine(cust_flights[i]);
//}
//******* GetFlightsByDestinationCountry ********
//List<Flights_project.Flight> cust_flights = flightDAOMSSQL.GetFlightsByDestinationCountry(1);
//for (int i = 0; i < cust_flights.Count; i++)
//{
// Console.WriteLine(cust_flights[i]);
//}
//******* GetFlightsByLandingDate ********
//List<Flights_project.Flight> cust_flights = flightDAOMSSQL.GetFlightsByLandingDate(D);
//for (int i = 0; i < cust_flights.Count; i++)
//{
// Console.WriteLine(cust_flights[i]);
//}
//******* GetFlightsByOriginCountry ********
//List<Flights_project.Flight> cust_flights = flightDAOMSSQL.GetFlightsByOriginCountry(1);
//for (int i = 0; i < cust_flights.Count; i++)
//{
// Console.WriteLine(cust_flights[i]);
//}
//******* remove ********
//flightDAOMSSQL.Remove(f);
//******* Update ********
//f.OriginCountryCode = 14;
//flightDAOMSSQL.Update(f);
//******************************************************************************************************
//******************************************************************************************************
//******************************************************************************************************
//******************************************************************************************************
//******************************************************************************************************
//******************************************************************************************************
//************************************* Tickets CLASS ***************************************
Flights_project.TicketDAOMSSQL ticketDAOMSSQL = new Flights_project.TicketDAOMSSQL();
Flights_project.Ticket ticket = new Flights_project.Ticket(7, 4);
// ******* Add ********
//ticketDAOMSSQL.Add(ticket);
// ******* Get ********
Flights_project.Ticket t = ticketDAOMSSQL.Get(10);
//Console.WriteLine(t);
//******* GetALL ********
//IList<Flights_project.Ticket> list = ticketDAOMSSQL.GetAll();
//for (int i = 0; i < list.Count; i++)
//{
// Console.WriteLine(list[i]);
//}
//******* remove ********
//ticketDAOMSSQL.Remove(t);
//******* Update ********
//t.FlightID =
//******************************************************************************************************
//******************************************************************************************************
//******************************************************************************************************
}
