public List <GameReview> GetAllGameReviewByUserId(int id)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("Select * From [dbo].[GameReview], [dbo].[Game] WHERE GameReview.userId = @id AND GameReview.GameId = Game.id", connection);
connection.Open();
cmd.Parameters.AddWithValue("id", id);
var reader = cmd.ExecuteReader();
List <GameReview> gameReviews = new List <GameReview>();
while (reader.Read())
{
GameReview gr = new GameReview()
{
ReviewId = reader.GetInt32(0),
Thoughts = reader.GetString(1),
Score = reader.GetInt32(2),
Game = new Game()
{
ItemID = reader.GetInt32(3),
ItemName = reader.GetString(6),
Picture = reader.GetString(7),
Genre = reader.GetString(8),
PlayedTime = reader.GetInt32(9)
}
};
gameReviews.Add(gr);
}
return(gameReviews);
};
}
public void Setup()
{
m_EntityOne = new GameReview
{
Id = Guid.Parse("10000000-0000-0000-0000-000000000000"),
Title = "Title 1",
Description = "Description 1",
Rating = 1
};
m_EntityTwo = new GameReview
{
Id = Guid.Parse("20000000-0000-0000-0000-000000000000"),
Title = "Title 2",
Description = "Description 2",
Rating = 2
};
m_Entities = new[]
{
m_EntityOne,
m_EntityTwo
}.AsQueryable();
var mocker = new NSubstituteAutoMocker <InformationFinder>();
m_Command = mocker.Get <ICommandGamesReviewsRepository>();
m_Query = mocker.Get <IQueryGamesReviewsRepository>();
m_Sut = mocker.ClassUnderTest;
}
public async Task <IActionResult> Edit(int id, [Bind("GameID,ApplicationUserID,Star,Review,IsVerify")] GameReview gameReview)
{
if (id != gameReview.GameID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(gameReview);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!GameReviewExists(gameReview.GameID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["ApplicationUserID"] = new SelectList(_context.ApplicationUsers, "Id", "Id", gameReview.ApplicationUserID);
ViewData["GameID"] = new SelectList(_context.Games, "ID", "ID", gameReview.GameID);
return(View(gameReview));
}
public GameReview Map(GameReviewDb gameReview)
{
GameReview gameReview_newType = new GameReview();
#region Transfer main attributes
gameReview_newType.Id = gameReview.Id;
gameReview_newType.Content = gameReview.Content;
gameReview_newType.CreateDate = gameReview.CreateDate;
gameReview_newType.Rating = gameReview.Rating;
#endregion
#region Transfering interop attributes
gameReview_newType.Reviewer = new User()
{
Id = gameReview.IdReviewer
};
gameReview_newType.Game = new Game()
{
Id = gameReview.IdGame
};
#endregion
return(gameReview_newType);
}
// GET: GameReview/Create
public ActionResult Create(int?gameId, int?userId)
{
if (!gameId.HasValue || !userId.HasValue)
{
//either value is null
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (!db.Game.Any(g => g.id == gameId) || !db.Member.Any(u => u.id == userId))
{
//either id does not exist
return(HttpNotFound());
}
if (db.GameReview.Any(gr => gr.gameId == gameId && gr.userId == userId))
{
//review for this game by this user exists
GameReview gameReview = db.GameReview.FirstOrDefault(gr => gr.gameId == gameId && gr.userId == userId);
return(RedirectToAction("Edit", new { id = gameReview.id }));
}
GameReview r = db.GameReview.ToList().LastOrDefault();
GameReview review = new GameReview()
{
id = r.id + 1,
gameId = gameId.Value,
userId = userId.Value,
Game = db.Game.Find(gameId)
};
return(View(review));
}
public void GameReviewTestConstructorTest()
{
var gameReview = new GameReview();
Assert.AreEqual(gameReview.Id, 0);
Assert.AreEqual(gameReview.GameId, 0);
Assert.AreEqual(gameReview.ReviewId, 0);
}
public ActionResult DeleteConfirmed(int id)
{
GameReview gameReview = db.GameReview.Find(id);
db.GameReview.Remove(gameReview);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void GameReviewGenerateExistsQueryTest()
{
var gameReview = new GameReview(
1,
2,
3);
Assert.AreEqual(gameReview.GenerateExistsQuery(), "SELECT Id FROM GameReview WHERE Id = 1");
}
public void GameReviewGenerateUpdateStatementTest()
{
var gameReview = new GameReview(
1,
2,
3);
Assert.AreEqual(gameReview.GenerateUpdateStatement(), "UPDATE GameReview SET GameId = 2, ReviewId = 3 WHERE Id = 1");
}
public void GameReviewGenerateInsertStatementTest()
{
var gameReview = new GameReview(
1,
2,
3);
Assert.AreEqual(gameReview.GenerateInsertStatement(), "INSERT INTO GameReview (GameId, ReviewId) VALUES (2, 3)");
}
public void GameReviewGenerateDeleteStatementTest()
{
var gameReview = new GameReview(
1,
2,
3);
Assert.AreEqual(gameReview.GenerateDeleteStatement(), "DELETE FROM GameReview WHERE Id = 1");
}
public ActionResult Edit([Bind(Include = "id,gameId,userId,rating,details")] GameReview gameReview)
{
if (ModelState.IsValid)
{
db.Entry(gameReview).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(gameReview));
}
public ActionResult Create([Bind(Include = "id,gameId,userId,rating,details")] GameReview gameReview)
{
if (ModelState.IsValid)
{
db.GameReview.Add(gameReview);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(gameReview));
}
public void Setup()
{
memberGuid = new Guid("2A384A50-E02A-43C9-AEB8-974DF0D32C38");
gameProductGuid = new Guid("12803115-7E2B-4E34-A492-C388DD37E6AF");
pendinGameReview = new GameReview()
{
MemberId = memberGuid,
ProductReviewedId = gameProductGuid,
ReviewStatus = ReviewStatus.Pending
};
approvedGameReview = new GameReview()
{
MemberId = memberGuid,
ProductReviewedId = gameProductGuid,
ReviewStatus = ReviewStatus.Approved
};
deniedGameReview = new GameReview()
{
MemberId = memberGuid,
ProductReviewedId = gameProductGuid,
ReviewStatus = ReviewStatus.Denied
};
physicalGameProduct = new PhysicalGameProduct
{
Reviews = new List<GameReview>()
{
approvedGameReview
}
};
game = new Game()
{
GameSKUs = new List<GameProduct> {physicalGameProduct},
};
memberId = new Guid("DB6EF48B-839E-4A54-AFA2-B772738D01DB");
ratingOnlyReview = new GameReview
{
ProductReviewed = physicalGameProduct,
Rating = 5
};
fullReview = new GameReview
{
ProductReviewed = physicalGameProduct,
Rating = 4,
ReviewText = "Test"
};
}
private IGameReview ToGameReview(IGameReviewModel model)
{
IGameReview instance = new GameReview
{
Id = model.Id,
Title = model.Title,
Description = model.Description,
Rating = model.Rating
};
return(instance);
}
public GameReview Get(long id)
{
GameReviewDb gameReview = gameReviewDAO.GetExtended(id);
GameReview gameReview_newTyped = null;
if (gameReview != null)
{
gameReview_newTyped = mapper.Map(gameReview);
}
return(gameReview_newTyped);
}
public void GameReviewGeneratePrimaryKeyWhereClauseTest()
{
var gameReview = new GameReview();
Assert.AreEqual(gameReview.GeneratePrimaryKeyWhereClause(), "");
gameReview = new GameReview(
1,
2,
3);
Assert.AreEqual(gameReview.GeneratePrimaryKeyWhereClause(), "Id = 1");
}
public void GameReviewGenerateSelectQueryTest()
{
var gameReview = new GameReview();
Assert.AreEqual(gameReview.GenerateSelectQuery(), "SELECT Id, GameId, ReviewId FROM GameReview");
gameReview = new GameReview(
1,
2,
3);
Assert.AreEqual(gameReview.GenerateSelectQuery(), "SELECT Id, GameId, ReviewId FROM GameReview WHERE Id = 1");
}
public static GameReviewApprovalModel GameReviewToGameReviewApprovalModel(this GameReview review, string reviewerName, string gameTitle)
{
return(new GameReviewApprovalModel
{
Id = review.Id,
CreatedBy = reviewerName,
GameName = gameTitle,
ReviewText = review.ReviewText,
CreatedOn = review.CreatedOn,
EditedOn = review.EditedOn,
Approved = review.Approved
});
}
// GET: GameReview/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
GameReview gameReview = db.GameReview.Find(id);
if (gameReview == null)
{
return(HttpNotFound());
}
return(View(gameReview));
}
public void GameReviewXmlCloneTest()
{
var gameReview1 = new GameReview(
1,
2,
3);
var gameReview2 = CloneUtility.XmlClone(gameReview1, null);
Assert.AreNotSame(gameReview1, gameReview2);
Assert.AreEqual(gameReview1.Id, gameReview2.Id);
Assert.AreEqual(gameReview1.GameId, gameReview2.GameId);
Assert.AreEqual(gameReview1.ReviewId, gameReview2.ReviewId);
}
public async Task <IActionResult> OnGetAsync(Guid?id)
{
if (id == null)
{
return(NotFound());
}
GameReview = await _context.GameReviews.FirstOrDefaultAsync(m => m.Id == id);
if (GameReview == null)
{
return(NotFound());
}
return(Page());
}
/// <summary>
/// Submits the review comments for game
/// </summary>
public void RateGame()
{
GameReview review = new GameReview()
{
GameId = this.Game.Id,
ReviewComments = this.ReviewComments,
GameRatingId = this.SelectedGameRating.Id
};
this._gameService.PostReview(review);
// close the pop up and load game list view
TryClose();
LoadGameList();
}
public GameReview PostGameReview(GameReview review)
{
// validate game identifier
var game = _context.Games.First(g => g.Id == review.GameId);
if (game == null)
{
return(null);
}
_context.GameReviews.Add(review);
_context.SaveChanges();
return(review);
}
public IEnumerable <GameReview> GetAll()
{
List <GameReviewDb> gameReviews = (List <GameReviewDb>)gameReviewDAO.GetAll();
List <GameReview> gameReviews_newType = new List <GameReview>();
foreach (GameReviewDb gameReview in gameReviews)
{
GameReview gameReview_newType = mapper.Map(gameReview);
gameReviews_newType.Add(gameReview_newType);
}
return(gameReviews_newType);
}
//metoda dodająca ocene do gry
public async Task <ResultDto <BaseDto> > AddReview(ReviewModel reviewModel)
{
var result = new ResultDto <BaseDto>()
{
Error = null
};
//sprawdzam czy gra istnieje
var gameExists = await _repo.Exists(x => x.Id == reviewModel.EntityId);
if (!gameExists)
{
result.Error = "Nie odnaleziono gry";
return(result);
}
//sprawdzam czy ten użytkownik już dodał recenzje do wybranej gry
var oldReview = await _reviewRepo.GetSingleEntity(x => x.GameId == reviewModel.EntityId &&
x.UserId == reviewModel.UserId);
//jeśli recenzja już jest, zmieniam jej wartość na nową, w przeciwnym wypadku tworze nowa recenzje
if (oldReview != null)
{
if (oldReview.Rating != reviewModel.Rating)
{
oldReview.Rating = reviewModel.Rating;
_reviewRepo.Update(oldReview);
}
}
else
{
var review = new GameReview()
{
UserId = reviewModel.UserId,
GameId = reviewModel.EntityId,
Rating = reviewModel.Rating
};
_reviewRepo.Add(review);
}
//po dodaniu/zmianie recenzji przeliczam średnia ocen dla danej gry
if (reviewModel.EntityId != 0)
{
RecalculateGameReview(reviewModel.EntityId);
}
return(result);
}
public void GameReviewPropertiesTest()
{
var gameReview = new GameReview();
Assert.AreEqual(gameReview.Id, 0);
gameReview.Id = 1;
Assert.AreEqual(gameReview.Id, 1);
Assert.AreEqual(gameReview.GameId, 0);
gameReview.GameId = 2;
Assert.AreEqual(gameReview.GameId, 2);
Assert.AreEqual(gameReview.ReviewId, 0);
gameReview.ReviewId = 3;
Assert.AreEqual(gameReview.ReviewId, 3);
}
public void CreateGameReview(string thoughts, int score, int gameId, int userId)
{
GameReview gr = new GameReview
{
Thoughts = thoughts,
Score = score
};
Game g = new Game
{
ItemID = gameId
};
gr.Game = g;
rda.CreateGameReview(gr, userId);
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
GameReview = await _context.GameReviews.FindAsync(id);
if (GameReview != null)
{
_context.GameReviews.Remove(GameReview);
await _context.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
public JsonResult DeleteReview(GameReview review)
{
CVGSAppEntities db = new CVGSAppEntities();
try
{
var memberId = User.Identity.GetUserId();
var savedReview = db.GameReviews.FirstOrDefault(r => r.Id == review.Id);
db.GameReviews.Remove(savedReview);
db.SaveChanges();
return(Json(new { Success = true }, JsonRequestBehavior.AllowGet));
}
catch
{
return(Json(new { Success = false, Error = "Error occurred while deleting review" }, JsonRequestBehavior.AllowGet));
}
}
public void CreateGameReview(GameReview gr, int userId)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
using (SqlCommand cmd = connection.CreateCommand())
{
cmd.CommandText = "Insert Into [dbo].[GameReview](thoughts, score, gameId, userId) values(@thoughts, @score, @gameId, @userId)";
cmd.Parameters.AddWithValue("thoughts", gr.Thoughts);
cmd.Parameters.AddWithValue("score", gr.Score);
cmd.Parameters.AddWithValue("gameId", gr.Game.ItemID);
cmd.Parameters.AddWithValue("userId", userId);
cmd.ExecuteNonQuery();
}
connection.Close();
}
}
