protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
using (PortalDataContext pdc = new PortalDataContext())
{
var qDivision = (from ed in pdc.EventDivisions
orderby ed.Name
select new { DivisionID = ed.EventDivisionID, Name = ed.Name }).ToList();
ddlDivision.DataSource = qDivision;
ddlDivision.DataValueField = "DivisionID";
ddlDivision.DataTextField = "Name";
ddlDivision.DataBind();
var qCategory = (from ec in pdc.EventCategories
orderby ec.Name
select new { CategoryID = ec.EventCategoryID, Name = ec.Name }).ToList();
ddlCategory.DataSource = qCategory;
ddlCategory.DataValueField = "CategoryID";
ddlCategory.DataTextField = "Name";
ddlCategory.DataBind();
ddlWinner.DataSource = DALPortal.DSLTeamNA();
ddlWinner.DataValueField = "TeamID";
ddlWinner.DataTextField = "TeamName";
ddlWinner.DataBind();
}
}
}
private void LoadActiveTeamScores()
{
string strWrite = "";
int intCount = 0;
using (SqlConnection cn = new SqlConnection(clsSpeedo.SpeedoConnectionString))
{
using (SqlCommand cmd = cn.CreateCommand())
{
cmd.CommandText = "SELECT TeamID,(SELECT Name FROM Portal.Team WHERE ActivityID=@ActivityID AND TeamID=pet.TeamID) AS Name, Rank, Score FROM Portal.EventTeamScore AS pet WHERE EventID=@EventID ORDER BY TeamID";
cmd.Parameters.Add(new SqlParameter("@EventID", GetActiveEvent()));
cmd.Parameters.Add(new SqlParameter("@ActivityID", SynergyCurrentID));
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
strWrite = strWrite + "<tr> " +
"<td><a href='../Synergy/TeamDetails.aspx?teamid=" + dr["TeamID"].ToString() + "'>" + dr["Name"].ToString() + "</a></td>" +
"<td style='text-align:center'>" + DALPortal.CountTotalWon(dr["TeamID"].ToString().ToInt(), GetActiveEvent().ToInt()).ToString() + "</td>" +
"<td style='text-align:center'>" + DALPortal.CountTotalLost(dr["TeamID"].ToString().ToInt(), GetActiveEvent().ToInt()).ToString() + "</td>" +
"</tr>";
}
}
}
lblTeamLineUp.Text = GetActiveEventName() + " Team Standing";
litLineup.Text = strWrite;
}
protected void dgOfficials_DeleteCommand(object source, DataGridCommandEventArgs e)
{
Label plblUsername = (Label)e.Item.FindControl("lblUsername");
DALPortal.DeleteEventGameOfficial(hdnGameID.Value.ToInt(), plblUsername.Text);
this.LoadOfficials();
}
private void SaveReply()
{
bool isSuccess = false;
string username = Request.Cookies["Speedo"]["UserName"];
int threadID = Request.QueryString["threadid"].ToInt();
ThreadDataContext sdc = new ThreadDataContext();
try
{
ThreadReply tr = new ThreadReply
{
ThreadID = threadID,
Username = username,
ReplyContents = ckeReply.Text,
DateReply = DateTime.Now
};
sdc.ThreadReplies.InsertOnSubmit(tr);
sdc.SubmitChanges();
isSuccess = true;
}
catch (Exception ex)
{
DALPortal.LogError(username, MethodBase.GetCurrentMethod().ReflectedType.ToString(), MethodBase.GetCurrentMethod().Name, ex.Message);
}
finally
{
sdc.Dispose();
}
if (isSuccess)
{
Response.Redirect("Thread.aspx?threadid=" + threadID.ToString() + "&page=1");
}
}
protected void dgMatch_DeleteCommand(object source, DataGridCommandEventArgs e)
{
HiddenField phdnGameID = (HiddenField)e.Item.FindControl("hdnGameID");
DALPortal.DeleteEventGame(phdnGameID.Value.ToInt());
this.LoadEventScheduleList();
}
protected void dgCompetingTeams_DeleteCommand(object source, DataGridCommandEventArgs e)
{
HiddenField phdnTeamID = (HiddenField)e.Item.FindControl("hdnTeamID");
DALPortal.DeleteEventGameTeam(hdnGameID.Value.ToInt(), phdnTeamID.Value.ToInt());
this.LoadCompetingTeams();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
hdnTeamID.Value = Request.QueryString["teamid"];
trTeamCompositionEditor.Visible = clsSystemModule.HasAccess(clsSystemModule.ModuleSynergy, Request.Cookies["Speedo"]["Username"]);
Team thread = new Team();
using (PortalDataContext pdc = new PortalDataContext())
{
thread = (from t in pdc.Teams
where t.TeamID == hdnTeamID.Value.ToInt()
select t).SingleOrDefault();
}
txtTeamName.Text = thread.Name;
txtCaptain.Text = thread.Captain;
txtViceCaptain.Text = thread.ViceCaptain;
this.BindTeamComposition();
this.LoadTeamMembers();
imgpnlavatar.ImageUrl = DALPortal.GetTeamLogo(hdnTeamID.Value.ToInt());
btnBack.Attributes.Add("onclick", "history.back(); return false");
}
}
protected void dgPlayers_DeleteCommand(object source, DataGridCommandEventArgs e)
{
Label plblUsername = (Label)e.Item.FindControl("lblUsername");
HiddenField phdnTeamIDP = (HiddenField)e.Item.FindControl("hdnTeamIDP");
DALPortal.DeleteEventGameTeamPlayer(hdnGameID.Value.ToInt(), phdnTeamIDP.Value.ToInt(), plblUsername.Text);
this.LoadCompetingTeams();
}
protected void btnSaveEventTeamScore_Click(object sender, ImageClickEventArgs e)
{
foreach (DataGridItem ditm in dgCompetingTeams.Items)
{
HiddenField phdnTeamID = (HiddenField)ditm.FindControl("hdnTeamID");
TextBox ptxtRank = (TextBox)ditm.FindControl("txtRank");
TextBox ptxtScore = (TextBox)ditm.FindControl("txtScore");
DALPortal.UpdateEventGameTeam(hdnGameID.Value.ToInt(), phdnTeamID.Value.ToInt(), ptxtRank.Text.ToInt(), ptxtScore.Text.ToInt());
}
this.LoadCompetingTeams();
}
protected void btnSaveEventTeamScore_Click(object sender, ImageClickEventArgs e)
{
foreach (DataGridItem ditm in dgTeamEventScore.Items)
{
HiddenField phdnTeamID = (HiddenField)ditm.FindControl("hdnTeamID");
TextBox ptxtRank = (TextBox)ditm.FindControl("txtRank");
TextBox ptxtScore = (TextBox)ditm.FindControl("txtScore");
DALPortal.UpdateScoreRank(hdnEventID.Value.ToInt(), phdnTeamID.Value.ToInt(), ptxtRank.Text.ToInt(), ptxtScore.Text.ToInt());
}
this.LoadEventTeamScore();
Response.Redirect("EventMenu.aspx");
}
protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
int intRecordsAffected = 0;
int eventID = Request.QueryString["eventid"].ToInt();
string eventName = txtEventName.Text;
int eventDivisionID = ddlDivision.SelectedValue.ToInt();
int eventCategoryID = ddlCategory.SelectedValue.ToInt();
int maxPoint = txtMaxPoints.Text.ToInt();
int winnerTeamID = ddlWinner.SelectedValue.ToInt();
int sortOrder = txtOrder.Text.ToInt();
string modifiedBy = Request.Cookies["Speedo"]["UserName"].ToString();
intRecordsAffected = DALPortal.UpdateEvent(eventID, eventName, eventDivisionID, eventCategoryID, maxPoint, winnerTeamID, sortOrder, true, modifiedBy);
}
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 Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ddlEvent.DataSource = DALPortal.DSLEventsAll();
ddlEvent.DataValueField = "EventID";
ddlEvent.DataTextField = "EventName";
ddlEvent.DataBind();
ddlTeam.DataSource = DALPortal.DSLTeamAll();
ddlTeam.DataValueField = "TeamID";
ddlTeam.DataTextField = "TeamName";
ddlTeam.DataBind();
btnBack.Attributes.Add("onclick", "history.back(); return false");
}
this.BindEventScheduleList();
}
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 BindTeamComposition()
{
dgTeamComposition.DataSource = clsTeamMembers.DSGTeamMember(hdnTeamID.Value.ToInt());
dgTeamComposition.DataBind();
foreach (DataGridItem ditm in dgTeamComposition.Items)
{
HiddenField phdnUsername = (HiddenField)ditm.FindControl("hdnUsername");
HiddenField phdnDepartment = (HiddenField)ditm.FindControl("hdnDepartment");
HiddenField phdnDivision = (HiddenField)ditm.FindControl("hdnDivision");
Label plblDepartment = (Label)ditm.FindControl("lblDepartment");
string strPreviousEvents = DALPortal.GetJoinedEvents(phdnUsername.Value, 2);
string strCurrentEvents = DALPortal.GetJoinedEvents(phdnUsername.Value, SynergyCurrentID);
plblDepartment.Text = phdnDepartment.Value + " (" + phdnDivision.Value + ")";
Image pimgPicture = (Image)ditm.FindControl("imgPicture");
pimgPicture.ImageUrl = "http://hq.sti.edu/pictures/realpicture/" + phdnUsername.Value + ".jpg";
}
}
private string LoadLatestScheduleTeams1(int gameID, int eventID)
{
string strReturn = "";
List <EventGameTeam> eventGameTeamList = new List <EventGameTeam>();
using (PortalDataContext pdc = new PortalDataContext())
{
eventGameTeamList = (from egt in pdc.EventGameTeams
where egt.GameID == gameID
orderby egt.Rank.Value
select egt).ToList();
}
foreach (EventGameTeam egt in eventGameTeamList)
{
strReturn += (strReturn == "" ? "" : "<br/>Vs.<br/>") + DALPortal.GetTeamName(egt.TeamID);
}
return(strReturn);
}
public static string GetStanding(int teamID, int eventID)
{
string standing = "";
int scoringType = 0;
using (PortalDataContext pdc = new PortalDataContext())
{
scoringType = (from ev in pdc.Events
where ev.EventID == eventID
select ev.ScoringTypeID).SingleOrDefault();
}
if (scoringType == 1)
{
standing = "(" + DALPortal.CountTotalWon(teamID, eventID).ToString() + "-" + DALPortal.CountTotalDraw(teamID, eventID).ToString() + "-" + DALPortal.CountTotalLost(teamID, eventID).ToString() + ")";
}
else if (scoringType == 2)
{
standing = "(" + DALPortal.GetScore(teamID, eventID).ToString() + ")";
}
return(standing);
}
protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
if (IsCorrectEntries())
{
int intRecordsAffected = 0;
int gameID = hdnGameID.Value.ToInt();
string gamePhase = ddlGamePhase.SelectedValue;
DateTime startDate = clsValidator.CheckDate(txtStartYear.Text.ToInt(), ddlStartMonth.SelectedValue.ToInt(), ddlStartDay.SelectedValue.ToInt(), ddlStartHour.SelectedValue.ToInt(), ddlStartMinute.SelectedValue.ToInt(), ddlStartTimePeriod.SelectedValue);
DateTime endDate = clsValidator.CheckDate(txtEndYear.Text.ToInt(), ddlEndMonth.SelectedValue.ToInt(), ddlEndDay.SelectedValue.ToInt(), ddlEndHour.SelectedValue.ToInt(), ddlEndMinute.SelectedValue.ToInt(), ddlEndTimePeriod.SelectedValue);
string location = txtLocation.Text;
int winnerTeamID = ddlWinner.SelectedValue.ToInt();
bool isFinished = chkFinished.Checked;
string modifiedBy = Request.Cookies["Speedo"]["UserName"];
intRecordsAffected = DALPortal.UpdateEventGames(gameID, gamePhase, startDate, endDate, location, winnerTeamID, isFinished, modifiedBy);
if (intRecordsAffected > 0)
{
Response.Redirect("EventDetails.aspx?eventid=" + Request.QueryString["eventid"]);
}
}
}
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);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
hdnEventID.Value = Request.QueryString["eventid"];
using (PortalDataContext pdc = new PortalDataContext())
{
txtEvent.Text = (from ev in pdc.Events
where ev.EventID == hdnEventID.Value.ToInt()
select ev.Name).SingleOrDefault();
}
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();
ddlGamePhase.DataSource = DALPortal.DSLGamePhase();
ddlGamePhase.DataValueField = "pvalue";
ddlGamePhase.DataTextField = "ptext";
ddlGamePhase.DataBind();
ddlStartMonth.SelectedValue = DateTime.Now.Month.ToString();
ddlStartDay.SelectedValue = DateTime.Now.Day.ToString();
txtStartYear.Text = DateTime.Now.Year.ToString();
ddlEndMonth.SelectedValue = DateTime.Now.Month.ToString();
ddlEndDay.SelectedValue = DateTime.Now.Day.ToString();
txtEndYear.Text = DateTime.Now.Year.ToString();
ddlWinner.DataSource = DALPortal.DSLTeamNA();
ddlWinner.DataValueField = "TeamID";
ddlWinner.DataTextField = "TeamName";
ddlWinner.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
clsSpeedo.Authenticate();
if (!Page.IsPostBack)
{
bool blnHasAccess = clsSystemModule.HasAccess(clsSystemModule.ModuleSynergy, Request.Cookies["Speedo"]["Username"]);
btnSave.Visible = blnHasAccess;
btnNewSchedule.Visible = blnHasAccess;
btnSaveEventTeamScore.Visible = blnHasAccess;
hdnEventID.Value = Request.QueryString["eventid"];
using (PortalDataContext pdc = new PortalDataContext())
{
var qDivision = (from ed in pdc.EventDivisions
orderby ed.Name
select new { DivisionID = ed.EventDivisionID, Name = ed.Name }).ToList();
ddlDivision.DataSource = qDivision;
ddlDivision.DataValueField = "DivisionID";
ddlDivision.DataTextField = "Name";
ddlDivision.DataBind();
var qCategory = (from ec in pdc.EventCategories
orderby ec.Name
select new { CategoryID = ec.EventCategoryID, Name = ec.Name }).ToList();
ddlCategory.DataSource = qCategory;
ddlCategory.DataValueField = "CategoryID";
ddlCategory.DataTextField = "Name";
ddlCategory.DataBind();
ddlWinner.DataSource = DALPortal.DSLTeamNA(hdnEventID.Value.ToInt());
ddlWinner.DataValueField = "TeamID";
ddlWinner.DataTextField = "TeamName";
ddlWinner.DataBind();
//Event eventSynergy = new Event();
//eventSynergy = (from ev in pdc.Events
// where ev.EventID == hdnEventID.Value.ToInt()
// select ev).SingleOrDefault();
//lnkEventDetails.Text = eventSynergy.Name;
//lnkEventDetails.NavigateUrl = "EventDetails.aspx?eventid=" + hdnEventID.Value.ToInt();
//txtEventName.Text = eventSynergy.Name;
//txtMaxPoints.Text = eventSynergy.MaxPoint.ToString();
//txtOrder.Text = eventSynergy.SortOrder.ToString();
//ddlDivision.SelectedValue = eventSynergy.EventDivisionID.ToString();
//ddlCategory.SelectedValue = eventSynergy.EventCategoryID.ToString();
//ddlWinner.SelectedValue = eventSynergy.WinnerTeamID.ToString();
//txtCreateBy.Text = eventSynergy.CreatedBy;
//txtCreateOn.Text = eventSynergy.DateCreated.Value.ToString("MMM dd, yyyy hh:mm tt");
//txtModifyBy.Text = eventSynergy.ModifiedBy.ToSafeString();
//txtModifyOn.Text = (eventSynergy.DateModified == null ? "" : eventSynergy.DateModified.Value.ToString("MMM dd, yyyy hh:mm tt"));
}
this.LoadEventDetails();
if (!blnHasAccess)
{
txtEventName.ReadOnly = true;
txtEventName.BackColor = System.Drawing.Color.AliceBlue;
ddlCategory.Enabled = false;
ddlDivision.Enabled = false;
txtMaxPoints.ReadOnly = true;
txtMaxPoints.BackColor = System.Drawing.Color.AliceBlue;
ddlWinner.Enabled = false;
txtOrder.ReadOnly = true;
txtOrder.BackColor = System.Drawing.Color.AliceBlue;
}
//this.CheckInsertEventTeamScore();
this.LoadEventScheduleList();
this.LoadEventTeamScore();
chkActive.Checked = IsActive(Request.QueryString["eventid"].ToInt());
}
}
protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
int intRecordsAffected = 0;
int eventID = Request.QueryString["eventid"].ToInt();
string eventName = txtEventName.Text;
int eventDivisionID = ddlDivision.SelectedValue.ToInt();
int eventCategoryID = ddlCategory.SelectedValue.ToInt();
int maxPoint = txtMaxPoints.Text.ToInt();
int winnerTeamID = ddlWinner.SelectedValue.ToInt();
int sortOrder = txtOrder.Text.ToInt();
string modifiedBy = Request.Cookies["Speedo"]["UserName"].ToString();
intRecordsAffected = DALPortal.UpdateEvent(eventID, eventName, eventDivisionID, eventCategoryID, maxPoint, winnerTeamID, sortOrder, true, modifiedBy);
using (SqlConnection cn = new SqlConnection(clsSpeedo.SpeedoConnectionString))
{
SqlCommand cmd = cn.CreateCommand();
cn.Open();
if (chkActive.Checked == true)
{
//added by charlie bachiller May 18, 2012
if (chkActive.Checked == true)
{
cmd.CommandText = "UPDATE Portal.EventsActive SET IsActive='0'";
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
cmd.CommandText = "UPDATE Portal.EventsActive SET IsActive='1' WHERE EventID=@EventID";
cmd.Parameters.Add(new SqlParameter("@EventID", eventID));
cmd.Parameters.Add(new SqlParameter("@IsActive", chkActive.Checked == true ? "1" : "0"));
cmd.ExecuteNonQuery();
}
else
{
cmd.CommandText = "SELECT EventID FROM Portal.EventsActive WHERE EventID=@EventID AND IsActive='1'";
cmd.Parameters.Add(new SqlParameter("@EventID", eventID));
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
cmd.CommandText = "UPDATE Portal.EventsActive SET IsActive='0'";
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
cmd.Parameters.Clear();
}
}
else
{
cmd.CommandText = "SELECT EventID FROM Portal.EventsActive WHERE EventID=@EventID AND IsActive='1'";
cmd.Parameters.Add(new SqlParameter("@EventID", eventID));
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
dr.Close();
cmd.CommandText = "UPDATE Portal.EventsActive SET IsActive='0'";
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
cmd.Parameters.Clear();
}
}
Response.Redirect("EventMenu.aspx");
}
private void LoadEventScheduleList()
{
bool blnHasAccess = clsSystemModule.HasAccess(clsSystemModule.ModuleSynergy, Request.Cookies["Speedo"]["Username"]);
List <EventGame> eventGameList = new List <EventGame>();
using (PortalDataContext pdc = new PortalDataContext())
{
eventGameList = (from eg in pdc.EventGames
where eg.IsActive == true && eg.EventID == hdnEventID.Value.ToInt()
orderby eg.StartDate
select eg).ToList();
dgSchedule.DataSource = eventGameList;
dgSchedule.DataBind();
dgSchedule.Columns[1].Visible = blnHasAccess;
if (dgSchedule.Items.Count > 0)
{
divSchedule.Visible = true;
lblNoSchedule.Visible = false;
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 phdnFinished = (HiddenField)ditm.FindControl("hdnFinished");
Image pimgFinished = (Image)ditm.FindControl("imgFinished");
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 + "'></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 = DALPortal.GetTeamLogo(phdnWinner.Value.ToInt());
}
pimgFinished.ImageUrl = "~/Support/" + (phdnFinished.Value == "True" ? "check16" : "history16") + ".png";
plblGamePhase.Text = DALPortal.GetGamePhaseName(phdnGamePhase.Value);
}
}
else
{
divSchedule.Visible = false;
lblNoSchedule.Visible = true;
}
}
}
///////////////////////////////
///////// 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();
}
}
private void InsertRecord()
{
string username = Request.Cookies["Speedo"]["UserName"];
ThreadDataContext sdc = new ThreadDataContext();
try
{
Thread thread = new Thread
{
ThreadCategoryID = ddlCategory.SelectedValue.ToInt(),
ThreadTypeID = ddlType.SelectedValue.ToInt(),
Title = txtTitle.Text,
Description = txtDescription.Text,
Contents = ckeContents.Text,
IsAllowedReply = chkIsAllowReply.Checked,
IsPosted = chkPostAnnouncement.Checked,
IsPrivate = chkIsPrivate.Checked,
IsActive = true,
IsSticky = false,
PostedBy = username,
PostedDate = DateTime.Now,
LastPostBy = username,
LastPostDate = DateTime.Now,
TotalReply = 0
};
if (fuAttachment.HasFile)
{
string fileName = System.Guid.NewGuid().ToString() + "." + Path.GetExtension(fuAttachment.FileName);
fuAttachment.SaveAs(Server.MapPath(@"~\App_Attachments\" + fileName));
thread.AttachedFileName = fileName;
thread.AttachedFileDescription = (txtAttachment.Text.Length == 0 ? "Attached File" : txtAttachment.Text);
}
sdc.Threads.InsertOnSubmit(thread);
sdc.SubmitChanges();
if (chkIsPrivate.Checked)
{
foreach (ListItem itm in cblThreadMembers.Items)
{
ThreadPrivateUser tpu = new ThreadPrivateUser()
{
ThreadID = thread.ThreadID,
Username = itm.Value
};
sdc.ThreadPrivateUsers.InsertOnSubmit(tpu);
}
}
sdc.SubmitChanges();
}
catch (Exception ex)
{
DALPortal.LogError(username, MethodBase.GetCurrentMethod().ReflectedType.ToString(), MethodBase.GetCurrentMethod().Name, ex.Message);
}
finally
{
sdc.Dispose();
}
Response.Redirect("ThreadList.aspx?categoryid=" + Request.QueryString["categoryid"] + "&page=1");
}
private void BindEventScheduleList()
{
using (PortalDataContext pdc = new PortalDataContext())
{
var predicate = PredicateBuilder.True <EventGame>();
if (ddlEvent.SelectedValue != "ALL")
{
predicate = predicate.And(p => p.EventID == ddlEvent.SelectedValue.ToInt());
}
if (ddlTeam.SelectedValue != "ALL")
{
predicate = predicate.And(p => (from egt in pdc.EventGameTeams where egt.TeamID == ddlTeam.SelectedValue.ToInt() select egt.GameID).Contains(p.GameID));
}
var q = (from eg in pdc.EventGames.Where(predicate)
where eg.IsActive == true &&
(from ev in pdc.Events
where ev.ActivityID == SynergyCurrentID
select ev.EventID).Contains(eg.EventID)
let xEventName = (from ev in pdc.Events
where ev.EventID == eg.EventID
select ev.Name).SingleOrDefault()
orderby eg.StartDate
select new
{
EventID = eg.EventID,
EventName = xEventName,
GameID = eg.GameID,
GamePhase = eg.GamePhase,
StartDate = eg.StartDate,
Location = eg.Location,
WinnerTeamID = eg.WinnerTeamID,
IsFinished = eg.IsFinished
}).ToList();
dgSchedule.DataSource = q;
dgSchedule.DataBind();
foreach (DataGridItem ditm in dgSchedule.Items)
{
HiddenField phdnEventID = (HiddenField)ditm.FindControl("hdnEventID");
HiddenField phdnGameID = (HiddenField)ditm.FindControl("hdnGameID");
HiddenField phdnDateStart = (HiddenField)ditm.FindControl("hdnDateStart");
Label plblDateStart = (Label)ditm.FindControl("lblDateStart");
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 = DALPortal.GetTeamLogo(phdnWinner.Value.ToInt());
}
plblDateStart.Text = clsValidator.CheckDate(phdnDateStart.Value).ToString("MMM dd, yyyy hh:mm tt");
plblGamePhase.Text = DALPortal.GetGamePhaseName(phdnGamePhase.Value);
}
}
}
private string LoadLatestScheduleTeams(int gameID, int eventID)
{
string strReturn = "";
List <EventGameTeam> eventGameTeamList = new List <EventGameTeam>();
using (PortalDataContext pdc = new PortalDataContext())
{
eventGameTeamList = (from egt in pdc.EventGameTeams
where egt.GameID == gameID
orderby egt.Rank.Value
select egt).ToList();
}
foreach (EventGameTeam egt in eventGameTeamList)
{
strReturn += (strReturn == "" ? "" : "<tr><td style='color:Red;border-color: #FFFFFF;'> <b>Versus </b></td></tr>") +
"<tr><td style='border-color: #FFFFFF;font-size:15px; line-height:15px'><b><a href='../Synergy/TeamDetails.aspx?teamid=" + egt.TeamID + "'>" + DALPortal.GetTeamName(egt.TeamID) + "</a></b></td></tr>";
}
return("<tr><td style='border-color: #FFFFFF;'><table align='center' style='border-color: #FFFFFF;'>" + strReturn + "</table></td></tr>");
}
private void LoadUpcomingSchedules()
{
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 >= 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 + "'></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);
}
}
}
