public void Initialise() { _context = new WSStatContext(); _stubLogger = MockRepository.GenerateStub<ILogger>(); InsertTestDataToDatabase(); }
private void DeleteTestDataFromDatabase() { using (var context = new WSStatContext()) { context.Database.ExecuteSqlCommand("delete from SessionBoards"); context.Database.ExecuteSqlCommand("delete from SessionSails"); context.Database.ExecuteSqlCommand("delete from SailingSession"); context.Database.ExecuteSqlCommand("delete from Sailor"); context.Database.ExecuteSqlCommand("delete from Location"); context.Database.ExecuteSqlCommand("delete from Board"); context.Database.ExecuteSqlCommand("delete from Sail"); context.Database.ExecuteSqlCommand("delete from SailModel"); context.Database.ExecuteSqlCommand("delete from BoardModel"); context.Database.ExecuteSqlCommand("delete from Manufacturer"); } }
private void InsertTestDataToDatabase() { using (var context = new WSStatContext()) { Manufacturer tushing = context.Manufacturers.Add(new Manufacturer { Name = "Tushingham" }); Manufacturer severne = context.Manufacturers.Add(new Manufacturer { Name = "Severne" }); Manufacturer jp = context.Manufacturers.Add(new Manufacturer { Name = "JP" }); SailModel rock = context.SailModels.Add(new SailModel { Name = "Rock", Manufacturer = tushing }); SailModel blade = context.SailModels.Add(new SailModel { Name = "Blade", Manufacturer = severne }); BoardModel rww = context.BoardModels.Add(new BoardModel { Name = "Real World Wave", Manufacturer = jp }); BoardModel fsw = context.BoardModels.Add(new BoardModel { Name = "Freestyle Wave", Manufacturer = jp }); Sail rock40 = context.Sails.Add(new Sail { Model = rock, Size = 4.0 }); Sail rock47 = context.Sails.Add(new Sail { Model = rock, Size = 4.7 }); Sail rock52 = context.Sails.Add(new Sail { Model = rock, Size = 5.2 }); Board rww76 = context.Boards.Add(new Board { Model = rww, Volume = 76 }); Board rww83 = context.Boards.Add(new Board { Model = rww, Volume = 83 }); Board fsw102 = context.Boards.Add(new Board { Model = fsw, Volume = 102 }); Location ditch = context.Locations.Add(new Location { Name = "Ditch" }); Location plimi = context.Locations.Add(new Location { Name = "Plimi" }); Sailor twigg = context.Sailors.Add(new Sailor { FirstName = "Andrew", LastName = "Twigg" }); Sailor sweeting = context.Sailors.Add(new Sailor { FirstName = "David", LastName = "Sweeting" }); DateTime sessionStart = DateTime.Parse("2012-04-01T17:35:00.0000000+13:00"); DateTime sessionEnd = DateTime.Parse("2012-04-01T19:35:00.0000000+13:00"); SailingSession session1 = context.Sessions.Add(new SailingSession { Sailor = twigg, StartTime = sessionStart, EndTime = sessionEnd, Location = ditch, }); SailingSession session2 = context.Sessions.Add(new SailingSession { Sailor = twigg, StartTime = sessionStart, EndTime = sessionEnd, Location = plimi }); SailingSession session3 = context.Sessions.Add(new SailingSession { Sailor = twigg, StartTime = sessionStart, EndTime = sessionEnd, Location = ditch }); session1.Sails.Add(rock40); session1.Boards.Add(fsw102); session2.Sails.Add(rock40); session2.Boards.Add(rww76); session3.Sails.Add(rock52); session3.Boards.Add(fsw102); context.Save(); } }