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