protected void grdPoints_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Edit") { int index = Convert.ToInt32(e.CommandArgument); string value = this.grdPoints.DataKeys[index].Values["id"].ToString(); Response.Redirect("edit.aspx?id=" + value.ToString()); } if (e.CommandName == "DeletePoints") { int index = Convert.ToInt32(e.CommandArgument); string value = this.grdPoints.DataKeys[index].Values["id"].ToString(); player_points _points = new player_points(); _points = _dal.GetPointsById(new Guid(value)); _points.isDeleted = true; _points.deletedDate = DateTime.Now; _dal.SoccerEntities.SaveChanges(); } }
protected void Page_Load(object sender, EventArgs e) { player _player = new player(); player_points _playerpoints = new player_points(); IQueryable<prize> _prizes; string id = Request.QueryString["playerId"]; Guid _guid = string.IsNullOrEmpty(id) ? new Guid() : new Guid(id); _player = _dal.GetPlayerBYID(new Guid(_dal.UserID.ToString())); playerName.InnerText = _player.Name.Substring(0, 9); lblshirtNumber.Text = _player.shirtNumber.ToString(); int playerPointsToadd = _dal.GetTotalPointsToAdd(); lblpoints.Text = playerPointsToadd.ToString(); _playerpoints = _dal.GetPlayerPointsBYID(new Guid(_dal.UserID.ToString())); _prizes = _dal.getAllprizesByPoints(Convert.ToInt32(_playerpoints.points)); rptPrize.DataSource = _prizes.ToList(); rptPrize.DataBind(); points.InnerText = _playerpoints.points.ToString(); }
public player_points GetPointsTORedeemByPlayerId(Guid _playerId) { try { if (_playerId == Guid.Empty) { player_points _playerpoints = new player_points(); return _playerpoints; } else { var q = SoccerEntities.player_points.Where(p => p.playerId == _playerId && p.isProcessed==true); if (q == null) throw new EntityContextException(string.Format("No Points could be found for player to be processed {0}!", _playerId)); else return q.ToList()[0]; } } catch (Exception ex) { throw new EntityContextException("GetPlayerBYID failed.", ex); } }
protected void btnSave_Click(object sender, EventArgs e) { try { string id = Request.QueryString["id"]; if (id != "00000000-0000-0000-0000-000000000000") { _playerId = string.IsNullOrEmpty(id) ? new Guid() : new Guid(id); } string teamIds = Request.QueryString["teamId"]; if (teamIds != "00000000-0000-0000-0000-000000000000") { _teamId = string.IsNullOrEmpty(id) ? new Guid() : new Guid(id); } player _player = new player(); RadWindow1.VisibleOnPageLoad = false; _player = _dal.GetPlayerBYID(_playerId); _player.Name = txtFullName.Text; _player.email = txtEmail.Text; _player.address = txtAddress.Text; _player.description = txtDescription.InnerText; _player.gender = dlGenders.SelectedValue.ToString(); _player.modifiedDate = DateTime.Now; _player.teamId = new Guid(ddlTeam.SelectedValue.ToString()); if (Convert.ToDateTime(dateOfBirth.Text) == new DateTime(1900, 1, 1)) _player.dob =Convert.ToDateTime(dateOfBirth.Text); if (_player.player_id == null) _player.player_id = _dal.genPlayerID(new Guid("B9B2A89A-2295-4E48-BBA4-9DC28A1855FB"), new Guid("6E424913-A9A4-4A46-9785-C8AFA09C82DB")); if (_teamId != Guid.Empty) { _player.teamId = _teamId; } if (id == "00000000-0000-0000-0000-000000000000") { player_points _points = new player_points(); _points.points = 200; _points.pointsToRedeem = 20; _points.authCreatedDate = DateTime.Now; _points.authUserName = User.Identity.Name; _player.player_points.Add(_points); _dal.SoccerEntities.AddToplayers(_player); } _dal.SoccerEntities.SaveChanges(); } catch (Exception ex) { throw new EntityContextException("btnSave_Click failed.", ex); } Response.Redirect("default.aspx?teamId=00000000-0000-0000-0000-000000000000&id=00000000-0000-0000-0000-000000000000"); }
public player_points GetPointsById(Guid _ppoints) { try { if (_ppoints == Guid.Empty) { player_points _points = new player_points(); return _points; } else { var q = SoccerEntities.player_points.Where(p => p.id == _ppoints && p.isDeleted == false); if (q == null) throw new EntityContextException(string.Format("A Point could not be found {0}!", _ppoints)); else return q.ToList()[0]; } } catch (Exception ex) { throw new EntityContextException("GetPointsById failed.", ex); } }
/// <summary> /// Deprecated Method for adding a new object to the player_points EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToplayer_points(player_points player_points) { base.AddObject("player_points", player_points); }
/// <summary> /// Create a new player_points object. /// </summary> /// <param name="id">Initial value of the id property.</param> /// <param name="playerId">Initial value of the playerId property.</param> public static player_points Createplayer_points(global::System.Guid id, global::System.Guid playerId) { player_points player_points = new player_points(); player_points.id = id; player_points.playerId = playerId; return player_points; }