Beispiel #1
0
        private void updateToDatabase(int id, string name, double price, string url_image)
        {
            connection.Open();
            string query = "UPDATE menus " +
                           "SET name=@name," +
                           "price=@price," +
                           "img_url=@url_image " +
                           "WHERE id=@id";

            try
            {
                SqlCommand command = new SqlCommand(query, connection);

                ImageServices imageService = new ImageServices(url_image);
                imageService.storeImage();

                savedImageFileName = imageService.createdFileName;

                command.Parameters.AddWithValue("@id", id);
                command.Parameters.AddWithValue("@name", name);
                command.Parameters.AddWithValue("@price", price);
                command.Parameters.AddWithValue("@url_image", Path.GetFileName(savedImageFileName));

                command.ExecuteReader();
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            finally
            {
                connection.Close();
            }
        }
Beispiel #2
0
        public void handleCreate(string name, double price, string url_image)
        {
            try
            {
                bool validator = validateInput(name, price, url_image);

                if (validator)
                {
                    ImageServices imageService = new ImageServices(url_image);
                    imageService.storeImage();

                    savedImageFileName = imageService.createdFileName;

                    createToDatabase(name, price, savedImageFileName);
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }