public IRestaurant[] GetRestaurantsByCity(string cityName) { IRestaurant[] restaurants = new IRestaurant[0]; try { using (var ctx = new RestaurantReviewContext()) { if (string.IsNullOrWhiteSpace(cityName)) { restaurants = ctx.Restaurants.ToArray(); } else { var restaurantList = ctx.Restaurants.Where(res => cityName.Equals(res.City, StringComparison.OrdinalIgnoreCase)); if (restaurantList != null) { restaurants = restaurantList.ToArray(); } } } } catch (Exception e) { } return(restaurants); }
public Result AddReview(IReview review) { Result result = new Result() { IsSuccessful = true }; try { using (var ctx = new RestaurantReviewContext()) { Review rev = review as Review; rev.ReviewID = Guid.NewGuid().ToString(); ctx.Reviews.Add(rev); ctx.SaveChanges(); } } catch (Exception e) { result.IsSuccessful = false; result.Message = e.Message; } return(result); }
public Result DeleteReview(string reviewID) { Result result = new Result() { IsSuccessful = true }; try { using (var ctx = new RestaurantReviewContext()) { Review rev = new Review(); rev.ReviewID = reviewID; ctx.Reviews.Attach(rev); ctx.Reviews.Remove(rev); ctx.SaveChanges(); } } catch (Exception e) { result.IsSuccessful = false; result.Message = e.Message; } return(result); }
public IReview[] GetReviewsByUser(string userName) { IReview[] reviews = new IReview[0]; if (string.IsNullOrWhiteSpace(userName)) { return(reviews); } try { using (var ctx = new RestaurantReviewContext()) { var reviewsList = ctx.Reviews.Where(rev => userName.Equals(rev.Reviewer, StringComparison.OrdinalIgnoreCase)); if (reviewsList != null) { reviews = reviewsList.ToArray(); } } } catch (Exception e) { } return(reviews); }