// 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);
}
