public Pet(int id, string name, Breed breed, Spieces spieces, Sanctuary sanctuary, int age, int gender, double weight, double bills, DateTime rescueD, string picturePath)
{
this.id = id;
this.name = name;
this.breed = breed;
this.spieces = spieces;
this.sanctuary = sanctuary;
this.age = age;
this.gender = gender;
this.weight = weight;
this.bills = bills;
this.rescueD = rescueD;
this.picturePath = picturePath;
}
// Method that returns a list of Sanctuary objects with the details from the DB
public static List<Sanctuary> LoadSanctuaries()
{
List<Sanctuary> sancuaries = new List<Sanctuary>();
OleDbConnection myConnection = GetConnection();
string myQuery = "SELECT * FROM sanctuaries";
OleDbCommand myCommand = new OleDbCommand(myQuery, myConnection);
try
{
myConnection.Open();
OleDbDataReader myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
Sanctuary sanctuary = new Sanctuary(int.Parse(myReader["id"].ToString()), myReader["name"].ToString());
sancuaries.Add(sanctuary);
}
return sancuaries;
}
catch (Exception ex)
{
Console.WriteLine("Exception in DBHandler", ex);
return null;
}
finally
{
myConnection.Close();
}
}
