public void AnimalPropsTest() { //if chip is longer than 5 digits, just add the first 5; cat = new Cat("123456", simpleDate, "testAnimal", "badHabits"); Assert.AreEqual("12345", cat.ChipRegistrationNumber, "Chip failed when more than 5 digits are inserted"); //if chip is shorter than 5, add zeros before the chip until the chip has 5 digits cat = new Cat("1234", simpleDate, "testAnimal", "badHabits"); Assert.AreEqual("01234", cat.ChipRegistrationNumber, "Chip failed when less than 5 digits were inserted"); //Check rest of properties; Assert.AreEqual(simpleDate, cat.DateOfBirth, "Incorrect DateOfBirth"); Assert.AreEqual("testAnimal", cat.Name, "Incorrect Name"); Assert.AreEqual("01234, 06-11-1996, testAnimal, not reserved, badhabits: badHabits", cat.ToString()); //test null birthdate for cat cat = new Cat("1234", null, "testAnimal", "badHabits"); Assert.AreEqual("01234, 00-00-0000, testAnimal, not reserved, badhabits: badHabits", cat.ToString()); //test "" badhabits cat = new Cat("1234", null, "testAnimal", ""); Assert.AreEqual("01234, 00-00-0000, testAnimal, not reserved, badhabits: none", cat.ToString()); //special dog test Assert.AreEqual("12345, 06-11-1996, testdog, not reserved, lastWalkDate: 06-11-1996", dog.ToString()); dog = new Dog("12345", null, null, null); dog.IsReserved = true; Assert.AreEqual("12345, 00-00-0000, noname, reserved, lastWalkDate: 00-00-0000", dog.ToString()); }
public void TestConstructor() { Cat cat = new Cat("123456", new SimpleDate(01, 05, 1997), "Gerrit", ""); Assert.AreEqual(cat.ChipRegistrationNumber, "12345"); Assert.AreEqual(cat.DateOfBirth.Day, 01); Assert.AreEqual(cat.DateOfBirth.Month, 05); Assert.AreEqual(cat.DateOfBirth.Year, 1997); Assert.AreEqual(cat.BadHabits, ""); Assert.AreEqual(cat.IsReserved, false); Assert.AreEqual(cat.Name, "Gerrit"); Assert.AreEqual(cat.Price, 60); cat = new Cat("123", new SimpleDate(12, 03, 2015), "Henk", "Pees everywhere"); Assert.AreEqual(cat.ChipRegistrationNumber, "00123"); Assert.AreEqual(cat.DateOfBirth.Day, 12); Assert.AreEqual(cat.DateOfBirth.Month, 03); Assert.AreEqual(cat.DateOfBirth.Year, 2015); Assert.AreEqual(cat.BadHabits, "Pees everywhere"); Assert.AreEqual(cat.IsReserved, false); Assert.AreEqual(cat.Name, "Henk"); Assert.AreEqual(cat.Price, 45); cat = new Cat("12345", new SimpleDate(12, 03, 2015), "Henk", "Pees everywhere. Bad cat and does not listen really well. Also bites everyone he sees"); Assert.AreEqual(cat.BadHabits, "Pees everywhere. Bad cat and does not listen really well. Also bites everyone he sees"); Assert.AreEqual(cat.Price, 20); cat.IsReserved = true; Assert.AreEqual(cat.IsReserved, true); }
public void TestToString() { Cat cat = new Cat("123", new SimpleDate(12, 03, 2015), "Henk", "Pees everywhere"); string catstring = cat.ToString(); Assert.AreEqual(catstring, "00123, 12-03-2015, Henk, not reserved, 45, Pees everywhere"); cat = new Cat("12345", null, "", ""); cat.IsReserved = true; catstring = cat.ToString(); Assert.AreEqual(catstring, "12345, 00-00-0000, noname, reserved, 60, "); }
public void AnimalComparing() { cat = new Cat("99999", simpleDate, "testAnimal", "badHabits"); Cat cat2 = new Cat("00000", simpleDate, "testAnimal", "badHabits"); administration.Add(cat); administration.Add(cat2); administration.Animallist.Sort(); Assert.AreEqual(cat2, administration.Animallist[0]); }
public void TestChipNumberFromCatTooShort() { Cat cat3 = new Cat("9876", new SimpleDate(8, 1, 2005), "Reserved", "Sven", ""); Assert.AreEqual("09876", cat3.ChipRegistrationNumber); }
public void TestCatPrice20() { Cat cat2 = new Cat("98765", new SimpleDate(8, 1, 2005), "Sven", "Reserved", "Sloopt gordijnen en gooit plantenbakken van de vensterbank af"); cat2.SetPrice(); Assert.AreEqual(20, cat2.Price); }
public void Initialize() { cat = new Cat("98765", new SimpleDate(8, 1, 2005), "Sven", "not reserved", ""); dog = new Dog("65432", new SimpleDate(6, 7, 2006), "Tristan", "not reserved", new SimpleDate(6, 10, 2015)); dog.SetPrice(); }
public void ReadAnimals(bool local) { if (local) { try { using (FileStream FS = new FileStream("objects.bin", FileMode.Open, FileAccess.Read)) { BinaryFormatter BF = new BinaryFormatter(); animals = (List<Animal>)BF.Deserialize(FS); } } catch (FileNotFoundException FNFE) { Console.WriteLine(FNFE.Message); } } else { using (OracleConnection connection = Database.Connection) { string sqlquery = "SELECT CHIPREGISTRATIONNUMBER, DATEOFBIRTH, NAME, RESERVED, PRICE, LASTWALKDATE, BADHABITS FROM ANIMALS"; OracleCommand OC = new OracleCommand(sqlquery, connection); OracleDataReader ODR = OC.ExecuteReader(); string ChipRegistrationNumber = ""; string Name = ""; string BadHabits = ""; SimpleDate DateOfBirth = null; SimpleDate LastWalkDate = null; bool Reserved = false; decimal Price = 0; //List<Animal> animal = new List<Animal>(); while (ODR.Read()) { ChipRegistrationNumber = ODR["CHIPREGISTRATIONNUMBER"].ToString(); Name = ODR["NAME"].ToString(); BadHabits = ODR["BADHABITS"].ToString(); DateTime DT = DateTime.Parse(ODR["DATEOFBIRTH"].ToString()); DateOfBirth = new SimpleDate(DT.Day, DT.Month, DT.Year); if (ODR["LASTWALKDATE"].ToString() != "") { DT = DateTime.Parse(ODR["LASTWALKDATE"].ToString()); } LastWalkDate = new SimpleDate(DT.Day, DT.Month, DT.Year); Reserved = Convert.ToBoolean(ODR["RESERVED"]); Price = Convert.ToDecimal(ODR["PRICE"]); if (BadHabits != "") { Cat cat = new Cat(ChipRegistrationNumber, DateOfBirth, Name, BadHabits); cat.IsReserved = Reserved; animals.Add(cat); } else { Dog dog = new Dog(ChipRegistrationNumber, DateOfBirth, Name, LastWalkDate); dog.IsReserved = Reserved; animals.Add(dog); } } } } }
/// <summary> /// Insert a new animal into the database /// </summary> /// <param name="animal"></param> /// <returns></returns> public bool InsertAnimal(Animal animal) { using (SQLiteConnection connection = Database.Connection) { string query = "INSERT INTO Animal (Chipnumber, Type, DateOfBirth, Name, IsReserved, LastWalkDate, BadHabits)" + " VALUES (:Chipnumber, :Type, :DateOfBirth, :Name, :IsReserved, :LastWalkDate, :BadHabits)"; using (SQLiteCommand command = new SQLiteCommand(query, connection)) { if(animal is Dog) { var dog = animal as Dog; command.Parameters.AddWithValue("Chipnumber", animal.ChipRegistrationNumber); command.Parameters.AddWithValue("Type", "Dog"); command.Parameters.AddWithValue("DateOfBirth", animal.DateOfBirth); command.Parameters.AddWithValue("Name", animal.Name); command.Parameters.AddWithValue("IsReserved", animal.IsReserved); command.Parameters.AddWithValue("LastWalkDate", dog.LastWalkDate); command.Parameters.AddWithValue("BadHabits", null); } else { var cat = animal as Cat; command.Parameters.AddWithValue("Chipnumber", animal.ChipRegistrationNumber); command.Parameters.AddWithValue("Type", "Cat"); command.Parameters.AddWithValue("DateOfBirth", animal.DateOfBirth); command.Parameters.AddWithValue("Name", animal.Name); command.Parameters.AddWithValue("IsReserved", animal.IsReserved); command.Parameters.AddWithValue("BadHabits", cat.BadHabits); command.Parameters.AddWithValue("LastWalkDate", null); } try { command.ExecuteNonQuery(); } catch (SQLiteException e) { // If a PK constraint was violated, handle the exception if (e.ResultCode == SQLiteErrorCode.Constraint) { return false; } // Unexpected error: rethrow to let the caller handle it throw; } } // Retrieve the id of the inserted row to create a new student object query = "SELECT last_insert_rowid()"; using (SQLiteCommand command = new SQLiteCommand(query, connection)) { if(animal is Dog) { var dog = animal as Dog; dog = new Dog(dog.ChipRegistrationNumber, dog.DateOfBirth, dog.Name, dog.IsReserved, dog.LastWalkDate); } else { var cat = animal as Cat; cat = new Cat(cat.ChipRegistrationNumber, cat.DateOfBirth, cat.Name, cat.IsReserved, cat.BadHabits); } } } return true; }
private void btnCreateCat_Click(object sender, EventArgs e) { Cat theCat = new Cat(textBoxChipRegNumb.Text, dateTimePickerBroughtIn.Value, textBoxName.Text, textBoxBadHabits.Text); }
public void Initialize() { simpleDate = new SimpleDate(06, 11, 1996); lastWalk = new SimpleDate(06, 11, 1996); administration = new Administration(); dog = new Dog("12345", simpleDate, "testdog", lastWalk); cat = new Cat("12345", simpleDate, "testcat", "0123456789"); }
public void TestAddCat() { //60-badhabits.length = price of cat Assert.AreEqual((60 - 10), cat.Price, "Incorrect Price"); //badhabits <= 20 : price = 20 cat = new Cat("12345", simpleDate, "testcat", "12345678901234567890123456789012345678901"); Assert.AreEqual(20, cat.Price); }