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