/// <summary>
/// Recording the customer rating the restaurants
/// </summary>
/// <param name="tblRating"></param>
public void RestaurantRating(TblRating tblRating)
{
tblRating.RecordTimeStampCreated = DateTime.Now;
db.Set <TblRating>().Add(tblRating);
db.SaveChanges();
}
public bool UpdateRestaurantRating(int ratingId, RestaurantRating restaurantRating)
{
try
{
if (!DoesRatingForRestaurantExists(restaurantRating.RestaurantId, ratingId))
{
throw new Exception($"Rating doesn't exist for the Restaurant {restaurantRating.RestaurantId}! " +
$"Try creating the same rating using HttpPost method.");
}
TblRating tblRating = new TblRating()
{
Id = ratingId,
TblRestaurantId = restaurantRating.RestaurantId,
Rating = restaurantRating.rating,
Comments = restaurantRating.user_Comments,
RecordTimeStampCreated = DateTime.Now.AddDays(-1),
RecordTimeStampUpdated = DateTime.Now
};
_dbContext.Update(tblRating);
return(SaveChanges());
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public bool UpdateRestaurantRating(int ID, TblRating tblRating)
{
try
{
var rating = db.TblRating.Find(ID);
if (rating != null)
{
rating.Rating = tblRating.Rating;
rating.Comments = tblRating.Comments;
rating.TblCustomerId = tblRating.TblCustomerId;
rating.UserModified = tblRating.UserModified;
rating.RecordTimeStamp = DateTime.Now;
db.Set <TblRating>().Update(rating);
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
//throw ex;
return(false);
}
}
public async Task <ActionResult <TblRating> > PostTblRating(TblRating tblRating)
{
_context.TblRating.Add(tblRating);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetTblRating", new { id = tblRating.RatingId }, tblRating));
}
public async Task <IActionResult> PutTblRating(int id, TblRating tblRating)
{
if (id != tblRating.RatingId)
{
return(BadRequest());
}
_context.Entry(tblRating).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TblRatingExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public void Update_Test_submit_review()
{
TblRating reviewdetails = new TblRating()
{
TblCustomerId = 1,
Rating = 5,
TblRestaurantId = 1,
Comments = "Good"
};
var options = new DbContextOptionsBuilder <ReviewManagementContext>()
.UseInMemoryDatabase(databaseName: "Reviewmanagement")
.Options;
ReviewRepository addreview = new ReviewRepository(new ReviewManagementContext(options));
int reviewid = addreview.RestaurantRating(reviewdetails);
TblRating updatedreviewdetails = new TblRating()
{
TblCustomerId = 1,
Rating = 5,
TblRestaurantId = 1,
Comments = "Excellent"
};
ReviewRepository Updatereview = new ReviewRepository(new ReviewManagementContext(options));
int updatedreviewid = Updatereview.RestaurantRating(updatedreviewdetails);
Assert.AreNotSame(reviewdetails, updatedreviewdetails);
Assert.AreEqual(reviewid, updatedreviewid);
}
public ActionResult FeedBack(TblRating tbl)
{
string userid = Request.Form["hdnuserid"].ToString();
tbl.UserId = userid;
int std = trepositery.Addrating(tbl);
if (std > 0)
{
ViewBag.Status = "FeedBack Submited Sucessfully";
}
ViewBag.stations = trepositery.getStations();
return(View());
}
/// <summary>
/// Recording the customer rating the restaurants
/// </summary>
/// <param name=""></param>
public void RestaurantRating(RestaurantRating restaurantRating)
{
if (restaurantRating != null)
{
TblRating rating = new TblRating()
{
Rating = restaurantRating.rating,
TblRestaurantId = restaurantRating.RestaurantId,
Comments = restaurantRating.user_Comments,
TblCustomerId = restaurantRating.customerId
};
search_Repository.RestaurantRating(rating);
}
}
public bool UpdateRestaurantRating(int ID, RestaurantRating restaurantRating)
{
if (restaurantRating != null)
{
TblRating rating = new TblRating()
{
Rating = restaurantRating.rating,
Comments = restaurantRating.user_Comments,
TblCustomerId = restaurantRating.customerId,
UserModified = restaurantRating.customerId
};
return(review_Repository.UpdateRestaurantRating(ID, rating));
}
return(false);
}
/// <summary>
/// Recording the customer rating the restaurants
/// </summary>
/// <param name="restaurantRating"></param>
public int RestaurantRating(RestaurantRating restaurantRating)
{
if (restaurantRating != null)
{
TblRating rating = new TblRating()
{
Rating = restaurantRating.rating,
TblRestaurantId = restaurantRating.RestaurantId,
Comments = restaurantRating.user_Comments,
TblCustomerId = restaurantRating.customerId
};
return(review_Repository.RestaurantRating(rating));
}
return(0);
}
/// <summary>
/// Recording the customer rating the restaurants
/// </summary>
/// <param name="tblRating"></param>
public bool RestaurantRating(TblRating tblRating)
{
try
{
tblRating.RecordTimeStamp = DateTime.Now;
tblRating.RecordTimeStampCreated = DateTime.Now;
db.Set <TblRating>().Add(tblRating);
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
//throw ex;
return(false);
}
}
/// <summary>
/// Recording the customer rating the restaurants
/// </summary>
/// <param name=""></param>
public bool RestaurantRating(RestaurantRating restaurantRating)
{
if (restaurantRating != null)
{
TblRating rating = new TblRating()
{
Rating = restaurantRating.rating,
TblRestaurantId = restaurantRating.RestaurantId,
Comments = restaurantRating.user_Comments,
TblCustomerId = restaurantRating.customerId,
UserCreated = restaurantRating.customerId,
UserModified = restaurantRating.customerId
};
return(review_Repository.RestaurantRating(rating));
}
return(false);
}
public void Test_submit_review()
{
TblRating reviewdetails = new TblRating()
{
TblCustomerId = 1,
Rating = 5,
TblRestaurantId = 1,
Comments = "Good"
};
var options = new DbContextOptionsBuilder <ReviewManagementContext>()
.UseInMemoryDatabase(databaseName: "Reviewmanagement")
.Options;
ReviewRepository addreview = new ReviewRepository(new ReviewManagementContext(options));
int reviewid = addreview.RestaurantRating(reviewdetails);
Assert.Greater(reviewid, 0);
}
/// <summary>
/// Recording the customer rating the restaurants
/// </summary>
/// <param name="tblRating"></param>
public int RestaurantRating(TblRating tblRating)
{
TblRating tr = db.TblRating.Where(r => r.TblRestaurantId == tblRating.TblRestaurantId && r.TblCustomerId == tblRating.TblCustomerId).FirstOrDefault();
if (tr != null)
{
tr.Comments = tblRating.Comments;
tr.Rating = tblRating.Rating;
tr.RecordTimeStamp = DateTime.Now;
tr.RecordTimeStampCreated = DateTime.Now;
tr.TblCustomerId = tblRating.TblCustomerId;
tr.TblRestaurantId = tblRating.TblRestaurantId;
db.SaveChanges();
return(tr.Id);
}
else
{
db.Set <TblRating>().Add(tblRating);
db.SaveChanges();
return(tblRating.Id);
}
}
public void GetRatingsbyCustomerID()
{
TblRating reviewdetails = new TblRating()
{
TblCustomerId = 1,
Rating = 5,
TblRestaurantId = 1,
Comments = "Good"
};
var options = new DbContextOptionsBuilder <ReviewManagementContext>()
.UseInMemoryDatabase(databaseName: "Reviewmanagement")
.Options;
ReviewRepository addreview = new ReviewRepository(new ReviewManagementContext(options));
int reviewid = addreview.RestaurantRating(reviewdetails);
ReviewRepository getreview = new ReviewRepository(new ReviewManagementContext(options));
IQueryable <TblRating> getrating = getreview.GetRestaurantRatingByCustomer(1);
Assert.AreEqual(1, getrating.Count());
}
public IQueryable <TblRating> RestaurantReviewRating(ReviewRating reviewRating)
{
try
{
if (dbContext != null)
{
TblRating tblRating = new TblRating
{
Rating = reviewRating.Rating,
Comments = reviewRating.ReviewComments,
TblRestaurantId = reviewRating.RestaurantID,
TblCustomerId = reviewRating.CustomerId,
RecordTimeStamp = DateTime.Now,
RecordTimeStampCreated = DateTime.Now
};
dbContext.Set <TblRating>().Add(tblRating);
dbContext.SaveChanges();
return((from rating in dbContext.TblRating
join restaurant in dbContext.TblRestaurant on
rating.TblRestaurantId equals restaurant.Id
where rating.TblRestaurantId == reviewRating.RestaurantID && rating.TblCustomerId == reviewRating.CustomerId
select new TblRating
{
Rating = rating.Rating,
Comments = rating.Comments,
TblRestaurantId = restaurant.Id,
TblRestaurant = restaurant,
TblCustomerId = rating.TblCustomerId
}).AsQueryable());
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public bool AddRestaurantRating(RestaurantRating restaurantRating, out RestaurantRating returnedRestaurantRating)
{
try
{
if (!DoesRestaurantExists(restaurantRating.RestaurantId))
{
throw new Exception("Restaurant doesn't exist! Try sending a valid Restaurant Id");
}
TblRating tblRating = new TblRating()
{
Id = restaurantRating.RatingId,
TblRestaurantId = restaurantRating.RestaurantId,
Rating = restaurantRating.rating,
Comments = restaurantRating.user_Comments,
RecordTimeStampCreated = DateTime.Now,
RecordTimeStampUpdated = DateTime.Now
};
_dbContext.Add(tblRating);
SaveChanges();
returnedRestaurantRating = new RestaurantRating()
{
RatingId = tblRating.Id,
RestaurantId = tblRating.TblRestaurantId,
rating = tblRating.Rating,
user_Comments = tblRating.Comments
};
return(true);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public int Addrating(TblRating rating)
{
db.TblRatings.Add(rating);
return(db.SaveChanges());
}