public MenuItemResponseModel changePrice(MenuItemRequestModel menuItemRequestModel, out ErrorModel errorModel) { errorModel = null; MenuItemResponseModel menuItemResponseModel = null; SqlConnection connection = null; try { using (connection = new SqlConnection(Database.getConnectionString())) { SqlCommand command = new SqlCommand(SqlCommands.SP_changePrice, connection); command.CommandType = System.Data.CommandType.StoredProcedure; #region Query Parameters command.Parameters.Add(new SqlParameter("@isDelete", System.Data.SqlDbType.Bit)); command.Parameters["@isDelete"].Value = menuItemRequestModel.isDelete; command.Parameters.Add(new SqlParameter("@itemId", System.Data.SqlDbType.Int)); command.Parameters["@itemId"].Value = menuItemRequestModel.itemId; command.Parameters.Add(new SqlParameter("@price", System.Data.SqlDbType.Decimal, 4)); command.Parameters["@price"].Value = menuItemRequestModel.price; command.Parameters.Add(new SqlParameter("@updatedBy", System.Data.SqlDbType.Int)); command.Parameters["@updatedBy"].Value = menuItemRequestModel.updatedBy; #endregion connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { if (reader.isColumnExists("ErrorCode")) { errorModel = new ErrorModel(); errorModel.ErrorCode = reader["ErrorCode"].ToString(); errorModel.ErrorMessage = reader["ErrorMessage"].ToString(); } else { menuItemResponseModel = new MenuItemResponseModel(); menuItemResponseModel.menuItemId = Convert.ToInt32(reader["menuItemId"].ToString()); menuItemResponseModel.menuItemName = reader["menuItemName"].ToString(); menuItemResponseModel.price = Convert.ToDouble(reader["price"].ToString()); } } command.Dispose(); connection.Close(); } return(menuItemResponseModel); } finally { if (connection != null) { connection.Close(); } } }
public async Task Edit(MenuItemRequestModel menuItem) { MenuItem menuItemEntity = await this.menuItemRepository.FindAsync(x => x.MenuItemId == menuItem.Id); menuItemEntity.Name = menuItem.Name; menuItemEntity.Price = menuItem.Price; await this.menuItemRepository.Update(menuItemEntity); }
public MenuItemResponseModel changePrice(MenuItemRequestModel menuItemRequest, out ErrorModel errorModel) { errorModel = null; try { Menu menuProvider = new Menu(); MenuItemResponseModel menuItemResponse = menuProvider.changePrice(menuItemRequest, out errorModel); return(menuItemResponse); } catch (Exception e) { return(null); } }
public HttpResponseMessage changePrice(MenuItemRequestModel menuItemRequestModel) { ErrorModel errorModel = new ErrorModel(); APIResponseModel responseModel = new APIResponseModel(); if (menuItemRequestModel != null) { MenuProvider menuProvider = new MenuProvider(); responseModel.Response = menuProvider.changePrice(menuItemRequestModel, out errorModel); responseModel.Error = errorModel; return(Request.CreateResponse(HttpStatusCode.OK, responseModel)); } responseModel.Error = ErrorCode.BadRequest; return(Request.CreateResponse(HttpStatusCode.OK, responseModel)); }
public async Task <IActionResult> Edit(MenuItemRequestModel menuItem) { await this.menuItemManager.Edit(menuItem); return(Ok()); }
public async Task Create(MenuItemRequestModel menuItem) { MenuItem menuItemEntity = this.mapper.Map <MenuItemRequestModel, MenuItem>(menuItem); await this.menuItemRepository.Create(menuItemEntity); }