public void ShouldExerciseScheduleGameRepositoryNHibernate()
{
var gameRepo = new ScheduleGameRepository(new RepositoryNHibernate <ScheduleGame>());
//IEnumerable<ScheduleGame> GetGamesForDay(int day, int year);
for (int i = 0; i < 7; i++)
{
gameRepo.Update(new ScheduleGame(null, i, i % 2, 1, null, null, null, null, 0, 0, false, 1, 0, null, false));
}
for (int i = 7; i < 22; i++)
{
gameRepo.Update(new ScheduleGame(null, i, i % 2 + 2, 2, null, null, null, null, 0, 0, false, 1, 0, null, false));
}
StrictEqual(4, gameRepo.GetGamesForDay(0, 1).Count());
StrictEqual(3, gameRepo.GetGamesForDay(1, 1).Count());
StrictEqual(7, gameRepo.GetGamesForDay(2, 2).Count());
StrictEqual(8, gameRepo.GetGamesForDay(3, 2).Count());
//IEnumerable<ScheduleGame> GetInCompleteGamesForDay(int day, int year);
gameRepo.Update(new ScheduleGame(null, 22, 3, 2, null, null, null, null, 0, 0, true, 1, 0, null, false));
gameRepo.Update(new ScheduleGame(null, 23, 3, 2, null, null, null, null, 0, 0, true, 1, 0, null, false));
StrictEqual(10, gameRepo.GetGamesForDay(3, 2).Count());
StrictEqual(8, gameRepo.GetInCompleteGamesForDay(3, 2).Count());
//IEnumerable<ScheduleGame> GetCompleteAndUnProcessedGamesForDay(int day, int year);
StrictEqual(2, gameRepo.GetCompleteAndUnProcessedGamesForDay(3, 2).Count());
//IEnumerable<ScheduleGame> GetInCompleteOrUnProcessedGamesForDay(int day, int year);
StrictEqual(17, gameRepo.GetInCompleteOrUnProcessedGamesOnOrBeforeDay(3, 2).Count());
}
// GET api/<controller>
public List<ScheduleGame> Get()
{
using (var db = new CSBCDbContext())
{
var rep = new ScheduleGameRepository(db);
return rep.GetAll().ToList();
}
}
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 void GameSchedulesGetAllTest()
{
using (var db = new CSBCDbContext())
{
var rep = new ScheduleGameRepository(db);
var games = rep.GetAll();
Assert.IsTrue(games.Any());
}
}
private void AddRegularSeasonGame(int scheduleNo)
{
using (var db = new CSBCDbContext())
{
var rep = new ScheduleGameRepository(db);
var game = new ScheduleGame();
try
{
game.ScheduleNumber = scheduleNo;
game.GameDate = (DateTime)ConcatDateTime(mskDate.Text, txtTime.Text);
game.GameTime = txtTime.Text;
game.HomeTeamNumber = ScheduleGamesVM.GetScheduleTeamNumberFromTeamNumber(ScheduleNo, Convert.ToInt32(txtHome.Text));
game.VisitingTeamNumber = ScheduleGamesVM.GetScheduleTeamNumberFromTeamNumber(ScheduleNo, Convert.ToInt32(txtVisitor.Text));
game.LocationNumber = Convert.ToInt32(cmbVenues.SelectedItem.Value);
if (game.VisitingTeamScore == null)
game.VisitingTeamScore = -1;
else
game.VisitingTeamScore = game.VisitingTeamScore;
if (game.HomeTeamScore == null)
game.HomeTeamScore = -1;
else
game.HomeTeamScore = game.HomeTeamScore;
game.DivisionId = Int32.Parse(ddlDivisions.SelectedValue);
game.SeasonId = Master.SeasonId;
//_with1.Descr = txtDescr.Text;
var newGame = rep.Insert(game);
db.SaveChanges(); //this should be in UOM!
GameNo = newGame.GameNumber;
}
catch (Exception ex)
{
Session["ErrorMSG"] = "ADDRow::" + ex.Message;
}
}
}
public static void UpdateScore(int gameNo, int divisionId, int homeScore, int visitorScore)
{
using (var db = new CSBCDbContext())
{
var rep = new ScheduleGameRepository(db);
var game = db.ScheduleGames.FirstOrDefault(g => g.GameNumber == gameNo && g.DivisionId == divisionId);
if (game != null)
{
game.HomeTeamScore = homeScore;
game.VisitingTeamScore = visitorScore;
rep.Update(game);
}
}
}
public void Initialize()
{
_mockRepository = new Mock<IScheduleGameRepository>();
_modelState = new ModelStateDictionary();
_service = new ScheduleGameService(new ModelStateWrapper(_modelState), _mockRepository.Object);
using (var db = new CSBCDbContext())
{
var rep = new ScheduleGameRepository(db);
db.ScheduleGames.Add(
new ScheduleGame {
ScheduleNumber=1001,
GameNumber = 1,
HomeTeamNumber = 10 });
}
}
public void GetSeasonGamesTest()
{
using (var db = new CSBCDbContext())
{
var rep = new ScheduleGameRepository(db);
var games = rep.GetSeasonGames(757);
Assert.IsTrue(games.Any());
}
}
public void TestGetGamesByDate()
{
using (var db = new CSBCDbContext())
{
var rep = new ScheduleGameRepository(db);
var venues = rep.GetAll();
Assert.IsTrue(venues.Any());
}
}
public List<ScheduleGamesVM> GetGames(int divisionId)
{
using (var db = new CSBCDbContext())
{
var rep = new ScheduleGameRepository(db);
var games = (from g in db.ScheduleGames
from d in db.Divisions
from l in db.ScheduleLocations
where (g.DivisionId == divisionId)
where (d.DivisionID == divisionId)
where (g.LocationNumber == l.LocationNumber)
select new
{
g.ScheduleNumber,
g.DivisionId,
g.GameDate,
g.GameTime,
d.Div_Desc,
g.LocationNumber,
l.LocationName,
g.GameNumber,
HomeTeamNo = db.Set<ScheduleDivTeam>().FirstOrDefault(t => t.TeamNumber == g.HomeTeamNumber).ScheduleTeamNumber,
VisitorTeamNo = db.Set<ScheduleDivTeam>().FirstOrDefault(t => t.TeamNumber == g.VisitingTeamNumber).ScheduleTeamNumber
});
var schedGames = new List<ScheduleGamesVM>();
var teams = db.Set<Team>().Where(t => t.DivisionID == divisionId).ToList<Team>();
foreach (var g in games)
{
var game = new ScheduleGamesVM();
game.ScheduleNumber = g.ScheduleNumber;
game.DivisionId = (int)g.DivisionId;
game.GameDate = (DateTime)g.GameDate;
game.GameTime = g.GameTime;
game.Division = g.Div_Desc;
game.LocationNumber = (int)g.LocationNumber;
game.LocationName = g.LocationName;
game.GameNumber = g.GameNumber;
game.HomeTeam = GetTeamName(teams, g.HomeTeamNo);
game.VisitorTeam = GetTeamName(teams, g.VisitorTeamNo);
game.GameType = GameTypes.Regular;
schedGames.Add(game);
}
schedGames = schedGames.Where(g => g.DivisionId == divisionId)
.OrderBy(g => g.GameDate).ThenBy(g => g.GameTime).ThenBy(g => g.DivisionId).ToList<ScheduleGamesVM>();
return schedGames;
}
}
public ScheduleGame GetByScheduleAndGameNo(int scheduleNo, int gameNo)
{
using (var db = new CSBCDbContext())
{
var rep = new ScheduleGameRepository(db);
var game = rep.GetByScheduleAndGameNo(scheduleNo, gameNo);
return game;
}
}
private void LoadSchedule(string sDivDesc, int iDiv, string sTeamDesc, int iTeam)
{
ScheduleGameRepository oGames = new ScheduleGameRepository(new CSBC.Core.Data.CSBCDbContext());
DataSet dataset = default(DataSet);
DataTable rsData = default(DataTable);
try
{
dataset = oGames.GetGames(1, iDiv, iTeam, sDivDesc, sTeamDesc);
rsData = dataset.Tables(0);
//CreateXML(rsData)
var _with3 = grdSchedule;
_with3.DataSource = rsData;
_with3.DataBind();
if (iDiv > 0)
{
lblTitle.Text = sDivDesc + " Schedule";
}
if (iTeam > 0)
{
lblTitle.Text = sDivDesc + " Team " + sTeamDesc + " Schedule";
}
Session["ScheduleNo"] = iDiv;
Session["ScheduleDesc"] = sDivDesc;
Session["TeamName"] = sTeamDesc;
Session["ReportName"] = "Schedules";
cobTeams.Visible = true;
lblTeams.Visible = true;
lblUsername.Visible = false;
txtUser.Visible = false;
lblPassword.Visible = false;
txtPwd.Visible = false;
btnSubmit.Visible = false;
lnkForgot.Visible = false;
lblLocation.Visible = false;
lblHome.Visible = false;
lblDate.Visible = false;
lblVisitor.Visible = false;
btnUpdate.Visible = false;
txtVScores.Visible = false;
txtHScores.Visible = false;
//imgStandings.Visible = True
lblError.Text = "";
}
catch (Exception ex)
{
lblError.Text = "LoadSchedule:" + ex.Message;
}
finally
{
oGames = null;
rsData = null;
}
}
public List<ScheduleStandingsViewModel> GetStandings(int divisionNo)
{
//var sql = "Exec GetStanding @ScheduleNumber = " + divisionNo.ToString();
//DataTable whatIsThis = db.ExecuteGetSQL(sql);
using (var db = new CSBCDbContext())
{
var rep = new ScheduleGameRepository(db); //make this a method here....
var games = rep.GetSeasonGames(divisionNo).ToList<ScheduleGame>();
var teams = GetDivisionTeams(divisionNo);
var teamRecords = GetTeamRecords(teams, games);
return teamRecords.OrderByDescending(t => t.Pct).ThenByDescending(t => t.Won).ToList();
}
}
private List<ScheduleStandingsViewModel> GetTeamRecords(List<Team> teams, List<ScheduleGame> games)
{
using (var db = new CSBCDbContext())
{
var teamRecords = new List<ScheduleStandingsViewModel>();
var rep = new ScheduleGameRepository(db);
foreach (var team in teams)
{
var teamRecord = GetTeamRecord(team, games);
teamRecords.Add(teamRecord);
}
return teamRecords;
}
}
