public void GetCoachByIdTest()
{
var context = new Core.Data.CSBCDbContext();
var testinit = new CSBCDbInitializer();
var rep = new CoachRepository(context);
var dt = rep.GetCoaches((testinit.CurrentSeason).SeasonID);
Assert.IsTrue(dt.Rows.Count > 0);
}
public void GetPersonByFirstAndLastNameTest()
{
var context = new Core.Data.CSBCDbContext();
var testinit = new TestUtils(context);
var rep = new PersonRepository(context);
var person = rep.FindPersonByLastAndFirstName(testinit.HouseholdLastNames[0], testinit.FirstNames[0]);
Assert.IsTrue(person.PeopleID != 0);
}
public void CleanupTest()
{
using (var context = new Core.Data.CSBCDbContext())
{
var init = new CSBCDbInitializer();
init.DeleteTestHouseholds(context);
}
}
public void GetSeasonCoachesTest()
{
var context = new Core.Data.CSBCDbContext();
var testinit = new CSBCDbInitializer();
var rep = new CoachRepository(context);
var coaches = rep.GetSeasonCoaches(testinit.CurrentSeason.SeasonID);
Assert.IsTrue(coaches.Any<vw_Coaches>() );
}
public void GetCoachVolunteerTest()
{
var context = new Core.Data.CSBCDbContext();
var testinit = new CSBCDbInitializer();
var rep = new CoachRepository(context);
var coaches = rep.GetCoachVolunteers(1, testinit.CurrentSeason.SeasonID);
Assert.IsTrue(coaches.Count<vw_Coaches>() > 0);
}
public void GetPersonByIdTest()
{
var context = new Core.Data.CSBCDbContext();
var testinit = new TestUtils(context);
var rep = new PersonRepository(context);
var people = rep.GetAll(1);
var person5 = people.ElementAt<Person>(5); //assume at least 5 people in table
var id = person5.PeopleID;
var person = rep.GetById(id);
Assert.IsTrue(person.PeopleID != 0);
}
public void GetParentsTest()
{
using (var context = new Core.Data.CSBCDbContext())
{
var testinit = new TestUtils(context);
var rep = new PersonRepository(context);
var person = context.People.FirstOrDefault();
if (person != null)
{
var parents = rep.GetParents(person.PeopleID);
Assert.IsTrue(person.PeopleID != 0);
Assert.IsTrue(parents.Any());
}
}
}
public void CreateCoachTest()
{
var context = new Core.Data.CSBCDbContext();
var rep = new CoachRepository(context);
Debug.Assert(context.People != null, "context.People != null");
var coach = new Coach
{
CompanyID = 1,
PeopleID = context.People.FirstOrDefault().PeopleID,
SeasonID = context.Seasons.First(s => s.CurrentSeason == true).SeasonID,
CoachPhone = "999-000-9090"
};
var i = rep.Insert(coach);
Assert.IsTrue(coach.CoachID > 0);
}
public void InsertPersonTest()
{
var context = new Core.Data.CSBCDbContext();
var repHouse = new HouseholdRepository(context);
var houses = repHouse.GetByName(TestUtils.Household1);
var house = houses.FirstOrDefault();
var rep = new PersonRepository(context);
int no= rep.Insert(new Person {
CompanyID = TestUtils.CompanyId, FirstName = "Sam", LastName = "Fred", HouseID = house.HouseID })
.PeopleID;
Assert.IsTrue(no > 0);
}
public void InitTest()
{
var context = new Core.Data.CSBCDbContext();
var init = new CSBCDbInitializer();
//init.InitCoaches(context);
//init.InitPersonTest(context);
}
public void UpdateCoachesTest()
{
var context = new Core.Data.CSBCDbContext();
var testinit = new CSBCDbInitializer();
var rep = new CoachRepository(context);
var coach = context.Coaches.FirstOrDefault();
coach.ShirtSize = shirtSize;
coach.CoachPhone = coachPhone;
rep.Update(coach);
var newcoach = rep.GetById(coach.CoachID);
Assert.IsTrue(newcoach.ShirtSize == shirtSize);
Assert.IsTrue(newcoach.CoachPhone == coachPhone);
}
public void InitTest()
{
using (var context = new Core.Data.CSBCDbContext())
{
var init = new CSBCDbInitializer();
init.InitHouseholds(context);
}
}
