public List <MovieReviews> GetAllReviewsOfMovie(int movieId)
{
List <MovieReviews> movieReviews = new List <MovieReviews>();
string query = "SELECT * FROM review WHERE mid = @movieId";
connection.Open();
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.Parameters.AddWithValue("@movieId", movieId);
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
MovieReviews movieReview = new MovieReviews
{
Id = (int)dataReader["id"],
MovieId = (int)dataReader["mid"],
UserName = dataReader["uname"].ToString(),
Review = dataReader["review"].ToString()
};
movieReviews.Add(movieReview);
}
dataReader.Close();
connection.Close();
return(movieReviews);
}
public static MovieReviews ParseMovieReviews(string json)
{
JObject jObject = JObject.Parse(json);
MovieReviews results = new MovieReviews();
int resultCount = 0;
int.TryParse(jObject["total"].ToString(), out resultCount);
results.ResultCount = resultCount;
var reviews = (JArray)jObject["reviews"];
foreach (var review in reviews)
{
Review result = new Review();
result.Critic = (string)review["critic"];
result.Date = (string)review["date"];
result.Publication = (string)review["publication"];
result.Quote = (string)review["quote"];
var links = (JObject)review["links"];
foreach (var link in links)
{
Link newLink = new Link();
newLink.Type = (string)link.Key;
newLink.Url = (string)link.Value;
result.Links.Add(newLink);
}
results.Reviews.Add(result);
}
return(results);
}
public ActionResult Edit(MovieReviews review)
{
if (ModelState.IsValid)
{
_db.Entry(review).State = EntityState.Modified;
_db.SaveChanges();
return(RedirectToAction("Index", new { id = review.MovieId }));
}
return(View());
}
public ActionResult Create(MovieReviews _review)
{
if (ModelState.IsValid)
{
_db.MovieReviews.Add(_review);
_db.SaveChanges();
return(RedirectToAction("Index", new { id = _review.MovieId }));
}
return(View(_review));
}
public ActionResult Create(MovieReviews mr)//the parameter is the collection of data created by user
{
try
{
// TODO: Add insert logic here
_movieReviews.Add(mr);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public void Copy(MovieReviews movieReviews)
{
foreach (var movieItem in movieReviews.Reviews.Select(review => new MovieReviewItem(
review.Critic,
review.Date,
review.Freshness,
review.Publication,
review.Quote,
review.Link.Review)))
{
this._items.Add(movieItem);
}
}
public ActionResult Delete(int id, MovieReviews deletedMovieReviews)
{
try
{
// TODO: Add delete logic here
var MovieReviewToBeDeleted = _movieReviews.Find(s => s.Id == id);
_movieReviews.Remove(MovieReviewToBeDeleted);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public MovieReviews[] getReviewsForMovieID(int movieID)
{
int i = 1;
int total_pages = 0;
List <MovieReviews> movieReviewList = new List <MovieReviews>();
do
{
MovieReviews npr = GetReviewsForMovieByPage(movieID, i);
total_pages = npr.total_pages;
movieReviewList.Add(npr);
i++;
} while (i <= total_pages);
return(movieReviewList.ToArray());
}
public ActionResult Edit(int id, MovieReviews updatedMovieReview)
{
try
{
// TODO: Add update logic here
//var movieReviewToBeUpdated = (from MovieReviews in_movieReviews
// where MovieReviews.Id==id
// select movieReview).Single();//OR
var movieReviewObj = _movieReviews.Where(obj => obj.Id == id).FirstOrDefault();
movieReviewObj.MovieName = updatedMovieReview.MovieName;
movieReviewObj.ReviewerName = updatedMovieReview.ReviewerName;
movieReviewObj.ReviewerComments = updatedMovieReview.ReviewerComments;
movieReviewObj.ReviewerRatings = updatedMovieReview.ReviewerRatings;
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public bool AddReview(MovieReviews movieReview)
{
string query = "INSERT INTO review(mid,uname,review) values(@mid,@uname,@review)";
connection.Open();
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.Parameters.AddWithValue("@mid", movieReview.MovieId);
cmd.Parameters.AddWithValue("@uname", movieReview.UserName);
cmd.Parameters.AddWithValue("@review", movieReview.Review);
int result = cmd.ExecuteNonQuery();
connection.Close();
if (result == 0)
{
return(false);
}
else
{
return(true);
}
}
public bool AddMovieReview(MovieReviews movieReview)
{
return(reviewTableAccess.AddReview(movieReview));
}
public bool AddMovieReview(MovieReviews movieReview)
{
IReviewInterFace movieBusinessService = new ReviewBusinessService();
return(movieBusinessService.AddMovieReview(movieReview));
}
