internal void BuildConnectionString(Credentials credentials)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("Server={0}{1};", adminConnection, instance);
sb.AppendFormat("Database={0};", database);
if (null != credentials)
{
if (credentials.IsSqlAccount())
{
sb.AppendFormat("User ID={0};Password={1};", credentials.GetUsername(), credentials.GetPassword());
}
else
{
sb.Append("Integrated Security=SSPI;");
sb.AppendFormat("uid={0};pwd={1};", credentials.GetUsername(), credentials.GetPassword());
}
}
else
{
sb.Append("Integrated Security=SSPI;");
}
sb.AppendFormat("Connection Timeout={0};", connectionTimeout);
if (!string.IsNullOrEmpty(applicationName))
{
sb.Append(applicationName);
}
if (!string.IsNullOrEmpty(encryptString))
{
sb.Append(encryptString);
}
if (!string.IsNullOrEmpty(trustCertificate))
{
sb.Append(trustCertificate);
}
if (!string.IsNullOrEmpty(workstationId))
{
sb.Append(workstationId);
}
#if DEBUG
//Console.WriteLine("ConnectionString: {0}", sb.ToString());
#endif
connection = new SqlConnection
{
ConnectionString = sb.ToString()
};
sb.Clear();
GC.Collect();
}
internal bool Connect(Credentials credentials)
{
#if DEBUG
Console.WriteLine("Domain Controller : {0}", domainController);
#endif
string distinguishedName;
if (null != credentials)
{
try
{
directoryEntry = new DirectoryEntry(domainController, credentials.GetUsername(), credentials.GetPassword());
distinguishedName = (string)directoryEntry.Properties["distinguishedName"].Value;
if (!string.IsNullOrEmpty(ldapPath))
{
ldapPath = string.Format("/{0},{1}", ldapPath, distinguishedName);
directoryEntry = new DirectoryEntry(domainController + ldapPath, credentials.GetUsername(), credentials.GetPassword());
}
}
catch (Exception ex)
{
Console.WriteLine("{0} : {1}", domainController, ex.Message);
return(false);
}
}
else
{
try
{
directoryEntry = new DirectoryEntry(domainController);
distinguishedName = (string)directoryEntry.Properties["distinguishedName"].Value;
if (!string.IsNullOrEmpty(ldapPath))
{
ldapPath = string.Format("/{0},{1}", ldapPath, distinguishedName);
directoryEntry = new DirectoryEntry(domainController + ldapPath);
}
}
catch (Exception ex)
{
Console.WriteLine("{0} : {1}", domainController, ex.Message);
return(false);
}
}
#if DEBUG
Console.WriteLine("DistinguishedName : {0}", distinguishedName);
#endif
return(true);
}
