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