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)));
}
