Creating Servers

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Net;
using System.Security.Cryptography.X509Certificates;
using System.IO;
using System.Xml;

namespace SQLAzureDatabaseManagement
{
    class Program
    {

        static void Main(string[] args)
        {
            string certFile;
            string certPassword;
            string subscriptionId;
            string AdminAcct;
            string AdminPwd;
            string Location;

            if (args.Length != 6)
            {
                Console.WriteLine("\nInsufficient Arguments.\n\nExpected CertfilePath, CertfilePassword, SubscriptionID, Admin, AdminPassword, and Location.\n");
                return;
            }
            else
            {
                certFile = args[0];
                certPassword = args[1];
                subscriptionId = args[2];
                AdminAcct = args[3];
                AdminPwd = args[4];
                Location = args[5];
            }


            //=========================================================================//
            //=== Execute SQL Database Server and Firewall Rules Management Operations ===//
            //=========================================================================//

            // Create a new server 
            CreateServer(certFile, certPassword, subscriptionId, AdminAcct, AdminPwd, Location);
        }


        //===============================================================================================================//
        //===                                                                                                         ===//
        //=== CreateServer                                                                                            ===//
        //===                                                                                                         ===//
        //=== This function should create a new SQL Database server under the specified subscription, and return the new ===//
        //=== server's name as output written to the console.                                                         ===//
        //===                                                                                                         ===//
        //=== Input Parameters:                                                                                       ===//
        //===                                                                                                         ===//
        //===   string certFilename : Full path to the Personal Information Exchange (.pfx) file which holds the      ===//
        //===                         private key for the certificate. The public key file must already be associated ===//
        //===                         to the subscription.                                                            ===//
        //===                                                                                                         ===//
        //===   string certPassword : The password of the Personal Information Exchange (.pfx) file referenced by     ===//
        //===                         certFilename.                                                                   ===//
        //===                                                                                                         ===//
        //===   string subscriptionId : This is the subscription id GUID in its string form.                          ===//
        //===                                                                                                         ===//
        //===   string Admin : The Administrator account for the new server.                                          ===//
        //===                                                                                                         ===//
        //===   string AdminPwd : This is the Administrator password for the new server which is associated with the  ===//
        //===                     Administrator account (Admin).                                                      ===//
        //===                                                                                                         ===//
        //===   string Location : This location string should match a valid location for the Location element in the  ===//
        //===                     Server.xsd schema (http://schemas.microsoft.com/sqlazure/2010/12/ Server.xsd).      ===//
        //===                                                                                                         ===//
        //=== Output:                                                                                                 ===//
        //===                                                                                                         ===//
        //===   The output of this function is written to the console. The output includes:                           ===//
        //===                                                                                                         ===//
        //===     The subscription id passed to this function.                                                        ===//
        //===                                                                                                         ===//
        //===     The request body built using the parameters passed to this function.                                ===//
        //===                                                                                                         ===//
        //===     The x-ms-request-id header returned from the REST API call.                                         ===//
        //===                                                                                                         ===//
        //===     The HTTP Status code returned from the REST API call.                                               ===//
        //===                                                                                                         ===//
        //===     The "ServerName" element returned from the response body of the REST API call or the exception      ===//
        //===     and error encountered during the REST API call.                                                     ===//
        //===                                                                                                         ===//
        //===============================================================================================================//

        static void CreateServer(string certFilename, string certPassword, string subscriptionId, string Admin, string AdminPwd, string Location)
        {
            Console.WriteLine("\n============================");
            Console.WriteLine("=== CreateServer Request ===");
            Console.WriteLine("============================\n");
            Console.WriteLine("Subscription : {0} \n", subscriptionId);

            try
            {
                string url = string.Format("https://management.database.windows.net:8443/{0}/servers", subscriptionId);
                HttpWebRequest webRequest = HttpWebRequest.Create(url) as HttpWebRequest;

                webRequest.ClientCertificates.Add(new X509Certificate2(certFilename, certPassword));
                webRequest.Headers["x-ms-version"] = "1.0";
                webRequest.Method = "POST";

                //=== Add the Request Payload ===//

                string xmlBody = "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n" +
                                  "<Server xmlns=\"http://schemas.microsoft.com/sqlazure/2010/12/\">\n" +
                                  "  <AdministratorLogin>" + Admin.ToString() + "</AdministratorLogin>\n" +
                                  "  <AdministratorLoginPassword>" + AdminPwd.ToString() + "</AdministratorLoginPassword>\n" +
                                  "  <Location>" + Location.ToString() + "</Location>\n" +
                                  "</Server>";


                Console.WriteLine("Request Body for the CreateServer Request : ...\n");
                Console.WriteLine(xmlBody);

                byte[] bytes = Encoding.UTF8.GetBytes(xmlBody);
                webRequest.ContentLength = bytes.Length;
                webRequest.ContentType = "application/xml;charset=utf-8";
                using (Stream requestStream = webRequest.GetRequestStream())
                {
                    requestStream.Write(bytes, 0, bytes.Length);
                }


                //=== Send the request and wait on the response ===//

                using (WebResponse webResponse = webRequest.GetResponse())
                {

                    //=== x-ms-request-id is useful for troubleshooting request failures with Microsoft ===//
                    Console.WriteLine("\nResponse x-ms-request-id : {0}", webResponse.Headers["x-ms-request-id"]);

                    Console.WriteLine("HttpStatusCode = {0}\n", (int)((HttpWebResponse)webResponse).StatusCode);

                    using (Stream stream = webResponse.GetResponseStream())
                    {
                        using (XmlTextReader xmlReader = new XmlTextReader(stream))
                        {
                            while (xmlReader.Read())
                            {
                                switch (xmlReader.NodeType)
                                {
                                    case XmlNodeType.Element:
                                        if (xmlReader.Name == "ServerName")
                                        {
                                            if (xmlReader.Read() && (xmlReader.NodeType == XmlNodeType.Text))
                                            {
                                                Console.WriteLine("NewServerName : {0}\n", xmlReader.Value.ToString());
                                            }
                                        }
                                        break;
                                }
                            }
                        }
                    }
                }
            }


            //====================================================================================//
            //=== Catch WebExceptions. The SQL Database Management Service will          ===//
            //=== provide detailed error information in the response stream for WebExceptions. ===//
            //====================================================================================//

            catch (WebException webEx)
            {

                Console.WriteLine("WebException : \n\n" + webEx.ToString());

                try
                {
                    HttpWebResponse errorResponse = (HttpWebResponse)webEx.Response;
                    Console.WriteLine(string.Format("HttpStatusCode = {0}", (int)errorResponse.StatusCode));

                    using (Stream errorResponseStream = errorResponse.GetResponseStream())
                    {
                        using (StreamReader sr = new StreamReader(errorResponseStream))
                        {
                            Console.WriteLine(sr.ReadToEnd());
                        }
                    }
                }
                catch (Exception innerEx)
                {
                    Console.WriteLine(innerEx.ToString());
                    Console.WriteLine(innerEx.StackTrace.ToString());
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString() + "\n");
                Console.WriteLine(ex.StackTrace.ToString() + "\n");
                if (ex.InnerException != null)
                {
                    Console.WriteLine(ex.InnerException.ToString() + "\n");
                    Console.WriteLine(ex.InnerException.StackTrace.ToString() + "\n");
                }
            }
        }

    }
}