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