public bool PostYourReview(TblTableReview tblTableReview) { if (tblTableReview != null) { db.Add(tblTableReview); db.SaveChanges(); return(true); } return(false); }
private bool SaveChanges() { try { _dbContext.SaveChanges(); return(true); } catch (Exception ex) { throw new Exception(ex.Message); } }
public IQueryable <TblRating> UpdateReviewRating(ReviewRating reviewRating) { try { if (dbContext != null) { var updateRecord = from rating in dbContext.TblRating where rating.TblRestaurantId == reviewRating.RestaurantID select rating; foreach (var items in updateRecord) { if (items.TblRestaurantId == reviewRating.RestaurantID && items.TblCustomerId == reviewRating.CustomerId) { items.Rating = reviewRating.Rating; items.Comments = reviewRating.ReviewComments; items.RecordTimeStampCreated = DateTime.Now; } } 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; } }
/// <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 bool EditResturantReview(RestaurantReview restaurantReview) { try { // RestaurantReview EditedResult = new RestaurantReview(); var Users = _connection.TblRating.Where(e => e.TblRestaurantId == restaurantReview.RestaurantId && e.TblCustomerId == restaurantReview.CustomerId).ToList(); // RestaurantReview editedUser = new RestaurantReview(); if (Users.Count == 0) { return(false); } else { List <TblRating> usertobeedited = _connection.TblRating.Where(x => x.Id == restaurantReview.Id).ToList(); usertobeedited.FirstOrDefault().Rating = (restaurantReview.Rating); usertobeedited.FirstOrDefault().RecordTimeStamp = usertobeedited.FirstOrDefault().RecordTimeStamp; usertobeedited.FirstOrDefault().RecordTimeStampCreated = usertobeedited.FirstOrDefault().RecordTimeStampCreated; usertobeedited.FirstOrDefault().Comments = restaurantReview.Comments; _connection.Update(usertobeedited.FirstOrDefault()); _connection.SaveChanges(); //editedUser = restaurantReview; } #region Comments //foreach (var User in Users) //{ // //if (Users.Count == 1) // //{ // if (User.Id == restaurantReview.Id) // { // _connection.Entry( // new TblRating // { // Rating = restaurantReview.Rating, // UserModified = restaurantReview.UserModified, // Comments = restaurantReview.Comments, // RecordTimeStamp=User.RecordTimeStamp, // RecordTimeStampCreated=User.RecordTimeStampCreated}).State = EntityState.Added; // this._connection.TblRating.Add(new TblRating // { // Rating = restaurantReview.Rating, // UserModified = restaurantReview.UserModified, // Comments = restaurantReview.Comments, // RecordTimeStamp = User.RecordTimeStamp, // RecordTimeStampCreated = User.RecordTimeStampCreated // }); // _connection.SaveChanges(); // // RestaurantReview editedUser = new RestaurantReview() // editedUser.Comments = restaurantReview.Comments; // editedUser.Id = restaurantReview.Id; // editedUser.Rating = restaurantReview.Rating; // editedUser.CustomerId = restaurantReview.CustomerId; // editedUser.UserCreated = restaurantReview.UserCreated; // editedUser.UserModified = restaurantReview.UserModified; // editedUser.RestaurantId = restaurantReview.RestaurantId ; // return editedUser; // } // //} // //else // //{ // // foreach(var MutliUser in Users) // // { // // if(MutliUser.Id==User.Id) // // { // // _connection.Entry(User).State = EntityState.Modified; // // _connection.SaveChanges(); // // RestaurantReview editedUser = new RestaurantReview() { Comments = User.Comments, Id = User.Id, Rating = User.Rating, CustomerId = User.TblCustomerId, UserCreated = User.UserCreated, UserModified = User.UserModified, RestaurantId = User.TblRestaurantId }; // // EditedResult.Add(editedUser); // // break; // // } // // } // //} //} #endregion return(true); //return EditedResult; } catch (Exception ex) { throw ex; } }