public override void Setup()
{
base.Setup();
DefaultAct = Act.CreateDefault();
DefaultNewsletter = Newsletter.CreateDefault();
DefaultSeries = Series.CreateDefault();
Location1 = new Location {
QueryHelper = QueryHelper,
Name = Location1Name
};
Event1 = new Event {
QueryHelper = QueryHelper,
Date = Event1Date
};
Act1 = new Act {
QueryHelper = QueryHelper,
Name = Act1Name,
Notes = Act1Notes
};
Act2 = new Act {
QueryHelper = QueryHelper,
Name = Act2Name
};
Set1 = new Set {
QueryHelper = QueryHelper,
SetNo = Set1SetNo
};
Set2 = new Set {
QueryHelper = QueryHelper,
SetNo = Set2SetNo
};
Session.BeginUpdate();
Session.Persist(DefaultAct);
Session.Persist(DefaultNewsletter);
Session.Persist(DefaultSeries);
Session.Persist(Location1);
Data.AddEventTypesPersisted(1, Session);
Event1.Location = Location1;
Event1.EventType = Data.EventTypes[0];
Session.Persist(Event1);
Session.Persist(Act1);
Session.Persist(Act2);
Set1.Event = Event1;
Set2.Event = Event1;
Data.AddGenresPersisted(1, Session);
Set1.Genre = Data.Genres[0];
Set2.Genre = Set1.Genre;
Session.Persist(Set1);
Session.Persist(Set2);
Set1.Act = Act1;
Session.Commit();
}
private void AddDefaultActIfItDoesNotExist()
{
Session.BeginUpdate();
var defaultAct = QueryHelper.Find <Act>(
Act.DefaultName, Session);
if (defaultAct == null)
{
defaultAct = Act.CreateDefault();
Session.Persist(defaultAct);
}
Session.Commit();
HasDefaultActBeenFound = true;
}
public override void Setup()
{
base.Setup();
EventType1 = new EventType {
QueryHelper = QueryHelper,
Name = EventType1Name
};
Genre1 = new Genre {
QueryHelper = QueryHelper,
Name = Genre1Name
};
Location1 = new Location {
QueryHelper = QueryHelper,
Name = Location1Name
};
Location2 = new Location {
QueryHelper = QueryHelper,
Name = Location2Name
};
DefaultNewsletter = Newsletter.CreateDefault();
Newsletter1 = new Newsletter {
QueryHelper = QueryHelper,
Date = Newsletter1Date,
Url = Newsletter1Url
};
Newsletter2 = new Newsletter {
QueryHelper = QueryHelper,
Date = Newsletter2Date,
Url = Newsletter2Url
};
DefaultSeries = Series.CreateDefault();
Series1 = new Series {
QueryHelper = QueryHelper,
Name = Series1Name
};
Series2 = new Series {
QueryHelper = QueryHelper,
Name = Series2Name
};
Event1 = new Event {
QueryHelper = QueryHelper,
Date = Event1Date,
Notes = Event1Notes
};
Event1AtLocation2 = new Event {
QueryHelper = QueryHelper,
Date = Event1Date
};
Event2 = new Event {
QueryHelper = QueryHelper,
Date = Event2Date
};
Set1 = new Set {
QueryHelper = QueryHelper,
SetNo = Set1SetNo
};
Set2 = new Set {
QueryHelper = QueryHelper,
SetNo = Set2SetNo
};
DefaultAct = Act.CreateDefault();
Session.BeginUpdate();
Session.Persist(EventType1);
Session.Persist(Genre1);
Session.Persist(Location1);
Session.Persist(Location2);
Session.Persist(DefaultNewsletter);
Session.Persist(Newsletter1);
Session.Persist(Newsletter2);
Session.Persist(DefaultSeries);
Session.Persist(Series1);
Session.Persist(Series2);
Session.Persist(DefaultAct);
Event1.Location = Location1;
Event1AtLocation2.Location = Location2;
Event2.Location = Location1;
Event2.Series = Series1;
Event1.EventType = EventType1;
Event1AtLocation2.EventType = EventType1;
Event2.EventType = EventType1;
Session.Persist(Event1);
Session.Persist(Event1AtLocation2);
Session.Persist(Event2);
Event1.Newsletter = Newsletter1;
Event1AtLocation2.Newsletter = Newsletter2;
Event1AtLocation2.Series = Series2;
Set1.Event = Event1;
Set1.Genre = Genre1;
Set2.Event = Event1;
Set2.Genre = Genre1;
Session.Persist(Set1);
Session.Persist(Set2);
Session.Commit();
}
public override void Setup()
{
base.Setup();
DefaultAct = Act.CreateDefault();
DefaultNewsletter = Newsletter.CreateDefault();
DefaultSeries = Series.CreateDefault();
Baker = new Artist {
QueryHelper = QueryHelper,
Surname = BakerName
};
Drums = new Role {
QueryHelper = QueryHelper,
Name = DrumsName
};
Location1 = new Location {
QueryHelper = QueryHelper,
Name = Location1Name
};
Event1 = new Event {
QueryHelper = QueryHelper,
Date = DateTime.Parse("2020/03/01")
};
Set1 = new Set {
QueryHelper = QueryHelper,
SetNo = Set1SetNo
};
Set2 = new Set {
QueryHelper = QueryHelper,
SetNo = Set2SetNo
};
Piece1 = new Piece {
QueryHelper = QueryHelper,
PieceNo = Piece1PieceNo,
AudioUrl = Piece1AudioUrl,
Duration = Piece1Duration = new TimeSpan(0, 5, 29),
Notes = Piece1Notes,
Title = Piece1Title,
VideoUrl = Piece1VideoUrl
};
Piece1AtSet2 = new Piece {
QueryHelper = QueryHelper,
PieceNo = Piece1PieceNo,
Duration = Piece1AtSet2Duration = new TimeSpan(0, 2, 8)
};
Piece2 = new Piece {
QueryHelper = QueryHelper,
PieceNo = Piece2PieceNo,
Duration = Piece2Duration = new TimeSpan(1, 46, 3)
};
Credit1 = new Credit {
QueryHelper = QueryHelper,
CreditNo = Credit1CreditNo
};
Credit2 = new Credit {
QueryHelper = QueryHelper,
CreditNo = Credit2CreditNo
};
Session.BeginUpdate();
Session.Persist(DefaultAct);
Session.Persist(DefaultNewsletter);
Session.Persist(DefaultSeries);
Session.Persist(Baker);
Session.Persist(Drums);
Session.Persist(Location1);
Event1.Location = Location1;
Data.AddEventTypesPersisted(1, Session);
Event1.EventType = Data.EventTypes[0];
Session.Persist(Event1);
Set1.Event = Event1;
Set2.Event = Event1;
Data.AddGenresPersisted(1, Session);
Set1.Genre = Data.Genres[0];
Set2.Genre = Set1.Genre;
Session.Persist(Set1);
Session.Persist(Set2);
Piece1.Set = Set1;
Piece1AtSet2.Set = Set2;
Piece2.Set = Set1;
Session.Persist(Piece1);
Session.Persist(Piece1AtSet2);
Session.Persist(Piece2);
Credit1.Artist = Baker;
Credit1.Piece = Piece1;
Credit1.Role = Drums;
Credit2.Artist = Baker;
Credit2.Piece = Piece1;
Credit2.Role = Drums;
Session.Persist(Credit1);
Session.Persist(Credit2);
Session.Commit();
Session.BeginRead();
Location1 = QueryHelper.Read <Location>(Location1Name, Session);
Event1 = QueryHelper.Read <Event>(Event1.SimpleKey, Location1, Session);
Set1 = QueryHelper.Read <Set>(Set1.SimpleKey, Event1, Session);
Set2 = QueryHelper.Read <Set>(Set2.SimpleKey, Event1, Session);
Piece1 = QueryHelper.Read <Piece>(Piece1SimpleKey, Set1, Session);
Piece1AtSet2 = QueryHelper.Read <Piece>(Piece1SimpleKey, Set2, Session);
Piece2 = QueryHelper.Read <Piece>(Piece2SimpleKey, Set1, Session);
Credit1 = QueryHelper.Read <Credit>(Credit1.SimpleKey, Piece1, Session);
Credit2 = QueryHelper.Read <Credit>(Credit2.SimpleKey, Piece1, Session);
Session.Commit();
}
public override void Setup()
{
base.Setup();
DefaultAct = Act.CreateDefault();
DefaultNewsletter = Newsletter.CreateDefault();
DefaultSeries = Series.CreateDefault();
Baker = new Artist {
QueryHelper = QueryHelper,
Surname = BakerName
};
Clarissa = new Artist {
QueryHelper = QueryHelper,
Forename = ClarissaName
};
Drums = new Role {
QueryHelper = QueryHelper,
Name = DrumsName
};
ElectricGuitar = new Role {
QueryHelper = QueryHelper,
Name = ElectricGuitarName
};
Location1 = new Location {
QueryHelper = QueryHelper,
Name = Location1Name
};
Event1 = new Event {
QueryHelper = QueryHelper,
Date = Event1Date
};
Set1 = new Set {
QueryHelper = QueryHelper,
SetNo = Set1SetNo
};
Piece1 = new TestPiece {
QueryHelper = QueryHelper,
PieceNo = Piece1PieceNo
};
Piece2 = new TestPiece {
QueryHelper = QueryHelper,
PieceNo = Piece2PieceNo
};
Credit1 = new Credit {
QueryHelper = QueryHelper,
CreditNo = Credit1CreditNo
};
Credit2 = new Credit {
QueryHelper = QueryHelper,
CreditNo = Credit2CreditNo
};
Credit3 = new Credit {
QueryHelper = QueryHelper,
CreditNo = Credit3CreditNo
};
Session.BeginUpdate();
Session.Persist(DefaultAct);
Session.Persist(DefaultNewsletter);
Session.Persist(DefaultSeries);
Session.Persist(Baker);
Session.Persist(Clarissa);
Session.Persist(Drums);
Session.Persist(ElectricGuitar);
Session.Persist(Location1);
Data.AddEventTypesPersisted(1, Session);
Event1.EventType = Data.EventTypes[0];
Event1.Location = Location1;
Session.Persist(Event1);
Set1.Event = Event1;
Data.AddGenresPersisted(1, Session);
Set1.Genre = Data.Genres[0];
Session.Persist(Set1);
Piece1.Set = Set1;
Piece2.Set = Set1;
Session.Persist(Piece1);
Session.Persist(Piece2);
Credit1.Piece = Piece1;
Credit1.Artist = Baker;
Credit1.Role = Drums;
Credit2.Piece = Piece1;
Credit2.Artist = Baker;
Credit2.Role = Drums;
Credit3.Piece = Piece2;
Credit3.Artist = Baker;
Credit3.Role = Drums;
Session.Persist(Credit1);
Session.Persist(Credit2);
Session.Persist(Credit3);
Session.Commit();
Session.BeginRead();
FetchData();
Session.Commit();
}
public override void Setup()
{
base.Setup();
DefaultAct = Act.CreateDefault();
DefaultNewsletter = Newsletter.CreateDefault();
DefaultSeries = Series.CreateDefault();
RalphJenkins = new Artist {
QueryHelper = QueryHelper,
Forename = RalphJenkinsForename,
Surname = RalphJenkinsSurname,
Notes = RalphJenkinsNotes
};
Clarissa = new Artist {
QueryHelper = QueryHelper,
Forename = ClarissaForename
};
Baker = new Artist {
QueryHelper = QueryHelper,
Surname = BakerSurname
};
Role1 = new Role {
QueryHelper = QueryHelper,
Name = Role1Name
};
Location1 = new Location {
QueryHelper = QueryHelper,
Name = Location1Name
};
Event1 = new Event {
QueryHelper = QueryHelper,
Date = Event1Date
};
Set1 = new Set {
QueryHelper = QueryHelper,
SetNo = Set1SetNo
};
Piece1 = new TestPiece {
QueryHelper = QueryHelper,
PieceNo = Piece1PieceNo
};
Credit1 = new Credit {
QueryHelper = QueryHelper,
CreditNo = Credit1CreditNo
};
Credit2 = new Credit {
QueryHelper = QueryHelper,
CreditNo = Credit2CreditNo
};
Session.BeginUpdate();
Session.Persist(DefaultAct);
Session.Persist(DefaultNewsletter);
Session.Persist(DefaultSeries);
Session.Persist(RalphJenkins);
Session.Persist(Clarissa);
Session.Persist(Baker);
Session.Persist(Role1);
Session.Persist(Location1);
Data.AddEventTypesPersisted(1, Session);
Event1.EventType = Data.EventTypes[0];
Event1.Location = Location1;
Session.Persist(Event1);
Set1.Event = Event1;
Data.AddGenresPersisted(1, Session);
Set1.Genre = Data.Genres[0];
Session.Persist(Set1);
Piece1.Set = Set1;
Session.Persist(Piece1);
Credit1.Artist = RalphJenkins;
Credit1.Role = Role1;
Credit1.Piece = Piece1;
Credit2.Artist = RalphJenkins;
Credit2.Role = Role1;
Credit2.Piece = Piece1;
Session.Persist(Credit1);
Session.Persist(Credit2);
Session.Commit();
Session.BeginRead();
RalphJenkins = QueryHelper.Read <Artist>(RalphJenkinsName, Session);
Clarissa = QueryHelper.Read <Artist>(ClarissaName, Session);
Baker = QueryHelper.Read <Artist>(BakerName, Session);
Credit1 = QueryHelper.Read <Credit>(Credit1.SimpleKey, Piece1, Session);
Credit2 = QueryHelper.Read <Credit>(Credit2.SimpleKey, Piece1, Session);
Session.Commit();
}
public override void Setup()
{
base.Setup();
DefaultAct = Act.CreateDefault();
DefaultNewsletter = Newsletter.CreateDefault();
DefaultSeries = Series.CreateDefault();
Location1 = new Location {
QueryHelper = QueryHelper,
Name = Location1Name
};
EventType1 = new EventType {
QueryHelper = QueryHelper,
Name = EventType1Name
};
Event1 = new Event {
QueryHelper = QueryHelper,
Date = Event1Date
};
Event2 = new Event {
QueryHelper = QueryHelper,
Date = Event2Date
};
Genre1 = new Genre {
QueryHelper = QueryHelper,
Name = Genre1Name
};
Act1 = new Act {
QueryHelper = QueryHelper,
Name = Act1Name
};
Act2 = new Act {
QueryHelper = QueryHelper,
Name = Act2Name
};
Set1 = new Set {
QueryHelper = QueryHelper,
SetNo = Set1SetNo,
Notes = Set1Notes,
IsPublic = false
};
Set1AtEvent2 = new Set {
QueryHelper = QueryHelper,
SetNo = Set1SetNo
};
Set2 = new Set {
QueryHelper = QueryHelper,
SetNo = Set2SetNo
};
Piece1 = new TestPiece {
QueryHelper = QueryHelper,
PieceNo = Piece1PieceNo
};
Piece2 = new TestPiece {
QueryHelper = QueryHelper,
PieceNo = Piece2PieceNo
};
Session.BeginUpdate();
Session.Persist(DefaultAct);
Session.Persist(DefaultNewsletter);
Session.Persist(DefaultSeries);
Session.Persist(EventType1);
Session.Persist(Location1);
Event1.Location = Location1;
Event2.Location = Location1;
Event1.EventType = EventType1;
Event2.EventType = EventType1;
Session.Persist(Event1);
Session.Persist(Event2);
Session.Persist(Act1);
Session.Persist(Act2);
Session.Persist(Genre1);
Set1.Event = Event1;
Set1AtEvent2.Event = Event2;
Set2.Event = Event1;
Set1.Genre = Genre1;
Set1AtEvent2.Genre = Genre1;
Set2.Genre = Genre1;
Session.Persist(Set1);
Session.Persist(Set2);
Session.Persist(Set1AtEvent2);
Set1.Act = Act1;
Set1AtEvent2.Act = Act2;
Set2.Act = Act1;
Piece1.Set = Set1;
Piece2.Set = Set1;
Session.Persist(Piece1);
Session.Persist(Piece2);
Session.Commit();
Session.BeginRead();
FetchData();
Session.Commit();
}