public void GetReviewsandRatings()
{
var options = new DbContextOptionsBuilder <RestaurantManagementContext>()
.UseInMemoryDatabase(databaseName: "ReviewManagement")
.Options;
RestaurantManagementContext context = new RestaurantManagementContext(options);
TblRatingandReviews ratingandReviews = new TblRatingandReviews
{
Id = 1,
Rating = 5,
Reviews = "Amazing",
TblRestaurantId = 3
};
context.TblRatingandReviews.Add(ratingandReviews);
TblRestaurant tblRestaurant = new TblRestaurant
{
Id = 3,
Name = "Frotinar"
};
context.TblRestaurant.Add(tblRestaurant);
ReviewRepository reviewRepository = new ReviewRepository(context);
var restaurantratings = reviewRepository.GetRestaurantRating("Frotinar");
Assert.NotNull(restaurantratings);
}
public void PostReviewsandRatings()
{
TblRatingandReviews ratingandReviews = new TblRatingandReviews()
{
TblRestaurantId = 10,
TblCustomerId = 1,
Rating = 3,
Reviews = "It was awsome"
};
var options = new DbContextOptionsBuilder <RestaurantManagementContext>()
.UseInMemoryDatabase(databaseName: "ReviewManagement")
.Options;
ReviewRepository reviewRepository = new ReviewRepository(new RestaurantManagementContext(options));
bool isupdated = reviewRepository.PostRatingandReviews(ratingandReviews);
Assert.IsTrue(isupdated);
}
public bool PostRatingandReviews(TblRatingandReviews ratingandreviews)
{
try
{
if (ratingandreviews != null)
{
db.Set <TblRatingandReviews>().Add(ratingandreviews);
db.SaveChanges();
return(true);
}
return(false);
}
catch (Exception e)
{
throw e;
}
}
public bool UpdateRatingandReviews(TblRatingandReviews ratingandreviews)
{
TblRatingandReviews ratingandreviewentity = null;
//db.Set<TblRatingandReviews>().Where(tto => tto.Id == ratingandreviews.Id).FirstOrDefault();
if (ratingandreviews != null)
{
ratingandreviewentity = ratingandreviews;
ratingandreviews.UserCreated = ratingandreviews.TblCustomerId.HasValue ? ratingandreviews.TblCustomerId.Value : 1;
ratingandreviews.UserModified = ratingandreviews.TblCustomerId.HasValue ? ratingandreviews.TblCustomerId.Value : 1;
ratingandreviewentity.RecordTimeStamp = DateTime.Now;
db.TblRatingandReviews.Update(ratingandreviewentity);
db.SaveChanges();
return(true);
}
return(false);
}
public bool PostRatingandReviews(TblRatingandReviews ratingandreviews)
{
try
{
if (ratingandreviews != null)
{
ratingandreviews.UserCreated = ratingandreviews.TblCustomerId.HasValue ? ratingandreviews.TblCustomerId.Value : 1;
ratingandreviews.UserModified = ratingandreviews.TblCustomerId.HasValue ? ratingandreviews.TblCustomerId.Value : 1;
ratingandreviews.RecordTimeStamp = DateTime.Now;
db.Set <TblRatingandReviews>().Add(ratingandreviews);
db.SaveChanges();
return(true);
}
return(false);
}
catch (Exception e)
{
throw e;
}
}
public bool PostRatingandReviews(RatingandReviewDetails ratingEntity)
{
try
{
TblRatingandReviews tblRatingandReviews;
if (ratingEntity != null)
{
tblRatingandReviews = new TblRatingandReviews();
tblRatingandReviews.TblRestaurantId = ratingEntity.TblRestaurantId;
tblRatingandReviews.TblCustomerId = ratingEntity.TblCustomerId;
tblRatingandReviews.Rating = ratingEntity.Rating;
tblRatingandReviews.Reviews = ratingEntity.Reviews;
tblRatingandReviews.RecordTimeStampCreated = DateTime.Now;
return(review_Repository.PostRatingandReviews(tblRatingandReviews));
}
return(false);
}
catch (Exception e)
{
throw e;
}
}
public bool UpdateRatingandReviews(TblRatingandReviews ratingandreviews)
{
try
{
var ratingandReviews = db.TblRatingandReviews.FirstOrDefault(s => s.Id.Equals(ratingandreviews.Id));
if (ratingandReviews != null && ratingandReviews.Id > 0)
{
ratingandReviews.Rating = ratingandreviews.Rating;
ratingandReviews.Reviews = ratingandreviews.Reviews;
ratingandReviews.RecordTimeStamp = DateTime.Now;
ratingandReviews.UserCreated = ratingandreviews.TblCustomerId.HasValue ? ratingandreviews.TblCustomerId.Value : 1;
ratingandReviews.UserModified = ratingandreviews.TblCustomerId.HasValue ? ratingandreviews.TblCustomerId.Value : 1;
db.SaveChanges();
return(true);
}
return(false);
}
catch (Exception ex)
{
throw ex;
}
}
