protected void LoadLatesActiveEvent() { 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 && eg.EventID == GetActiveEvent().ToInt() orderby eg.StartDate select eg).ToList(); } foreach (EventGame eg in eventGamesList) { strWrite += "<table>" + "<tr>" + "<td>" + "<img src='../Support/play16red.png' alt='' />" + "</td>" + "<td style='font-size: 18pt; font-family: Arial; font-weight: bold'>" + eg.StartDate.ToString("MMM dd, yyyy") + "</td>" + "</tr>" + "<tr>" + "<td> </td>" + "<td>" + DALPortal.GetGamePhaseName(eg.GamePhase.ToString()) + "<br/>(" + eg.StartDate.ToString("hh:mm tt") + ", " + eg.Location + ")" + "<br/>" + this.LoadLatestScheduleTeams1(eg.GameID, eg.EventID) + " </td>" + "<tr>" + "</table>"; break; } } litLatestEvent.Text = strWrite; }
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>"; } }
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; }
private void LoadUpcomingSchedules() { //added by rollie 7/29/11 DateTime latestDate = DALPortal.GetLatestGameDate(); DateTime latestDateStart = clsDateTime.ChangeTimeToStart(latestDate); DateTime latestDateEnd = clsDateTime.ChangeTimeToEnd(latestDate); //////// //Add By Charlie Bachiller 2-1-2012 DateTime dtCurrentDate = latestDate; DateTime dtFirstDayOfMonth = new DateTime(); dtFirstDayOfMonth = dtCurrentDate.AddDays(-(dtCurrentDate.Day - 1)); //// using (PortalDataContext pdc = new PortalDataContext()) { var q = (from eg in pdc.EventGames join e in pdc.Events on eg.EventID equals e.EventID into eeg from eegx in eeg.DefaultIfEmpty() //where eg.IsActive == true && eg.StartDate >= latestDateStart && eg.StartDate <= latestDateEnd where eg.IsActive == true && eg.StartDate >= dtFirstDayOfMonth && eg.IsFinished == false orderby eg.StartDate select new { EventID = eg.EventID, EventName = eegx.Name, GameID = eg.GameID, StartDate = eg.StartDate, GamePhase = eg.GamePhase, Location = eg.Location, WinnerTeamID = eg.WinnerTeamID }); //var q = (from eg in pdc.EventGames // join e in pdc.Events on eg.EventID equals e.EventID into eeg // from eegx in eeg.DefaultIfEmpty() // where eg.IsActive == true && eg.StartDate >= DateTime.Now.Date // orderby eg.StartDate // select new // { // EventID = eg.EventID, // EventName = eegx.Name, // GameID = eg.GameID, // StartDate = eg.StartDate, // GamePhase = eg.GamePhase, // Location = eg.Location, // WinnerTeamID = eg.WinnerTeamID // }); dgSchedule.DataSource = q.ToList(); dgSchedule.DataBind(); foreach (DataGridItem ditm in dgSchedule.Items) { HiddenField phdnGameID = (HiddenField)ditm.FindControl("hdnGameID"); Literal plitTeams = (Literal)ditm.FindControl("litTeams"); HiddenField phdnWinner = (HiddenField)ditm.FindControl("hdnWinner"); Image pimgWinner = (Image)ditm.FindControl("imgWinner"); HiddenField phdnGamePhase = (HiddenField)ditm.FindControl("hdnGamePhase"); Label plblGamePhase = (Label)ditm.FindControl("lblGamePhase"); List <EventGameTeam> egtList = new List <EventGameTeam>(); egtList = (from egt in pdc.EventGameTeams where egt.GameID == phdnGameID.Value.ToInt() orderby egt.TeamID select egt).ToList(); foreach (EventGameTeam egt in egtList) { string teamLogo = (from t in pdc.Teams where t.TeamID == egt.TeamID select t.TeamLogo).SingleOrDefault(); if (teamLogo.Length > 0) { plitTeams.Text += "<td ><img src='" + teamLogo + "' Width='50px' Height='50px'></td>"; } } if (plitTeams.Text.Trim().Length > 0) { plitTeams.Text = "<table cellpadding='5'><tr>" + plitTeams.Text + "</tr></table>"; } if (phdnWinner.Value == "" || phdnWinner.Value == "0") { pimgWinner.Visible = false; } else { pimgWinner.ImageUrl = (from t in pdc.Teams where t.TeamID == phdnWinner.Value.ToInt() select t.TeamLogo).SingleOrDefault(); } plblGamePhase.Text = DALPortal.GetGamePhaseName(phdnGamePhase.Value); } } }