예제 #1
0
        public static void UpdateToAnimals()
        {
            // Update animals in db
            var animalOption = 0;

            System.Console.WriteLine("Would you like to update the number of sightings [1] or last location [2]");
            animalOption = int.Parse(Console.ReadLine());
            if (animalOption == 1)
            {
                var whichSpecies = "";
                var newSightings = 0;
                System.Console.WriteLine("Which species?");
                whichSpecies = Console.ReadLine();
                System.Console.WriteLine("What is the new value? for # of sightings?");
                newSightings = int.Parse(Console.ReadLine());
                // Initialize database
                var db = new SafariVacationContext();
                var CountOfTimesSeenToUpdate = db.SeenAnimalsTable.FirstOrDefault(animal => animal.Species == whichSpecies);
                CountOfTimesSeenToUpdate.CountOfTimesSeen = newSightings;
                db.SaveChanges();
            }
            else
            {
                var whichSpecies = "";
                var newLastSeen  = "";
                System.Console.WriteLine("Which species?");
                whichSpecies = Console.ReadLine();
                System.Console.WriteLine("Where is the last location you saw this animal?");
                newLastSeen = Console.ReadLine();
                var db = new SafariVacationContext();
                var LocationOfLastSeenToUpdate = db.SeenAnimalsTable.FirstOrDefault(animal => animal.Species == whichSpecies);
                LocationOfLastSeenToUpdate.LocationOfLastSeen = newLastSeen;
                db.SaveChanges();
            }
        }
예제 #2
0
        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();
        }
예제 #3
0
        public static void ReadAllAnimals()
        {
            // Read all animals in db
            var db      = new SafariVacationContext();
            var animals = db.SeenAnimalsTable;

            // SELECT * From SeenAnimals
            foreach (var animal in animals)
            {
                System.Console.WriteLine($"There is a {animal.Species}, last seen at {animal.LocationOfLastSeen}");
            }
        }
예제 #4
0
        static void Main(string[] args)
        {
            var userInput = 0;

            while (true)
            {
                userInput = Greeting();
                if (userInput == 1)
                {
                    AddAnimalToDb();
                }
                else if (userInput == 2)
                {
                    ReadAllAnimals();
                    System.Console.WriteLine("\n");
                }
                else if (userInput == 3)
                {
                    UpdateToAnimals();
                }
                else if (userInput == 4)
                {
                    // Delete animals
                    var whichSpecies = "";
                    System.Console.WriteLine("Which species would you like to eradicate?");
                    whichSpecies = Console.ReadLine();
                    var db             = new SafariVacationContext();
                    var animalToDelete = db.SeenAnimalsTable.FirstOrDefault(animal => animal.Species == whichSpecies);
                    db.SeenAnimalsTable.Remove(animalToDelete);
                    db.SaveChanges();
                }
                else
                {
                    var optionsInput = 0;
                    System.Console.WriteLine("1: Will show you animals in the Jungle");
                    System.Console.WriteLine("2: Will REMOVE animals from the Desert");
                    System.Console.WriteLine("3: Get total number of animal sights");
                    System.Console.WriteLine("4: Get total of lions, tigers, and bears");
                    if (optionsInput == 1)
                    {
                        var db            = new SafariVacationContext();
                        var jungleAnimals = db.SeenAnimalsTable.Where(animals => animals.LocationOfLastSeen == "Jungle");
                        foreach (var jungleAnimal in jungleAnimals)
                        {
                            System.Console.WriteLine(jungleAnimal);
                        }
                    }
                    else if (optionsInput == 2)
                    {
                        var db            = new SafariVacationContext();
                        var desertAnimals = db.SeenAnimalsTable.Where(animals => animals.LocationOfLastSeen == "Desert");
                        db.SeenAnimalsTable.RemoveRange(desertAnimals);
                        db.SaveChanges();
                    }
                    else if (optionsInput == 3)
                    {
                        var db = new SafariVacationContext();
                        var totalAnimalsSeen = db.SeenAnimalsTable.Sum(c => c.CountOfTimesSeen);
                        System.Console.WriteLine(totalAnimalsSeen);
                    }
                    else if (optionsInput == 4)
                    {
                        var db = new SafariVacationContext();
                        var totalAnimalsSeen = db.SeenAnimalsTable
                                               .Where(w => w.Species == "lions" || w.Species == "bears" || w.Species == "tigers")
                                               .Sum(c => c.CountOfTimesSeen);
                        System.Console.WriteLine(totalAnimalsSeen);
                    }
                }
            }
        }