public ActionResult SettleWager(int WagerId)
{
// Create model
WagerModel wager = new WagerModel
{
Id = WagerId
};
// Pass model to database for update
wagerRepo.EditWager((int)WagerEditQuery.Settle, wager, User.Identity.GetUserName());
// Refresh page
return(PendingSettlement());
}
public ActionResult AcceptWager(int WagerId)
{
// Create model
WagerModel wager = new WagerModel
{
Id = WagerId
};
// Pass model to database for update
wagerRepo.EditWager((int)WagerEditQuery.Accept, wager, User.Identity.GetUserName());
// Refresh page
return(BetFeed());
}
public ActionResult AddWager()
{
// Load the model
WagerModel wager = new WagerModel();
TryUpdateModel <WagerModel>(wager);
// Check if model is valid
if (!ModelState.IsValid)
{
// Load bets and store in viewbag
ViewBag.Wagers = wagerRepo.GetWagers((int)WagerGetQuery.OpenBets, User.Identity.GetUserName());
wager.Id = -1;
// Redirect back to bet feed with invalid model
return(View("OpenBets", wager));
}
// Pass model to database for insert
wagerRepo.EditWager((int)WagerEditQuery.Insert, wager, User.Identity.GetUserName());
// Refresh page
return(OpenBets());
}
// Edits wagers
public int EditWager(int mode, WagerModel wager, string username)
{
int returnValue;
// Get connection string
string constring = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
SqlConnection con = new SqlConnection(constring);
try // If any part errors, go to catch clause
{
// Create Connection
string query = "sp_Wager_edit";
var command = new SqlCommand(query, con);
command.CommandType = System.Data.CommandType.StoredProcedure;
// Add parameters
command.Parameters.Add("@mode", System.Data.SqlDbType.Int);
command.Parameters["@mode"].Direction = System.Data.ParameterDirection.Input;
command.Parameters["@mode"].Value = mode;
command.Parameters.Add("@id", System.Data.SqlDbType.Int);
command.Parameters["@id"].Direction = System.Data.ParameterDirection.Input;
command.Parameters["@id"].Value = wager.Id;
command.Parameters.Add("@teamNameFor", System.Data.SqlDbType.VarChar);
command.Parameters["@teamNameFor"].Direction = System.Data.ParameterDirection.Input;
command.Parameters["@teamNameFor"].Value = wager.TeamName_For;
command.Parameters.Add("@teamNameAgainst", System.Data.SqlDbType.VarChar);
command.Parameters["@teamNameAgainst"].Direction = System.Data.ParameterDirection.Input;
command.Parameters["@teamNameAgainst"].Value = wager.TeamName_Against;
command.Parameters.Add("@spread", System.Data.SqlDbType.Int);
command.Parameters["@spread"].Direction = System.Data.ParameterDirection.Input;
command.Parameters["@spread"].Value = wager.Spread;
command.Parameters.Add("@gameTime", System.Data.SqlDbType.VarChar);
command.Parameters["@gameTime"].Direction = System.Data.ParameterDirection.Input;
command.Parameters["@gameTime"].Value = wager.GameTime;
command.Parameters.Add("@wager", System.Data.SqlDbType.Int);
command.Parameters["@wager"].Direction = System.Data.ParameterDirection.Input;
command.Parameters["@wager"].Value = wager.Wager;
command.Parameters.Add("@userName", System.Data.SqlDbType.VarChar);
command.Parameters["@userName"].Direction = System.Data.ParameterDirection.Input;
command.Parameters["@userName"].Value = username;
command.Parameters.Add("@returnValue", System.Data.SqlDbType.Int);
command.Parameters["@returnValue"].Direction = System.Data.ParameterDirection.ReturnValue;
// Execute Query
con.Open();
command.ExecuteNonQuery();
// Return model
returnValue = (int)command.Parameters["@returnValue"].Value;
}
catch (Exception ex) // If any errors occur while querying database, the following message gets displayed to user
{
throw new Exception(string.Format("Exception Thrown Message - {0} Stack Trace - {1}", ex.Message, ex.StackTrace));
}
finally // Close connection
{
returnValue = -1;
if (con.State == System.Data.ConnectionState.Open)
{
con.Close();
}
}
return(returnValue);
}
