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 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 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 List <Adopter> ReturnAdopterList()
{
DatabaseConnectionDataContext database = new DatabaseConnectionDataContext();
var list = database.Adopters.OrderBy(o => o.AdopterName).Select(s => s).ToList();
return(list);
}
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);
}
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));
}
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();
}
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);
}
}
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 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);
}
}
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);
}
}
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.");
}
}