public bool JoinLeague(UserAndLeague model) { bool success = false; int rowsaffected = 0; string addUserLeagueSql = @"insert into users_leagues (userId, leagueId) values (@userId, @leagueId);"; using (SqlConnection sqlC = new SqlConnection(connectionString)) { try { sqlC.Open(); SqlCommand cmd = new SqlCommand(addUserLeagueSql, sqlC); cmd.Parameters.AddWithValue("@userId", model.UserId); cmd.Parameters.AddWithValue("@leagueId", model.LeagueId); rowsaffected = cmd.ExecuteNonQuery(); success = (rowsaffected > 0); } catch (SqlException sqlEx) { Console.WriteLine(sqlEx); success = false; } } return(success); }
public ActionResult CreateLeague(League league) { league.UserName = Session[SessionKeys.Username].ToString(); UserAndLeague model = new UserAndLeague() { UserId = (int)Session[SessionKeys.UserId], LeagueId = -1 }; bool createSuccessful = dal.CreateLeague(league); bool addSuccessful = false; if (createSuccessful) { model.LeagueId = dal.GetLeagueId(league.Name); if (model.LeagueId > 0) //valid league id will be greater than 0 { addSuccessful = dal.JoinLeague(model); } } if (createSuccessful && addSuccessful) { SetMessage("League has been successfully created!", MessageType.Success); } else { SetMessage("There was an error creating your league!", MessageType.Error); } return(RedirectToAction("Index", "Home")); }