public ActionResult Insert(CompetitionModel model)
{
if (ModelState.IsValid)
{
// Attempt to register the contact
try
{
S_Competition competition = new S_Competition();
competition.challengeid = model.challengeId;
competition.description = model.description;
competition.enddate = model.EndDate;
competition.price = model.price;
competition.startdate = model.StartDate;
CompetitionManager.Insert(competition);
return(RedirectToAction("Competition", "Competition", new { id = competition.challengeid }));
}
catch (MembershipCreateUserException e)
{
ModelState.AddModelError("", "Fout");
}
}
// If we got this far, something failed, redisplay form
return(View(model));
}
public ActionResult Edit(CompetitionModel model)
{
if (ModelState.IsValid)
{
// Attempt to save the competition
try
{
S_Competition competition = CompetitionManager.GetCompetition(model.Id);
competition.challengeid = model.challengeId;
competition.description = model.description;
competition.enddate = model.EndDate;
competition.startdate = model.StartDate;
competition.price = model.price;
competition.id = model.Id;
CompetitionManager.Update(competition);
CompetitionManager.DeleteAllBowlingCentersByCompetition(competition.id);
// setup properties
var selectedBowlingCenters = new List <C_Checkbox>();
var postedBowlingCenterIds = new string[0];
if (model.PostedBowlingCenters == null)
{
model.PostedBowlingCenters = new C_PostedCheckbox();
}
// if a view model array of posted ids exists
// and is not empty, save selected ids
if (model.PostedBowlingCenters.CheckboxIds != null && model.PostedBowlingCenters.CheckboxIds.Any())
{
postedBowlingCenterIds = model.PostedBowlingCenters.CheckboxIds;
foreach (var id in postedBowlingCenterIds)
{
CompetitionManager.InsertBowlingcenterForCompetition(competition.id, long.Parse(id));
}
}
TempData["message"] = "De competitie met nummer " + competition.id + " is aangepast.";
return(RedirectToAction("competition", "Competition", new { id = model.challengeId }));
}
catch (Exception e)
{
TempData["error"] = "Er is een fout opgetreden";
}
}
// If we got this far, something failed, redisplay form
return(View(model));
}
public ActionResult Delete(long id)
{
S_Competition c = CompetitionManager.GetCompetition(id);
try
{
CompetitionManager.Delete(id);
TempData["message"] = "De competitie is verwijderd.";
}
catch (Exception e)
{
TempData["error"] = e.Message;
}
return(RedirectToAction("competition", "Competition", new { id = c.challengeid }));
}
public ActionResult Edit(long id)
{
S_Competition competition = CompetitionManager.GetCompetition(id);
CompetitionModel competitionModel = new CompetitionModel();
competitionModel.Id = competition.id;
competitionModel.challengeId = competition.challengeid;
competitionModel.challenge = ChallengeManager.GetChallenge(competition.challengeid).name;
competitionModel.description = competition.description;
competitionModel.StartDate = competition.startdate;
competitionModel.EndDate = competition.enddate;
competitionModel.price = competition.price;
List <S_BowlingCenter> bcl = BowlingCenterManager.GetBowlingCenters();
List <S_CompetitonBowlingcenter> cbcl = CompetitionManager.GetBowlingcentersByCompetition(competition.id);
competitionModel.AllBowlingCentersChecked = bcl.Count == cbcl.Count;
//var selectedBowlingCenters = CheckboxManager.GetAll()
// .Where(x => cbcl.Any(s => x.Id.ToString().Equals(s.bowlingcenterid)))
// .ToList();
List <C_Checkbox> selectedBowlingCenters = new List <C_Checkbox>();
foreach (S_CompetitonBowlingcenter cbc in cbcl)
{
S_BowlingCenter bc = BowlingCenterManager.GetBowlingCenterById(cbc.bowlingcenterid);
selectedBowlingCenters.Add(new C_Checkbox {
Id = cbc.bowlingcenterid, Name = bc.name
});
}
//setup a view model
competitionModel.AvailableBowlingCenters = CheckboxManager.GetAll().ToList();
competitionModel.SelectedBowlingCenters = selectedBowlingCenters;
return(View(competitionModel));
}
protected void buttonSubmitForm_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
Page.MaintainScrollPositionOnPostBack = true;
bool validUser = true;
string result = string.Empty;
try
{
S_User user = null;
long frequentBowlerNumber = 0;
if (string.IsNullOrEmpty(compFrequentBowlerNummer.Text))
{
result = result = "Vul een Frequent Bowler Nummer in!";
validUser = false;
}
else
{
bool isNumeric = long.TryParse(compFrequentBowlerNummer.Text, out frequentBowlerNumber);
if (!isNumeric)
{
result = "Vul je ID in!";
validUser = false;
}
else
{
if (!UserManager.UserExistByFrequentBowlerNumber(frequentBowlerNumber))
{
result = "Kies je eigen ID, deze bestaat niet!";
validUser = false;
}
}
}
if (string.IsNullOrEmpty(compWachtwoord.Text))
{
result = result = "Vul je wachtwoord in!";
validUser = false;
}
else
{
if (string.IsNullOrEmpty(compFrequentBowlerNaam.Text))
{
result = result = "Vul je Frequent Bowler Naam in!";
validUser = false;
}
else
{
if (!UserManager.UserExistByUsername(compFrequentBowlerNaam.Text))
{
result = result = "Er bestaat geen registratie met deze Frequent Bowler Naam!";
validUser = false;
}
else if (!UserManager.UserExistByFrequentBowlerNumber(frequentBowlerNumber))
{
result = result = "Er bestaat geen registratie met dit ID!";
validUser = false;
}
else
{
user = UserManager.GetUserByNamePasswordAndFrequentbowlernumber(compFrequentBowlerNaam.Text, compWachtwoord.Text, frequentBowlerNumber);
if (user == null)
{
result = result = "Het wachtwoord is niet correct voor deze Frequent Bowler Naam en ID!";
validUser = false;
}
}
}
}
if (validUser)
{
int competitionId = Convert.ToInt16(compCompetitie.SelectedValue);
S_Competition competition = CompetitionManager.GetCompetition(competitionId);
if (competition == null)
{
result = result = "Deze competitie bestaat niet meer, selecteer een andere!";
validUser = false;
}
else
{
if (CompetitionManager.ExistPlayerInCompetition(competitionId, user.id))
{
result = result = "Je doet al mee aan deze competitie, selecteer een andere!";
validUser = false;
}
else
{
CompetitionManager.AddPlayer(user.id, competitionId);
result = result = "Je bent ingeschreven voor deze competitie!";
compCompetitie.Visible = false;
compFrequentBowlerNaam.Visible = false;
compFrequentBowlerNummer.Visible = false;
compWachtwoord.Visible = false;
}
}
}
}
catch (Exception ex)
{
result = "Er is een fout opgetreden, probeer het nogmaals";
}
if (!validUser)
{
meldSuccess.Attributes.Add("style", "color:red");
}
else
{
meldSuccess.Attributes.Add("style", "color:black");
}
meldSuccess.InnerHtml = result;
}
}
public ActionResult competitionranking(long id, string name, long challengeid)
{
ObservableCollection <PlayerRankingGridModel> playerRankingModelList = new ObservableCollection <PlayerRankingGridModel>();
ObservableCollection <PlayerRankingGridModel> filteredPlayerRankingModelList = new ObservableCollection <PlayerRankingGridModel>();
List <S_CompetitionPlayers> playerList;
playerList = CompetitionManager.GetPlayersByCompetition(id);
if (playerList != null && playerList.Count() > 0)
{
S_Competition competition = CompetitionManager.GetCompetition(playerList[0].competitionid);
S_Challenge challenge = ChallengeManager.GetChallengeByCompetition(playerList[0].competitionid);
List <S_CompetitionPlayersRanking> cprl = CompetitionManager.GetCompetitionPlayersRanking(challenge.id, playerList[0].competitionid, playerList, competition.startdate, competition.enddate);
foreach (S_CompetitionPlayersRanking cpr in cprl)
{
PlayerRankingGridModel prgm = new PlayerRankingGridModel();
prgm.Rank = cpr.Rank;
prgm.UserId = cpr.UserId;
prgm.Name = cpr.Name;
prgm.FrequentBowlernumber = cpr.FrequentBowlernumber;
prgm.Score = cpr.Score;
playerRankingModelList.Add(prgm);
}
int rank = cprl.Count();
if (challengeid != 6)
{
foreach (S_CompetitionPlayers cp in playerList)
{
bool playerInRanking = false;
foreach (PlayerRankingGridModel prgm in playerRankingModelList)
{
if (prgm.UserId == cp.userid)
{
playerInRanking = true;
}
}
if (!playerInRanking)
{
S_User u = UserManager.GetUserById(cp.userid);
playerRankingModelList.Add(new PlayerRankingGridModel {
Name = u.name, FrequentBowlernumber = u.frequentbowlernumber, Rank = ++rank
});
}
}
}
foreach (PlayerRankingGridModel prgm in playerRankingModelList)
{
if (name == null || prgm.Name.ToUpper().Contains(name.ToUpper()))
{
filteredPlayerRankingModelList.Add(prgm);
}
}
}
ViewBag.competitionid = id;
ViewBag.challengeid = challengeid;
return(View(filteredPlayerRankingModelList));
}
