// Save Current Position
public void SaveCurrentPos(int CompPlayerID, int pos)
{
CompPlayer cPlayer = db.CompPlayers.Find(CompPlayerID);
cPlayer.CurrentPos = pos;
db.Entry(cPlayer).State = EntityState.Modified;
db.SaveChanges();
}
// Save Movement Icon
public void SaveMovementIcon(int CompPlayerID, string movementIcon)
{
CompPlayer cPlayer = db.CompPlayers.Find(CompPlayerID);
cPlayer.MovementIcon = movementIcon;
db.Entry(cPlayer).State = EntityState.Modified;
db.SaveChanges();
}
// Get Players Home Club
public int HomeClubID(int compPlayerID)
{
int ClubID = 0;
CompPlayer cplayer = db.CompPlayers.Find(compPlayerID);
int userID = cplayer.UserID;
var pProfile = from pp in db.Profiles
where pp.UserID == userID
select pp;
foreach (var item in pProfile)
{
ClubID = Convert.ToInt32(item.HomeClubID);
}
return(ClubID);
}
// Get Players Current H'Cap
public decimal CurrentHcap(int compPlayerID)
{
decimal Hcap = 0;
CompPlayer cplayer = db.CompPlayers.Find(compPlayerID);
int userID = cplayer.UserID;
var pProfile = from pp in db.Profiles
where pp.UserID == userID
select pp;
foreach (var item in pProfile)
{
Hcap = Convert.ToDecimal(item.Handicap);
}
return(Hcap);
}
public void RemovePlayer(int compPlayerID)
{
CompPlayer compPlayer = db.CompPlayers.Find(compPlayerID);
int compID = compPlayer.CompID;
int userID = compPlayer.UserID;
// Remove any CompScore Records
var PlayerScores = from ps in db.CompScores
where ps.CompPlayerID == compPlayerID
select ps;
foreach (var Score in PlayerScores)
{
db.CompScores.Remove(Score);
}
// Remove any Score Card Image Records
var cardImages = from si in db.ScoreCardImages
where si.CompID == compID && si.UserID == userID
select si;
foreach (var image in cardImages)
{
db.ScoreCardImages.Remove(image);
}
// Remove any Upcomping Rounds
var comingRnds = from cr in db.UpcomingRnds
where cr.CompPlayerID == compPlayerID
select cr;
foreach (var rnd in comingRnds)
{
db.UpcomingRnds.Remove(rnd);
// Remove Comp Player
db.CompPlayers.Remove(compPlayer);
}
// Remove Player
db.CompPlayers.Remove(compPlayer);
db.SaveChanges();
}
