protected void Page_Load(object sender, EventArgs e) { if (!Roles.IsUserInRole(Page.User.Identity.Name, "CSBA_Admin")) { rBTNAssign.Enabled = false; rBTNPickPlayer.Enabled = false; rDDSeasonTeam.Enabled = false; rBTNEmptyRecycleBin.Enabled = false; rBTNEmptyRecycleBin.Visible = false; } Session["time"] = DateTime.Now.AddSeconds(40); if (!IsPostBack) { List <SeasonDomainModel> Seasons = new List <SeasonDomainModel>(); Seasons = SeasonBLL.ListSeason(); var CurrentSeasonID = from Season in Seasons where Season.CurrentSeason select Season.SeasonID; List <PositionDomainModel> Pos = new List <PositionDomainModel>(); Pos = PosBLL.ListPositions().OrderBy(o => o.PositionName).ToList(); rDDPosition.DataSource = Pos; rDDPosition.DataTextField = "PositionNameLong"; rDDPosition.DataValueField = "PositionID"; rDDPosition.DataBind(); rDDPosition.SelectedIndex = 0; rDDSeason.DataSource = Seasons; rDDSeason.DataValueField = "SeasonID"; rDDSeason.DataTextField = "SeasonName"; rDDSeason.DataBind(); rDDSeason.SelectedValue = CurrentSeasonID.FirstOrDefault().ToString(); SetPlayerListBox(); rDDPrimPos.DataSource = PosBLL.ListPositions(); rDDPrimPos.DataValueField = "PositionID"; rDDPrimPos.DataTextField = "PositionNameLong"; rDDPrimPos.DataBind(); LoadrDDSeasonTeam(); } DraftStatusDomainModel DraftStatus = new DraftStatusDomainModel(); DraftStatus = DraftPlayerBLL.DraftStatus(Convert.ToInt32(rDDSeason.SelectedValue)); rLGStatus.Scale.Max = (decimal)DraftStatus.SeaonPlayerTotal; rLGStatus.Pointer.Value = (decimal)DraftStatus.SeasonPlayerDrafted; rLGStatus.ToolTip = string.Format("Players Drafted: {0}, Players Total: {1}", rLGStatus.Pointer.Value, rLGStatus.Scale.Max); ManageButtons(); }
public DraftStatusDomainModel DraftStatus(int SeasonID) { DraftStatusDomainModel dStatus = new DraftStatusDomainModel(); using (CSBAAzureEntities context = new CSBAAzureEntities()) { dStatus = (from result in context.DraftPlayerStatus(SeasonID) select new DraftStatusDomainModel { SeaonPlayerTotal = result.SeaonPlayerTotal, SeasonPlayerDrafted = result.SeasonPlayerDrafted }).FirstOrDefault(); } // Guaranteed to close the Connection return(dStatus); }