public static bool ColorUsed(int id)
{
using (var db = new CSBCDbContext())
{
return db.Teams.Any(t => t.TeamColorID == id);
}
}
protected void LoadTotals()
{
var oSeasonCounts = new CSBC.Components.Season.ClsSeasons();
DataTable rsData = default(DataTable);
using (var ctx = new CSBCDbContext())
{
var idParam = new SqlParameter
{
ParameterName = "CompanyID",
Value = 1
};
}
try
{
rsData = oSeasonCounts.GetSeasonCounts(Master.SeasonId, Master.CompanyId);
var x = rsData.Rows.Count;
grdTotals.DataSource = rsData;
grdTotals.DataBind();
grdTotals.Columns[0].Visible = false;
}
catch (Exception ex)
{
lblError.Text = "Invalid Username/Password " + ex.ToString();
}
}
public void CreateSponsorProfileTest()
{
using (var db = new CSBCDbContext())
{
var repPeople = new PersonRepository(db);
var people = db.People.Where(p => p.Sponsor == true).ToList();
var repColor = new ColorRepository(db);
var color = repColor.GetByName(1, "Red").ID;
Contract.Assert(color != 0);
var repProfile = new SponsorProfileRepository(db);
var person = people.FirstOrDefault();
var sponsorProfile = repProfile.Insert(new SponsorProfile
{
SpoName = person.LastName + "Company",
SponsorProfileID = 0,
CompanyID = 1,
HouseID = person.HouseID,
State = "FL",
City = "Coral Springs",
Address = "10 Main Street",
ContactName = person.FirstName + " " + person.LastName
});
var profile = repProfile.GetById(sponsorProfile.SponsorProfileID);
Assert.IsTrue(profile != null);
repProfile.Delete(profile);
profile = repProfile.GetById(sponsorProfile.SponsorProfileID);
Assert.IsTrue(profile == null);
}
}
// GET api/<controller>
public List<ScheduleGame> Get()
{
using (var db = new CSBCDbContext())
{
var rep = new ScheduleGameRepository(db);
return rep.GetAll().ToList();
}
}
public void GetDivisionTeamsTest()
{
var csbcDbContext = new CSBCDbContext();
var rep = new TeamRepository(csbcDbContext);
var divisions = csbcDbContext.Divisions.Select(s => s);
var teams = rep.GetTeams(divisions.First<Division>().DivisionID);
Assert.IsTrue(teams.Any<Team>());
}
public void GetUserAccessTest()
{
var dataContext = new CSBCDbContext();
var tester = new TestUtils(dataContext);
var rep = new UserRepository(new CSBCDbContext());
var user = dataContext.Users.FirstOrDefault(n => (n.UserName == (tester.HouseholdLastNames[0] + "1")) && (n.PWord == tester.HouseholdLastNames[0]));
Assert.IsTrue(user.HouseID != 0);
//return user.SeasonID
}
private void SetPersonObject(int personId)
{
using (var db = new CSBCDbContext())
{
var rep = new PersonRepository(db);
var person = rep.GetById(personId);
Master.Person = person;
}
}
public void GetSponsorsInSeasonTest()
{
using (var db = new CSBCDbContext())
{
var repProfile = new SponsorProfileRepository(db);
var sponsors = repProfile.GetSponsorsInSeason(1, 9);
Assert.IsTrue(sponsors.Any());
}
}
// GET api/<controller>
public IEnumerable<object> Get()
{
using (var db = new CSBCDbContext())
{
var repo = new DirectorRepository(db);
var data = repo.GetAll(1);
return data;
}
}
public void CleanupTest()
{
using (var context = new CSBCDbContext())
{
var init = new CSBCDbInitializer();
init.DeleteTestPeople(context);
init.DeleteTestHouseholds(context);
}
}
public List<SeasonPlayer> GetDivisionPlayers(int divisionId)
{
using (var db = new CSBCDbContext())
{
var rep = new PlayerRepository(db);
var players = rep.GetDivisionPlayers(divisionId);
return players.ToList();
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (var db = new CSBCDbContext())
{
var repo = new PlayerRepository(db);
Players = repo.GetDivisionPlayers(757).ToList();
ObjectDataSource1.DataBind();
}
}
public static Player LastSeason(int peopleId)
{
using (var db = new CSBCDbContext())
{
var rep = new PlayerRepository(db);
var player = rep.GetLastSeasonPlayed(peopleId);
return player;
}
}
public void GetGamesAllTeamTest()
{
using (var db = new CSBCDbContext())
{
var rep = new ScheduleGameRepository(db);
var table = rep.GetGames(1, 7, 0, "MEN", "");
Assert.IsTrue(table.Tables[0].Rows.Count > 0);
}
}
public static void Insert(Color entity)
{
using (var db = new CSBCDbContext())
{
var rep = new ColorRepository(db);
rep.Insert(entity);
db.SaveChanges();
}
}
public void GetByIdSponsorProfileTest()
{
var context = new CSBCDbContext();
var repProfile = new SponsorProfileRepository(context);
var profile = context.SponsorProfiles.First<SponsorProfile>();
var profile2 = repProfile.GetById(profile.SponsorProfileID);
Assert.IsTrue(profile2 != null);
Assert.IsTrue(profile2.SponsorProfileID == profile.SponsorProfileID);
}
public void GameSchedulesGetAllTest()
{
using (var db = new CSBCDbContext())
{
var rep = new ScheduleGameRepository(db);
var games = rep.GetAll();
Assert.IsTrue(games.Any());
}
}
public void GetEmailGroupTest()
{
using (var context = new CSBCDbContext())
{
var testinit = new TestUtils(context);
var rep = new PersonRepository(context);
//var people = rep.GetByGroup(1, testinit);
}
}
public void InitColors(CSBCDbContext context)
{
var rep = new ColorRepository(context);
for (int i = 0; i < ColorNames.Count; i++)
{
rep.Insert(new Color { ColorName = ColorNames[i], CompanyID = 1 });
}
rep.Insert(new Color { ColorName = "Chartreuse", CompanyID = 1, Discontinued = true });
context.SaveChanges();
}
public void GetSummaryTest()
{
var context = new CSBCDbContext();
var rep = new SummaryRepository(context);
var repSeason = new SeasonRepository(context);
var current = repSeason.GetCurrentSeason(1);
rep.GetSummary(1, current.SeasonID);
Assert.IsTrue(false);
}
protected void Page_Load(System.Object sender, System.EventArgs e)
{
//Put user code to initialize the page here
if (!IsPostBack)
{
Session["UserID"] = null;
var db = new CSBCDbContext();
db.TestMode = false;
}
}
protected List<Division> GetDivisionList(int seasonId)
{
using (var db = new CSBCDbContext())
{
var rep = new DivisionRepository(db);
var divisions = rep.GetDivisions(seasonId).ToList<Division>();
return divisions;
}
}
public void LoadPlayerHistory(int personId)
{
using (var db = new CSBCDbContext())
{
var rep = new PlayerRepository(db);
PlayerHistoryList = rep.GetPlayerHistory(personId);
gridPlayerHistory.DataSource = PlayerHistoryList;
gridPlayerHistory.DataBind();
}
}
protected void LoadPayments(int sponsorProfileId)
{
using (var context = new CSBCDbContext())
{
var rep = new SponsorPaymentRepository(context);
var payments = rep.GetSponsorPayments(sponsorProfileId);
grd.DataSource = payments;
grd.DataBind();
}
}
public void GetUserByHouseholdIDTest()
{
using (var db = new CSBCDbContext())
{
var tester = new TestUtils(db);
var house = new HouseholdRepository(db).GetByName(tester.HouseholdLastNames[1]).First<Household>();
var rep = new UserRepository(db);
var user = rep.GetUserByHouseId(house.HouseID);
Assert.IsTrue(user != null);
}
}
public void DeletePlayerTest()
{
var context = new CSBCDbContext();
var player = new Player { DivisionID = 25, PeopleID = 2, CompanyID = 1, CoachID = 2, SeasonID = 2 };
var rep = new PlayerRepository(context);
var id = rep.Insert(player);
Assert.IsTrue(context.Players.Any<Player>(p => p.CompanyID == 1 && p.SeasonID == 2 && p.DivisionID == 25));
rep.Delete(player);
Assert.IsTrue(context.Players.Find(id) == null);
}
public void PopulateList()
{
using (var db = new CSBCDbContext())
{
var rep = new DirectorRepository(db);
var board = rep.GetAll().ToList<Director>().Where(b => b.CompanyID == 1).OrderBy(b => b.Seq);
repBoard.DataSource = board;
repBoard.DataBind();
}
}
public void InitTest()
{
using (var context = new CSBCDbContext())
{
var tester = new CSBCDbInitializer();
tester.InitHouseholds(context);
tester.InitPersonTest(context);
tester.InitColors(context);
tester.InitDivision(context);
tester.InitTeams(context);
}
}
public void GetDirectorVolunteersTest()
{
using (var db = new CSBCDbContext())
{
var rep = new DirectorRepository(db);
var records = rep.GetDirectorVolunteers(1);
Assert.IsTrue(records.Any());
foreach(vw_Directors record in records)
{
Assert.IsTrue(record.PeopleID != 0);
Assert.IsTrue(record.Name != String.Empty);
}
}
}
protected void InitializeVariables(CSBCDbContext context)
{
if (Session["CompanyID"] == null)
Session["CompanyID"] = 1;
if (Session["SeasonID"] == null)
{
var seasonrep = new SeasonRepository(context);
var season = seasonrep.GetCurrentSeason(GetSessionCompany());
Session["SeasonID"] = season.SeasonID;
//lblSeason.Text = season.Sea_Desc;
}
//test other variables
}
