public void Reviews_AddReviewToBook_UserAndBookExist() { // Arrange var repo = new ReviewsRepository(context); int bookId = (context.Books.OrderByDescending(b => b.Id).FirstOrDefault()).Id; var newUser = new User { Name = "Gux", Address = "Rvk", Email = "*****@*****.**", PhoneNumber = "699-6666", Deleted = false }; context.Users.Add(newUser); context.SaveChanges(); int userId = newUser.Id; // Act repo.AddReviewToBook(newUser.Id, bookId, new ReviewView { ReviewText = "Such wow", Stars = 4 }); // Assert Assert.AreEqual(2, context.Reviews.Count()); Assert.AreEqual("Such wow", context.Reviews.Where(b => b.ReviewText == "Such wow").SingleOrDefault().ReviewText); Assert.AreEqual(4, context.Reviews.Where(b => b.Stars == 4).SingleOrDefault().Stars); }
public JsonResult ReservationReviewStatusDelete(int ID) { string Msg = ""; string request = "false"; try { ReviewsRepository modelRepo = new ReviewsRepository(); // FirmRequestExt model = new FirmRequestExt(); if (modelRepo.deleteReviewStatus(ID,this) == false) { return this.Json(new DataSourceResult { Errors = Msg }); } request = "true"; } catch (Exception ex) { string hostName1 = Dns.GetHostName(); string GetUserIPAddress = Dns.GetHostByName(hostName1).AddressList[0].ToString(); string PageName = Convert.ToString(Session["PageName"]); //string GetUserIPAddress = GetUserIPAddress1(); using (BaseRepository baseRepo = new BaseRepository()) { //BizContext BizContext1 = new BizContext(); BizApplication.AddError(baseRepo.BizDB, PageName, ex.Message, ex.StackTrace, DateTime.Now, GetUserIPAddress); } Session["PageName"] = ""; string error = ErrorHandling.HandleException(ex); return this.Json(new DataSourceResult { Errors = error }); } return Json(request); }
public ReviewController(string filePath) { IContext <JsonReviews> context = new JsonFile(filePath); IRepository <ReviewModel> reviews = new ReviewsRepository(context); this.factory = new ReviewsFactory(reviews); }
public void Reviews_UpdateUsersBookRewiew_ReviewDoesNotExist() { // Arrange var repo = new ReviewsRepository(context); int bookId = (context.Books.OrderByDescending(b => b.Id).FirstOrDefault()).Id; int userId = (context.Users.OrderByDescending(b => b.Id).FirstOrDefault()).Id; var newUser = new User { Name = "Gux", Address = "Rvk", Email = "*****@*****.**", PhoneNumber = "699-6666", Deleted = false }; context.Users.Add(newUser); context.SaveChanges(); // Act repo.UpdateBooksUserReview(bookId, newUser.Id, new ReviewView { ReviewText = "Such wow", Stars = 4 }); // Assert Assert.Fail("Should have thrown NotFoundException"); }
public ReviewController() { string filePath = Path.Combine(HttpRuntime.AppDomainAppPath, "./reviews.json"); IRepository <ReviewModel> reviews = new ReviewsRepository(new JsonFile(filePath)); this.factory = new ReviewsFactory(reviews); }
public UnitOfWork(AppDbContext dbContext) { _dbContext = dbContext; Admins = new AdminsRepository(_dbContext); Albums = new AlbumsRepository(_dbContext); Messages = new MessagesRepository(_dbContext); Photos = new PhotosRepository(_dbContext); Sellers = new SellersRepository(_dbContext); Users = new UsersRepository(_dbContext); Reviews = new ReviewsRepository(_dbContext); }
public void Reviews_GetAllBookReviews_OneReview() { // Arrange var repo = new ReviewsRepository(context); // Act var reviews = repo.GetAllBookReviews(); // Assert Assert.AreEqual(1, reviews.Count()); Assert.AreEqual(5, reviews.Where(b => b.ReviewText == "I really liked it").SingleOrDefault().Stars); }
public void Reviews_GetAllReviewsForBook_BookDoesNotExist() { // Arrange var repo = new ReviewsRepository(context); int bookId = (context.Books.OrderByDescending(b => b.Id).FirstOrDefault()).Id; // Act var reviews = repo.GetAllReviewsForBook(bookId + 1); // Assert Assert.Fail("Should have thrown NotFoundException"); }
public void Reviews_DeleteUsersBookReview_UserAndBookAndReviewExist() { // Arrange var repo = new ReviewsRepository(context); int bookId = (context.Books.OrderByDescending(b => b.Id).FirstOrDefault()).Id; int userId = (context.Users.OrderByDescending(b => b.Id).FirstOrDefault()).Id; // Act repo.DeleteUsersBookReview(userId, bookId); // Assert Assert.AreEqual(0, context.Reviews.Count()); }
public void Reviews_DeleteUsersBookReview_BookDoesNotExist() { // Arrange var repo = new ReviewsRepository(context); int bookId = (context.Books.OrderByDescending(b => b.Id).FirstOrDefault()).Id; int userId = (context.Users.OrderByDescending(b => b.Id).FirstOrDefault()).Id; // Act repo.DeleteUsersBookReview(userId, bookId + 1); // Assert Assert.Fail("Should have thrown NotFoundException"); }
public void Reviews_GetBookReviewFromUser_UserDoesNotExist() { // Arrange var repo = new ReviewsRepository(context); int bookId = (context.Books.OrderByDescending(b => b.Id).FirstOrDefault()).Id; int userId = (context.Users.OrderByDescending(b => b.Id).FirstOrDefault()).Id; // Act var review = repo.GetBookReviewFromUser(userId + 1, bookId); // Assert Assert.Fail("Should have thrown NotFoundException"); }
public void Reviews_GetAllReviewsForBook_BookExists() { // Arrange var repo = new ReviewsRepository(context); int bookId = (context.Books.OrderByDescending(b => b.Id).FirstOrDefault()).Id; // Act var reviews = repo.GetAllReviewsForBook(bookId); // Assert Assert.AreEqual(1, reviews.Count()); Assert.AreEqual("I really liked it", reviews.ElementAt(0).ReviewText); Assert.AreEqual(5, reviews.ElementAt(0).Stars); }
public BlogGType(ReviewsRepository repo, IDataLoaderContextAccessor dataLoaderContextAccessor) { Field(t => t.BlogId); Field(t => t.Description); Field(t => t.Content); Field(t => t.Title); Field <BlogTypeEnum>("type"); Field <ListGraphType <ReviewsType> >("reviews", resolve: ctx => { var dataLoader = dataLoaderContextAccessor.Context.GetOrAddCollectionBatchLoader <int, Review>("GetReviewsByBlogId", repo.GetAllBlogIds); return(dataLoader.LoadAsync(ctx.Source.BlogId)); }); }
public void Reviews_UpdateUsersBookRewiew_BookDoesNotExist() { // Arrange var repo = new ReviewsRepository(context); int bookId = (context.Books.OrderByDescending(b => b.Id).FirstOrDefault()).Id; int userId = (context.Users.OrderByDescending(b => b.Id).FirstOrDefault()).Id; // Act repo.UpdateBooksUserReview(bookId + 1, userId, new ReviewView { ReviewText = "Such wow", Stars = 4 }); // Assert Assert.Fail("Should have thrown NotFoundException"); }
public void Reviews_GetBookReviewFromUser_BookAndUserExist() { // Arrange var repo = new ReviewsRepository(context); int bookId = (context.Books.OrderByDescending(b => b.Id).FirstOrDefault()).Id; int userId = (context.Users.OrderByDescending(b => b.Id).FirstOrDefault()).Id; // Act var review = repo.GetBookReviewFromUser(userId, bookId); // Assert Assert.AreEqual(1, context.Reviews.Count()); Assert.AreEqual("I really liked it", review.ReviewText); Assert.AreEqual(5, review.Stars); Assert.AreEqual(userId, review.UserId); Assert.AreEqual(bookId, review.BookId); }
public void Reviews_UpdateUsersBookRewiew_UserAndBookAndReviewExist() { // Arrange var repo = new ReviewsRepository(context); int bookId = (context.Books.OrderByDescending(b => b.Id).FirstOrDefault()).Id; int userId = (context.Users.OrderByDescending(b => b.Id).FirstOrDefault()).Id; // Act repo.UpdateBooksUserReview(bookId, userId, new ReviewView { ReviewText = "Such wow", Stars = 4 }); // Assert Assert.AreEqual(1, context.Reviews.Count()); Assert.AreEqual("Such wow", context.Reviews.Where(b => b.ReviewText == "Such wow").SingleOrDefault().ReviewText); Assert.AreEqual(4, context.Reviews.Where(b => b.Stars == 4).SingleOrDefault().Stars); }
public void Post([FromBody] JToken value) { var a = value.ToString(); CityReview review = new CityReview(); review.ReviewCategory = (string)value["ReviewCategory"]; review.ReviewItemID = (int)value["reviewItemID"]; review.ReviewRating = (string)value["reviewRating"]; review.ReviewText = (string)value["reviewText"]; ReviewsRepository repo = new ReviewsRepository(_logger); repo.addReview(review); _logger.LogInformation("Value added"); }
static void Main(string[] args) { ResterauntFunctions rest = new ResterauntFunctions(); ReviewFunctions rev = new ReviewFunctions(); Resteraunt resteraunt = new Resteraunt() { Name = "Bobs Burgers", City = "Ft. Lauderdale" }; // ResterauntCrudOps.AddResteraunt(resteraunt); ReviewsRepository revi = new ReviewsRepository(); // revi.TableToXml(); UserInputHandler.UserCommandOptions(); Console.ReadLine(); }
public void Reviews_GetBookReviewFromUser_ReviewDoesNotExist() { // Arrange var repo = new ReviewsRepository(context); int bookId = (context.Books.OrderByDescending(b => b.Id).FirstOrDefault()).Id; int userId = (context.Users.OrderByDescending(b => b.Id).FirstOrDefault()).Id; var newUser = new User { Name = "Gux", Address = "Rvk", Email = "*****@*****.**", PhoneNumber = "699-6666", Deleted = false }; context.Users.Add(newUser); // Act var review = repo.GetBookReviewFromUser(newUser.Id, bookId); // Assert Assert.Fail("Should have thrown NotFoundException"); }
public ReviewsService(ReviewsRepository repo, ProductsRepository prodRepo) { _repo = repo; _prodRepo = prodRepo; }
public IEnumerable <CityReview> Get() { ReviewsRepository repo = new ReviewsRepository(_logger); return(repo.returnReviews("Events").ToList()); }
public ReviewService() { reviewsRepository = new ReviewsRepository(); }
public ReviewsService(ReviewsRepository repo) { _repo = repo; }
public ReviewsService(ReviewsRepository repo, ContractorsRepository conRepo) { _repo = repo; _conRepo = conRepo; }
public ReviewsService(IOptions <DatabaseSettings> databaseSettings, IMapper mapper) : base(mapper) { _reviewsRepository = new ReviewsRepository(databaseSettings.Value.ConnectionString); }
public ReviewsService() { _bookRepo = new BookRepository(); _reviewRepo = new ReviewsRepository(); //DATAACCESS }
public ActionResult _Read([DataSourceRequest]DataSourceRequest request) { ReviewsRepository modelRepo = new ReviewsRepository(); DataSourceResult result = modelRepo.GetReservationReviews().ToDataSourceResult(request); return Json(result); }