public HttpResponseMessage DeleteReview(int id)
{
try
{
using (var ctx = new RestaurantDBContext())
{
Users us = ctx.Users.SingleOrDefault(b => b.Id == id);
if (us == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "User with id =" + id.ToString() + "not found to delete"));
}
else
{
ctx.Users.Remove(us);
ctx.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex));
}
}
public ActionResult Index()
{
RestaurantDBContext db = new RestaurantDBContext();
db.Restaurants.ToList();
return(View());
}
/// <summary>
/// Method called by Controller to insert the order with the database structure, receiving only the client description of order.
/// </summary>
/// <param name="orderViewModel"></param>
/// <returns></returns>
public static bool InsertOrder(OrderViewModel orderViewModel)
{
try
{
var context = new RestaurantDBContext();
List <string> itemList = new List <string>();
List <int> numbers = new List <int>();
itemList = orderViewModel.OrderDescription.Split(",").ToList();
OrderObj order = GetOrderObj(itemList.FirstOrDefault().ToLower().Trim());
itemList.RemoveRange(0, 1);
numbers = ValidateOrder(itemList);
if (numbers != null && numbers.Count > 0)
{
OrderAccess.AddOrder(order);
return(InsertAllOrderItems(numbers));
}
return(false);
}
catch
{
return(false);
}
}
public HttpResponseMessage PostReview([FromBody] Users us)
{
try
{
if (ModelState.IsValid)
{
using (var ctx = new RestaurantDBContext())
{
ctx.Users.Add(us);
ctx.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, us);
message.Headers.Location = new Uri(Request.RequestUri + us.Id.ToString());
return(message);
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Invalid Model"));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage PostRestaurant([FromBody] Restaurant rest)
{
try
{
if (ModelState.IsValid)
{
using (var ctx = new RestaurantDBContext())
{
ctx.Restaurants.Add(new Restaurant()
{
RestaurantName = rest.RestaurantName,
City = rest.City
});
ctx.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, rest);
message.Headers.Location = new Uri(Request.RequestUri + rest.RestaurantName);
return(message);
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Invalid Model"));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex));
}
}
public static void AddOrder(OrderObj order)
{
try
{
using (var context = new RestaurantDBContext())
{
context.OrderObjs.Add(order);
context.SaveChanges();
}
}
catch
{
return;
}
}
public IEnumerable <Users> GetReviewsByUser([FromUri] string user)
{
IList <Users> us = null;
using (var ctx = new RestaurantDBContext())
{
us = ctx.Users.Where(e => e.UserName == user).ToList <Users>();
}
if (us == null)
{
var message = string.Format("Review for user = {0} not found", user);
throw new HttpResponseException(
Request.CreateErrorResponse(HttpStatusCode.NotFound, message));
}
return(us);
}
public IEnumerable <String> GetRestaurant()
{
IList <String> us = null;
using (var ctx = new RestaurantDBContext())
{
us = ctx.Restaurants.Select(m => m.City).Distinct().ToList <String>();
}
if (us == null)
{
var message = string.Format("City not found");
throw new HttpResponseException(
Request.CreateErrorResponse(HttpStatusCode.NotFound, message));
}
return(us);
}
public IEnumerable <Restaurant> GetRestaurantByCity([FromUri] string city)
{
IList <Restaurant> rest = null;
using (var ctx = new RestaurantDBContext())
{
rest = ctx.Restaurants.Where(e => e.City == city).ToList <Restaurant>();
}
if (rest == null)
{
var message = string.Format("Restaurant in city = {0} not found", city);
throw new HttpResponseException(
Request.CreateErrorResponse(HttpStatusCode.NotFound, message));
}
return(rest);
}
public UserRepository(RestaurantDBContext dBContext)
: base(dBContext)
{
}
public OrdersController(RestaurantDBContext context)
{
_context = context;
}
public DishRepository(RestaurantDBContext context)
{
this.db = context;
}
public CustomerController(RestaurantDBContext context)
{
_context = context;
}
public RestaurantInfo(RestaurantDBContext context)
{
this._context = context;
}
public Repository(RestaurantDBContext dBContext)
{
this._dBConn = dBContext;
this.dbSet = dBContext.Set <T>();
}
public Foods(RestaurantDBContext context)
{
this._context = context;
}
public Feedbacks(RestaurantDBContext context)
{
this._context = context;
}
public RestaurantCart(RestaurantDBContext _db)
{
this.db = _db;
}
public BookTable(RestaurantDBContext context)
{
this._context = context;
}
public EFUnitOfWork(RestaurantDBContext context)
{
this.db = context;
}
public RestaurantService(RestaurantDBContext restaurantDBContext)
{
_restaurantDBContext = restaurantDBContext;
}
public EFOrdersRepository(RestaurantDBContext c)
{
context = c;
}
public OrderRepository(RestaurantDBContext dBConn)
: base(dBConn)
{
}
public static List <OrderObj> GetOrderObjs()
{
var context = new RestaurantDBContext();
return(context.OrderObjs.ToList());
}
public MenuRepository(RestaurantDBContext dBConn)
: base(dBConn)
{
}
public Banners(RestaurantDBContext context)
{
this._context = context;
}
public ItemController(RestaurantDBContext context)
{
_context = context;
}
public IngredientRepository(RestaurantDBContext context)
{
this.db = context;
}
public EFDishesRepository(RestaurantDBContext c)
{
context = c;
}
public AccountController(RestaurantDBContext context)
{
restaurantService = context;
}
