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