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); }
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); }
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); }
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."); } }
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."); } }
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."); } }