private void seasonTreeView_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e) { seasonTreeView.SelectedNode = e.Node; if (e.X <= 20) { return; } if (e.Node.IsExpanded) { e.Node.Collapse(); } else { e.Node.Expand(); } if (e.Node.Level == 1) { selectedRound = e.Node.Tag as round; lblPlaces.Hide(); ShowRound(); } else { selectedSeason = e.Node.Tag as season; lblPlaces.Show(); ShowSeason(); } }
//common lib public int Insert(season entity) { try { //Thêm mùa giải if (entity.start_date_at >= entity.end_date_at) { return(-2); } db.seasons.Add(entity); db.SaveChanges(); //Cập nhật số vòng đấu trong mua giải tương ứng với số đội tham gia int num_round = (int)(entity.number_club * (entity.number_club - 1) / (entity.number_club / 2)); var model_round = db.rounds.Where(x => x.tournament_id == entity.tournamnet_id).OrderBy(x => x.display_order).Take(num_round).ToList(); foreach (var item in model_round) { Insert_SeasonRound(entity.id, item.id); } return(1); } catch (Exception) { return(-1); } }
/*------------------------------------------------------------------------- * 更新 * 季節が変わったときtrueを返す * ---------------------------------------------------------------------------*/ public bool UpdateSeason() { bool ret = false; DateTime now = DateTime.Now; long ticks = now.Ticks - m_base_season_start.Ticks; long t = ticks / TimeSpan.FromHours(9).Ticks; if (t < 0) { t--; } // 偶数なら夏、奇数なら冬 season now_s = ((t & 1) == 0)? season.summer: season.winter; if (now_s != m_now_season) { ret = true; // 季節が変わった } m_now_season = now_s; // 今回得たの季節 // 今回の変動開始日時 m_now_season_start = m_base_season_start.AddHours((t + 0) * 9); // Debug.WriteLine(TojbbsDateTimeString(m_now_season_start)); // 次回の変動開始日時 m_next_season_start = m_base_season_start.AddHours((t + 1) * 9); // Debug.WriteLine(TojbbsDateTimeString(m_next_season_start)); // 季節が変わったかどうかを返す return(ret); }
/*------------------------------------------------------------------------- * * ---------------------------------------------------------------------------*/ public gvo_season() { // 夏の基準となる日時 // 未来でも過去でもよい m_base_season_start = new DateTime(2010, 3, 2, 13, 30, 0); // 夏 m_now_season = season.MAX; // 更新 UpdateSeason(); }
/*------------------------------------------------------------------------- * 季節を文字列で返す * ---------------------------------------------------------------------------*/ public static string ToSeasonString(season s) { switch (s) { case season.summer: return("夏"); case season.winter: return("冬"); } return("不明"); }
public long GetCurrentSeasonId(long leagueId, DateTime date) { season _season = null; using (var context = new escorcenterdbEntities()) { _season = (from s in context.seasons where s.league == leagueId && s.dateFrom <= date && s.dateTo >= date && s.enabled == true select s).FirstOrDefault <season>(); } if (_season == null) { return(0); } return(_season.id); }
public IHttpActionResult CreateSeason([FromBody] SeasonDTO _season) { season s = new season() { description = _season.Description, league = (int)_season.League, dateFrom = DateTime.Now, dateTo = new DateTime(2016, 04, 29), title = _season.Title }; using (var context = new escorcenterdbEntities()) { context.seasons.Add(s); context.SaveChanges(); } return(Ok(s)); }
public ActionResult Details(string name, int?year) { //initialize the year to 2016. year = year ?? 2016; season season = db.seasons.FirstOrDefault(s => s.tournament.name == name && s.year == year); if (season == null) { return(HttpNotFound()); } ViewBag.years = db.seasons.Select(s => s.year).Distinct().ToList(); return(View(season)); }
public bool Update(season entity) { try { var info = db.seasons.Find(entity.id); info.name = entity.name; info.start_date_at = entity.start_date_at; info.end_date_at = entity.end_date_at; info.number_club = entity.number_club; info.display_order = entity.display_order; info.is_active = entity.is_active; db.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public IHttpActionResult GetPastMatchesByLeagueId(long leagueId) { DateTime now = DateTime.Now; long seasonId = GetCurrentSeasonId(leagueId, now); if (seasonId < 0) { return(Ok()); } season _season = null; List <WeekDTO> weeks = new List <WeekDTO>(); using (var context = new escorcenterdbEntities()) { week[] _weeks = (from w in context.weeks where w.enabled == true && w.season == seasonId && w.dateFrom <= now select w).OrderByDescending(w => w.dateFrom).ToArray <week>(); foreach (week _week in _weeks) { WeekDTO week = GetPastMatchesByWeekId(_week.id, now); if (week != null) { weeks.Add(week); } } _season = (from s in context.seasons where s.id == seasonId select s).FirstOrDefault <season>(); } if (_season == null) { return(Ok()); } SeasonDTO season = new SeasonDTO { Title = _season.title, DateFrom = _season.dateFrom.ToString(), DateTo = _season.dateTo.ToString(), Description = _season.description, Id = _season.id, League = _season.league }; season.Weeks.AddRange(weeks); return(Ok(season)); }
private void btnAdd_Click(object sender, EventArgs e) { if (database.seasons.FirstOrDefault(s => s.deleted == 0 && s.name == fldSeason.Text) != null) { new ErrorPopup("Naziv sezone mora biti jedinstven!").ShowDialog(this); } else { Season = new season() { name = fldSeason.Text.Trim(), deleted = 0 }; database.seasons.Add(Season); database.SaveChanges(); Success = true; Close(); } }
protected void Button1_Click1(object sender, EventArgs e) { { using (DataClasses1DataContext db = new DataClasses1DataContext()) { try { var goal = new season(); goal.season_id = Convert.ToInt32(TextBox1.Text); goal.date_start = Convert.ToDateTime(TextBox3.Text); goal.date_end = Convert.ToDateTime(TextBox3.Text); if (CheckBox1.Checked) { goal.category = 'P'; } else if (CheckBox2.Checked) { goal.category = '1'; } else if (CheckBox3.Checked) { goal.category = '2'; } else if (CheckBox4.Checked) { goal.category = '3'; } db.seasons.InsertOnSubmit(goal); db.SubmitChanges(); BindGridView(); } catch (System.Exception excep) { ch_(); } } } }
void UpdateSeason() { if (daysSinceYearStart < seasonLengthSpring) { currentSeason = season.SPRING; } if ((daysSinceYearStart >= seasonLengthSpring) && (daysSinceYearStart < seasonLengthSpring + seasonLengthSummer)) { currentSeason = season.SUMMER; } if ((daysSinceYearStart >= seasonLengthSpring + seasonLengthSummer) && (daysSinceYearStart < seasonLengthSpring + seasonLengthSummer + seasonLengthAutumn)) { currentSeason = season.AUTUMN; } if (daysSinceYearStart >= seasonLengthSpring + seasonLengthSummer + seasonLengthAutumn) { currentSeason = season.WINTER; Debug.Log(currentSeason); } }
public ActionResult Edit(season season) { if (ModelState.IsValid) { var dao = new season_dao(); var result = dao.Update(season); if (result) { SetAlert(StaticResources.Resources.Pub_UpdateSucess, "success"); return(RedirectToAction("Index", "Season")); } else { ModelState.AddModelError("", StaticResources.Resources.UpdateSeasonFailed); } } SetListTournament(season.tournamnet_id); return(View()); }
/*------------------------------------------------------------------------- * 更新 * ---------------------------------------------------------------------------*/ public void UpdateSeason() { DateTime now = DateTime.Now; long ticks = now.Ticks - m_base_season_start.Ticks; long t = ticks / TimeSpan.FromHours(9).Ticks; if (t < 0) { t--; } // 偶数なら夏、基数なら冬 m_now_season = ((t & 1) == 0)? season.summer: season.winter; // 今回の変動開始日時 m_now_season_start = m_base_season_start.AddHours((t + 0) * 9); // Debug.WriteLine(TojbbsDateTimeString(m_now_season_start)); // 次回の変動開始日時 m_next_season_start = m_base_season_start.AddHours((t + 1) * 9); // Debug.WriteLine(TojbbsDateTimeString(m_next_season_start)); }
public ActionResult Create(season season) { if (ModelState.IsValid) { var dao = new season_dao(); int result = dao.Insert(season); if (result == 1) { SetAlert(StaticResources.Resources.Pub_InsertSuccess, "success"); return(RedirectToAction("Index", "Season")); } else if (result == -2) { ModelState.AddModelError("", "Ngày bắt đầu phải nhỏ hơn ngày kết thúcss"); } else if (result == -1) { ModelState.AddModelError("", StaticResources.Resources.InsertSeasonFailed); } } SetListTournament(season.tournamnet_id); return(View()); }
public ActionResult <season> Postseason([FromBody] season c) { _context.seasons.Add(c); _context.SaveChanges(); return(Ok(c)); }
public IHttpActionResult GetResultTable(int leagueId) { long seasonId = GetCurrentSeasonId(leagueId, DateTime.Now); if (seasonId == 0) { return(Ok()); } scoretableview[] _scoreTable = null; season _season = null; List <ScoreTableResultDTO> scoreTable = new List <ScoreTableResultDTO>(); using (var context = new escorcenterdbEntities()) { _scoreTable = (from st in context.scoretableviews where st.season == seasonId select st).OrderBy(st => st.GamesWon.Value * 3 + st.GamesDrawn.Value * 1).ToArray <scoretableview>(); _season = (from s in context.seasons where s.id == seasonId && s.enabled == true select s).FirstOrDefault <season>(); if (_scoreTable == null || _season == null) { return(NotFound()); } foreach (scoretableview st in _scoreTable) { team _team = (from t in context.teams where t.Id == st.team select t).FirstOrDefault <team>(); String leagueName = getLeagueNameById(_team.League); ScoreTableResultDTO result = new ScoreTableResultDTO { Team = AutoMapper.Mapper.Map <team, TeamDTO>(_team), GamesDrawn = st.GamesDrawn.Value, GamesLost = st.GamesLost.Value, GamesPlayed = st.GamesPlayed.Value, GamesWined = st.GamesWon.Value, //Cambiar esto a hacerlo dinamico, no solo para el fut Points = st.GamesWon.Value * 3 + st.GamesDrawn.Value * 1, ScoreAgainst = (long)st.ScoreAgainst.Value, ScoreDifference = (long)st.ScoreDifference.Value, ScoreFavor = (long)st.ScoreFavor.Value, League = leagueName }; scoreTable.Add(result); } } if (_season == null) { return(Ok()); } scoreTable.OrderBy(r => r.Points); SeasonDTO season = new SeasonDTO { DateFrom = _season.dateFrom.ToString(), DateTo = _season.dateTo.ToString(), Description = _season.description, Id = _season.id, League = _season.league, Title = _season.title }; season.ScoreTableResult.AddRange(scoreTable); return(Ok(season)); }