// Delete method:
        public static string DeleteProduct(ProductXML prod)
        {
            string msg   = string.Empty;
            string query = $"DELETE Products WHERE Id = {prod.Id}";

            using (conn = new SqlConnection(ConnectionString))
            {
                conn.Open();
                using (cmd = new SqlCommand(query, conn))
                {
                    cmd.Parameters.AddWithValue("@Title", prod.Title);
                    cmd.Parameters.AddWithValue("@Country", prod.Country);
                    cmd.Parameters.AddWithValue("@Price", prod.Price);

                    int result = cmd.ExecuteNonQuery();

                    if (result == 1)
                    {
                        msg = "Product was Delete successfully";
                    }
                    else
                    {
                        msg = "Product was NOT Delete.. Something went wrong...";
                    }
                }
            }

            return(msg);
        }
        // Add method:
        public static string AddProduct(ProductXML prod)
        {
            string msg   = string.Empty;
            string query = "INSERT INTO Products(Title, Country, Price) VALUES(@Title, @Country, @Price)";

            using (conn = new SqlConnection(ConnectionString))
            {
                conn.Open();
                using (cmd = new SqlCommand(query, conn))
                {
                    cmd.Parameters.AddWithValue("@Title", prod.Title);
                    cmd.Parameters.AddWithValue("@Country", prod.Country);
                    cmd.Parameters.AddWithValue("@Price", prod.Price);

                    int result = cmd.ExecuteNonQuery();

                    if (result == 1)
                    {
                        msg = "Product was added successfully";
                    }
                    else
                    {
                        msg = "Product was NOT added. Please try it again";
                    }
                }
            }

            return(msg);
        }