private void btnOk_Click(object sender, EventArgs e)
{
btnPromote.Visible = false;
cmboxResult.Enabled = false;
pnlPromo.Visible = false;
lblTotalPoints.Text = selectedGame.TotalPoints.ToString();
using (MCLEntities entities = new MCLEntities())
{
PlayerGame pg = entities.PlayerGames.Where(x => x.PlayerGameId == selectedGame.PlayerGameId).FirstOrDefault();
PlayerMaster pm = entities.PlayerMasters.Where(x => x.PlayerMasterId == pg.PlayerMasterId).FirstOrDefault();
pg.ResultId = (cmboxResult.SelectedItem as Result).ResultId;
pg.GamePoints = Convert.ToInt32(lblExtraPoints.Text);
pg.IsMarked = true;
pg.MarkedAt = DateTime.Now;
pg.MarkedById = Configuration.User.UserId;
entities.SaveChanges();
pm.TierId = (cmbPromoTier.SelectedItem as Tier).TierId;
pm.Points = 0;
pm.TotalPoints = Convert.ToInt32(lblTotalPoints.Text);
pm.PromoEnabled = false;
pm.IsPromoBlock = false;
entities.SaveChanges();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
using (MCLEntities entities = new MCLEntities())
{
PlayerGame pg = entities.PlayerGames.Where(x => x.PlayerGameId == selectedGame.PlayerGameId).FirstOrDefault();
PlayerMaster pm = entities.PlayerMasters.Where(x => x.PlayerMasterId == pg.PlayerMasterId).FirstOrDefault();
if (cmboxResult.Enabled)
{
pg.ResultId = (cmboxResult.SelectedItem as Result).ResultId;
pg.GamePoints = Convert.ToInt32(lblGamePoints.Text);
pg.IsMarked = true;
pg.MarkedAt = DateTime.Now;
pg.MarkedById = Configuration.User.UserId;
entities.SaveChanges();
pm.TierId = (cmbTier.SelectedItem as Tier).TierId;
pm.Points = pm.Points + Convert.ToInt32(lblGamePoints.Text);
pm.TotalPoints = Convert.ToInt32(lblTotalPoints.Text);
if (btnPromo.Text == "Disable")
{
pm.PromoEnabled = true;
pm.IsPromoBlock = false;
}
else
{
pm.PromoEnabled = false;
}
entities.SaveChanges();
if (pg.ResultId != 4)
{
cmboxResult.Enabled = false;
}
}
else
{
if (btnPromo.Text == "Disable")
{
pm.PromoEnabled = true;
pm.IsPromoBlock = false;
}
else
{
pm.PromoEnabled = false;
}
entities.SaveChanges();
}
}
}
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 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 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();
}
}
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 = "";
}
}
