private static void ListOfDestinationsAndCreationOfTraveler(AgencyModel dbConnection)
{
Console.WriteLine("____________________________________");
Console.WriteLine("List of destinations:");
Console.WriteLine("____________________________________");
var destinations = dbConnection.Destination.ToList();
for (int i = 0; i < destinations.Count; i++)
{
Console.WriteLine("------------------------------");
Console.WriteLine("Destination Id: " + destinations[i].Id);
Console.WriteLine("Country: " + destinations[i].Country);
Console.WriteLine("City: " + destinations[i].City);
}
Console.WriteLine("");
Console.WriteLine("Create a new Traveler!");
var addTraveler = new Travelers();
Console.WriteLine("Register a name: ");
addTraveler.Name = Console.ReadLine();
Console.WriteLine("Register an agency Id, available agency ID's 1,2 and 5: ");
addTraveler.AgencyID = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Choose the destination by id from the destination list above: ");
addTraveler.DestinationID = Convert.ToInt32(Console.ReadLine());
dbConnection.Travelers.Add(addTraveler);
dbConnection.SaveChanges();
Console.WriteLine("The information has been saved on the database!");
}
private static void DeleteTraveler(AgencyModel dbConnection)
{
Console.WriteLine("____________________________");
Console.WriteLine("____________________________________");
Console.WriteLine("List of travelers:");
Console.WriteLine("____________________________________");
var travelers = dbConnection.Travelers.ToList();
for (int i = 0; i < travelers.Count; i++)
{
Console.WriteLine("------------------------------");
Console.WriteLine("Traveler id: " + travelers[i].Id);
Console.WriteLine("Traveler Name: " + travelers[i].Name);
}
int answer = 0;
Console.WriteLine("____________________________________");
Console.WriteLine("Type which traveler you want to delete by giving TravelerId:");
answer = int.Parse(Console.ReadLine());
var selectedPerson = dbConnection.Travelers.Find(answer);
if (selectedPerson != null)
{
dbConnection.Travelers.Remove(selectedPerson);
dbConnection.SaveChanges();
}
Console.WriteLine("The selected person has been deleted from the database!");
}
private static void DeleteDestination(AgencyModel dbConnection)
{
Console.WriteLine("____________________________________");
Console.WriteLine("List of destinations:");
Console.WriteLine("____________________________________");
var destinations = dbConnection.Destination.ToList();
for (int i = 0; i < destinations.Count; i++)
{
Console.WriteLine("------------------------------");
Console.WriteLine("Destination Id: " + destinations[i].Id);
Console.WriteLine("Country: " + destinations[i].Country);
Console.WriteLine("City: " + destinations[i].City);
}
int dest = 0;
Console.WriteLine("____________________________________");
Console.WriteLine("Type which destination you want to delete by giving DestinationId:");
dest = int.Parse(Console.ReadLine());
var selectedDest = dbConnection.Destination.Find(dest);
if (selectedDest != null)
{
dbConnection.Destination.Remove(selectedDest);
dbConnection.SaveChanges();
}
Console.WriteLine("The selected destination has been deleted from the database!");
}
private static void DestinationCreation(AgencyModel dbConnection)
{
Console.WriteLine("____________________________");
Console.WriteLine("Create a new destination!");
var addDestination = new Destination();
Console.WriteLine("Register a city: ");
addDestination.City = Console.ReadLine();
Console.WriteLine("Register a Country: ");
addDestination.Country = Console.ReadLine();
dbConnection.Destination.Add(addDestination);
dbConnection.SaveChanges();
Console.WriteLine("The information has been saved on the database!");
}
static void Main(string[] args)
{
using (AgencyModel dbConnection = new AgencyModel())
{
// Update Traveler
var selectedUpTraveler = dbConnection.Travelers.Where(f => f.Name == "Delil").FirstOrDefault();
// Here you choose which Traveler you want to change
// In this case we change Delil to Bkörn
if (selectedUpTraveler != null)
{
selectedUpTraveler.Name = "Björn";
dbConnection.SaveChanges();
}
// Update Destination
var selectedUpDestination = dbConnection.Destination.Where(p => p.Country == "Turkey").FirstOrDefault();
// Here you choose which counry and city you would like to change
// In this case we change Turkey to Sweden and östersund as city
if (selectedUpDestination != null)
{
selectedUpDestination.Country = "Sweden"; // County changes
selectedUpDestination.City = "Östersund"; // City C changes
dbConnection.SaveChanges();
// Note that sometimes there is same country name with different city in the destination list
}
bool listRunning = true;
while (listRunning)
{
char ch;
ShowMenu();
ch = Char.Parse(Console.ReadLine());
switch (ch)
{
case '1':
ShowAgencies(dbConnection);
Console.WriteLine("Press [ENTER] to go back to the menu");
Console.ReadLine();
Console.Clear();
break;
case '2':
ShowTravelers(dbConnection);
Console.WriteLine("Press [ENTER] to go back to the menu");
Console.ReadLine();
Console.Clear();
break;
case '3':
ListOfDestinationsAndCreationOfTraveler(dbConnection);
Console.WriteLine("Press [ENTER] to go back to the menu");
Console.ReadLine();
Console.Clear();
break;
case '4':
DestinationCreation(dbConnection);
Console.WriteLine("Press [ENTER] to go back to the menu");
Console.ReadLine();
Console.Clear();
break;
case '5':
DeleteTraveler(dbConnection);
Console.WriteLine("Press [ENTER] to go back to the menu");
Console.ReadLine();
Console.Clear();
break;
case '6':
DeleteDestination(dbConnection);
Console.WriteLine("Press [ENTER] to go back to the menu");
Console.ReadLine();
Console.Clear();
break;
}
}
}
}
