public ActionResult Create(ReviewModels review, int id /*int id, string content*/)
{
try
{
CommentModels comment1 = new CommentModels();
var query = db.User.Where(i => i.Email == User.Identity.Name);
UserModels user = query.Single();
comment1.Author = user;
var query2 = db.Review.Where(i => i.ID == id);
ReviewModels review2 = query2.Single();
comment1.Review = review2;
System.Diagnostics.Debug.WriteLine(review.ID);
comment1.PostDate = DateTime.Now;
comment1.Contents = Request.Form["textarea"];
if (ModelState.IsValid)
{
db.Comment.Add(comment1);
db.SaveChanges();
return(RedirectToAction("Details", "ReviewModel", new { id }));
}
return(RedirectToAction("Details", "ReviewModel", new { id }));
}
catch
{
return(View());
}
}
public ActionResult Create([Bind(Include = "ID, Title, Photo, Contents, DateOfPublication")] ReviewModels review, int BoardGame_Id)
{
System.Diagnostics.Debug.WriteLine("CREATE REVIEW");
var query = db.User.Where(i => i.Email == User.Identity.Name);
UserModels user = query.Single();
review.Author = user;
review.DateOfPublication = DateTime.Now;
var query2 = db.BoardGame.Where(i => i.ID == BoardGame_Id);
BoardGameModels game = query2.Single();
review.BoardGame = game;
System.Diagnostics.Debug.WriteLine(BoardGame_Id);
if (ModelState.IsValid)
{
db.Review.Add(review);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BoardGame_Id = new SelectList(db.BoardGame, "Id", "Title", review.BoardGame.ID);
ViewBag.Author_Id = new SelectList(db.User, "Id", "FullName", review.Author.ID);
return(View(review));
}
public ActionResult DeleteConfirmed(int id)
{
ReviewModels reviewModels = db.Reviews.Find(id);
db.Reviews.Remove(reviewModels);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "id,CustomerName,Rating,Description")] ReviewModels reviewModels)
{
if (ModelState.IsValid)
{
db.Entry(reviewModels).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(reviewModels));
}
public ActionResult Create([Bind(Include = "id,CustomerName,Rating,Description")] ReviewModels reviewModels)
{
if (ModelState.IsValid)
{
db.Reviews.Add(reviewModels);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(reviewModels));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(RedirectToAction("Index"));
}
ReviewModels game = db.Review.Find(id);
if (game == null)
{
return(HttpNotFound());
}
return(View(game));
}
// GET: ReviewModels1/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ReviewModels reviewModels = db.Reviews.Find(id);
if (reviewModels == null)
{
return(HttpNotFound());
}
return(View(reviewModels));
}
public ActionResult Edit([Bind(Include = "ID,ReviewTitle,PublishDate,ReviewText,CriticID,GameID,Rating")] ReviewModels reviewModels)
{
reviewModels.PublishDate = DateTime.Now;
if (ModelState.IsValid)
{
db.Entry(reviewModels).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CriticID = new SelectList(db.Critics, "ID", "Name", reviewModels.CriticID);
ViewBag.GameID = new SelectList(db.Games, "ID", "Title", reviewModels.GameID);
return(View(reviewModels));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ReviewModels reviewModels = db.Reviews.Find(id);
if (reviewModels == null)
{
return(HttpNotFound());
}
ViewBag.CriticID = new SelectList(db.Critics, "ID", "Name", reviewModels.CriticID);
ViewBag.GameID = new SelectList(db.Games, "ID", "Title", reviewModels.GameID);
return(View(reviewModels));
}
public ActionResult Edit(ReviewModels review)
{
try
{
if (ModelState.IsValid)
{
db.Entry(review).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(review));
}
catch
{
return(View());
}
}
public ActionResult Delete(int id)
{
ReviewModels review = db.Review.Find(id);
review.Comments.Clear();
try
{
db.Review.Remove(review);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
ViewBag.Message = String.Format("This element is coneted with other DB you cant remove it!");
return(View(review));
// return RedirectToAction("Index");
}
}
public ActionResult Create([Bind(Include = "ID,ReviewTitle,PublishDate,ReviewText,CriticID,GameID,Rating")] ReviewModels reviewModels)
{
reviewModels.PublishDate = DateTime.Now;
string userID = User.Identity.GetUserId();
var critic = db.Critics.Where(c => c.SecondName.Equals(userID));
reviewModels.CriticID = critic.FirstOrDefault().ID;
if (ModelState.IsValid)
{
db.Reviews.Add(reviewModels);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CriticID = new SelectList(db.Critics, "ID", "Name", reviewModels.CriticID);
ViewBag.GameID = new SelectList(db.Games, "ID", "Title", reviewModels.GameID);
return(View(reviewModels));
}
public ActionResult About()
{
List <ReviewModels> reviews = db.Review.ToList();
if (reviews.Count < 3)
{
return(View(reviews));
}
List <DateTime> datesOfPublication = new List <DateTime>();
System.Diagnostics.Debug.WriteLine(reviews.Count);
foreach (var item in reviews)
{
datesOfPublication.Add(item.DateOfPublication);
}
DateTime first = datesOfPublication.Max();
ReviewModels a = new ReviewModels();
foreach (var item in reviews)
{
if (item.DateOfPublication == first)
{
a = item;
}
}
reviews.Remove(a);
datesOfPublication.Clear();
System.Diagnostics.Debug.WriteLine(reviews.Count);
foreach (var item in reviews)
{
datesOfPublication.Add(item.DateOfPublication);
}
DateTime second = datesOfPublication.Max();
ReviewModels b = new ReviewModels();
foreach (var item in reviews)
{
if (item.DateOfPublication == second)
{
b = item;
}
}
reviews.Remove(b);
datesOfPublication.Clear();
foreach (var item in reviews)
{
datesOfPublication.Add(item.DateOfPublication);
}
DateTime third = datesOfPublication.Max();
ReviewModels c = new ReviewModels();
foreach (var item in reviews)
{
if (item.DateOfPublication == third)
{
c = item;
}
}
reviews.Remove(c);
List <ReviewModels> newestReview = new List <ReviewModels>();
newestReview.Add(a);
newestReview.Add(b);
newestReview.Add(c);
return(View(newestReview));
}
