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