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