public static Driver GetDriver(DomainUrl domainUrl)
{
switch(domainUrl.Protocol)
{
case "msaccess":
return new Access.AccessDriver(domainUrl);
case "mssql":
return new MSSql.MSSqlDriver(domainUrl);
case "mysql":
return new MySql.MySqlDriver(domainUrl);
default:
return null;
}
}
public static DomainBuilder GetDomainBuilder(DomainUrl domainUrl)
{
switch(domainUrl.Protocol)
{
case "msaccess":
return new OleDb.OleDbDomainBuilder(DriverFactory.GetDriver(domainUrl));
case "mssql":
return null;
case "mysql":
return new MySql.MySqlDomainBuilder(DriverFactory.GetDriver(domainUrl));
default:
return null;
}
}
public Project ConnectToDatabase(string name, string url)
{
Project project = GetProject() as Project;
if (project != null)
{
DomainUrl domainUrl = new DomainUrl(url);
DomainBuilder builder = DomainBuilderFactory.GetDomainBuilder(domainUrl);
DataDomain dataDomain = builder.BuildDomain();
dataDomain.Name = name;
project.AddDataDomain(dataDomain);
return(project);
}
return(null);
}
public static void SendRequesttoServer(List <string> DomainURLs)
{
string strResponseValue = string.Empty;
foreach (var DomainUrl in DomainURLs)
{
var baseUri = DomainUrl.ToString();
if (!string.IsNullOrEmpty(baseUri))
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(baseUri);
request.Method = "GET"; // DELETE\POST\GET...
// request.Proxy = WebRequest.DefaultWebProxy; // set proxy , this method will use default windows client proxy value
// WebProxy proxyObject = new WebProxy("http://pproxyserverURL:80"); // this is another method whee allow you manual set proxy server value
// request.Proxy = proxyObject; // this is another method whee allow you manual set proxy server value
try
{
using (HttpWebResponse resposne = (HttpWebResponse)request.GetResponse())
{
if (resposne.StatusCode != HttpStatusCode.OK)
{
throw new ApplicationException("error code " + resposne.ToString());
}
else
{
//process the response stream , can be JSON , XML , HTML...
using (Stream responsestream = resposne.GetResponseStream())
{
if (responsestream != null)
{
using (StreamReader reader = new StreamReader(responsestream))
{
// REST return result was store here
strResponseValue = reader.ReadToEnd();
} // end of stream reader
}
} //End of using reponse stream
Console.WriteLine("Url: " + resposne.ResponseUri.AbsoluteUri + " " + resposne.StatusCode);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message.ToString());
}
}
}
}
public static DomainBuilder GetDomainBuilder(DomainUrl domainUrl)
{
switch (domainUrl.Protocol)
{
case "msaccess":
return(new OleDb.OleDbDomainBuilder(DriverFactory.GetDriver(domainUrl)));
case "mssql":
return(null);
case "mysql":
return(new MySql.MySqlDomainBuilder(DriverFactory.GetDriver(domainUrl)));
default:
return(null);
}
}
public static Driver GetDriver(DomainUrl domainUrl)
{
switch (domainUrl.Protocol)
{
case "msaccess":
return(new Access.AccessDriver(domainUrl));
case "mssql":
return(new MSSql.MSSqlDriver(domainUrl));
case "mysql":
return(new MySql.MySqlDriver(domainUrl));
default:
return(null);
}
}
public static void SendRequesttoServer(List <string> DomainURLs)
{
string strResponseValue = string.Empty;
foreach (var DomainUrl in DomainURLs)
{
var baseUri = DomainUrl.ToString();
if (!string.IsNullOrEmpty(baseUri))
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(baseUri);
request.Method = "GET"; // DELETE\POST\GET...
try
{
using (HttpWebResponse resposne = (HttpWebResponse)request.GetResponse())
{
if (resposne.StatusCode != HttpStatusCode.OK)
{
throw new ApplicationException("error code " + resposne.ToString());
}
else
{
//process the response stream , can be JSON , XML , HTML...
using (Stream responsestream = resposne.GetResponseStream())
{
if (responsestream != null)
{
using (StreamReader reader = new StreamReader(responsestream))
{
// REST return result was store here
strResponseValue = reader.ReadToEnd();
} // end of stream reader
}
} //End of using reponse stream
Console.WriteLine("Url: " + resposne.ResponseUri.AbsoluteUri + " " + resposne.StatusCode);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message.ToString());
}
}
}
}
public object SubmitQuery(string url, string sql)
{
Hashtable result = new Hashtable();
try
{
DomainUrl domainUrl = new DomainUrl(url);
Driver driver = DriverFactory.GetDriver(domainUrl);
using (IDbConnection dbConnection = driver.OpenConnection())
{
IDbCommand command = driver.GetDbCommand(sql, dbConnection);
IDbDataAdapter adapter = driver.GetDbDataAdapter();
adapter.SelectCommand = command;
DataSet dataSet = new DataSet();
adapter.Fill(dataSet);
ASObject asoResult = new ASObject();
DataTable dataTable = dataSet.Tables[0];
ArrayList rows = new ArrayList(dataTable.Rows.Count);
for (int i = 0; i < dataTable.Rows.Count; i++)
{
DataRow dataRow = dataTable.Rows[i];
ASObject asoRow = new ASObject();
for (int j = 0; j < dataTable.Columns.Count; j++)
{
DataColumn column = dataTable.Columns[j];
asoRow.Add(column.ColumnName, dataRow[column]);
}
rows.Add(asoRow);
}
result["result"] = rows;
}
}
catch (Exception ex)
{
result["message"] = ex.Message;
}
return(result);
}
public DataDomain(DomainUrl domainUrl) : base(domainUrl.Host)
{
_domainUrl = domainUrl;
_tables = new Table[0];
}
public DataDomain(string url) : base(url)
{
_domainUrl = new DomainUrl(url);
_tables = new Table[0];
}
public Driver(DomainUrl url)
{
_url = url;
}
public DataDomain(DomainUrl domainUrl) : base(domainUrl.Host)
{
_domainUrl = domainUrl;
_tables = new Table[0];
}
public MSSqlDriver(DomainUrl domainUrl) : base(domainUrl)
{
}
public Driver(DomainUrl url)
{
_url = url;
}
public AccessDriver(DomainUrl domainUrl) : base(domainUrl)
{
}
public AccessDriver(DomainUrl domainUrl) : base(domainUrl)
{
}
public MSSqlDriver(DomainUrl domainUrl) : base(domainUrl)
{
}
public DataDomain(string url) : base(url)
{
_domainUrl = new DomainUrl(url);
_tables = new Table[0];
}
