public void GetCountryByName()
{
var options = new DbContextOptionsBuilder <OlympicGamesDBContext>()
.UseInMemoryDatabase(databaseName: "GetCountryByNameDB")
.Options;
var data = new List <Countries>()
{
new Countries {
Id = 1, Name = "Country1"
},
new Countries {
Id = 2, Name = "Country2"
},
new Countries {
Id = 3, Name = "Country3"
},
}.AsQueryable();
using (OlympicGamesDBContext context = new OlympicGamesDBContext(options))
{
CountriesBusiness business = new CountriesBusiness(context);
data.ToList().ForEach(t => context.Countries.Add(t));
context.SaveChanges();
Countries t = business.GetCountryByName("Country1");
Assert.AreEqual("Country1", t.Name);
}
}
public void GetCompetitorByName()
{
var options = new DbContextOptionsBuilder <OlympicGamesDBContext>()
.UseInMemoryDatabase(databaseName: "GetCompetitorByNameDB")
.Options;
var data = new List <Competitors>()
{
new Competitors {
Id = 1, FullName = "Competitor1"
},
new Competitors {
Id = 2, FullName = "Competitor2"
},
new Competitors {
Id = 3, FullName = "Competitor3"
},
}.AsQueryable();
using (OlympicGamesDBContext context = new OlympicGamesDBContext(options))
{
CompetitorsBusiness business = new CompetitorsBusiness(context);
data.ToList().ForEach(c => business.AddCompetitors(c));
Competitors c = business.GetCompetitorByName("Competitor1");
Assert.AreEqual("Competitor1", c.FullName);
}
}
public void GetsAllSportsFromDatabase()
{
var options = new DbContextOptionsBuilder <OlympicGamesDBContext>()
.UseInMemoryDatabase(databaseName: "GetsAllSportsFromDatabaseDB")
.Options;
var data = new List <Sports>()
{
new Sports {
Id = 1, Name = "Sport1"
},
new Sports {
Id = 2, Name = "Sport2"
},
new Sports {
Id = 3, Name = "Sport3"
},
}.AsQueryable();
using (OlympicGamesDBContext context = new OlympicGamesDBContext(options))
{
SportsBusiness business = new SportsBusiness(context);
data.ToList().ForEach(t => context.Sports.Add(t));
context.SaveChanges();
Assert.AreEqual(data.ToList(), business.GetAllSports());
}
}
public void GetClubByName()
{
var options = new DbContextOptionsBuilder <OlympicGamesDBContext>()
.UseInMemoryDatabase(databaseName: "GetClubByNameDB")
.Options;
var data = new List <Clubs>()
{
new Clubs {
Id = 1, Name = "Club1"
},
new Clubs {
Id = 2, Name = "Club2"
},
new Clubs {
Id = 3, Name = "Club3"
},
}.AsQueryable();
using (OlympicGamesDBContext context = new OlympicGamesDBContext(options))
{
ClubsBusiness business = new ClubsBusiness(context);
data.ToList().ForEach(c => business.AddClub(c));
Clubs c = business.GetClubByName("Club1");
Assert.AreEqual("Club1", c.Name);
}
}
public void DeleteTown()
{
var options = new DbContextOptionsBuilder <OlympicGamesDBContext>()
.UseInMemoryDatabase(databaseName: "DeleteTownDB")
.Options;
var data = new List <Towns>()
{
new Towns {
Id = 1, Name = "Town1"
},
new Towns {
Id = 2, Name = "Town2"
},
new Towns {
Id = 3, Name = "Town3"
},
}.AsQueryable();
using (OlympicGamesDBContext context = new OlympicGamesDBContext(options))
{
TownsBusiness business = new TownsBusiness(context);
data.ToList().ForEach(town => business.AddTown(town));
business.DeleteTownById(2);
Assert.AreEqual(2, business.GetAllTowns().Count);
}
}
public void DeleteClub()
{
var options = new DbContextOptionsBuilder <OlympicGamesDBContext>()
.UseInMemoryDatabase(databaseName: "DeleteClubDB")
.Options;
IQueryable <Clubs> data = new List <Clubs>()
{
new Clubs {
Id = 1, Name = "Club1"
},
new Clubs {
Id = 2, Name = "Club2"
},
new Clubs {
Id = 3, Name = "Club3"
},
new Clubs {
Id = 22, Name = "SektantiVegani"
},
}.AsQueryable();
using (OlympicGamesDBContext context = new OlympicGamesDBContext(options))
{
ClubsBusiness business = new ClubsBusiness(context);
data.ToList().ForEach(club1 => business.AddClub(club1));
business.DeleteClubById(22);
Assert.AreEqual(3, business.GetAllClubs().Count);
}
}
public void DeleteCompetitor()
{
var data = new List <Competitors>()
{
new Competitors {
Id = 1, FullName = "Competitor1"
},
new Competitors {
Id = 2, FullName = "Competitor2"
},
new Competitors {
Id = 3, FullName = "Competitor3"
},
}.AsQueryable();
var options = new DbContextOptionsBuilder <OlympicGamesDBContext>()
.UseInMemoryDatabase(databaseName: "DeleteCompetitorDB")
.Options;
using (OlympicGamesDBContext context = new OlympicGamesDBContext(options))
{
CompetitorsBusiness business = new CompetitorsBusiness(context);
data.ToList().ForEach(competitor => business.AddCompetitors(competitor));
business.DeleteCompetitorById(2);
Assert.AreEqual(2, business.GetAllCompetitors().Count);
}
}
public void TestAddClub()
{
var options = new DbContextOptionsBuilder <OlympicGamesDBContext>()
.UseInMemoryDatabase(databaseName: "TestAddClubDB")
.Options;
var data = new List <Clubs>()
{
new Clubs {
Id = 1, Name = "Club1"
},
new Clubs {
Id = 2, Name = "Club2"
},
new Clubs {
Id = 3, Name = "Club3"
},
}.AsQueryable();
using (OlympicGamesDBContext context = new OlympicGamesDBContext(options))
{
ClubsBusiness business = new ClubsBusiness(context);
data.ToList().ForEach(t => business.AddClub(t));
Assert.AreEqual(data.ToList(), business.GetAllClubs());
}
}
public void TestUpdateCoaches()
{
var options = new DbContextOptionsBuilder <OlympicGamesDBContext>()
.UseInMemoryDatabase(databaseName: "TestUpdateCoachesDB")
.Options;
var data = new List <Coaches>()
{
new Coaches {
Id = 1, Name = "Coach1"
},
new Coaches {
Id = 2, Name = "Coach2"
},
new Coaches {
Id = 3, Name = "Coach3"
},
}.AsQueryable();
using (OlympicGamesDBContext context = new OlympicGamesDBContext(options))
{
CoachesBusiness business = new CoachesBusiness(context);
data.ToList().ForEach(c => business.AddCoach(c));
Coaches c = business.GetCoachById(2); c.Name = "Coach22";
business.UpdateCoach(c);
Assert.AreEqual("Coach22", business.GetCoachById(2).Name);
}
}
public void TestUpdateTowns()
{
var options = new DbContextOptionsBuilder <OlympicGamesDBContext>()
.UseInMemoryDatabase(databaseName: "TestUpdateTownsDB")
.Options;
var data = new List <Towns>()
{
new Towns {
Id = 1, Name = "Town1"
},
new Towns {
Id = 2, Name = "Town2"
},
new Towns {
Id = 3, Name = "Town3"
},
}.AsQueryable();
using (OlympicGamesDBContext context = new OlympicGamesDBContext(options))
{
TownsBusiness business = new TownsBusiness(context);
data.ToList().ForEach(c => business.AddTown(c));
Towns c = business.GetTownById(2); c.Name = "Town22";
business.UpdateTown(c);
Assert.AreEqual("Town22", business.GetTownById(2).Name);
}
}
public void DeleteCoach()
{
var options = new DbContextOptionsBuilder <OlympicGamesDBContext>()
.UseInMemoryDatabase(databaseName: "DeleteCoachDB")
.Options;
var data = new List <Coaches>()
{
new Coaches {
Id = 1, Name = "Coach1"
},
new Coaches {
Id = 2, Name = "Coach2"
},
new Coaches {
Id = 3, Name = "Coach3"
},
}.AsQueryable();
//да не забравяш options
using (OlympicGamesDBContext context = new OlympicGamesDBContext(options))
{
CoachesBusiness business = new CoachesBusiness(context);
data.ToList().ForEach(c => business.AddCoach(c));
business.DeleteCoachById(2);
Assert.AreEqual(2, business.GetAllCoaches().Count);
}
}
public void GetTownByName()
{
var options = new DbContextOptionsBuilder <OlympicGamesDBContext>()
.UseInMemoryDatabase(databaseName: "GetTownByNameDB")
.Options;
var data = new List <Towns>()
{
new Towns {
Id = 1, Name = "Town1"
},
new Towns {
Id = 2, Name = "Town2"
},
new Towns {
Id = 3, Name = "Town3"
},
}.AsQueryable();
using (OlympicGamesDBContext context = new OlympicGamesDBContext(options))
{
TownsBusiness business = new TownsBusiness(context);
data.ToList().ForEach(t => business.AddTown(t));
Towns t = business.GetTownByName("Town1");
Assert.AreEqual("Town1", t.Name);
}
}
public void GetsAllTownsFromDatabase()
{
var options = new DbContextOptionsBuilder <OlympicGamesDBContext>()
.UseInMemoryDatabase(databaseName: "GetsAllCompetitorsFromDatabaseDB")
.Options;
var data = new List <Towns>()
{
new Towns {
Id = 1, Name = "Town1"
},
new Towns {
Id = 2, Name = "Town2"
},
new Towns {
Id = 3, Name = "Town3"
},
}.AsQueryable();
using (OlympicGamesDBContext context = new OlympicGamesDBContext(options))
{
TownsBusiness business = new TownsBusiness(context);
data.ToList().ForEach(c => business.AddTown(c));
Assert.AreEqual(data.ToList(), business.GetAllTowns());
}
}
//Ъм тука имам въпорс - i az
/// <summary>
/// Constructor for CompetitorsDisplay class.
/// </summary>
/// <param name="context"></param>
public CompetitorsDisplay(OlympicGamesDBContext context)
{
competitorsBusiness = new CompetitorsBusiness(context);
coachesBusiness = new CoachesBusiness(context);
clubsBusiness = new ClubsBusiness(context);
townsBusiness = new TownsBusiness(context);
sportsBusiness = new SportsBusiness(context);
townsDisplay = new TownsDisplay(context);
clubsDisplay = new ClubsDisplay(context);
coachesDisplay = new CoachesDisplay(context);
}
public void GetSportById()
{
var options = new DbContextOptionsBuilder <OlympicGamesDBContext>()
.UseInMemoryDatabase(databaseName: "TestDB")
.Options;
using (OlympicGamesDBContext context = new OlympicGamesDBContext(options))
{
SportsBusiness business = new SportsBusiness(context);
context.Sports.Add(new Sports {
Id = 1, Name = "Sport1"
});
context.Sports.Add(new Sports {
Id = 2, Name = "Sport2"
});
context.Sports.Add(new Sports {
Id = 3, Name = "Sport3"
});
Sports c = business.GetSportById(1);
Assert.AreEqual(1, c.Id);
}
}
public void GetClubById()
{
var options = new DbContextOptionsBuilder <OlympicGamesDBContext>()
.UseInMemoryDatabase(databaseName: "GetClubByIdDB")
.Options;
using (OlympicGamesDBContext context = new OlympicGamesDBContext(options))
{
ClubsBusiness business = new ClubsBusiness(context);
business.AddClub(new Clubs {
Id = 1, Name = "Club1"
});
business.AddClub(new Clubs {
Id = 2, Name = "Club2"
});
business.AddClub(new Clubs {
Id = 3, Name = "Club3"
});
Clubs c = business.GetClubById(1);
Assert.AreEqual(1, c.Id);
}
}
public void GetCompetitorById()
{
var options = new DbContextOptionsBuilder <OlympicGamesDBContext>()
.UseInMemoryDatabase(databaseName: "GetCompetitorByIdDB")
.Options;
using (OlympicGamesDBContext context = new OlympicGamesDBContext(options))
{
CompetitorsBusiness business = new CompetitorsBusiness(context);
business.AddCompetitors(new Competitors {
Id = 1, FullName = "Competitor1"
});
business.AddCompetitors(new Competitors {
Id = 2, FullName = "Competitor2"
});
business.AddCompetitors(new Competitors {
Id = 3, FullName = "Competitor3"
});
Competitors c = business.GetCompetitorById(1);
Assert.AreEqual(1, c.Id);
}
}
public void GetTownById()
{
var options = new DbContextOptionsBuilder <OlympicGamesDBContext>()
.UseInMemoryDatabase(databaseName: "GetTownByIdDB")
.Options;
using (OlympicGamesDBContext context = new OlympicGamesDBContext(options))
{
TownsBusiness business = new TownsBusiness(context);
business.AddTown(new Towns {
Id = 1, Name = "Town1"
});
business.AddTown(new Towns {
Id = 2, Name = "Town2"
});
business.AddTown(new Towns {
Id = 3, Name = "Town3"
});
Towns c = business.GetTownById(1);
Assert.AreEqual(1, c.Id);
}
}
public SportsBusiness(OlympicGamesDBContext context)
{
this.olympicGamesDBContext = context;
}
/// <summary>
/// Constructor for SportsDisplay class.
/// </summary>
/// <param name="context"></param>
public SportsDisplay(OlympicGamesDBContext context)
{
sportsBusiness = new SportsBusiness(context);
}
public TownsBusiness(OlympicGamesDBContext context)
{
this.olympicGamesDBContext = context;
}
/// <summary>
/// Constructor for ClubsDisplay class.
/// </summary>
/// <param name="context"></param>
public ClubsDisplay(OlympicGamesDBContext context)
{
clubsBusiness = new ClubsBusiness(context);
}
/// <summary>
/// Makes the connection between Coaches's display and business layer.
/// </summary>
/// <param name="context"></param>
public CoachesDisplay(OlympicGamesDBContext context)
{
coachesBusiness = new CoachesBusiness(context);
sportsBusiness = new SportsBusiness(context);
}
/// <summary>
/// Constructor for CoachesBusiness class.
/// </summary>
/// <param name="context"></param>
public CoachesBusiness(OlympicGamesDBContext context)
{
this.olympicGamesDBContext = context;
}
/// <summary>
/// Constructor for CountriesDisplay class.
/// </summary>
/// <param name="context"></param>
public CountriesDisplay(OlympicGamesDBContext context)
{
countriesBusiness = new CountriesBusiness(context);
towns = new TownsBusiness(context);
}
/// <summary>
/// Constructor for CompetitorsBusiness class.
/// </summary>
/// <param name="context"></param>
public CompetitorsBusiness(OlympicGamesDBContext context)
{
this.olympicGamesDBContext = context;
}
