// 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);
}
}
