public async Task <ActionResult> Edit(FrequentlyAskedQuestionEditModel model) { if (!ModelState.IsValid) { return(View(model)); } FrequentlyAskedQuestion faq = await _context.FrequentlyAskedQuestions.SingleOrDefaultAsync(i => i.Id == model.Id); if (faq == null) { return(RedirectToAction <FrequentlyAskedQuestionsController>(c => c.Index()) .WithError("Could not load the Frequently Asked Question")); } faq.Question = model.Question; faq.Answer = model.Answer; faq.Order = model.Order; await _context.SaveChangesAsync(); return(RedirectToAction <FrequentlyAskedQuestionsController>(c => c.Index()) .WithSuccess("Frequently Asked Question Edited.")); }
public IActionResult Post([FromBody] FrequentlyAskedQuestion value) { if (!TryValidateModel(value)) { return(StatusCode(500)); } _context.FrequentlyAskedQuestions.Add(value); _context.SaveChanges(); if (value.ResourceLink != null) { var resourceLink = _context.ResourceLinks.FirstOrDefault(x => x.DisplayName.Equals(value.ResourceLink.DisplayName) && x.Link.Equals(value.ResourceLink.Link)); if (resourceLink == null) { _context.ResourceLinks.Add(new ResourceLink() { DisplayName = value.ResourceLink.DisplayName, Link = value.ResourceLink.DisplayName }); _context.SaveChanges(); resourceLink = _context.ResourceLinks.First(x => x.DisplayName.Equals(value.ResourceLink.DisplayName) && x.Link.Equals(value.ResourceLink.Link));; } value.ResourceLinkId = resourceLink.Id; } return(Created(Url.Action("Get", new { id = value.Id }), value)); }
public void AddUsefulnessScore(QuestionAnswerUserReview review) { FrequentlyAskedQuestion faq = _ctx.FrequentlyAskedQuestions.Find(review.FrequentlyAskedQuestion_Id); // Update existing user usefulness review. if (faq != null) { ICollection <QuestionAnswerUserReview> reviews = faq.UserReviews; var existingReviews = reviews.Where(e => e.User_Id == review.User_Id && e.FrequentlyAskedQuestion_Id == review.FrequentlyAskedQuestion_Id); QuestionAnswerUserReview existingReview = existingReviews.FirstOrDefault(); if (existingReview == null) { // No existing Review. Add new review. faq.UserReviews.Add(review); faq.TotalUserReviewScore += review.UserReviewScore; } else { // Existing review. Update review. faq.UserReviews.Remove(existingReview); faq.TotalUserReviewScore += -existingReview.UserReviewScore; faq.UserReviews.Add(review); faq.TotalUserReviewScore += review.UserReviewScore; } _ctx.SaveChanges(); } }
public async Task OnInit() { FAQs = await _frequentlyAskedQuestionService.GetAll(); NewOrEditFAQ = new FrequentlyAskedQuestion() { Active = true }; }
/// <summary> /// /// </summary> /// <param name="questionId"></param> /// <returns></returns> public void IncrementViewCount(int questionId) { FrequentlyAskedQuestion faq = _ctx.FrequentlyAskedQuestions.Find(questionId); if (faq != null) { faq.ViewCount++; _ctx.SaveChanges(); } }
public async Task <ActionResult> DeleteConfirmed(int id) { FrequentlyAskedQuestion frequentlyAskedQuestion = await _context.FrequentlyAskedQuestions.FindAsync(id); _context.FrequentlyAskedQuestions.Remove(frequentlyAskedQuestion); await _context.SaveChangesAsync(); return(RedirectToAction <FrequentlyAskedQuestionsController>(c => c.Index()) .WithSuccess("Frequently Asked Question Deleted.")); }
public async Task <IActionResult> PostFrequentlyAskedQuestion([FromBody] FrequentlyAskedQuestion frequentlyAskedQuestion) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _context.FrequentlyAskedQuestion.Add(frequentlyAskedQuestion); await _context.SaveChangesAsync(); return(CreatedAtAction("GetFrequentlyAskedQuestion", new { id = frequentlyAskedQuestion.FrequentlyAskedQuestionId }, frequentlyAskedQuestion)); }
//GET: This function is used to fetch the data that will be displayed in the update FAQ view. public ActionResult UpdateFAQAdmin(int id) { Debug.WriteLine("Entering Update FAQ"); Debug.WriteLine("Fetching data to be displayed in the update FAQ page"); //Query to get the FAQ Details with specific FAQ id. string query = "select * from FrequentlyAskedQuestions where id = @id"; FrequentlyAskedQuestion FAQ = db.FrequentlyAskedQuestions.SqlQuery(query, new SqlParameter("@id", id)).FirstOrDefault(); //Calling the FAQ view with the Specific FAQ details return(View(FAQ)); }
public IActionResult Put(int id, [FromBody] FrequentlyAskedQuestion value) { var ticket = _context.Tickets.FirstOrDefault(x => x.Id == id); if (ticket == null) { return(NotFound(value)); } ticket.Description = value.Description; _context.SaveChanges(); return(Ok(ticket)); }
public IActionResult Put(int id, [FromBody] FrequentlyAskedQuestion value) { var faq = _context.FrequentlyAskedQuestions.FirstOrDefault(x => x.Id == id); if (faq == null) { return(NotFound()); } faq.Answer = value.Answer; faq.Description = value.Description; faq.Question = value.Question; _context.SaveChanges(); return(Ok(faq)); }
public async Task Save() { if (DialogId == default) { NewOrEditFAQ.Id = Guid.NewGuid(); await _frequentlyAskedQuestionService.Create(NewOrEditFAQ); } else { await _frequentlyAskedQuestionService.Update(NewOrEditFAQ); } FAQs = await _frequentlyAskedQuestionService.GetAll(); NewOrEditFAQ = new FrequentlyAskedQuestion(); EditModalOpen = false; }
public async Task <ActionResult> Create(FrequentlyAskedQuestionCreateModel model) { if (!ModelState.IsValid) { return(View(model)); } var frequentlyAskedQuestion = new FrequentlyAskedQuestion { Order = model.Order, Question = model.Question, Answer = model.Answer }; _context.FrequentlyAskedQuestions.Add(frequentlyAskedQuestion); await _context.SaveChangesAsync(); return(RedirectToAction <FrequentlyAskedQuestionsController>(c => c.Index()) .WithSuccess("Frequently Asked Question Created.")); }
public async Task <IActionResult> PutFrequentlyAskedQuestion([FromRoute] Guid id, [FromBody] FrequentlyAskedQuestion frequentlyAskedQuestion) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != frequentlyAskedQuestion.FrequentlyAskedQuestionId) { return(BadRequest()); } _context.Entry(frequentlyAskedQuestion).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!FrequentlyAskedQuestionExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task Cancel() { NewOrEditFAQ = new FrequentlyAskedQuestion(); EditModalOpen = false; }
public async Task Edit(FrequentlyAskedQuestion faq) { DialogId = faq.Id; NewOrEditFAQ = faq; EditModalOpen = true; }
public Task Update(FrequentlyAskedQuestion frequentlyAskedQuestion) { return(_proxy.Update(frequentlyAskedQuestion)); }