protected void LoadLatestSchedule() { string strWrite = ""; int intCountEvents = 0; DateTime latestDate = DALPortal.GetLatestGameDate(); if (latestDate != DateTime.MinValue) { DateTime latestDateStart = clsDateTime.ChangeTimeToStart(latestDate); DateTime latestDateEnd = clsDateTime.ChangeTimeToEnd(latestDate); List <EventGame> eventGamesList = new List <EventGame>(); using (PortalDataContext pdc = new PortalDataContext()) { eventGamesList = (from eg in pdc.EventGames where eg.IsActive == true && eg.StartDate >= latestDateStart && eg.IsFinished == false orderby eg.StartDate select eg).ToList(); } foreach (EventGame eg in eventGamesList) { if (intCountEvents > 4) { break; } strWrite += "<tr>" + "<td colspan='3' style='border-color: #FFFFFF;'>" + "<b>Event:</b> " + DALPortal.GetEventName(eg.EventID) + "<br />" + "<b>Teams:</b> " + this.LoadLatestScheduleTeams(eg.GameID, eg.EventID) + " <br />" + "<b>Date:</b> " + eg.StartDate.ToString("MMM dd, yyyy") + "<br />" + "<b>Time:</b> " + eg.StartDate.ToString("hh:mm tt") + "<br />" + "<b>Location:</b> " + eg.Location + "<br />" + "</td>" + "</tr>" + "<tr>" + "<td style='height: 5px;' colspan='3'>" + "</td>" + "</tr><br/>"; intCountEvents++; } } litEcheduledEvents.Text = strWrite; }
/////////////////////////////// ///////// Form Events ///////// /////////////////////////////// protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { bool blnHasAccess = clsSystemModule.HasAccess(clsSystemModule.ModuleSynergy, Request.Cookies["Speedo"]["Username"]); hdnGameID.Value = Request.QueryString["gameid"]; ddlStartMonth.DataSource = clsDateTime.GetMonths(); ddlStartMonth.DataValueField = "pvalue"; ddlStartMonth.DataTextField = "ptext"; ddlStartMonth.DataBind(); ddlStartDay.DataSource = clsDateTime.GetDays(); ddlStartDay.DataValueField = "pvalue"; ddlStartDay.DataTextField = "ptext"; ddlStartDay.DataBind(); ddlStartHour.DataSource = clsDateTime.GetHours(); ddlStartHour.DataValueField = "pvalue"; ddlStartHour.DataTextField = "ptext"; ddlStartHour.DataBind(); ddlStartMinute.DataSource = clsDateTime.GetMinutes(); ddlStartMinute.DataValueField = "pvalue"; ddlStartMinute.DataTextField = "ptext"; ddlStartMinute.DataBind(); ddlStartTimePeriod.DataSource = clsDateTime.GetTimePeriod(); ddlStartTimePeriod.DataValueField = "pvalue"; ddlStartTimePeriod.DataTextField = "ptext"; ddlStartTimePeriod.DataBind(); ddlEndMonth.DataSource = clsDateTime.GetMonths(); ddlEndMonth.DataValueField = "pvalue"; ddlEndMonth.DataTextField = "ptext"; ddlEndMonth.DataBind(); ddlEndDay.DataSource = clsDateTime.GetDays(); ddlEndDay.DataValueField = "pvalue"; ddlEndDay.DataTextField = "ptext"; ddlEndDay.DataBind(); ddlEndHour.DataSource = clsDateTime.GetHours(); ddlEndHour.DataValueField = "pvalue"; ddlEndHour.DataTextField = "ptext"; ddlEndHour.DataBind(); ddlEndMinute.DataSource = clsDateTime.GetMinutes(); ddlEndMinute.DataValueField = "pvalue"; ddlEndMinute.DataTextField = "ptext"; ddlEndMinute.DataBind(); ddlEndTimePeriod.DataSource = clsDateTime.GetTimePeriod(); ddlEndTimePeriod.DataValueField = "pvalue"; ddlEndTimePeriod.DataTextField = "ptext"; ddlEndTimePeriod.DataBind(); ddlWinner.DataSource = DALPortal.DSLTeamNA(); ddlWinner.DataValueField = "TeamID"; ddlWinner.DataTextField = "TeamName"; ddlWinner.DataBind(); ddlGamePhase.DataSource = DALPortal.DSLGamePhase(); ddlGamePhase.DataValueField = "pvalue"; ddlGamePhase.DataTextField = "ptext"; ddlGamePhase.DataBind(); using (PortalDataContext pdc = new PortalDataContext()) { EventGame eventGame = (from eg in pdc.EventGames where eg.GameID == hdnGameID.Value.ToInt() select eg).SingleOrDefault(); hdnEventID.Value = eventGame.EventID.ToString(); txtEvent.Text = DALPortal.GetEventName(eventGame.EventID); ddlGamePhase.SelectedValue = eventGame.GamePhase.ToString(); txtStartYear.Text = eventGame.StartDate.Year.ToString(); ddlStartMonth.SelectedValue = eventGame.StartDate.Month.ToString(); ddlStartDay.SelectedValue = eventGame.StartDate.Day.ToString(); ddlStartHour.SelectedValue = eventGame.StartDate.ToString("hh"); ddlStartMinute.SelectedValue = eventGame.StartDate.Minute.ToString(); ddlStartTimePeriod.SelectedValue = eventGame.StartDate.ToString("tt"); txtEndYear.Text = eventGame.EndDate.Year.ToString(); ddlEndMonth.SelectedValue = eventGame.EndDate.Month.ToString(); ddlEndDay.SelectedValue = eventGame.EndDate.Day.ToString(); ddlEndHour.SelectedValue = eventGame.EndDate.ToString("hh"); ddlEndMinute.SelectedValue = eventGame.EndDate.Minute.ToString(); ddlEndTimePeriod.SelectedValue = eventGame.EndDate.ToString("tt"); txtLocation.Text = eventGame.Location; ddlWinner.SelectedValue = eventGame.WinnerTeamID.ToString(); chkFinished.Checked = eventGame.IsFinished; } if (blnHasAccess) { trSaveSchedule.Visible = true; } else { trSaveSchedule.Visible = false; ddlGamePhase.Enabled = false; ddlStartMonth.Enabled = false; ddlStartDay.Enabled = false; txtStartYear.Enabled = false; ddlStartHour.Enabled = false; ddlStartMinute.Enabled = false; ddlStartTimePeriod.Enabled = false; ddlEndMonth.Enabled = false; ddlEndDay.Enabled = false; txtEndYear.Enabled = false; ddlEndHour.Enabled = false; ddlEndMinute.Enabled = false; ddlEndTimePeriod.Enabled = false; txtLocation.ReadOnly = true; txtLocation.BackColor = System.Drawing.Color.AliceBlue; ddlWinner.Enabled = false; chkFinished.Enabled = false; } this.LoadOfficials(); this.LoadCompetingTeams(); } }
protected void LoadLatestSchedule() { string strWrite = ""; int intCountEvents = 0; int intCount = 0; DateTime latestDate = DALPortal.GetLatestGameDate(); if (latestDate != DateTime.MinValue) { DateTime latestDateStart = clsDateTime.ChangeTimeToStart(latestDate); DateTime latestDateEnd = clsDateTime.ChangeTimeToEnd(latestDate); List <EventGame> eventGamesList = new List <EventGame>(); using (PortalDataContext pdc = new PortalDataContext()) { eventGamesList = (from eg in pdc.EventGames where eg.IsActive == true && eg.StartDate >= latestDateStart && eg.IsFinished == false orderby eg.StartDate select eg).ToList(); } intCount = eventGamesList.Count; foreach (EventGame eg in eventGamesList) { if (intCountEvents > 4) { break; } strWrite += "<div class='GridBorder' style='text-align:center;border-color: #FFFFFF; font-size: 11px; line-height:5px'>" + "<table style='width:100%;border-color: #FFFFFF;'>" + "<tr><td style='border-color: #FFFFFF;'><b><a href='" + clsSystemConfigurations.PortalRootURL + "/Synergy/EventDetails.aspx?eventid=" + eg.EventID.ToString() + "'>" + DALPortal.GetEventName(eg.EventID) + "</a></b></td></tr>" + "<tr><td style='border-color: #FFFFFF;'>" + DALPortal.GetGamePhaseName(eg.GamePhase.ToString()) + "</td></tr>" + this.LoadLatestScheduleTeams(eg.GameID, eg.EventID) + "<tr><td style='color:Black;border-color: #FFFFFF;'>" + eg.StartDate.ToString("hh:mm tt ddd, MMM dd") + "</td></tr>" + "<tr><td style='color:Black;border-color: #FFFFFF;'>@ " + eg.Location + "</td></tr>" + "</table><hr/>" + "</div>"; intCountEvents++; } } if (intCount > 0) { masterlitLatestSchedule.Text = "<div class='' ><div class='' style='font-weight:bold'>Game Schedule</div><div class='masterpanelspace'></div>" + strWrite + "</div>"; } }