public static Game GetGameById(int id) { var db = new GolfDB(); Game g = db.Games.Where(v => v.UserId.UserId == id).SingleOrDefault(); return(g); }
public static List <Game> GetAllGamesByUser(int id) { var db = new GolfDB(); List <Game> games = db.Games.Include("UserId").Where(g => g.UserId.UserId == id).ToList(); return(games); }
private void btnSaveUser_Click(object sender, EventArgs e) { GolfDB db = new GolfDB(); //create user to be saved User user = new User(); //check to see if user is already present by username User testUser = DBHelper.GetUserByUsername(txtUsername.Text); if (testUser == null) { User saveUser = new User(); saveUser.Username = txtUsername.Text; saveUser.Password = txtPassword.Text; db.Users.Add(saveUser); if (db.SaveChanges() == 1) { MessageBox.Show("User saved!"); } } else { MessageBox.Show("User already exists!"); } }
public static User GetUserByUsername(string username) { //create golf database context var db = new GolfDB(); //search for user. user will be set to null if not found User user = db.Users.Where(u => u.Username == username).SingleOrDefault(); return(user); }
private void IndividualPlayerStats_Load(object sender, EventArgs e) { GolfDB dB = new GolfDB(); Game g = dB.Games.Include("Holes").Where(a => a.GameId == gameId).SingleOrDefault(); List <Hole> holes = g.Holes; int count = 1; foreach (Hole H in holes) { this.chart1.Series[""].Points.AddXY(count, H.Par); this.chart1.Series[""].Points.AddXY(count, H.TotalShots); count++; } }
private void btnFinishGame_Click(object sender, EventArgs e) { var db = new GolfDB(); db.Users.Attach(game.UserId); db.Games.Add(game); if (db.SaveChanges() == 1) { MessageBox.Show("Game saved!"); } else { MessageBox.Show("Something went wrong."); } }
private void btnSaveUser_Click(object sender, EventArgs e) { //create new golfDB to connect to DB? GolfDB db = new GolfDB(); //create user to be saved User user = new User(); if (txtPassword.Text != txtPassConfirmation.Text) { txtPassNotMatched.Visible = true; } else if (txtPassword.Text == txtPassConfirmation.Text && txtPassword.Text.Length >= 6) { //check to see if user is already present by username User testUser = DBHelper.GetUserByUsername(txtUsername.Text); if (testUser == null) { User saveUser = new User(); saveUser.Username = txtUsername.Text; saveUser.Password = txtPassword.Text; db.Users.Add(saveUser); if (db.SaveChanges() == 1) { MessageBox.Show("User saved!"); } } else { MessageBox.Show("User already exists!"); } } else { lblPassCharacter.Visible = true; } }