// Use from [TestInitialize] or [ClassInitialize] public static void InitializeForTest(this SqlConnection db, SjoslagetDbTestConfig config = null) { if (null == config) { config = SjoslagetDbTestConfig.Default; } db.Execute("delete from [Cruise]"); db.Execute("delete from [CabinType]"); db.Execute("delete from [ProductType]"); _cabinTypeId = db.ExecuteScalar <Guid>("insert into [CabinType] ([Name], [Description], [Capacity], [Order]) output inserted.[Id] values ('A4', '', 4, 0)"); _cabinTypeBId = db.ExecuteScalar <Guid>("insert into [CabinType] ([SubCruise], [Name], [Description], [Capacity], [Order]) output inserted.[Id] values ('B', 'B4', '', 4, 0)"); _cruiseId = db.ExecuteScalar <Guid>("insert into [Cruise] ([Name], [IsActive]) output inserted.[Id] values ('Test', 1)"); _productId = db.ExecuteScalar <Guid>("insert into [ProductType] ([Name], [Order]) output inserted.[Id] values ('Produkt', 0)"); db.Execute("insert into [CruiseCabin] ([CruiseId], [CabinTypeId], [Count], [PricePerPax]) values (@CruiseId, @CabinTypeId, @NumberOfCabins, @PricePerPax)", new { CruiseId = _cruiseId, CabinTypeId = _cabinTypeId, NumberOfCabins = config.NumberOfCabins, PricePerPax = config.PricePerPax }); db.Execute("insert into [CruiseCabin] ([CruiseId], [CabinTypeId], [Count], [PricePerPax]) values (@CruiseId, @CabinTypeId, @NumberOfCabins, @PricePerPax)", new { CruiseId = _cruiseId, CabinTypeId = _cabinTypeBId, NumberOfCabins = config.NumberOfCabins, PricePerPax = config.PricePerPax }); db.Execute("insert into [CruiseProduct] ([CruiseId], [ProductTypeId], [Description], [Price]) values (@CruiseId, @ProductTypeId, '', @Price)", new { CruiseId = _cruiseId, ProductTypeId = _productId, Price = config.ProductPrice }); }
// Use from [TestInitialize] or [ClassInitialize] public static void InitializeForTest(SjoslagetDbTestConfig config = null) { using (var db = DbUtil.Open()) db.InitializeForTest(config); }