public int insertReview() { ReviewDAO dao = new ReviewDAO(); int result = dao.Insert(this); return(result); }
public ActionResult Register(Review review) { try { ReviewDAO dao = new ReviewDAO(); UserDAO udao = new UserDAO(); review.Date = DateTime.Now; User u = udao.SearchById(int.Parse(Session["Id"].ToString())); review.UserId = u.Id; Review rev = dao.SearchByUserApp(review.UserId, review.ApplicationId); if (rev != null) { dao.Remove(rev); } dao.Add(review); IList <Review> revs = dao.SearchByAppId(review.ApplicationId); double totalrate = 0; foreach (var r in revs) { totalrate += r.Value; } totalrate = Math.Round(totalrate / revs.Count); ApplicationDAO appdao = new ApplicationDAO(); Application a = appdao.SearchById(review.ApplicationId); a.Value = int.Parse(totalrate.ToString()); appdao.Update(); return(RedirectToAction("Product", "Application", new { id = review.ApplicationId })); } catch { return(RedirectToAction("Index", "Home")); } }
public ActionResult YourReviews() { try { if (Session["DevId"] != null) { ApplicationDAO appdao = new ApplicationDAO(); ReviewDAO rdao = new ReviewDAO(); IList <Application> apps = appdao.GetDevGames(int.Parse(Session["DevId"].ToString())); UserDAO udao = new UserDAO(); ViewBag.User = udao.SearchById(int.Parse(Session["Id"].ToString())); //IList<Review> revs = new List<Review>(); //foreach (var a in apps) //{ // IList<Review> rev = rdao.SearchByAppId(a.Id); // foreach(var r in rev) // { // revs.Add(r); // } //} ViewBag.Apps = apps; return(View()); } return(RedirectToAction("Index", "Home")); } catch { return(RedirectToAction("Index", "Home")); } }
public List <ReviewWithUsername> SearchReviews(string title) { // create new instance of ReviewDAO ReviewDAO dataService = new ReviewDAO(); return(dataService.SearchReviews(title)); }
public PartialViewResult _ListReviewDev(int AppId) { ReviewDAO dao = new ReviewDAO(); UserDAO udao = new UserDAO(); IList <Review> list = dao.SearchByAppId(AppId); IList <User> users = new List <User>(); bool b = false; foreach (var r in list) { b = false; foreach (var u in users) { if (u.Id == r.UserId) { b = true; } } if (!b) { users.Add(udao.SearchById(r.UserId)); } } ViewBag.Revs = list; ViewBag.UserRevs = users; return(PartialView()); }
public ActionResult <Review> Post([FromBody] Review review) { int id = Convert.ToInt32(TokenModel.ReadClaimFromRequest(Request, "id")); review.IdUser = id; return(Ok(ReviewDAO.Create(review))); }
public Review GetReview(int reviewid) { // create new instance of ReviewDAO ReviewDAO dataService = new ReviewDAO(); // create GetReview method return(dataService.GetReview(reviewid)); }
public List <Review> GetReviews(int userid) { // create new instance of ReviewDAO ReviewDAO dataService = new ReviewDAO(); // return GetReviews method return(dataService.GetReviews(userid)); }
public ActionResult <IEnumerable <Review> > GetReviewsFromUser(int id) { IEnumerable <Review> reviewsByUser = ReviewDAO.GetReviewsByUser(id); return(reviewsByUser != null ? (ActionResult <IEnumerable <Review> >)Ok(reviewsByUser) : NotFound("User not found")); }
public ActionResult <IEnumerable <Review> > GetReviewByPlace(int id) { IEnumerable <Review> reviews = ReviewDAO.GetReviewByPlace(id); return(reviews != null ? (ActionResult <IEnumerable <Review> >)Ok(reviews) : NotFound("This lieu does not exists !")); }
public new ActionResult Profile() { string username = (string)Session["username"]; ViewBag.borrower = BorrowerDAO.GetBorrowerByUsername(username); ViewBag.reservations = ReservationDAO.GetReservationByUsername(username); ViewBag.reviews = ReviewDAO.GetReviewByUsername(username); ViewBag.message = ""; return(View()); }
/// <summary> /// Review Controller handles all of the views focused on reviews. This controller needs a ReviewDAO, UserDAO, and GameDAO that connect to the /// GAMEGROOVE database, as well as a logger to fill out an error log. Retrieve the parameters needed for each of the above from WebConfig. /// </summary> public ReviewController() { string connectionString = ConfigurationManager.ConnectionStrings["GameGroove"].ConnectionString; string logPath = ConfigurationManager.AppSettings["LogPath"]; _Logger = new Logger(logPath); _ReviewDataAccess = new ReviewDAO(logPath, connectionString); _UserDataAccess = new UserDAO(logPath, connectionString); _GameDataAccess = new GameDAO(logPath, connectionString); }
public IActionResult Reviewform(string studentId) { ReviewForm r = new ReviewForm(); r.studentID = HttpContext.Request.Form["id"]; r.teacherName = HttpContext.Request.Form["teacher"]; r.feedback = HttpContext.Request.Form["feedback"]; ReviewDAO.save(r); return(View()); }
public ActionResult Review(FormCollection form) { string title = form["title"]; string user = form["username"]; string isbn = form["isbn"]; int score = int.Parse(form["score"]); string content = form["content"]; bool inserted = ReviewDAO.InsertReview(title, content, DateTime.Now, isbn, user, score); ViewBag.insertReview = inserted; return(RedirectToAction("ViewBook", "ViewBook", new { isbn = isbn })); }
public IEnumerable <ReviewAndUser> GetReviewAndUserByPlace(int idPlace) { IEnumerable <Review> reviews = ReviewDAO.GetReviewByPlace(idPlace); ReviewAndUser[] reviewAndUsers = new ReviewAndUser[reviews.Count()]; int i = 0; foreach (var review in reviews) { reviewAndUsers[i] = GetReviewAndUser(review.Id); i++; } return(reviewAndUsers); }
public IEnumerable <ReviewWithPlaceAndAddress> GetReviewsWithPlaceAndAddresses(int id) { IEnumerable <Review> reviews = ReviewDAO.GetReviewsByUser(id); ReviewWithPlaceAndAddress[] reviewWithPlaceAndAddresses = new ReviewWithPlaceAndAddress[reviews.Count()]; int i = 0; foreach (var review in reviews) { reviewWithPlaceAndAddresses[i] = GetReviewWithPlaceAndAddress(review.Id); i++; } return(reviewWithPlaceAndAddresses); }
//En attendant de la résolution de la contrainte on delete cascade en bdd public bool DeleteWithCascade(int id) { if (!AddressDAO.Delete(PlaceDAO.Get(id).IdAdr)) { return(false); } if (!ReviewDAO.DeleteByPlace(id)) { return(false); } return(PlaceDAO.Delete(id)); }
// pass user model in RegisterUser method public Review CreateReview(Review review) { // create new instance of ReviewDAO ReviewDAO dataService = new ReviewDAO(); if (dataService.CreateReview(review)) { return(review); } else { return(null); } }
public bool EditReview(Review review) { // create new instance of ReviewDAO ReviewDAO dataService = new ReviewDAO(); if (dataService.UpdateReview(review)) { return(true); } else { return(false); } }
public bool DeleteReview(int reviewId) { // create new instance of ReviewDAO ReviewDAO dataService = new ReviewDAO(); if (dataService.DeleteReview(reviewId)) { return(true); } else { return(false); } }
public ActionResult <Review> Update([FromBody] Review review) { return(ReviewDAO.Update(review) ? (ActionResult <Review>)Ok() : NotFound()); }
public ActionResult Delete(int id) { return(ReviewDAO.Delete(id) ? (ActionResult)Ok() : NotFound()); }
public ActionResult <IEnumerable <Review> > Query() { return(Ok(ReviewDAO.Query())); }
public IEnumerable <Review> GetList(ushort id) { return(ReviewDAO.GetList(id)); }
public ReviewBLL() { SqlConnectBLL common = new SqlConnectBLL(); dao = new ReviewDAO(common.host, common.port, common.database, common.username, common.password); }
public void Insert(uint id, string name, string review, float rating) { ReviewDAO.Insert(id, name, review, rating); }
public ReviewWithPlaceAndAddress GetReviewWithPlaceAndAddress(int id) { Review review = ReviewDAO.Get(id); return(new ReviewWithPlaceAndAddress(review, PlaceService.GetPlaceAndAddress(review.IdPlace))); }
public Review getReviews() { ReviewDAO dao = new ReviewDAO(); return(dao.RetrieveReviews()); }
public ReviewAndUser GetReviewAndUser(int idReview) { Review review = ReviewDAO.Get(idReview); return(new ReviewAndUser(review, UserDAO.Get(review.IdUser))); }