protected void btnChallenge_Click(object sender, EventArgs e) { var tournamentGUID = this.GetRedirectParameter("tournamentGUID", false); if (tournamentGUID != null) { using (var db = Global.GetConnection()) { //check so this participant isn't added already var participantcheck = from p in db.Ext_PrivateTournamentParticipant where p.PrivateTournamentGUID == new Guid(tournamentGUID.ToString()) && p.TeamGUID == new Guid(drpTeamsToChallenge.SelectedValue) select p; if (participantcheck.ToList().Count > 0) { lblChallengeMessage.Text = "Det laget är redan utmanat"; return; } var participant = new Ext_PrivateTournamentParticipant(); participant.TeamGUID = new Guid(drpTeamsToChallenge.SelectedValue); participant.PrivateTournamentGUID = new Guid(tournamentGUID.ToString()); participant.IsAccepted = false; db.Ext_PrivateTournamentParticipant.InsertOnSubmit(participant); db.SubmitChanges(); LoadParticipants(new Guid(tournamentGUID.ToString()), db); } } }
protected void Save_Click(object sender, EventArgs e) { //validate if (FirstName.Text.Trim().Length == 0 || LastName.Text.Trim().Length == 0) { lblMessage.Text = "Du måste ange både förnamn och efternamn"; } else { using (var db = Global.GetConnection()) { var userQ = from u in db.Sys_User where u.UserName == SessionProps.UserName select u; var user = userQ.ToList()[0]; user.FirstName = FirstName.Text; user.LastName = LastName.Text; db.SubmitChanges(); lblMessage.Text = "Nu är ändringarna sparade"; } } }
private void ShowPointsToDistribute(bool final) { if (MatchId != Guid.Empty) { using (var db = Global.GetConnection()) { var match = db.Inti_Match.Single(m => m.GUID == MatchId); var mpes = from mpe in db.Inti_MatchPointEvent where mpe.Inti_Match.GUID == MatchId orderby mpe.Inti_AthleteClub.Inti_Club.Name orderby mpe.Inti_AthleteClub.Inti_Position.Name orderby mpe.Inti_PointEvent.Name select mpe; lblUpdateProgress.Text = "Poäng:<br>"; if (final) { lblUpdateProgress.Text = "Följande poäng kommer delas ut för matchen:<br>"; } lblUpdateProgress.Text += "<table><tr><td>spelare</td><td>Insats</td><td>poäng</td></tr>"; foreach (var mpe in mpes) { lblUpdateProgress.Text += String.Format("<tr><td>{0} {1}</td><td>{2}</td><td>{3}</td></tr> ", mpe.Inti_AthleteClub.Inti_Athlete.FirstName, mpe.Inti_AthleteClub.Inti_Athlete.LastName, mpe.Inti_PointEvent.Name, mpe.Points.ToString()).Trim(); } lblUpdateProgress.Text += "</table>"; } } }
protected void btnDelete_Click(object sender, EventArgs e) { var messageGUID = this.GetRedirectParameter("messageGUID", false); if (messageGUID != null) { using (var db = Global.GetConnection()) { var message = db.Ext_Message.Single(m => m.GUID == new Guid(messageGUID.ToString())); //safety foreach (var rec in message.Ext_MessageRecipient) { if (rec.RecipientUserGUID == SessionProps.UserGuid) { db.Ext_MessageRecipient.DeleteOnSubmit(rec); db.SubmitChanges(); break; } } } WebControlManager.RedirectWithQueryString("UserMessages.aspx", new[] { "GUID" }, new[] { SessionProps.UserGuid.ToString() }); } }
private List <StandingDto> GetPrivateTournamentStanding(Ext_PrivateTournament pvtTournament) { using (var db = Global.GetConnection()) { var standing = from ptp in db.Ext_PrivateTournamentParticipant where ptp.PrivateTournamentGUID == pvtTournament.GUID && (ptp.IsAccepted ?? false) && (ptp.Inti_Team.IsActive ?? false) && (ptp.Inti_Team.IsPaid ?? false) select new StandingDto { GUID = ptp.Inti_Team.GUID, TeamName = ptp.Inti_Team.Name, Manager = ptp.Inti_Team.Sys_User.FirstName + " " + ptp.Inti_Team.Sys_User.LastName, Points = (ptp.Inti_Team.Inti_TeamPointEvents.Where(tpe => ((pvtTournament.IsLimitedInTime ?? false) && tpe.Inti_MatchPointEvent.Inti_Match.MatchDate >= pvtTournament.StartDate && tpe.Inti_MatchPointEvent.Inti_Match.MatchDate <= (pvtTournament.EndDate ?? tpe.Inti_MatchPointEvent.Inti_Match.MatchDate)) || (!(pvtTournament.IsLimitedInTime ?? false) && tpe.Inti_MatchPointEvent.Inti_Match.TourDay >= (pvtTournament.StartDay ?? tpe.Inti_MatchPointEvent.Inti_Match.TourDay) && tpe.Inti_MatchPointEvent.Inti_Match.TourDay <= (pvtTournament.EndDay ?? tpe.Inti_MatchPointEvent.Inti_Match.TourDay))) .Count() > 0 ? ((ptp.Inti_Team.Inti_TeamPointEvents.Where(tpe => ((pvtTournament.IsLimitedInTime ?? false) && tpe.Inti_MatchPointEvent.Inti_Match.MatchDate >= pvtTournament.StartDate && tpe.Inti_MatchPointEvent.Inti_Match.MatchDate <= (pvtTournament.EndDate ?? tpe.Inti_MatchPointEvent.Inti_Match.MatchDate)) || (!(pvtTournament.IsLimitedInTime ?? false) && tpe.Inti_MatchPointEvent.Inti_Match.TourDay >= (pvtTournament.StartDay ?? tpe.Inti_MatchPointEvent.Inti_Match.TourDay) && tpe.Inti_MatchPointEvent.Inti_Match.TourDay <= (pvtTournament.EndDay ?? tpe.Inti_MatchPointEvent.Inti_Match.TourDay))) .Sum(tpe => tpe.Inti_MatchPointEvent.Points))) : 0) }; return(standing.OrderByDescending(x => x.Points).ToList()); } }
protected void grdRules_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "New") { //get the highest sort order and add that to the list. Add some random rules and save and show rules using (var db = Global.GetConnection()) { var highestSortOrder = db.Inti_TournamentRule.Where(r => r.TournamentGUID == SessionProps.SelectedTournament.GUID).Max( r => r.SortOrder); var newRule = new Inti_TournamentRule(); newRule.TournamentGUID = SessionProps.SelectedTournament.GUID; newRule.SortOrder = highestSortOrder + 1; newRule.Header = "header"; newRule.Body = "body"; db.Inti_TournamentRule.InsertOnSubmit(newRule); db.SubmitChanges(); } LoadRules(); } }
protected void Page_Load(object sender, EventArgs e) { var header = "Hittade inte laget"; var clubId = this.GetRedirectParameter("id", false); if (!String.IsNullOrEmpty(clubId)) { try { var clubGuid = new Guid(clubId); using (var db = Global.GetConnection()) { //get club name var club = db.Inti_Club.Single(c => c.GUID == clubGuid); header = club.Name; //load players LoadPlayers(clubGuid, db); //load matches LoadMatches(clubGuid, db); //load stakeholders TeamBreakDown.LoadClubEvaluation(clubGuid, db); } } catch (Exception) { //bad input or whatever, just let it slide } } lblHeader.Text = header; }
protected void btnSave_Click(object sender, EventArgs e) { using (var db = Global.GetConnection()) { for (var i = 0; i < grdMatches.Rows.Count; i++) { var row = grdMatches.Rows[i]; grdMatches.SelectedIndex = i; //is it updated? var newTourDay = int.Parse((row.Cells[2].FindControl("drpDay") as DropDownList).SelectedValue); var orgTourDay = int.Parse((row.Cells[4].FindControl("txtOrgTourDay") as TextBox).Text); var newMatchDate = DateTime.Parse((row.Cells[3].FindControl("txtMatchDate") as TextBox).Text); var orgMatchDate = DateTime.Parse((row.Cells[5].FindControl("txtOrgMatchDate") as TextBox).Text); if (newTourDay != orgTourDay || newMatchDate != orgMatchDate) { var guid = new Guid(grdMatches.SelectedValue.ToString()); var match = db.Inti_Match.Single(m => m.GUID == guid); match.HomeClub = new Guid((row.Cells[0].FindControl("drpHomeTeam") as DropDownList).SelectedValue); match.AwayClub = new Guid((row.Cells[1].FindControl("drpAwayTeam") as DropDownList).SelectedValue); match.TourDay = newTourDay; match.MatchDate = newMatchDate; } } db.SubmitChanges(); } LoadMatches(); }
protected void btnReDistributePointsForFullDay_Click(object sender, EventArgs e) { var matchManagement = new MatchManagement(Global.ConnectionString, SessionProps); using (var db = Global.GetConnection()) { var tourDay = int.Parse(drpTourDay.SelectedValue); var matches = from m in db.Inti_Match where m.TournamentGUID == SessionProps.SelectedTournament.GUID && m.TourDay == tourDay && m.IsUpdated == true select m; lblUpdateProgress.Text = ""; foreach (var match in matches) { //clear the points matchManagement.ClearTeamPoints(match.GUID); matchManagement.DistributePoints(match.GUID); lblUpdateProgress.Text += String.Format("{0} - {1}<br>", match.HomeClubInti_Club.Name, match.Inti_Club.Name); } SwitchStep(0); } }
protected void btnSend_Click(object sender, EventArgs e) { if (drpRecipient.SelectedValue.Length > 0 && Header.Text.Length > 0 && Body.Text.Length > 0 && SessionProps.UserGuid != Guid.Empty) { using (var db = Global.GetConnection()) { var message = new Ext_Message(); message.FromUserGUID = SessionProps.UserGuid; message.Header = Header.Text; message.Body = Body.Text; message.SentDate = DateTime.Now; var recipient = new Ext_MessageRecipient(); recipient.MessageGUID = message.GUID; recipient.RecipientUserGUID = new Guid(drpRecipient.SelectedValue); db.Ext_Message.InsertOnSubmit(message); db.Ext_MessageRecipient.InsertOnSubmit(recipient); db.SubmitChanges(); pnlEditControls.Visible = false; pnlSuccessControls.Visible = true; lblSuccessMessage.Text = "Meddelandet är skickat"; } } else { lblMessage.Text = "Kunde inte skicka meddelandet, ämne, text och mottagare måste fyllas i."; } }
protected void btnShowPlayers_Click(object sender, EventArgs e) { using (var db = Global.GetConnection()) { var clubGUID = drpClubs.SelectedValue == "" ? Guid.Empty : new Guid(drpClubs.SelectedValue); var posGUID = drpPosition.SelectedValue == "" ? Guid.Empty : new Guid(drpPosition.SelectedValue); var players = from ac in db.Inti_AthleteClub where (clubGUID == Guid.Empty || ac.ClubGUID == clubGUID) && (posGUID == Guid.Empty || ac.PositionGUID == posGUID) && ac.Inti_Club.TournamentGUID == SessionProps.SelectedTournament.GUID select new { ac.GUID, Name = ac.Inti_Athlete.FirstName + " " + ac.Inti_Athlete.LastName, Club = ac.Inti_Club.Name, Position = ac.Inti_Position.Name, Price = ac.Price, Points = (ac.Inti_MatchPointEvent.Count > 0 ? ac.Inti_MatchPointEvent.Sum(mpe => mpe.Points) : 0), CustomClass = !ac.IsActive ?? false ? "list-group-item-danger" : "" }; rptPlayers.DataSource = players.OrderByDescending(p => p.Points).ToList(); rptPlayers.DataBind(); } }
private void AddButtonsToAddTeams() { if (Id == SessionProps.UserGuid) { //loopa tournaments - en knapp för varje tournament som är öppen using (var db = Global.GetConnection()) { var tours = from t in db.Inti_Tournament select t; foreach (var tour in tours.ToList()) { //är den öppen för registrering if (tour.PublicateDate <= DateTime.Now && tour.StartRegistration <= DateTime.Now && tour.EndRegistration >= DateTime.Now) { var btn = new Button(); btn.Text = "Lägg till lag i " + tour.Name; btn.ID = "addTeam" + tour.GUID.ToString(); btn.Click += AddTeam_Click; btn.CssClass = "btn btn-primary"; plhAddTeams.Controls.Add(btn); } } } } }
protected void btnAddTransferWindow_Click(object sender, EventArgs e) { //kontrollera att det inte finns fler transferfönster änvad som angetts i turneringen using (var db = Global.GetConnection()) { var transferWindows = db.Inti_TransferPeriod.Where(tf => tf.TournamentGUID == TourId); var tour = db.Inti_Tournament.Single(t => t.GUID == TourId); var transferWindow = new Inti_TransferPeriod(); transferWindow.TournamentGUID = TourId; transferWindow.StartDate = tour.StartRegistration; transferWindow.EndDate = tour.StartRegistration; transferWindow.Name = "Nytt transferfönster"; transferWindow.Description = ""; db.Inti_TransferPeriod.InsertOnSubmit(transferWindow); db.SubmitChanges(); LoadTransferWindows(); LoadTransferWindow(transferWindow.GUID); } }
protected void btnCreateForumItem_Click(object sender, EventArgs e) { var categoryGUID = this.GetRedirectParameter("categoryGUID", false); if (categoryGUID != null && !String.IsNullOrEmpty(SessionProps.UserName) && SessionProps.HasPermission("USER") && Header.Text.Trim().Length > 0 && Body.Text.Trim().Length > 0) { using (var db = Global.GetConnection()) { var forum = new Ext_Forum(); forum.Header = Header.Text; forum.Body = Body.Text; forum.PostedDate = DateTime.Now; forum.ForumCategoryGUID = new Guid(categoryGUID.ToString()); forum.UserGUID = SessionProps.UserGuid; db.Ext_Forum.InsertOnSubmit(forum); db.SubmitChanges(); WebControlManager.RedirectWithQueryString("ForumViewThread.aspx", new string[] { "threadGUID" }, new string[] { forum.GUID.ToString() }); } } else { lblMessage.Text = "Det gick inte att spara inlägget. Är du inloggad? Har du fyllt i både rubrik och brödtext?"; } }
private void LoadDays() { int mostRecentDay = 1; using (var db = Global.GetConnection()) { var matches = from m in db.Inti_Match where (m.IsUpdated ?? false) && m.TournamentGUID == SessionProps.SelectedTournament.GUID select m; var matchList = matches.OrderByDescending(m => m.TourDay).ToList(); if (matchList.Count > 0) { mostRecentDay = matchList[0].TourDay; } } for (var i = 1; i <= SessionProps.SelectedTournament.NmbrOfDays; i++) { drpTourDay.Items.Add(new ListItem(i.ToString(), i.ToString())); } drpTourDay.ClearSelection(); drpTourDay.SelectedValue = mostRecentDay.ToString(); }
private void LoadPlayers() { var position = this.GetRedirectParameter("position", false); using (var db = Global.GetConnection()) { var athletes = from a in db.Inti_AthleteClub where (position == null ? true : a.Inti_Position.ShortName == position.ToString()) && a.Inti_Club.TournamentGUID == TourId && (a.IsActive ?? false) select new { GUID = a.GUID, PlayerName = String.Format("{0} {1}", a.Inti_Athlete.FirstName, a.Inti_Athlete.LastName).Trim(), ClubShortName = a.Inti_Club.ShortName, Position = a.Inti_Position.ShortName, Price = a.Price }; grdPlayers.DataKeyNames = new string[] { "GUID" }; grdPlayers.DataSource = athletes.OrderBy(club => club.ClubShortName).ToList(); grdPlayers.DataBind(); } }
private void LoadTeams() { using (var db = Global.GetConnection()) { var teams = from t in db.Inti_Team where t.TournamentGUID == SessionProps.DefaultTournament.GUID select new { GUID = t.GUID, Name = t.Name, TeamManager = t.Sys_User.FirstName + " " + t.Sys_User.LastName, TeamManagerMail = t.Sys_User.UserName, t.IsActive, t.IsPaid, t.BonusPoints, t.Picture }; grdUserTeams.DataKeyNames = new string[] { "GUID" }; grdUserTeams.DataSource = teams.OrderBy(t => t.Name); grdUserTeams.DataBind(); var countList = teams.ToList(); lblTournament.Text += ". " + countList.Count() + " lag varav " + countList.Count(t => t.IsPaid ?? false) + " betalda."; } }
private void LoadRecipients() { using (var db = Global.GetConnection()) { var messageGUID = this.GetRedirectParameter("messageGUID", false); var users = from u in db.Sys_User select new { u.GUID, Name = u.FirstName + " " + u.LastName }; drpRecipient.DataValueField = "GUID"; drpRecipient.DataTextField = "Name"; drpRecipient.DataSource = users.OrderBy(u => u.Name).ToList(); drpRecipient.DataBind(); if (messageGUID != null) { var message = db.Ext_Message.Single(m => m.GUID == new Guid(messageGUID.ToString())); drpRecipient.ClearSelection(); drpRecipient.Items.FindByValue(message.FromUserGUID.ToString().Replace("{", "").Replace("}", "")).Selected = true; drpRecipient.Enabled = false; } } }
private void LoadMessage() { var messageGUID = this.GetRedirectParameter("messageGUID", false); if (messageGUID != null) { using (var db = Global.GetConnection()) { var message = db.Ext_Message.Single(m => m.GUID == new Guid(messageGUID.ToString())); //safety foreach (var rec in message.Ext_MessageRecipient) { if (rec.RecipientUserGUID == SessionProps.UserGuid) { if (rec.ReadOn == null) { rec.ReadOn = DateTime.Now; db.SubmitChanges(); } lblHeader.Text = message.Header; lblInformation.Text = String.Format("Från: {0} {1}. Skickat: {2}", message.Sys_User.FirstName, message.Sys_User.LastName, (message.SentDate ?? DateTime.Now).ToShortDateString()); lblBody.Text = Server.HtmlEncode(message.Body).Replace("\n", "<br>"); break; } } } } }
private void CopyFromTournament(Guid tournamentId) { using (var db = Global.GetConnection()) { var oldRules = from r in db.Inti_TournamentRule where r.TournamentGUID == SessionProps.SelectedTournament.GUID select r; if (oldRules.ToList().Count == 0) { var rulesToCopy = from r in db.Inti_TournamentRule where r.TournamentGUID == tournamentId select r; foreach (var rule in rulesToCopy) { var newRule = new Inti_TournamentRule(); newRule.Header = rule.Header; newRule.TournamentGUID = SessionProps.SelectedTournament.GUID; newRule.Body = rule.Body; newRule.SortOrder = rule.SortOrder; db.Inti_TournamentRule.InsertOnSubmit(newRule); } db.SubmitChanges(); //refresh the rules LoadRules(); } } }
private void LoadTournament() { if (TourId != Guid.Empty) { //get this tournament using (var db = Global.GetConnection()) { var tour = db.Inti_Tournament.Single(t => t.GUID == TourId); TournamentName.Text = tour.Name; TournamentDescription.Text = tour.Description; PublicateDate.Text = tour.PublicateDate.ToString(); StartRegistration.Text = tour.StartRegistration.ToString(); EndRegistration.Text = tour.EndRegistration.ToString(); NmbrOfClubs.Text = tour.NmbrOfClubs.ToString(); NmbrOfDays.Text = tour.NmbrOfDays.ToString(); NmbrOfTransfers.Text = tour.NmbrOfTransfers.ToString(); Budget.Text = tour.Budget.ToString(); IncludeManager.Checked = tour.IncludeManager; //get clubs if any var clubs = from c in db.Inti_Club where c.TournamentGUID == TourId select c; grdClubs.DataKeyNames = new string[] { "GUID" }; grdClubs.DataSource = clubs.OrderBy(c => c.Name).ToList(); grdClubs.DataBind(); LoadTransferWindows(); } } }
private void LoadPrivateTournaments() { if (SessionProps.UserGuid == Id) { using (var db = Global.GetConnection()) { var tournaments = from ptp in db.Ext_PrivateTournamentParticipant where ptp.Inti_Team.UserGUID == Id && ptp.Ext_PrivateTournament.Inti_Tournament.GUID == SessionProps.SelectedTournament.GUID && (((ptp.IsAccepted ?? false) && (ptp.Ext_PrivateTournament.IsVisibleForAll ?? false)) || SessionProps.UserGuid == Id) select new { ptp.PrivateTournamentGUID, ptp.TeamGUID, ptp.Ext_PrivateTournament.Name, ptp.Ext_PrivateTournament.Description, TeamName = ptp.Inti_Team.Name, ptp.IsAccepted }; grdPrivateTournaments.DataKeyNames = new string[] { "PrivateTournamentGUID", "TeamGUID" }; grdPrivateTournaments.DataSource = tournaments.OrderBy(p => p.IsAccepted).ToList(); grdPrivateTournaments.DataBind(); } } }
private void LoadThread(Guid guid) { using (var db = Global.GetConnection()) { var forumItems = from ft in db.Ext_Forum where ft.GUID == guid || ft.ResponseToGUID == guid select new { ft.GUID, ft.Header, ft.Body, ft.PostedDate, Author = String.Format("{0} {1}", ft.Sys_User.FirstName, ft.Sys_User.LastName).Trim() }; var theList = forumItems.OrderBy(ft => ft.PostedDate).ToList(); rptForum.DataSource = theList; rptForum.DataBind(); //suggest header for reply Header.Text = "Sv: " + theList[theList.Count - 1].Header; } }
protected void btnGenerateMatches_Click(object sender, EventArgs e) { using (var db = Global.GetConnection()) { //delete any matches fropm before, if any have been updated. Skip this action var checkUpdatedMatches = from m in db.Inti_Match where m.TournamentGUID == TourId select m; if (checkUpdatedMatches.ToList().Count > 0) { lblMatchEditMessage.Text = "Det finns redan matcher i denna tävlingen. Du får editera matcherna manuellt."; return; } //delete all matches in this tournament //var matchesToDelete = db.Inti_Match.Where(m => m.TournamentGUID == TourId); //foreach(var match in matchesToDelete.ToList()) //{ // db.Inti_Match.DeleteOnSubmit(match); //} //db.SubmitChanges(); //loop the clubs of the tournament var clubs = db.Inti_Club.Where(c => c.TournamentGUID == TourId); var clubs1 = clubs.ToList(); var clubs2 = clubs.ToList(); foreach (var homeClub in clubs1) { foreach (var awayClub in clubs2) { if (homeClub.GUID != awayClub.GUID) { var match = new Inti_Match(); match.TournamentGUID = TourId; match.HomeClub = homeClub.GUID; match.AwayClub = awayClub.GUID; match.MatchDate = DateTime.Parse(EndRegistration.Text); match.TourDay = 1; match.IsUpdated = false; db.Inti_Match.InsertOnSubmit(match); } } } db.SubmitChanges(); } }
protected void Page_Load(object sender, EventArgs e) { VerifyAccess("ADMIN"); using (var db = Global.GetConnection()) { var tournament = db.Inti_Tournament.Single(t => t.GUID == TourId); tournamentName.Text = tournament.Name; } }
private void LoadTransferWindows() { using (var db = Global.GetConnection()) { var transferWindows = db.Inti_TransferPeriod.Where(tf => tf.TournamentGUID == TourId); grdTransferPeriods.DataKeyNames = new string[] { "GUID" }; grdTransferPeriods.DataSource = transferWindows.OrderBy(tf => tf.StartDate).ToList(); grdTransferPeriods.DataBind(); } }
private void LoadAthletes() { if (MatchId != Guid.Empty) { using (var db = Global.GetConnection()) { var match = db.Inti_Match.Single(m => m.GUID == MatchId); lblHomeGoalPoints.Text = match.HomeClubInti_Club.Name; var homeAthletes = from def in db.Inti_AthleteClub where def.ClubGUID == match.HomeClub && def.Inti_Position.ShortName != "MGR" && (def.IsActive ?? false) orderby def.Inti_Athlete.LastName orderby def.Inti_Athlete.FirstName orderby def.Inti_Position.SortOrder descending select new { def.GUID, AthleteName = def.Inti_Athlete.FirstName + " " + def.Inti_Athlete.LastName, Position = def.Inti_Position.Name }; grdHomeGoalPoints.DataKeyNames = new string[] { "GUID" }; grdHomeGoalPoints.DataSource = homeAthletes.ToList(); grdHomeGoalPoints.DataBind(); lblAwayGoalPoints.Text = match.Inti_Club.Name; var awayAthletes = from def in db.Inti_AthleteClub where def.ClubGUID == match.AwayClub && def.Inti_Position.ShortName != "MGR" && (def.IsActive ?? false) orderby def.Inti_Athlete.LastName orderby def.Inti_Athlete.FirstName orderby def.Inti_Position.SortOrder descending select new { def.GUID, AthleteName = def.Inti_Athlete.FirstName + " " + def.Inti_Athlete.LastName, Position = def.Inti_Position.Name }; grdAwayGoalPoints.DataKeyNames = new string[] { "GUID" }; grdAwayGoalPoints.DataSource = awayAthletes.ToList(); grdAwayGoalPoints.DataBind(); } } }
private void LoadHeader() { using (var db = Global.GetConnection()) { var users = from u in db.Sys_User where u.GUID == SessionProps.UserGuid select u; var user = users.ToList()[0]; Header.Text = String.Format("{0} {1}", user.FirstName, user.LastName); } }
private void LoadRules() { using (var db = Global.GetConnection()) { var rules = from r in db.Inti_TournamentRule where r.TournamentGUID == SessionProps.SelectedTournament.GUID select r; grdRules.DataSource = rules.OrderBy(r => r.SortOrder).ToList(); grdRules.DataBind(); lblSelectedTournament.Text = SessionProps.SelectedTournament.Name; } }
protected void btnSearch_Click(object sender, EventArgs e) { //lista spelarna IList <Inti_Athlete> players; using (var db = Global.GetConnection()) { players = Searching.SearchForAthletes(db, SearchInput.Text); } grdPlayers.DataKeyNames = new string[] { "GUID" }; grdPlayers.DataSource = players; grdPlayers.DataBind(); }