public IEnumerable <User> GetAll() //retrieve from database { using (var db = new OurLunchDatabase()) { return(db.UserRepository.GetUsers()); } }
public IEnumerable <Order> GetAll() { using (var db = new OurLunchDatabase()) { return(db.OrderRepository.GetOrders()); } }
public IEnumerable <Meal> GetMealsForRestaurant(int id) { using (var db = new OurLunchDatabase()) { return(db.MealRepository.GetMealsByRestaurantId(id)); } }
public IEnumerable <Restaurant> GetRestaurants() { using (var db = new OurLunchDatabase()) { return(db.RestaurantRepository.GetRestaurants()); } }
public IActionResult GetOrderByTime(DateTime start, DateTime end) { List <Order> orders; using (var db = new OurLunchDatabase()) { orders = db.OrderRepository.GetOrdersByTime(start, end); } return(new ObjectResult(orders)); }
public IActionResult UpdateRestaurant(int id, [FromBody] Restaurant restaurant) { using (var db = new OurLunchDatabase()) { db.RestaurantRepository.UpdateRestaurant(restaurant); db.Save(); _socketHandler.SendToAll(new Notification { Path = "restaurants", Method = "put", Data = restaurant }); } return(new NoContentResult()); }
public IActionResult AddRestaurant([FromBody] Restaurant restaurant) { using (var db = new OurLunchDatabase()) { db.RestaurantRepository.AddRestaurant(restaurant); db.Save(); _socketHandler.SendToAll(new Notification { Path = "restaurants", Method = "post", Data = restaurant }); } return(new ObjectResult(restaurant.RestaurantId)); }
public IActionResult UpdateOrderItem(int id, [FromBody] OrderItem orderItem) { using (var db = new OurLunchDatabase()) { db.OrderItemRepository.UpdateOrderItem(orderItem); db.Save(); _socketHandler.SendToAll(new Notification { Path = "orderItems", Method = "put", Data = orderItem }); } return(new NoContentResult()); }
public IActionResult AddMeal([FromBody] Meal meal) { using (var db = new OurLunchDatabase()) { db.MealRepository.AddMeal(meal); db.Save(); _socketHandler.SendToAll(new Notification { Path = "meals", Method = "post", Data = meal }); } return(new ObjectResult(meal.MealId)); }
public IActionResult UpdateMeal(int id, [FromBody] Meal meal) { using (var db = new OurLunchDatabase()) { db.MealRepository.UpdateMeal(meal); db.Save(); _socketHandler.SendToAll(new Notification { Path = "meals", Method = "put", Data = meal }); } return(new NoContentResult()); }
public IActionResult UpdateUser(int id, [FromBody] User user) { using (var db = new OurLunchDatabase()) { db.UserRepository.UpdateUser(user); db.Save(); _socketHandler.SendToAll(new Notification { Path = "users", Method = "put", Data = user }); } return(new NoContentResult()); }
public IActionResult AddOrderItem([FromBody] OrderItem orderItem) { using (var db = new OurLunchDatabase()) { db.OrderItemRepository.AddOrderItem(orderItem); db.Save(); _socketHandler.SendToAll(new Notification { Path = "orderItems", Method = "post", Data = orderItem }); } return(new ObjectResult(orderItem.OrderItemId)); }
public IActionResult GetMealById(int id) { Meal meal; using (var db = new OurLunchDatabase()) { meal = db.MealRepository.GetMealById(id); } if (meal == null) { return(NotFound()); } return(new ObjectResult(meal)); }
public IActionResult GetByAlias(string aliasVar) { User user; using (var db = new OurLunchDatabase()) { user = db.UserRepository.GetUserByAlias(aliasVar); } if (user == null) { return(NotFound()); } return(new ObjectResult(user)); }
public IActionResult GetRestaurantById(int id) { Restaurant restaurant; using (var db = new OurLunchDatabase()) { restaurant = db.RestaurantRepository.GetRestaurantById(id); } if (restaurant == null) { return(NotFound()); } return(new ObjectResult(restaurant)); }
public IActionResult GetOrderItemsByOrderId(int orderId) { List <OrderItem> orderItems; using (var db = new OurLunchDatabase()) { orderItems = db.OrderItemRepository.GetOrderItemsByOrderId(orderId); } if (orderItems == null) { return(NotFound()); } return(new ObjectResult(orderItems)); }
public IActionResult GetOrderById(int id) { Order order; using (var db = new OurLunchDatabase()) { order = db.OrderRepository.GetOrderById(id); } if (order == null) { return(NotFound()); } return(new ObjectResult(order)); }
public IActionResult DeleteRestaurant(int id) { using (var db = new OurLunchDatabase()) { var restaurant = db.RestaurantRepository.GetRestaurantById(id); if (restaurant == null) { return(NotFound()); } db.RestaurantRepository.DeleteRestaurant(restaurant); db.Save(); _socketHandler.SendToAll(new Notification { Path = "restaurants", Method = "delete", Data = restaurant }); } return(new NoContentResult()); }
public IActionResult DeleteUser(int id) { using (var db = new OurLunchDatabase()) { var user = db.UserRepository.GetUserById(id); if (user == null) { return(NotFound()); } db.UserRepository.DeleteUser(user); db.Save(); _socketHandler.SendToAll(new Notification { Path = "users", Method = "delete", Data = user }); } return(new NoContentResult()); }
public IActionResult DeleteOrderItem(int id) { using (var db = new OurLunchDatabase()) { var orderItem = db.OrderItemRepository.GetOrderItemByOrderItemId(id); if (orderItem == null) { return(NotFound()); } db.OrderItemRepository.DeleteOrderItem(orderItem); db.Save(); _socketHandler.SendToAll(new Notification { Path = "orderItems", Method = "delete", Data = orderItem }); } return(new NoContentResult()); }
public IActionResult DeleteMeal(int id) { using (var db = new OurLunchDatabase()) { var meal = db.MealRepository.GetMealById(id); var restaurantId = meal.RestaurantId; if (meal == null) { return(NotFound()); } db.MealRepository.DeleteMeal(meal); db.Save(); _socketHandler.SendToAll(new Notification { Path = "meals", Method = "delete", Data = meal }); } return(new NoContentResult()); }
public IActionResult AddUser([FromBody] User user) { using (var db = new OurLunchDatabase()) { var existingUser = db.UserRepository.GetUserByAlias(user.Alias); if (existingUser != null) { return(BadRequest()); } db.UserRepository.AddUser(user); db.Save(); _socketHandler.SendToAll(new Notification { Path = "users", Method = "post", Data = user }); } return(new ObjectResult(user.UserId)); }