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