Database Manager - AddDatabase

Version: 7C

HC7 Build: 7.00.0012 and later

API Build: 1.00.0001 and later

Database Manager - AddDatabase  adds database under a specified website. This web service call can be made as http://your-domain.com/HC7API/DatabaseManager.asmx?op=AddDatabase.

Input Parameters

• HostUserName

• HostPassword

• OwnerName - user name for whom you want to add database

• DatabaseName - name of the database you want to add

• DatabaseType - MS-SQL Server / MySQL

• DatabaseLogin - login name of the database

• DatabasePassword

• DatabaseInstance

• WebsiteName - name of the website under which you want to add database

• OptionalParam

• Language
   

Output Parameters

         N/A

Sample Optional Parameters

<Parameters>

<Parameter Name = "Language">French</Parameter>

</Parameters>

Sample SOAP Request

POST /HC7API/DatabaseManager.asmx HTTP/1.1

Host: your-domain.com

Content-Type: text/xml; charset=utf-8

Content-Length: length

SOAPAction: "http://tempuri.org/AddDatabase"

<?xml version="1.0" encoding="utf-8"?>

<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

  <soap:Body>

    <AddDatabase xmlns="http://tempuri.org/">

      <HostUserName>host</HostUserName>

      <HostPassword>host123</HostPassword>

      <OwnerName>david</OwnerName>

      <DatabaseName>MyDatabase</DatabaseName>

      <DatabaseType>MySQL</DatabaseType>

      <DatabaseLogin>Mydb</DatabaseLogin>

      <DatabasePassword>Mydb123</DatabasePassword>

      <DatabaseInstance>localhost</DatabaseInstance>

      <WebsiteName>MyDomain.com</WebsiteName>

      <OptionalParam>xml</OptionalParam>

    </AddDatabase>

  </soap:Body>

</soap:Envelope>

Sample HTTP Request

POST /HC7API/DatabaseManager.asmx/AddDatabase HTTP/1.1

Host: your-domain.com

Content-Type: application/x-www-form-urlencoded

Content-Length: length

HostUserName=host&HostPassword=host123&OwnerName=david&DatabaseName=MyDatabase

&DatabaseType=MySQL&DatabaseLogin=Mydb&DatabasePassword=Mydb123&

DatabaseInstance=localhost&WebsiteName=MyDomain.com&OptionalParam=xml

Sample C# Code

public DatabaseManager.Response AddDatabase(string strHostUserName, string strHostPassword, string strOwnerName, string strDatabaseName, string strDatabaseType, string srtDatabaseLogin, string strDatabasePassword, string strDatabaseInstance, string strWebsiteName)

{

         try

         {

                    DatabaseManager.DatabaseManager oDatabase = new DatabaseManager.DatabaseManager();

                    DatabaseManager.Response oResponse = new DatabaseManager.Response();

                    oResponse = oDatabase.AddDatabase(strHostUserName, strHostPassword, strOwnerName,

                    strDatabaseName, strDatabaseType, srtDatabaseLogin, strDatabasePassword,

                    strDatabaseInstance, strWebsiteName, null);  

         }

         catch

         {

         }

         return oResponse;

}

Sample Response

<Response>

    <Method>AddDatabase</Method>

    <Status>true</Status>

    <ErrorCode>73100011</ErrorCode>

    <ErrorDescription>Database created successfully.</ErrorDescription>           

    <Result/>

</Response>