Beispiel #1
0
        public static Adopter SaveAdopterToDatabase(string name, string phone, bool homeOwner, bool newPetOwner, string bio)
        {
            DatabaseConnectionDataContext database = new DatabaseConnectionDataContext();

            Adopter newAdopter = new Adopter();

            newAdopter.AdopterName        = name;
            newAdopter.AdopterPhone       = phone;
            newAdopter.AdopterHomeOwner   = homeOwner;
            newAdopter.AdopterNewPetOwner = newPetOwner;
            newAdopter.AdopterBio         = bio;

            database.Adopters.InsertOnSubmit(newAdopter);

            try
            {
                database.SubmitChanges();
                Console.WriteLine($"New Adopter {newAdopter.AdopterName} successfully added.");
            }
            catch (Exception e)
            {
                Console.Write(e);
                Console.WriteLine("Something went wrong while saving the new adopter to the database.");
            }

            return(newAdopter);
        }
Beispiel #2
0
        public static bool SaveRoomToDatabase(int?animalID, int roomID)
        {
            DatabaseConnectionDataContext database = new DatabaseConnectionDataContext();

            var room =
                (from r in database.Rooms
                 where r.RoomID == roomID
                 select r).First();

            if (room.AnimalID == null)
            {
                room.AnimalID = animalID;
            }
            else
            {
                Console.Write("Room Occupied. Select a different Room.");
                Console.WriteLine("Available Rooms: ");
                PrintAvailableRooms();
                return(false);
            }
            try
            {
                database.SubmitChanges();
                Console.WriteLine($"Successfully moved {room.Animal.AnimalName} to room #{room.RoomID}");
            }
            catch
            {
                Console.WriteLine("Something went wrong while accessing room in database. Check ID.");
            }
            return(true);
        }
Beispiel #3
0
        public static Animal SaveAnimalToDatabase(int species, string name, string sex, int age, double weight, string color, double food, bool shots)
        {
            DatabaseConnectionDataContext database = new DatabaseConnectionDataContext();

            Animal newAnimal = new Animal();

            newAnimal.AnimalSpecies = species;
            newAnimal.AnimalName    = name;
            newAnimal.AnimalSex     = sex;
            newAnimal.AnimalAge     = age;
            newAnimal.AnimalWeight  = weight;
            newAnimal.AnimalColor   = color;
            newAnimal.AnimalFood    = food;
            newAnimal.AnimalShots   = shots;
            newAnimal.AnimalAdopted = false;

            database.Animals.InsertOnSubmit(newAnimal);

            try
            {
                database.SubmitChanges();
            }
            catch (Exception e)
            {
                Console.Write(e);
            }

            return(newAnimal);
        }
Beispiel #4
0
        public static List <Adopter> ReturnAdopterList()
        {
            DatabaseConnectionDataContext database = new DatabaseConnectionDataContext();

            var list = database.Adopters.OrderBy(o => o.AdopterName).Select(s => s).ToList();

            return(list);
        }
Beispiel #5
0
        public static List <Animal> FilterBySpecies(int speciesCode)
        {
            DatabaseConnectionDataContext database = new DatabaseConnectionDataContext();

            var list = database.Animals.Where(w => w.AnimalSpecies == speciesCode).Where(ww => ww.AnimalAdopted == false).Select(s => s).ToList();

            return(list);
        }
Beispiel #6
0
        public static void PrintAvailableRooms()
        {
            DatabaseConnectionDataContext database = new DatabaseConnectionDataContext();

            var room = database.Rooms.Where(r => r.AnimalID == null).Select(s => s.RoomID.ToString()).ToList();

            Console.WriteLine(room.Aggregate((x, y) => x + ", " + y));
        }
Beispiel #7
0
        public static void PrintAnimals(bool adopted)
        {
            DatabaseConnectionDataContext database = new DatabaseConnectionDataContext();

            var animals = database.Animals.Where(w => w.AnimalAdopted == adopted).Select(s => s.AnimalID.ToString() + " " + s.AnimalName.ToString() + " "
                                                                                         + s.AnimalSpecy.SpeciesName);

            Console.WriteLine(string.Join("\n", animals));

            Console.WriteLine();
        }
Beispiel #8
0
        public static Room GetRoom(Animal animal)
        {
            DatabaseConnectionDataContext database = new DatabaseConnectionDataContext();

            try
            {
                var room = database.Rooms.Where(w => w.AnimalID == animal.AnimalID).Select(s => s).First();

                return(room);
            }
            catch
            {
                return(null);
            }
        }
Beispiel #9
0
        public static void RemoveAnimalFromRoom(int roomID)
        {
            DatabaseConnectionDataContext database = new DatabaseConnectionDataContext();
            var room = database.Rooms.Where(r => r.RoomID == roomID).Select(s => s).First();

            room.AnimalID = null;
            try
            {
                database.SubmitChanges();
            }
            catch
            {
                Console.WriteLine("Something went wrong while searching for Animal. Check ID.");
            }
        }
Beispiel #10
0
        public static Adopter GetAdopter(int adopterID)
        {
            DatabaseConnectionDataContext database = new DatabaseConnectionDataContext();

            try
            {
                var adopter = database.Adopters.Where(w => w.AdopterID == adopterID).Select(s => s).First();

                return(adopter);
            }
            catch
            {
                Console.WriteLine("Adopter not found please check ID or add new adopter.");
                return(null);
            }
        }
Beispiel #11
0
        public static Animal GetAnimal(int animalID)
        {
            DatabaseConnectionDataContext database = new DatabaseConnectionDataContext();

            try
            {
                var animal = database.Animals.Where(w => w.AnimalID == animalID).Select(s => s).First();

                return(animal);
            }
            catch
            {
                Console.WriteLine("Animal ID not found please check ID and try again.");
                return(null);
            }
        }
Beispiel #12
0
        public static void UpdateAnimal(Animal updatedAnimal)
        {
            DatabaseConnectionDataContext database = new DatabaseConnectionDataContext();

            var animal = database.Animals.Where(w => w.AnimalID == updatedAnimal.AnimalID).Select(s => s).First();

            animal.AnimalAge    = updatedAnimal.AnimalAge;
            animal.AnimalWeight = updatedAnimal.AnimalWeight;
            animal.AnimalFood   = updatedAnimal.AnimalFood;
            animal.AnimalShots  = updatedAnimal.AnimalShots;

            try
            {
                database.SubmitChanges();
                Console.WriteLine("Animal updated successfully.");
            }
            catch
            {
                Console.WriteLine("Something went wrong while updating the animal.");
            }
        }
Beispiel #13
0
        public static void SaveAdoptionToDatabase(Adopter adopter, Animal animal)
        {
            DatabaseConnectionDataContext database = new DatabaseConnectionDataContext();
            var a = database.Adopters.Where(w => w.AdopterID == adopter.AdopterID).Select(s => s).First();
            var b = database.Animals.Where(w => w.AnimalID == animal.AnimalID).Select(s => s).First();
            var c = database.Rooms.Where(w => w.AnimalID == animal.AnimalID).Select(s => s).First();

            a.AdopterNewPetOwner = false;
            b.AnimalAdopted      = true;
            b.AnimalAdopterID    = a.AdopterID;
            b.DateAdopted        = DateTime.Now;
            RemoveAnimalFromRoom(c.RoomID);

            try
            {
                database.SubmitChanges();
                Console.WriteLine($"{adopter.AdopterName} you are the new owner of the {animal.AnimalSpecy.SpeciesName} {animal.AnimalName}!");
            }
            catch
            {
                Console.WriteLine("Something went wrong updating the adopter and/or animal in the database.");
            }
        }