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