Example #1
0
        public void GetGameScheduleTest()
        {
            var vm = new Csbchoops.Web.ViewModels.GameSchedulesViewModel();

            var games = vm.GetGames(71);
            Assert.IsTrue(games.Any());
        }
Example #2
0
        private List<GameSchedulesViewModel> GetPlayoffGames(int divisionId)
        {
            using (var db = new CSBCDbContext())
            {
                var games = (from g in db.SchedulePlayoffs
                             from l in db.ScheduleLocations
                             from d in db.Divisions
                             where g.DivisionId == divisionId
                             where g.LocationNumber == l.LocationNumber
                             where g.DivisionId == d.DivisionID
                             select new
                             {
                                 g.ScheduleNumber,
                                 d.DivisionID,
                                 g.GameDate,
                                 g.GameTime,
                                 d.Div_Desc,
                                 g.LocationNumber,
                                 l.LocationName,
                                 g.GameNumber,
                                 g.HomeTeam,
                                 g.VisitingTeam,
                                 g.Descr
                             });
                var schedGames = new List<GameSchedulesViewModel>();
                DateTime time;
                foreach (var g in games)
                {
                    var game = new GameSchedulesViewModel();

                    game.ScheduleNumber = g.ScheduleNumber;
                    //game.DivisionId = g.DivisionID;
                    game.GameDate = (DateTime)g.GameDate;
                    if (DateTime.TryParse(g.GameTime, out time))
                        game.GameTime = time;
                    //game.D = g.Div_Desc;
                    //game.LocationNumber = (int)g.LocationNumber;
                    game.LocationName = g.LocationName;
                    game.GameNumber = g.GameNumber;
                    game.HomeTeamName = g.HomeTeam;
                    game.VisitingTeamName = g.VisitingTeam;
                    game.GameDescription = g.Descr;
                    //game.GameType = GameTypes.Playoff;
                    schedGames.Add(game);
                }

                if (divisionId != 0)
                {
                    schedGames = schedGames
                    .OrderBy(g => g.GameDate).ThenBy(g => g.GameTime).ThenBy(g => g.DivisionID).ToList<GameSchedulesViewModel>();
                }
                return schedGames;
            }
        }
Example #3
0
        private void LoadSchedule(int divisionId, int teamId)
        {
            if (panelGames.Visible)
            {
                try
                {
                    if (cbAllTeams.Checked)
                        teamId = 0;
                    var vm = new GameSchedulesViewModel();
                    var games = new List<GameSchedulesViewModel>();
                    if (teamId == 0)
                    {
                        games = vm.GetGames(Convert.ToInt32(Session["SeasonID"]), divisionId);
                    }
                    else
                    {
                        games = vm.GetGames(Convert.ToInt32(Session["SeasonID"]), divisionId, teamId);
                    }

                    var grid = grdSchedule;
                    grid.DataSource = games.OrderBy(g => g.GameDate);
                    grid.DataBind();
                    if (divisionId > 0)
                    {
                        //lblTitle.Text = games..FirdivisionDescription + " Schedule";
                    }
                    //if (iTeam > 0)
                    //{
                    //    lblTitle.Text = divisionDescription + " Team " + sTeamDesc + " Schedule";
                    //}
                    Session["ScheduleNo"] = divisionId;
                    //Session["ScheduleDesc"] = divisionDescription;
                    //Session["TeamName"] = sTeamDesc;
                    Session["ReportName"] = "Schedules";
                    cobTeams.Visible = true;
                    grdSchedule.Columns[9].Visible = ((Session["Editing"] != null & Session["Editing"] == "All") ||
                        (Session["User"] != null & CheckAD(Convert.ToInt32(ddlDivisions.SelectedValue), (User)Session["User"]))
                        );
                    //btnSubmit.Visible = false;
                }
                catch (Exception ex)
                {
                    //lblError.Text = "LoadSchedule:" + ex.Message;
                }
            }
        }
Example #4
0
 public void GetGameScheduleByDivisionandTeamTest()
 {
     var vm = new Csbchoops.Web.ViewModels.GameSchedulesViewModel();
     var games = vm.GetGames(71, 757, 4615);
     Assert.IsTrue(games.Any());
 }