public int DeleteCurProduct(Product product)
        {
            MySqlConnection connection = DBConnection.Instance().Connection;

            try
            {
                connection.Open();
                byte[]       imageData = ProductConverter.ToBytesArray(product.BitmapImage);
                MySqlCommand command   = new MySqlCommand("delete_cur_product", connection);
                command.CommandType = System.Data.CommandType.StoredProcedure;
                command.Parameters.AddWithValue("@_idproduct", product.Id);
                command.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            connection.Close();
            return(1);
        }