protected void GetPermissions_Click(object sender, EventArgs e) { bool isAdmin = User.IsInRole("Admin"); if (this.Page.User.Identity != null && this.Page.User.Identity.IsAuthenticated && isAdmin) { AspNetToken token = GenerateAdminToken(LastingOfAuth); ConquistadorEntities context = new ConquistadorEntities(); context.AspNetTokens.Add(token); Session.Add("AdminTokenId", token.Id); try { context.SaveChanges(); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } ErrorSuccessNotifier.AddInfoMessage(string.Format("You have full permisions for this section in the next {0} minutes.", LastingOfAuth)); } else { ErrorSuccessNotifier.AddWarningMessage("You don't have full permishions."); } }
protected void EditAnswer_Command(object sender, CommandEventArgs e) { var context = new ConquistadorEntities(); question = context.Questions.Find(questionId); if (answerId == 0) { isNewAnswer = true; answer = new Answer(); answer.QuestionId = question.Id; context.Answers.Add(answer); } if (!isNewAnswer) { answer = context.Answers.Find(answerId); } try { answer.ContentText = this.TextBoxEdit.Text; context.SaveChanges(); Response.Redirect("EditQuestions.aspx", false); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex.Message); return; } }
protected void ButtonJoker25_Click(object sender, EventArgs e) { string userName = this.Page.User.Identity.Name; ConquistadorEntities db = new ConquistadorEntities(); var currentUser = db.AspNetUsers.FirstOrDefault(u => u.UserName == userName); db.AspNetUsers.Attach(currentUser); if (currentUser.Bonus >= JokerBonus) { currentUser.Bonus -= JokerBonus; while (true) { int random = rand.Next(0, 4); int answerId = Convert.ToInt32(this.RadioButtonListAnswers.Items[random].Value); Answer answer = db.Answers.FirstOrDefault(a => a.Id == answerId); if (answer.IsCorrect != true) { RadioButtonListAnswers.Items[random].Text = ""; this.ButtonJoker25.Visible = false; this.ButtonJoker50.Visible = false; break; } } this.LiteralBonus.Text = currentUser.Bonus.ToString(); db.SaveChanges(); } else { Error_Handler_Control.ErrorSuccessNotifier.AddInfoMessage("No enought bonus points!"); } }
protected void Delete_Command(object sender, CommandEventArgs e) { var context = new ConquistadorEntities(); int answerId = Convert.ToInt32(e.CommandArgument); var answer = context.Answers.Find(answerId); context.Answers.Remove(answer); context.SaveChanges(); }
protected void Delete_Command(object sender, CommandEventArgs e) { var context = new ConquistadorEntities(); var questionId = Convert.ToInt32(e.CommandArgument); Question question = context.Questions.Include("Answers").FirstOrDefault(x => questionId == x.Id); context.Answers.RemoveRange(question.Answers); context.Questions.Remove(question); context.SaveChanges(); }
protected void Delete_Command(object sender, CommandEventArgs e) { var context = new ConquistadorEntities(); try { int answerId = Convert.ToInt32(e.CommandArgument); var answer = context.Answers.Find(answerId); context.Answers.Remove(answer); context.SaveChanges(); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex.Message); } }
// The id parameter name should match the DataKeyNames value set on the control public void GridViewEditUsers_DeleteItem(string id) { ConquistadorEntities context = new ConquistadorEntities(); var user = context.AspNetUsers.Find(id); context.AspNetUsers.Remove(user); try { context.SaveChanges(); ErrorSuccessNotifier.AddInfoMessage("User is deleted"); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } }
protected void ButtonSubmit_Click(object sender, EventArgs e) { string questionText = this.TextBoxQuestion.Text; //validate q if (string.IsNullOrEmpty(questionText)) { ErrorSuccessNotifier.AddErrorMessage("The question field cannot be empty!"); return; } List<Answer> answers = new List<Answer>(); answers.Add(new Answer() { ContentText = this.TextBoxAnswer1.Text }); answers.Add(new Answer() { ContentText = this.TextBoxAnswer2.Text }); answers.Add(new Answer() { ContentText = this.TextBoxAnswer3.Text }); answers.Add(new Answer() { ContentText = this.TextBoxAnswer4.Text }); //validate answers int correctAnswerIndex = int.Parse(this.DropDownCorrectAnswer.SelectedValue) - 1; for (int i = 0; i < answers.Count; i++) { if (string.IsNullOrEmpty(answers[i].ContentText)) { ErrorSuccessNotifier.AddErrorMessage("An answer field cannot be empty."); return; } if (i == correctAnswerIndex) { answers[i].IsCorrect = true; break; } } ConquistadorEntities context = new ConquistadorEntities(); try { Question created = new Question() { TextContent = questionText, Answers = answers, IsApproved = true }; context.Questions.Add(created); context.SaveChanges(); ErrorSuccessNotifier.AddSuccessMessage("Question was added."); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex.Message); } }
// The id parameter name should match the DataKeyNames value set on the control public void GridViewEditUsers_UpdateItem(string id) { ConquistadorEntities context = new ConquistadorEntities(); var product = context.AspNetUsers.Find(id); TryUpdateModel(product); if (ModelState.IsValid) { try { context.SaveChanges(); ErrorSuccessNotifier.AddInfoMessage("User is edited"); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } } }
// The id parameter name should match the DataKeyNames value set on the control public void ListViewUserRole_DeleteItem(string id) { ConquistadorEntities context = new ConquistadorEntities(); var userName = this.Request.Params["userName"]; var user = context.AspNetUsers.Include("AspNetRoles").FirstOrDefault(u => u.UserName == userName); var role = user.AspNetRoles.FirstOrDefault( r=> r.Id == id); user.AspNetRoles.Remove(role); try { context.SaveChanges(); ErrorSuccessNotifier.AddSuccessMessage("Role succssesfuly removed."); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } }
// not in use public void ListViewUserRole_UpdateItem(string id) { ConquistadorEntities context = new ConquistadorEntities(); var userName = this.Request.Params["userName"]; var user = context.AspNetUsers.Include("AspNetRoles").FirstOrDefault(u => u.UserName == userName); var role = user.AspNetRoles.FirstOrDefault(r => r.Id == id); user.AspNetRoles.Remove(role); var roleNew = context.AspNetRoles.FirstOrDefault(r => r.Name == role.Name && r.Id != role.Id); roleNew.AspNetUsers.Add(user); try { context.SaveChanges(); ErrorSuccessNotifier.AddInfoMessage("ToDoList is edited"); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } }
protected void Save_Command(object sender, CommandEventArgs e) { var context = new ConquistadorEntities(); int questionId = Convert.ToInt32(Request.Params["id"]); if (questionId == 0) { isNewQuestion = true; } if (!isNewQuestion) { question = context.Questions.Find(questionId); } else { question = new Question(); context.Questions.Add(question); } question.TextContent = this.TextBoxEdit.Text; question.IsApproved = this.CheckBoxApproved.Checked; try { context.SaveChanges(); Response.Redirect("EditQuestions.aspx", false); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex.Message); return; } }
protected void UploadButton_Click(object sender, EventArgs e) { if (this.FileUploadPic.HasFile) { try { if (FileUploadPic.PostedFile.ContentType == "image/jpeg") { //save to server string file = Path.GetFileName(FileUploadPic.FileName); string path = Server.MapPath("~/Uploaded_Files/") + file; FileUploadPic.SaveAs(path); //save to db var userId = User.Identity.GetUserId(); ConquistadorEntities context = new ConquistadorEntities(); var user = context.AspNetUsers.Find(userId); user.ImagePath = "~/Uploaded_Files/" + file; context.SaveChanges(); Error_Handler_Control.ErrorSuccessNotifier.AddSuccessMessage("Upload status: File uploaded!"); } else { Error_Handler_Control.ErrorSuccessNotifier.AddWarningMessage("Allowed file types: image/jpeg!"); } } catch (Exception ex) { Error_Handler_Control.ErrorSuccessNotifier.AddErrorMessage(ex.Message); } } }
protected void AddRole_Click(object sender, EventArgs e) { ConquistadorEntities context = new ConquistadorEntities(); var roleId = this.DDLRoles.SelectedValue; var role = context.AspNetRoles.FirstOrDefault(r => r.Id == roleId); if (role == null) { ErrorSuccessNotifier.AddErrorMessage("Invalid role."); return; } var userName = this.Request.Params["userName"]; var user = context.AspNetUsers.Include("AspNetRoles").FirstOrDefault( u => u.UserName == userName); if (user == null) { ErrorSuccessNotifier.AddErrorMessage("Can not find user."); return; } var roles = user.AspNetRoles; if (roles != null) { } var conatinRole = user.AspNetRoles.FirstOrDefault(r => r.Id == roleId); if (conatinRole != null) { ErrorSuccessNotifier.AddErrorMessage("User is already in this role."); return; } user.AspNetRoles.Add(role); try { context.SaveChanges(); ErrorSuccessNotifier.AddSuccessMessage("Role succssesfuly added."); } catch (Exception ex) { ErrorSuccessNotifier.AddErrorMessage(ex); } }
//public IQueryable <Answer> RadioButtonListAnswers_GetData( int questionId) //{ // ConquistadorEntities db = new ConquistadorEntities(); // IQueryable<Answer> answers = db.Answers.Where(a => a.QuestionId == questionId); // IQueryable<Answer> randomisedAnsvers = answers.OrderBy(a => Guid.NewGuid()).Take(4); // bool containsRightAnswer = randomisedAnsvers.FirstOrDefault(a => a.IsCorrect == true) == null; // while (containsRightAnswer) // { // randomisedAnsvers = answers.OrderBy(a => Guid.NewGuid()).Take(4); // containsRightAnswer = randomisedAnsvers.FirstOrDefault(a => a.IsCorrect == true) == null; // } // return randomisedAnsvers; //} protected void ButtonSubmit_Click(object sender, EventArgs e) { if (this.RadioButtonListAnswers.SelectedValue != null && !string.IsNullOrWhiteSpace(this.RadioButtonListAnswers.SelectedValue)) { int answerId = Convert.ToInt32(this.RadioButtonListAnswers.SelectedValue); using (ConquistadorEntities db = new ConquistadorEntities()) { Answer answer = db.Answers.FirstOrDefault(a => a.Id == answerId); if (answer.IsCorrect == true) { // answer correct //this.LiteralAnswer.Text = "Aswer Correct!"; Error_Handler_Control.ErrorSuccessNotifier.AddSuccessMessage("Aswer Correct!"); string userName = this.Page.User.Identity.Name; var currentUser = db.AspNetUsers.FirstOrDefault(u => u.UserName == userName); currentUser.Score += QuestionScore; currentUser.Bonus += AnswerBonus; db.SaveChanges(); this.LiteralBonus.Text = currentUser.Bonus.ToString(); this.LiteralScore.Text = currentUser.Score.ToString(); } else { //// answer incorrect Error_Handler_Control.ErrorSuccessNotifier.AddErrorMessage("Aswer Incorrect!"); for (int i = 0; i < 4; i++) { int ansId = Convert.ToInt32(this.RadioButtonListAnswers.Items[i].Value); Answer currAnswer = db.Answers.FirstOrDefault(a => a.Id == ansId); if (currAnswer.IsCorrect == true) { this.LiteralAnswer.Text = "Correct answer is: " + this.RadioButtonListAnswers.Items[i].Text; break; } } } } this.RadioButtonListAnswers.Visible = false; this.ButtonSubmit.Visible = false; this.ButtonNextQuestion.Visible = true; this.ButtonJoker25.Visible = false; this.ButtonJoker50.Visible = false; } }