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);
}
}
}
