public AddUser() { InitializeComponent(); using (MCLEntities entities = new MCLEntities()) { List <UserType> getUserType = (from a in entities.UserTypes select a).Where(x => x.UserTypeId != 3).ToList(); cbUserTypeList.DataSource = getUserType; cbUserTypeList.ValueMember = "UserTypeId"; cbUserTypeList.DisplayMember = "UserType1"; } }
private void cbGameList_SelectedValueChanged(object sender, EventArgs e) { dgvAssignJudge.Rows.Clear(); using (MCLEntities entities = new MCLEntities()) { int gid = Convert.ToInt32(cbGameList.SelectedValue); LeagueJudge[] leagueJudges = entities.LeagueJudges.Where(x => x.LeagueMasterId == gid).ToArray(); foreach (LeagueJudge lj in leagueJudges) { dgvAssignJudge.Rows.Add(lj.UserId, lj.User.FirstName); } } }
private void btnAssign_Click(object sender, EventArgs e) { int gid = Convert.ToInt32(cbGameList.SelectedValue); using (MCLEntities Entities = new MCLEntities()) { foreach (DataGridViewRow row in dgvAssignJudge.Rows) { LeagueJudge lj = new LeagueJudge(); lj.LeagueMasterId = gid; lj.UserId = Int32.Parse(row.Cells[0].Value.ToString()); Entities.LeagueJudges.Add(lj); } Entities.SaveChanges(); } }
private void dgvAssignJudge_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == dgvAssignJudge.Columns["Remove"].Index) { using (MCLEntities Entities = new MCLEntities()) { int gid = Convert.ToInt32(cbGameList.SelectedValue); int userid = Int32.Parse(dgvAssignJudge.Rows[e.RowIndex].Cells[0].Value.ToString()); var lj = (from y in Entities.LeagueJudges where y.LeagueMasterId == gid && y.UserId == userid select y).FirstOrDefault(); Entities.LeagueJudges.Remove(lj); Entities.SaveChanges(); } dgvAssignJudge.Rows.Remove(dgvAssignJudge.Rows[e.RowIndex]); } }
private void btnPromote_Click(object sender, EventArgs e) { btnPromote.Visible = false; cmboxResult.Enabled = false; cmbPromoTier.DataSource = null; lblPromoRank.Text = ""; pnlPromo.Visible = true; if (btnPromote.Text == "Demote from Tier") { using (MCLEntities entities = new MCLEntities()) { View_AllGames game = entities.View_AllGames.Where(x => x.PlayerGameId == selectedGame.PlayerGameId).FirstOrDefault(); Tier[] tiers = entities.Tiers.Where(x => x.RankId == game.CurrentRankId && x.TierTypeId != 1).OrderBy(x => x.Index).ToArray(); cmbPromoTier.DisplayMember = "Title"; cmbPromoTier.DataSource = tiers; cmbPromoTier.Text = game.CurrentTier; cmbPromoTier.SelectedIndex = tiers.Length - 1; lblPromoRank.Text = game.CurrentRank; } } else { using (MCLEntities entities = new MCLEntities()) { View_AllGames game = entities.View_AllGames.Where(x => x.PlayerGameId == selectedGame.PlayerGameId).FirstOrDefault(); Rank nextrank = entities.Ranks.Where(x => x.LeagueId == selectedGame.LeagueId && x.Index > game.CurrentRankIndex).OrderBy(x => x.Index).FirstOrDefault(); if (nextrank != null) { Tier[] tiers = entities.Tiers.Where(x => x.RankId == nextrank.RankId && x.TierTypeId != 1).OrderBy(x => x.Index).ToArray(); cmbPromoTier.DisplayMember = "Title"; cmbPromoTier.DataSource = tiers; cmbPromoTier.SelectedIndex = 0; lblPromoRank.Text = nextrank.Title; } else { MessageBox.Show("Alert", "Next Tier is not available", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } }
private void btnLogin_Click(object sender, EventArgs e) { string name = txtboxUserName.Text; string pw = txtboxPassword.Text; using (MCLEntities entities = new MCLEntities()) { Configuration.User = entities.Users.Where(x => x.LoginId == name && x.Password == pw).SingleOrDefault(); if (Configuration.User != null) { this.Hide(); HomePage homepage = new HomePage(); homepage.ShowDialog(); this.Close(); } else { } } }
void load() { using (MCLEntities entities = new MCLEntities()) { League runningLeague = entities.Leagues.Where(x => x.Status == true).FirstOrDefault(); lblLeague.Text = runningLeague.Title; int?[] allowedGameIds = entities.View_AllJudges.Where(x => x.UserId == Configuration.User.UserId).Select(x => x.GameId).ToArray(); View_AllGames[] games = entities.View_AllGames.Where(x => x.LeagueId == runningLeague.LeagueId).ToArray(); //List<View_AllGames> allowedGames = new List<View_AllGames>(); foreach (View_AllGames game in games) { if (allowedGameIds.Contains((int?)game.GameId)) { dgvPlayerGame.Rows.Add(game.PlayerGameId, game.PlayerName, game.Game, game.GameStartTime.Value.ToShortDateString(), game.GameStartTime.Value.ToShortTimeString(), game.GameEndTime.Value.ToShortTimeString(), game.CurrentRank, game.CurrentTier, game.TotalPoints, game.GameTierType, game.MarkedByFName + " " + game.MarkedByLName, "View"); } } } }
private void cbLeagueList_SelectedValueChanged(object sender, EventArgs e) { dgvAssignJudge.Rows.Clear(); using (MCLEntities entities = new MCLEntities()) { int lid = Convert.ToInt32(cbLeagueList.SelectedValue); //var leagueGames = from t1 in entities.LeagueMasters // join t2 in entities.Games on t1.GameId equals t2.GameId // where t1.LeagueId == lid // select new { t1.LeagueMasterId, t2.Title }; View_AllGamesOfLeague[] leagueGames = entities.View_AllGamesOfLeague.Where(x => x.LeagueId == lid).ToArray(); if (leagueGames.Any()) { cbGameList.ValueMember = "LeagueMasterId"; cbGameList.DisplayMember = "Title"; cbGameList.DataSource = leagueGames; //cbGameList.SelectedIndex = 0; } } }
private void cbGameList_SelectedValueChanged(object sender, EventArgs e) { dgvAssignJudge.Rows.Clear(); using (MCLEntities entities = new MCLEntities()) { int gid = Convert.ToInt32(cbGameList.SelectedValue); //int lid = Convert.ToInt32(cbLeagueList.SelectedValue); //var lm = (from y in entities.LeagueMasters // where y.GameId == gid && y.LeagueId == lid // select y).FirstOrDefault(); //if (lm != null) //{ //int lmid = lm.LeagueMasterId; LeagueJudge[] leagueJudges = entities.LeagueJudges.Where(x => x.LeagueMasterId == gid).ToArray(); foreach (LeagueJudge lj in leagueJudges) { dgvAssignJudge.Rows.Add(lj.UserId, lj.User.FirstName); } //} } }
public void FillLists() { using (MCLEntities entities = new MCLEntities()) { List <League> leagues = (from a in entities.Leagues select a).ToList(); cbLeagueList.ValueMember = "LeagueId"; cbLeagueList.DisplayMember = "Title"; cbLeagueList.DataSource = leagues; cbLeagueList.SelectedIndex = 0; List <User> Users = (from a in entities.Users where a.UserTypeId == 2 select a).ToList(); cbJudgeList.ValueMember = "UserId"; cbJudgeList.DisplayMember = "FirstName"; cbJudgeList.DataSource = Users; cbJudgeList.SelectedIndex = 0; } }
private void btnSelect_Click(object sender, EventArgs e) { foreach (DataGridViewRow row in dgvAssignJudge.Rows) { if (Int32.Parse(row.Cells[0].Value.ToString()) == Int32.Parse(cbJudgeList.SelectedValue.ToString())) { MessageBox.Show("Judge Already Assigned"); return; } } dgvAssignJudge.Rows.Add(cbJudgeList.SelectedValue, cbJudgeList.Text); int gid = Convert.ToInt32(cbGameList.SelectedValue); using (MCLEntities Entities = new MCLEntities()) { LeagueJudge lj = new LeagueJudge(); lj.LeagueMasterId = gid; lj.UserId = Int32.Parse(cbJudgeList.SelectedValue.ToString()); Entities.LeagueJudges.Add(lj); Entities.SaveChanges(); } }
private void load() { panelEditUser.Visible = false; dgvUsers.Rows.Clear(); using (MCLEntities Entities = new MCLEntities()) { List <UserType> getUserType = (from a in Entities.UserTypes select a).ToList(); cbUserTypeList.DataSource = getUserType; cbUserTypeList.ValueMember = "UserTypeId"; cbUserTypeList.DisplayMember = "UserType1"; var Users = (from a in Entities.Users select a).ToList(); foreach (User users in Users) { var UserType = (from a in Entities.UserTypes where a.UserTypeId == users.UserTypeId select a).FirstOrDefault(); dgvUsers.Rows.Add(users.UserId, users.FirstName, users.LastName, UserType.UserType1, users.LoginId, users.EmailId, users.ContactNumber); } } }
private void EditBtn_Click(object sender, EventArgs e) { using (MCLEntities Entities = new MCLEntities()) { var user = (from a in Entities.Users where a.UserId == userId select a).FirstOrDefault(); if (!(string.IsNullOrEmpty(tbFName.Text))) { user.FirstName = tbFName.Text.ToString(); } else { MessageBox.Show("Enter First Name"); tbFName.Focus(); return; } if (!(string.IsNullOrEmpty(tbLName.Text))) { user.LastName = tbLName.Text.ToString(); } else { MessageBox.Show("Enter Last Name"); tbLName.Focus(); return; } user.UserTypeId = Int32.Parse(cbUserTypeList.SelectedValue.ToString()); if (!(string.IsNullOrEmpty(tbLoginId.Text))) { user.LoginId = tbLoginId.Text.ToString(); } else { MessageBox.Show("Enter Login ID"); tbLoginId.Focus(); return; } if (!(string.IsNullOrEmpty(tbPW.Text))) { user.Password = tbPW.Text.ToString(); } else { MessageBox.Show("Enter Password"); tbPW.Focus(); return; } if (!(string.IsNullOrEmpty(tbEmail.Text))) { user.EmailId = tbEmail.Text.ToString(); } else { } if (!(string.IsNullOrEmpty(tbContactNo.Text))) { user.ContactNumber = tbContactNo.Text.ToString(); } else { } Entities.SaveChanges(); MessageBox.Show("User Updated."); load(); } }
void load(int pgid) { Configuration.KillMediaPlayerProcess(); tierPoints = new Dictionary <int, int>(); using (MCLEntities entities = new MCLEntities()) { lblPromo.Visible = false; btnPromo.Visible = false; selectedGame = entities.View_AllGames.Where(x => x.PlayerGameId == pgid).FirstOrDefault(); if ((bool)selectedGame.IsMarked) { cmboxResult.Enabled = false; } else if (selectedGame.GameTierType == "Promo") { btnSave.Visible = false; } lblPlayerName.Text = selectedGame.PlayerName.ToString(); lblLeague.Text = selectedGame.League; lblStartTime.Text = selectedGame.GameStartTime.ToString(); lblEndTime.Text = selectedGame.GameEndTime.ToString(); lblGame.Text = selectedGame.Game; Tier[] tiers = entities.Tiers.Where(x => x.RankId == selectedGame.CurrentRankId).OrderBy(x => x.Index).ToArray(); cmbTier.DisplayMember = "Title"; cmbTier.DataSource = tiers; cmbTier.Text = selectedGame.CurrentTier; Rank rank = entities.Ranks.Where(x => x.RankId == selectedGame.CurrentRankId).FirstOrDefault(); int point = (int)rank.TierPoints; foreach (Tier tier in tiers) { tierPoints.Add(tier.TierId, point); point = point + (int)rank.TierPoints; } Result[] results = entities.Results.ToArray(); if (selectedGame.GameTier == "Promo") { results = results.Where(x => x.ResultId != 3 && x.ResultId != 5).ToArray(); } cmboxResult.DisplayMember = "Title"; cmboxResult.DataSource = results; cmboxResult.Text = selectedGame.GameResult; if (selectedGame.TotalPoints == null) { lblTotalPoints.Text = "0"; } else { lblTotalPoints.Text = selectedGame.TotalPoints.ToString(); } lblRank.Text = selectedGame.CurrentRank; if (selectedGame.RecordingFileName != null) { runMediaPlayerProcess(selectedGame.RecordingFileName); } if (selectedGame.GameTierType != "Promo") { #region Game { if (selectedGame.PromoEnabled) { btnPromo.Text = "Disable"; lblPromo.Text = "PROMO ENABLED"; } else { btnPromo.Text = "Enable"; lblPromo.Text = "PROMO DISABLED"; } if ((bool)selectedGame.IsMarked && selectedGame.CurrentTierTypeId == 1) { lblPromo.Visible = true; btnPromo.Visible = true; } } #endregion } else { #region Promo { lblPromo.Visible = false; btnPromo.Visible = false; // tbPromoTotalPoints.Text = selectedGame.TotalPoints.ToString(); // if (selectedGame.TotalPoints == null) lblTotalPoints.InnerText = "0"; // else lblTotalPoints.InnerText = selectedGame.TotalPoints.ToString(); } #endregion } } }
private void cmboxResult_SelectedIndexChanged(object sender, EventArgs e) { Result rsult = cmboxResult.SelectedItem as Result; if (selectedGame.GameTierType != "Promo") { int gainpoints = 0; Rank rank; using (MCLEntities entities = new MCLEntities()) { rank = entities.Ranks.Where(x => x.RankId == selectedGame.CurrentRankId).FirstOrDefault(); if (rsult.ResultId == 1)//Win { gainpoints = (int)entities.LeagueMasters.Where(x => x.LeagueId == selectedGame.LeagueId).FirstOrDefault().WinPoints; } else if (rsult.ResultId == 2)//Loose { gainpoints = (int)entities.LeagueMasters.Where(x => x.LeagueId == selectedGame.LeagueId).FirstOrDefault().LoosePoints; } else if (rsult.ResultId == 3)//Tie { gainpoints = (int)entities.LeagueMasters.Where(x => x.LeagueId == selectedGame.LeagueId).FirstOrDefault().TiePoints; } else if (rsult.ResultId == 4)//None { gainpoints = 0; } else if (rsult.ResultId == 5)//Invalid { gainpoints = (int)entities.LeagueMasters.Where(x => x.LeagueId == selectedGame.LeagueId).FirstOrDefault().InvalidPoints; } } lblGamePoints.Text = gainpoints.ToString(); if (cmboxResult.Enabled) { int points = Convert.ToInt32(selectedGame.TotalPoints); points = points + gainpoints; lblTotalPoints.Text = points.ToString(); int tierId; if (gainpoints != 0) { tierId = getNextTier(points); } else { tierId = (int)selectedGame.CurrentTierId; } setTier(tierId); } } else { lblGamePoints.Text = "0"; } if (cmboxResult.Enabled && cmbTier.Text == "Promo" && selectedGame.GameTierType != "Promo") { btnPromo.Visible = true; lblPromo.Visible = true; } else if (selectedGame.GameTierType == "Promo") { btnPromo.Visible = false; lblPromo.Visible = false; if ((bool)selectedGame.IsMarked) { btnPromote.Visible = false; } else { if (rsult.Title == "Win") { btnPromote.Text = "Promote To Next Rank"; btnPromote.Visible = true; } else if (rsult.Title == "Loose") { btnPromote.Text = "Demote from Tier"; btnPromote.Visible = true; } else { btnPromote.Visible = false; } } } else { btnPromo.Visible = false; lblPromo.Visible = false; } //int totalpoints = Convert.ToInt32(lblTotalPoints.InnerText); //totalpoints = totalpoints + gainpoints; //tbtotalPoints.Text = totalpoints.ToString(); //dlisttier_SelectedIndexChanged(null, null); }
private void SaveBtn_Click(object sender, EventArgs e) { using (MCLEntities entities = new MCLEntities()) { User user = new User(); if (!(string.IsNullOrEmpty(tbFName.Text))) { user.FirstName = tbFName.Text.ToString(); } else { MessageBox.Show("Enter First Name"); tbFName.Focus(); return; } if (!(string.IsNullOrEmpty(tbLName.Text))) { user.LastName = tbLName.Text.ToString(); } else { MessageBox.Show("Enter Last Name"); tbLName.Focus(); return; } user.UserTypeId = Int32.Parse(cbUserTypeList.SelectedValue.ToString()); if (!(string.IsNullOrEmpty(tbLoginId.Text))) { user.LoginId = tbLoginId.Text.ToString(); } else { MessageBox.Show("Enter Login ID"); tbLoginId.Focus(); return; } if (!(string.IsNullOrEmpty(tbPW.Text))) { user.Password = tbPW.Text.ToString(); } else { MessageBox.Show("Enter Password"); tbPW.Focus(); return; } if (!(string.IsNullOrEmpty(tbEmail.Text))) { user.EmailId = tbEmail.Text.ToString(); } else { } if (!(string.IsNullOrEmpty(tbContactNo.Text))) { user.ContactNumber = tbContactNo.Text.ToString(); } else { } entities.Users.Add(user); entities.SaveChanges(); MessageBox.Show("New User Added."); tbFName.Text = ""; tbLName.Text = ""; tbLoginId.Text = ""; tbPW.Text = ""; tbEmail.Text = ""; tbContactNo.Text = ""; } }