public JsonResult Put(RestaurantsOrderItems restaurantsOrderItem)
{
if (restaurantsOrderItem != null)
{
return(Json(new RestaurantsOrderItemsRepository().UpdateRestaurantsOrderItem(restaurantsOrderItem)));
}
return(Json(null));
}
public IActionResult Update(RestaurantsOrderItems restaurantsOrderItem)
{
if (restaurantsOrderItem != null && restaurantsOrderItem.RESTAURANTS_ID != Guid.Empty)
{
return(Json(new RestaurantsOrderItemsRepository().UpdateRestaurantsOrderItem(restaurantsOrderItem)));
}
return(Json(null));
}
public IActionResult Delete(RestaurantsOrderItems restaurantsOrderItem)
{
if (restaurantsOrderItem != null && restaurantsOrderItem.ID != Guid.Empty)
{
return(Json(new RestaurantsOrderItemsRepository().DeleteOrderItem(restaurantsOrderItem.ID)));
}
return(Json(null));
}
public RestaurantsOrderItems GetOrderItem(Guid id)
{
RestaurantsOrderItems orderItem = new RestaurantsOrderItems();
orderItem = _db.Query <RestaurantsOrderItems>("SELECT * FROM RESTAURANTS_ORDER_ITEMS WHERE ID = @ID", new RestaurantsOrderItems()
{
ID = id
}).SingleOrDefault();
return(orderItem);
}
public JsonResult Post(RestaurantsOrderItems restaurantsOrderItem)
{
var added = new RestaurantsOrderItemsRepository().AddRestaurantsOrderItem(restaurantsOrderItem);
if (added)
{
return(Json(new RestaurantsOrderItemsRepository().GetOrderItem(restaurantsOrderItem.ID)));
}
return(Json(null));
}
public bool UpdateRestaurantsOrderItem(RestaurantsOrderItems restaurantsOrderItem)
{
if (restaurantsOrderItem != null)
{
int count = _db.Execute("UPDATE RESTAURANTS_ORDER_ITEMS SET RESTAURANTS_ID=@RESTAURANTS_ID, NAME=@NAME, PORTION=@PORTION, DESCRIPTION=@DESCRIPTION, IMAGE=@IMAGE, PRICEWHERE=@PRICEWHERE WHERE ID = @ID", restaurantsOrderItem);
if (count == 1)
{
return(true);
}
}
return(false);
}
public bool AddRestaurantsOrderItem(RestaurantsOrderItems restaurantsOrderItem)
{
if (restaurantsOrderItem != null && restaurantsOrderItem.RESTAURANTS_ID != Guid.Empty)
{
if (restaurantsOrderItem.ID == Guid.Empty)
{
restaurantsOrderItem.ID = Guid.NewGuid();
}
_db.Query <RestaurantsOrderItems>("INSERT INTO RESTAURANTS_ORDER_ITEMS(ID, RESTAURANTS_ID, NAME, PORTION, DESCRIPTION, IMAGE, PRICE) VALUES(@ID, @RESTAURANTS_ID, @NAME, @PORTION, @DESCRIPTION, @IMAGE, @PRICE)", restaurantsOrderItem).SingleOrDefault();
return(true);
}
return(false);
}
