public static void AddAnimalToDb()
{
// Create animal
var animalName = "";
var numberOfSeen = 0;
var lastSeen = "";
System.Console.WriteLine("What is the name of the species?");
animalName = Console.ReadLine();
System.Console.WriteLine("How many times have you seen this animal?");
numberOfSeen = int.Parse(Console.ReadLine());
System.Console.WriteLine("And where did you last see the per-Animal?");
// Similar to creating object within Js
var newAnimal = new SeenAnimals
{
Species = animalName,
CountOfTimesSeen = numberOfSeen,
LocationOfLastSeen = lastSeen
};
// Similar to appending to the DOM
var db = new SafariVacationContext();
db.SeenAnimalsTable.Add(newAnimal);
db.SaveChanges();
}
public ActionResult <SeenAnimals> Post([FromBody] SeenAnimals seenAnimals)
{
var db = new SeenAnimalsContext();
db.SeenAnimals.Add(seenAnimals);
db.SaveChanges();
return(seenAnimals);
}
public ActionResult <SeenAnimals> AddAnimals([FromBody] SeenAnimals incomingSeenAnimals)
{
var db = new SafariVacationContext();
db.SeenAnimals.Add(incomingSeenAnimals);
db.SaveChanges();
return(incomingSeenAnimals);
}
public ActionResult <SeenAnimals> Post([FromBody] SeenAnimals animals)
{
var db = new SafariVacationContext();
db.SeenAnimals.Add(animals);
db.SaveChanges();
return(animals);
}
public ActionResult <SeenAnimals> Put([FromRoute] int id, [FromBody] SeenAnimals updatedData)
{
var db = new SeenAnimalsContext();
var seenAnimals = db.SeenAnimals.FirstOrDefault(animals => animals.Id == id);
seenAnimals.Species = updatedData.Species;
seenAnimals.CountOfTimesSeen = updatedData.CountOfTimesSeen;
seenAnimals.LocationOfLastSeen = updatedData.LocationOfLastSeen;
db.SaveChanges();
return(updatedData);
}
public ActionResult <SeenAnimals> Post([FromBody] string species)
{
var animal = new SeenAnimals
{
Species = species,
LocationOfLastSeen = "Africa",
CountOfTimesSeen = 1,
};
this.db.SeenAnimals.Add(animal);
this.db.SaveChanges();
return(animal);
}
public ActionResult <SeenAnimals> Delete([FromBody] string species)
{
var animal = new SeenAnimals {
Species = species,
};
var db = new SafariAdventureContext();
db.SeenAnimals.Add(animal);
db.SaveChanges();
return(animal);
}
public ActionResult <SeenAnimals> Put([FromBody] string species)
{
var animal = new SeenAnimals {
Species = species,
LocationOfLastSeen = "outside",
};
var db = new SafariAdventureContext();
db.SeenAnimals.Add(animal);
db.SaveChanges();
return(animal);
}
static void Main(string[] args)
{
Console.WriteLine("What Animals Did You See Today?");
var species = Console.ReadLine();
var newAnimal = new SeenAnimals {
Species = species
};
var db = new Safari_VacationContext();
db.SeenAnimalsTable.Add(newAnimal);
db.SaveChanges();
var AllAnimals = db.SeenAnimalsTable;
foreach (var animal in AllAnimals)
{
System.Console.WriteLine(value: $"AllAnimals:{animal.Species}");
}
}
public ActionResult <object> UpdateSeenAnimals([FromRoute] int id, [FromBody] SeenAnimals newInformation)
{
var db = new SafariVacationContext();
var seenanimal = db.SeenAnimals.FirstOrDefault(animal => animal.Id == id);
if (seenanimal != null)
{
seenanimal.Species = newInformation.Species;
seenanimal.CountOfTimesSeen = newInformation.CountOfTimesSeen;
seenanimal.LocationOfLastSeen = newInformation.LocationOfLastSeen;
db.SaveChanges();
return(Ok(seenanimal));
}
else
{
return(NotFound());
}
}
static void Main(string[] args)
{
using (var db = new SafariVacationContext())
{
//Prompt user for what they want to do to their Safari Collection.
Console.WriteLine("(A)dd an animal.");
Console.WriteLine("(D)isplay all animals from the Safari thus far.");
Console.WriteLine("(U)pdate an animal.");
Console.WriteLine("(S)pecial commands.");
var userAction = Console.ReadLine();
userAction = userAction.ToUpper();
switch (userAction)
{
case "A":
addAnimal();
break;
case "D":
displayAnimals();
break;
case "U":
updateAnimal();
break;
case "S":
specialPrompts();
break;
default:
Console.WriteLine("Please choose a valid option!");
break;
}
void addAnimal()
{
Console.WriteLine("Please tell me what animal you want to add!");
var _animalSpecies = Console.ReadLine();
//Create a new SeenAnimals instance called newSpecies and assign it a species.
var _newSpecies = new SeenAnimals {
Species = _animalSpecies
};
if (_animalSpecies != "")
{
//Add the new SeenAnimals instance to the SeenAnimalsTable in the SafariVacation database.
//Technically, we are just adding the newSpecies to a DbSet<SeenAnimals> in C#, which
//connects to the SQL server and adds a new row into the SeenAnimalsTable.
db.SeenAnimalsTable.Add(_newSpecies);
//commits changes from C# to the database.
db.SaveChanges();
}
else
{
//If no user input, display message below.
Console.WriteLine("Nothing to add");
}
}
void displayAnimals()
{
//Display all of the animals that the user has seen
var _allSeenAnimals = db.SeenAnimalsTable;
foreach (var _animal in _allSeenAnimals)
{
Console.WriteLine($"Animal seen: {_animal.Species}");
}
}
void updateAnimal()
{
Console.WriteLine("Please tell me what animal you want to update!");
var _animalSpecies = Console.ReadLine();
Console.WriteLine("How many times did you see this animal?");
var _animalSeenCount = Console.ReadLine();
Console.WriteLine("Where did you last see this animal?");
var _animalLocationSeen = Console.ReadLine();
//Update the CountOfTimesSeen and LocationOfLastSeen for an animal
var animalToUpdate = db.SeenAnimalsTable.FirstOrDefault(animal => animal.Species == _animalSpecies);
//Update properties of the selected animal.
animalToUpdate.CountOfTimesSeen = int.Parse(_animalSeenCount);
animalToUpdate.LocationOfLastSeen = _animalLocationSeen;
//commits changes from C# to the database.
db.SaveChanges();
}
void displayAnimalsFromLocation()
{
Console.WriteLine("From what location would you like to display all of the animals?");
var _location = Console.ReadLine();
var animalsToDisplay = db.SeenAnimalsTable.Where(animal => animal.LocationOfLastSeen == _location);
Console.WriteLine($"Animals from {_location}");
foreach (var _animalSpecies in animalsToDisplay)
{
Console.WriteLine($"Animal seen: {_animalSpecies.Species}");
}
}
void removeAnimalsFromLocation()
{
Console.WriteLine("From what location would you like to remove all of the animals?");
var _location = Console.ReadLine();
var animalsToRemove = db.SeenAnimalsTable.Where(animal => animal.LocationOfLastSeen == _location);
foreach (var _animalSpecies in animalsToRemove)
{
db.SeenAnimalsTable.Remove(_animalSpecies);
}
db.SaveChanges();
}
void getTotalCountSeen()
{
var _totalCount = 0;
var _allSeenAnimals = db.SeenAnimalsTable;
foreach (var _animal in _allSeenAnimals)
{
_totalCount += _animal.CountOfTimesSeen;
}
Console.WriteLine($"You have seen a total of {_totalCount} animals!");
}
void getTotalCountSeenWizardsOfOzEdition()
{
var _totalCount = 0;
var _allWizardOfOzAnimals = db.SeenAnimalsTable.Where(animal => animal.Species == "Lion" || animal.Species == "Tiger" || animal.Species == "Bear");
foreach (var _animal in _allWizardOfOzAnimals)
{
_totalCount += _animal.CountOfTimesSeen;
}
Console.WriteLine($"You have seen a total of {_totalCount} animals of Wizard type!");
}
void specialPrompts()
{
Console.WriteLine("(D)isplay all animals from a specific location.");
Console.WriteLine("(R)emove all animals from a specific location.");
Console.WriteLine("(G)et total count of all animals you have seen.");
Console.WriteLine("(W)izards of Oz edition: total count of lions, tigers, and bears seen.");
var specialUserAction = Console.ReadLine();
specialUserAction = specialUserAction.ToUpper();
switch (specialUserAction)
{
case "D":
displayAnimalsFromLocation();
break;
case "R":
removeAnimalsFromLocation();
break;
case "G":
getTotalCountSeen();
break;
case "W":
getTotalCountSeenWizardsOfOzEdition();
break;
default:
Console.WriteLine("Please choose a valid option!");
break;
}
}
}
}
public ActionResult <SeenAnimals> AddAnimal([FromBody] SeenAnimals animalToAdd)
{
db.SeenAnimals.Add(animalToAdd);
db.SaveChanges();
return(animalToAdd);
}
