public void DeleteSeasonRecyclePlayerAll(SeasonPlayerDomainModel _SeasonPlayer) { using (CSBAAzureEntities context = new CSBAAzureEntities()) { context.Database.ExecuteSqlCommand("sp_SeasonPlayerRecycle_deleteAll {0}", _SeasonPlayer.SeasonID); } }
protected void rBTNAssign_Click(object sender, EventArgs e) { //var strPlayerGUID = rLBPlayer.SelectedValue; var strPlayerGUID = hddPlayerGUID.Value; Guid PlayerGuid = Guid.Parse(strPlayerGUID); if (rDDSeasonTeam.SelectedValue == "0") // Put player in recycle bin { SeasonPlayerDomainModel SP = new SeasonPlayerDomainModel(); SeasonPlayerBusinessLogic SPBLL = new SeasonPlayerBusinessLogic(); SP.SeasonID = Convert.ToInt32(rDDSeason.SelectedValue); SP.PlayerGUID = PlayerGuid; SPBLL.InsertSeasonPlayerRecycle(SP); } else { SeasonTeamPlayerDomainModel STP = new SeasonTeamPlayerDomainModel(); STP.SeasonID = Convert.ToInt32(rDDSeason.SelectedValue); STP.TeamID = Convert.ToInt32(rDDSeasonTeam.SelectedValue); STP.PlayerGUID = PlayerGuid; STP.Points = Convert.ToInt32(rNTBCurrBid.Value); DraftPlayerBLL.DraftPlayer(STP); } strPageState = "Pick"; ManageButtons(); RepaintScreen(); }
public void InsertSeasonPlayer(SeasonPlayerDomainModel _SeasonPlayer) { using (CSBAAzureEntities context = new CSBAAzureEntities()) { context.Database.ExecuteSqlCommand("sp_SeasonPlayer_Insert {0}, {1}", _SeasonPlayer.SeasonID, _SeasonPlayer.PlayerGUID); } }
public void DeleteSeasonPlayerAll(SeasonPlayerDomainModel _SeasonPlayer, PositionDomainModel _Position) { using (CSBAAzureEntities context = new CSBAAzureEntities()) { context.Database.ExecuteSqlCommand("sp_SeasonPlayer_deleteAll {0}, {1}", _SeasonPlayer.SeasonID, _Position.PositionID); } }
protected void rBTNSaveChanges_Click(object sender, EventArgs e) { SeasonPlayerDomainModel _SeasonPlayer = new SeasonPlayerDomainModel(); _SeasonPlayer.SeasonID = (Convert.ToInt32(rDDSeason.SelectedValue)); PositionDomainModel _Position = new PositionDomainModel(); _Position.PositionID = (Convert.ToInt16(rDDPosition.SelectedValue)); SPBLL.DeleteSeasonPlayerAll(_SeasonPlayer, _Position); int iStOrder = 1; foreach (RadListBoxItem item in rLBPlayerSelected.Items) { SeasonPlayerDomainModel _SPNew = new SeasonPlayerDomainModel(); _SPNew.SeasonID = Convert.ToInt32(rDDSeason.SelectedValue); _SPNew.PlayerGUID = new Guid(item.Value.ToString()); iStOrder += 1; SPBLL.InsertSeasonPlayer(_SPNew); } SetupListBoxes(); }
protected void rBTNEmptyRecycleBin_Click(object sender, EventArgs e) { SeasonPlayerDomainModel SP = new SeasonPlayerDomainModel(); SeasonPlayerBusinessLogic SPBLL = new SeasonPlayerBusinessLogic(); SP.SeasonID = Convert.ToInt32(rDDSeason.SelectedValue); SPBLL.DeleteSeasonRecyclePlayerAll(SP); }
public void DeleteSeasonRecyclePlayerAll(SeasonPlayerDomainModel _SeasonPlayer) { SPDAL.DeleteSeasonRecyclePlayerAll(_SeasonPlayer); }
public void InsertSeasonPlayerRecycle(SeasonPlayerDomainModel _SeasonPlayer) { SPDAL.InsertSeasonPlayerRecycle(_SeasonPlayer); }
public void DeleteSeasonPlayerAll(SeasonPlayerDomainModel _SeasonPlayer, PositionDomainModel _Position) { SPDAL.DeleteSeasonPlayerAll(_SeasonPlayer, _Position); }
public static void HandlePitcher(List <clsPitcher> colPitchers) { PlayerBusinessLogic pBLL = new PlayerBusinessLogic(); PlayerDomainModel player = new PlayerDomainModel(); PlayerPostiionBusinessLogic ppBLL = new PlayerPostiionBusinessLogic(); PlayerPositionDomainModel playerposition = new PlayerPositionDomainModel(); StatBusinessLogic sBLL = new StatBusinessLogic(); StatDomainModel stat = new StatDomainModel(); SeasonPlayerPositionStatBusinessLogic sppsBLL = new SeasonPlayerPositionStatBusinessLogic(); SeasonPlayerPositionStatDomainModel statValue = new SeasonPlayerPositionStatDomainModel(); SeasonPlayerBusinessLogic spBLL = new SeasonPlayerBusinessLogic(); SeasonPlayerDomainModel spDM = new SeasonPlayerDomainModel(); statValue.SeasonID = C_SeasonID; statValue.PlayerGUID = player.PlayerGUID; sppsBLL.DeleteAllStatsForPlayer(statValue); foreach (clsPitcher cPitcher in colPitchers) { player.PlayerName = cPitcher.FirstName.Trim() + " " + cPitcher.LastName.Trim(); pBLL.InsertPlayer(player); playerposition.PlayerGUID = player.PlayerGUID; playerposition.PrimaryPositionID = TransformPos(cPitcher.Pos); playerposition.SecondaryPostiionID = null; ppBLL.DeletePlayerPosition(playerposition); ppBLL.InsertPlayerPosition(playerposition); spDM.PlayerGUID = player.PlayerGUID; spDM.SeasonID = C_SeasonID; spBLL.InsertSeasonPlayer(spDM); BindingFlags flags = BindingFlags.Instance | BindingFlags.Public | BindingFlags.NonPublic; foreach (FieldInfo f in cPitcher.GetType().GetFields(flags)) { Console.WriteLine("{0} = {1}", f.Name, f.GetValue(cPitcher)); System.Diagnostics.Debug.WriteLine("{0} = {1}", f.Name, f.GetValue(cPitcher)); string fieldName = _getBackingFieldName(f.Name.ToUpper()); if (fieldName != "FIRSTNAME" && fieldName != "LASTNAME" && fieldName != "PT" && fieldName != "POS") { stat.StatName = fieldName; stat.PositionTypeID = 2; // 1 = hitter stat = sBLL.InsertStat(stat); statValue.SeasonID = C_SeasonID; statValue.PlayerGUID = player.PlayerGUID; statValue.PositionID = TransformPos(cPitcher.Pos); statValue.StatID = stat.StatID; if (f.GetValue(cPitcher) == null) { statValue.StatValue = null; } else { statValue.StatValue = f.GetValue(cPitcher).ToString(); } sppsBLL.InsertStatValue(statValue); } } } }