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 TestToString() { Dog dog = new Dog("51000", new SimpleDate(01, 05, 1997), "Peter", new SimpleDate(02, 06, 2011)); string dogstring = dog.ToString(); Assert.AreEqual("51000, 01-05-1997, Peter, not reserved, 350, 02-06-2011", dogstring); dog.IsReserved = true; dogstring = dog.ToString(); Assert.AreEqual("51000, 01-05-1997, Peter, reserved, 350, 02-06-2011", dogstring); dog = new Dog("51000", new SimpleDate(01, 05, 1997), "", new SimpleDate(02, 06, 2011)); dogstring = dog.ToString(); Assert.AreEqual("51000, 01-05-1997, noname, not reserved, 350, 02-06-2011", dogstring); dog = new Dog("51000", new SimpleDate(01, 05, 1997), null, new SimpleDate(02, 06, 2011)); dogstring = dog.ToString(); Assert.AreEqual("51000, 01-05-1997, noname, not reserved, 350, 02-06-2011", dogstring); }
public void TestConstructor() { Dog dog = new Dog("123456", new SimpleDate(01, 05, 1997), "Peter", new SimpleDate(02, 06, 2011)); Assert.AreEqual(dog.ChipRegistrationNumber, "12345"); Assert.AreEqual(dog.DateOfBirth.Day, 01); Assert.AreEqual(dog.DateOfBirth.Month, 05); Assert.AreEqual(dog.DateOfBirth.Year, 1997); Assert.AreEqual(dog.LastWalkDate.Day, 02); Assert.AreEqual(dog.LastWalkDate.Month, 06); Assert.AreEqual(dog.LastWalkDate.Year, 2011); Assert.AreEqual(dog.IsReserved, false); Assert.AreEqual(dog.Name, "Peter"); Assert.AreEqual(dog.Price, 200); dog.IsReserved = true; Assert.AreEqual(true, dog.IsReserved); dog = new Dog("51000", new SimpleDate(01, 05, 1997), "Peter", new SimpleDate(02, 06, 2011)); Assert.AreEqual(350, dog.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 TestDogPrice200() { Dog dog2 = new Dog("21452", new SimpleDate(6, 7, 2005), "Tristan", "Reserved", new SimpleDate(6, 10, 2014)); dog2.SetPrice(); Assert.AreEqual(200, dog2.Price); }
public void TestDogNoValuesToString() { Dog dog3 = new Dog("12334", null, null, "Reserved", new SimpleDate(6, 10, 2015)); string s = "12334" + ", " + "00-00-0000" + ", " + "noname" + ", " + "Reserved" + ", " + "€ " + "0,00" + ", " + "06-10-2015"; Assert.AreEqual(s, dog3.ToString()); }
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 btnCreateDog_Click(object sender, EventArgs e) { Dog theDog = new Dog(textBoxChipRegNumb.Text, dateTimePickerBroughtIn.Value, textBoxName.Text, dateTimePickerLastWalked.Value); }
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 TestAddDog() { Assert.AreEqual(lastWalk, dog.LastWalkDate, "Incorrect Last Walk Date"); //Chipnumber of dog < 50000 Assert.AreEqual(200, dog.Price, "Incorrect Price with chipnumber < 50000"); //Chipnumber of dog >= 50000 dog = new Dog("52345", simpleDate, "testdog", lastWalk); Assert.AreEqual(350, dog.Price, "Incorrect Price with chipnumber >= 50000"); }