private ApiResult SaveUserPick(Dictionary <string, string> p)
{
ApiResult result = new ApiResult();
try
{
int tournamentId = Convert.ToInt32(p["tournament"]);
int userId = Convert.ToInt32(p["user"]);
int golferId = Convert.ToInt32(p["golfer"]);
if (tournamentId > 0 && userId > 0 && golferId > 0)
{
UserPickService.Save(userId, tournamentId, golferId);
result.Success = true;
}
else
{
result.Success = false;
result.Message = "One of the parameters was missing";
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
protected void OnSelectGolfer(object sender, EventArgs e)
{
var ddl = (DropDownList)sender;
if (ddl != null)
{
int tournamentId = Convert.ToInt32(ddl.Attributes["TournamentId"].ToString());
int userId = Convert.ToInt32(user_list.SelectedValue);
int golferId = Convert.ToInt32(ddl.SelectedValue);
UserPickService.Save(userId, tournamentId, golferId);
}
}
protected void OnSavePick(object sender, EventArgs e)
{
////save values
//SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["default"].ConnectionString);
//connection.Open();
//connection.Query("UserPick_Set", new {
// TournamentId = tournament_list.SelectedValue,
// UserId = user_list.SelectedValue,
// GolferId = golfer_list.SelectedValue
//}, commandType: CommandType.StoredProcedure);
//connection.Close();
UserPickService.Save(user_list.SelectedValue, tournament_list.SelectedValue, golfer_list.SelectedValue);
//should the change log be here, or in the UserPick.Save mehtod?
message_label_panel.Visible = true;
message_label.Text = "Pick was saved";
BindGrid();
}
protected void OnDataBoundUserPicks(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
DropDownList golfer_list = (DropDownList)e.Row.FindControl("golfer_list");
golfer_list.DataSource = GolferService.ListActive(); //hopefully the caching works
golfer_list.DataBind();
golfer_list.Items.Insert(0, "-- Choose a Golfer --");
//get current pick (if any)
int tournamentId = Convert.ToInt32(((HiddenField)e.Row.FindControl("userpick_hidden")).Value);
int userId = Convert.ToInt32(user_list.SelectedValue);
var pick = UserPickService.Get(userId, tournamentId); //should get all on page load and search through collection (too many db calls)
try
{
if (pick != null)
{
golfer_list.SelectedValue = pick.GolferId.ToString();
}
}
catch { }
}
}
