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 = "";
}
}
