public ActionResult Homepage(int contestantId, int VoteSessionId) { var usr = Session["Username"]; var pw = Session["Password"]; //to make sure you have signed in. if (usr?.ToString() == null || pw?.ToString() == null) { TempData["MessageType"] = "danger"; TempData["Message"] = "Please you have to sign in first!!"; return(Redirect("Login")); } if (db.EligibleMembers.Where(dbl => dbl.email.ToLower() == usr.ToString().ToLower() && dbl.password == pw.ToString()).Count() == 0) { TempData["MessageType"] = "danger"; TempData["Message"] = "Please enter a valid email amd password combination!!"; return(Redirect("Login")); } //vote once foreach (var voterecord in db.voteLogs) { if (voterecord.VotingSessionId == VoteSessionId && voterecord.EligibleMember.email.ToLower() == usr.ToString().ToLower()) { TempData["MessageType"] = "danger"; TempData["Message"] = "You can only vote once!!"; return(Redirect("Homepage")); } } var person = db.EligibleMembers.Where(dbl => dbl.email.ToLower() == usr.ToString().ToLower() && dbl.password == pw.ToString()).First(); voteLog c = new voteLog { datetime = DateTime.Now, contestantId = contestantId, VotingSessionId = VoteSessionId, memberId = person.Id }; voteLog cc = db.voteLogs.Add(c); db.SaveChanges(); ViewBag.memberId = person.Id; TempData["MessageType"] = "success"; TempData["Message"] = "Your vote was successful casted!!"; return(View()); }
public ActionResult IndexTest(int contestantId, int VoteSessionId) { var usr = Session["Username"]; var pw = Session["Password"]; var mt = Session["membershipType"]; //to make sure you have signed in. if (usr?.ToString() == null || pw?.ToString() == null) { TempData["MessageType"] = "danger"; TempData["Message"] = "Please you have to sign in first!!"; return(Redirect("/Home/IndexTest#warn")); } //vote once foreach (var voterecord in db.voteLogs) { if (voterecord.VotingSessionId == VoteSessionId && voterecord.EligibleMember.email == usr.ToString()) { TempData["MessageType"] = "danger"; TempData["Message"] = "You can only vote once!!"; return(Redirect("/Home/IndexTest#warn")); } } var person = db.EligibleMembers.Where(dbl => dbl.email == usr.ToString()).First(); voteLog c = new voteLog { datetime = DateTime.Now, contestantId = contestantId, VotingSessionId = VoteSessionId, memberId = person.Id }; voteLog cc = db.voteLogs.Add(c); db.SaveChanges(); TempData["MessageType"] = "success"; TempData["Message"] = "Your vote was successful casted!!"; return(Redirect("/Home/IndexTest#warn")); }