// method to get reviews public static List <Review> ShowRestaurantReviews(string _sRestaurant) { List <Review> lsReviews = new List <Review>(); try { RestaurantReviewP0Entities db = new RestaurantReviewP0Entities(); lsReviews = db.Restaurants.ToList().SingleOrDefault(x => x.rName == _sRestaurant).Reviews.ToList(); } catch (InvalidOperationException ioe) { Console.WriteLine("Exception handled:\n" + ioe.Message); Console.WriteLine("Stack Trace:\n" + ioe.StackTrace); } catch (SystemException se) { Console.WriteLine("Exception handled:\n" + se.Message); Console.WriteLine("Stack Trace:\n" + se.StackTrace); } catch (Exception e) { Console.WriteLine("Exception handled:\n" + e.Message); Console.WriteLine("Stack Trace:\n" + e.StackTrace); } return(lsReviews); }
// method to get restaurants public static List <Restaurant> ShowAllRestaurants() { List <Restaurant> lsLocalList = new List <Restaurant>(); try { RestaurantReviewP0Entities db = new RestaurantReviewP0Entities(); lsLocalList = db.Restaurants.ToList(); } catch (InvalidOperationException ioe) { Console.WriteLine("Exception handled:\n" + ioe.Message); Console.WriteLine("Stack Trace:\n" + ioe.StackTrace); } catch (SystemException se) { Console.WriteLine("Exception handled:\n" + se.Message); Console.WriteLine("Stack Trace:\n" + se.StackTrace); } catch (Exception e) { Console.WriteLine("Exception handled:\n" + e.Message); Console.WriteLine("Stack Trace:\n" + e.StackTrace); } return(lsLocalList); }
public static void InsertReviewIntoDB(string sRName, string sRvAddress, decimal dRvRating, string sRvSummary, int iForeignKey) { try { RestaurantReviewP0Entities db; using (db = new RestaurantReviewP0Entities()) { Review review = new Review() { rName = sRName, rAddress = sRvAddress, rRating = dRvRating, rSummary = sRvSummary, fk_rId = iForeignKey }; db.Reviews.Add(review); db.SaveChanges(); } } catch (DbUpdateException se) { Debug.WriteLine("Exception handled:\n" + se.Message); Debug.WriteLine("Stack Trace:\n" + se.StackTrace); Debug.WriteLine(se.InnerException.Message); Debug.WriteLine(se.InnerException); } catch (SqlException se) { Console.WriteLine("Exception handled:\n" + se.Message); Console.WriteLine("Stack Trace:\n" + se.StackTrace); } catch (DbException de) { Console.WriteLine("Exception handled:\n" + de.Message); Console.WriteLine("Stack Trace:\n" + de.StackTrace); } catch (ExternalException ee) { Console.WriteLine("Exception handled:\n" + ee.Message); Console.WriteLine("Stack Trace:\n" + ee.StackTrace); } catch (SystemException syse) { Console.WriteLine("Exception handled:\n" + syse.Message); Console.WriteLine("Stack Trace:\n" + syse.StackTrace); } catch (Exception e) { Console.WriteLine("Exception handled:\n" + e.Message); Console.WriteLine("Stack Trace:\n" + e.StackTrace); } }
// method to insert record into database public static int InsertRestaurantIntoDB(string sRName, string sRAddress, decimal dAvgRating) { RestaurantDataLayer.Restaurant restaurant = new RestaurantDataLayer.Restaurant() { rName = sRName, rAddress = sRAddress, rAvgRating = dAvgRating }; try { RestaurantReviewP0Entities db; using (db = new RestaurantReviewP0Entities()) { db.Restaurants.Add(restaurant); db.SaveChanges(); } } catch (DbUpdateException se) { Debug.WriteLine("Exception handled:\n" + se.Message); Debug.WriteLine("Stack Trace:\n" + se.StackTrace); Debug.WriteLine(se.InnerException.Message); Debug.WriteLine(se.InnerException); } catch (SqlException se) { Debug.WriteLine("Exception handled:\n" + se.Message); Debug.WriteLine("Stack Trace:\n" + se.StackTrace); } catch (DbException de) { Debug.WriteLine("Exception handled:\n" + de.Message); Debug.WriteLine("Stack Trace:\n" + de.StackTrace); } catch (ExternalException ee) { Console.WriteLine("Exception handled:\n" + ee.Message); Console.WriteLine("Stack Trace:\n" + ee.StackTrace); } catch (SystemException syse) { Console.WriteLine("Exception handled:\n" + syse.Message); Console.WriteLine("Stack Trace:\n" + syse.StackTrace); } catch (Exception e) { Debug.WriteLine("Exception handled:\n" + e.Message); Debug.WriteLine("Stack Trace:\n" + e.StackTrace); } return(restaurant.rId); }
// method to delete record into database public static void DeleteRestaurantFromDB(string sRestaurantInput) { try { RestaurantReviewP0Entities db; using (db = new RestaurantReviewP0Entities()) { Restaurant restaurant = db.Restaurants.SingleOrDefault(x => x.rName == sRestaurantInput); db.Restaurants.Attach(restaurant); db.Entry(restaurant).State = EntityState.Deleted; db.Restaurants.Remove(restaurant); db.SaveChanges(); } } catch (DbUpdateConcurrencyException duce) { Console.WriteLine("Exception handled:\n" + duce.Message); Console.WriteLine("Stack Trace:\n" + duce.StackTrace); } catch (SqlException se) { Console.WriteLine("Exception handled:\n" + se.Message); Console.WriteLine("Stack Trace:\n" + se.StackTrace); } catch (DbException de) { Console.WriteLine("Exception handled:\n" + de.Message); Console.WriteLine("Stack Trace:\n" + de.StackTrace); } catch (ExternalException ee) { Console.WriteLine("Exception handled:\n" + ee.Message); Console.WriteLine("Stack Trace:\n" + ee.StackTrace); } catch (SystemException syse) { Console.WriteLine("Exception handled:\n" + syse.Message); Console.WriteLine("Stack Trace:\n" + syse.StackTrace); } catch (Exception e) { Console.WriteLine("Exception handled:\n" + e.Message); Console.WriteLine("Stack Trace:\n" + e.StackTrace); } }
public static void DeleteReviewFromDB(string sRName, string sRSummary) { try { RestaurantReviewP0Entities db = new RestaurantReviewP0Entities(); Review review = db.Reviews.SingleOrDefault(x => x.rName == sRName); db.Reviews.Attach(review); db.Entry(review).State = EntityState.Deleted; db.Reviews.Remove(review); db.SaveChanges(); } catch (SqlException se) { Console.WriteLine("Exception handled:\n" + se.Message); Console.WriteLine("Stack Trace:\n" + se.StackTrace); } catch (DbException de) { Console.WriteLine("Exception handled:\n" + de.Message); Console.WriteLine("Stack Trace:\n" + de.StackTrace); } catch (ExternalException ee) { Console.WriteLine("Exception handled:\n" + ee.Message); Console.WriteLine("Stack Trace:\n" + ee.StackTrace); } catch (SystemException syse) { Console.WriteLine("Exception handled:\n" + syse.Message); Console.WriteLine("Stack Trace:\n" + syse.StackTrace); } catch (Exception e) { Console.WriteLine("Exception handled:\n" + e.Message); Console.WriteLine("Stack Trace:\n" + e.StackTrace); } }