00001 00002 using System; 00003 using NUnit.Framework; 00004 using Foodolini.Database; 00005 00006 namespace Foodolini.Database.Test 00007 { 00008 00012 [TestFixture] 00013 public class FoodDescriptionTest : DatabaseTest 00014 { 00022 [Test] 00023 public void SaveloadTest() 00024 { 00025 FoodDescription food; 00026 food = new FoodDescription(); 00027 food.CommercialName = "ymer"; 00028 food.ExpirationAfterOpening = new TimeSpan(10,20,30, 0 ,40).Ticks; 00029 food.FoodGroupId = 44; 00030 food.LongDescription = "ymer2"; 00031 food.Manufacturer = "arla"; 00032 food.ShelfLife = new TimeSpan(4,3,2,1).Ticks; 00033 food.ShortDescription = "short ymer"; 00034 00035 this.repository.Add<FoodDescription>(food); 00036 00037 Assert.AreNotEqual (0,food.FoodDescriptionId, "food have been given a database Id"); 00038 00039 FoodDescription foodload; 00040 foodload = this.repository.SingleWhere<FoodDescription>("FoodDescriptionId = @0",food.FoodDescriptionId); 00041 00042 TimeSpan expTime = new TimeSpan(foodload.ExpirationAfterOpening.Value); 00043 Assert.AreEqual(10, expTime.Days ,"test that time stamp match"); 00044 Assert.AreEqual(20, expTime.Hours,"test that time stamp match"); 00045 Assert.AreEqual(30, expTime.Minutes,"test that time stamp match"); 00046 Assert.AreEqual(40, expTime.Milliseconds,"test that time stamp match"); 00047 00048 TimeSpan ShelfLife = new TimeSpan(foodload.ShelfLife.Value); 00049 Assert.AreEqual(4, ShelfLife.Days ,"test that time stamp match"); 00050 Assert.AreEqual(3, ShelfLife.Hours,"test that time stamp match"); 00051 Assert.AreEqual(2, ShelfLife.Minutes,"test that time stamp match"); 00052 Assert.AreEqual(1, ShelfLife.Seconds,"test that time stamp match"); 00053 00054 Assert.AreEqual(44,foodload.FoodGroupId); 00055 Assert.AreEqual("ymer",foodload.CommercialName); 00056 Assert.AreEqual("ymer2",foodload.LongDescription); 00057 Assert.AreEqual("arla",foodload.Manufacturer); 00058 Assert.AreEqual("short ymer",foodload.ShortDescription); 00059 00060 } 00061 } 00062 }